Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Is there a way to adjust my Zap to ingest the “Tomorrow” date format from Trello into Coda?

Hello, I have a Zap that pulls data from Trello cards and imports the into a Coda table. One of those pieces of data is a date. The Zap works perfectly, except I’ve discovered that in Trello if you choose the next day as your date, Trello formats it as “tomorrow,” as opposed to 9/15/2022, like it does for other days. 

 

When that happens, the date is not transferring to Coda and, sometimes, nothing transfers when the Zap runs. I do not believe I can get Trello to not list dates that way. Can anyone think of way to adjust my zap to ingest “Tomorrow” into Coda? 

 

Thanks in advance.  

Hi @Aaron Sheinin 

Good question.

Try using a Zap Formatter > Dates / Times > Add/Subtract Time step in your Zap.

 

 

Troy, thanks so much for the response. I have to admit this is my first Zap. So this would be an additional step? 

@Aaron Sheinin 

Yes, the Formatter step would be another step in the Zap.

Try using a Zap Formatter > Dates / Times > Add/Subtract Time step in your Zap.

 

 

Hey @Aaron Sheinin! I wanted to swing by and see if you were able to get this rolling? 🤗

Troy’s recommendations is spot on! The formatter step would be sandwiched between the trigger and action step. Here’s another resource in case it’s helpful:

Let us know how this works out for you! 

@christina.d, thank you! I am still working on it, I’ll admit. My first attempt wasn’t successful but I plan to try again later this morning. I’ll let you know and provide some screen grabs this time. 

@christina.d, @Troy Tessalone I’m afraid I’m still running into trouble. Here is a look at the Trello card entry. As you can see, when you select the next day as the publish date in Trello, Trello formats it as saying “tomorrow.” 

 

Here is the format step I created in the Zap: 
 

 

I chose the X From Format because the others didn’t seem to make sense. When I run the Zap, the date field in Coda remains blank. Any ideas? 

And I really appreciate your help. 

@Aaron Sheinin 

The example data from Trello in the Zap trigger step has “No data” for the mapped variable.

Try changing your trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

 

@christina.d @Troy Tessalone Huzzah! That seems to have worked y’all. Thank you so much!

Terms & Conditions