With HubSpot increasingly at the center of our tech stack, it's often necessary to create mappings from one system to another. For example, we have service teams and our invoiced revenue in Quickbooks is attributed to that service team. However, in QBO, that's a really string of characters. Current integration mappings don't work for many use cases. While this could be done through Workflows, the immediacy of calculated properties makes them a superior solution here. I'd love a "switch" or "case" function for calculated properties. This would make the calculation a lot easier to read and maintain compared to a long nested IF statement. If I need to create a calculated property for "Quickbooks Class" based on our "Assigned Service Team" property, I'd love to have the Quickbooks Class property be a calculated property, simlar to something like: ---- Switch ( [assigned_service_team], {'west_region','A34567890'}, {'east_region','B987654323'}, {'north_central_region','C8625638397'}, {default,'00000000000'} ) I'm not suggesting this be the exact implementation, but this would save me a ton of time for many use cases that involve mapping HubSpot property values over to other systems. This is especially valuable for established portals where you can't just change the internal property value to match the receiving system's needs. Possible use cases: * HubSpot object ID to a different object id * Pipeline or stage ID values to a project management system * company IDs to QBO company IDs * Product Names to Wordpress product IDs An alternative approach to this may be to create a HubDB Lookup function. Again, just off the top of my head, something like: ----- HubDBLookup([assigned_service_team], TableID, LookupColumnName,ReturnColumnName,DefaultValue) So, in this case I would look up my assigned service team in the HubDB table with the ID I pass in. I'd search for that value in the LookupColumnName column and set my new property value to the value in the ReturnColumnName. And optionally, I could specify a default value if nothing is found. Either one of these solutions would be incredibly beneficial for us.
...read more