Need help moving children records to a new table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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?
Photo of Cameron Hughes

Cameron Hughes

  • 130 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
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)
I have a solution but it would take an hour or so of consulting time to set up for you.  Contact me via my website if you want to discuss.