PowerSchool EUI Admin: eCollect Forms report

PowerSchool EUI Admin: How do you display/export data collected via the eCollect Form?

eCollect Reports

We do have a Form Report in PowerSchool to pull the eCollect data. Please follow the instructions below to get the report.

• Click on Data and Reporting, then click on Reports, and select Form Reports.

• Select “Form name” (Stipulated Agreement example) from the list of reports and click on the title of the report

• Under Data Source – select Show by Person if you would like to get the latest record for each student OR Show by Response to view all records (if the student filled out the form more than once, you will see both records)

• Click on Add columns and select all fields in the Form Elements>click on Apply button

• Go back to Add Columns and select PowerSchool Fields - you can add additional columns from Students table (like grade_level, schoolid (current school), DOB, etc) to your report if you like.  Click on Apply button

• Click on the Generate Report button

• Once the report is displayed, click the last button on the right side of your screen above the heading of your report (the arrow pointing up-right) and select Export

• Select Table and check csv as the format>click Export (open the saved file in Excel)