Ask the community

In certain business scenarios, clients may need to extract a value only from the last system opened in a Multi-System configuration. Since the number of systems opened is not known in advance, hard-coding logic for each instance is not feasible.This method allows you to dynamically identify and fetch the value from the last opened system. How to Create a Counter for System TrackingAdd a numeric question inside the Multi-System group. Set its default value to 1. This question will act as a system counter and will be used in an aggregate function (SUM) to determine the total number of systems opened at runtime.How to Use a Proposal Attribute to Identify the Last System To isolate the value from the last system, use conditional logic with the FLOOR() function. Example scenario:Assume the following values from each system:System 1: 100 System 2: 200 System 3: 300Let N be the total number of systems (i.e., the result of the counter using SUM()).Apply the formula:Value * FLOOR(SystemIndex /

Exclude filters are a powerful feature used to dynamically remove or restrict options based on previous user input or existing customer data. Below are three common use cases that show how to implement exclude filters effectively in subscription flows, inclusion logic, and product selection. How to Remove Items from a Text List Based on Existing SubscriptionsUse Case 1: Subscriptions This scenario involves preventing users from selecting a product they already own in a new subscription quote. For example, if a client already has Product A from a previous subscription, it should not appear in the current selection list. InstructionsCreate a dedicated question group for exclude logic.   For each product in your picklist, create a text answer question. Configure conditional answers based on whether the product exists in the client's current subscription. Then, create a text list question that includes all possible products.   Add the previously created text answers as exclude filters on t

By default, subscription data in HubSpot is often filtered based solely on status. However, certain business use cases require fetching not only active subscriptions but also those that have expired within the past three months. This article outlines how to achieve that using a custom field and a structured query. How to Calculate Time Since Subscription End Date in HubSpot To begin, create a custom calculated property in HubSpot that determines the time difference between the current date and the subscription’s end date. This property will allow you to filter subscriptions based on how long ago they expired.The calculated field should return the difference in milliseconds between today and the end date. HubSpot will display this value as a number, making it usable in filters or API queries.For reference, three months is equal to approximately 7,888,128,000 milliseconds.  How to Structure the API Query Once the field is created and populated, you can query both active subscriptions and

In some configurations, it's necessary to identify the latest date entered across multiple entries in a repeatable question group. This is useful in workflows where you need to calculate end dates, trigger validations, or control the visibility of sections based on the most recent event or timeline.The method below outlines how to calculate the maximum date using standard functions and formula questions. How to Configure the Max Date Logic In a regular question group, create a base date question. This date will serve as the reference point for all calculations.  In the repeatable question group, add a formula question that calculates the number of days between the base date and the selected date in that row.  Back in the regular question group, create a formula question using the MAX_IN_GROUP() function to extract the maximum number of days from all repeatable entries.  Finally, add a formula date question that adds the maximum number of days to the base date, effectively reconstructin

One common use case when working with multiple repeatable question groups is when you want a SKU in one group to pull a value, such as quantity, from a specific matching row in another repeatable group. This configuration allows you to tie product selections directly to user-defined attributes or inputs. How to Reference a Specific Row from Another Group To pull a value (e.g., quantity) from a matching row in another repeatable group, the assignment rule must include a comparison that matches a field in both groups. This ensures the value is only pulled when the context aligns—such as matching sites or environments. Example Scenario Let’s assume the following:In Question Group 1, the user defines a list of sites with quantities for each.Question_group_1Site_List Quantity  Site 1 5 Site 2 3 In Question Group 2, the user selects products, and you want a SKU to pull its quantity from the matching site defined in Question Group 1.Question_group_2Site_List SKU Site 1 Product A

In some use cases, clients want to sync the start date of a selected period from a Multi-System question group directly to an opportunity field in the CRM. For this scenario, we’ll assume there can be a maximum of three periods, and the user selects which period to sync.  How to Capture the Selected Period’s Start Date To implement this logic:Set up a global question outside the Multi-System group. This will determine which period (e.g., Period 1, Period 2, or Period 3) should be used for syncing. Inside the Multi-System group, ensure you have a Start Date question for each row (period).    

Scenario AtlasIQ, a SaaS company offering AI infrastructure tools, often builds proposals with multiple pricing packages—such as “Starter,” “Growth,” and “Enterprise”—using DealHub’s Multi-System functionality. While this gives customers flexibility, it created operational friction. Buyers would verbally choose one offer, but sales reps then had to manually remove the unselected systems and products from Salesforce, risking errors and slowing down approvals.To streamline this, AtlasIQ configured a dropdown menu in the DealRoom that lets buyers select the offer they want. Behind the scenes, DealHub converts that selection into a numeric value, which is used to flag which quote system to keep. All other systems are tagged for deletion via a synced proposal attribute (Offer__c) and a custom Salesforce field (Delete__c).Once the buyer submits their choice, Salesforce automatically deletes the non-selected quote lines using DealHub’s Quote Line Deletion package. The final CRM record reflect

ScenarioOptiCloud, a mid-size SaaS company offering customizable cloud analytics, handles complex proposals with multiple SKUs, implementation services, and region-specific legal clauses. Their Sales Ops team was struggling with:Inconsistent formatting in output documents Manual insertion of legal clauses and billing tables Lack of dynamic fields (e.g., product-specific T&Cs, pricing tables, renewal dates) Inability to quickly preview or adjust order forms on a per-client basisTo address this, they standardized on DealHub’s Document and Sub-Document Templates functionality to automate and professionalize document generation.Their most important need right now is to create a custom table in their output document with custom borders. They want to utilize DealHub’s HTML capabilities to achieve this.They also want to be able to add horizontal lines across their document. Solution Step 1: Adding a basic table in Output DocumentsClick on Add Element, then select Text SectionInsert a tabl

Scenario DeployLogic, a SaaS provider offering modular implementation and onboarding services, often sells tailored solution packages to enterprise clients. These packages include multiple components like:Integration Setup Data Migration Training Programs Custom Feature DevelopmentEach of these services has its own start and end date, depending on resource availability, client readiness, and deployment sequencing. The RequirementsWhen a DealHub proposal includes multiple services within a repeatable table, the client success team wants to:Display a single, accurate project timeline summarizing all selected services. Show the earliest start date and latest end date for the entire engagement. Avoid manual errors or the need for reps to calculate summary dates outside the system.This summary data is crucial for the prospect and for setting expectations internally for resource planning.Overview:Using the method in the document, DeployLogic configures DealHub to automatically surface:The Fi

Scenario TechNest, a mid-market SaaS provider of enterprise collaboration tools, operates a multi-tier sales model:Sales Reps can offer limited discounts. Managers and VPs can approve deeper discounts for strategic accounts.However, rather than approving based on a discount percentage, TechNest sets absolute floor prices per SKU. For example, while the list price for the “Collaboration Suite Pro” is $100/user/month, Sales Reps must not go below $80, and Managers must not approve less than $70.DealHub’s standard approval workflows rely on discount percentage thresholds—not specific price points.To meet this requirement the team implemented a flexible floor-price-based approval system using DealHub’s product and proposal attributes, assignment rules, and general workflows, outlined below. Solution PRODUCT ATTRIBUTEIn Products, click on Actions, then click on Settings, then select the “Product Attributes" tab.  Click Add Attribute and change Type to “Number”Label this attribute “Floor Pri

Scenario InsightFlow, a SaaS company, provides a flexible analytics platform with modular features. Customers can choose from a list of add-ons such as:Data Enrichment Predictive Modeling Custom DashboardsEach module adds value, but InsightFlow wants to incentivize volume purchasing through tiered pricing:The first module purchased is priced at a premium. The second module is discounted. Additional modules are priced even lower.This approach increases deal sizes while maintaining perceived value for the primary feature.Traditional CPQ systems price each product independently. However, InsightFlow wants pricing to depend on the order of selection, not the product itself. Regardless of which modules are chosen:First = $50 Second = $30 Third = $15This dynamic pricing must work within the constraints of DealHub’s CPQ engine without requiring hardcoding for every combination. Solution  Playbook Configuration (Set up for a total of 3 products):Add a question to the playbook that is a Text Li

Scenario A cloud communications provider sells products such as API calls, voice minutes, and message transactions. Buyers can either:Commit to purchasing a minimum volume upfront, or Lock in future rates through a rate card, without immediate purchase.Sales needs a way to configure deals that reflect both committed usage (which is billable now) and rate card agreements (which are informational for future usage), all in the same proposal and order form.The goal is to set up a pricing and proposal structure in DealHub that:Differentiates between committed usage (charged now) and rate card usage (charged later). Displays tiered rates and volumes for both types. Automatically updates the order form with correct product details, quantities, and pricing.  Solution Playbook configurationUsing a repeatable table in the playbook is a great tool to create custom tiers or prices for usage products. Suggested questions: Is this a commit or rate card product? This question allows you to know if yo

Scenario GlobaTech, a fast-growing SaaS provider for supply chain automation, operates globally with sales teams and customers across North America, Europe, and APAC. Pricing is maintained in USD, but clients often request quotes in their local currencies (EUR, GBP, AUD, etc.).Previously, reps manually adjusted currency conversions or referenced internal spreadsheets. This created:Inconsistent exchange rates across quotes Manual errors in pricing Discrepancies between DealHub proposals and Salesforce CRM recordsTo solve this, GlobaTech leverages Salesforce’s Manage Currencies feature and integrates it directly with DealHub to automate currency conversion in real-time using the exchange rates stored in Salesforce. Solution OverviewUsing DealHub’s external object integration capabilities, GlobaTech implemented a seamless way to:Automatically pull the customer’s currency from the Salesforce Opportunity. Query Salesforce’s CurrencyType object to fetch the correct exchange rate. Apply that