My question has been asked with variations in these forums, but I wasn’t able to get the results I wanted from what I found.
I am creating a new database for a museum. We want to give each object a unique identifier. None of the 3,000+ objects have any kind of number assigned to them. Let’s call this field Object ID. I have another field called Object Type that has 4 choices (Tool, Musical Instrument, Action Model, Other). I would like the Object ID to be assigned automatically based on the record number but prefixed like this:
TO0004 which means Tool #4
MI0017 which means Musical Instrument #17
AM0004 which means Action Model #4
So the sequence of numbers would start over for each type of object. And this could happen after one selects the object type from a drop down menu before the form is submitted. It would be in an uneditable field and just display the object ID. This number can never be changed.
Do I use scripting for this?
Thanks in advance for you help. I am completely new to Airtable.