Custom Fields (Australia)

Any spreadsheet can be used.  Whether it is manually created or downloaded from your SIS, Operoo is ready to share it with your families.

This first release is for parent forms only, but we expect to expand it to include staff forms as well.

Our team has thought of these uses for Custom Fields:

• Census Data (Language spoken at home, Level of Education, etc) verification
• Academic Results - with confirmation signatures
• Exam Invitations
• Student Timetables
• Subject Elective confirmation
• Student Attendance (term) summary  

We’d love your feedback on what your school will use it to send!

THE CUSTOM FIELDS SCREEN

Choose the new Custom Fields from the sidebar menu.

The Custom Fields screen displays a list of all files uploaded into Operoo for use with Custom Fields.  These files are called Collections in Operoo.  Please note that these will be uploaded separately from the SIS data imported into Operoo.

Click the to edit the file.  Field Names can be edited and fields can be reordered (See the Tips area for details).  Collection names default to match your uploaded file, but you can also change the name here if your original file did not match your naming convention (See the tips area for naming conventions)

Click the to map lookup tables and reprocess the data (See the Lookup Table area for details)

Clicking the name of the file will display the data contained in the collection.  This list can be sorted and filtered as needed.

Click the to delete the file, but please be aware this will also delete the data attached to any eForm in which the collection was used.  There will be a warning before you delete the file.

TYPES OF FILES

STUDENT DATA – REQUIRED

The Student Data file contains all the information that will appear in your Operoo form.  

• The file can be either excel (.xlsx) or csv (.csv)
• The file MUST contain the student ID number and that column MUST have a header captioned  student_id.  This column does NOT have to be the first column in the data set. 
  The student ID in the file must match the student ID in Operoo and is case sensitive - ABCD1234 will not match to abcd1234.
• Multiple rows of data for the same student is fine, each row MUST contain the student ID.
• It’s ok if the data is in a different order than you want in the form
• It’s ok to have extra columns that you do not want to appear in the form
• If you use files from your SIS, it’s ok to add or remove columns
• If there is data in the column, there must be a column header

LOOKUP TABLE – OPTIONAL

A lookup table only needs to be used when there is data that needs to be replaced in the Student Data file for families to have a clearer understanding of what is in the form.  Examples include:

• Replacing Course Codes with Course Names
• Replacing Comment Codes with Comment Text
• Replacing Absence Codes with an Absence Description

HOW A LOOKUP TABLE WORKS

A lookup table will replace one value in a file with another everywhere it appears in a column (similar to Find and Replace).  For example, if your student data file includes course code, you can use a lookup table to replace the code with the course name.  The key to a lookup table is that both the original (Find) and new (Replace) data appear on the same row.

• The column headers MUST be in the first row of the lookup table
• The lookup table should NOT have any empty rows

HOW TO UPLOAD THE FILES

DATA FILE ONLY 

To upload the file, choose Custom Fields from the sidebar menu.

Choose the student data file you have saved on your computer, leave STUDENT DATA, the Import data into collection checkbox checked and click Create Collection from File.  The data may take some time to process, for large files, feel free to leave this screen and return to it later to create the form.  The rows entry on the collection will increase as the data uploads.

Once uploaded, Operoo stores the data in a “Collection” that has the name of the file.

DATA FILE and LOOKUP TABLE

To upload the files, choose Custom Fields from the sidebar menu.

STEP 1: Upload the Lookup Table

Choose the student data file from your computer, choose LOOKUP TABLE from the dropdown menu and click Create Collection from File.  

STEP 2: Upload the headers from the STUDENT DATA file

Choose the student data file from your computer, choose STUDENT DATA from the dropdown menu, UNCHECK the Import data into collection checkbox, and click Create Collection from File.  

STEP 3: Map the LOOKUP TABLE to the STUDENT DATA

Click the to the left of the STUDENT DATA file that contains the course code

Find the COURSE field in the data field list

Use the dropdowns to map the following:

Lookup table = Choose the file where Operoo should find the lookup data (uploaded in Step 1)

Lookup Column = The name of the field with the original data we don’t want families to see

Replacement Column = The name of the field with the replacement data we do want families to see

The sample below shows replacing Course Code with Course Title:

Reprocess the data by choosing the file name and clicking Import Data.  This reprocessing will link the replacement values from the lookup tables into the student data Operoo will send to families.

The data processing may take some time, for large files, feel free to leave this screen and return to it later to create the form.

ADDING THE DATA TO A FORM

CREATE THE FORM

Create an eForm as usual in Operoo.

In the description area, add any message that will provide context to the collection.  

To add the collection data, choose an Additional Notes question for your form.  Add any text needed, choose the placeholder option and choose the collection from the list.  Multiple collections can be added to the same eForm and will be displayed in separate tables.

Additional questions or signature options can be added to the form.  Remember, you can reorder the Additional Notes question to the top of your eForm to bring immediate attention to the information in the collection.

CHOOSING MEMBERS

A new option has been added to ensure that forms based on collections are only sent to the families of students who have data in the collection.

Choose Dynamic Members and click Choose FIlter.

At the members screen, choose the group.  In the Additional Attributes column, Open the Custom Field Collections and click the arrow to the left of the specific collection you will be using in your form.  Check the box below the name of the selected collection.

 If you are using multiple collections in your form, you will have to check all of them and decide if students MUST have data in both collections to be included or if the eForm should be sent if they have data in only one of the collections.  If they must have data in both, click Members must have ALL these attributes.

PRO TIPS

RENAMING AND REORDERING THE DATA

If the columns in the STUDENT DATA file are not in the best order for families, Operoo allows you to reorder the columns once uploaded.

RENAMING

Click on the pencil to edit the file

Click Edit to rename the column.  Type the new name and click save.

REORDERING

Click and hold the 6 dots to the left of the Name above the column to be moved.

Drag and drop the columns to the preferred order.

DISPLAYING ONLY CERTAIN FIELDS TO FAMILIES

The default in Operoo is to display all data in the Student Data file. If you do not want all of the data to be displayed, you can delete the columns before you upload the file or insert instructions after the collection name once placed into the form.  The exact format must be followed:(no space between the collection name and the command.)

 

1. Open with a hard bracket [
2. Type quotation marks “
3. Type a column header (must be the exact column header from your student data file)
4. Type quotation marks “
5. Type a comma ,
6. Repeat steps 2-5 for all columns that should appear in the form
7. Close with a hard bracket ]

Example: Only show columns 1, 3 and 7 from the Student Data file.  Add the following after the collection in the form:

[“column 1 header”,”column 3 header”,”column 7 header”]

The screenshot below shows an example with the actual column headers

NAMING CONVENTIONS

With the flexibility that comes with the Operoo Custom Fields feature, we expect that many files will be uploaded by our schools.  Some of these files will be very similar, such as grades for each marking period or attendance for different days.  We strongly recommend that your school decides a naming convention for all files uploaded to Operoo.  For example, 2022_1_3 Course Grades or 2_1_2022 Attendance.  

WHAT WILL FAMILY CONTACTS SEE?

Following is the email received by the family contact:

When they click to respond, they will see the collection data specific to their student: