Automation - Add dynamic amount of records to a table
I'm looking to add records to a table via an automation based on a variable numeric field in the trigger table. So if the field is 1 I add one record to a table, if 2 then 2 and so on...
Forum Discussion
Low tech solution if you have a limited number of choices for the # of records to be added, say between 1 and 10 is to have 10 Automations and fire them based on checking that number.
It is also possible to write a looping Automation which will increment a counter and then trigger itself to run again as long as the counter is still less that the number to be added.
You can do up to 100 loops before Quick base will assume that you may have created and endless loop and stop the process.
It is also possible to write a looping Automation which will increment a counter and then trigger itself to run again as long as the counter is still less that the number to be added.
You can do up to 100 loops before Quick base will assume that you may have created and endless loop and stop the process.
I have implemented this solution and it is working to my satisfaction. Thanks for the input.