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
Not tested, but try this
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
------------------------------
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
------------------------------
This 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($
DisplayURLMissingRID) & $RID;
------------------------------
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
------------------------------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
------------------------------
