Hi @Jenny_Wright - this could be done with an Airtable script. I don’t think there’s another way to do this wholly within Airtable. The script would loop through every record and, for each record, loop through every item in the Drivers column, creating a new record on each iteration of the inner loop. As you say, creating these records in a new table is going to be a better option than trying to add into the original table.
It isn’t a hugely complex script but would take some time to develop. If you’ve got a budget for a small script project, feel free to DM me for script dev costs.
Thanks for the reply @JonathanBowen.
Would you be able to append data to the new table based off changes or would the new table have to regenerate each time?
Thanks for the reply @JonathanBowen.
Would you be able to append data to the new table based off changes or would the new table have to regenerate each time?
Hi @Jenny_Wright - you could do either. To append, I would probably just mark each record in the original script as “processed” (maybe a checkbox" field) and skip these next time. This assumes that no-one would go and edit a record after it has been processed. It might be safer to do a full refresh each time, but doable either way and the choice would probably depend upon your specific situation. Or, indeed, have both methods and only do a full refresh occasionally.