Hello Appsheet community,
I have a problem sending emails with one or more image attachments.
The email is always sent but without the attachments that I would like to deliver.
The data source of the App is a Google Sheet.
The email sending is executed by a bot, which is triggered when a new entry in the sheet “BAU_RECORDS” is added.
However, the path to the attachment(s) is stored in a sheet named “BAU_ATTACHMENTS”. The link/join between these two sheets is a ref column in the sheet “BAU_ATTACHMENTS”. If there are multiple attachments for one row in the sheet “BAU_RECORDS”, that many rows are added in the sheet “BAU_ATTACHMENTS” with the same REC_ID from the sheet “BAU_RECORDS”.
I know that you can change the default app folder in the info tab:
I tried already all kinds of combinations for the default app folder and the expression in the Other Attachments tab of the bot.
Nothing worked with an expression, I only managed to make it work with plain text of a file name of an image and the appropriate default app folder. Unfortunately this is not sufficient, as I always want to send the new images of the entries and not a static image.
Here are some examples of the expressions I tried in the Other Attachments tab of the bot:
When changing the result of the folder path I always changed the default app folder in a way that it should work.
Any help would be appreciated!