Manage Nonprofit Volunteers with Google Calendar and Forms

// CONFIGURATION
const CALENDAR_ID = 'primary'; // Or the ID of your 'Volunteer Shifts' calendar
const FORM_COLUMNS = {
  NAME: 1, // Column B
  EMAIL: 2, // Column C
  SHIFT: 3  // Column D (The dropdown selection)
};
 
function onFormSubmit(e) {
  const responses = e.namedValues;
  const name = responses['Name'][0];
  const email = responses['Email'][0];
  const shiftSelection = responses['Select Shift'][0]; // "Sat Dec 12, 9AM-12PM"
  
  // Parse the shift string to real dates
  // (Assuming format: "YYYY-MM-DD HH:mm to HH:mm")
  // Ideally, use a structured value in the form or parsing logic here.
  // For this example, we'll assume the value is parseable or mapped.
  const {startTime, endTime} = parseShift(shiftSelection);
  
  if (startTime && endTime) {
    createInvite(name, email, startTime, endTime, shiftSelection);
  }
}
 
function createInvite(name, email, start, end, shiftName) {
  const calendar = CalendarApp.getCalendarById(CALENDAR_ID);
  
  const event = calendar.createEvent(`Volunteer: ${name}`, start, end, {
    description: `Shift: ${shiftName}\nVolunteer Contact: ${email}`,
    guests: email,
    sendInvites: true
  });
  
  // Add strict reminders
  event.addEmailReminder(24 * 60); // 24 hours before
  event.addPopupReminder(60);      // 1 hour before
}
 
// Helper to handle date parsing (customize based on your dropdown text)
function parseShift(shiftString) {
  // Example input: "2025-12-28 09:00 to 12:00"
  try {
    const [datePart, timeRange] = shiftString.split(' ');
    const [startStr, endStr] = timeRange.split('to'); // simplistic split
    
    // Construct Date objects
    // In production, use libraries like moment.js or specific string parsing
    // This is a placeholder for the logic you need based on YOUR specific form values
    
    // For specific implementation, I recommend using "YYYY-MM-DDT09:00:00" as the value 
    // in your dropdown if possible, or mapping IDs to dates in a separate function.
    
    return {
      startTime: new Date(datePart + 'T' + startStr),
      endTime: new Date(datePart + 'T' + endStr)
    };
  } catch (e) {
    Logger.log("Error parsing date: " + e.message);
    return {startTime: null, endTime: null};
  }
}