We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
Jan 14, 2022 12:30 PM
Dear Community,
I use Webinarjam and Hubspot for sign ups and webinar execution and am connecting the two via zapier. I want to update a contact property in Hubspot to reflect who attended a webinar and who missed it. For this, I imported a .csv with the live attendees from Webinarjam and the contact property has been correctly updated for properties formatted as "radio select", where option was “Yes" for attendance and "No" for no attendance. I also wanted to import the time stamps (so time spent in live or replay room) but this information could not be imported, I guess because of the wrong format. Can you let me know what format I can import into? Ideally it would not be text but date or time, so you can later on also interpret or filter according to the results? See the screenshot below for the timestamp format I want to import.
Thank you and best
Daniela
Solved! Go to Solution.
Jan 14, 2022 1:18 PM
Hi @danielajk,
Unfortunately there aren't any file formats for durations or time (aside from the Date picker format). The closest to a duration would be the Number format. You'd have to convert the minutes into decimals first. Then you could import the number into a newly created custom Number property.
Let me know if you have any follow-up questions!
Karsten Köhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Jan 18, 2022 8:28 AM
Thanks @karstenkoehler this helps.
Jan 14, 2022 1:18 PM
Hi @danielajk,
Unfortunately there aren't any file formats for durations or time (aside from the Date picker format). The closest to a duration would be the Number format. You'd have to convert the minutes into decimals first. Then you could import the number into a newly created custom Number property.
Let me know if you have any follow-up questions!
Karsten Köhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |