Hi
I have created an automation where i create a pdf and then try and email it.
The pdf creates perfectly and the email goes out just with no attachment. I even put a delay between the steps to see if it was executing too quickly.
My pdf is CONCATENATE(“New_Starter_”, [Full Name].[First Name],“_”,[Full Name].[Surname])
in folder “NewStarterPDFs”
and my mail attachment is
CONCATENATE(
“NewStarterPDFs/”,
“New_Starter_”,
[Full Name].[First Name],
“_”,
[Full Name].[Surname],
“.pdf”
)
Can anyone see if i have missed something ?
Is the PDF being stored in a file type column in the app and if so, are you able to open it from that file column?
Also could you mention in which setting of the automation pane you are storing the email attachment path and that is the folder “NewStarterPDFs” in the root folder of the app? This means does the folder “NewStarterPDFs” reside in the same level where the Google sheet of the app resides if you are using a G sheet as backend.
I am using a database as the backend but i also store a signature generated from appsheet and that is in the same location. I do store the file name in a file type but it can not open it
I changed the method and did not create the pdf first .. just created it at part of the email and it worked perfectly .. even better as i do not really want a copy hanging around