(Andrea Sala) #1


Hello! Thanks in advance for your kind help. Please help… I’m feeling close to my goal, but I’m stuck

Atm …


Is it possible to automatically record the value of built in variables inside a spreadsheet?


A) https://help.appsheet.com/behavior/workflow-sending-email/template-variables

B) https://help.appsheet.com/behavior/workflow-sending-email/sending-email-from-a-workflow-rule-or-scheduled-report

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%2FMyAttachmentName20171107_133355_804.pdf&appVersion=1.000001

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

(Andrea Sala) #2

Is it actually feasible or not?

If not

is it kindly possible to ask for a feature request?

Thank you very much.

(Andrea Sala) #3

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?

(Aleksi Alkio) #4

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.

(Andrea Sala) #5

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?

(Aleksi Alkio) #6

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.

(Andrea Sala) #7

That’s it. Sure,

thank you very much

(Aleksi Alkio) #8

You’re welcome