JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Submission answers are repeating in pre-calculated fieldsAsked 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
submission answers style size font Selection
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.