Forum Discussion

Liangxie's avatar
Liangxie
Qrew Cadet
3 years ago

Move Records with API Buttons in Quick Base

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



  • 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
    ------------------------------
    • Liangxie's avatar
      Liangxie
      Qrew Cadet
      yes, you are right, copy will be better

      ------------------------------
      Liang xie
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------