Tables across the MIS

Our 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

Bulk actions

The Bulk action button can be used both for bulk editing, and to take further actions! You can see full details about using this feature here: How and what can I update using bulk actions?

Once you have selected the (editable) cells to update, click the Bulk action button to change the cell values in bulk.

 

To take further actions, tick the boxes next to students then click the Bulk Action button to take further actions or follow-ups, such as sending communications.

 

Downloading and analysis

You can easily get aggregate figures right within the table, without needing to export and calculate! Just select cells by:

• using the shift key to select fields in a rectangle
• clicking on a field and dragging until they are all selected
• holding down your control key and selecting the values you want to analyse

At the bottom of the table, you'll then see the status bar, which will display an Average, Count, Minimum value, Maximum value and Sum of all the cells you've selected!

Top Tips:

• Non-numeric and time/date cells will only display the Count.
• The status bar won't display if you've selected a cell with a drop-down.
• You can copy and paste the status bar values.

 

If you do need to download your data into different formats such as Word or PDF, just click the Download button at the top of the table. You can see more about using this feature here: Downloading files from Arbor

 

Top Tip: You can customise some additional fields to output when creating an Excel download or Live Feed: Customising the download with Unique Student Identifiers

 

Ordering and resizing

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

 

If you sort a column, hold down Shift, and click on another column header, this will apply a multi-column sort. Top Tip: This will only apply this to the page you're on if there are multiple pages in your table.

 

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.

 

Change the table height

Table heights are a maximum of 480px, to fit the majority of screens.

Click the Expand table button to either:

• fit the table to your entire window. Top Tip: You can zoom out on your browser and repeat this multiple times.
• extend the table to 600px, if the table already sits on the bottom of the page and you are unable to scroll.

This will then be saved on a per-user per-table basis.

 

Click Reset table to return the height to 480px.

 

If a table has no data, or doesn't have enough data to fit the entire page, the button will not be visible and the table will have a height of 208px.

 

The option buttons at the top

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

Top Tip: You can also use your cmd (cntrl on a Mac) + Z keys to undo data entry.

 

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! 

 

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

 

Use the cog button to:

• change your spacing and text display size - by default, if the height is less than 700px it will adjust its height to match the table content, and if above 700px, the table height will stay as 700px, and it will scroll internally.
• reset your table settings
• disable colours in the cells
• enable vertical column borders to your table

Top Tip: This won't change any data in the table, just the way it's displayed. It's also saved on a per-user per-table basis, so you'll need to enable it on your favourite tables.

 

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

 

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.

 

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.

 

You can always see the number of results or rows at the bottom of each table.

• When you apply a filter, we'll tell you haw may are filtered out.
• If the table has multiple pages, we'll let you know how the filter has been applied.

 

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 originallywas.

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.

 

You don't need to delete the text by backspacing to clear your filters. Just click the Reset button to remove any filters you've applied.

 

Different ways to enter your data

Top Tip: You can only fill in fields that are editable (fields that have an arrow or pencil icon).

Fill in a field by typing in 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.

 

Click in the bottom right of a field and drag down to fill in cells in bulk.

 

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.

 

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.

 

If you try to go to another page in Arbor, we'll ask you whether you want to keep editing, or if you want to navigate away and remove the invalid data.

 

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.

 

Some tables need you to hit save or submit to store the data you've input. For these tables, we'll now warn you if you're trying to navigate away with unsaved changes.

 

Tables in slide overs

In slide overs where you can add additional rows, the tables are reduced to save space and don't show the options for:

• search bar
• hidden columns
• downloads
• re-ordering columns

 

If you try to save with invalid data (such as a date in an invalid format), we'll let you know you need to correct it.

Top Tip: You'll also see messages like this on form-based tables not in slide overs (anywhere that doesn’t save automatically but has a save/submit button).