Forum Discussion
MikeTamoush
Qrew Commander
Is 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
------------------------------
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_AnnAiken
3 years agoQrew Member
Hi 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
------------------------------
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
------------------------------
- MarkShnier__You3 years agoQrew ChampionShelly, you need to set the field to be updated to match the Field ID of your checkbox field. Think some digits were transposed.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx" &
"&_fid_529=1" & //529 is the checkbox field, 1 just means set it to true, or set it to checked
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MikeTamoush3 years agoQrew CommanderThanks Mark.
Shelly, Mark is likely correct. The 529 should be the field ID of your checkbox. I accidentally transposed them when correcting your formula.
------------------------------
Mike Tamoush
------------------------------- Shelly_AnnAiken3 years agoQrew Member529 is the correct field ID. But it's not being checked and saved before the form closes - by clicking the formula button
------------------------------
Shelly Ann Aiken
------------------------------