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

kylesouzakylesouza Posts: 156 ✭✭✭
in The Astronauts (Q&A)
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.
Kyle Souza
Data Wizard
P&P Oil & Gas Solutions
Tagged:

Best Answer

  • Options
    kylesouzakylesouza Posts: 156 ✭✭✭
    Answer ✓
    Figured it out, i needed to change the Validate Expression to  PRICE_MATCHES_="TRUE"
    Kyle Souza
    Data Wizard
    P&P Oil & Gas Solutions
Sign In or Register to comment.