Need help moving children records to a new table

Question

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?

ChuckGrigsby · Answer

It's because formulas and lookups are more of a looking glass at a present state of data. It's not an actual value that's stored. That's why when you make a change to the formula/lookup dependant field you can see it change instantly. The date modified only changes when a value is changed/added and stored(saved to the database)

Sign up

Login to the community