Google sheets and automatic emails -
i wondering if can problem.
i teacher in school , tracking if students off track in subjects. google sheet shared whole school , members of staff add if students off track or 1 track. if student off track in 2 or more subjects email sent me can pick these students up. email sent every week.
the logic seems simple enough, if count of amount of cells equal "off track" send email value of first column name.
however @ banging head on wall don't know how add google sheet.
i give credit 1 can help!!
thank every one
i haven't done myself, need dig code scripting on sheet. setup trigger run script @ time.
https://developers.google.com/apps-script/guides/triggers/events
if not comfortable coding, can find on odesk, guru or elance. india fast , cheap.
Comments
Post a Comment