Quick Base Discussions

Expand all | Collapse all

Keeping a copied table with updates values

  • 1.  Keeping a copied table with updates values

    Posted 11-29-2017 19:52
    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)?


  • 2.  RE: Keeping a copied table with updates values

    Posted 11-29-2017 21:27
    When you copy a table I believe there is an option to keep the data, or not.


  • 3.  RE: Keeping a copied table with updates values

    Posted 11-29-2017 22:16
    I don't believe it updates the current information though. 


  • 4.  RE: Keeping a copied table with updates values

    Posted 11-29-2017 22:22
    What do you mean by updating yh current information. Can you give me an example?


  • 5.  RE: Keeping a copied table with updates values

    Posted 11-30-2017 00:07
    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.    


  • 6.  RE: Keeping a copied table with updates values

    Posted 12-04-2017 19:33
    Thank you! Where is the option to do that? I add a table and I don't see the option to "use connected data.


  • 7.  RE: Keeping a copied table with updates values