Reports are running more than once

I understand that it’s confusing.

Try to read about each of the parts around automation:

Bots: The Essentials | AppSheet Help Center

Process: The Essentials | AppSheet Help Center

Event: The Essentials | AppSheet Help Center

Step: The Essentials | AppSheet Help Center

Task: The Essentials | AppSheet Help Center

Anyway, your process has no table.

But as far as I know it doesn’t need it because those are scheduled reports.

Again, be careful before changing anything

1 Like

Yeah. Since they are all “scheduled” - None is I guess the required entry. I will see if this all works now.

Thanks

Ok. It seems to have cut it down from 4 emails to 2?

But why two?

Are you sure that the emails aren’t duplicated on to, CC, BCC?

I don’t know if that could be related but maybe..

1 Like

Yeah - see below. This is one of the bots:

Here are the bots - snapshots:

Btw, this is a bot that should trigger for different locations?

Have you tried by making just 1 BOT and then branch on conditions to select which task should be executed?

2 Likes

This is 5 different bots. They basically do the same thing. Except each bot calls a slightly different email template. In the templates I specify the location. I have not tried cutting back to just one.

Can we use multiple bots per app? Again, this is 5 bots for one app. They are basically doing the same thing. However, each calls a different email template. So they are 5 different bots. Is this not ok to do?

1 Like

I think the question is this not okay to do is very subjective and should be looked at on a case-by-case basis.

What is efficient or easy to process for individuals may or may not be the best way to “program” a task in terms of platform (for a lot of different reasons such as speed, sync times, data integrity, etc.)

The question we should all ask ourselves is “Is there a better way to do this”.

Even without knowing the differences in your templates, I strongly would advise getting as close to one automation/bot as possible. You can achieve this with conditions, “dynamic” expressions and even third party integrations!

1 Like

I do not know how to write an expression to choose which email to send per [location_code] using one bot.

You can make one bot that triggers at 09:00 am.

Then you can have a step that branches on a condition to decide if a task should be executed and a step to a task if that condition is yes or no.

Then you can have multiple of the above step pairs as needed.

I have one bot that sends a certain generated pdf to different emails and create 4 emails in the process to different people that shouldn’t know about each other’s emails

1 Like

Ok. I see what you are talking about. However, I can’t make a condition because it is not looking at a table - its a scheduled event:

What do you see when you look in Audit History?
https://help.appsheet.com/en/articles/5317105-troubleshooting-emails
The Audit History is almost always the first place to look when trying to diagnose workflow emails.

1 Like

It shows each bot twice:

Audit History shows each scheduled bot running once. There are two audit records because the first reflects the start and the second reflects the finish of the bot.

1 Like

so technically its right? Why do i get multiple emails PER bot?

The Audit History lists the people who will receive the email in the audit record.
What does it contain?

1 Like

It shows each bot - twice. One per process then one per task. But it ONLY shows my email under users (I blacked them out)?

Something I am noticing, I have a process emailing and the task? Is that right?

Process:

Task: