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.

Hello -

 

I’m trying to take dated journal entries from my CRM and put them in a table in a google doc. 

I was able to extract the data via webhook and format via JavaScript. Still need to figure out how to format the date which is the number in the screen shot. 

I guess I have two questions, how do I transform the highlighted number to a date, then put each entry into a row in either sheets or docs?

 

Hi @PeterQuinn 

These are Unix timestamp in milisecond. Zapier’s internal date-time formatter doesn’t directly support unix millisecond formatter I think, you can probably substring the length and get it to work. Since you are already using JS to achieve some of it I think you should keep use the same JS code step to 

Better use chatgpt to generate the code piece

Terms & Conditions