Add columns $ amount

  • Profile Image
    jstefan
    Asked on June 01, 2021 at 06:50 PM
  • Profile Image
    Kevin_G
    Answered on June 01, 2021 at 11:09 PM

    Unfortunately, I cannot understand your requirement, please provide us more details about what you would like to achieve, we will be happy to help.


  • Profile Image
    jstefan
    Answered on June 02, 2021 at 08:10 AM

    I would like the values in this column:

    1622635815_60b7752734060_

    To calculate the total in this field:

    1622635842_60b7754287967_

  • Profile Image
    Sam_G
    Answered on June 02, 2021 at 08:52 AM

    Hello Jstefan,

    Unfortunately, it is not possible to do that in the Input table field.

    Here's a workaround:

    1) Add one text field and set any default value in it (you should make that text field hidden):

    1622638200_60b77e783d9c4_

    2) then add conditions that will insert $(or whatever you need) into each Input table field, for example, I have this:

    1622638234_60b77e9aee1d6_

    3) And then I created these conditions:

    1622638252_60b77eac66e8b_

    Please note that this needs to be done to each input field under amount.

    Here's my cloned form: https://form.jotform.com/211523418900952

    I hope this helps.

    Let us know if you need further assistance.

  • Profile Image
    jstefan
    Answered on June 02, 2021 at 04:50 PM

    Hi,

    I tried doing this, but it is not adding up the values in each row to calculate a total in the field titled "Total Amount". It's add "$" to those amount fields, but I'd like it to calculate the total automatically. It seems that is possible.

    Thanks

  • Profile Image
    Kevin_G
    Answered on June 02, 2021 at 07:30 PM

    I see your form is not configured to calculate the total yet, you can do it following these steps:

    1. Disable the condition that inserts the dollar signs into the total amount field:

    1622676471_60b813f77f12f_

    2. Open the Form Calculation widget settings and delete everything you have there, then click on the add field button:

    1622676551_60b81447b7cf5_

    3. The last step is to add the fields from the input table, on this step you can add the dollar sign manually at the beginning:

    1622676608_60b8148035d38_1.gif

    I hope this helps.

  • Profile Image
    jstefan
    Answered on June 02, 2021 at 07:57 PM

    Where exactly am I adding the dollar sign manually?

  • Profile Image
    jstefan
    Answered on June 02, 2021 at 08:15 PM

    More specifically....can I add a $ sign in each "amount" cell in that column?

    Thanks

  • Profile Image
    Kevin_G
    Answered on June 02, 2021 at 11:32 PM

    You can add the dollar sign to the calculation widget, here is where:

    1622690998_60b84cb6db0be_

    To add the dollar sign in the amount cell of the table, you can refer to the steps provided by my colleague on his response, note that these steps apply to the cells in the table only: https://www.jotform.com/answers/3134333#3135455

    To add the dollar sign to the Total Amount field refer to my response above.

    Also, while on the conditions section delete all those conditions with the "missing field" error or they can cause conflicts with other conditions.

    Kindly follow the steps carefully to get it working on your form too.