Forum Discussion
It seems to me that this would be pretty straightforward with a Pipeline. He would figure out what your trigger is and that would be a on new event type trigger.
Then you would search the tags. Where is the tag number is between the starting tag in the ending tag
then you would have a For Each loop to create the join table records.
In theory, it is more efficient to create a bulk upsert right after the trigger step and then add rows to the bulk upsert and then at the end of the process commit the upsert, but if you're adding say 10 or 20 records, it will be fine be to do the for each loop to create the join table records.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Mark. I thought it was something like that, but I've been having trouble with the start and end tag search working properly. I will dig into it more and see if I can get it to work. Glad to know I'm on the right track at least.
------------------------------
Matt S
------------------------------
- MattS3 years agoQrew Member