Expression Builder - Calculations and Check Box fields

The following expression, used in a calculated field, will stamp that field with the current date and user ID whenever the check box field 'contact2.checkfield' is marked. It will also remove the stamp when the check box is unmarked. Because of the iif() statement, the field will not be changed whenever the record is edited, only when the check box is marked or unmarked:

iif(contact2.checkfield and empty
(contact2.charfield),dtoc(date())+' '+
cuserid,iif(!contact2.checkfield and !empty
(contact2.charfield),space(14),contact2.charfield))

The field 'contact2.charfield' used in this example is a character field with a length of 14. The field needs to be long enough to contain whatever will be automatically placed in it by the calculation, and the number (14) in the last line of the expression must match the actual length of the field.

 

-- End of FAQ #25

FAQ ID #25

Product Related: TeleMagic 4.x

Last Updated: March 19, 2000