New tables across the MIS

Our new tables give you a powerful and easy-to-use spreadsheet, with intuitive features such as quick search, full-screen mode, and column filtering and resizing.

We're always looking for ways we can improve, so if you have any feedback, please submit it here: Improved tables in Arbor

How can we use the new tables?

How do we switch them on?

There's nothing you need to do to switch on our new tables! Everyone who could access tables before will be able to use the new tables from the same places.

Can we switch back to our old tables?

Yes you can switch back to the old tables for now, by clicking the Toggle New Tables switch next to the search bar. If your screen size is small, you'll find this in the burger menu.

Screenshot_2022-07-14_at_09.52.23.png

Screenshot_2022-07-14_at_09.51.43.png

 

Will the new features appear on all tables on all pages?

You'll see the new tables on most of our pages on the School MIS and MAT MIS from Tuesday 19th July. To enable us to make these updates, there are some tables that will remain in the old format for now, including:

  • The Students table on the Lesson Dashboard
  • The Formative Assessment Markbook
  • The Attendance > Statistics and Bulk Edit Marks Advanced pages (the Standard page will have the new tables)
  • Tables where you can add additional rows, such as Trip and Club prices, Grade Set creation in Exams, Assessments, Assignments and Observations, and Import pages such as in the New School Year Setup.

We'll be working on upgrading these pages to the new table format over the Summer holidays. 

 

What are the new features?

We've introduced a whole host of amazing new features, and improved some existing functionality.

Additional option buttons at the top

Use the arrow buttons to undo or redo the last action taken.

undo_redo.png

 

Choose whether to hide any columns using the Hide columns feature - just untick the box and the column will no longer show. Top Tip: Click and drag a column offscreen to hide it too! 

Screenshot_2022-07-14_at_09.38.59.png

 

Click the tooltip button to hide or unhide tooltips showing more information when you hover over a field.

Screenshot_2022-07-14_at_09.40.14.png

 

Use the cog button to change your text display size and reset your table settings. Top Tip: This won't change any data in the table, just the way it's displayed.

Screenshot_2022-07-14_at_09.40.56.png

 

Bring up a full-screen view of your table using the expander.

Screenshot_2022-06-06_at_15.43.58.png

 

Search, sort and filter your table

Use the search bar to find specific pieces of data in the table, such as to search for a student's name.

Screenshot_2022-07-14_at_10.00.54.png

 

Click the arrow in a column header to open your sorting and filtering options. Use the filter to only show rows with the selected values.

Screenshot_2022-08-04_at_09.15.16.png

 

The footer will tell you how many results are shown based on your filter.

Screenshot_2022-08-01_at_12.29.20.png

 

Pin this column to the very far left or far right of your table. Pinned columns will always be shown on the screen, so you never have to scroll to see them. Select No Pin to put it back where it originally was.

Click and drag the line between two column headers to resize the column. If you columns are too wide or narrow, select to autosize the current one to the correct width, or all of them. Top Tip: Use the cog button and select Reset your table settings to revert back to the default widths.

Screenshot_2022-07-14_at_10.04.38.png

 

New ways to enter your data

Fill in a field by straight typing and pressing enter to jump to the next cell below. You can also click the pencil icon if you’d prefer to use your mouse.

Screenshot_2022-08-04_at_09.31.29.png

 

Copy and paste from any source, across multiple fields.

  • To copy, select the fields and drag until they are all selected, then use Ctrl+C (Windows) or Cmd + C (Mac).
  • To paste, select the fields and drag until they are all selected, then use Ctrl+V (Windows) or Cmd + V (Mac).

You might need to agree to share data from your Clipboard with Arbor by clicking Allow in the pop up.

agree_to_data_sharing.png

 

If you enter an invalid value, the value won't save and the field will be reset to blank.

If you paste in an invalid value, there's now no more getting trapped in the editor. Now it'll highlight the invalid value in red, and won't send the data to other areas of Arbor until you fix it.

Screenshot_2022-08-04_at_09.33.19.png

 

If you refresh the page, close your window or tab, or leave Arbor, the invalid value won't be saved. You'll get a pop-up to confirm you still want to leave the page.

leave_changes.png

 

Revamped features you know and love

Tick the boxes next to students to select them to use with bulk actions - you can see more about using this feature here: How and what can I update using bulk actions?

Screenshot_2022-06-06_at_15.45.59.png

 

Click and drag both downwards and upwards to select and deselect the rows.

Screenshot_2022-08-01_at_12.27.02.png

 

The footer will tell you how many rows you have selected.

Screenshot_2022-08-01_at_12.27.40.png

 

You can then take further actions by clicking the Bulk action button.

Screenshot_2022-07-14_at_10.08.28.png

 

Download your table into different formats such as Word or PDF by clicking Download - you can see more about using this feature here: What files can I download from Arbor?

Screenshot_2022-06-06_at_15.54.40.png

 

Click the column headers to sort from highest to lowest or alphabetically.

Screenshot_2022-07-14_at_10.09.03.png

 

Click and drag the line between two column headers to resize the column. You can also drag and drop your columns into any order you like, and we'll remember them for you for when you return to this specific page.

Screenshot_2022-07-14_at_10.14.42.png

Was this article helpful?
3 out of 5 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.