Updating a column from the original base

Hi,

I’m trying to update a record from an original base, rather than the synced one, from the synced spreadsheet. How would you do this?

My best try has been to update the original record via Zapier, with the trigger being an unsynced column on the synced table, and looking up the identifier on the original table with the proper identifier.

The problem of my solution is that Zapier doesn’t recognize unsynced columns on synced tables for the automation, so I’m stuck with either:

  1. Doing something so Zapier recognizes the unsyced columns
  2. Finding a different solution altogether

What do you think?
Thanks in advance

**With unsynced columns, I mean the new columns you add on a synced table.