Discussions

Expand all | Collapse all

Need help moving children records to a new table

  • 1.  Need help moving children records to a new table

    Posted 11-17-2017 21:09
    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?


  • 2.  RE: Need help moving children records to a new table

    Bronze
    Contributor
    Posted 11-17-2017 21:26
    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)


  • 3.  RE: Need help moving children records to a new table

    Posted 11-17-2017 21:30
    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 QuickBaseCoach.com if you want to discuss.