Hello Community: I need some help. I am tryin...

(SmartD) #1

Hello Community: I need some help. I am trying to send reports (based in GoogleDocs)

to clients informing them of everything they bought the day before. The point is: how to make the AppSheet platform select only the customers who bought the previous day and send them a report informing them of their purchase automatically?

Rafael

(Philip Garrett) #2

@SmartD

  1. Create a slice that contains only the Customer records who made a purchase on the previous day. You will need to write the expression to do that based on the order date. 2. Add a Report that runs daily. Base it on the slice above. Select the “For Each Row in Table” option to create an email for each customer in the slice.
(SmartD) #3

@Philip_Garrett_Appsh Thank you very much!

(SmartD) #4

@Philip_Garrett_Appsh In this case I would have to create a slice for each client?