how to make the records in the report unique

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
how to make the records in the report unique. Need to add a unique key which is a combination of all columns
Photo of Pushpakumar Gnanadurai

Posted 11 months ago

  • 0
  • 1
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.
Photo of QuickBase Girl

QuickBase Girl

  • 638 Points 500 badge 2x thumb
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.