OK so here's an interesting one. I have two lists that I'm working with here. List A is the Suppliers list and List B is the Products. Product lookup is nested in a repeating table along with a single line of text column called Quantity and a calculated field named Calc_Price. This field is looking up the Products list. So using Cascading dropdown you choose a Supplier which then filters out that supplier's product in the nested dropdown then you choose a product and the calc field pulls the price. So I already have a formula in that field. As you can see in my screenshot I have everything totalling up nicely in Order Total field.Â
Â
My issue is I want to be able to add it by quantity as well. Meaning as in my screenshot if I choose two items in the Quantity field that number should become 200. It should also be noted there's a hidded Calc field that counts all those prices and adds them with Tax and Shipping to give the Order Total at the bottom. Any help would be greatly appreciated. Thanks to everyone in advance.
Â
Â
Best answer by MegaJerk
View original