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!

Checkbox Fields

Posted by: Keith Hipkin

Date: May 02, 2008 05:55PM

I would like to create a formula that check all boxes when one box is checked but would like this to happen when any box is checked. eg.

If checkbox 1 is checked it also checks checkbox 2 and checkbox 3. If checkbox 3 is unchecked then checkbox 1 & checkbox 2 are also unchecked and so on.

does anyone know what formula I should use.

Many Thanks

Checkboxes

Posted by: Keith

Date: May 06, 2008 10:11AM

Just thought I would post a little more info regarding the problem I am having in the hope that someone might be able to help.

Here is the code I am using:

codes.JPG

I pasted this into notepad to make it easier but if you cannot read it, see below:

User11

CASE
WHEN [User12] = "true" THEN "true"
WHEN [User13] = "true" THEN "true"
ELSE
"false"
END


User12

CASE
WHEN [User11] = "true" THEN "true"
WHEN [User13] = "true" THEN "true"
ELSE
"false"
END


User13

CASE
WHEN [User11] = "true" THEN "true"
WHEN [User12] = "true" THEN "true"
ELSE
"false"
END

When I check any of the boxes the tick applies to all boxes. So far, so good but

When I uncheck a box the problems start:

Uncheck11.JPG

Uncheck13.JPG

I keep trying different code but gradually get in a mess.

If there are any clever people out there who might be able to help I would love to hear from you.

Regards

A complete novice.

Re: Checkboxes

Posted by: Admin

Date: May 08, 2008 01:04AM

Please try the following formula :

User11

IF [User12] = "true" AND [User13] = "true"
THEN
"true"
ELSE
"false"
END

and so on for User12, User13

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.