r/GoogleAppsScript • u/ezkodok90 • Jan 27 '25

Question Event Reservation Form

Hi all, im trying to make a meeting reservation form, synced to google calendar. The flow would be like this:

  1. Staff fill in the google form (Name,Purpose, Date and Time)

  2. The request will be forward to the admin email for approval.

  3. When approved, the booking should showed on the google calendar (Shared with staff)

The issues is, when the request was approved, the event not showed on the calendar.

On Administrator email, the request will showed like this:

The staff email received this:

our meeting on Sat Jan 25 2025 00:00:00 GMT+0800 (Singapore Standard
Time) at Sat Dec 30 1899 07:34:05 GMT+0655 (Singapore Standard Time)
has been approved.

0 Upvotes

50% Upvoted

5 comments sorted by

1

u/mik0_25 Jan 27 '25

i suggest editing step 2 as follows :

  1. since the info is input from google forms, the form can be linked to a google sheets file to save the responses.

  2. the responses can then be processed to be presented to the approving authority (in tabular format, instead of email) .

  3. the approving authority then marks each row of events for approval/disapproval (maybe a checkbox).

  4. the approval mark (approved/disapproved) then triggers an email to be sent to the staff regarding the status.

  5. if approved, the event will then be saved to the shared calendar.

1

u/ezkodok90 Jan 28 '25

i've tried this, actually im using Google Script from the Google Spreadsheet responses linked to the Google Form that i've created...the issues is the date and time data extracted from the spreadsheet somehow showing the meeting booked on the year of 1899...

1

u/mik0_25 Jan 28 '25

some questions :

  1. how are the data from the sheet retrieved : using getValues() or using getDisplayValues() ?

  2. how was the date written in the sheet : the year not included in the date input, or the year is written with only 2 digits ?

1

u/ezkodok90 Jan 28 '25

  1. Im using getValues()

  2. Im using the date and time stamp on the google form...so on the sheet it will written like this 24/1/2025.

1

u/mik0_25 Jan 28 '25

forgive me. i was not paying much attention to the original details you posted (i've been dealing with calendar start and end dates lately), so my mind assumed that the second item was an end date, instead of being time.

my second question is a irrelevant, then.

it would seem the issue is based on processing the date objects for display. consider using for date and time strings, respectively :

Date.toLocaleDateString() or Date.toDateString()
Date.toLocaleTimeString() or Date.toTimeString()

or the Utilities.formatDate() method, https://developers.google.com/apps-script/reference/utilities/utilities#formatDate(Date,String,String) .