Tip: Use ”Data Review” Columns Carefully!
Data Review columns allow you to display information to users but don”t allow users to change the data they contain. Most marksheets will contain at least a few columns that you want to protect like this, usually to stop users accidentally changing data.
But Data Review columns lack flexibility - you can”t change a data review column into a data entry column. You have to delete the column and create a new data entry column.
So, unless you are 100% sure that you”ll never need users to amend the data, always define new columns as data entry and tick the ”read only” option. Ticking this option makes the column read only, just like a data review column, but if you need to open the column up for data entry, just un-tick the option.
I only use the data review button for aspects that contain the official keystage results - the only data that schools should never change.
