Forum Discussion
MikeTamoush
3 years agoQrew Commander
I 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
------------------------------
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_AnnAiken3 years agoQrew 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
------------------------------- MikeTamoush3 years agoQrew 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
------------------------------- Shelly_AnnAiken3 years agoQrew MemberHi Mike,
now it run with no error. However it did not check the checkbox on the form before saving and going back to table home page. what am i missing?
------------------------------
Shelly Ann Aiken
------------------------------