Forum Discussion

Qrew Member

3 years ago

Need Help creating a formula button to check a box then return to table home page

Hi, I am new to this. How do i create a button on a form called Archive so that when pressed, it will check a hidden archive checkbox then return to table home page. ----------------------------...

APIs and custom code

Buttons

Shelly_AnnAiken

Qrew Member

I 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
------------------------------

MikeTamoush

Qrew Commander

3 years ago

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
------------------------------

Shelly_AnnAiken
Qrew Member
3 years ago
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
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  Shelly, 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
  ------------------------------
  - MikeTamoush
    Qrew Commander
    3 years ago
    Thanks 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
    ------------------------------