How to use Confiforms Field Definition Rules with Validation rule (dataset)

[Michael Confessore]

I have a Confiform TableView that is populated with data and I’m looking to run a check to prevent a new record from being added to the table if a field in the record matches one already in the table. I believe that the “Validation rule (dataset)” option on the Confiforms Field Definition Rules is the right approach, but when I set the condition:

myField:[entry.myField]

the condition is always true and the record is never allowed to be added. What is the proper syntax for the comparison of the new record’s field value to existing field values in the table?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

This is a correct way to check, but you need to check for count also

In the condition parameter you will need to put the following expression

myField:[entry.myField] AND _count:>1

Alex 

[Michael Confessore]

Worked perfectly, thank you!