I would like to generate a unique primary key for each record of a table/database based on the following criteria:
- Use the first letter of the person’s first name. For example, a record with the first name of “Scott” will have the key beginning with an “S.”
- Followed by a four-digit sequence number starting with 0001.
If I was to create a new record for myself, my key is S0001.
If the next entry has the first name of “Howard,” the key would be H0001.
Then if I create a record for someone with the first name of Susan, the key would be S0002 because S0001 already exists.
Similarly, Helen would be H0002.
Can this be done using Airtable?