Skip to main content
Question

Is there a single-click solution to update all records in a table?

  • January 29, 2018
  • 0 replies
  • 52 views

Forum|alt.badge.img+1
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.
This topic has been closed for replies.

Brett,

This is confusing. Note that a Dynamic Form Rule only fires when a human user edits a single record on a form record and saves the record.  They do not fire for Grid Edits or for other kinds of mass updates such as mass find a replace or APIs.

Is this just a one time update that you need to do?