Update/Merge application table of fields with another application's fields

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

There is an old response from 5 years ago on this.   Is there any updates to this process?  


https://quickbase-community.intuit.com/questions/59483?_ans=2&_pos=1&_src=sapi&_tot=8059&from=sapi&t...=


I've created a "development", "staging", "production" version of an application.  What we are doing now is creating our changes in the development application. Once done, we go into the staging and recreate the fields, etc (in the same order..difficult).  


Wondering if there is a way to do this better?  Mainly the issue would be field ids being different between apps, such as when a table's listing of fields happens to have different Fids if created out of order. Same issue if something is deleted. 


I was looking into the GetSchema, but don't think i can recreate a field  (API_AddField) and specify a field id instead of receiving one.

Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
QuickBase today has a Sandbox available on the higher level plans. It works pretty well but does have a set of limitations. We generally find we can complete 80% of the work in the Sandbox and then another 20% has to be carefully done in Production.

Over the years, we have also developed some special tools to help document applications, manage change control, etc. to mitigate that risk. There is no other way natively (or via API) though to write fields and tables.

If you are interested, we can definitely discuss some overall governance strategies with you to help augment the native capabilities.