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
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__You
Qrew Legend
Qrew LegendThe 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
------------------------------
& "&_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
------------------------------- It worked!
Thank you again Mark!
------------------------------
Howard Fu
------------------------------