Birthdays

[Brandon Hodgson]

Hello, 

I created a form that allows me to email students on their birthday. Unfortunately, it sends it the day before at 9PM. How can I change this? Thank you!

This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited.

[Joseph Schmidt]

Adjust the formula.

It appears that Google's clock isn't I synch with your calculations.

Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/199e0288-3ce8-4ecc-931e-981019cf5876n%40googlegroups.com.

[Brandon Hodgson]

How do I fix that? Or can you? 

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOTeNjEG_beRTmORPLmam-S9j%2BSTUkE1Refhodg9NJidFg%40mail.gmail.com.

[Joseph Schmidt]

How are you determining when to send?

I made the assumption you have all of the students in a spreadsheet and a formula to determine who gets sent on a given today.

Could you share a copy of the file with the names removed.  Put in a dummy email address.

You can share we me and I will take a look at it.

Joe Schmidt

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAFYpjqtRmepCG_3uWBVvodmqnAoK6Q0djEJrWAGddzThcfMcjw%40mail.gmail.com.

[Aullin Lundu]

Your time may be different with the default time zone in sheet. I suggest you change it in the sheet's settings.

Aullin Lundu

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORcosMHG9w9EKebEhZO%2B7poE0CgCEf62no_zB__SMWUag%40mail.gmail.com.