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
        ------------------------------
  • Jay_DDS_'s avatar
    Jay_DDS_
    Qrew Cadet
    9 years ago
    So, my syntax issue is fixed, but now I'm getting this error:

    API_EditRecord
    24
    Invalid Application Token
    An Application Token must be supplied.

    I did create a new app token and replaced the apptoken above, but I still get this message. Any ideas?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    Sometimes I accidentally get a space placed after the = sign and before the actual token,  this can cause some errors.

    apptoken= xxxxxx   (bad)
    apptoken=xxxxxx    (good)

    Just an idea
  • LeslieG's avatar
    LeslieG
    Qrew Cadet
    9 years ago
    I've tried to do the same thing, with the same error. Jay -- any solution?
  • Liangxie's avatar
    Liangxie
    Qrew Cadet
    8 years ago
    meet the same problem