Add your own columns and fields to your table

You can add custom columns and fields to your data, choosing the data type and creating your own lists for users to select from. You can also create calculated fields, using your own formulas to generate values based on other fields. In addition, you can build lookup tables, allowing one column’s value to be determined by another.

For example, you might add a column to your staff table that lets you select a role from a list you’ve created. A lookup table can then determine how much that teacher should be teaching based on their role, and a calculated field can automatically work out their PPA.