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 Worceste...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen 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
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
yes, you are right, copy will be better
------------------------------
Liang xie
------------------------------
------------------------------
Liang xie
------------------------------
- MarkShnier__YouWhen 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
------------------------------- 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
------------------------------- MarkShnier__YouHere 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
------------------------------
