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.

I am trying to extract data from a Booking site using Zapier to populate Deal Information in HubSpot. I can pull the start date and the end date from the Booking site using Zapier. However, I need to convert the start date and end to text fields, so that I can concatenate the data to create the Deal Name to send to HubSpot. Does anyone have any ideas on how I can accomplish this?

Hi @Scott B 

Perhaps you can provide screenshots of what you’re trying to do and the desired end result, thanks.

Troy, Thank you for the quick response. Here is what I am trying to do I want to take the date information in M2 and N2, convert the information to text fields and then concatenate the two fields into one field to create the Deal Name to send to HubSpot. Thanks,

 

 

Hey there @Scott B - Zapier has an awesome feature called Date Formatter 

 

https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps

 

It allows you to take the date, and turn it into a pretty date which you can then parse into the next step. So for example, once you’ve parsed the date, you can concatenate your value with the date. 

 

Hope that helps!

@Scott B 

You can use Formatter > Date & Time > Format steps to convert the format for Timestamps.

You can create a HubSpot Deal Title by inserting a combo of Static values and Dynamic data points from previous steps.

For example: DATE_ARRIVE] - DATE_LEAVE], where VARIABLES] are dynamically mapped in the Zap and “ - ” is static

Hey @Scott B Thanks for the follow up… In that case you may actually not need the date formatter step, you should just be able to bring in both dates into the same field in order to concatenate

Hi @Scott B, just checking in to see if you still need help with this? Were the suggestions of Troy and Andy useful in saving the concatenated data into Hubspot? Please let us know! 
 

Terms & Conditions