Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
7 years ago

how to make the records in the report unique

how to make the records in the report unique. Need to add a unique key which is a combination of all columns
  • 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.
  • MeredithMoore5's avatar
    MeredithMoore5
    Qrew Assistant Captain
    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.