BrettLyon
8 years agoQrew Trainee
Is there a single-click solution to update all records in a table?
In short, all I need to do is to "re-save" all records in a table, even if nothing is updated, simply to trigger a form rule that happens upon saving. The reason a second or "re-save" is needed is because the form rule needs to copy a value that does not yet exist until the key child record is created upon the first save with a QB action.
On the first save, a QB action creates child record of a formula text value that becomes a key in the child table for a summarizing data.
The only option now to tie that child key to the parent is to go back to the parent and either choose the key from the drop down or of course simply open and save because my form rule will take care of it (now that the child key record exists as a choice in the drop down).
Again, I am sure there are a few different ways to skin the cat, but I am guessing the easiest would be something along the lines of a formula URL or particular API that, with one click, can "update" (re-save) all parent records.
On the first save, a QB action creates child record of a formula text value that becomes a key in the child table for a summarizing data.
The only option now to tie that child key to the parent is to go back to the parent and either choose the key from the drop down or of course simply open and save because my form rule will take care of it (now that the child key record exists as a choice in the drop down).
Again, I am sure there are a few different ways to skin the cat, but I am guessing the easiest would be something along the lines of a formula URL or particular API that, with one click, can "update" (re-save) all parent records.