Add Score to Request Form
Good Morning I need to add score to the answers provided in a request form and then use the score in a report to evaluate the results Example: Q1: how are you? A1: fine (2 points) Q2: are you happy? A1: yes (2 Points) In the report I want to see for example 4 points if someone answer A1 on both the questions. Thank you. |
It may be possible to map your questions request form questions to task custom fields and retain the points in the answer.
For example, the answer would be written exactly has you have them in the example you provided.
Then when you need to score the results, view the tasks in table view and make the custom fields visible.
Export the view as an excel spreadsheet.
Open the spreadsheet and use formulas or a macro to parse the answers in order to retrieve the values.
Once you have extracted your numbers, you can create your report in Excel.