Anybody have any ideas on how to import data into a synced table?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
We are bringing basic info from one app into this one, but we have additional detail workflow that we need to import into the synced table.  It appears that both import/export and pasting into a grid edit report do not work.  Any ideas?
Photo of slloydavant

slloydavant

  • 220 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of David

David

  • 836 Points 500 badge 2x thumb
I've created a spreadsheet with the new additional data (with the key field), then saved as a CSV and dumped in my Google Drive sync folder. QB will grab all csv files for importing. This assumes you're sync settings are for 'add and update'. Does this help?
Photo of slloydavant

slloydavant

  • 220 Points 100 badge 2x thumb
I don't think so--this is a QB to QB sync.  You can't change the sync type, right?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,814 Points 50k badge 2x thumb
QB to QB Sync means that the source of truth is the original Sync source QB table.  So the only place to add record is at the source.