Update multiple choice
Hi there. Some help with a trigger needed here, plesae!
In a multiple choice field I have 40+ choices. Is there a way to set a sort of "select all" button without having to click 40+ times?
Thanks for your help.
G
11 replies
-
Do you not see an "all" choice?
-
Mconneen,
I think G means to make a button whicht activate all the items in the multiple choice field:
Button with a formula like 'Multiple choice' := [1,2,3,4,5,......39,40] which select all the 40 items.
The above does the trick but is a bit a cumbersome way of doing things. So, I've tried like in the pic below but i get an error like this.(Don't mind the checkbox and other stuff, this is a testing DB)
Any suggestions?
-
It looks like the iPhone app does not have the "all" option like the other versions do. @Steven, this is what I came up with...
let mcArray := [1];
for i in range(2, 4) do
mcArray := unique(mcArray, i)
end;
'Multiple choice' := mcArray
This will select all of the choices in a MC field with 3 choices. Remember that the second number in the range is not inclusive.
-
@Steven...
You are SOOOOOO close. Just drop the concat.. :)
Button Mark Them All..
I only looked briefly.. would be nice to dynamically figure out how many values are in the multiple choice field..
-
@Mconneen, Cool! I didn't know that range() could be used outside of the for-loop context.
-
When you consider the state of the current documentation, finding new functionality is like finding Easter eggs.
-
@Sean... totally agree about the documentation... range appears to return an array of numbers.. I was going to point you to a niffty posting about array handling.. and when I looked up my notes.. YOU POSTED IT.. :) LOL..
-
Thanks guys for taking the time to help me with that. It seems that this will help other as well. Great!
The solution posted by Mconneen works just fine.
This is the whole story: a correct answer in both the red-rounded items should imply the whole score in the previous 16 items. The range() function does the job perfectly, as the total score for those items (via a formula which is not visible in the screenhot) is 18.
I owe you all a beer. Or a free phonologic awareness assessment. You choose.
;)
-
Great...
-
Awesome.. +1 on the beer! LOL..
-
Content aside
- 5 yrs agoLast active
- 11Replies
- 3134Views