Discussions

Expand all | Collapse all

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

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

    Posted 03-28-2018 16:03
    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?


  • 2.  RE: How can I update a connected field whose column name changes in the connected CSV?

    Posted 03-28-2018 16:07
    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?


  • 3.  RE: How can I update a connected field whose column name changes in the connected CSV?

    Posted 03-28-2018 16:47
    Yes, that would probably work - but boy is that messy (as you say).