issues using Automation generate pdf with multiple rows using <<Start>> <<End>> and send by email

[Ruxandra]

Hello!

I used <<Start>> <<End>> in a template to generate pdf with multiple rows in a table; it works, I have dynamic rows added in my table designed in the template.

In my automation I set to send email for "Adds" in the Db table.

But, I have two  problems:

1. I receive as many emails as there are rows generated inside <<Start>> <<End>> expression; for example; if the pdf file has in the designed table 5 rows, I receive 5 emails instead of only one;

2. first emails do not contain all the rows from template because the sync is in progress (it takes some time to write in the appsheet DB that I use for).

Could someone help me with some suggestions to solve these problems (have only one email sent and only after all data is saved in the DB?

Many thanks!

Regards!

Ruxandra

[MiguelPilo · Accepted solution]

I have some suggestions for your case:

1. The "Data change type" of your bot need to be Updates (Wait fot condition at the end).
2. Add a new row in your table of chemicals test [Select_test].
3. Action 1. Create an action to set values in [Select_test]=IF([Select_test]="Selected", " " ,"Selected") Could be display inline attached to [Select_test]
4. Second action: add a new row to a another table (you already have this)
5. Third action: Execute an action on a set of rows; For a record of & Referenced Table: "Chemicals test";
   Referenced Rows: Select( Chemical test[Key Column], [Select_test]="Selected"); Referenced Action: Add a new row to a another table "Second action"
6.  Create a Format Rule to easy visual identification of Selected rows.

I imagine that rows copied in second table include a "order number" column or something like this. So the next is formulate de condition for your bot: 

• Condition (Compare number of selected test and number of lines in this order):
  Count( Select( Chemical test[Key Column], [Select_test]="Selected") )=
  Count( Select (Table2[key Column],[Order_number]=[_Thisrow].[Order_number]) )

If you want to use the action 1 and action 3 at the same multi selecting rows, add a new grupped action.