Formula URL Button to Open New Form and Check a Box
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!
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)
