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

  • Profile Image
    jetform.admin
    Asked on January 05, 2022 at 01:15 PM

    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

    Screenshot
  • Profile Image
    Jovanne
    Answered on January 05, 2022 at 05:22 PM

    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:

    1641421293_61d619ed0cb4a_

    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.

  • Profile Image
    jetform.admin
    Answered on January 05, 2022 at 08:00 PM

    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

  • Profile Image
    Girish
    Answered on January 06, 2022 at 02:24 AM

    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.