Hi @Underdog
You can assign a value to the answer in the drop-down field.
Instead of
Answer 1
Answer 2
Answer 3
Answer 4
Use this
Answer 1|0
Answer 2|3
Answer 3|4
Answer 4|5
Example
Select Answer 1 - Question1 value is 0
Hope that helps
Which forms designer are you using - Classic or New Responsive?
If you're using the Classic designer, try using the formula below in the Formula field of the Calculated Value control. Make sure the "Save as data type" is set to Integer.
If(equals(Impact of the effort, "Neither driven by or impacted to business initiative"), 0, 999)
If you're using the New Responsive Designer, then you should be able to do this easier with a form rule to set the value of the control.
Hi Bamaeric,
Thanks for the quick response. I believe it's the New Responsive Designer. I you'd have any screenshots to assist, it would be greatly appreciated as I'm brand new to this software package.
Hi Garrett,
Thanks for the quick response. The suggestion is a good one. The conundrum for me is I desire their answer, but they can't see the number value assigned to it. That number is added to six other numbers (from six other questions) to determine a priority score. That's why the question is text, and I convert it to a score.
I believe my Nintex is "Responsive." Another person suggest a Rule. Would you have any insight or thoughts on that route?
Thanks for your help and time!
I created two controls on a New Responsive form: one "Choice Single" control named "Impact of the effort" for the drop down with your choices and one "Number" control named "Value" to store a value.
Add a form rule and configure it per the screenshot below.
Hi @Underdog
I just want to illustrate the value to the answer hence why I showed the score.
If you don't want to show the scores, just hide the controls.(Visible = No)
But during development, its better to show the controls (Visible = Yes) for verification.
The 6 questions - Are the scores for the answer fixed set?
If yes, then use my suggestion.
<Text Answer>|<Score> e.g. Answer 1|0
If no, then use form Rules to assign score values
Assigning a value to the answer, saves you some time.
You avoid doing some codes or form rules as below
e.g. If ans == "Answer A", score = 5
If ans == "Answer B", score = 10
Question1 value is equals to the selection.
Are you going to save the Score into a SP column?
If yes, then Users will be able to see the score.
You will still need Form Rules to
- Calc the final score (can be done on the form, saving the form also saves the score) (can be done in the workflow too)
- show/hide additional questions depending on users; answer
Here is some additional resources to help you.
Have a look at this - On Input Rules
and this - Form Functions Sum
Hey @Underdog
Both myself and @bamaeric have provided you with some great suggestions.
I hope that you are able to implement the suggestions into a proper solution for yourself.
Then is also the possibility of getting yourself confused.
Here are some guideline for you
1. Decide what is your Goal / What do you want to achieve with the Form and Workflow
2. Choose Simple rather than complex
3. Select easy maintenance and code readability
Hope that helps
The above makes sense. How do I access that screen. I'd send a screenshot of what I see, but don't see a way to attach it.
I capture screens with the Snipping Tool and paste it. Try it
To get to the Rules designer in the New Responsive Designer, click on the Rules tab at the top of the form designer and click on the "Add form rule" button. This will open the rule designer for a new rule like I have in my screenshot.
I don't see that tab. Would that indict I have the Classic version?
@Underdog
You are using the Responsive Form
There is no wrong or right answer, but why are you using the Responsive Form?
Do you have a screenshot of your questions and the answers with scores?
Picture 3 is actually first, though listed second in the attachments.
The scores are:
Question #1 = 0
Question #2 = 1
Question #3 = 3
Question #4 = 9
Thank you very much for your help and time!
Just to clarify... what you actually meant is...
The scores for Question 1 are:
Question Answer #1 = 0
Question Answer #2 = 1
Question Answer #3 = 3
Question Answer #4 = 9
The value for the Dropdown List is <value>|<text>
"0|Answer #1,1|Answer #2,3|Answer #3,9|Answer #4"
For illustration purposes only - The Value is Underlined and the Text is in Italics
Note: There should NOT be any SPACES between the COMMA "," separator
Good morning Garrett,
Thank you for your response. I added your response as advised:
0|[Answer]
1|[Answer]
3|[Answer]
9|[Answer]
Now the number is included, though the submitter cannot see it. I'm going to do the same for the other six questions.
I would now like to tally the amounts for all seven questions combined, to find a total amount .. a total score (if you will) .. .. That total score I would translate to "None", "Low", "Medium" & "High". I would like to have the score sent to me by e-mail, or put it in its own column in the Nintex List (Nintex: List: Problems: Priority Score).
Thank you very much for your help. I wouldn't have had any idea how to proceed without your help.