Forum Discussion

Liangxie's avatar
Liangxie
Qrew Cadet
2 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



5 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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
        Qrew #1 Challenger
        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
        ------------------------------