Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Google Form Responses to Trello automation sets due date time incorrectly

Edited

Hi, I've been trying for days to find a way to have a Google form auto populate a Trello card. To do that I've been using automation.io. Everything works—the title, the description, the day its due—but the time its due is always off in a way I don't understand.

 

Here's the Google form response:
24-Jan-2022 22:52:00 (10:52pm)

Screen Shot 2022-01-06 at 10.31.35 AM.png

 

Here's what automate.io is sending to Trello, as given to me by automation.io support:
24-Jan-2022 22:52:00 (10:52pm)

 

image (1).png

But the Trello card created is:
24-Jan-2022 17:52:00 (5:52 PM)

trello card.png

My Trello board, Google Sheet, Google Form and local computer are all set to EST.

Why is Trello misinterpreting the time? How would I fix this issue?
Gratitude for any help!

1 answer

1 accepted

0 votes
Answer accepted
Felix Atlassian Team Jan 06, 2022

Trello's API expects all dates to be passed in UTC.

You'll likely either need to do this conversion in your google form or in automate.io before passing it to Trello.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...

540 views 19 20
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you