# Data **URL:** https://community.hubspot.com/c/revops-data-hub/64.md?page=16 [Latest](https://community.hubspot.com/latest.md) · [Categories](https://community.hubspot.com/categories.md) · [Tags](https://community.hubspot.com/tags.md) **Page:** 17 --- ## [Domain kasa.com is incorrectly displaying info pulled from Clearbit](https://community.hubspot.com/t/domain-kasa-com-is-incorrectly-displaying-info-pulled-from-clearbit/122911)
**Author:** [@Camilo\_Olea](https://community.hubspot.com/u/Camilo_Olea)\ **Replies:** 4\ **Last updated:** [December 27, 2024, 8:15pm UTC](https://community.hubspot.com/t/domain-kasa-com-is-incorrectly-displaying-info-pulled-from-clearbit/122911 "2024-12-27T20:15:25Z")
Hi, At kasa.com we use superhuman.com to manage our email service. We noticed that all Kasa employees are displaying incorrect information in their profile - they are listed as employees of “Kasa Smart”, which is a diff… --- ## [Submit your ideas: What custom code actions should we build next?](https://community.hubspot.com/t/submit-your-ideas-what-custom-code-actions-should-we-build-next/42503)
**Author:** [@maggiebutler](https://community.hubspot.com/u/maggiebutler)\ **Replies:** 19\ **Last updated:** [December 24, 2024, 5:54pm UTC](https://community.hubspot.com/t/submit-your-ideas-what-custom-code-actions-should-we-build-next/42503 "2024-12-24T17:54:20Z")
We’re building a library of custom code actions so you can automate anything in HubSpot. What do you want to be able to automate? Submit your ideas in the comments below or upvote your favorite ideas, and we’ll add them … --- ## [Format Date and Time: Daylight Savings v. Standard](https://community.hubspot.com/t/format-date-and-time-daylight-savings-v-standard/119359)
**Author:** [@00000](https://community.hubspot.com/u/00000)\ **Replies:** 10\ **Last updated:** [December 19, 2024, 4:19pm UTC](https://community.hubspot.com/t/format-date-and-time-daylight-savings-v-standard/119359 "2024-12-19T16:19:36Z")
How can we reference the account’s timezone in the timezone field when formating date and time through workflows? Organization wants the time a property is changed to be stamped into a text property string so this infor… --- ## [Using Operations Hub to pull a first name from an email.](https://community.hubspot.com/t/using-operations-hub-to-pull-a-first-name-from-an-email/38877)
**Author:** [@ConnorMcM](https://community.hubspot.com/u/ConnorMcM)\ **Replies:** 3\ **Last updated:** [December 18, 2024, 8:04am UTC](https://community.hubspot.com/t/using-operations-hub-to-pull-a-first-name-from-an-email/38877 "2024-12-18T08:04:42Z")
I was wondering if there was a way to pull a first (and maybe even a last name) from an email, as long as it uses a separator such as “\_” or “.”. Would this be possible using the Format Data function or would I have to … --- ## [Data Outputs Not Working](https://community.hubspot.com/t/data-outputs-not-working/121798)
**Author:** [@ahmedbs](https://community.hubspot.com/u/ahmedbs)\ **Replies:** 2\ **Last updated:** [December 17, 2024, 7:31pm UTC](https://community.hubspot.com/t/data-outputs-not-working/121798 "2024-12-17T19:31:23Z")
from datetime import datetime maintDate = ‘’ def main(event): try: input\_fields = event.get(‘inputFields’) # Get the maintenance start and end dates maint\_start\_date = input\_fields.get(‘maint\_start\_date’) maint\_en… --- ## [Deal Created via API - Associate to company?](https://community.hubspot.com/t/deal-created-via-api-associate-to-company/51744)
**Author:** [@BenLerner-Paio](https://community.hubspot.com/u/BenLerner-Paio)\ **Replies:** 4\ **Last updated:** [December 17, 2024, 5:52pm UTC](https://community.hubspot.com/t/deal-created-via-api-associate-to-company/51744 "2024-12-17T17:52:12Z")
Hey everyone, I have a client that is creating deals via API calls from their backend, and I would like to be able to associate these deals to a company already in HubSpot. They have one property that will be in both … --- ## [Record ID field Sync with Dynamcs 365 CRM](https://community.hubspot.com/t/record-id-field-sync-with-dynamcs-365-crm/80872)
**Author:** [@KMohamed15](https://community.hubspot.com/u/KMohamed15)\ **Replies:** 8\ **Last updated:** [December 17, 2024, 2:45pm UTC](https://community.hubspot.com/t/record-id-field-sync-with-dynamcs-365-crm/80872 "2024-12-17T14:45:02Z")
Hi, I’m trying to map the Record ID field with a field in CRM Dynamics 365 called “Contact Record”. For some reason, I can’t seem to find the Record ID field. It’s not a custom field but rather an Out of the box field. … --- ## [Projected ARR Calculations](https://community.hubspot.com/t/projected-arr-calculations/122523)
**Author:** [@drafeedie](https://community.hubspot.com/u/drafeedie)\ **Replies:** 5\ **Last updated:** [December 17, 2024, 2:13pm UTC](https://community.hubspot.com/t/projected-arr-calculations/122523 "2024-12-17T14:13:57Z")
I am trying to created a projected ARR number for each of our customers. We bill out customers a variable fee each month via Quickbooks and use the integraiton to sync invoices to Hubspot. Currently we have a roll up cu… --- ## [Integrating Product Activity Data with HubSpot: Best Practices and Solutions](https://community.hubspot.com/t/integrating-product-activity-data-with-hubspot-best-practices-and-solutions/122584)
**Author:** [@SClara](https://community.hubspot.com/u/SClara)\ **Replies:** 1\ **Last updated:** [December 16, 2024, 6:15pm UTC](https://community.hubspot.com/t/integrating-product-activity-data-with-hubspot-best-practices-and-solutions/122584 "2024-12-16T18:15:50Z")
What’s the best way to connect my customers’ activity within my product to HubSpot? Currently, we’re tracking activity in PostHog, but I’d like to send data such as logins and other events to HubSpot as well. Could you … --- ## [Scaling Insights with Snowflake Data Share](https://community.hubspot.com/t/scaling-insights-with-snowflake-data-share/122595)
**Author:** [@JMercado](https://community.hubspot.com/u/JMercado)\ **Replies:** 0\ **Last updated:** [December 16, 2024, 6:12pm UTC](https://community.hubspot.com/t/scaling-insights-with-snowflake-data-share/122595 "2024-12-16T18:12:14Z")
\*\*HubSpot-Snowflake Data Share & Data Ingestion Solution Deck from HubSpot Solution Architects\*\* I’m excited to share a slide deck of resources on HubSpot-Snowflake Data Share and Snowflake Data Ingestion, now in publi… --- ## [Mapping Associations w/ Hubspot Sync for Airtable](https://community.hubspot.com/t/mapping-associations-w-hubspot-sync-for-airtable/67828)
**Author:** [@aeley05](https://community.hubspot.com/u/aeley05)\ **Replies:** 8\ **Last updated:** [December 12, 2024, 8:17pm UTC](https://community.hubspot.com/t/mapping-associations-w-hubspot-sync-for-airtable/67828 "2024-12-12T20:17:33Z")
Hello there, I am leveraging our Operations Hub Starter account to set up a sync between datasets in Airtable / Hubspot. Essentially, I am just trying to sync the basic CRM data (companies / contacts). So far, I have s… --- ## [Manage forms in Hubspot](https://community.hubspot.com/t/manage-forms-in-hubspot/122374)
**Author:** [@CGabaston](https://community.hubspot.com/u/CGabaston)\ **Replies:** 2\ **Last updated:** [December 12, 2024, 3:23pm UTC](https://community.hubspot.com/t/manage-forms-in-hubspot/122374 "2024-12-12T15:23:07Z")
Hello ! I’d like to have your feedback about Hubspot’s best practices. I use Hubspot forms on my website (contact, download different types of contents…) and I currently have more than 100 forms in my CRM. Each form dr… --- ## [How to automatically add companies to Hubspot and get notifications via Slack](https://community.hubspot.com/t/how-to-automatically-add-companies-to-hubspot-and-get-notifications-via-slack/122278)
**Author:** [@JazminA](https://community.hubspot.com/u/JazminA)\ **Replies:** 2\ **Last updated:** [December 11, 2024, 9:44pm UTC](https://community.hubspot.com/t/how-to-automatically-add-companies-to-hubspot-and-get-notifications-via-slack/122278 "2024-12-11T21:44:51Z")
Hello! I have recently joined Clearbit to explore its potential for tracking visitors interested in our product. So far, I have connected Clearbit to HubSpot, added the JavaScript tracker to our website, and created lis… --- ## [Change task/text field directly in report - is that possible?](https://community.hubspot.com/t/change-task-text-field-directly-in-report-is-that-possible/122234)
**Author:** [@LULUDEDE](https://community.hubspot.com/u/LULUDEDE)\ **Replies:** 2\ **Last updated:** [December 10, 2024, 7:08pm UTC](https://community.hubspot.com/t/change-task-text-field-directly-in-report-is-that-possible/122234 "2024-12-10T19:08:29Z")
I’ve searched around but have not been able to find if there’s any kind of field/ property, that allows the team to immediately update a text field when looking at a report? For us it doesn’t matter what field type this … --- ## [Associate Deal to Company](https://community.hubspot.com/t/associate-deal-to-company/85081)
**Author:** [@iingallslawtige](https://community.hubspot.com/u/iingallslawtige)\ **Replies:** 14\ **Last updated:** [December 9, 2024, 2:35pm UTC](https://community.hubspot.com/t/associate-deal-to-company/85081 "2024-12-09T14:35:06Z")
Hello, I am working on using HubSpot Custom Code Workflow Actions to associate the deal in the workflow with a specific company (I already know the company ID). For the property included in the code, I have the Deal ID… --- ## [Email a List of Contacts via Workflow](https://community.hubspot.com/t/email-a-list-of-contacts-via-workflow/87435)
**Author:** [@GWalsh](https://community.hubspot.com/u/GWalsh)\ **Replies:** 5\ **Last updated:** [December 9, 2024, 6:48am UTC](https://community.hubspot.com/t/email-a-list-of-contacts-via-workflow/87435 "2024-12-09T06:48:07Z")
Is there a way to send an email with a copy of a list to contact owners without them having to enter HubSpot to view the list? We have contacts automatically added to our large ‘Bounce List’ whenever they bounce. I woul… --- ## [Natural Logarithm as calculation option](https://community.hubspot.com/t/natural-logarithm-as-calculation-option/109564)
**Author:** [@FabioLangbein](https://community.hubspot.com/u/FabioLangbein)\ **Replies:** 3\ **Last updated:** [December 7, 2024, 12:27pm UTC](https://community.hubspot.com/t/natural-logarithm-as-calculation-option/109564 "2024-12-07T12:27:42Z")
I would need to use the logarithm log() or even better the natural logarithm ln() in order to create a customer valuation score. I need to use the ln() because I don’t want explosive behaviour in my function if for examp… --- ## [Format Date into normal format when pulling it to the spreadsheet](https://community.hubspot.com/t/format-date-into-normal-format-when-pulling-it-to-the-spreadsheet/79237)
**Author:** [@tverdokhlib1](https://community.hubspot.com/u/tverdokhlib1)\ **Replies:** 7\ **Last updated:** [September 23, 2026, 9:00am UTC](https://community.hubspot.com/t/format-date-into-normal-format-when-pulling-it-to-the-spreadsheet/79237 "2026-09-23T09:00:46Z")
Hey HubSpotters. I have set up Google Sheets integration with HubSpot to pull Contact’s data into it. All works fine, the only thing I’m trying to resolve is that instead of creating a normal Date and Time, HubSpot sen… --- ## [Updating CO records with excel/sheets data via Zapier or similar](https://community.hubspot.com/t/updating-co-records-with-excel-sheets-data-via-zapier-or-similar/52283)
**Author:** [@Bob2245](https://community.hubspot.com/u/Bob2245)\ **Replies:** 7\ **Last updated:** [December 7, 2024, 10:47am UTC](https://community.hubspot.com/t/updating-co-records-with-excel-sheets-data-via-zapier-or-similar/52283 "2024-12-07T10:47:07Z")
So, we’ve got this use case where the client has a weekly generated spreadsheet exported from their finance system. We need to use this sheet to update records in a Custom Object in Hubspot. The sheet has no Hubspot Obje… --- ## [Custom deal view keeps resetting](https://community.hubspot.com/t/custom-deal-view-keeps-resetting/110877)
**Author:** [@CMartin20](https://community.hubspot.com/u/CMartin20)\ **Replies:** 2\ **Last updated:** [December 6, 2024, 9:39pm UTC](https://community.hubspot.com/t/custom-deal-view-keeps-resetting/110877 "2024-12-06T21:39:37Z")
My custom deal views keep resetting when I leave or refresh the page. I create a new view, updated the columns to what I want and change all the filters to create the view I am looking for. As soon as I leave and return … --- ## [Google Sheet API Failing to Import 2% of Contacts From Active List](https://community.hubspot.com/t/google-sheet-api-failing-to-import-2-of-contacts-from-active-list/60083)
**Author:** [@HvanderKloot](https://community.hubspot.com/u/HvanderKloot)\ **Replies:** 4\ **Last updated:** [December 6, 2024, 5:53am UTC](https://community.hubspot.com/t/google-sheet-api-failing-to-import-2-of-contacts-from-active-list/60083 "2024-12-06T05:53:05Z")
Hello, We recently created a Contact-Based Workflow where users from an Active List are enrolled into a Google Sheet via the API integration. The import just completed but we are seeing about 400+ contacts that failed … --- ## [Import a DataSet into a Google Sheet](https://community.hubspot.com/t/import-a-dataset-into-a-google-sheet/59543)
**Author:** [@yano-myhome](https://community.hubspot.com/u/yano-myhome)\ **Replies:** 2\ **Last updated:** [December 6, 2024, 5:48am UTC](https://community.hubspot.com/t/import-a-dataset-into-a-google-sheet/59543 "2024-12-06T05:48:07Z")
Hi, I’m trying to import a Complete Dataset I created into a Google Sheet. Once this is done I would like to have the Google Sheets update every 1 hour with any changes in the Dataset so it is semi-realtime. Thanks … --- ## [Reports on NRR and GRR in Hubspot](https://community.hubspot.com/t/reports-on-nrr-and-grr-in-hubspot/121956)
**Author:** [@dmattauch](https://community.hubspot.com/u/dmattauch)\ **Replies:** 1\ **Last updated:** [December 5, 2024, 10:33pm UTC](https://community.hubspot.com/t/reports-on-nrr-and-grr-in-hubspot/121956 "2024-12-05T22:33:52Z")
Hi, Is it possible to directly report on NRR and GRR in Hubspot with reccuring revenue reporting? Thanks David --- ## [Add proper case option to data format](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834)
**Author:** [@JenWallace](https://community.hubspot.com/u/JenWallace)\ **Replies:** 5\ **Last updated:** [December 5, 2024, 10:27am UTC](https://community.hubspot.com/t/add-proper-case-option-to-data-format/48834 "2024-12-05T10:27:30Z")
We have just started with Operations Hub and I’m setting up some automation that cleans up our data. I have alot of names that are in All Caps. Just using the option to “capitalize” under the automation format data doesn… --- ## [remove contact from a list](https://community.hubspot.com/t/remove-contact-from-a-list/121901)
**Author:** [@msshey](https://community.hubspot.com/u/msshey)\ **Replies:** 1\ **Last updated:** [December 4, 2024, 7:01pm UTC](https://community.hubspot.com/t/remove-contact-from-a-list/121901 "2024-12-04T19:01:49Z")
Hi Team, I have a quick question. I created an active list in HS that pulls contacts from specific stages in the pipeline, which I plan to use in a workflow to send an email blast. Is there a way to automatically remove … --- ## [Custom workflow coding to find and update all overdue tasks associated to a ticket](https://community.hubspot.com/t/custom-workflow-coding-to-find-and-update-all-overdue-tasks-associated-to-a-ticket/108391)
**Author:** [@SemRC](https://community.hubspot.com/u/SemRC)\ **Replies:** 5\ **Last updated:** [December 3, 2024, 12:56pm UTC](https://community.hubspot.com/t/custom-workflow-coding-to-find-and-update-all-overdue-tasks-associated-to-a-ticket/108391 "2024-12-03T12:56:09Z")
Hi all! I have a use case where I want to automate as much as possible in onboarding our new customers (the onboarding phase is tracked via onboarding tickets). This means at every stage tasks are created, and if all ta… --- ## [Custom Coded Workflow Using Custom Objects](https://community.hubspot.com/t/custom-coded-workflow-using-custom-objects/121687)
**Author:** [@MCarr2](https://community.hubspot.com/u/MCarr2)\ **Replies:** 1\ **Last updated:** [December 2, 2024, 4:56pm UTC](https://community.hubspot.com/t/custom-coded-workflow-using-custom-objects/121687 "2024-12-02T16:56:15Z")
Hi everyone, We currently use an integration called Subskribe to manage all of our subscriptions (SaaS). The Subscriptions custom object information is: objectTypeId: 2-21331959 internal name: subskribe\_subscription … --- ## [Hubspot best practice](https://community.hubspot.com/t/hubspot-best-practice/121601)
**Author:** [@ELar7](https://community.hubspot.com/u/ELar7)\ **Replies:** 3\ **Last updated:** [December 2, 2024, 1:10pm UTC](https://community.hubspot.com/t/hubspot-best-practice/121601 "2024-12-02T13:10:10Z")
Hi I’m trying to sort out my company’s hubspot, here is the scenario, I hope someone can help or point me somewhere: They have the Marketing subscription. 10 users Using it since 2016 About 30k records Is there a be… --- ## [mapping the fields](https://community.hubspot.com/t/mapping-the-fields/121507)
**Author:** [@axhhami](https://community.hubspot.com/u/axhhami)\ **Replies:** 7\ **Last updated:** [November 27, 2024, 5:46pm UTC](https://community.hubspot.com/t/mapping-the-fields/121507 "2024-11-27T17:46:19Z")
ich habe ein problem die zuordnungen zu ändern ich will zum beispiel owner und für kontakt zuständiger mitarbeiter ändern zu postleitzahl und postleitzahl was muss ich denn da tun??? --- ## [visualization of repeted customers](https://community.hubspot.com/t/visualization-of-repeted-customers/121498)
**Author:** [@MPedraza3](https://community.hubspot.com/u/MPedraza3)\ **Replies:** 1\ **Last updated:** [November 27, 2024, 2:44pm UTC](https://community.hubspot.com/t/visualization-of-repeted-customers/121498 "2024-11-27T14:44:46Z")
Hello there! How can I visualize in the list of customers the ones that are repeated? [Previous page](https://community.hubspot.com/c/revops-data-hub/64.md?page=15) [Next page](https://community.hubspot.com/c/revops-data-hub/64.md?page=17)