ionMy - July Hot Tips (2021) Highlighting Cells in Reports and Editing Credential Alert Timeframe
SUPPORT HOT TIP #1 – REPORTING - HIGHLIGHTING A CELL
We can set cells within our report results to be coloured based on certain criteria. For example, records open longer than 5, 10, 20 days; Risk Rated High or Extreme and so on.
the format is x to y:color
and use ; as the rule separator
Here we have set a rule on the Summary table, first selecting the Settings toggle next to the ‘Total Incidents’ field. Then we have set the cell highlight rule of:
5 to 6:Blue;7 to 10:Red
Tip: Any official HTML colour can be used in your highlight rules. Here is a guide I refer to:
https://www.cknow.com/cms/articles/what-are-the-official-html-color-names-and-hex-codes-3.html
SUPPORT HOT TIP #2 – UPDATING YOUR CREDENTIAL EXPIRY ALERT TIMING
The Department of Health have suggested that it would be beneficial to remind staff, and others, of expiring Police and NDIS Worker Screening checks 12 weeks prior to expiry, due to delayed renewal processing times by the National Police Checking Service.
ionMy can be updated to assist with this by;
Updating Credential Expiry Timed Reminder setting to 120960 minutes (12 weeks)
In Reminders > Setup > Setup Reminder > edit Staff Credential Expired to 120960
If you have volunteers, contractors, or others with these credential types, please repeat this process for "TPP Credential Expired"
Updating any Police Check and NDIS Worker Screening Credential Reports to highlight certificates that expire within the next 3 months.
If you require further guidance with these changes please do contact the Support Team.
Click here to download July Hot tips