I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue.
What I want to do in my report is create one row for each issue that arises during the safety inspection. For instance there could be three issues that arise in the inspection and corrective action needs to be taken for each issue. A separate line would be ideal to address each issue.