What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Submission answers are repeating in pre-calculated fields

    Asked by Chemtech on September 22, 2016 at 08:00 AM

    Could you please assist. I am working on a form which has conditional formatting based on the selection of previous cell.

    The submission results in my fields named: 

    'Details' and 'Chemicals Used' have the the calculated results displayed numerous times instead of just once in the field. Could you please advise what I need to do to ensure the information only displays once in each field.

    eg user selects 'Method Statement' 1 - and 'C&D of CWST & DWS' is displayed as a result in 'Details' and also 'Chlorine + Sodium Thiosulphate' is displayed in 'Chemicals Used'

    PLease see https://form.jotformeu.com/61993946325367

    Regards,
    Tracy Thomson

    Page URL:
    https://form.jotformeu.com/61993946325367

    Screenshot
    submission answers style size font Selection
  • Profile Image
    JotForm Support

    Answered by Charlie on September 22, 2016 at 10:34 AM

    Upon checking your form and the conditions, the reason for the duplicate is because you have setup somewhat a limited loop.

    Here's what your condition states:

     

    Your condition says that if "Method Statement" is equal to "1" then insert "'Details' C&D of CWST & DWS" to "Details". You are inserting a the input of the field itself to itself. Which may cause a finite loop.

     

    Same with the "Chemicals Used":

     

    If you just want to insert a static text, then no need to insert "Details" and "Chemicals Used" inside the "DO" statement. So it should be something like this if your goal is to insert static text on a field:

     

    You need to update all of your conditions if this is the case. To learn more about conditional logic. Please refer to this link instead: https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

    Let us know if I misunderstood your concern.

  • Profile Image

    Answered by Chemtech on September 25, 2016 at 02:19 PM

    Thanks! :)