How to I take my submissions and automatically add the amounts together.

  • Profile Image
    laurashoemake
    Asked on June 05, 2018 at 04:31 PM
  • Profile Image
    jonathan
    Answered on June 05, 2018 at 06:04 PM

    If I understand correctly, what you wanted to do is to get the grand total/amount of all the submission data from your Order Form.

    You can do this by exporting the data first to a spreadsheet.

    You can either Create Excel Report and do the additions in the Excel app.

    Or use google spreadsheet integration and do the additions in spreadsheet.

    I hope this help. Let us know if you need further assistance on this.

  • Profile Image
    laurashoemake
    Answered on June 06, 2018 at 09:43 AM
    I tried the Excel Report, but it puts all the items and numbers in one line.
    When doing the Google Spreadsheet Integration, does it need to be done before submissions of the jotform are done?
    ...
  • Profile Image
    aubreybourke
    Answered on June 06, 2018 at 11:35 AM

    You might be able to parse your spreadsheet

    Can you tell us what data exactly did you want to extract? 

  • Profile Image
    aubreybourke
    Answered on June 06, 2018 at 11:52 AM

    Using the text to columns function on the data tab in Excel, I chose the other delimiter. It splits all the data in the one cell so each is in its own cell.

    For example:

    1528300344textToColumns.gif 

  • Profile Image
    laurashoemake
    Answered on June 06, 2018 at 12:43 PM
    I have an order form where people ordered quantities of items. I wanted to be able to total each individual item, so I wouldn’t need to do it.
    ...
  • Profile Image
    laurashoemake
    Answered on June 06, 2018 at 12:43 PM
    Ok.
    It appears that the items are in different columns, so when use the delimiter for one column, the rest disappear, so it gives one set of quantities, but the rest disappear.
    ...
  • Profile Image
    aubreybourke
    Answered on June 06, 2018 at 02:19 PM

    OK, firstly you need to press CTRL + J for a newline delimiter in the other field.

    If you go to the Data preview you will see a border line for each product.

    1528308531hy64x.png

    You will see that it breaks the all-in-one cell into several cells for each product:

    15283089135x17h.png

     

    Getting this far is a good start. But you still have a bit of work to do. Unfortunately my Excel knowledge is limited. So you will have to visit a forum to see how you can add all the quantities of each product.

    https://www.excelforum.com/

    They would be able to give you a much better answer than I can provide.

  • Profile Image
    laurashoemake
    Answered on June 06, 2018 at 02:43 PM
    Thanks for all your help. I do appreciate it.
    ...