how to make the records in the report unique

  • 0
  • 1
  • Question
  • Updated 1 day 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 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,702 Points 50k badge 2x thumb
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

  • 422 Points 250 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.