Forum Discussion
- MikeTamoushQrew CommanderI think this should do it. Put this in a formula URL field and choose the selection to have it be a button.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxxxx" &
"&_fid_59=1" & //this is the checkbox field
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td")
------------------------------
Mike Tamoush
------------------------------- Shelly_AnnAikenQrew MemberI am still getting error. I am still new to this. 529 is the field ID for checkbox field
Error: There are extra characters beyond the end of the formula.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=cd9d9ctqt3qb2jdr7mybtrmbsf" &
"&_fid_59=1" & "&_fid=529" //this is the checkbox field
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td")
------------------------------
Shelly Ann Aiken
------------------------------- MikeTamoushQrew CommanderIs your checkbox field 259? If so:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx" &
"&_fid_259=1" & //259 is the checkbox field, 1 just means set it to true, or set it to checked
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td")
------------------------------
Mike Tamoush
------------------------------