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