Form > Zapier > Google Sheets- Timestamp?

SOLVE
New Contributor

I am using zapier to create rows on a spreadsheet as form-fills are submitted to create warranty requests for my company's tech department. I would like to find a way to create a timestamp within the spreadsheet, or generate an ID number automatically. Has anyone found a way to accomplish this?

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Advisor

The timestamp should be easy to solve for.  If Zapier cannot grab that data from the form submit, I would just create a date property and populate that.  If you need a true datestamp, just modify your form embed code and include it via javascript ( https://developers.hubspot.com/docs/methods/forms/advanced_form_options ).  Then pass that property through Zapier.

 

The problem with generating an ID number depends on the complexity of the number, whether it is auto increment or whether it is some custom string.  If you can generate it via API or script prior to the form submission you may be able to pass it as a property.  If not I'm a bit short of ideas because the thought going through my mind is keeping it in sync between platforms.

1 Reply 1
Highlighted
Advisor

The timestamp should be easy to solve for.  If Zapier cannot grab that data from the form submit, I would just create a date property and populate that.  If you need a true datestamp, just modify your form embed code and include it via javascript ( https://developers.hubspot.com/docs/methods/forms/advanced_form_options ).  Then pass that property through Zapier.

 

The problem with generating an ID number depends on the complexity of the number, whether it is auto increment or whether it is some custom string.  If you can generate it via API or script prior to the form submission you may be able to pass it as a property.  If not I'm a bit short of ideas because the thought going through my mind is keeping it in sync between platforms.