Unique Records Check

[ChrisCarlson]

I would like to add the following functionality to a datapage text field. When the user types in a value, I would like to check the database to make sure the value does not previously exist in any records. If the value exists I would like it to cause an error message and not allow the user to submit the record. Any recommendations on how I could achieve this?

[ScottDube]

If you make it a unique value in the table won't if give you an error message?

[iren]

Hello ccarls,

 

You can check the ‘Unique’ option in Table Design to enforce the uniqueness of values entered in the field meaning that no two records can have the same value for the field.

 

Hope it helps.

[NailDyanC]

Hi, just to add to the previous comments above, you may use a calculated field/calculated value to check if the value/record is already existed in the table using this formula:

CASE WHEN (SELECT COUNT(FIELDNAME) FROM TABLE WHERE CODE=target.[@field:CODE) > 1 THEN 'EXISTING' ELSE 'NOT EXISTING' END
 

And, you may create now a JavaScript code that will display an error based on the result of the calculation.  I hope this helps.