I have created a health & safety site inspection which has been set up using the "pages-dynamic grid" functionality. There are a total of 50 questions which have been broken down across several sections on several pages. Each question is set up like below:
| begin group | q1gr | Question 1 |
| select_one risk | q1 | Is there an up to date version of CPP available on site? (1 point) |
| select_one q1.1 | q1_1 | Select the Non-Conformance |
| select_one q1.2 | q1_2 | Corrective Action required |
| text | q1_3 | Additional Comment(s) |
| end group | | |
| begin group | q2gr | Question 2 |
| select_one risk | q2 | Is Principal Contractor, Employer and Public Liability Insurance displayed? (1 Point) |
| select_one q2.1 | q2_1 | Select the Non-Conformance |
| select_one q2.2 | q2_2 | Corrective Action required |
| text | q2_3 | Additional Comment(s) |
| end group | | |
The 'select_one risk' question is broken down into Yes, No or N/A, with the next 2 'select_one' questions containing the relevant non-conformance and corrective action choices. These will only display if the first question is answered "No".
What I need to be able to do is create a summary in the last section of my survey listing all of the questions (of a possible 50) where the 'select_one risk' was answered "No". If possible it needs to be laid out like below.
| | Question | Non-conformance | Corrective Action required |
| 1 | | | |
| 2 | | | |
| 3 | | | |
| 4 | | | |
| 5 | | | |
I am having difficulty getting a working calculation given that there are so many questions and there being multiple choices for each non-conformance and corrective action question. I have tried looking for something on here that might help me but haven't been able to get anything working myself.
Any help would be hugely appreciated. Thanks.
