Report Generation

Hi,

I have suppliers table and orders tables. I wish to send an email everyday at a fixed time to all the suppliers individually the list of pending orders on them.

How do i achieve this.

Please advice.

Hi @Rahul_Sanghavi

On your Orders table, if each order is correctly linked to the Supplier table, then you will want to use a bot, from the Automation panel.

This bot will run against the Supplier table.

I suggest you go in the Automation panel, starts with a suggested Bot, and adapt it to your need.

For reference:

https://help.appsheet.com/en/articles/4865326-bots-the-essentials

https://help.appsheet.com/en/articles/4865380-event-the-essentials

Feel free to let us know if you don’t have enough information on the documentation.

3 Likes

Yes. I understand.

Below is the screenshot of the pending orders with different suppliers.

I have three suppliers and there are multiple pending orders on them. I want to create a BOT which will email individual suppliers their pending list.

How do i do that?

Did you read the documentation links I provided, or tried my suggestion ?

What did you tried so far ?

I haven’t tried it yet. Will check today.

Done. It worked.

Thanks.

1 Like