Create a button to change the value of another field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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?
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
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
Photo of Matthew Neil

Matthew Neil

  • 31,418 Points 20k badge 2x thumb
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 
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
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?
Photo of Matthew Neil

Matthew Neil

  • 31,418 Points 20k badge 2x thumb
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
Photo of Leslie G

Leslie G

  • 248 Points 100 badge 2x thumb
I've tried to do the same thing, with the same error. Jay -- any solution?
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
meet the same problem