Clean names with visual on-call cues • Pure CSS zero-flicker hierarchy
Solid black fill with bold white text. Flags Active Duty + Annual Leave or Country Clinic + Intervention overlaps. (iCCnet Hotline 1–3 during Country Clinics is permitted.)
1st On-Call: Solid crimson Date/Day (#DC2626 weekday, #991B1B weekend) for Intervention, iCCnet 1, or CAH Intervention/General when Group on Call = H&V. 2nd / Other Shift: Bold crimson text preserving Today/weekend shading (e.g., CAH shifts when another private group is on call). Never triggered by Annual Leave or Group on Call alone.
Soft gold for the selected cardiologist and H&V in Group on Call (visible for everyone). Upgrades to vibrant amber on Today's row for clear contrast.
Sky-blue full-row highlight (#7DD3FC) with bold deep navy text, overriding passive category tints while yielding to Tiers 1–3.
Passive weekday and deeper weekend tints mapped to each hospital/service group.
Read-only Apps Script JSON feed for roster.heartlens.com.au (2026 & 2027)
Continue editing your 2026/2027 Universal Rosters in Google Sheets or via automated Gmail parsing.
Paste the script below into Extensions > Apps Script and deploy as a read-only Web App.
Any (2nd) tags in the sheet are respected for on-call logic and stripped cleanly on display.
Code.gs)
/**
* Read-only JSON endpoint for Universal Cardiac Services Roster PWA
* Deploy: Extensions > Apps Script > Deploy > New deployment > Web app
* Execute as: Me | Who has access: Anyone
*/
function doGet(e) {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName('Lists');
const range = sheet.getRange('M1:AF366');
const values = range.getDisplayValues();
const notes = range.getNotes(); // Preserves Multiple (X) cell notes
const headers = values[0];
const rows = [];
for (let r = 1; r < values.length; r++) {
if (!values[r][0]) continue;
const obj = { _notes: {} };
for (let c = 0; c < headers.length; c++) {
const key = headers[c].trim();
if (!key) continue;
obj[key] = values[r][c] || '';
if (notes[r][c]) obj._notes[key] = notes[r][c];
}
rows.push(obj);
}
return ContentService
.createTextOutput(JSON.stringify({
spreadsheet: ss.getName(),
syncedAt: new Date().toISOString(),
rows: rows
}))
.setMimeType(ContentService.MimeType.JSON);
}