How to automatically link record templates to file upload fields in Zoho Creator?

[@Zoho_Creator]

Thanks to Simon (Zoho Creator Tech Star) for pointing out a subtle but important detail regarding the URL format! In case anyone runs into any issue, the correct URL structure for fetching PDFs should look like this: // Construct the URL with the correct format for the record PDF ConstructedUrl = "creatorapp.zohopublic.com/c6demo/zylker-home-appliances/record-pdf/All_Orders/" + input.ID + "/Invoice/Pxe1ug2V1bBGEsp08BUCPxY80Pxky8d3S5QD0NE7DOquvDXK8ShZzhy3hk35rsEZOuYWw6K4t5KEfVGVCwWQ37eUVPybEwk4MT47"; // Use invokeUrl to fetch the PDF data from the constructed URL InvoiceData = invokeUrl [ url: ConstructedUrl type: GET ]; // Save the fetched data to the Invoice field input.Invoice = InvoiceData; This change ensures that /record-pdf/ is placed correctly in the URL and /report-perma/ is removed, which should solve the issue some might encounter. Hope this helps!

[@AceTester777]

nice video. but may i know, is it a must to publish the report? is it possible for me to get the url of the template without publishing the report. for example, maybe we can use connection instead of publishing report. Looking forward for your answer

[@Zoho_Creator]

Thank you for your question! Yes, currently, publishing the report is necessary to access the URL directly. Using a connection in place of a published report isn’t an option for accessing the template URL directly. However, if you'd like more control over access, you can restrict visibility to specific users or groups even when a report is published.

[@simonwhitebridge5615]

The video is not 100% accurate as if you notice the url that is pasted into the deluge script is slightly different from the url that is copied when the report is published. /record-pdf/ is required to be inserted before the report name and /report-perma/ needs to be removed. Having said that the video is good and the solution solves an issue that many people struggle with. If anyone needs any assistance with Zoho then let me know - Simon (winner of Zoho Creator Tech Star in Education Award 2020 and 2021)

[@Zoho_Creator]

Thank you for your detailed feedback, Simon! You’re absolutely correct-when constructing the URL, it’s essential to modify it by adding /record-pdf/ and removing /report-perma/ to ensure the link functions correctly. I appreciate you highlighting this, as it can be easy to miss those details. Glad to hear the solution helps address a common challenge, and congratulations on your achievements as a Zoho Creator Tech Star!