Add to formula with question logic

Add a value to formula with question logic, to show outcomes based on formula results when a certain condition is met. This can be done on a specific answer to a question, on a custom score on a question block, or even an intro field.


    Professional         
   Enterprise         
   ReportR         
   DistributR     

You've set up a great questionnaire and you're wondering how to show outcomes based on formula results. This guide will take you through it step-by-step! 


This video explains how to use formulas to show the right outcome based on scores:



We'll start by creating formulas that will be used in question logic. The question logic will dictate how many points to add to the formula and we'll use those calculations to put together the outcome screen conditions.


This guide will teach you:

  1. Create Formulas 
  2. Set up Question logic with Formulas
  3. Test your Formulas
  4. Set up Outcomes

1. Create Formulas

Start by creating a formula for each outcome that you want to display. In the Extra Options tab, you'll find the Formulas feature under the heading of Custom scoring


Now click Create formula and create a formula for each outcome. In the text field of each formula, enter a 0 (zero). Click save to save all of your formulas.

Add to formula with question logic- create formulas

2. Set up Question logic with Formulas

Now head over to the Question logic feature (also in the Extra options tab).

Add to formula with question logic- create question logic

Create rules to specify how many points to add to each formula option when a particular answer is selected. You'll need to set up a question logic rule for each of the answers to all of the questions.


Let's take look at an example to make things more clear. We can set up a question logic rule as follows: IF answer on question 2 is equal to answer 1 THEN add to formula1, 2 points. The 2 points scored will be added to "formula 1" at the back-end, and as the respondent continues through the questionnaire, scores will be added to the different formulas according to the question logic that has been set up for each answer.

Add to formula with question logic- question logic configuration

3. Test your formulas

It's worth running a few tests to check that your formulas are correct. A quick way to do this is to add all of the formula variables (e.g. *|f2_result|*) to the final screen so all formula results will show up each time you complete the survey. Just click Preview and you can try out your survey a few times in Preview mode. No results will be saved.

Add to formula with question logic- test your setup

This is how your formula results could be shown all together on the final screen:

Add to formula with question logic- final screen

4. Set up Outcomes

Now that you are sure your formulas are working, you can set up the conditions for each outcome screen. Choose to show this outcome when a certain condition is met. Set the condition based on a formula


For example, to show the Outcome screen for someone who received a score that would rank them "Super sharp!", set the conditions that the formula result for Super sharp has to be greater than *|f1_result|* and *|f2_result|* and *|f3_result|*.

Add to formula with question logic- create outcomes

Set the conditions for each of the outcome screens, click save and you're ready to roll!

What's next?

  • Use question types that support custom scoring to give a score to each answer, so that an overall score will be calculated at the end of the survey. Not all question types support this feature by default, however you can use formulas to add custom score to your forms, open ended and ranking inquiries.
  • The feature to calculate formulas including all survey responses allows you to make calculations taking into account all responses collected and not just a single respondent's information. Enable this feature so that you can calculate averages, count responses, and more.
  • Question Block Custom Score Table shows your respondents how they scored in an assessment based on the Question Blocks you have created. This is a way to show your respondents in which areas they excel and which areas need improvement. 
S
Support is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.