Help

Create múltiple records based on data from one cell

Topic Labels: Automations
703 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Maximiliano_Bus
4 - Data Explorer
4 - Data Explorer

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?

captura_de_pantalla_2021-07-15_a_la_s__10.24.15_a.m.-1

1 Reply 1
Joe_Hewes
7 - App Architect
7 - App Architect

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