In this video, I demonstrate how to create a scoring system on a form using conditional logic in the NRDS web app, specifically for a food safety system. I walk you through setting up a repeating section for questions, where each question can be answered with Yes, No, or N/A, and how to assign scores accordingly. I also explain how to count the number of Yes and No answers and calculate the overall score based on these responses. I encourage you to follow along in the Template Builder and try implementing this scoring system yourself. By the end, you'll see how to effectively track and score responses based on your criteria.
1. Introduction to the Scoring System 0:00
Overview of the video purpose: Demonstrating how to create a scoring system on a form using conditional logic.
Example scoring system: Food safety system with a series of questions.
2. Understanding the Scoring Mechanism 0:12
Scoring based on answers:
Yes = 1 point
No = 0 points
N/A = not scored
Calculation: Number of Yes answers divided by the total number of answered questions.
3. Accessing the Template Builder 1:12
Navigate to the Template Builder to start creating the scoring system.
4. Setting Up the Repeating Section 1:36
Create a repeating section for questions (e.g., 'Plants and Grounds').
Define the questions within this section.
5. Importing Questions 2:00
Upload or import questions from a spreadsheet.
Example questions: Question 1, Question 2, etc.
6. Defining Answer Options 2:24
Create a custom option list for answers:
Yes
No
N/A
Assign scores to each answer.
7. Implementing Conditional Logic 2:37
Set conditional logic for required notes based on answers (e.g., if 'No' is selected, make notes required).
8. Pre-filling the Repeating Section 3:01
Set the repeating section to pre-fill with the defined questions.
Adjust settings to show or hide the pre-filled section.
9. Choosing View Options 4:15
Set the default view for the repeating section (form view vs. table view).
10. Creating Score Calculation Sections 5:03
Add a new section for scoring (not a repeating section).
Create questions to count Yes and No answers using conditional logic.
11. Summing Scores 6:07
Implement logic to sum scores based on Yes and No answers.
12. Final Score Calculation 6:25
Create a final score question that divides the total score by the number of answered questions.
13. Conclusion and Feedback Request 7:21
Recap of the scoring system creation process.
Invite viewers to ask questions or share use cases.
Link to Loom