Submission answers are repeating in pre-calculated fields

  • Chemtech
    Asked on September 22, 2016 at 8: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

    Jotform Thread 939095 Screenshot
  • Charlie
    Replied 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:

    Submission answers are repeating in pre calculated fields Image 1 Screenshot 40

     

    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":

    Submission answers are repeating in pre calculated fields Image 2 Screenshot 51

     

    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:

    Submission answers are repeating in pre calculated fields Image 3 Screenshot 62

     

    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.

  • Chemtech
    Replied on September 25, 2016 at 2:19 PM

    Thanks! :)