I’m very new to Airtable and colleagues of mine - who are using Airtable very intensively - are using one of the communities’s script automations to create a child table linked to a parent table with a number of entries that is controlled by a “on-run” string-input from the user that originally has triggered the automation by clicking on a button at a given row in the parent table.
The script is “Multiple records w/prompt”:
What I’m trying to achieve is that, instead of waiting for the manual input from the user during execution to determine how many entries the script should create at the child table, as per line
const newRecordCount = hardCoded.newRecordCount
? parseInt(hardCoded.newRecordCount, 10)
: parseInt(await input.textAsync(‘Number of records to create’), 10);
I would like to use the value of a field (column) that actually contains the number of entires to be created in the child table.
More precisely, in the first row of this example:
after pressing the button “Create Tracks” the script should create in the child table 10 tracks that are linked to the parent table, without the need of the user (who pressed the button) to manually input 10 into the field that pops up on pressing the button:
I have tried a couple of variations of “.getCellValue()” but without success.
Any help is very appreciated :grinning_face_with_big_eyes:
Thank you very much!