Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoWhen 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
------------------------------
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
------------------------------
RodericWest
6 years agoQrew Trainee
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
------------------------------
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__You6 years ago
Qrew Legend
Since 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
------------------------------- RodericWest6 years agoQrew TraineeThank you!
That works! The notification sent successfully with the link. I like the way it displays.
However, when I clicked the Submit button, I was given and Error, page not found.
The record was saved and updated.
------------------------------
RWest8 RWest8
------------------------------- MarkShnier__You6 years ago
Qrew Legend
OK, so we are getting there.
This part of the formula here
a=showpage&pageid=7
is saying to display page # 7
When you look at your list of pages, the page ID# is on the right. So check that you are displaying a page which, in fact, does exists :)
ā
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------