How to make a record unique

Question

I have a table with multiple columns in it. Each column may have repeated values but each record (a row) must not be repeated. Is there any way to make this possible ?

------------------------------
Aswin Babu
------------------------------

markshnier__you · Answer

np,just make a formula which will concatenate the fields together and mark it as Unique in field properties.List("-", [field 1], [Field 2], [field 3])note that you make not use lookup or summary fields in that formula.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

aswinbabu · Answer

Thats the challenge. I will have to use the look up fields , is there any other way to achieve this------------------------------Aswin Babu------------------------------

markshnier__you · Answer

np,you may not use a lookup field, but you may use the reference field.so for exampleToText([Related Parent])&nbsp;would be valid to use in the string.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

aswinbabu · Answer

Okay. Let me try this then. Thank you Mark-- RegardsAswin Babu

Forum Discussion

How to make a record unique

Related Content

Show unique parent records for current user

Custom Record Titles

Formula Help to Make Field Unique

Search for Multiple/Many Unique Asset IDs in text Field.

Problems constructing Headers in pipelines 'make request' channel