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

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

Solved Solved
0 13 371
2 ACCEPTED SOLUTIONS

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.

 

View solution in original post

Please share a screenshot of bot test detail.

But i think that the problem is in second part of your formula condition:

"I wrote the condition in the bot to count (select) all id from table 1 where column Y='finished" that should be equal to count all id from table 2 where column Y (I also have the same column in the table 2) is="finished"; the expression is valid."

Your table 2 always will have column Y="finished" so, this column is unnecesary

I think that your condition have to be simple as i was mencionated:

  • 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]) )

 

 

View solution in original post

13 REPLIES 13
Top Labels in this Space