Copy link to clipboard
Copied
Hello, I'm creating an audit form. In each category the dropdown selections are "Yes", "No" or "N/A". Section one has 6 questions. Section two has 8 questions. Section 3 has 9 questions and lastly section 4 has 4 questions. I want to assign a value to calculate the yes answers for each section providing a percentage as a score (75% or 100% etc.). Each section is scored individually and I also want to average all of the scores from each section for a final overall rating which is also a percentage. I have no experience doing scripts so please provide the most simple instructions.
Copy link to clipboard
Copied
You can add values as 'export value' of choices in dropdown fields.
For help with script, tell us your field names or share your file.
Copy link to clipboard
Copied
It would help to write a script for this if the field names follow a regular pattern. Or even better if they used group nameing. For example:
"Questions.GroupSetup.Q1", "Questions.GroupSetup.Q2", etc. with the % fields named "Percent.GroupSetup".
This naming pattern makes clear associations between the parts of the form that need to be operated on together, and with the fields that recieve the results, making it possible to write a single script to handle all operations.