Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Split one record in multiple records

2819 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Luigi3
4 - Data Explorer
4 - Data Explorer

Hi all,

I need to create from a single record, multiple record, in the same table. If in one field there is a specified keyword, I would not a single row but 2 or more records. Is it possbile?

The "source" record could be added from a form or if is it possibile from an email.

Thank you very much.

Luigi

5 Replies 5
Karlstens
11 - Venus
11 - Venus

Yes, this is absolutely possible with an Automation Script. If you provide some mock-up data, some split keywords and a screenshot or two - I can provide a sample script for you to use.

Hi,

I try to explain my needs. 

A first form where I can insert a name and a date. After I push a botton:

If the name is "....." then create one or more new record on the master base, with other fields that I set in the automation.

For example: if in the first form the name is Luca then I would to create 2 (or more) new records in the main database with this field:

Name="Luca", Date=date_in_the_form, Reason="rent", Cost="100,00"

Name="Luca", Date=date_in_the_form, Reason="utility", Cost="50,00"

I hope I explain my requests.

Regards

You could definitely no-code a solution for this - such as with two tables;

First table with a Form View - and form entry is critical for no-code automation to trigger record creation, where the name of the trigger record is being copied into subsequent fields. A form allows the complete capture of the name upon form submission - where other trigger methods often result in empty data being used upon triggering an automation.

Karlstens_4-1671581216292.png

 

Second Table where the automated records are created.

Karlstens_5-1671581254897.png

 

Automation could look something like this - note that the trigger is upon when a form is submitted;

 

Karlstens_2-1671581132209.png

Karlstens_3-1671581143922.png

 

 

Luigi3
4 - Data Explorer
4 - Data Explorer

Thank you very much.

a question: if in the form I would like to create many buttons, and for every button I create an automation that create multiple records with all the fields that I would to insert in the second database, is it possible?

Regards

With an Interface Form, yes, this can be done - but limited to one automation per button, which is frustrating. I hope Airtable Devs allow for one automation to be tied to many buttons soon.