Google Sheets: sendEmail() with day exceptions

I was able to send rows from a Google Sheet via e-mail, using the Javascript sendEmail() function. The aforementioned Google Sheet is linked to a Google Form.

In the sheet, under the column "Recursive_Requests", there are 2 options to send data. I would want that:
1) if you select "send_every_day" option, the request is sent by e-mail every day;
2) if you select "send_every_monday", the request remains in the sheet, BUT it is sent only every Monday;
3) if you select "No", no changes are made.

Any help would be appreciated!


Code used --> AppsScript code.pdf
Google Form --> https://forms.gle/Mxow3DR58yZCoAp48
Google Sheet --> https://docs.google.com/spreadsheets...it?usp=sharing

Cross-posted over another forum --> https://stackoverflow.com/questions/...-on-weeks-date

Well over 400 views and no offers of help suggests that there isn't anyone here who can help you or that your query is unclear. Sorry.

It's in the right place.

If you want to ask the same question on a third party forum, then it's fine to do so, as long as you share a link to that forum and your question on it here.

I don't know - I am just pointing out that MANY members have viewed your post over a week and NOT ONE person has offered help. This is very, very rare and suggests that nobody is in a position to help you.

There is nothing more I can do to help you. It's up to you whether you ask somewhere else or not: all we ask is that you tell us if you do.

Maybe it is - maybe there just isn't anyone here among the 400+ who've viewed your thread that uses AppScript code. I cannot magic up a helper for you - sorry.

Thank you.

Suggest you try here: https://groups.google.com/g/google-a...ript-community


I suspect it's not that difficult for someone familiar with Google AppScript.

Good luck and thanks for providing the cross post link.

Good luck - let us know how you get on.

Bear in mind going forward that ExcelForum is predominantly still a forum for Excal and Microsoft VBA, so it's better to find a specialist forum for Google-based stuff.