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