I just need to know what to search on in the Designer Help or this forum because what I’ve tried so far isn’t getting me any help.I have a number of fields that are checkboxes. If more than one checkbox is picked, is there a way to separate the multiple values from each other or is the value the combination of all the selections. For instance: The choices are 1. Easy 2. Fast 3. Cheap 4. Red. Person A selects Easy and Red. Person B selects Easy and Cheap. I now have two for easy and 1 each for cheap and read. Everything I’ve tried shows the value as both selections. Like Easy, Red for person A and Easy, Cheap for person B.
I need to count how many of each selection in this case 2-Easy, 1-Cheap, 1-Red.
Where exactly are you trying to total these values? In a Notes view? I’m not exactly sure what you are trying to accomplish here. More detail would make it easier to suggest a solution.
Okay. We have a wellness plan that less than 50% of the company is participating in. HR wants to know why. I’m making a survey. Question #1 is What incentives would make you consider joinging the plan (Click all that apply). The options are: A. Lower health premiums, B. Wellness C. Money Rewards, D. Wellness Time Off Rewards, E. Other. I need to know how many people selected each choice. It seems the value of the field is all the checked choices, I need to break them out to count how many.Then I’d like to graph the results for all of the questions but I’ve read enough on that to reconsider …
If you want to have the values appear as separate values in the view, you can select the column property “Show multiple values as separate entries” but if you are going to write a report based on the selections, you are better off writing an agent that will process the responses, collate them and dump them into an excel spreadsheet. Unfortunately, if you don’t know how to do LotusScript, such an agent is going to be difficult…
I’ve almost completed LOTUSSCRIPT PRE-SCHOOL. I may have found something though. I didn’t realize when a checkbox field is categorized in a column view, each value is separated. I just found a sample script which will count documents in each category. I’m going to try that. It could get complicated though because there are 5 questions with multiple choices. Maybe I could have a view for each question.