We are using two bases to work different steps of a workflow but are having difficulty syncing all the data back to the original record source in “base #1”.
“Base #1” has the planning, design request & scheduling executed and “base #2” has the designing, design proofing & final design attachment executed. We have synced a table from base #1 to base #2 but then created new fields to be worked in base #2, how do we update the original record in base #1 to the applicable new fields created in base #2?
As a note, we were able to sync all the applicable fields back to base #1 in a new table but that did not fulfill our workflow need as we require the new field data to be included in the original table in base #1.
Any ideas on how to build this differently or automate the data to flow full circle?
Thank you in advance!