Need help with a complex pricing matrix

Hi Gliders,

I’m working on building a pricing tool and could use some help with the setup.

I’m trying to create a system to estimate repair costs for vehicles. Each repair has multiple factors affecting the price. For example, if we’re repairing a specific panel, the price depends on the size of the damage and the number of damage spots.

Here’s what I’m working with:

  1. Estimates Table: This is where we keep track of each repair job.
  2. Pricing Structure Table: This contains the pricing details based on different factors.

I’m having trouble figuring out how to link the chosen damage parameters to the specific panel with the pricing structure inside the estimates table.

Should I set up the pricing details in a single table? How can I relate these factors (damage size and count) to the panel being repaired?

I’ve tried using if-then-else logic but can’t seem to match the price correctly. I hope this makes sense, any suggestions or examples would be really appreciated!

Thanks!

How are you structuring the Pricing Structure Table? How complex is the logic you’re trying to have here?

Hi ThinhDinh

So would contain a list of each panel of a car (hood, fender, door etc) and then would have columns for a dent count (10 different category options), dent size (4 different options) and then all would have respected pricing.