Forum Discussion
I think these would be the steps
I think your search step is on the wrong table.
A - Record Created (Triggers on the source table action) Correct
B - Prepare Bulk Record Upsert Correct
C - Search Records (Searches on source table to capture data). Query of Record ID = {{a.id}} Incorrect - you want to search the helper table with a filter that the helper record counter number is less than or equal to the # of records required from step A.
For Each loop contains
D - Add Bulk Upsert Row correct
End of For Loop
E - Commit upsert correct
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks for your assistance. Finally got it working. There is a noticeable delay when adding hundreds of records but since that is a rare situation it should be acceptable.
The advance query ended up being a simple:
{6.LTE.{{a.job_qty}}}
------------------------------
Grant K
------------------------------