Hello, I've looked around for an answer to this but haven't found one yet, apologies if I've been looking in the wrong place or the answer is obvious.
My airtable has a list of filename prefixes in one field and a corresponding number of files in another. The prefixes are formatted something like this: item-01, and then there would be a file count that can range up into the dozens. What I am hoping to do is use those two fields to create a file name list. So if the file count was 2, I would want a list that would go something like
item-01-001.tif
item-01-002.tif
This data would then be output to a "filenames" tab in the airtable. Is this doable? I am not good with formulas so I've been trying various solutions using linked records and automations but I haven't had any luck.
Thank you for reading!
