Accessing 4Matrix from Outside School

There are several ways in which this can be achieved, and we have put together a document to help users decide on which option is best for their school. 

You can download the document from this link: https://www.4matrix.com/news/remoteaccess

In-light of the current situation, we are extending the free-use period of 4Matrix Infinity for all schools until September 2020.


Import Fix

There is a fix available for an error which occurs when attempting to import data via a spreadsheet into an existing series in which results or custom field data has already been imported.

Please visit https://www.4matrix.com/news/importfix for more details.


 Exported spreadsheet COUNTA formula is not working as expected

Solution

This is a common problem with Excel. The blank cells in the export are actually set to ‘Null’ instead of blank, which is why they are being included in the COUNTA.

There is another formula that you can use, which we’ve tested, and it seems to be more accurate:

=COUNTIF(range,"?*")

As of February 2017, Results Overview is the only export which 'auto-converts' NULL values to blank.

 

 
Was this article helpful? yes / no
 

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies