Forum Discussion

AndreaJohannes's avatar
AndreaJohannes
Qrew Trainee
6 years ago

Connecting an already created table to another table in another QB app so that it will automatically refresh

I have several small applications that I've created that utilize an "employees" table. I am currently updating them manually.  I have a master personnel application. I've recently discovered using Quickbase Connections to automatically refresh the tables in other apps with information from my overall personnel app. (A QB partner created a new application for me that did this) When I read how to connect the tables in the applications, it all directs me to create a new table and choose connection. Is there a way to connect a table that is already created? Or do I have to delete the old tables in my smaller apps (which would mess up my current data) and build a new table with the connection?  Thanks in advance for your help!

1 Reply

  •  No there is not a way to convert a regular table to be a Connected Sync table.  An possible option might be to bring in your data to the app on a new Sync table, and them to have an Automation run to delete the records in your existing tables each day (if the record count is under 1,000)  and then to re-import each day from the Sync table.  But that assumes that there is no data entry into the old tables, ie these are fixed Master tables like the Customer Master or the Item Masters.