Give every unique value in column a unique value

Topic Labels: Formulas
541 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to figure out the best way to assign a unique, human readable code to each record having a unique entry in a particular field.

Screenshot2022-09-19 at 09.26.41

In my primary table every record represents a Document and the information in each record is extracted from or associated with it, including its MD5 hash (i.e., a unique 32 character algorithmically generated alphanumeric code).

The records in the database were created by identifying individual Documents contained within a File and creating a new record for every Document. So, e.g., a single PDF File might have 5 separate Documents contained within it, and thus 5 different Airtable records.

Every File has a unique MDF Hash value. Every Document within that file has the same MD5 Hash (since the value is calculated based on the File, not the Document).

So, I want to create the equivalent of a File ID # by giving each unique MD5 Hash a unique sequential value, and then associated that value with each corresponding record.

Thoughts on the best approach to this? Thanks.

0 Replies 0