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------------------------------
Original Message:
Sent: 06-25-2022 19:04
From: Liang xie
Subject: Move Records with API Buttons in Quick Base
yes, you are right, copy will be better
------------------------------
Liang xie
Original Message:
Sent: 06-25-2022 12:07
From: Mark Shnier (Your Quickbase Coach)
Subject: Move Records with API Buttons in Quick Base
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
Original Message:
Sent: 06-24-2022 22:13
From: Liang xie
Subject: 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