create a single email with zip file or single pdf

[benny94]

Is it possible to send an email with all the rows of a table in a single pdf or create a zip file containing the individual pdfs?

thanks

[Steve · Accepted solution]

---

@benny94 wrote:

all the rows of a table in a single pdf

---

Yes

---

@benny94 wrote:

create a zip file

---

No

[Marc_Dillon · Accepted solution]

an email with all the rows of a table in a single pdf

---

https://help.appsheet.com/en/articles/961746-template-start-expressions

create a zip file containing the individual pdfs

---

Not possible.

[Koichi_Tsuji]

Your question is unclear, better to elaborate deeper.

[Steve · Accepted solution]

---

@benny94 wrote:

all the rows of a table in a single pdf

---

Yes

---

@benny94 wrote:

create a zip file

---

No

[Marc_Dillon · Accepted solution]

an email with all the rows of a table in a single pdf

---

https://help.appsheet.com/en/articles/961746-template-start-expressions

create a zip file containing the individual pdfs

---

Not possible.

[benny94]

Hello, 

sorry for disturbing.
Inside the pdf I was able to insert all the requests. The problem is as follows:
not a single email is sent, but as many emails as requests.
Is it possible to send 1 email containing the pdf of all the requests?

With the aim of having 1 email with the total report every month

Into pdf, example:

Request nome: lolli
Request Date start: 27/02/2023
Request Date finish: 27/02/2023
Requester email: email1@gmail.com
Request Type: ferie
Status: NOT APPROVED
Request nome: kkkdfd
Request Date start: 27/02/2023
Request Date finish: 27/02/2023
Requester email: email2@gmai.com
Request Type: ferie
Status: NOT APPROVED
Request nome: eeee
Request Date start: 01/03/2023
Request Date finish: 01/03/2023
Requester email: email2@gmai.com
Request Type: ferie
Status: NOT APPROVED
Request nome: Hgh
Request Date start: 01/03/2023
Request Date finish: 01/03/2023
Requester email: email2@gmai.com
Request Type: permessi
Status: APPROVED

[Marc_Dillon]

Turn off the "for every row" option.

[benny94]

if "Turn off the "for every row" " 

I receveid: 
The event and process of the 'Creazione pdf mensile' Bot are not compatible. The output of event 'scheduler' and the input of the process 'Process for Creazione pdf mensile - 1' must be the same table or 'None' in the case of a chat event or scheduled event that is not 'For Each Row'. No "Call Process for each row" step is allowed in the process when using scheduled event

Accept as Solution

[Marc_Dillon · Accepted solution]

The message is telling you that the table your Event is on must match the table that your Process is on.

ForEachRow Events get assigned a table, then when you create a new Step in the Bot, it automatically creates a Process and assigns it to the same table.

But a non-forEveryRow Event is table-less, so you need to change your Process to point to "none" as the table. This is a bit difficult due to how the editor's UI is set up. I believe you have to turn linking on for the Process, then view the Process directly to change it. It's probably easier just to start creating a new Bot from scratch and just copy the details & template over from the existing Task.

[benny94]

I created a new bot from scratch and copied the details and model from the existing activity and it worked.
Thank you