Discussions

Expand all | Collapse all

how to make the records in the report unique

  • 1.  how to make the records in the report unique

    Posted 08-20-2018 10:47
    how to make the records in the report unique. Need to add a unique key which is a combination of all columns


  • 2.  RE: how to make the records in the report unique

    Posted 08-20-2018 10:56
    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.


  • 3.  RE: how to make the records in the report unique

    Posted 01-22-2019 05:43
    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.