What are these 3 digits on the end of this fi...

workflow
(Aaron Moolb) #1

What are these 3 digits on the end of this file name “_491” and how do I get rid of them?

I am archiving the file and my file name has the following expression:

<<[Quote ID]>>, <<CONCATENATE(MONTH([Date]),DAY([Date]),YEAR([Date]))>>, <<[Quote Number]>>, <<[Business Name]>>, Quote, <<CONCATENATE(HOUR(TIMENOW() - “00:00:00”),MINUTE(TIMENOW() - “00:00:00”),SECOND(TIMENOW() - “00:00:00”))>>

(Philip Garrett) #2

@Aaron_Moolb

See topic “Attachment Archive” in this article help.appsheet.com - Sending Email from a Workflow Rule or Scheduled Report Sending Email from a Workflow Rule or Scheduled Report help.appsheet.com

(Aaron Moolb) #3

@Philip_Garrett_Appsh How can I get rid of those with an expression? Maybe similar to what I am currently using…

(Philip Garrett) #4

@Aaron_Moolb

AppSheet is generating the entire PDF date/time suffix as described in the article. You have no control over that.

You can retrieve the _ATTACHMENTFILENAME and display it in your workflow Body or Attachment.

(Aaron Moolb) #5

@Philip_Garrett_Appsh Thanks, I was trying to avoid script. No biggie

(Philip Garrett) #6

@Aaron_Moolb Sorry