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! Go to Solution.
I have some suggestions for your case:
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:
If you want to use the action 1 and action 3 at the same multi selecting rows, add a new grupped action.
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:
User | Count |
---|---|
20 | |
13 | |
8 | |
3 | |
2 |