I have 2 tables in my app. One is an inventory table with a master data list of SKU details, cost, selling price, etc.
Another table I have is a “SKU pricing scale”. This scale table has few fields: Min, Max, Markup %.
Different price ranges have different markups (e.g. $0-500 = 25% markup, $500-1000 = 20% markup, and so on.)
Thanks. While testing this out I found that we’re missing an operator (“Greater than or equal to” and “Less than or equal to”) in the filter options. We need to add this to make it work, we’ll have this done soon.
Here’s a video demonstrating how to do this with a pipe. I wish it was simpler, but hopefully this can help for now.
Main issue with this which is still being worked on is that if the value falls on an exact number in the max or min field it will not work. For that we need an operator that is “higher than or equal to” and “lower than or equal to”
So I sent you a video regarding decimal values not passing through the API filters.
And one other question I had - is there a way to connect the two tables in such a way that when any of the scales change, the master table would get the updated selling price right away. All SKUs that fall within the updated scale margin, would get updated. Vice versa, if I update a SKU record in the sku table, I can create a table rule “created or edited” to automatically pull in the correct scale at that moment.
I’m curious if there’s a way to make these two tables “sticky” and have the scale always push.