cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

how to caculate total price automaticatically based on selected product in nintex forms

i want to get total price automatically based on a prodcut model selected in dropdown down list and by entering  its quantiity another filed with out mentioning unit price externally on form

Labels: (1)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

where do you store unit price? in an other list?

then use lookup()  function to query for unit price by the model selected and multiply the result with given quantity.

Accept as Solution Reply
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

If you have a UnitCost field in another list called Products, and a list lookup control in your form called Product List, and field named Quantity, the formula in the calculated field for total price would look like this:

lookup('Products', 'Title', parseLookup(ProductLookup), 'UnitCost') * Quantity

In this case the select lookup value is matched against the Title field in the Products list. If you need multiple line items for the order it can get more complicated.

 

Accept as Solution Reply
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

I am using cascading dropdowns like Product Line one DropDown,if we select that Product line in dropdown related product models are displayed in another dropdown for each and every product model unique price is there but we dont want to show price for each product model externally in form i have created Product line list as onelookup   and i create productmodel list in that i use lookup of productline, along with that product model column,

created another list called price list in that i create a productmodel which was a lookpup filed in that list and a price coloumn for each and every productmodel. i created a one transaction list  for store the details we provide in form wtih theese coloumns like Productline,productmodel,quatity,estimated price in form if i select productline value in dropdown related producmodels are displayed in productmodel dropdrown if select value in product model dropdown and  after provide quantiy value  manually in text filed in form i need to get estimated price automatically i have used  calulated value in from to get estimated price. i tried in diffrent process but not estimated value is not geeting how could i acheive it.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

i am doing same only waht you mention but i am not getting i have created price and prodcutmodel in one list,price related to each productmodel which was a lookup column in that list 

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

I believe following formula should give you the price

lookup('PriceList','ModelLookupField',parseLookup(ModelCtrl,false),'ModelUnitPriceField') * QuantityCtrl
0 Kudos
Accept as Solution Reply
Workflow Hero

Re: how to caculate total price automaticatically based on selected product in nintex forms

It might help to break down the problem and test each step individually. I've posted more information here http://www.tekdoginc.com/blog/updating-total-price-in-sharepoint

0 Kudos
Accept as Solution Reply