Grooper 21.00.0082 is available as of 12-12-2023! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.00.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0018 is available as of 04-15-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Options
DATA VALIDATION: Boolean Fields
kylesouza
Posts: 156 ✭✭✭
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
-
Optionskylesouza Posts: 156 ✭✭✭Figured it out, i needed to change the Validate Expression to PRICE_MATCHES_="TRUE"Kyle Souza
Data Wizard
P&P Oil & Gas Solutions0