DavyOu1
4 years agoQrew Trainee
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
------------------------------
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
------------------------------