About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

How to send the timestamp for a form response in Slack to Excel?

  • 24 August 2021
  • 7 replies
  • 359 views
C

Hi all!  So i am trying to timestamp a form response from slack, but…

  1. They don’t have a variable for time submitted
  2.  {{zap_meta_human_now}} is coming up blank in excel

Any way for me to get a timestamp inputted into excel as a step?

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

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @CashOffer 

Please post screenshots of how your Zap steps are currently configured, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C

 

C

 

C

Using “add row with Microsoft Excel” 

I want to put a timestamp, but can’t figure out how to get it there

 

Troy Tessalone
Userlevel 7
Badge +14

@CashOffer 

Those screenshots don’t look like the Zap Editor.

What app are you using to configure those steps seen in the screenshot?

 

The timestamp placeholder code will most likely only work in the Zap Editor.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C

Its the Slack workflow builder using Zapier Integration.  So it is Zapier doing the action…  Im game for any other type of time stamp, even a formula into excel (=now() works but updates everytime the spreadsheet is opened)

 

 

Troy Tessalone
Userlevel 7
Badge +14

@CashOffer 

Try creating another Zap that does this.

Steps

  1. Trigger: Excel - New Row
  2. Action: Excel - Update Row (use {{zap_meta_human_now}} to set the timestamp)
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions