+ Reply to Thread
Results 1 to 1 of 1

Execution of AppsScript trigger with date exceptions

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

    Question Execution of AppsScript trigger with date exceptions

    Hi there,
    I am new in the world of Javascript coding.
    I have managed to adapt some javascript code to edit a Google Sheet. However, I would want to create a time-driven trigger that runs this code every day, with date exceptions (e.g. not in the weekend, winter/easter holidays, ...). The date exceptions do not have to carry the year, because this exceptions must be applied every year.

    for example: create "time-driven trigger" --> run code "every day from 7am to 8am" - { every Sunday , from 12/25 to 01/10 , 07/04 }


    Is it possible to widen the possibilities of AppsScript triggers to what I would want to achieve?
    Any help would be much appreciated.

    Time-driven trigger settings: h t t p s : / / drive.google.com/file/d/1sexjgI1YPNuJBVt5riBa-Nfa5AZ8FVR9/view?usp=sharing
    Cross-posted AND SOLVED over another forum --> h t t p s : / / stackoverflow.com/questions/74043689/execution-of-appsscript-trigger-with-date-exceptions
    Last edited by Micheal_Benton; 10-12-2022 at 01:53 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date formula to show ON TIME and LATE with Exceptions
    By Guttenbomber57 in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 10-14-2022, 07:55 AM
  2. [SOLVED] Calculate latest date from two columns with exceptions
    By madman411 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-28-2020, 11:35 AM
  3. Need VB code to trigger popup when any date in a range is within 30 days of system date.
    By enthusiastic learner in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-15-2019, 11:44 AM
  4. Replies: 0
    Last Post: 06-28-2014, 09:31 AM
  5. Task Tracker - Filtering by ascending date and exceptions
    By sk8ersquare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 01:36 AM
  6. How to trigger code execution?
    By alwaysgo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2008, 09:11 AM
  7. date exceptions
    By blahblah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2008, 11:15 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