Subtotal: $17,583.00
Currently when validating a field using SQL, the only validation option is to specify a not equal to a value, where the value has to be specified. It would be nice to have option where the sql query does not return a result or even better, have the ability to use a live form token.
I am trying to check the database to see if a form value has already been entered to prevent duplicates. So I am querying the fieldvalue column in the db to see if the entered value is already in the table.
For others that may want a work around to check for duplicates, here is what you can do:
Create a hidden form field and create an On Form View action to populate the new field using sql.
Create a validation to compare the 2 fields. If they are equal, display message.