Getting Started

 View Only
  • 1.  Move Records with API Buttons in Quick Base

    Posted 06-24-2022 22:14
    What's the formula to move the records with API bottom in quick base between two table, please



    ------------------
    Leon Xie 

    Absolute Group of Companies
    33 Southgate Street 
    Worcester,MA 01610
    508-733-7829
    +86-136-0684-4906





  • 2.  RE: Move Records with API Buttons in Quick Base

    Posted 06-25-2022 12:07
    When you say "move", are you really sure that you want to delete the original record, or perhaps it's better to flag it as having been copied to another table.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Move Records with API Buttons in Quick Base

    Posted 06-25-2022 19:05
    yes, you are right, copy will be better

    ------------------------------
    Liang xie
    ------------------------------



  • 4.  RE: Move Records with API Buttons in Quick Base

    Posted 06-25-2022 19:57
    When you think about formula URL buttons, you need to think through exactly what you want them to do.

    in you case, I assume you want to launch off a record,
    Flag as copied
    Create duplicate record in a different table.
    and then land the user where?


    But before we start writing code for this, is there a good reason to want to duplicate the record?  Often, a better solution is to just have a status field in the record  and use reports to filter the records.  Once you start down a path of duplication, there is the risk that the two records will get different.


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Move Records with API Buttons in Quick Base

    Posted 06-25-2022 20:37
    This is what I want to do 
    1. I have one table has couple options
    2. there is another table like create a PO
    3.I want make one button on the option table, and pick couple options which I need copy to another table into one PO

    ------------------------------
    Liang xie
    ------------------------------



  • 6.  RE: Move Records with API Buttons in Quick Base

    Posted 06-26-2022 19:36
    Here is a partial answer.
    This formula in a formula URL field code will create a new record in another table and land the user on the newly created record.

    URLRoot() & "db/" & [DBID_of the target table from its advanced settings] & "?act=API_AddRecord"
    & "apptoken=xxxxxxxxx" // if you have application tokens enabled
    & "&_fid_6=" & urlencode([my field 1])
    & "&_fid_7=" & urlencode([my field 1])
    & "&_fid_8=" & urlencode([my field 1])
    & "&disprec=1"

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------