API_Add Record Redirect to Thank You Page - Token Not Recognized

Question

Hi everyone,I'm fairly new to QuickBase still; and am so appreciative the community here as reading through your discussions that are similar to my question helped me get this far.&nbsp; So thank you!I'm still puzzled, however, on how to write a URL Formula to redirect to a Rich Text Thank You Page.&nbsp; We have a lot of EOTI Surveys, and on pressing Submit, I want to make it clear the submission was received and thank the user for their time.My current code reads as:
URLRoot() &amp; "db/" &amp; [_DBID_ITK_ATTENDEE_SURVEY] &amp; "?a=API_AddRecord&amp;AppToken="&amp;[ItK-Token]&amp;"=Approved"&amp;"&amp;rdr="&amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dbpage&amp;pageID=2&amp;ifv=1")
But I still receive the error:&nbsp;
&lt;qdbapi&gt;

&lt;action&gt;API_AddRecord&lt;/action&gt;

&lt;errcode&gt;24&lt;/errcode&gt;

&lt;errtext&gt;Invalid Application Token&lt;/errtext&gt;

&lt;errdetail&gt;An Application Token must be supplied.&lt;/errdetail&gt;

&lt;/qdbapi&gt;I've verified that I DO have a functional Application Token; I applied to a Variable when the code wouldn't accept the token directly in it (it kept looking for a Text string?).I've been reading through this help guide: Configure URL Fields and this one: Using ""&amp;z=""&amp;Rurl() and rdr in formula URL fieldsI'm Totally puzzled why the sample formula provided for this purpose includes a rid and fid demarcation, when the goal is to submit a record and redirect to a Thank you Page.Can someone help me understand why my formula isn't working?&nbsp;&nbsp;Is there a guide that helps break down the parts of formulas more clearly and provides a step-by-step roadmap?&nbsp;&nbsp;Thank you so much,Jen------------------------------Jennifer Juhasz------------------------------

markshnier__you · Answer

I think that in fact you want to put up an Add Record form as opposed to actually adding a record. if a human user is Saving a record on a manual form, then you do not need an App Token.

Try this syntax

URLRoot() & "db/" & [_DBID_ITK_ATTENDEE_SURVEY] & "?a=API_GenAddRecordForm"

& "&NextURL=" &URLEncode(URLRoot() & "db/" & Dbid() & "?a=showpage&pageID=2&ifv=1")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

jenniferjuhasz · Answer

Hi Mark,Thank you so much for taking a look.&nbsp; I love the simplicity of your suggestion, but it results in a pop-up that says "You must save this Response first".&nbsp;&nbsp;Is there not a way to code a 'Submit' button that saves the record to the table and takes a person to a Thank You page?Thank you again!------------------------------Jennifer Juhasz------------------------------

markshnier__you · Answer

I think that we need to take a step back here.

What are you trying to do? Where is the user launching from?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

jenniferjuhasz · Answer

Hi Mark,The user is provided with this Survey via an email after an online community forum:https://familysmart.quickbase.com/db/brkb4ptab?a=GenNewRecord&amp;ifv=1(I have several of these Surveys built for events we hold - but our team would like the Submit button to redirect to a 'Thank you' page)Thank you page for our Surveys App is: https://familysmart.quickbase.com/db/brfyiak3f?a=dbpage&amp;pageID=2Our Orientation Coordinator said it was possible to build a button to do this, but we never reached a point where this was built or I was shown how to do it - so I've been trying to learn on my own (on the fly).Possible?&nbsp; Seems like it should be a simple executable.------------------------------Jennifer Juhasz------------------------------

markshnier__you · Answer

Can you show me the code for your "submit" button?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

API_Add Record >> Redirect to Thank You Page - Token Not Recognized

8 Replies