Automation with Google Calendar - Event Date & Time

[jamiemburns]

Hello! 

I work for an event facility and we are trying to automate our calendar with a submission form. The idea is that when a new form is submitted with an event name, date and time that it will be automatically added to Google calendar. With the current automation, it syncs the date with google calendar, but defaults to 12pm for the time for everything submitted. Does anyone have a suggestion on how to make this work? 

Thanks! 
Jamie

[TheTimeSavingCo]

Hmm, could you include a screenshots of how you've attempted to combine the "Start Date" and "Start Time" field values and how you used that combined value in your automation? 

I take it there's a business requirement that prevents you from just having one "Start Date/Time" field that allows the user to select both the date and the time?

 

[jamiemburns]

Form is attached. In google calendar, it is syncing and putting the event on the actual date, but defaults to all day. So if I put an event in from 12pm (start time) - 1pm (end time) on 3/11/24, it would sync to google calendar as an all day event on 3/11/24/

[TheTimeSavingCo]

Ah, you're now using a single date time field instead of a date field and a time field, that's great!

Could you please provide screenshots of your automation setup, specifically of the action that creates the event in Google Calendar?

[TheTimeSavingCo · Accepted solution]

Thank you!  Could you try unchecking the "All day event" checkbox?

 

[jamiemburns]

Thank you! I'm not sure how I missed that, but it worked!