Hi everyone,
I’m working with a dataset of products and prices, where each product has multiple price points. The dataset structure looks like this:
- Product Code
- Price A
- Price B
- Price C
- (Other fields like Product Weight, etc.)
I also have an Accounts dataset that includes a Price Band field, which is set to values like “Price A”, “Price B”, etc.
The Challenge:
I’m displaying products in a search view, which includes a price column. However, since there is no direct connection between the Price Band and the correct price field in the products dataset, I’ve had to duplicate the search view multiple times - one for each price band to ensure customers only see their relevant pricing.
The Question:
Is there a way to dynamically display the correct price based on the customer’s Price Band without having to maintain multiple search views? Ideally, I’d like to hide irrelevant price fields and only show the price that corresponds to the customer’s assigned Price Band.
Any suggestions or best practices would be greatly appreciated!
Thanks in advance.