PowerSchool: eCollect Forms report

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.

1. From the home page of PowerSchool, while accessing the District Office, select “Form Reports” under Report (left navigation pane)

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

3. 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)

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

5. 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

6. Click on the Generate Report button

7. 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

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