Skip to main content
Question

How to add to my url formula button that changes a checkbox to ""true"

  • July 16, 2020
  • 0 replies
  • 247 views
I am trying to create a url button that will take a user to the related form and check off a checkbox. My current formula is not working for some reason:

I am in the Jobs table (_DBID_JOBS) when I select the button, the checkbox I am trying to change is also located in the Jobs table. Once the user selects the button (They will be selecting from a report) I would like them taken to the related jobs form and would like the field ID 1146 to change to "checked". 

URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job] & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Maximum Related Job] &"apptoken=b5migf_nhwb_uwejxvbfjbg42bcg4aecdf5rk4b"
&"&_fid_1146=1"

------------------------------
Wallace (DHS)
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
  • IvanWeiss
  • Registered
  • July 16, 2020
Flip around the display record.  You do not display it first, the API can edit the record and you can display it after

rewrite the formula completing your api edit record first.  After that put an & next line should be
"&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job]);

You complete the action and use the rdr to navigate after that.

------------------------------
Ivan Weiss
------------------------------
Terms & ConditionsAccessibility statement