Forum Discussion

ChrisSwirtz3's avatar
ChrisSwirtz3
Qrew Member
2 years ago

Button That Checks a box on a form and then redirects to the app homepage

I have a button with the following code that does check the box but instead of taking me to the app home page it takes me to a page with some code on it that is pasted below the formula. I have tried several variations of the end of the formula for the redirect but so far no luck on that part.

URLRoot() & "db/" & Dbid()
& "?a=API_EditRecord"
& "&rid=" & [Record ID#]
& "&_fid_1152=yes"
& "&rdr"
& URLEncode("https://georgiabuildingauthority.quickbase.com/db/bka89j884")


<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>11541</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1652985137631</update_id>
</qdbapi>


------------------------------
Chris Swirtz
------------------------------

4 Replies

  • It doesn't like the redirect. Probably the http:// but better practice is to use the URLRoot() command so try:

    & URLEncode(URLRoot() & "db/bka89j884")

    URLRoot will always put yourdomain@quickbase.com

    ------------------------------
    Mike Tamoush
    ------------------------------
    • ChrisSwirtz3's avatar
      ChrisSwirtz3
      Qrew Member
      Thanks Mike, I do think I had tried this already but I tried it again. The check box worked but the redirect still took me to the code page that read.

      <qdbapi>
      <action>API_EditRecord</action>
      <errcode>0</errcode>
      <errtext>No error</errtext>
      <rid>11541</rid>
      <num_fields_changed>1</num_fields_changed>
      <update_id>1652987789802</update_id>
      </qdbapi>


      ------------------------------
      Chris Swirtz
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        Oh I just realized you are missing the = sign. The original may have worked.

        "&rdr="


        ------------------------------
        Mike Tamoush
        ------------------------------