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.

Best answer

How to create timestamp type field with firebase in Zapier?

  • 22 January 2023
  • 5 replies
  • 242 views
V
Userlevel 1
It was expected to be input as Timestamp type based on json type, but only string type was input.

 

icon

Best answer by Danvers 24 January 2023, 12:19

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

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Victor Ko 

Good question.

Can you provide more detail about what you are trying to do, the issue you are encountering, and screenshots with all of your Zap steps?

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

@Troy Tessalone

 

Thanks for answering my problem. The problem is actually very simple. When saving a new document to firestore, I want to store the current time in a Timestamp type field. However, I couldn't find a related example, and I tried setting the key in json format to "__time__", but it was recognized as a String type.

 

Danvers
Userlevel 7
Badge +12

Hi @Victor Ko!

Got it, thanks for the extra information :) 

You can enter the value {{zap_meta_human_now}} to add a timestamp of the current date/time into your Zap. The format of the {{zap_meta_human_now}} output is MM/DD/YY hh:mmAM/PM and it will use the timezone of your Zapier account (or the individual Zap if that’s set to something different) to calculate the time. If you’d like the time in a different format or timezone, this help doc explains some of your options:

Insert the time of Zap runs into a field. 

 

​I hope that's clear, please let us know if you have any questions!

V
Userlevel 1

Hi @Victor Ko!

Got it, thanks for the extra information :) 

You can enter the value {{zap_meta_human_now}} to add a timestamp of the current date/time into your Zap. The format of the {{zap_meta_human_now}} output is MM/DD/YY hh:mmAM/PM and it will use the timezone of your Zapier account (or the individual Zap if that’s set to something different) to calculate the time. If you’d like the time in a different format or timezone, this help doc explains some of your options:

Insert the time of Zap runs into a field. 

 

​I hope that's clear, please let us know if you have any questions!

Hi! @Danvers! 

Thanks for the reply. I have already tried the method I found out through countless web surfing. I think the ability to specify the field type should be added when setting the firestore value.
Danvers
Userlevel 7
Badge +12

Hi @Victor Ko 

Thanks for your reply, I see what you mean now - it’s not that you need to make a timestamp it’s that you need to tell Firebase that the value you’re giving is a timestamp (as opposed to an integer/string). That isn’t currently possible but we do have a feature request open for this. I've added your email address as another vote for this addition. I don't have an ETA of when or if this will happen, but we will definitely email you if it does become a reality. 

Thanks!

Terms & Conditions