Ensuring columns have unique composite values

[bespokeappstt]

I have two columns, serial number and model number. What can I do to ensure that every row of information is unique for the list? I want to ensure there are no duplicate serial and matching model numbers. Two serial numbers might be the same but they would have different model numbers and vice versa. I guess in traditional database concept this would be a composite primary key. But I'm not using it as a foreign key, just want to ensure users don't enter dups for equipment data.

 

[troester]

Validation "AreUniqueValues"

 

[bespokeappstt]

I'm not seeing 'AreUniqueValues' and it's not just one element but the combined value of two elements I would like to be unique?

 

[bespokeappstt]

Okay it's a plugin. I'll check it out.

 

[troester]

Additional plugins are in Fabrik downloads (or to "Discover" if you are running a GitHub version).
Or use php validation to validate yourself.

 

[bespokeappstt]

Works like a charm. The wiki has only one optional value but the downloaded plugin has 2. This is great.
[solved]