Submission answers are repeating in pre-calculated fields

  • Profile Image
    Chemtech
    Asked 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

  • Profile Image
    Charlie
    Answered 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
    Chemtech
    Answered on September 25, 2016 at 02:19 PM

    Thanks! :)