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
yes, you are right, copy will be better
------------------------------
Liang xie
------------------------------
------------------------------
Liang xie
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendWhen 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
------------------------------
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
------------------------------
