# Data **URL:** https://community.hubspot.com/c/revops-data-hub/64.md?page=12 [Latest](https://community.hubspot.com/latest.md) · [Categories](https://community.hubspot.com/categories.md) · [Tags](https://community.hubspot.com/tags.md) **Page:** 13 --- ## [Cannot merge two contacts using custom code in workflow](https://community.hubspot.com/t/cannot-merge-two-contacts-using-custom-code-in-workflow/130510)
**Author:** [@customtruck](https://community.hubspot.com/u/customtruck)\ **Replies:** 2\ **Last updated:** [April 25, 2025, 5:15pm UTC](https://community.hubspot.com/t/cannot-merge-two-contacts-using-custom-code-in-workflow/130510 "2025-04-25T17:15:42Z")
I am attempting to use the custom code workflow capabilities in Operation Hub to merge two contacts if they match on the mobilephone (internal name) property. This is very similar to the use case provided by Hubspot staf… --- ## [Non-Profit Fundraising and Revops!](https://community.hubspot.com/t/non-profit-fundraising-and-revops/130519)
**Author:** [@NFarrell](https://community.hubspot.com/u/NFarrell)\ **Replies:** 1\ **Last updated:** [April 25, 2025, 7:50am UTC](https://community.hubspot.com/t/non-profit-fundraising-and-revops/130519 "2025-04-25T07:50:48Z")
Hi! I am a rev ops associate and database administrator for a non profit. We are newly integrating hubspot into our revenue operations and trying to establish a flow that minimizes any redundancies or error or confusion… --- ## [how to connect custom pixel changer to wp](https://community.hubspot.com/t/how-to-connect-custom-pixel-changer-to-wp/130276)
**Author:** [@Theo6578](https://community.hubspot.com/u/Theo6578)\ **Replies:** 2\ **Last updated:** [April 25, 2025, 4:22am UTC](https://community.hubspot.com/t/how-to-connect-custom-pixel-changer-to-wp/130276 "2025-04-25T04:22:20Z")
how can i connect pixel changer tool https://resizepanda.com/ (custom to wordpress) --- ## [Subscription Products Lifecycle Management](https://community.hubspot.com/t/subscription-products-lifecycle-management/130168)
**Author:** [@kpmc](https://community.hubspot.com/u/kpmc)\ **Replies:** 3\ **Last updated:** [April 24, 2025, 4:58pm UTC](https://community.hubspot.com/t/subscription-products-lifecycle-management/130168 "2025-04-24T16:58:15Z")
Hi, We are currently a Salesforce shop using Salesforce CPQ (previously Steelbricks) and we are considering a move to HubSpot. We are using CPQ to generate order forms for new business deals, expansions and renewals. We… --- ## [Record Deletions and warehousing considerations](https://community.hubspot.com/t/record-deletions-and-warehousing-considerations/125968)
**Author:** [@idanc](https://community.hubspot.com/u/idanc)\ **Replies:** 3\ **Last updated:** [April 24, 2025, 3:20pm UTC](https://community.hubspot.com/t/record-deletions-and-warehousing-considerations/125968 "2025-04-24T15:20:50Z")
Hi, We use Workato to pull data out of HubSpot into a BigQuery data warehouse. Our challenge is that the API from Hubspot to Workato doesn’t recognize deleted records. Hence, everytime a record is merged or deleted from… --- ## [Custom object search API not correct?](https://community.hubspot.com/t/custom-object-search-api-not-correct/53345)
**Author:** [@thomasvbe](https://community.hubspot.com/u/thomasvbe)\ **Replies:** 2\ **Last updated:** [April 24, 2025, 2:07am UTC](https://community.hubspot.com/t/custom-object-search-api-not-correct/53345 "2025-04-24T02:07:30Z")
Hi I wanted to search for a custom object that I’ve created and wanted to use the API in a custom code workflow. The documentation states that you have to use the following: const apiResponse = await hubspotClient.crm.… --- ## [How to change current Timezone](https://community.hubspot.com/t/how-to-change-current-timezone/117416)
**Author:** [@esealpha](https://community.hubspot.com/u/esealpha)\ **Replies:** 3\ **Last updated:** [April 23, 2025, 9:44am UTC](https://community.hubspot.com/t/how-to-change-current-timezone/117416 "2025-04-23T09:44:44Z")
So now, one of the Formatting issues I can fix is the UTC Timezone. I can do this in the Location section of Formatting issues. But I can only mass apply the change to 50 records at a time. How can I automate this featur… --- ## [Confused about Products, Payments, Contacts, and Deals](https://community.hubspot.com/t/confused-about-products-payments-contacts-and-deals/130199)
**Author:** [@Jsum](https://community.hubspot.com/u/Jsum)\ **Replies:** 6\ **Last updated:** [April 23, 2025, 6:07am UTC](https://community.hubspot.com/t/confused-about-products-payments-contacts-and-deals/130199 "2025-04-23T06:07:41Z")
I’m setting up what I thought would be a simple set of automations. The client has an intake form for scheduling consultations. They have 2 types of consultations. I set a property for “which product” on the form that h… --- ## [Calculating NRR](https://community.hubspot.com/t/calculating-nrr/89398)
**Author:** [@timo1](https://community.hubspot.com/u/timo1)\ **Replies:** 7\ **Last updated:** [April 22, 2025, 2:00pm UTC](https://community.hubspot.com/t/calculating-nrr/89398 "2025-04-22T14:00:59Z")
Hey team, I figured out how to dynamically track Net Revenue Retention / team members as a percentage via custom code. The only problem is that to get it accurate at a company level, I need to divide the sum of all NRR… --- ## [\[WRAP UP\] Becoming a HubSpot Admin - 5 Lessons Learned from a HubSpot Admin](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-5-lessons-learned-from-a-hubspot-admin/55859)
**Author:** [@jbogaert](https://community.hubspot.com/u/jbogaert)\ **Replies:** 1\ **Last updated:** [April 21, 2025, 5:49am UTC](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-5-lessons-learned-from-a-hubspot-admin/55859 "2025-04-21T05:49:21Z")
Hi everyone! Yesterday, Matt Bolian of RevPartners, a HubSpot RevOps agency, held the series finale of the three-part event series called: Becoming a HubSpot Admin, with a special interview with the HubSpot Admin Chr… --- ## [Removing company associations automatically after Job change enrichtment](https://community.hubspot.com/t/removing-company-associations-automatically-after-job-change-enrichtment/127787)
**Author:** [@CarlosvBoekhold](https://community.hubspot.com/u/CarlosvBoekhold)\ **Replies:** 5\ **Last updated:** [April 20, 2025, 5:31am UTC](https://community.hubspot.com/t/removing-company-associations-automatically-after-job-change-enrichtment/127787 "2025-04-20T05:31:38Z")
Hi everyone, We recently started using Apollo and are looking into assigning people to the right companies, since we all know people can switch jobs. It sadly becomes a mess when you want to do this since the old assoc… --- ## [Transitioning from Sales to RevOps](https://community.hubspot.com/t/transitioning-from-sales-to-revops/130053)
**Author:** [@FKhan3](https://community.hubspot.com/u/FKhan3)\ **Replies:** 2\ **Last updated:** [April 19, 2025, 6:16pm UTC](https://community.hubspot.com/t/transitioning-from-sales-to-revops/130053 "2025-04-19T18:16:09Z")
Hey everyone! With 3 years of B2C sales experience, I’m now making the move into the RevOps space. I’m excited to be part of this community and really looking forward to learning from you all along the way! If you could … --- ## [\[WRAP UP\] Becoming a HubSpot Admin - 5 Tips from a RevOps Recruiter](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-5-tips-from-a-revops-recruiter/55653)
**Author:** [@jbogaert](https://community.hubspot.com/u/jbogaert)\ **Replies:** 3\ **Last updated:** [April 19, 2025, 2:54am UTC](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-5-tips-from-a-revops-recruiter/55653 "2025-04-19T02:54:05Z")
Hi everyone! Matt Bolian of RevPartners, a HubSpot RevOps agency, continued his three-part event series called: Becoming a HubSpot Admin – 5 Tips from a RevOps recruiter. In this post, you’ll find all the resources … --- ## [\[WRAP UP\] Becoming a HubSpot Admin: The 5 Stages of the HubSpot Admin](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-the-5-stages-of-the-hubspot-admin/52574)
**Author:** [@jbogaert](https://community.hubspot.com/u/jbogaert)\ **Replies:** 7\ **Last updated:** [April 19, 2025, 2:33am UTC](https://community.hubspot.com/t/wrap-up-becoming-a-hubspot-admin-the-5-stages-of-the-hubspot-admin/52574 "2025-04-19T02:33:59Z")
Hi everyone! Yesterday, Matt Bolian of RevPartners, a HubSpot RevOps agency, kicked off a three-part event series for our community called: Becoming a HubSpot Admin. In this post, you’ll find all the resources for y… --- ## [Colored properties for Property Sync](https://community.hubspot.com/t/colored-properties-for-property-sync/130174)
**Author:** [@THayes3](https://community.hubspot.com/u/THayes3)\ **Replies:** 1\ **Last updated:** [April 18, 2025, 7:37pm UTC](https://community.hubspot.com/t/colored-properties-for-property-sync/130174 "2025-04-18T19:37:28Z")
The ability to apply colors to properties has been great but theres a gap. When creating a Property Sync, you can only apply color to the Property you are syncing from. I have a Company drop down property with two color… --- ## [Use Hubspot form to create Salesforce Opps without creating Hubspot contact](https://community.hubspot.com/t/use-hubspot-form-to-create-salesforce-opps-without-creating-hubspot-contact/130147)
**Author:** [@JSmith84](https://community.hubspot.com/u/JSmith84)\ **Replies:** 2\ **Last updated:** [April 18, 2025, 2:40pm UTC](https://community.hubspot.com/t/use-hubspot-form-to-create-salesforce-opps-without-creating-hubspot-contact/130147 "2025-04-18T14:40:14Z")
Hi there, can someone help? I need to create a form in Hubspot (very simple, just a couple of fields) that goes on to create an Opportunity in Salesforce. Is this possible without the form creating a Contact in Hubspot… --- ## [2 way sync custom object with hubspot and salesforce](https://community.hubspot.com/t/2-way-sync-custom-object-with-hubspot-and-salesforce/98664)
**Author:** [@MohitK1](https://community.hubspot.com/u/MohitK1)\ **Replies:** 7\ **Last updated:** [April 15, 2025, 11:38pm UTC](https://community.hubspot.com/t/2-way-sync-custom-object-with-hubspot-and-salesforce/98664 "2025-04-15T23:38:08Z")
We are seeking clarification on the integration capabilities between HubSpot and Salesforce for custom objects. According to information found in a documentation article on the official HubSpot site, it is stated that th… --- ## [How to set recipient name and email based on Google Sheets scenarios](https://community.hubspot.com/t/how-to-set-recipient-name-and-email-based-on-google-sheets-scenarios/124583)
**Author:** [@FMurad](https://community.hubspot.com/u/FMurad)\ **Replies:** 7\ **Last updated:** [April 15, 2025, 3:02pm UTC](https://community.hubspot.com/t/how-to-set-recipient-name-and-email-based-on-google-sheets-scenarios/124583 "2025-04-15T15:02:59Z")
I’m looking to build a rather complex automation, and was wondering if it was possible. I have a Google Sheets worksheet with some “scenarios.” It contains scenarios 1-20 under a Scenarios column. Each scenario is deter… --- ## [MDynamics365 Sync - No association mapping for Contact or Company?](https://community.hubspot.com/t/mdynamics365-sync-no-association-mapping-for-contact-or-company/129687)
**Author:** [@PThomasFuelius](https://community.hubspot.com/u/PThomasFuelius)\ **Replies:** 5\ **Last updated:** [April 15, 2025, 1:47pm UTC](https://community.hubspot.com/t/mdynamics365-sync-no-association-mapping-for-contact-or-company/129687 "2025-04-15T13:47:28Z")
Hi guys, When setting up a sync for a custom object, at the top of the list for the HubSpot side of the sync are all available associations. These have worked fine so far. However when attempting to do the same for … --- ## [How to use Change Source data in workflows and reports](https://community.hubspot.com/t/how-to-use-change-source-data-in-workflows-and-reports/126333)
**Author:** [@LMC-Alex](https://community.hubspot.com/u/LMC-Alex)\ **Replies:** 5\ **Last updated:** [April 15, 2025, 11:52am UTC](https://community.hubspot.com/t/how-to-use-change-source-data-in-workflows-and-reports/126333 "2025-04-15T11:52:50Z")
I’m trying to figure out how I can use property “change source” information in workflows and/or reporting (see screenshot). My use case: We have a number of different ways of updating data: 1. Manual 2. Workflow … --- ## [Trigger workflow based on object associations](https://community.hubspot.com/t/trigger-workflow-based-on-object-associations/116332)
**Author:** [@kieranknock](https://community.hubspot.com/u/kieranknock)\ **Replies:** 4\ **Last updated:** [April 14, 2025, 10:00pm UTC](https://community.hubspot.com/t/trigger-workflow-based-on-object-associations/116332 "2025-04-14T22:00:37Z")
Is there any way to trigger a workflow (in this case for deals) based on an association, or lack thereof with another object? I need to identify deals that have no company associated with them so that we can attempt to … --- ## [Leads vs Introducer Custom Object](https://community.hubspot.com/t/leads-vs-introducer-custom-object/128716)
**Author:** [@SKerrigan5](https://community.hubspot.com/u/SKerrigan5)\ **Replies:** 3\ **Last updated:** [April 14, 2025, 8:38am UTC](https://community.hubspot.com/t/leads-vs-introducer-custom-object/128716 "2025-04-14T08:38:20Z")
We use companies for client companies and have a custom object for introducer companies which is working quite well and I’d like to keep the two separate. We associate the introducer to companies and deals that they are … --- ## [Sync contacts and activity across 20 portals](https://community.hubspot.com/t/sync-contacts-and-activity-across-20-portals/87055)
**Author:** [@aleksbasara](https://community.hubspot.com/u/aleksbasara)\ **Replies:** 7\ **Last updated:** [April 11, 2025, 2:03pm UTC](https://community.hubspot.com/t/sync-contacts-and-activity-across-20-portals/87055 "2025-04-11T14:03:35Z")
Hi, I’m currently working on a PoC for syncing contacts and their activity across 20 HubSpot portals. I’ve already looked at make and Zapier, but I guess there is a cleaner way to do that. Any ideas? Best Aleks --- ## [3 Dashboard into 1](https://community.hubspot.com/t/3-dashboard-into-1/128228)
**Author:** [@ynnaejnyl](https://community.hubspot.com/u/ynnaejnyl)\ **Replies:** 4\ **Last updated:** [April 9, 2025, 4:27pm UTC](https://community.hubspot.com/t/3-dashboard-into-1/128228 "2025-04-09T16:27:20Z")
Hi guys! Asking for your assistance. How do I make this 3 Dashboard into 1 Dashboard only? I tried creating one, the Date entered “LCB (Lead Status)” (the Launch Call Booked) has the accurate data (sort of), while the … --- ## [Workflows automatically creates lists I don't want](https://community.hubspot.com/t/workflows-automatically-creates-lists-i-dont-want/121450)
**Author:** [@EVatsev](https://community.hubspot.com/u/EVatsev)\ **Replies:** 3\ **Last updated:** [April 9, 2025, 3:43am UTC](https://community.hubspot.com/t/workflows-automatically-creates-lists-i-dont-want/121450 "2025-04-09T03:43:29Z")
Hello, I am creating a deal based workflow that will add deals to a list when a deal contains a specific line item. I created a static list, tested the workflow and it does what it’s purpose is. However, it created a l… --- ## [Google sheet sync](https://community.hubspot.com/t/google-sheet-sync/119830)
**Author:** [@KMorka](https://community.hubspot.com/u/KMorka)\ **Replies:** 7\ **Last updated:** [April 8, 2025, 1:23pm UTC](https://community.hubspot.com/t/google-sheet-sync/119830 "2025-04-08T13:23:36Z")
How can I import data from active list in Google Sheet to HubSpot and use this data in workflows? --- ## [Using calculation properties via form / alternatives?](https://community.hubspot.com/t/using-calculation-properties-via-form-alternatives/129477)
**Author:** [@MHarju](https://community.hubspot.com/u/MHarju)\ **Replies:** 7\ **Last updated:** [October 29, 2026, 5:34pm UTC](https://community.hubspot.com/t/using-calculation-properties-via-form-alternatives/129477 "2026-10-29T17:34:54Z")
Hi all, Is anyone using HubSpot to calculate time to do something? Example; product x takes 4 hours to complete. Customer or… --- ## [Calculated fields return null values](https://community.hubspot.com/t/calculated-fields-return-null-values/129401)
**Author:** [@Huntscape-Ops](https://community.hubspot.com/u/Huntscape-Ops)\ **Replies:** 11\ **Last updated:** [April 7, 2025, 7:10pm UTC](https://community.hubspot.com/t/calculated-fields-return-null-values/129401 "2025-04-07T19:10:50Z")
I am trying to use a calculated field, but if one of the values is empty in the calculation, then it returns a null value. (\[properties.imported\_total\] + \[properties.total\_donations\]) There has to be an easy way to fix… --- ## [Sheets sync](https://community.hubspot.com/t/sheets-sync/126313)
**Author:** [@Akash\_Vi\_R](https://community.hubspot.com/u/Akash_Vi_R)\ **Replies:** 2\ **Last updated:** [April 7, 2025, 3:22pm UTC](https://community.hubspot.com/t/sheets-sync/126313 "2025-04-07T15:22:38Z")
I’ve been using Superjoin for syncing Hubspot data into Sheets. Are there other tools I can use? I’ve tried Zapier & Make in the past, but quite comfortable with Superjoin. The advantage with Zapier or Make is I can pul… --- ## [Datasets - Use association labels](https://community.hubspot.com/t/datasets-use-association-labels/92079)
**Author:** [@SLABONNE](https://community.hubspot.com/u/SLABONNE)\ **Replies:** 4\ **Last updated:** [April 4, 2025, 10:19am UTC](https://community.hubspot.com/t/datasets-use-association-labels/92079 "2025-04-04T10:19:12Z")
Hello, I am creating a dataset for Transactions and a Custom Object I would like to see and use association labels, as in a normal report, but this seems impossible Is there another way? Thank you! [Previous page](https://community.hubspot.com/c/revops-data-hub/64.md?page=11) [Next page](https://community.hubspot.com/c/revops-data-hub/64.md?page=13)