Hi all, I have a simple but very frustrating issue when I specify โOther Attachmentsโ in a workflow. The file path is being included in the file name. For example, my workflow saves โExample.pdfโ to the correct location without an issue. It even attaches the file to the email, no problem. However, in specifying the file path to the file in the โOther Attachmentsโ field, somehow my file gets renamed once it attaches to the email. So โExample.pdfโ becomes โProjects/Payroll/Example.pdfโ on the actual email attachment.
If anyone can help me with this it would be greatly appreciated, Iโve tried all the troubleshooting I can think of. Whenever I try messing with the file path in the โOther Attachmentsโ field the workflow fails to find the file since it is within a subset of folders.
My app ID is Timekeeping-1049060 and my account ID is 1049060
The expression Iโm using in the other attachments field is:
#This is the file path
concatenate(โPayroll Filesโ,"/",[jobsite].[label],"/",if(len(text(month([Week Ending]-6)))<2,โ0โ&month([Week Ending]-6),month([Week Ending]-6)) &"-"& if(len(text(day([Week Ending]-6)))<2,โ0โ&day([Week Ending]-6),day([Week Ending]-6)) &"-"& if(len(text(year([Week Ending]-6)))<2,โ0โ&year([Week Ending]-6),year([Week Ending]-6)),"/")
&
#This is the file name
year([Week Ending])&"-"&switch(month([Week Ending]), 1,Jan, 2,Feb, 3,Mar, 4,Apr, 5,May, 6,Jun, 7,Jul, 8,Aug, 9,Sep, 10,Oct, 11,Nov,Dec, )&"-"& if(len(text(day([Week Ending])))<2,โ0โ&day([Week Ending]),day([Week Ending]))&"_"& year(now())& if(len(text(month(now())))<2,โ0โ&month(now()),month(now()))& if(len(text(day(now())))<2,โ0โ&day(now()),day(now()))&"_prhourspage.csv"
Solved! Go to Solution.
@Phil fixed this and did a rollout that just took effect for me today. Each of my files is now saving to the correct subfolder and is also being attached perfectly to the outgoing email with the correct file name.
I have a relatively complex workflow that saves 3 files to a variable file folder path, and then attaches those files to an outgoing email. Itโs working perfectly!
@Phil fixed this and did a rollout that just took effect for me today. Each of my files is now saving to the correct subfolder and is also being attached perfectly to the outgoing email with the correct file name.
I have a relatively complex workflow that saves 3 files to a variable file folder path, and then attaches those files to an outgoing email. Itโs working perfectly!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |