Discussions

Expand all | Collapse all

Automate Checkbox Field

  • 1.  Automate Checkbox Field

    Posted 08-14-2018 16:12
    I am trying to place a check in checkbox field [Tests Scheduled] when 3 of 3 date fields have been populated: [MRI date], [CT date] and [Endo date]. I have tried actions and automations. I don't want form rules because these dates are entered in grid edit mode. I think a checkbox formula field will work, but I 'm not sure how to write the formula. Help please!  I don't have any training in formulas, I have looked at numerous posts for possible answers without finding an answer. 


  • 2.  RE: Automate Checkbox Field

     
    Posted 08-14-2018 16:23
    The formula for the [Tests Scheduled] formula checkbox field should look something like:

    If(
    IsNull([MRI date]) OR IsNull([CT date]) OR IsNull([Endo date]),
    false,
    true
    )

    Should return 'false' (unchecked) if any of the dates are null; 'true' otherwise.

    See if that works.

    Thanks,

    ~Rob


  • 3.  RE: Automate Checkbox Field

    Posted 08-14-2018 17:24

    Thank you, it works!  So simple too!