What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to extract the total amount in Purchase Order ?

    Asked by maisonlondres on December 01, 2015 at 11:10 AM

    Hello!

    I know that this question has been asked before but you might have find a solution since then. So I used the purchase order tool and I would like to have  the total amount and the number of products ordered in a separate column on Excel when I download the spreadsheet.

    I know it is not possible straight away but is it possible to extract these number and put it in a hidden field. So when i download the spreadsheet there are in a separate column?

    many thanks for your help!

    .

    Page URL: https://form.jotform.com/53014030776952

    Page URL:
    https://form.jotform.com/53014030776952

    purchase amount in how
  • Profile Image

    Answered by victor on December 01, 2015 at 01:32 PM

    Unfortunately, it is not possible to extract the product quantity from the payment question and place it in a hidden field. Using condition you are able to copy the total amount of the purchase and place in another field

    If you require further assistance, please let us know. We will be glad to help

  • Profile Image
    JotForm Support

    Answered by abajan on December 01, 2015 at 02:32 PM

    @maisonlondres

    Unless I'm misunderstanding the functionality required, it is indeed possible to have a hidden field capture whatever total is displayed in the purchase order field, so that it would appear in a separate column in the form records (and downloaded Excel spreadsheet of those records). If you clone this clone of your form you'll see that it has a hidden field labelled Total. The condition pictured below was added to make that field capture the purchase order total:

    (After clicking the Add Field button, the 0-9 was clicked to change it to a-z and make the button grey.)

    Here's how to clone a JotForm.

    If you need more help with this, we would be happy to provide it.

    Cheers

  • Profile Image
    JotForm Support

    Answered by abajan on December 01, 2015 at 02:39 PM

    Ah never mind. After re-reading your post, I see that I certainly did misunderstand what you meant (and my colleague's reply). While it's possible to have the total appear in a separate column, like my colleague has stated it's not possible to extract the product quantity and place it into hidden (or shown) field. That would require embedding the form's full source in a webpage and adding a custom script.

    Thanks