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