Discussions

Expand all | Collapse all

Create new record in one database from data in another database

  • 1.  Create new record in one database from data in another database

    Posted 05-09-2018 20:01
    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?


  • 2.  RE: Create new record in one database from data in another database

    Posted 05-09-2018 20:03
    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.


  • 3.  RE: Create new record in one database from data in another database

    Posted 05-24-2018 16:39
    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.


  • 4.  RE: Create new record in one database from data in another database

    Posted 05-25-2018 19:44

    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.