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 think the looping is more applicable to my desired function. Let's say I initially fire the automation to be looped based on marking a checkbox; Can I then keep firing the automation based on the incremented field changing as a result of the automation? So the trigger is any of the following fields change: checkbox & counter.
If so, mine does not appear to increment correctly. I modify the loop numeric field in my automation. I have source set to both type and copy values. Then I grabbed the loop field and said + 1. What do I need to change to get my automation to increment a loop that continually triggers itself. - You can�t do calculations in the automation set up.
Make a feld on your trigger record which calculates a counter plus 1 and then have the Automation map that field into the counter. - I have implemented this solution and it is working to my satisfaction. Thanks for the input.
