I have a Create File Bot that requires today's date at the end of the file name but when the file is created it creates subdirectories due to the "/". Is there a specific syntax I should be using to have this not create the subdirectories?
"Inventory/"&[Division].[name]&"_"&Today()
should be file name "General-01/26/2022" but it created this in the subdirectories
Yes, in case you use / for the file prefix, it means the you are asking to make sub folder. If you wish to have data value in the file name, then dont use / for that part. Instead, the expression could be
"Inventory/"&[Division].[name]&"_"&TEXT(Today(), "MM-DD-YYYY")
Thanks Tsuji, I'll give it a try and report back
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |