Description:

Collection tables are Ecollect elements that interact with 1:many tables within PowerSchool.  These are useful for collecting data where each responder has an unpredictable number of responses or the data area has multiple data points.  For example, student allergies - each student may have none, one or many and each may require information about medication, severity, epipen use, etc.


Collection Tables and Enhanced Collection Tables allow forms to collect a dynamic number of rows per form response.  Both element types link to a 1:many table within PowerSchool that extends the table students, users or schoolstaff.


Enhanced Collection Tables:

Enhanced collection tables are the second generation version of the element.  Enhanced collection tables allow users to build the data rows using the traditional Ecollect elements.  Each "inner" element is linked to a field within the database extension linked to the collection table element.  Users can move data elements between 3 columns and an unlimited number of rows, similar to a side by side container.


Properties:

In addition to the basic element properties, collection table elements have the following settings:


One to Many Table Extension

The dropdown list contains all the one-to-many extensions of the Students table (for student forms) or Users table (for teacher forms) in your database. Select the one that contains your data.


Table Name

The table within the selected extension group to be used with the element.


Filter by Response

Select the field within the database table that will hold the Response ID. Use in conjunction with the form property Clear Form on Submission to not display previously submitted additions to the ETC. Only those rows added during a given response will be associated with that response.



Use Case Considerations:

Collection tables are the only elements that can interact with 1:many data sets within PowerSchool (asice from the contacts element).  The extensions must extend either students (for student forms) or users/schoolstaff )for teacher forms.  


The element is ideal for situations where the number of items within the category is different/unknown per responder.  


Resources:

Basic Elements Documentation

Enhanced Collection Tables Documentation