Submission Table-Add column with Order Total ($)

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.

Hello,

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.

Hi, thanks for the help.

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

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.

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?

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:

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

Thank you!

Thank you so much for your help!