Hi. I have a form using tabs for maintenance...

Hi. I have a form using

tabs for maintenance checking. What is the right expression to use to trigger an email if any of the True/False fields in the form are False instead of just saying [Compressor] = False for example?

0 4 469
4 REPLIES 4

wrap all the individual column checks in an OR() function.

OR( [Compressor] = False,[Fuel Level] = False,[Battery] = False )

Or, if you store the values as 0โ€™s and 1โ€™s, then you could use

SUM( [Compressor],[Fuel Level],[Battery])=0

Thank you Joseph

You need to generate a list before the summing likeโ€ฆ SUM(LIST([Compressor],[Fuel Level],[Battery]))=0

Great, thank you.

Top Labels in this Space