Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

166
Views
Création d'un événement de calendrier - Horaires personnalisés- sans compter les jours feriés - Google Apps Script

comment creer un événement de calendrier lors de la soumission d'un formulaire avec une date debut et date fin , mais sans creer des evenements durant samedi et dimanche.

Voici ce que j'ai actuellement :

function CreateEvent(){
 var vSS = SpreadsheetApp.getActiveSpreadsheet();
 var vS = vSS.getSheetByName("blah blah blah");
 var vLastRow = vS.getLastRow();
 var vCalendar = CalendarApp.getCalendarbyID('xxxxxx@joent.com')
 var vStartDate = vS.getRange(vLastRow,6);
 var vStartDateValue = new Date (vStartDate.getValue());
      vStartDateValue.setHours(9);
 var vEndDate = vS.getRange(vLastRow,7);
 var vEndDateValue = new Date (vEndDate.getValue());
      vEndDateValue.setHours(17);

 vCalendar.createEvent('Description',
                        vStartDateValue,
                        vEndDateValue)
  }
about 4 years ago · Santiago Gelvez
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!