Setting up and managing User Defined Fields (UDFs)

What are User Defined Fields?

UDFs let you track that little bit of extra information on a student, staff or guardian profile, or for Educational Institutions. Here are some example User Defined Fields schools have created:

  • If a student has access to the internet or a laptop at home
  • Reading age
  • CAT score
  • Whether the child has Funded early education for two year olds (FEET)
  • Favourite colour and other fun personal preferences
  • Out of Authority flags
  • Much much more!

Permissions

You'll need either the General Admin: Administer or User Defined Fields: Setup permissions to set up UDFs and manage the permissions needed to view and input data into UDFs in bulk.

The permissions to view and input data into UDFs on user profiles will depend on what your school has chosen during the setup of the UDF.

If you don't have permission, contact your office staff - they can follow this guide to give you the right permission.

How long will it take?

  • Setting up a UDF - 5 minutes
  • Updating UDFs in bulk - 2 minutes
  • Importing the spreadsheet - 15 minutes

 

Managing User Defined Fields 

Setting up a user defined field

Go to System > User Defined Fields and click Add User Defined Field

Screenshot_2022-10-25_at_09.39.28.png

 

Choose which UDF type to set up. This cannot be changed once the field has been created.

  • Short text - type in any text into the box
  • Long text - type in any text into the box
  • Boolean - set answers to Yes or No
  • Drop-down - select between a set number of responses
  • Number - any number
  • Date - select the date
  • Date/time - select the date and time

The only difference between short and long text is the size of the text area when editing the record, we don't limit the number of characters you can record. If you want to encourage staff to enter less text, choose the short text option and vice versa.

Screenshot_2021-12-13_at_12.46.01.png

 

In the slide over, choose your settings:

  • Related to - Select the type of record the user defined field should be associated with. Select if you would like this field to show on Students, Staff or Guardian profiles, or Educational Institutions.  This cannot be changed once the field has been created.
  • 'Field name' - For example 'Ipad serial numbers'.
  • 'Identifier' - An optional field that lets you set an identifier for the field that is different to the label used for the field

Screenshot_2021-12-13_at_12.49.41.png

 

If you've selected the field type of 'Drop-down', you'll need to add options for the drop-down menu.

Screenshot_2022-10-25_at_09.41.10.png

 

In the permissions section, you can either:

  • Leave the drop-down menu blank to have the UDF only viewable in the System area by those with the General Admin: Administer or User Defined Fields: Setup permissions.  
  • Select an area of the system to see what permissions will also be able to access this information on user profiles.

Screenshot_2021-12-20_at_12.06.26.png

 

In this example, you can see that someone will need the Student Profile: Communications: Administer my students permission to fill in this field on a student's profile.

Screenshot_2021-12-20_at_12.09.14.png

 

You can edit these options once set up by going to the UDF and clicking Edit.

Screenshot_2021-12-20_at_12.10.55.png

 

You can also delete the UDF from here.

Screenshot_2021-12-20_at_12.11.24.png

 

Click into a drop-down item to delete it (if it is not in use) to prevent this option from being selected but to not remove it from existing records.

Screenshot_2021-12-13_at_13.01.14.png

 

Filling in a user defined field

Updating user defined fields in bulk

Go to System > User Defined Fields and click the user defined field you'd like to update.

Screenshot_2022-10-25_at_09.50.22.png

 

On the next page, you can select all the users to change the field for and click the Bulk actions button to change the value in the field for these users.

  • For Drop-down fields, you'll have an option for each drop-down item.
  • For Boolean fields, you'll have the options for Yes or No.

Screenshot_2022-10-25_at_09.51.12.png

 

For other types of fields e.g. text string, you'll have the option to update the values of the fields in bulk.

Screenshot_2022-10-25_at_10.12.48.png

Screen_Shot_2020-03-27_at_11.44.01.png

Importing and uploading User defined field values

Go to System > User Defined Fields and click the user defined field you'd like to import values for. On the next page, select Imports from the left-hand menu. You'll be taken to the import page.

Screen_Shot_2020-04-03_at_14.03.31.png

 

If your User defined field is for:

  • Guardians - Select individual guardians, select the guardians of certain student groups this year or select all guardians by leaving the field blank.
  • Staff - Select groups of staff with the same role or individual staff.
  • Students - Select any student group, such as year group. Top Tip: To select students from past or future years, use a Custom Group
  • Educational Institutions - Select the institutions.

We recommend only selecting student groups from within one year, as the import spreadsheet will not show which year a student belongs to. For example, if you select year 7 from both the 19/20 and 20/21 years, the spreadsheet will show the current registration form for the 19/20 group, and the registration form the students in the 20/21 group will be in next academic year.

Screen_Shot_2020-04-03_at_14.04.40.png

 

When you click Download Template, the file will download to your computer. You'll need to open it.

open_file.png

 

Is your spreadsheet blank or missing students? Follow these instructions: Applicant new starters not included in exports

In the spreadsheet, if your User defined field is String or Text, you'll be able to put any values into the UDF Value boxes.

text_value_UDF.png

 

If your User defined field is Boolean, you'll be able to select Yes or No.

Top Tip: Click and drag downwards from the bottom right of a cell to apply the same value to multiple cells!

Boolean_UDF.png

 

Once you've added in all the information, return to the System > User Defined Fields page and click the user defined field you'd like to import values for. Click +Add and select that you are uploading.

upload_UDF_spreadsheet.png

 

Click Browse to select the file on your computer, then click Upload to upload it.

slect_USD_spreadsheet_file.png

 

On the next page, you can review the information you are about to import. You can cancel the upload if you've selected the wrong file or need to make changes or import the details by clicking the Confirm and Import button.

If you've left a field blank in the spreadsheet, we won't be able to import the information for this user (shown as a cross in the example below).

Screenshot_2022-10-25_at_10.18.00.png

 

After confirming the upload, the details will show as updated.

Screenshot_2022-10-25_at_10.18.42.png

 

Back on the System > User Defined Fields > Select User defined field page, you can see the values have been updated for these students.

Screenshot_2022-10-25_at_10.19.07.png

Updating User Defined Fields on a user's profile

User Defined Fields can be seen and updated from the User Defined Fields section in student, guardian and staff profiles. You can see how this works here: User Defined Fields (UDFs) on student, guardian or staff profiles

edit_UDF_on_profile.png

 
Was this article helpful?
7 out of 10 found this helpful
I'm still stuck!

Comments

2 comments
  • I think it would help if the UPN of the student was included in the upload template.

    This would make it easier to match up data from other sources that don't have the Arbor ID.

    0
  • Hi Karen, thanks for your thoughts. Please add your feedback here.

    0

Article is closed for comments.