<<_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
Atm โฆ
QUESTION:
Is it possible to automatically record the value of built in variables inside a spreadsheet?
DOCUMENTATION:
A) https://help.appsheet.com/behavior/workflow-sending-email/template-variables
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.
For example: https://www.appsheet.com/template/getappfileurl?appName=appName-111111&fileName=Attachments%2FMyAtta...
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
Is it actually feasible or not?
If not
is it kindly possible to ask for a feature request?
Thank you very much.
My best guesses:
1 - a CONCATENATE expression: but Iโm having some difficulties in calculating the millisecond (Iโm not an expert at all).
2- a LINKTOFORM expression: in order to create a deep link that automatically populate a table with the <<_ATTACHMENTFILE_URL>>.
P.S.:Is it possible to use placeholder in deep links?
The problem with the formula is you donโt know the time value before the pdf is created. Thatโs why this kind of functionality is not possible at this moment as far as Iโm aware of it.
Thank you. Can you please help me understanding why is it possible to get the URL via a built-in variableโฆ but itโs not possible to have an expression?
If I remember correctly the workflow is created and sent after the saveโฆ and thatโs why itโs not possible to save it into the spreadsheet or database.
Thatโs it. Sure,
thank you very much
Youโre welcome
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |