URL Button to check/uncheck a check box
Is it possible to use conditional logic with an api call? I would like to create a URL button to check or un-check a checkbox depending on the state it is in
Forum Discussion
Hi Jorden,
Yes, you can.
Please have a look at the sample formula:
Replace _fid_101 with your field Id and [Checkbox] field with your checkbox field name.
Please let me know if this works for you and need any further help.
Thanks,
Gaurav
Yes, you can.
Please have a look at the sample formula:
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & If([Checkbox]=true, "&_fid_101=0", "&_fid_101=1") & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])
Replace _fid_101 with your field Id and [Checkbox] field with your checkbox field name.
Please let me know if this works for you and need any further help.
Thanks,
Gaurav
Jordan,
Please have a look at the Mark Answer. He did the exact thing which you are asking. Also, that formula will work in all your scenarios whether you are triggering from the table or form it will redirect back to your original position.
Please go ahead with that.
Thanks,
Gaurav
Please have a look at the Mark Answer. He did the exact thing which you are asking. Also, that formula will work in all your scenarios whether you are triggering from the table or form it will redirect back to your original position.
Please go ahead with that.
Thanks,
Gaurav