Jul 21, 2023 12:50 PM
Hi,
Is there a script that will generate a Unique ID for each image that would ideally be the concatenation of other fields like Initiative Name, Project Name, and then some random value? While the image has a name, creating Asset ID's automatically would help organize and ensure we are working with the correct creative asset.
Jul 21, 2023 02:20 PM
You can use a formula field to concatenate the information from other fields to create your ID. If you need an additional identifier to make the ID unique, you can use an autonumber field or the record ID.
If you want this concatenates ID as the filename for your attachment, you can either edit the name manually or you can use a script to re-upload the file with the new name.
Jul 21, 2023 02:28 PM
Thanks you are a rockstar! I am brand new to AirTable and I have lots to learn. what a powerful tool!