Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoIs the problem data dependent. ie does it work on other records? Can you also try with a record that does not have a website loaded? Maybe the URL is choking on the http:// part. or is the data just like www.google.com
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RyanFarrington
5 years agoQrew Member
I've done more testing and found that the system prefers certain fields toward the beginning of the URL, otherwise it won't write the values to the fields in the new record. I have no idea why! (I'm going to try working in the [Billing Address] field after I make more progress. I haven't gotten that to work yet.)
With the "preferred" fields listed first, I tested the button and appended
With that working, I thought I would try just URLTWO, which is an API_GenAddRecordForm. That worked.
Now it's a matter of getting it to create the first record and then redirect to URLTWO, which it refuses to do.
------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------
With the "preferred" fields listed first, I tested the button and appended
&disprec=1
so it would land on the newly created record. That only worked when I put &disprec=1
early in the URL.With that working, I thought I would try just URLTWO, which is an API_GenAddRecordForm. That worked.
Now it's a matter of getting it to create the first record and then redirect to URLTWO, which it refuses to do.
//URLONE
URLRoot() & "db/" & [_DBID_CLIENTS] & "?a=API_AddRecord&apptoken=XXXXXXXX"
& "&_fid_37=" & URLEncode([Website])
& "&_fid_43=" & URLEncode(User()) //Account Lead
& "&_fid_173=" & URLEncode([Record ID#]) //Trigger Contact
& "&_fid_6=" & URLEncode([Company Name]) //required field
& "&_fid_89=" & URLEncode([Related Payment Term]) //required field
& "&_fid_99=" & URLEncode([Related Tax Code]) //required field
& "&_fid_62=" & URLEncode([Lead Source])
& "&_fid_126=" & URLEncode(User()) //Won By
& "&_fid_83=" & URLEncode(User()) //Project Manager
& "&_fid_33=Prospect"
& "&_fid_38=" & URLEncode([Industry])
& "&rdr=" & URLEncode(
//URLTWO
URLRoot() & "db/" & [_DBID_QUOTES] & "?a=API_GenAddRecordForm"
& "&_fid_244=" & URLEncode(Today()+Days(7))
& "&_fid_214=" & URLEncode([Record ID#]) //Related Contact
& "&_fid_653=" & URLEncode([Record ID#]) //Trigger Contact
)
------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------