I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've created a new custom list called "Purchase Form".

In that "Purchase Form" I want to have below:

  • A auto sequence column "Purchase ID" which will auto generate as "PO-15-####". The behind number will start from 2001.
  • A lookup column of "ProductCode" which will be in Choice mode.
  • A column which have "Unit Price" from another list will automatically generated when we choose the "ProductCode".
  • The main important column is "Purchased Value" which will calculate [Purchased Qty*Unit Price] and results will be in currency or number. [I will another column called "Purchased Qty"(number).]

I've tried lookup but unable to do the calculate. I need to have a workaround without using any backend commands.

Please help me to guide how to do in SharePoint 2013 or InfoPath 2013 without having workflow involved.

  • is javascript allowed?
    – Taran Goel
    Dec 15, 2015 at 8:02
  • How do I check on that? This is my company test site for me to play around and learn more on SharePoint 2013. Please assist.
    – Yuges
    Dec 15, 2015 at 8:06
  • Generally there's no restriction on using client side scripting, though you ll need to check. Why workflows not allowed. Very strange.
    – Taran Goel
    Dec 15, 2015 at 8:19
  • How to do by using workflow? I've never done any workflow before. Please guide on achieving the goal.
    – Yuges
    Dec 15, 2015 at 8:31
  • @TaranGoel: Can you help me with this?
    – Yuges
    Dec 16, 2015 at 5:16

1 Answer 1


In Order to achieve your goal workflows are required. you can't calculate the lookup fields, so you need to copy the lookup field into a single line of text using "Set" value in workflow, do the same for other columns which are unable to calculate. finally after creating all single line of texts you can keep a column for calculated values and get your workdone.

  • It can be done without Workflows but requires all the logic to be done with JavaScript code... not for beginners. Dec 15, 2015 at 8:25
  • How it can be done by using workflow? I've never touched workflow part. Please guide.
    – Yuges
    Dec 16, 2015 at 1:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.