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?
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.
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |