{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/75d962e42f6c49b79aae32bcfcac8c14\" frameborder=\"0\" width=\"1956\" height=\"1467\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1467,"width":1956,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1467,"thumbnail_width":1956,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/75d962e42f6c49b79aae32bcfcac8c14-83149f77f897380b.gif","duration":311.476,"title":"How to Query Form Submissions Answers","description":"This Loom explains how to create a reporting query to find specific answers from a form or packet submission. The presenter goes to Reporting and Queries, starts a new query for students, and adds a rule based on a specific form instance, selecting the neurology form question and its yes answer, and optionally filtering to a specific packet year such as the 2026 packet. After saving to run the report, they show how to add the filtered yes values as columns under Form Requests, Submissions, Form Instance, Form Values, expanding Neurology. They also cover downloading the results as PDF, Excel, or CSV and flattening columns if values contain multiple entries."}