Attachment Path Question - Having Issues with Subfolders

[mykrobinson]

I am trying to get reports generated through automation to always dump into a specified folder. I figured out getting them into a specified folder, but multiple subfolders are being created inside the specified relative path.

Here's what i have in the archive path declaration:

What i expect is for all files generated by this automation to be placed inside UserGeneratedSeenByProviderReports, but what i get is a path that is so long that Google Drive refuses to show it 😂

So how do i get my files to just be in that top level relative path i defined?

Thanks,

[koma25]

I noticed that there is a limit on the length of the file names, I don’t know if it’s from Google or from the appsheet side. maybe the same applies to folders

[mykrobinson]

Thing is, it seems to be creating very short subfolder names. The way it is dividing the thing into folders that i didn't even request is quite puzzling 🤔

[koma25]

It seems to me that the simplest thing you can try is to shorten the folder name and look at the result

[mykrobinson]

I think @Marc_Dillon has the solution below. The dates in my file name have slashes and the slashes are crating subfolders.

[Marc_Dillon]

Default date format has slashes in it. Slashes create subfolders when used in a file name. Remove the slashes from your dates, perhaps with TEXT().

[mykrobinson]

Brilliant! I totally didn't think about that but it makes sense, it's creating subfolders because its encountering slashes! 

Thank you!