How can I update a connected field whose column name changes in the connected CSV?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
We recently had to make a change to the CSV file that is used in a connected table via Quickbase Sync. This column name change immediately caused the sync to fail on the next interval, which makes sense.

I expected there to be a way to go to the connected field in Quickbase (that was now orphaned), and "re-link" it to the newly renamed field in the CSV. However, there only appeared to be the option to delete my orphaned connected field, and add the "new" renamed field. 

In this situation that wasn't too big of a deal, but if that field had a long list in the "usage" tab (reports, calculated fields, relationships, etc) it would have been very tricky.

Is there not a way to re-link a broken connection to a field?
Photo of Scott

Scott

  • 50 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
As a work a round if there had been extensive usage of that field, does it look like you could have changed the orphaned field to a formula field equal to the value of the replacement Sync field?

I know, a bit messy but would that have been an option?
Photo of Scott

Scott

  • 50 Points
Yes, that would probably work - but boy is that messy (as you say).