Automation Robot

[Joao_Rocha]

hello people! Hope you're all doing fine! I am trying to create an automation event in appsheet to schedule to send weekly reports to the users. I have created slices of my table for each user to send the right data to each one and I've also customized my email template so nothing to worry there. However I am failing to connect a task to the slices I've created. Anyone can make me a quick summary of how to do this process? Thank you!

[Totocoss]

Hello Joao,

I'm having trouble understanding where you're stuck but here's a mini tutorial for choosing your slice.

In first click on the plus button to create a bot.

Then select the event.

 Put your event on Scheduled

 And then scroll down and select your slice.

Hoping this will help you.

[Joao_Rocha]

Hello , thanks for the reply! And sorry for the late reply, I replied earlier but something must have gone wrong and it wasnt posted.

In detail, what I want is the following: I have a calendar in which the other users of my app register their daily shedule. I want to create an automation that sends me every friday, for each user, their week details. So this has to be based on a slice and I think the issue is that, because I dont want to connect the task to a table, but to a slice, since I want only that week's information.

[Totocoss]

Hello Joao, thank you for the details.

You can see a solution here but it seems to be on an old version and I haven't been able to do it:

Other post 

But I think you can use the table. In the Email template, you just need to make a formula like this for example: <<SELECT(Calendar[Title], [Week] = WEEKNUM(TODAY()))>>. Then it will only show the “Tasks” for the actual week.

If you want to display by person, simply add a condition in the selection.