spreadsheet - google sheets - send email notification based on time of day -


in google sheets, there way send email notification when cell not filled time of day? if cell a1 isn't filled 5pm, send email user tell them fill cell.

you'll need time driven trigger checks if cell(or range) blank , calls email function

also @ answer, uses onedit()


-

Comments

Post a Comment

Popular posts from this blog

php - Auto increment employee ID -

Image
i want add employee , after that, employee id increment. textbox must disabled also here's code. want auto increment employee id when add new employee. hope me. thank in advance. :) <center> <form class="contact_form" action="#" method="post"> <h2>register new employee</h2> <br/> <table> <tr> <td><label for="emp">emp id:</label></td> <td><input type="text" name="emp" placeholder="emp id" required /></td> </tr> <tr> <td><label for="name">name:</label></td> <td><input type="text" name="fname" placeholder="first name" required /> <input type="text" name="lname" placehol...
Read more

python - Evaluating the next line in a For Loop while in the current iteration -

here trying do: trying solve issue has wrapping in text file. i want open txt file, read line , if line contains want contain, check next line see if not contain in first line. if not, add line first line. import re stuff = open("my file") line in stuff: if re.search("from ", line): first = line print first if re.search('from ', handle.next()): continue else: first = first + handle.next() else: continue i have looked quite few things , cannot seem find answer. please help! i try this, invalid triples of "from " , not elegant @ all. lines = open("file", 'r').readlines() lines2 = open("file2", 'w') counter_list=[] last_from = 0 counter, line in enumerate(lines): if "from " in line , counter != last_from +1: last_from = counter current_count = counter if current_coun...
Read more

php - Facebook share link is not showing image within the post?(get parameter in url) -

i have added code in head part <meta property="og:image" content="your_image_here" /> case 1: when click share link. below url working properly. example: www.exampledomainname.com/test fetching image in second case adding parameter url example: www.exampledomainname.com/test?username="aaa"; because every time username change. <a href="http://www.facebook.com/share.php?u=www.exampledomainname.com/test?username=aaa" target="_blank"><button class="btn btn-social btn-facebook"><span class="icon icon-facebook"></span> share on facebook</button></a $input = "www.exampledomainname.com/test?username=aaa"; $encoded = urlencode($input) <a href="http://www.facebook.com/share.php?u='.$encoded.'" target="_blank"><button class="btn btn-social btn-facebook"><span class="icon icon-facebook"></...
Read more