Seems as if I should be able use Column A ("Timestamp") with some sort of a comparison to now() to determine the 10 day part. And to get the have not paid their dues just has to be Column D does not equal Yes. The recipient's e-mail address is, obviously, in Column X.

I've already written a script to send a confirmation e-mail to the recipient "On Form Submit." So I'm comfortable with the MailApp.sendEmail class.

And if you notice the "Updaid" tab, you'll see that I've tackled using a query to pull out people who haven't paid.

But I'm not sure how to get the MailApp.sendEmail class to operate on data that's already IN a sheet. That is not triggering automatically when the form is submitted.

And I don't know how to adapt my query to account for the 10 days ago bit.

And I'm not even sure I should be USING a query for this application.

Can anybody right my path?

Thanks.

网友答案:

The easiest way to know if a date is 10 days later is probably to count the milliseconds !