Hello Community!
I have a form to submit records to "Table 1". Two of the fields from this form are Long-Text fields called "Anchors1" and "Links1" where I input multiple lines of text. In example, "Anchors1" cell content is:
"Anchor 1
Anchor 2
Anchor 3"
And "Links1" cell content is:
"link1.com
link2.com
link3.com"
Example of the form: https://airtable.com/shrSx7xeaXqXIfGBy
Example of Table1: https://airtable.com/shrXWKgXuwV0sx2cw
I want to run an automation, that every time the form is submitted ( and a new record is created on "Table 1") I can get the data from the last record created in "Table 1" and split the records from fields "Anchors1" and "Links1" into many different records on Table 2.
The result should be 3 new records on Table 2, where in Field "IndividualAnchors1" and "IndividualLink1" I can Get:
Record ID | IndividualAnchors1 | IndividualLink1
ID1 | Anchor 1 | link1.com
ID2 | Anchor 2 | link2.com
ID3 | Anchor 3 | link3.com
Example of Table2 with the splitted content: https://airtable.com/shrWD03FklpPRRAst
Can you help me create an automation for this case?
Thank you in advance