ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

ActPresentation.com


Add-ons for Sage ACT! CRM

ACT! addons by ActPresentation.com : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!

Conditional calculation based on check-box ( YesNo field )

Posted by: Admin

Date: May 20, 2007 07:36AM

Hi!
Some people ask how to perform conditional calculations depending on check-box state ( YesNo field )
Here is formula example :

IF
( [check_box_field] = 1 )
THEN

/* put here formula if check-box is checked */
ELSE

/* put here formula if check-box is not checked */
END


Comments : if [check_box_field] is checked - its value is 1, if not checked - its value is 0

Re: Conditional calculation based on check-box ( YesNo field )

Posted by: pbb

Date: August 23, 2007 01:19PM

In Act 2008, Yes/No is either "True" or "False".

If you test for 0 or 1 to do conditional calculations, it does not work.

This code works for the field "test":
IF( [check_box] = "True" ) THEN
"True"
ELSE
"False"
END

This code does not work:
IF( [check_box] = 1 ) THEN
"True"
ELSE
"False"
END

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.