How do I populate a column in a table with the amount (total) charged?

Hi,

My default table has everything I need except the amount paid. I was able to create an empty column for these values but I cannot figure out how to populate automatically. I can add the values manually but that is a lot of work.

Thanks,

Chris

Hi, thank you for contacting support.

You can create a new column in the submission table using a Formula you have. See the image attached:

You just need to specify the formula and the fields that you need to generate the correct value.

Please give it a try and let us know if you need further assistance.

Thank you.

Hi Jovanne_A,

Thanks for that info. When I open the formula builder it does not show any of the submission field from the Square Products plug-in where the value of the courses are listed. The only place where I might have a clue on the amount being charged is from a field called 'intended course'. This does not necessarily indicate what they are being charged. Is there a way to access the submissions fields of the Square integration? Other wise I would have to try to construct a case statement like.

If intended course is{

children class then x =1;

youth class then x = 13;

adult class then x =17;

end case.

Or something like that. I am not sure how to go about it though. Are there other options?

Chris

I understand that you want to show the total amount as a separate column on your submission page.

At the moment that is not possible as the total is linked to the payment/product field.

You will need to export the submission as an excel and then split the payment/product field across different cells manually using Excel functions.

Otherwise, you can add a hidden field on the form and conditionally pass on the total to that field on the form. This will then show as a new column on the submission page.