-
tjlphdAsked on August 19, 2019 at 4:30 PM
I Have a multiple select field: see image.
When all values are selected, I want a new field to contain a default value.
I set a default but it doesn't work because of the calculation.
The calculation is designed to indicate what is NOT selected in the multiple select field. This works well as designed. However, when ALL are selected , in the multiple select, then the calculated fields does not get any value and the default value does NOT come in.
this is the field that should get a value ONLY when all of the values in another field are selected.
Here is the question with multiple values. When any one is selected, then all the others appear in the one above - through calculation. But I cannot figure out the "null" - that is, when all of the below are selected, how do I get a single unique value in the field above?
-
tjlphdReplied on August 20, 2019 at 2:02 PM
Please advise
-
John Support Team LeadReplied on August 20, 2019 at 3:33 PM
Hi @tjlphd,
If I get it right, what you want to achieve is that when all these options below are selected, the "Please consider.." field should contain "None Required" value. Am I correct?
If so, we need to identify first if the user selected all of these options. Here's a solution I came up with.
I added a Long Text entry field to contain the selected values of the Biomarkers field:
I then added a condition that if this Long Text entry field contains all the options of the Biomarker's field, the "Please consider..." field should display a "None Required" text.
Please try that to your form and let us know how it goes.
-
tjlphdReplied on August 20, 2019 at 3:37 PM
Yes,
or alternatively, have that field not appear.
I tried to do a show/hide where I put every one of the items on the list in a "if equal to". and then "hide" "please consider" but it didn't work. That field still showed up - I think because it is perceived as being filled by other logic even though it is blank. Putting in a default doesn't work - it doesn't show up for the same reason. The calculation driving values into that field, even when blank, somehow indicates there is a value - if that makes sense.
-
John Support Team LeadReplied on August 20, 2019 at 3:45 PM
I have updated my answer. Please try the workaround I suggested and let us know if it satisfies the requirement.
-
tjlphdReplied on August 20, 2019 at 4:28 PM
Ugh.... It didn't work:
-
tjlphdReplied on August 20, 2019 at 4:34 PM
NOT A PERFECT SOLUTION BUT I PUT A PLACEHOLDER IN AND THIS IS ACCEPTABLE.
-
John Support Team LeadReplied on August 20, 2019 at 5:36 PM
I tried to get rid of this condition:
And replaced it with these conditions:
Here's a link to the cloned form. Please feel free to test it and see if it meets the requirement:
https://form.jotform.com/92315771420957
-
tjlphdReplied on August 21, 2019 at 8:10 AM
This works well. thank you.
Another question: When going through the "entry" fields sometimes the cursor is NOT in the box and requires a click and sometimes it is. Sometimes it's slow to appear.
Is there a setting for this.
For example, if you pick all the labs, the first box is "fasting insulin entry". You must click in this box before you can put in an entry. When you click next, sometimes it takes a moment for the cursor to appear in the box.
Is there a fix for this?
-
jherwinReplied on August 21, 2019 at 9:26 AM
Considering that your other concern is about another topic, I have moved it to a new thread to avoid confusion.
https://www.jotform.com/answers/1934743
Please refer to that thread for any related questions and/or follow-ups.