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