Create new record in one database from data in another database

  • 1
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I have two databases called app 1  and app 2.  There are times when I would like to create a new record in app 2 and auto populate some of the fields in app 2 with information from fields in app1.  I'm thinking a formula button would be the best but I need assistance.  Can someone assist me with starting this process?
Photo of cowannbell

cowannbell

  • 680 Points 500 badge 2x thumb

Posted 6 months ago

  • 1
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Quick Base Actions would be a far simpler and quicker solution to set up. Click on the settings link for the table that will invoke the action. Click on Quick Base Actions at the bottom right. The steps are pretty self explanatory.
(Edited)
Photo of cowannbell

cowannbell

  • 680 Points 500 badge 2x thumb
Thank you,  We are on a corporate version on our on share, however we will be moving to Quickbase servers in August and we will then have this function available.
Photo of Noah McBride

Noah McBride

  • 356 Points 250 badge 2x thumb

This may not be worth the work, considering that you are going to be using QB actions, but this may be a time saver in the meantime.


You could create a Formula Rich Text field using the Add Record API. Here is a link to the page.


https://help.quickbase.com/api-guide/index.html#add_record.html%3FTocPath%3DQuick%2520Base%2520API%2...


All you would have to do is specify the Field IDs of App 2 and then set them equal to the Field in App1 that supplies the correct value. This above link has examples for XML and URL API calls.