Best answer

Quickbooks Online invoice to Google Calendar Entry. How do I enter a delivery time?

  • 10 September 2020
  • 2 replies
  • 70 views

Userlevel 3
Badge

We are professional balloon decorators that use Quickbooks online for our accounting. We’d like to use Zapier to automatically create a google calendar event based on our invoices. We’ve got it mostly working. We send the client the invoice and we get a custom calendar event with all the information about that gig. Here’s the rub. QBO doesn’t actually have a “Time of delivery” field, much less a “Window of time for delivery” field. Is it possible to steal another field or two (“tracking number” and “shipping via” perhaps?) and write “9:00am to 4:00pm” as the delivery window? What is the specific way to write the times so that Google Calendar recognizes it and creates the event at the right time?

Thanks so much for your help.

icon

Best answer by Troy Tessalone 10 September 2020, 05:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 3
Badge

This has been resolved, thank you.

Userlevel 7
Badge +14

Article: https://zapier.com/help/doc/common-problems-google-calendar#is-the-event-being-created-on-the-wrong-date-specifically-with-the-month-and-day-switched

 

Is the event being created on the wrong date, specifically with the month and day switched?

Regardless of your settings in Google Calendar directly, their API only accepts dates in MM/DD/YYYY format.

So, if you try to pass April 7, 2018 as 07/04/2018, Google Calendar will interpret that as July 4, 2018.

You'll need to pass your data in MM/DD/YYYY format for Google Calendar to add the event to the correct date(s).

If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.