Missing Other Attachments stops email from sending

AppSheet AppSheet Q&A
,
1

I have an Other Attachments formula that looks like this:

CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”)

The send an email automation works fine if the file is found. But if a user doesn’t create the file, the automation fails and the email won’t send. This can happen.

Is there a different way to structure this so that if the file isn’t found, the automation still runs?

2

Please try below

First solution suggestion;

in the other attachments setting, please try the following expression

IFS( ISNOTBLANK(INDEX( SPLIT(CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”), “Files/”), 2)),

CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”)

)

If the above suggestion does not work, then please try below

Second solution suggestion:

You could create 2 different bots

  1. Bot 1 when the attachment file is available.

The event condition for this bot will be

ISNOTBLANK(INDEX( SPLIT(CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”), “Files/”), 2))

This bot will have the other attachment setting path as

CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”)

  1. Bot 2 when the attachment file is NOT available.

The event condition for this bot will be

ISBLANK(INDEX( SPLIT(CONCATENATE(“Files/”,“HighSpeedDoorPMChecklist”,“-”,[JobNumber],“.pdf”), “Files/”), 2))

This bot will NOT have other attachment setting but will have other email sending settings as the bot in point 1 ) above,

Basically when the attachment is available, the bot in point 1) above will fire and when the attachment is not available, the bot in point 2) will fire.