Forum Discussion

Shelly_AnnAiken's avatar
Shelly_AnnAiken
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
MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago
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
------------------------------
  • Shelly_AnnAiken's avatar
    Shelly_AnnAiken
    Qrew Member
    3 years ago
    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's avatar
      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's avatar
        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
        ------------------------------