Save and redirect to a thank you page
I have a form that I need an external user to complete. I want to add a Submit button, that will Save and Close the record and direct them to a Thank you page. I have a Home Page that has a Thank you ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK, what if you send then a link to edit the record.
URLRoot() & "db/" & [_DBID_table where the record will be edited] & "?a=er&rid=" & [Record ID#] &nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5")
I have not tested that, but it might work.
There is a pretty straight forward way to make your own save button with any color and label, which i can supply if needed. You can suppress the native save button by suffixing the URL with
&ifv=1
URLRoot() & "db/" & [_DBID_table where the record will be edited] & "?a=er&rid=" & [Record ID#] &ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5&ifv=1")
If it is possible to make a button which will save and redirect, it would require using what is known as the IOL - Image On Load technique, which is non native, and non supported by Quick Base and will break in the future when they launch their new forms (not sure when that will happen, but forms have been mostly the same since like 2001, so they well know its time for an update.
So that is why I'm suggesting to explore a native solution.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID_table where the record will be edited] & "?a=er&rid=" & [Record ID#] &nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5")
I have not tested that, but it might work.
There is a pretty straight forward way to make your own save button with any color and label, which i can supply if needed. You can suppress the native save button by suffixing the URL with
&ifv=1
URLRoot() & "db/" & [_DBID_table where the record will be edited] & "?a=er&rid=" & [Record ID#] &ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5&ifv=1")
If it is possible to make a button which will save and redirect, it would require using what is known as the IOL - Image On Load technique, which is non native, and non supported by Quick Base and will break in the future when they launch their new forms (not sure when that will happen, but forms have been mostly the same since like 2001, so they well know its time for an update.
So that is why I'm suggesting to explore a native solution.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I tried the code you provided, however, I got a syntax error message.
URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] &ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1"
What would I do to simply have it save the record?
And then to explore, what would be the native option and how that would work.
Sorry, I am not very good at coding, in the process of learning.
------------------------------
RWest8 RWest8
------------------------------
URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] &ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1"
What would I do to simply have it save the record?
And then to explore, what would be the native option and how that would work.
Sorry, I am not very good at coding, in the process of learning.
------------------------------
RWest8 RWest8
------------------------------
- MarkShnier__YouWhen you have a syntax error its much easier for us to help you if you not only post your code (which you did) but also the whole text of the error.
But try this
URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] & "&ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1")
Once you use the syntax to hide the regular features of the form and hence hide the native save button then you would need to make a rich text formula field for the user to click to save.
Try this code.
"<a class='Vibrant Primary' style=\"width:180px; text-align: center;\" onclick='DoSaveAdd()' href='#'>Submit</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you. The Submit button works great!
Where do I enter the code prior?
URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] & "&ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1")
I was entering it into a Formula URL, that is where I got an error, assuming the wrong place.
------------------------------
RWest8 RWest8
------------------------------- MarkShnier__YouSince this, you say, is being sent out by an email Notification, then the formula would go into a formula URL field on the record and you would have words on the email notification like
Click here [my url field goes here] to complete your registration.
If there are still Syntax errors with that untested formula, please copy and paste in the syntax error text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------