Submission Table-Add column with Order Total ($)

  • Profile Image
    Asked on November 07, 2021 at 08:26 PM

    I'd like to be able to pull out the Total($) for each order and have it show up in a 'Total' Column. I assume I need to make a new column and somehow tell it to show the specific Field ID for the 'Total' in that column. I just can't seem to find what that Field ID is? I did an 'inspect' on the form and cannot locate it.

  • Profile Image
    Answered on November 08, 2021 at 12:47 AM


    1.Please add a new “Number” field to your form and name it, for example, “TOTAL”.


    2.Please add a new condition by choosing “Settings” and then “ Conditions”.


    3.Please choose “Update/Calculated Field”.


    4. As it was shown before, the name of the product list has became “Products”


    5. Please Make the value of “Product” field equal to “Total” field.


    Please let us know if you need further assistance, we are happy to help.

  • Profile Image
    Answered on November 09, 2021 at 09:20 PM

    Hi, thanks for the help.

    I do not have "Products" as an option to select in the IF field.


  • Profile Image
    Answered on November 10, 2021 at 04:43 AM

    Your product list field does not have any label and hence you are not seeing that on the condition.

    See below - Select payment field id11 which is your product field:


    Please try and let us know.

  • Profile Image
    Answered on November 11, 2021 at 11:07 AM

    Thanks, I now have a total column on my submissions chart but it is blank. So am I to assume that numbers will only be added in that column for new orders that come in and won't show the total for any of the existing orders?

  • Profile Image
    Answered on November 11, 2021 at 11:43 AM


    You are right. Those data will be added for the new submissions made.

    For instance, if I go ahead and make a submission with the following products, the Total field will get the same value:

    1636648913_618d47d12f093_Screenshot 20211636648911_618d47cfd18ec_Screenshot 2021

    For the existing submission, you may manually put the values for the TOTAL field.

    Thank you!

  • Profile Image
    Answered on November 11, 2021 at 09:48 PM

    Thank you so much for your help!