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:
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:
Hello, we've built an app for this exact purpose and you can find it here.
The app will generate a script that you can add to your "Run a Script" automation action, and the script will split the long text from multiple cells in the first table and create records in the second table, as well as linking the records together.
It does not matter how many data fields you have, so if you have the fields "IndividualAnchors1", "IndividualAnchors2", "IndividualAnchors3", "IndividualLink1", "IndividualLink2" for the same record, the app will still work fine.