Submit button error
currently i have buttons that will work if i save the record and go back into the form, but i want to be able to change field ID 79's status to pending review when one hits submit WITHOUT having to h...
Forum Discussion
I keep getting this message, even after placing a semi-colon -
A variable declaration must end with a semi-colon.
and it is referring to this portion:
"<a class=\"Vibrant Primary SaveBeforeNavigating\" width:310px; text-align: center;\" href='" $URL & "'>Submit</a>"
thanks for being awesome!
------------------------------
Michelle Craig
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThis line here needs a semi colon at the end after the RID. I will also fix my original post.
var text URL = $Edit
& "&rdr=" & URLEncode($
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Stupid question...should I be copy/pasting your entire post with changing my app ID? OR just that first line replacing the savebeforenavigating portion? - sorry coding is def not my strongest skill
------------------------------
Michelle Craig
------------------------------- MarkShnier__You
I'm not sure what your formula reads as now because you didn't post your whole formula but the full corrected formula is this (other than you need to put in your own application token)
var text RID = If([Record ID#] > 0, ToText([Record ID#]), "%%rid%%");
// the %%rid%% is a special symbol which will be replaced by the value of the
// Record ID# when the SaveBeforeNavigating happens.
var text Edit = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=you wish you knew&_fid_79=Pending Review";
var text DisplayURLMissingRID = URLRoot() & "db/" & Dbid() & "?a=dr&rid=";
var text URL = $Edit
& "&rdr=" & URLEncode($DisplayURLMissingRID) & $RID;
// note that the %%rid%% does not like being URLEncoded!
"<a class=\"Vibrant Primary SaveBeforeNavigating\" width:310px; text-align: center;\" href='" & $URL & "'>Submit</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ok cool, that's what I had, now getting this:
<qdbapi><action>API_EditRecord</action><errcode>30</errcode><errtext>No such record</errtext><errdetail>Sorry, there is no record in this application table with the record identifier (rid) of "0".</errdetail>var text RID = If([Record ID#] > 0, ToText([Record ID#]), "%%rid%%");
// the %%rid%% is a special symbol which will be replaced by the value of the
// Record ID# when the SaveBeforeNavigating happens.
var text Edit = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=blank&_fid_79=Pending Review";
var text DisplayURLMissingRID = URLRoot() & "db/" & Dbid() & "?a=dr&rid=";
var text URL = $Edit& "&rdr=" & URLEncode($DisplayURLMissingRID) & $RID;
// note that the %%rid%% does not like being URLEncoded!
"<a class=\"Vibrant Primary SaveBeforeNavigating\" width:310px; text-align: center;\" href='" & $URL & "'>Submit</a>"</qdbapi>
------------------------------
Michelle Craig
------------------------------