Help with API
I have never used an API. How do I assign a value to a field with an url API? I want the user to click a link of dashboard and the API to assign the value to the first field on the form from the...
Forum Discussion
Instead of ?a=nwr you're going to want to use ?a=API_GenAddRecordForm you'll also need to pass a parameter with &_fid_XX= where XX is the field id of the field you'd like to change. What comes after the = is the value that you'd like to set in that field. It is best practice to wrap the value in a URLEncode() function.
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/
------------------------------
https://jsupor.quickbase.com/db/bn9gef6we?a=API_GenAddRecordForm&_fid_142=SHH Logistics LLC.&ticket=auth_ticket&apptoken=app_token is what I am trying and does not work.
| Kyle McAfee Estimating & Database Design
SHH Logistics LLC 15171 Cronewood Lane Memphis, IN 47143
Phone: 812.989.4171 / 973.229.9099
|
WBE Certified Business
|
My assumption is that SHH Logistics LLC. needs to be wrapped in a URLEncode() Function.
What error are you getting?
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/
------------------------------Justin,
Gives an error when entering in Dashboard. "Link is not valid web URI, make sure you included the protocol such as "https://"
Is the period after LLC valid? Do I need quotes around the value, "SHH Logistics LLC."?
I looked at the online help and do not understand the "%20" where there would normally be spaces. Do I need to add "%20" where the spaces are?
Example from QuickBase
https://target_domain/db/bdec4pdva?a=API_GenAddRecordForm&_fid_11=
GoodBye&_fid_23=Four%20score%20and%20seven%20years&ticket=auth_ticket
&apptoken=app_tokenKyle McAfee
Estimating & Database Design
SHH Logistics LLC
15171 Cronewood Lane
Memphis, IN 47143
Phone: 812.989.4171 / 973.229.9099
WBE Certified Business
%20 is a URL Encoded Space Character
Try replacing https://jsupor.quickbase.com with the Function URLRoot()
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/
------------------------------