Skip to main content
Question

Submit button error

  • March 26, 2023
  • 0 replies
  • 86 views

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 hit save & keep working (or exit or new) 

this is what i am working with for my submit button, i have removed my app token for security reasons. 

"<a class=\"Vibrant Primary SaveBeforeNavigating\" width:310px; text-align: center;\" href='" & URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=you wish you knew &_fid_79=Pending Review&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()) & "'>Submit</a>"

this is the error that i am getting:

thanks in advance for helping me!



------------------------------
mcraig0127
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------

    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement