Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoPerhaps not intuitive, but the way to do this is not in the Submit button but on the button to add a new record. We use the Syntax for &NextURL = ... to control where the user goes after the native Save. We have to URLEncode when we nest successive URLs.
URLRoot() & "db/" & [_DBID_table where the new record will be added] & "?a=nwr&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID_table where the new record will be added] & "?a=nwr&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RodericWest
6 years agoQrew Trainee
We don't have them add the record. The record is created by us, and based on certain selections a notification of the record is sent to the outside person. They fill out the information they need to and then save. I wanted to add a Submit button at the end, so they click that, save the record, and redirects them to a Thank you home page.
It was requested to have a Submit button at the bottom, rather than use the Save button at the top.
------------------------------
RWest8 RWest8
------------------------------
It was requested to have a Submit button at the bottom, rather than use the Save button at the top.
------------------------------
RWest8 RWest8
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
OK, 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
------------------------------- RodericWest6 years agoQrew TraineeI 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
------------------------------- MarkShnier__You6 years ago
Qrew Legend
When 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
------------------------------