How to Dynamically Display Relevant Pricing in a Search View?

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.

Hi @marketing1,

Your way makes sense if the Price A, B and C are fields within the Product table, without the need for any code.

You could introduce another table called Product prices, which relates to the product and price band.

You would then show a search view of: Product price records connected to the same Price band connected to the logged-in Account.
You can also pull in fields from the connected Product to display (e.g. weight, etc).

PROS:

  • Allows you to maintain a history of prices (old prices can be archived)
  • One single view, filtered by connected price band

CONS:

  • More record consumption
  • Manually add product price records after a product is created
  • Risk of duplication (e.g. Product A has two active Price Band A records)

Hope that helps!