Skip to main content
Question

how to make the records in the report unique

  • August 20, 2018
  • 0 replies
  • 21 views

how to make the records in the report unique. Need to add a unique key which is a combination of all columns
This topic has been closed for replies.

You can make a formula field which concatenate several fields together and then flag that is being unique.

It is a field property.

However certain types of fields may not be used in a formula which is designated as unique. For example if you were using a look up field in your formula then it won�t let you make that field unique.

Forum|alt.badge.img+7
  • Quickbase Alumni
  • January 22, 2019
I have a cipher code I built if you are interested. It takes strings of text (and numbers) and turns it into a 15 digit number. Not 100,000% guaranteed but works pretty well.