<<_BUILT IN VARIABLES>> and PDF WORKFLOW @Aleksi_Alkio
Hello! Thanks in advance for your kind help. Please help… I’m feeling close to my goal, but I’m stuck
Is it possible to automatically record the value of built in variables inside a spreadsheet?
SCENARIO: 1- I have a workflow rule that sends a PDF attachment via email
everytime a new row of record is added.
2 - In the workflow menu I’ve checked the option “archive as PDF” in order to keep a copy of the PDF in Google Drive.
3- In email body I have a built-in variable: <<_ATTACHMENTFILE_URL>>. Said variable is the URL of the PDF and has the following structure: - Prefixed “https://www.appsheet.com/template/getappfileurl?appName=appName-111111&fileName=Attachments%2F” - Attachment Name you specified in Appsheet, - Suffixed with the system generated date and time formatted as “yyyyMMdd_HHmmss_fff” where “fff” is milliseconds. - Suffixed the current app version.
4- I have got the URL of the PDF attachment in the template (Great!) but I need it stored in my sheet. Now: How to automatically record that url in a column of my spreadsheet??
Thank you very much for your helpfulness Andrea