Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Dynamically update a table

I am not sure if this is possible, I would like to know if there is a way to dynamically update a table with all of the current tables in an app?



------------------------------
Paul Peterson
------------------------------
Relationships
Tables and fields
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago

    Yes, but. In order to capture and update a table in App A with the tables in App B, you will need to do one of two things. If you're comfortable building your own solution, you can utilize the API and access an application's schema using API_GetSchema, then update the list of tables using the information from this. The second option would be to use a pre-built tool that can capture the schema of one or more applications for you. Tools like this are available from several QSPs including DataCollaborative and Juiced Technologies. An example of one of these is available in the App Exchange and it's called QuickBase Application Documenter.



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------