I’m using a relationship to fill the estimate lines with the proper price for a given product in function of the qty of product ordered.
It works well. Except that I need to find a way to control the “infinite” concept.
Initially I was using -1 as volume treshold for price codes that don’t have upper limits e.g. a product which would have only a regular price, or the top volume level e.g. regular 1-10, vol1 11-20, vol2 21+
Unfortunately, that is interpreted as smaller than the first threshold so it make it the first threshold and bumps all others.
I thought of having an auto-calc that would convert “” into 10 000 000 which seems reasonnably high. But somehow, the autocalc won’t fill the field with it.
I could also have a button that the client can press to have it set the field to ten millions but that’s not really “modern” lol.
> This is the relationship.
> And below, the field definition for threshold which doesn’t replace with 10millions if empty.
Below you can see that the smallest quantity in the Teal treshold should have the higher price and the top quantity (pink) should fall above the last treshold set (volume2) and have the smallest price. In other words, the pink square on the left should be at the bottom but because it is 0 instead of infinite, it bumps the other volumes down.