Skip to main content
Question

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

  • February 15, 2021
  • 0 replies
  • 52 views
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
------------------------------
Thank you for your help! Davy Ou, Quantitative Financial analyst Certified QuickBase Developer, Lifetime learner https://www.linkedin.com/in/davyou/
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Qrew Cadet
  • February 15, 2021
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
------------------------------
KeithJusas
Forum|alt.badge.img+7
  • KeithJusas
  • Registered
  • February 17, 2021
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
------------------------------
Terms & ConditionsAccessibility statement