Results 1 to 17 of 17

Google Sheets: sendEmail() with day exceptions

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2022
    Location
    London, England
    MS-Off Ver
    Microsoft Office 365 2021
    Posts
    21

    Question 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
    Last edited by Micheal_Benton; 10-26-2022 at 02:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Execution of AppsScript trigger with date exceptions
    By Micheal_Benton in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-12-2022, 10:44 AM
  2. [SOLVED] Current Term Code and Weekly Assignments
    By crazyforexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2020, 11:03 AM
  3. Goal Seek doesn't run on iterative code
    By skipnick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2018, 01:49 AM
  4. VB Code to summarize weekly Sales
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2014, 03:52 PM
  5. Iterative code stops right after 1st step
    By AtulSwamy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 12:21 PM
  6. Replies: 3
    Last Post: 11-19-2010, 06:26 AM
  7. Problem with Iterative Code, Excel Precision, or my maths??
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2009, 09:59 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1