Keeping a copied table with updates values

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
I copied a table but I need it to have the current information from the first table. How do I ensure that the copied table keeps the current information (and not just the format of the first table)?
Photo of Shannon Dorman

Shannon Dorman

  • 90 Points 75 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
When you copy a table I believe there is an option to keep the data, or not.
Photo of Shannon Dorman

Shannon Dorman

  • 90 Points 75 badge 2x thumb
I don't believe it updates the current information though. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
What do you mean by updating yh current information. Can you give me an example?
Photo of Drew

Drew

  • 432 Points 250 badge 2x thumb
I think what you're looking for is a 'connected table'.  This is a table that you set up to mirror another quickbase table, and to keep the data in the connected table the same as in the source one.  This is the easiest way to accomplish this, albeit there are a few caveats.  For one, the shortest time you can schedule between 'syncs' is one hour, although you can manually sync as often as you want.  There are other ways to do this as well, such as using native webhooks.  There is an example app in the exchange which demonstrates how those are setup.  The benefit is that the second table can be kept up to date with the source table in 'live' time, not on a schedule.  However, there is significantly more setup involved in this method.    
Photo of Shannon Dorman

Shannon Dorman

  • 90 Points 75 badge 2x thumb
Thank you! Where is the option to do that? I add a table and I don't see the option to "use connected data."
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,096 Points 50k badge 2x thumb
Please read up on setting up a Sync table.

https://help.quickbase.com/user-assistance/connecting_to_other_quickbase_apps.html

You will need to set up a fresh new table and create it as a "Sync" table.