Forum Discussion

Qrew Cadet

8 years ago

Sync two Quickbase tables into a third Quickbase table.

Can I sync from two different sources into one Quickbase table? Specifically, I have three databases. Two have Timelog tables. I want to combine the information from each existing Timelog table int...

Quickbase Automations

Qrew Cadet

My goal is to make them automatic.

Qrew Captain

8 years ago

This sounds like it will involve more than I can easily explain in this forum.

Send me an email at matthew@cirrusops.com

I can help more effectively if we do a share screen.

ELANAMETH
Qrew Cadet
5 years ago
Hello,
Is there any updated way to do this?
I have 2 apps with a table in each that need to be merged (on a filter, as I don't want overlap). Each table already has a corresponding sync table in the other app, so it does not really matter where I do the join. I would like to sync table A and table B into table C. Again, not all of table A or B - each would need a filter.

Is the only way to do this via an import?

------------------------------
E. P.
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  You can have a process each night to run an Automation to copy across data for the two tables into a third table, and then to delete any records, where the source record got deleted.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------