Forum Discussion

DavyOu1's avatar
DavyOu1
Qrew Trainee
5 years ago

QuickBase Juiced Tech URL to generate document while the template and the URL field are in different applications

Hi community,

I have a question about setting up a formula URL using Juiced Tech to generate a document in an application referring the template stored in another application.

I used the code that usually works when the template and the generate button are in the same app, but I could not get it to work when referring the template in another application. Please see below codes and let me know how I can get it to work.

Thanks in advance! 

"https://www.quickbaseutilities1.com/xxx_W230/DocumentMerge/doc_merge_UA.aspx?"
& "clientid=W230" // Our company client id
& "&appid=bq5nuxsac" // Application where the template is stored
& "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES] // Target database ID where the templates are stored
& "&tpid=19" //Template id
& "&fn=Sales_Order" //The table that I want to generate the document
& "&msid=" & URLEncode ([Record ID#]) 
& "&msdb=" & Dbid() 
& "&faid=132&efpdte=133" // File attachment and generated date fields
& "&addfiles="
& "&docfmt=pdf&stream=y"
& "&apptoken=d8v8cjiaafvwet546bc93xcsx7dam" // Application token to access the application that stores the template

------------------------------
Davy Ou
------------------------------
Wizards and add-ons
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    5 years ago
    Davy,

    Use the actual Table ID.  Go to the application where the table exists and get it from the URL at the top it will be 

    yourrealm.quickbase.com/db/XXXXXXXX?a=td

    You want the value that is XXXXXXX


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      This could also be due to you not having permissions from Juiced to use their add-on in multiple apps. Juiced add-ons only work the app you registered them, and then you pay an extra fee to use them in additional apps (though they recently sent an email indicating this will be changing in the next month or so).

      ------------------------------
      Mike Tamoush
      ------------------------------
  • KeithJusas's avatar
    KeithJusas
    Qrew Captain
    5 years ago
    Davy
    the appid should reference the application where the document will be created and NOT the application where the template lives.  So use appid() in the appid= parameter 
    for the tpdbid= do not use the table alias since that will refer to the table in the current app, use the actual dbid of the table in the other application.
    make sure the user token you're  using has access to both apps.


    ------------------------------
    Keith Jusas
    CEO
    Juiced Technologies, Inc.
    Ronkonkoma NY
    6316175060
    ------------------------------
    • KeithJusas's avatar
      KeithJusas
      Qrew Captain
      5 years ago
      One more point...I don't recommend using an external table to store the templates as our EFP Configurator utility used to assist in building your subtable configurations CANNOT cross apps.  So you would have to manually build out your subtable config settings which can be done but is not simple.  Much easier to use a local templates table for this reason

      ------------------------------
      Keith Jusas
      CEO
      Juiced Technologies, Inc.
      Ronkonkoma NY
      6316175060
      ------------------------------