I am using a concatenation to refer to a file attachment that was saved in another workflow, saved on Drive, in the default folder for the app.
CONCATENATE(โFiles/โ,(RIGHT(YEAR(NOW()),4)),IF(MONTH(TODAY())<10,CONCATENATE(0,MONTH(TODAY())),MONTH(TODAY())),IF(DAY(TODAY())<10,CONCATENATE(0,DAY(TODAY())),DAY(TODAY())),Daily_Warning,".csv")
Which results in:
Files/20190327Daily_Warning.csv
But I canโt get the report to find the file. Is it the syntax that is wrong?
I am not certain I understand. Are you saying that the file you are trying to attach to the Report email was uploaded by the AppSheet application via a File field?
File created from another report.
Report 1 - Creates csv from template with the concatenated name.
Report 2 - 10 minutes later emails out the csv created.
The file is named correctly, and in the right folder, I just get the error when report 2 triggers:
โErrorsโ: โError: Workflow attachment file โFiles/20190327Daily_Warning.csvโ not found due to: Object reference not set to an instance of an objectโฆโ,
I have tried referring to this file in the โother attachmentsโ of report 2 in many different ways, Iโm not sure how to get the report to find this file.
Ideas?
See topic " Constructing an Attachment File URL" in this article https://help.appsheet.com/behavior/workflow-sending-email/email-pdf-attachment-archiving
Using that format, I can get a url to download the file, but it isnโt as a .csv anymore, and it isnโt named. This also doesnโt let me attach it to the email as a file. I didnโt expect this to be so hard lol
I got it to work in a different way! No report 1, just an email using the csv template for the attachment, and making the attachment name end in .csv wow, thank you for your help.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |