Skip to main content
Question

Create a button to change the value of another field

  • February 24, 2017
  • 0 replies
  • 285 views
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 to copy the forumula-url I used before but that didn't really work.

Help?
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • February 24, 2017
      What is the field ID of your "Yes" field?  What its your Table ID? 

      You will use the API Edit Record function, but you will need the DBID, the FID and an app token.  All of which can be found through the settings of your app.

      The general format will be:

      URLRoot() & "db/" & [_DBID_YOURTABLEID] & "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=yourapptoken&_fid_22=yes

      *where your field id of the yes field is 22, you will need to change that to match yours.
      • JayDDS
      • Author
      • Registered
      • February 24, 2017
      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
      Terms & ConditionsAccessibility statement