Need help moving children records to a new table
I have a parent record that has a variable amount of children records. When I set a field in the parent record to Approved, I want the 4 children records to be written to a "Final" table.
At the moment I have a button on the parent record that will set a field to Approved. The children records all have a lookup field that retrieve the Approved info.
Apparently a quickbase action cant look at a lookup value, so i created a formula text field that is equal to the lookup field.
I want quickbase to see that the formulas value has changed, and then run an action to move each record to the new table.
It seems like when a lookup or a formula field change, that the date modified does not. Any suggestions?
At the moment I have a button on the parent record that will set a field to Approved. The children records all have a lookup field that retrieve the Approved info.
Apparently a quickbase action cant look at a lookup value, so i created a formula text field that is equal to the lookup field.
I want quickbase to see that the formulas value has changed, and then run an action to move each record to the new table.
It seems like when a lookup or a formula field change, that the date modified does not. Any suggestions?
