Automation emailing a slice

[Fred_Worrell]

I have an automation that I need to run once a month, on the first day. It should email the records in a slice to multiple addresses. Problem is, the slice doesn’t show up as a usable table in the process. what gives? Something so simple shouldn’t be this difficult to achieve.

[Steve]

Recategorized this topic as #appsheet-automation.

[Suvrutt_Gurjar]

I believe in the “Process”, one defines the table on which the task below is based on

Below is a task under the process where one can define a slice to run the report on

In the task under that process please select a slice to run the report on

[Fred_Worrell]

That doesn’t seem to work, unless I associate the event with every row of the table, which gives me 18+ emails when I only need one.

[Suvrutt_Gurjar]

Okay, got it. Please try below.

Please select none in the process under table selection.

Under Events, please deselect for Each Row in Table

The report template needs to be compatible to handle multiple rows, meaning it should have a
<<START: SELECT(… ) statement , si that multiple records are included in the report from the slice something like below

[Ryan1]

Thanks the solution here. I had the same problem and just trying to automate a weekly email of a slice.
Following your directions I have:

1. Assigned the Table Name to my slice under “tasks”
2. Changed the Table to “none” under Processes
3. Turned off ForEachRowInTable under “events”.
   The last part is where I need help. How and where do I set up this “report template”?
   Please advise,
   Thank you so much!

[Poojaaram]

Hi,

Once the slice is sent in the email, I want to update a column in the slice as email sent. Then, move all the rows of slice sent in email to a new table. But if I uncheck the ForEachRowInTable, I am unable to run any data action. How to go about this? Thanks. 

[Markus_Malessa]

You should post this under a new question as it is an entirely new topic.

[Fred_Worrell]

@Suvrutt_Gurjar, that worked!! I was able to pull all rows into one email instead of multiple emails (one for each row). Thank you for your solution. I hope others also having this problem find this. Thank you!!