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.
Solved! Go to Solution.
Please try with TEXT() expression
<<TEXT([Date],“YYYY-MM-DD”)>>_<<[Equip_ID]>>.pdf
Please try with TEXT() expression
<<TEXT([Date],“YYYY-MM-DD”)>>_<<[Equip_ID]>>.pdf
so simple!! thanks
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |