Submission Table-Add column with Order Total ($)

  • Profile Image
    gleparentclub
    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
    alara
    Answered on November 08, 2021 at 12:47 AM

    Hello,

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

    QHaQC_H9-rY977qLB8baluPNqbgImvBCYe3WYLNT

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

    MAJUCsmZ2SO3RVWlRkzOz0-vbl7hMa8LGQG9ZVA7

    3.Please choose “Update/Calculated Field”.

    VmYlBVRyLsmwfMfoAhtdLGm8Mxh5CpmraXwMeh2q

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

    KxpuRFiwa_26fLI1K-Z9QFJkdRY0R4w_z0v9QXTX

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

    kgtRBGNBQ7uZmhI_0xxy-BRGTRg_m6Hr-Rk3hUub

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


  • Profile Image
    gleparentclub
    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.

    1636510821_618b2c6572859_WOJOS-JOTFORM-S

  • Profile Image
    gerardw
    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:

    1636537415_618b94476e559_1011_8.png

    Please try and let us know.

  • Profile Image
    gleparentclub
    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
    Niko_N
    Answered on November 11, 2021 at 11:43 AM

    Greetings,

    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
    gleparentclub
    Answered on November 11, 2021 at 09:48 PM

    Thank you so much for your help!