The autoresponder in my new form does not add up the calculation fields

  • Profile Image
    Soargui
    Asked on June 13, 2019 at 05:12 PM

    In my form (https://www.jotform.com/build/91616810473659) I use AUTORESPONDER to be able to add (accumulate) the values of submissions of several days.
    Why is it not being added (accumulated)?
    In another form (https://www.jotform.com/build/70315577639666) I also use AUTORESPONDER and the values of this form are summed (accumulated).
    Why does it work in one (https://www.jotform.com/build/70315577639666) and does not work in another (https://www.jotform.com/build/91616810473659)?

    Obs
    All this is missing so that I can present the client for approval.
    thankful
    Geraldo

  • Profile Image
    Welvin
    Answered on June 13, 2019 at 06:45 PM

    Hello Geraldo,

    I'm afraid I do not understand the problem in the form. I checked your 'autoresponder' email settings, it is not formatted correctly for the given form (https://form.jotformz.com/91616810473659). You have your email table as shown below:

    15604658462019-06-14-019.png

    The calculation is working correctly in the form view, so I guess your problem is related to the formatting and placement of the fields. You may consider creating a new autoresponder email, and start formatting it.

    To create an autoresponder email: https://www.jotform.com/help/26-Creating-a-Form-Autoresponder

  • Profile Image
    Soargui
    Answered on June 13, 2019 at 11:43 PM
    Hello Welvin, thank you for the answer but that's not my problem.
    I'll show you another way.
    I will only use one item as an example, with two submissions and with
    different values.
    At the end of the two submissions, I need a report (Notification email)
    accumulating the reported values.
    I was directed to use AUTORESPONDER for this.
    - FIRST FILL AND FIRST DATA SUBMISSION:
    Day one
    Car
    $ 10.00
    - SECOND FILL AND SECOND DATA SUBMISSION:
    Day two
    Car
    $ 20.00
    Using the AUTORESPONDER to add (accumulate) the values informed we should
    find in the NOTIFICATION EMAIL of the day TWO for the item Car the
    accumulated value of U $ 30,00
    IT IS THIS SUM (ACCUMULATION) THAT IS NOT BEING MADE, only the value of U $
    20.00 that is information of the SECOND FILL AND SECOND SHIPMENT is being
    shown.
    Thank you
    Geraldo
    Em qui, 13 de jun de 2019 às 19:45, Jotform escreveu:
    ...
  • Profile Image
    Nik_C
    Answered on June 14, 2019 at 02:16 AM

    I'm really not sure how you have it working in this form https://www.jotform.com/build/70315577639666, what you described cannot work standalone. 

    When the user fills the form, the data filled will be the data sent via autoresponder/notification. There is no way for form to accumulate data from some previous submission.

    The only way to have that working is that you pass some new information to the second filling of the form, and that information would be inserted via prepopulate link for example https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    So, a user uses such link, opens the form and data (that he inserted before) will be inserted in the form, then when he chooses additional item it could be summed with previous.

    Unless I misunderstood your question.

    Please advise.

    Thank you!

  • Profile Image
    Soargui
    Answered on June 14, 2019 at 09:43 AM
    When the user fills the form, the data filled will be the data sent via
    autoresponder/notification. There is no way for form to accumulate data
    from some previous submission.
    But in the form https://www.jotform.com/build/70315577639666 the values are
    SOMED, I will prepare more information and send next.
    Thank you
    Geraldo
    Em sex, 14 de jun de 2019 às 03:16, Jotform escreveu:
    ...
  • Profile Image
    Soargui
    Answered on June 14, 2019 at 10:43 AM
    I will send the following print of forms, using two different forms in its
    structure.
    Form (https://www.jotform.com/build/70315577639666) makes the SUM of the
    values of two or more submissions.
    The form (https://www.jotform.com/build/91616810473659) DOES NOT.
    The difference between the two is that in the form (
    https://www.jotform.com/build/70315577639666) USER (User ONE or User TWO)
    inserts twice the same values, the first time on page TWO and re-enters the
    values on page FIVE (for example if the day chosen to enter the data is day
    1)
    Already on the form (https://www.jotform.com/build/91616810473659) USER
    (User ONE or User TWO) enters data ONLY ON PAGE TWO and values are
    automatically transferred to page FIVE (if the day chosen for Day 1) or
    page SIX (if the day chosen is Day 2) THROUGH THE CONDITIONAL LOGIC: UPDATE
    / CALCULATE FIELD.
    I will complete and forward following TWO FINAL REPORTS, please check that
    in the form (https://www.jotform.com/build/70315577639666) the values are
    summed and in form (https://www.jotform.com / build / 91616810473659) IT IS
    NOT SOMETHING.
    I will use the same data in both forms (name, day and values)
    I will send separate print.
    Obigado
    Geraldo
    Em sex, 14 de jun de 2019 às 10:38, Geraldo Mário
    escreveu:
    ...
  • Profile Image
    Jed_C
    Answered on June 14, 2019 at 11:09 AM

    I'm sorry, but I'm having difficulty understanding the flow. To make it easy for us to test the form, please provide us steps and which field and value to put in.

    Let me give you an example format:

    In form 70315577639666:

    1). Put 10 in 0 - ESTOQUE DE FARINHA DE ONTEM and 0 - COMPRA DE FARINHA DE HOJE 

    2). Check 0 - TOTAL DE FATURAMENTO DO TURNO and compare with other form


    In form 91616810473659: 

    1). Put 10 in 0 - ESTOQUE DE FARINHA DE ONTEM and 0 - COMPRA DE FARINHA DE HOJE 

    2). Check 0 - TOTAL DE FATURAMENTO DO TURNO and compare with other form

    There's a lot of field and is not translated in english that is why I'm having difficulty finding with total field to check on.

    Looking forward for your response. 

  • Profile Image
    Soargui
    Answered on June 14, 2019 at 12:43 PM
    a moment please
    Geraldo
    Em sex, 14 de jun de 2019 às 12:09, Jotform escreveu:
    ...
  • Profile Image
    Soargui
    Answered on June 14, 2019 at 01:43 PM
    Soargui Aplicativos
    Em sex, 14 de jun de 2019 12:51, Geraldo Mário
    escreveu:
    ...
  • Profile Image
    Soargui
    Answered on June 14, 2019 at 02:43 PM
    This attached document is a part of the FINAL REPORT of information that I
    should show in the fields I am going to mention, the sum (cumulative) of
    two submissions made, Day 1 and Day 2.
    The fields:
    - (TOTAL MONEY 60.00) and (TOTAL CREDIT CARD 40.00) should be accumulated
    with the values of Day 1 - (TOTAL MONEY 40.00) and (TOTAL CREDIT CARD
    50.00),
    Also the fields: (TOTAL MEAT 43.00) and
    (TOTAL STAFF 32.00) should be accumulated with the values of Day 1 (TOTAL
    OF MEAT 15) and (TOTAL OF STAFF 25)
    Would be like this:
    - TOTAL MONEY 100.00
    - TOTAL CREDIT CARD 90.00
    - TOTAL MEAT 58.00
    - TOTAL STAFF 57.00
    This is what I am trying to do, in the final report add "accumulate" values
    from Day 1 to Day 2
    Thank you
    Em sex, 14 de jun de 2019 às 12:09, Jotform escreveu:
    ...
  • Profile Image
    Nik_C
    Answered on June 14, 2019 at 04:24 PM

    I'm sorry, I tried to follow, but I'm not able to determine what exactly is wrong in the form, is it possible you could share us screenshots of what you're expecting in the form: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    So we have a better understanding.

    We'll wait for your response.

    Thank you!

  • Profile Image
    Geraldo Simões
    Answered on June 14, 2019 at 04:53 PM

    1560545281Jot Form Relatório Final.png

    This image above is part of the FINAL REPORT of information that I need to show, which is the (cumulative) sum of two submissions made, day 1 and day 2.

    The fields are (example only):

    - (TOTAL MONEY 60.00) AND (TOTAL CREDIT CARD 40.00) shall be accumulated

    with the values of the 1st day - (TOTAL OF 40.00) and (TOTAL OF THE CREDIT CARD

    50.00),

    also the fields: (TOTAL MEAT 43.00) and

    (TOTAL STAFF 32.00) shall be accumulated with the values of Day 1 (TOTAL

    DA MEAT 15) and (TOTAL STAFF 25)

    It would be like this:

    - TOTAL MONEY 100.00

    - TOTAL CREDIT CARD 90.00

    - TOTAL CHART 58.00

    - TOTAL STAFF 57.00

    That's what I'm trying to do, in the final report add "accumulate" values

    from Day 1 to Day 2

    Thank you

  • Profile Image
    Soargui
    Answered on June 14, 2019 at 05:43 PM
    What I need is for the values reported in submissions to be summed and
    accumulated.
    Recently someone directed me to use AUTORESPONDER to get this sum of values.
    Ex:
    Day 1: food = $ 20.00
    Day 2: food = $ 30.00
    Using AUTORESPONDER to inform the data of Day 2, according to the
    orientation they have given me is that in the email notification the sum of
    expenses with food = $ 50.00 would appear.
    That's all I need.
    No form https://www.jotform.com/build/70315577639666 I already did it, but
    now it is not adding up anymore, and I do not know why?
    thankful
    Em sex, 14 de jun de 2019 às 17:24, Jotform escreveu:
    ...
  • Profile Image
    Welvin
    Answered on June 14, 2019 at 07:46 PM

    I'm sorry, but I don't think this is possible with Jotform. There is currently no way you can sum up entries from different submissions into one autoresponder email.

    I understand that in your "Escolha uma data" field, you have Day 1 and Day 2 as the options.

    15605557182019-06-15-002.png

    You have each day conditioned to show the corresponding fields, in this case, multiple pages like Day 1 and Day 2.

    Day 1:

    15605557792019-06-15-003.png

    Day 2:

    15605558072019-06-15-004.png

    Now, since you have conditioned these fields, one person needs to submit the form twice. This is correct, right? That person will then have two entries, one for Day 1, and another for Day 2. Now, do you want to sum up Day 1 and Day 2 entries into one autoresponder - and you want to send it upon submitting Day 2, correct?

    Unfortunately, the above is not possible. One thing I can think of that is possible would be to let the person submit Day 1 and Day 2 at once. So, in this case, you will have to restructure your form and allow people to select Day 1 and Day 2, so they can fill it at once. If you do not want them to overwhelm with the number of fields in the form, maybe, offer them to save and continue later. We have this feature.

    https://www.jotform.com/help/97-How-to-Save-Forms-to-Continue-Later

    I hope that helps. Let me know if you need further help on this.


  • Profile Image
    Geraldo Simões
    Answered on June 15, 2019 at 12:09 AM

    Attached is three print

    1- MAIO-Dia UM-Manhã João

    2- MAIO-Dia UM-Tarde Carlos

    3- ACUMULADOS

    Please check the highlight in red.

    In the first print, the value 627.00 was entered in the field MONEY

    In the second print, the value of 1,599.50 was entered in the MONEY field

    In the third print in the field ACUMULADOS is added (627.00 + 1,599.50 = 2,226.56) that is referring to the TOTAL DE DINHEIRO

    And this sum was made by the form through the second submission using AUTORESPONDER.

    This shows that the form can add (accumulate) values from several submissions.

    I just do not know why it's not adding up, I must have done some altruism without realizing it.

    So I would like you to help me check where the problem is.

    thankful

    Geraldo1560571479Soma de Valores.png1560571501MAIO-dia UM-Tarde Carlos.png1560571517MAIO-dia UM-Manhã João.png


  • Profile Image
    Nik_C
    Answered on June 15, 2019 at 03:06 AM

    Thank you for the additional information.

    I believe screenshots you sent is from your Notifier:

    1560581933Screen Shot 2019-06-15 at 8.58

    I checked that field (ttDinheiro) and it is calculated from these fields:

    1560582012Screen Shot 2019-06-15 at 8.53

    I tested the form and TT DINHEIRO is calculated in the form properly.

    Now, you're mentioning multiple submissions that are accumulating, that is not possible out of the box in our builder and I'm not sure if you set that (calculated) somehow out of the JotForm.

    One way was presented by my colleague Welvin in the previous reply, another way that I can think of is to integrate your form with Spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets and do the calculation from submissions there.