Having a dynamic 'today' field in the 'Time between' feature
I'm in the process of setting up calculated properties to use the new "time between" feature in reporting, and realized that, in the 'time between' calculations for properties, I'd like to have access to the option 'today,' which would be a dynamic date set as the value of today's date.
That would allow me to track dynamically how long has it been since a deal has been created ('today' minus 'create date' = how far along we are in the sales cycle up till now).
Currently trying to calculate the time left on a trial/subscription for each user and this is impossible without the bloated and mistake-ridden workarounds.
It's baffling how we cannot report based on a date field matching the date of 'Today'.
I'm trying to build a workflow that will trigger when a customer returns a vehicle. 'Return date' is the property. Is anyone able to simplify how i can use the 'Return date' to kick start my workflow? I'd massively appreciate it!
I'd even be happy for it to trigger based on it being 1 day out as I'd be able to put a delay in to compensate this.
Our company uses HubSpot and we like it. Their customer service on the phone has always been excellent. But they seem to have just ignored all of us on this topic. I've not even seen one response or update from HubSpot. Maybe I missed it?
Echoing this idea - it's sorely needed for reporting and making use of the "Time Between" equation. Doesn't make it possible to create our own Days since _________ kind of properties
We are considering an option with custom code, which appears to be an action available to us in workflows. Using javascript, our intent is to create timestamp fields populated by our first custom javascript code, dumping the date and time to a field. The second will calculate the difference in minutes between two timestamps, excluding non-business hours. If anyone has any feedback on this idea, please share. Or if anyone has done this already, this group would likely benefit from anything you can share.
Almost two years on from adding my voice to requesting this essential functionality at my old company, it still appears to be nowhere near coming to fruitition so I'm posting again from my new company. PLEASE Hubspot - this should be really basic functionality 🙏
I’m Shay Jones, the Product Manager on the CRM product team.
Thank you all for taking the time to submit, upvote, and comment on this Idea. We hear you loud and clear, and we agree that this functionality is important. We are currently evaluating if this Idea is feasible and, if so, how our team will implement it.
Any news about this feature request will be relayed on this thread, so stay tuned!
