Formula URL Button to Open New Form and Check a Box

Question

I'm not proud, lol. Asking for help with my tail between my legs. I'm missing something here.

I'm in a form in Table "A". I want my button to open a different form in the same table in edit mode and check a checkbox. THAT'S IT! Here's what I currently have:

URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&dfid=14" & "&apptoken=apptoken" & "&_fid_216=1" & "&z=" & Rurl()

Thanks for any suggestions!

MarkShnierYou · Accepted Answer

Its actually a bit complicated because a=er is not an API call, just a cheat we all use and it does not support checking a box.

But you might be OK with checking the box and then editing the record.

not tested but try this

var text CheckBox =

URLRoot() & "db/" & dbid() & "?a=API_EditRecord&rid=" & [Record ID#]

& "&apptoken=xxxxxxxxx"
& "&_fid_216=1";

var text OpenInEditMode = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&dfid=14"

$CheckBox

& "&rdr=" & URLEncode($OpenInEditMode)

Sign up

Login to the community