For teams that run on HubSpot
HubSpot date calculation on your records
Adding months to a date or counting the days since one takes workflow actions from the higher HubSpot plans. On Starter, and in many Professional accounts, teams type the date in or keep it in a spreadsheet.
How it goes today
- Look at the start or close date.
- Count the months on a calendar.
- Type the new date on the record.
- Do it again when the start date changes.
How it can go
Dates such as renewal, next service or days since the last order are worked out on each record.
You give the rules, such as renewal date is close date plus twelve months, next service is last visit plus six months, days since last order, or age from date of birth. Each night the dates are worked out and written to properties on contacts, companies, deals or tickets, so you can use them in lists, views and workflows.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your HubSpot key in the portal, never in the chat.
With Hypamoon, each night, work out the dates I define, such as renewal date as close date plus twelve months and next service as last visit plus six months, and write them to properties on our HubSpot contacts, companies, deals or tickets.
A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.
More for teams on HubSpot
- I merge duplicate contacts one by one.
- I clear old tasks by hand after a deal or ticket closes.
- I clone won deals by hand to set up the renewal.
- I change our workflows every time someone goes on holiday.
- I compare last week's deal export with this week's to see what changed.
- I work out our ticket times in business days in Excel.
- I add the contacts of a company to each new deal by hand.
- I export our HubSpot reports to send to people without a login.
- I take our own test entries off the form counts every month.
- I move contacts to another company one by one.
- I calculate our stage conversion rates by hand.
- I copy notes and calls out of HubSpot record by record.
- I move open tasks by hand when records change owner.
- I check by hand which won deals have no products.
- I clean up names, countries and company fields in HubSpot every week.
- I go through the pipeline by hand to find deals that went quiet.
- I calculate commission from HubSpot exports in a spreadsheet.
- I export each object from HubSpot by hand to keep a copy.
- I add the country code to phone numbers by hand.
- I set the subscription by hand for people who already confirmed.
- I track the time zones of my contacts in a spreadsheet.
- I write the formal greeting by hand for each contact.
- I split full names into first and last name in a spreadsheet.
- I cannot show what a form said when someone signed up.
- I type our exchange rates into HubSpot by hand.
- I rename product lines by hand on quotes in other languages.
- I check customer VAT numbers by hand on the VIES site.
- I add the VAT rate by hand to each line.
- I rebuild HubSpot invoices elsewhere to send an e-invoice.
- I make our invoices again elsewhere to get a Factur-X file.
- I link branch records to their parent company one by one.
- I look up each customer's prices and change the deal lines by hand.
- I keep the reseller and end user in text fields on each deal.
- I build our Gift Aid claim in a spreadsheet from HubSpot exports.
- I export HubSpot to a spreadsheet every week.
- I copy deal details into our contract template by hand.
- I tick off event attendees by hand from a list.
- I keep a branch per postcode in our workflow to route leads.
- I number our deals by hand from a counter in a spreadsheet.
- I keep prepaid hours in a spreadsheet next to our tickets.
- I print the notification email to keep a copy of each form.
- I copy NPS scores from another survey tool into HubSpot.
- I work out deal margins in a spreadsheet.
- Everything for HubSpot