You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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)
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)
But the Trello card created is:
24-Jan-2022 17:52:00 (5:52 PM)
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.