how to do a calculations based on the user selected option??

I need to create a approval workflow for user to submit a request, and there needs have a simple calculation based on what user choose to calculate cost for the course.

If user choose Course A + Location A, the Cost field need to show $1000 & start the approval workflow for the manager to approve.

I have no idea on how to do that...can anyone help?!?!?!

I should setup another list with Course + Location table as below? I didn't know how the list can based on this 2 criteria to retrieve the cost & then to start the approval workflow....so confusion...........

And there have another requirement, if user choose a field called Vendor A, it will need to choose Vendor A cost*6.25% something like that............how to do that??

Sorry i may be explain my question very clearly....because i am too confused....if you have any idea/example/youtube can help me.. please let me know~~~~~~~

June 23rd, 2015 8:15am

hi

you should have a list with corses

Column 1 : Corse_name

Column 2 : Price

A seconf list , with a site column : LOcation ( as multiple chocies : location A, Location B )

and another lookup column ( from first list ) - don't forget to check there also Price column

Next attahc an approval workflow to this second list based on values selected by the user

If you need more details. let me know

Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2015 11:35am

Oh.sorry, i am not quite understand..please forgive me as i am so stupid....

The price is based on both course & location choose by user. Not only the course name, so how to put in the value on the first list??


June 24th, 2015 8:08am

Do you think I can set it as calculated field (e.g. price), create a single list with column Course(choice field) and column Location (choice field) and then the price field set the formular if Course = A and Location = A, Price = 1000?

But I didn't know the syntax how to set if if Course = A and Location = A then price = 1000, If course = A and location = B then price = 1140


Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 3:36am

is that not possible to do that? Please help........
July 7th, 2015 9:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics