API copy a record and change some fields
Hello QB Community, How do I use API to copy a record in the same table and change a couple of values in the newly created record. ------------------------------ Howard Fu --------------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this as a URL formula button I'm just on my iPhone do post back if there are any syntax errors
URLRoot() & "db/" & Dbid()
& "?act=API_AddRecord"
& "&_fid_6=" & URLEncode ([Purchase Order])
& "&_fid_17=" & [Qty]
& "&_fid_10=" & [Related Priced Material]
& "disprec=1"
for each field ID you need a new line for your own sanity.
if the data being put into the field might have text with spaces of special characters, you need to URLEncode as above.
if here are fields of type User or date they need to converted to text
Like
& "&_fid_17=" & ToText(User field])
the last line says to display the record after the click.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
HI Mark,
I tried the formula but I'm having some trouble when it comes to replacing the line below with my own information
& "&_fid_6=" & URLEncode ([Purchase Order])
Can you explain what this line is saying similar how you spell it out in your URL Buttons for Dummies app (very helpful by the way)?
I have a multiple choice field called [Type] and the field ID is 8. The options are Price, Sample, and Purchase. I want the newly created record to say Purchase.
I also have a text field called [Description] where users put in various information. I would like that field to be copied from the original to the new record.
Can you please guide me in the right direction toward accomplishing those two things?
------------------------------
Howard Fu
------------------------------
I tried the formula but I'm having some trouble when it comes to replacing the line below with my own information
& "&_fid_6=" & URLEncode ([Purchase Order])
Can you explain what this line is saying similar how you spell it out in your URL Buttons for Dummies app (very helpful by the way)?
I have a multiple choice field called [Type] and the field ID is 8. The options are Price, Sample, and Purchase. I want the newly created record to say Purchase.
I also have a text field called [Description] where users put in various information. I would like that field to be copied from the original to the new record.
Can you please guide me in the right direction toward accomplishing those two things?
------------------------------
Howard Fu
------------------------------
- MarkShnier__YouThe line should read
& "&_fid_8=" & "Purchase"
If the field ID for Description was 99 the line would read
& "&_fid_99=" & URLEncode ([Description])
That field will need the URLEncode, as the contents of that field are likely to include spaces or special characters.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Hi Mark,
I've entered all the fields I wanted to include in this button and everything works great so thank you for that. The last thing I need to fix is displaying the record. Right now it shows that there are no errors. I believe & "disprec=1" should display the record. Is there anything I need to change or try?
------------------------------
Howard Fu
------------------------------- MarkShnier__YouI believe that the syntax is actually
& "&disprec=1"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------