Call an Appscript function that returns a list, create rows in a table from the returned values

[Suvrutt_Gurjar]

@Robert_Sherwood

The next step in the should accept the List as input and creates one row in a different table for each item in the list:

Please take a look at the several tips about adding rows to a table based on the enumlist in table 1.

I have myself used the following excellent tip by @Steve several times.

FAQ: add row per value in EnumList

Add one row per value in an EnumList column list. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: EnumList (type EnumList; a list of Enum values;…

Add rows to another table WITH parameterized input

This pattern comes up more and more, so I thought I’d build a simple example. We already know that you can copy rows using the “add rows to another table” action. But sometimes we want our end user audience to provide some input first. The attached app shows a simple way to do this. At its most basic, the design has an “extra” table whose only real purpose is to allow data entry of a single row of info. This info could then be used when calling the “Copy” action. So… in our fictitious example…