Forum Discussion

Jay_DDS_'s avatar
Jay_DDS_
Qrew Cadet
9 years ago

Create a button to change the value of another field

I need to create a formula-URL field that displays a button on a form. When the button is clicked, I want the value for another field to be recorded as "Yes". I've done this before, and just tried t...
Jay_DDS_'s avatar
Jay_DDS_
Qrew Cadet
9 years ago
So, this is what I was able to come up with:

URLRoot() & "db/" & [_DBID_INTERPRETING_REQUESTS] & "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken= daszufyd548iwsdg4qcshck5ve6b&_fid_118=Yes

But I'm getting this error:

Formula syntax error

Expected a valid expression after the "&"

URLRoot() & "db/" & [_DBID_INTERPRETING_REQUESTS] & "?a=API_EditRecord&rid="&[Record ID#]& "&apptoken= daszufyd548iwsdg4qcshck5ve6b&_fid_118=Yes
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Sorry, A little syntax mistake.  Try this:

URLRoot() & "db/" & [_DBID_INTERPRETING_REQUESTS] & "?a=API_EditRecord&rid=URLEncode([Record ID#])&apptoken= daszufyd548iwsdg4qcshck5ve6b&_fid_118=Yes"

needed to get ride of some &" and add a close quote at the end.  I usually like to use the URLEncode Options as it helps keep things clean in the formula 
  • AnnaHarris's avatar
    AnnaHarris
    Qrew Trainee
    6 years ago
    Ran into an issue that says 

    <qdbapi>
    <action>API_EditRecord</action>
    <errcode>32</errcode>
    <errtext>No such database</errtext>
    <errdetail>
    The application does not exist or was deleted. If you followed a link to get here, you may want to inform the author of that link that the application no longer exists.
    </errdetail>
    <dbid>-b</dbid>
    </qdbapi>

    help? 


    ------------------------------
    Anna Harris
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Anna,
      I'm trying to figure out this new forum.  You seem to be asking for help in debugging a formula URL button but have not posted the code that you are now using,.

      ------------------------------
      Mark Shnier (YQC)
      markshnier2@gmail.com
      ------------------------------