Unique data table entries, not just unique fields
Add an option to force Unique data table entries, not just unique fields.
For example,
These two entries can not be added
Remote Diagnostics, USA, New Jersey, and Toms River
Remote Diagnostics, USA, New Jersey, and Toms River
But These two entries can be added,
Remote Diagnostics, USA, New Jersey, and Toms River
Remote Diagnostics, USA, Georgia, and Toms River
11
votes
Adam
shared this idea
This can be achieved with unique attribute in Formula Field. More information can be found at https://howto.caspio.com/tables-and-views/data-types/formula-fields/
-
Ali
commented
Its been solved on release 9.8
Formula Field Enhancements to Support Composite Keys