Create múltiple records based on data from one cell

Hello there Airtable experts :wave:t3:

So the context for this use case is the following:

There is a form on another app where an order is submitted and sent to a record in airtable. This form captures basic client stuff + plus the products which are inputed as # item numbers separated by comas in one cell. (1234, 2345, 1294)

→ What I want to do is to create múltiple records (one for each item) on another table.
1234 provider status
2344 provider status
1294 provider status

Im guessing it would be a scripting solution, has anyone done something similar?

Airtable provide something very similar as one of their examples. I’ve followed this and expanded on it with success: Airtable Scripting

By the sounds of it, you’d probably want to use automations “on form submission” trigger.

You could do this without code via integromat too