Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
2 years ago

Button to check a box and then redirect to generate an Exact Forms doc

I need help to accomplish the redirect to the Exact Forms doc generation. Here is what I tried but not correct:

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&apptoken=cav92prc9it7rfdfbvc32xuy2vj" &
    "&_fid_172=1" &
    "&rdr=&URLencode("https://www.aws-juiced-client2.com/Juiced/ExactFormsPlus10/doc_merge_ua.aspx?"
& "request="
& Base64Encode("clientid=Q2683"
& "&appid=" & AppID()
& "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES]
& "&tpid=2"
& "&fn=BoM Purchase Order"
& "&msid=" & URLEncode ([Record ID#])
& "&msdb=" & Dbid()
& "&faid=58&efpdte=59"
& "&docfmt=doc&stream=y"
& "&apptoken="))



------------------------------
George Bramhall
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    What is the symptom of the problem?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      2 years ago

      I get this error:



      ------------------------------
      George Bramhall
      ------------------------------
      • GeorgeBramhall2's avatar
        GeorgeBramhall2
        Qrew Cadet
        2 years ago

        The generate the PO doc code starting with "https://www.aws-juiced-client2.com/Juiced/ExactFormsPlus10/doc_merge_ua.aspx?" works fine on it's own, but when I insert the check box code and then try to redirect I get the error.



        ------------------------------
        George Bramhall
        ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      2 years ago

      Figured out. 

      var text checkboxone= URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
          "&rid=" & [Record ID#] &
          "&apptoken=cav92prc9it7rfdfbvc32xuy2vj" &
          "&_fid_172=1";

      var text exactformone="https://www.aws-juiced-client2.com/Juiced/ExactFormsPlus10/doc_merge_ua.aspx?"
      & "request="
      & Base64Encode("clientid=Q2683"
      & "&appid=" & AppID()
      & "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES]
      & "&tpid=2"
      & "&fn=BoM Purchase Order"
      & "&msid=" & URLEncode ([Record ID#])
      & "&msdb=" & Dbid()
      & "&faid=58&efpdte=59"
      & "&docfmt=doc&stream=y"
      & "&apptoken=");

      var text checkboxtwo= URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
          "&rid=" & [Record ID#] &
          "&apptoken=cav92prc9it7rfdfbvc32xuy2vj" &
          "&_fid_172=2";

      If([PO Doc Generated]=false, $checkboxone
      & "&rdr=" & URLEncode($exactformone),$checkboxtwo
      & "&rdr=" & URLEncode($exactformone))



      ------------------------------
      George Bramhall
      ------------------------------