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.

------------------------------
Shelly Ann Aiken
------------------------------
  • 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
      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
        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
        ------------------------------