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

expressions
(PDM Business Support) #1

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?

(GreenFluxLLC) #2

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

(PDM Business Support) #3

Thank you Joseph

(Aleksi Alkio) #4

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

(PDM Business Support) #5

Great, thank you.