Attach and Archive problem when Saving file with date in filename

Hi All,

I have this unwanted behaviour - if the filename contains [Date] then when it “Attach and Archives” the attachment it reads the date as part of the file path, and not as part of the filename.

I am using UK locale in google sheets and in appsheet. e.g. 31/07/2020. It archives into google drive.

example:

Attachment folder path: CONCATENATE(“EquipmentInspections/”,[Region],"/",[Equipment_ID])
(no problem with this)

filename: [Date]_[Equipment_ID]>>.pdf

Appsheet parses the [Date] as part of the folder path so I get this path instead:

Desired output: EquipmentInspections/North/Equip_123
Actual output: “EquipmentInspections/North/Equip_123/31/07/2020/” then the filename.pdf

To work around this I tried:

<<YEAR([Date])>>-<<MONTH([Date])>>-<<DAY([Date])>>_<<[Equip_ID]>>.pdf

and it gets close but the filename is shown as:
2,020-07-31_Equipment123_datestamp.pdf
there is an unwanted comma.

How can I fix this.

Please try with TEXT() expression

<<TEXT([Date],“YYYY-MM-DD”)>>_<<[Equip_ID]>>.pdf

4 Likes

so simple!! thanks

2 Likes