DATA VALIDATION: Boolean Fields
kylesouza
Posts: 138 ✭✭
I want "False" values in a Boolean field to be flagged.
I'm calculating the field value with this expression:
If(ROUNDED_PRICE=Math.Round(PRICELIST_VALUE,2), "TRUE", "FALSE")
It is calculating correctly.
I am trying to validate the field with these settings:
But the falses aren't turning pink.
NOTE: Originally I was using Yes/No, but I switched everything to TRUE/FALSE to try to get it to work.
I'm calculating the field value with this expression:
If(ROUNDED_PRICE=Math.Round(PRICELIST_VALUE,2), "TRUE", "FALSE")
It is calculating correctly.
I am trying to validate the field with these settings:
But the falses aren't turning pink.
NOTE: Originally I was using Yes/No, but I switched everything to TRUE/FALSE to try to get it to work.
Kyle Souza
Data Wizard
P&P Oil & Gas Solutions
Data Wizard
P&P Oil & Gas Solutions
Tagged:
0
Best Answer
-
kylesouza
Posts: 138 ✭✭
Figured it out, i needed to change the Validate Expression to PRICE_MATCHES_="TRUE"Kyle Souza
Data Wizard
P&P Oil & Gas Solutions0
Moderators
GrooperGuru
RandoCalrisian
jongoesboom