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?
Best answer
Manipulating and combining date fields from a trigger
Best answer by Troy Tessalone
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
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,
+9- Zapier Solution Partner
Hey there
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!
+14- Zapier Orchestrator & Solution Partner
- Answer
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
+9- Zapier Solution Partner
Hey
+5- Zapier Staff
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.