Q & A
Multiple Formulas for the Same Item
Could you add a way to have a dropdown menu for multiple formulas in an item. Let's say you are measuring paint in gallons or 5 gallons. Paint is just an example of many that exist. Could also be if you want to calculate items by SF vs by how it is sold at the stores, like boxes or bags, etc.
The idea is to save the logic of an item.
You can with a check box and an "if" formula
This decides if I am measuring door trim by the meter or by the door
if([Mtrs (otherwise sets)]==0,1,5
I have a check box called [Mtrs (otherwise sets)] so when I check it it multiply's the door i have counted x5 which is 5 meters per door otherwise it counts the door x 1 which is a set per door
You can do it with a dropdown if you have more than 1 variation by having multiple "if' formulas and you could probably also do it by adding the variations to a product list.