Check this will help you:
http://www.withoutthesarcasm.com/automating-google-spreadsheets-email-reminders/
what you can do is create a trigger which runs every hour or so which
triggers your appointment script.
In your code add condition before sending email that if current time is
greater then event reminder time then send email, post sending email update
in column as email sent as yes so that no new reminder send for particular
row item..
Thanks
+++++
*I did not do this for you. God is here working through me for you.*
On Fri, Oct 17, 2014 at 4:30 AM, Hasnain Basit <smhasnai...@gmail.com>
wrote:
> Hello,
>
> My script is in attachment. Let me explain you what it is doing.
> I have a Google form for appointments through which user enter its data
> and reserve two future dates for two separate appointments.
> I need to do two tasks:
> 1) As soon as user submits form "Confirmation Email" of form submission
> should be send. This task is tested and completed (your previous pointer to
> tutorial helped a lot).
> 2) Second task is to send user "Reminder Email" One or Two day before
> his/her reserved appointment. For this I have created two separate
> functions 'firstAppointmentDeadLine' and 'secondAppointmentDeadLine'. These
> functions need to be triggered one or two day before appointment. I am
> unable to solve how to trigger these two functions.
> Also these two functions are not tested due to trigger issue, so if you
> find any problems please guide me as this is my first time with Google
> forms & Java Script.
>
>
> Regards,
> Hasnain
>
> On Thu, Oct 16, 2014 at 6:18 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>
>> Ok. Send me your whole code. Will add on time trigger.
>> On Oct 16, 2014 2:54 PM, "Hasnain Basit" <smhasnai...@gmail.com> wrote:
>>
>>> Thanks a lot, it solved my supplementary problem but my main problem of
>>> sending Reminder before deadline is still there. I am unable to find
>>> solution for it.
>>>
>>> Closest thing I found is that we can send triggers at specific time of
>>> weekday, but since I want to send reminder near to deadline I want some
>>> thing which can subtract deadline with current date and issue a trigger.
>>>
>>> ScriptApp.newTrigger('myFunction')
>>> .timeBased()
>>> .onWeekDay(ScriptApp.WeekDay.MONDAY)
>>> .atHour(9)
>>> .create();
>>>
>>>
>>> Regards,
>>> Hasnain
>>>
>>>
>>>
>>> On Wed, Oct 15, 2014 at 4:02 PM, Hasnain Basit <smhasnai...@gmail.com>
>>> wrote:
>>>
>>>> Hello Experts,
>>>>
>>>> I have a query related to Google Doc Spreadsheet.
>>>> I have a Google Form whose data is saved in Online Google Docs
>>>> Spreadsheet.
>>>> Data fields saved in Google Spread sheet are (column wise) : First
>>>> Name, Last Name, Email ID, Appointment Date.
>>>> I want to Automatically send Reminder email to user 24 hour prior to
>>>> their Appointment Date.
>>>>
>>>> I have searched few forum and found out this can be done via Excel VBA
>>>> but could not find if this can be done via Online Google Doc, as there is
>>>> no Developer Tab in it.
>>>>
>>>> Can some one guide me with better solution for this problem?
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Hasnain
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
