Select a meal for this compartment
Choose a meal to copy into this slot
Choose a day & compartment
Updates all meal planner titles, favorite labels, and family event tags across the app.
Blacks out the display, pauses background sync, releases browser Wake Lock so your deviceβs screen timeout can turn off the backlight, and triggers hardware screen off in Fully Kiosk Browser when supported.
Backend Shared Secret protects your Google Sheet & Calendar Apps Scripts (must match FAMILY_SECRET in your Apps Scripts; never synced into Sheet data).
One unified Apps Script Web App URL syncs both your Google Sheet (meals & settings) and Google Calendar (family events & US holidays).
Google delivers within the selected 1-hour window in your timezone. Click Apply Schedule after updating & deploying the Unified Script.
var DEFAULT_SHEET_ID = '19TnRtIvIU6CRuuT8_figeZzXEqMUvcV9rYQm6zFug2c';
var FAMILY_SECRET = 'YOUR_BACKEND_SECRET'; // Set to match Backend Shared Secret in Settings
var DIGEST_RECIPIENTS = ''; // Fallback comma-separated emails if not set in BentoBoard Settings
var DIGEST_APP_URL = 'https://bentoboard-school-meals.vercel.app';
var DIGEST_TIMEZONE = ''; // Optional e.g. 'America/New_York' (defaults to Script timezone)
var DIGEST_WEEKDAYS_ONLY = false; // Set true to skip Saturday/Sunday morning digest emails
function getExpectedSecret_() {
try {
var propSecret = PropertiesService.getScriptProperties().getProperty('FAMILY_SECRET');
if (propSecret) return propSecret;
} catch (pe) {}
if (typeof BENTO_SCRIPT_SECRET !== 'undefined' && BENTO_SCRIPT_SECRET) {
return BENTO_SCRIPT_SECRET;
}
return FAMILY_SECRET;
}
function checkSecret_(provided) {
var expected = getExpectedSecret_();
if (!expected) return;
var cache = CacheService.getScriptCache();
if (cache.get('bento_auth_lock')) {
throw new Error('Too many failed attempts. Try again in 15 minutes.');
}
if (String(provided || '') !== expected) {
var fails = Number(cache.get('bento_auth_fails') || 0) + 1;
cache.put('bento_auth_fails', String(fails), 900);
if (fails >= 5) cache.put('bento_auth_lock', '1', 900);
throw new Error('Unauthorized: invalid Backend Secret');
}
cache.remove('bento_auth_fails');
}
function getStateSheet_(spreadsheetId) {
var ss = SpreadsheetApp.openById(spreadsheetId || DEFAULT_SHEET_ID);
return ss.getSheetByName('BentoBoardState') || ss.insertSheet('BentoBoardState');
}
function getTargetCalendar_(calId) {
if (calId) {
var byId = CalendarApp.getCalendarById(calId);
if (byId) return byId;
}
return CalendarApp.getDefaultCalendar();
}
function listEventsForParams_(params) {
var p = params || {};
checkSecret_(p.secret);
var cal = getTargetCalendar_(p.calendarId);
var now = new Date();
var start = p.start ? new Date(p.start + 'T00:00:00') : new Date(now.getTime() - 14 * 86400000);
var end = p.end ? new Date(p.end + 'T23:59:59') : new Date(now.getTime() + 45 * 86400000);
var tz = Session.getScriptTimeZone() || 'America/New_York';
var mapCalEvents_ = function(calObj, isHoliday, isWork, extraMeta) {
return calObj.getEvents(start, end).map(function(ev) {
var s = ev.getStartTime();
var en = ev.getEndTime();
var endInclusive = ev.isAllDayEvent() ? new Date(en.getTime() - 1) : en;
var startDateStr = Utilities.formatDate(s, tz, 'yyyy-MM-dd');
var endDateStr = Utilities.formatDate(endInclusive, tz, 'yyyy-MM-dd');
var guests = '';
var title = '';
var loc = '';
var desc = '';
try { title = ev.getTitle() || ''; } catch (te) {}
if (isWork && !title) title = 'Work (Busy)';
if (extraMeta && !title) title = (extraMeta.label || 'Calendar') + ' (Busy)';
if (!isHoliday && !isWork) {
try { loc = ev.getLocation() || ''; } catch (le) {}
try { desc = ev.getDescription() || ''; } catch (de) {}
if (!extraMeta) {
try {
guests = ev.getGuestList().map(function(g) { return g.getEmail(); }).join(', ');
} catch (ge) {}
}
}
return {
googleEventId: ev.getId(),
title: title,
date: startDateStr,
endDate: endDateStr >= startDateStr ? endDateStr : startDateStr,
startTime: ev.isAllDayEvent() ? '' : Utilities.formatDate(s, tz, 'HH:mm'),
endTime: ev.isAllDayEvent() ? '' : Utilities.formatDate(en, tz, 'HH:mm'),
allDay: ev.isAllDayEvent(),
location: loc,
notes: desc,
guests: guests,
isHoliday: Boolean(isHoliday),
isWork: Boolean(isWork),
isExtra: Boolean(extraMeta),
extraSlot: extraMeta ? extraMeta.slot : -1,
extraLabel: extraMeta ? extraMeta.label : '',
extraColor: extraMeta ? extraMeta.color : ''
};
});
};
var events = mapCalEvents_(cal, false, false, null);
if (p.workCalendarId && String(p.workCalendarId).trim() !== String(p.calendarId || '').trim()) {
try {
var workId = String(p.workCalendarId).trim();
var workCal = CalendarApp.getCalendarById(workId) || CalendarApp.subscribeToCalendar(workId);
if (workCal) {
events = events.concat(mapCalEvents_(workCal, false, true, null));
}
} catch (we) {}
}
var extraList = [];
if (p.extraCalendars) {
try {
extraList = typeof p.extraCalendars === 'string' ? JSON.parse(p.extraCalendars) : p.extraCalendars;
} catch (ee) {
extraList = [];
}
}
if (Array.isArray(extraList)) {
for (var xi = 0; xi < extraList.length; xi++) {
var ex = extraList[xi];
var exId = ex && ex.id ? String(ex.id).trim() : '';
if (!exId || exId === String(p.calendarId || '').trim() || exId === String(p.workCalendarId || '').trim()) continue;
try {
var exCal = CalendarApp.getCalendarById(exId) || CalendarApp.subscribeToCalendar(exId);
if (exCal) {
events = events.concat(mapCalEvents_(exCal, false, false, {
slot: typeof ex.slot === 'number' ? ex.slot : xi,
label: ex.label || ('Calendar ' + (xi + 1)),
color: ex.color || 'amber'
}));
}
} catch (xe) {}
}
}
try {
var holidayCal = CalendarApp.getCalendarById('en.usa#holiday@group.v.calendar.google.com');
if (holidayCal) {
events = events.concat(mapCalEvents_(holidayCal, true, false, null));
}
} catch (he) {}
return ContentService.createTextOutput(JSON.stringify({ ok: true, events: events }))
.setMimeType(ContentService.MimeType.JSON);
}
var SHEET_CELL_CHUNK_SIZE = 45000;
var SHEET_ROW_COUNT = 7;
function joinSheetRowCells_(row) {
if (!row || !row.length) return '';
var out = '';
for (var i = 0; i < row.length; i++) {
if (row[i] !== '' && row[i] !== null && row[i] !== undefined) {
out += String(row[i]);
}
}
return out;
}
function chunkStringForSheet_(str, chunkSize) {
var s = String(str || '');
var size = chunkSize || SHEET_CELL_CHUNK_SIZE;
if (s.length <= size) return [s];
var chunks = [];
for (var i = 0; i < s.length; i += size) {
chunks.push(s.slice(i, i + size));
}
return chunks;
}
function pruneScheduleForSheet_(sched) {
var out = {};
if (!sched || typeof sched !== 'object') return out;
for (var dateKey in sched) {
if (!Object.prototype.hasOwnProperty.call(sched, dateKey)) continue;
var dayObj = sched[dateKey];
if (!dayObj || typeof dayObj !== 'object') continue;
var cleanedDay = {};
var hasAny = false;
for (var slot in dayObj) {
if (!Object.prototype.hasOwnProperty.call(dayObj, slot)) continue;
var arr = dayObj[slot];
if (Array.isArray(arr) && arr.length > 0) {
cleanedDay[slot] = arr;
hasAny = true;
}
}
if (hasAny) out[dateKey] = cleanedDay;
}
return out;
}
function pruneWeeklyGoalsForSheet_(goals) {
var out = {};
if (!goals || typeof goals !== 'object') return out;
for (var wk in goals) {
if (!Object.prototype.hasOwnProperty.call(goals, wk)) continue;
if (Array.isArray(goals[wk]) && goals[wk].length > 0) {
out[wk] = goals[wk];
}
}
return out;
}
function pruneDayNotesForSheet_(notes) {
var out = {};
if (!notes || typeof notes !== 'object') return out;
for (var k in notes) {
if (!Object.prototype.hasOwnProperty.call(notes, k)) continue;
if (notes[k] !== null && notes[k] !== undefined && String(notes[k]).trim() !== '') {
out[k] = String(notes[k]);
}
}
return out;
}
function readSheetState_(sheet) {
var lastCol = Math.max(1, sheet.getLastColumn());
var numRows = Math.max(SHEET_ROW_COUNT, Math.min(SHEET_ROW_COUNT, sheet.getLastRow()));
var rows = sheet.getRange(1, 1, numRows, lastCol).getValues();
var raw1 = joinSheetRowCells_(rows[0]);
if (!raw1) return null;
var state = JSON.parse(raw1);
if (!state || typeof state !== 'object') return null;
var raw2 = joinSheetRowCells_(rows[1]);
var raw3 = joinSheetRowCells_(rows[2]);
var raw4 = joinSheetRowCells_(rows[3]);
var raw5 = joinSheetRowCells_(rows[4]);
var raw6 = rows.length > 5 ? joinSheetRowCells_(rows[5]) : '';
var raw7 = rows.length > 6 ? joinSheetRowCells_(rows[6]) : '';
if (raw2) state.meals = JSON.parse(raw2);
if (raw3) state.schedule = JSON.parse(raw3);
if (raw4) state.weeklyGoals = JSON.parse(raw4);
if (raw5) state.lists = JSON.parse(raw5);
if (raw6) state.dayNotes = JSON.parse(raw6);
if (raw7) state.noSchoolDays = JSON.parse(raw7);
return state;
}
function writeSheetState_(sheet, nextState) {
var core = {};
for (var k in nextState) {
if (Object.prototype.hasOwnProperty.call(nextState, k)) {
if (k === 'meals' || k === 'schedule' || k === 'weeklyGoals' || k === 'lists' || k === 'dayNotes' || k === 'noSchoolDays') continue;
core[k] = nextState[k];
}
}
core.schemaVersion = 3;
var rowStrings = [
JSON.stringify(core),
JSON.stringify(nextState.meals || []),
JSON.stringify(pruneScheduleForSheet_(nextState.schedule)),
JSON.stringify(pruneWeeklyGoalsForSheet_(nextState.weeklyGoals)),
JSON.stringify(nextState.lists || []),
JSON.stringify(pruneDayNotesForSheet_(nextState.dayNotes)),
JSON.stringify(nextState.noSchoolDays || {})
];
var rowChunks = [];
var neededCols = 1;
for (var r = 0; r < rowStrings.length; r++) {
var chunks = chunkStringForSheet_(rowStrings[r], SHEET_CELL_CHUNK_SIZE);
rowChunks.push(chunks);
if (chunks.length > neededCols) neededCols = chunks.length;
}
var totalCols = Math.max(neededCols, sheet.getLastColumn(), 1);
var grid = [];
for (var rIdx = 0; rIdx < rowChunks.length; rIdx++) {
var row = [];
for (var cIdx = 0; cIdx < totalCols; cIdx++) {
row.push(cIdx < rowChunks[rIdx].length ? rowChunks[rIdx][cIdx] : '');
}
grid.push(row);
}
sheet.getRange(1, 1, SHEET_ROW_COUNT, totalCols).setNumberFormat('@').setValues(grid);
}
function doGet(e) {
try {
var params = (e && e.parameter) || {};
if (params.action === 'listEvents') {
return listEventsForParams_(params);
}
checkSecret_(params.secret);
var sheet = getStateSheet_(params.spreadsheetId);
var existing = readSheetState_(sheet);
return ContentService.createTextOutput(JSON.stringify({
ok: true,
state: existing,
updatedAt: (existing && existing.updatedAt) || ''
})).setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({ ok: false, error: err.toString() }))
.setMimeType(ContentService.MimeType.JSON);
}
}
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
checkSecret_(data && data.secret);
if (data.action === 'listEvents') {
return listEventsForParams_(data);
}
if (data.action === 'createCalendarEvent') {
var cal = getTargetCalendar_(data.calendarId);
var opts = {
location: data.location || '',
description: data.description || ''
};
if (data.guests) {
var cleanGuests = String(data.guests)
.split(/[,;\s]+/)
.map(function(s) { return s.trim(); })
.filter(Boolean)
.join(',');
if (cleanGuests) {
opts.guests = cleanGuests;
opts.sendInvites = true;
}
}
var ev;
var endDateStr = (data.endDate && data.endDate >= data.date) ? data.endDate : data.date;
if (data.allDay) {
var allDayStart = new Date(data.date + 'T00:00:00');
var allDayEnd = new Date(endDateStr + 'T00:00:00');
allDayEnd.setDate(allDayEnd.getDate() + 1);
ev = cal.createAllDayEvent(data.title, allDayStart, allDayEnd, opts);
} else {
var start = new Date(data.date + 'T' + (data.startTime || '09:00') + ':00');
var end = new Date(endDateStr + 'T' + (data.endTime || '10:00') + ':00');
ev = cal.createEvent(data.title, start, end, opts);
}
return ContentService.createTextOutput(JSON.stringify({ ok: true, googleEventId: ev.getId() }))
.setMimeType(ContentService.MimeType.JSON);
}
if (data.action === 'updateCalendarEvent') {
var calUpd = getTargetCalendar_(data.calendarId);
var evUpd = data.googleEventId ? calUpd.getEventById(data.googleEventId) : null;
if (evUpd) {
evUpd.setTitle(data.title || evUpd.getTitle());
evUpd.setLocation(data.location || '');
evUpd.setDescription(data.description || '');
var updEndStr = (data.endDate && data.endDate >= data.date) ? data.endDate : data.date;
if (data.allDay) {
var uStart = new Date(data.date + 'T00:00:00');
var uEnd = new Date(updEndStr + 'T00:00:00');
uEnd.setDate(uEnd.getDate() + 1);
evUpd.setAllDayDates(uStart, uEnd);
} else {
evUpd.setTime(
new Date(data.date + 'T' + (data.startTime || '09:00') + ':00'),
new Date(updEndStr + 'T' + (data.endTime || '10:00') + ':00')
);
}
return ContentService.createTextOutput(JSON.stringify({ ok: true, updated: true }))
.setMimeType(ContentService.MimeType.JSON);
}
return ContentService.createTextOutput(JSON.stringify({ ok: true, updated: false }))
.setMimeType(ContentService.MimeType.JSON);
}
if (data.action === 'deleteCalendarEvent') {
var calDel = getTargetCalendar_(data.calendarId);
var evDel = data.googleEventId ? calDel.getEventById(data.googleEventId) : null;
if (!evDel && data.date && data.title) {
var dayEvents = calDel.getEventsForDay(new Date(data.date + 'T12:00:00'));
for (var i = 0; i < dayEvents.length; i++) {
if (dayEvents[i].getTitle() === data.title) {
evDel = dayEvents[i];
break;
}
}
}
if (evDel) {
evDel.deleteEvent();
return ContentService.createTextOutput(JSON.stringify({ ok: true, deleted: true }))
.setMimeType(ContentService.MimeType.JSON);
}
return ContentService.createTextOutput(JSON.stringify({ ok: true, deleted: false }))
.setMimeType(ContentService.MimeType.JSON);
}
if (data.action === 'sendDailyDigest') {
var dailyResult = sendDailyMorningDigest({
spreadsheetId: data.spreadsheetId,
recipients: data.recipients
});
return ContentService.createTextOutput(JSON.stringify(dailyResult))
.setMimeType(ContentService.MimeType.JSON);
}
if (data.action === 'sendWeeklyDigest') {
var weeklyResult = sendWeeklyDigest({
spreadsheetId: data.spreadsheetId,
recipients: data.recipients,
weekMonday: data.weekMonday
});
return ContentService.createTextOutput(JSON.stringify(weeklyResult))
.setMimeType(ContentService.MimeType.JSON);
}
if (data.action === 'updateDigestTriggers') {
saveDigestProps_(data.spreadsheetId, data.timeZone);
var trigSheet = getStateSheet_(data.spreadsheetId || getSavedDigestSheetId_());
var trigState = readSheetState_(trigSheet) || {};
var sched = data.digestSchedule || trigState.digestSchedule || {};
var schedSummary = applyDigestTriggersFromSchedule_(sched, data.timeZone);
var quota = MailApp.getRemainingDailyQuota();
var activeCount = ScriptApp.getProjectTriggers().filter(function(t) {
var fn = t.getHandlerFunction();
return fn === 'sendDailyMorningDigest' || fn === 'sendWeeklyDigest';
}).length;
var recipNote = '';
try {
resolveDigestRecipients_(trigState, data.recipients);
} catch (re) {
recipNote = ' (Warning: set Digest Email Recipients before next run)';
}
return ContentService.createTextOutput(JSON.stringify({
ok: true,
triggerCount: activeCount,
remainingEmailQuota: quota,
summary: schedSummary + ' [' + activeCount + ' trigger(s) active]' + recipNote
})).setMimeType(ContentService.MimeType.JSON);
}
var sheet = getStateSheet_(data.spreadsheetId);
var existing = readSheetState_(sheet);
if (data.action === 'getState') {
return ContentService.createTextOutput(JSON.stringify({
ok: true,
state: existing,
updatedAt: (existing && existing.updatedAt) || ''
})).setMimeType(ContentService.MimeType.JSON);
}
if (!data.state || typeof data.state !== 'object') {
throw new Error('Invalid state payload');
}
if (!data.force && existing && existing.updatedAt && data.lastKnownUpdatedAt && existing.updatedAt !== data.lastKnownUpdatedAt) {
return ContentService.createTextOutput(JSON.stringify({
ok: false,
conflict: true,
serverUpdatedAt: existing.updatedAt,
state: existing
})).setMimeType(ContentService.MimeType.JSON);
}
var nextState = data.state || data;
nextState.updatedAt = data.updatedAt || new Date().toISOString();
writeSheetState_(sheet, nextState);
return ContentService.createTextOutput(JSON.stringify({ ok: true, updatedAt: nextState.updatedAt }))
.setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({ ok: false, error: err.toString() }))
.setMimeType(ContentService.MimeType.JSON);
}
}
/* ============================================================================
DAILY MORNING & WEEKLY DIGEST EMAILS
Run authorizeAllScopes() once, then setupDigestTriggers() to schedule:
- Daily Morning Digest every day at ~7:00 AM
- Weekly Preview Digest every Sunday at ~5:00 PM
============================================================================ */
function authorizeAllScopes() {
CalendarApp.getDefaultCalendar();
SpreadsheetApp.openById(DEFAULT_SHEET_ID);
MailApp.getRemainingDailyQuota();
ScriptApp.getProjectTriggers();
return 'All Calendar, Sheet, Mail, and Trigger scopes authorized!';
}
function authorizeCalendar() {
return authorizeAllScopes();
}
function clampDigestHour_(raw, fallbackHour) {
var h = parseInt(raw, 10);
if (isNaN(h) || h < 0 || h > 23) return fallbackHour;
return h;
}
function saveDigestProps_(spreadsheetId, timeZone) {
try {
var props = PropertiesService.getScriptProperties();
if (spreadsheetId && String(spreadsheetId).trim()) {
props.setProperty('BENTO_DIGEST_SHEET_ID', String(spreadsheetId).trim());
}
if (timeZone && String(timeZone).trim()) {
props.setProperty('BENTO_DIGEST_TIMEZONE', String(timeZone).trim());
}
} catch (pe) {}
}
function getSavedDigestSheetId_() {
try {
var saved = PropertiesService.getScriptProperties().getProperty('BENTO_DIGEST_SHEET_ID');
if (saved) return saved;
} catch (pe) {}
return DEFAULT_SHEET_ID;
}
function applyDigestTriggersFromSchedule_(sched, timeZoneOverride) {
var s = sched || {};
var tz = (timeZoneOverride && String(timeZoneOverride).trim()) || getDigestTimeZone_();
var dailyEnabled = s.dailyEnabled !== false;
var dailyHour = clampDigestHour_(s.dailyHour, 7);
var weeklyEnabled = s.weeklyEnabled !== false;
var weeklyHour = clampDigestHour_(s.weeklyHour, 17);
var dayKey = String(s.weeklyDay || 'SUNDAY').toUpperCase();
var weekDayMap = {
SUNDAY: ScriptApp.WeekDay.SUNDAY,
MONDAY: ScriptApp.WeekDay.MONDAY,
TUESDAY: ScriptApp.WeekDay.TUESDAY,
WEDNESDAY: ScriptApp.WeekDay.WEDNESDAY,
THURSDAY: ScriptApp.WeekDay.THURSDAY,
FRIDAY: ScriptApp.WeekDay.FRIDAY,
SATURDAY: ScriptApp.WeekDay.SATURDAY
};
var weeklyDay = weekDayMap[dayKey] || ScriptApp.WeekDay.SUNDAY;
removeDigestTriggers();
var parts = [];
if (dailyEnabled) {
var dBuilder = ScriptApp.newTrigger('sendDailyMorningDigest')
.timeBased()
.everyDays(1)
.atHour(dailyHour);
try { if (tz) dBuilder.inTimezone(tz); } catch (tze) {}
dBuilder.create();
parts.push('Daily at ' + formatDigestTime12h_(String(dailyHour) + ':00') + (s.dailyWeekdaysOnly ? ' (MonβFri)' : ''));
} else {
parts.push('Daily Off');
}
if (weeklyEnabled) {
var wBuilder = ScriptApp.newTrigger('sendWeeklyDigest')
.timeBased()
.onWeekDay(weeklyDay)
.atHour(weeklyHour);
try { if (tz) wBuilder.inTimezone(tz); } catch (wtze) {}
wBuilder.create();
parts.push('Weekly on ' + dayKey.charAt(0) + dayKey.slice(1).toLowerCase() + ' at ' + formatDigestTime12h_(String(weeklyHour) + ':00'));
} else {
parts.push('Weekly Off');
}
return 'Digest schedule updated (' + tz + '): ' + parts.join(' β’ ');
}
function setupDigestTriggers(optionalSchedule) {
var sched = optionalSchedule;
if (!sched) {
try {
var sheet = getStateSheet_(getSavedDigestSheetId_());
var st = readSheetState_(sheet) || {};
sched = st.digestSchedule || {};
} catch (e) {
sched = {};
}
}
return applyDigestTriggersFromSchedule_(sched);
}
function removeDigestTriggers() {
var triggers = ScriptApp.getProjectTriggers();
for (var i = 0; i < triggers.length; i++) {
var fn = triggers[i].getHandlerFunction();
if (fn === 'sendDailyMorningDigest' || fn === 'sendWeeklyDigest') {
ScriptApp.deleteTrigger(triggers[i]);
}
}
}
function escapeDigestHtml_(str) {
return String(str || '')
.replace(/&/g, '&')
.replace(/</g, '<')
.replace(/>/g, '>')
.replace(/"/g, '"')
.replace(/'/g, ''');
}
function getDigestTimeZone_() {
if (DIGEST_TIMEZONE) return DIGEST_TIMEZONE;
try {
var savedTz = PropertiesService.getScriptProperties().getProperty('BENTO_DIGEST_TIMEZONE');
if (savedTz) return savedTz;
} catch (pe) {}
return Session.getScriptTimeZone() || 'America/New_York';
}
function formatDateKeyTz_(dateObj, tz) {
return Utilities.formatDate(dateObj, tz, 'yyyy-MM-dd');
}
function addDaysToKey_(dateKey, offsetDays, tz) {
var parts = String(dateKey).split('-');
var d = new Date(Number(parts[0]), Number(parts[1]) - 1, Number(parts[2]), 12, 0, 0);
d.setDate(d.getDate() + offsetDays);
return formatDateKeyTz_(d, tz);
}
function getMondayKeyForKey_(dateKey, tz) {
var parts = String(dateKey).split('-');
var d = new Date(Number(parts[0]), Number(parts[1]) - 1, Number(parts[2]), 12, 0, 0);
var dow = d.getDay();
var diff = dow === 0 ? -6 : 1 - dow;
return addDaysToKey_(dateKey, diff, tz);
}
function formatDigestDayLabel_(dateKey, tz) {
var parts = String(dateKey).split('-');
var d = new Date(Number(parts[0]), Number(parts[1]) - 1, Number(parts[2]), 12, 0, 0);
return Utilities.formatDate(d, tz, 'EEEE, MMM d');
}
function formatDigestTime12h_(hhmm) {
if (!hhmm || String(hhmm).indexOf(':') === -1) return hhmm || '';
var parts = String(hhmm).split(':');
var h = parseInt(parts[0], 10);
if (isNaN(h)) return hhmm;
var ampm = h >= 12 ? 'PM' : 'AM';
var h12 = h % 12 || 12;
return h12 + ':' + parts[1] + ' ' + ampm;
}
function resolveDigestRecipients_(state, overrideRecipients) {
var raw = overrideRecipients || (state && state.digestRecipients) || DIGEST_RECIPIENTS || Session.getEffectiveUser().getEmail() || '';
var list = String(raw)
.split(/[,;\n]+/)
.map(function(s) { return s.trim(); })
.filter(function(s) { return s.indexOf('@') !== -1; });
if (!list.length) {
throw new Error('No digest recipient email configured. Set Digest Email Recipients in BentoBoard Settings or DIGEST_RECIPIENTS in Apps Script.');
}
return list.join(',');
}
function getDigestEventsForRange_(state, startKey, endKey, tz) {
var calCfg = (state && state.familyCalConfig) || {};
var cal = getTargetCalendar_(calCfg.calendarId || '');
var startParts = startKey.split('-');
var endParts = endKey.split('-');
var startDt = new Date(Number(startParts[0]), Number(startParts[1]) - 1, Number(startParts[2]), 0, 0, 0);
var endDt = new Date(Number(endParts[0]), Number(endParts[1]) - 1, Number(endParts[2]), 23, 59, 59);
var collected = [];
var collectCal = function(calObj, isHoliday, isWork) {
if (!calObj) return;
var evs = calObj.getEvents(startDt, endDt);
for (var i = 0; i < evs.length; i++) {
var ev = evs[i];
var s = ev.getStartTime();
var en = ev.getEndTime();
var endIncl = ev.isAllDayEvent() ? new Date(en.getTime() - 1) : en;
var sKey = formatDateKeyTz_(s, tz);
var eKey = formatDateKeyTz_(endIncl, tz);
if (eKey < sKey) eKey = sKey;
var title = '';
try { title = ev.getTitle() || ''; } catch (te) {}
if (isWork && !title) title = 'Work (Busy)';
var loc = '';
if (!isHoliday && !isWork) {
try { loc = ev.getLocation() || ''; } catch (le) {}
}
collected.push({
title: title || 'Untitled Event',
date: sKey,
endDate: eKey,
startTime: ev.isAllDayEvent() ? '' : Utilities.formatDate(s, tz, 'HH:mm'),
endTime: ev.isAllDayEvent() ? '' : Utilities.formatDate(en, tz, 'HH:mm'),
allDay: ev.isAllDayEvent(),
location: loc,
isHoliday: Boolean(isHoliday),
isWork: Boolean(isWork)
});
}
};
collectCal(cal, false, false);
if (calCfg.workCalendarId && String(calCfg.workCalendarId).trim() !== String(calCfg.calendarId || '').trim()) {
try {
var workId = String(calCfg.workCalendarId).trim();
var workCal = CalendarApp.getCalendarById(workId) || CalendarApp.subscribeToCalendar(workId);
collectCal(workCal, false, true);
} catch (we) {}
}
if (Array.isArray(calCfg.extraCalendars)) {
for (var xi = 0; xi < calCfg.extraCalendars.length; xi++) {
var ex = calCfg.extraCalendars[xi];
var exId = ex && ex.id ? String(ex.id).trim() : '';
if (!exId || exId === String(calCfg.calendarId || '').trim() || exId === String(calCfg.workCalendarId || '').trim()) continue;
try {
var exCal = CalendarApp.getCalendarById(exId) || CalendarApp.subscribeToCalendar(exId);
collectCal(exCal, false, false);
} catch (xe) {}
}
}
try {
var holidayCal = CalendarApp.getCalendarById('en.usa#holiday@group.v.calendar.google.com');
collectCal(holidayCal, true, false);
} catch (he) {}
var localEvents = (state && Array.isArray(state.familyEvents)) ? state.familyEvents : [];
for (var j = 0; j < localEvents.length; j++) {
var le = localEvents[j];
if (!le || le.isWork || le.googleEventId || le.syncedToGoogle) continue;
var leStart = le.date || '';
var leEnd = le.endDate || leStart;
if (!leStart || leEnd < startKey || leStart > endKey) continue;
collected.push({
title: le.title || 'Untitled Event',
date: leStart,
endDate: leEnd,
startTime: le.allDay ? '' : (le.startTime || ''),
endTime: le.allDay ? '' : (le.endTime || ''),
allDay: Boolean(le.allDay),
location: le.location || '',
isHoliday: false,
isWork: false
});
}
return collected;
}
function sortAndFilterEventsForDay_(events, dateKey) {
var list = [];
for (var i = 0; i < events.length; i++) {
var ev = events[i];
if (ev.date <= dateKey && (ev.endDate || ev.date) >= dateKey) {
list.push(ev);
}
}
list.sort(function(a, b) {
if (a.allDay && !b.allDay) return -1;
if (!a.allDay && b.allDay) return 1;
return String(a.startTime || '').localeCompare(String(b.startTime || ''));
});
return list;
}
function formatDigestEventTimeRange_(ev) {
if (ev.allDay) return 'All Day';
var s = formatDigestTime12h_(ev.startTime);
var e = formatDigestTime12h_(ev.endTime);
if (s && e) return s + ' β ' + e;
return s || 'Timed';
}
function buildDayMealsSummary_(state, dateKey) {
var mealMap = {};
var meals = (state && Array.isArray(state.meals)) ? state.meals : [];
for (var i = 0; i < meals.length; i++) {
if (meals[i] && meals[i].id) mealMap[meals[i].id] = meals[i];
}
var daySched = (state && state.schedule && state.schedule[dateKey]) || {};
var slots = ['Breakfast', 'Snack', 'Lunch'];
var out = {};
for (var s = 0; s < slots.length; s++) {
var slotName = slots[s];
var entries = Array.isArray(daySched[slotName]) ? daySched[slotName] : [];
var items = [];
for (var k = 0; k < entries.length; k++) {
var entry = entries[k];
var mId = (entry && typeof entry === 'object') ? entry.mealId : entry;
var meal = mId ? mealMap[mId] : null;
if (meal) {
items.push({
emoji: meal.emoji || '',
name: meal.name || '',
note: meal.note || ''
});
}
}
out[slotName] = items;
}
return out;
}
function getWeekGoalsSummary_(state, mondayKey) {
var raw = (state && state.weeklyGoals && Array.isArray(state.weeklyGoals[mondayKey]))
? state.weeklyGoals[mondayKey]
: [];
var active = [];
for (var i = 0; i < raw.length; i++) {
if (raw[i] && !raw[i].archived) active.push(raw[i]);
}
var open = [];
var completedCount = 0;
for (var j = 0; j < active.length; j++) {
if (active[j].completed) {
completedCount++;
} else {
open.push(active[j]);
}
}
open.sort(function(a, b) {
return (b.pinned ? 1 : 0) - (a.pinned ? 1 : 0);
});
return {
open: open,
completedCount: completedCount,
totalCount: active.length
};
}
function renderEventsHtmlBlock_(events) {
if (!events.length) {
return '<p style="margin:0;color:#676D63;font-size:13px;">No events scheduled.</p>';
}
var html = '<table style="width:100%;border-collapse:collapse;">';
for (var i = 0; i < events.length; i++) {
var ev = events[i];
var timeLabel = formatDigestEventTimeRange_(ev);
var bg = ev.isWork ? '#FEF2F2' : (ev.isHoliday ? '#ECF6F0' : '#FAF8F1');
var border = ev.isWork ? '#FECACA' : (ev.isHoliday ? '#C4E2D0' : '#E5E0CE');
var color = ev.isWork ? '#991B1B' : (ev.isHoliday ? '#2A5740' : '#252A24');
var titleHtml = ev.isWork
? '<span style="font-weight:700;">Work</span> <span style="color:#7F1D1D;">' + escapeDigestHtml_(timeLabel) + '</span>'
: '<span style="font-weight:700;">' + escapeDigestHtml_(ev.title) + '</span>' +
(ev.location ? ' <span style="color:#676D63;font-size:12px;">β’ ' + escapeDigestHtml_(ev.location) + '</span>' : '');
html += '<tr><td style="padding:4px 0;">' +
'<div style="background:' + bg + ';border:1px solid ' + border + ';border-radius:8px;padding:7px 10px;font-size:13px;color:' + color + ';">' +
(ev.isWork ? '' : '<span style="display:inline-block;min-width:95px;font-weight:700;color:#535A51;font-size:12px;">' + escapeDigestHtml_(timeLabel) + '</span> ') +
titleHtml +
'</div></td></tr>';
}
html += '</table>';
return html;
}
function wrapDigestEmailShell_(titleText, subtitleText, bodyHtml) {
return '<!DOCTYPE html><html><body style="margin:0;padding:18px;background:#FAF8F1;font-family:Arial,Helvetica,sans-serif;color:#252A24;">' +
'<div style="max-width:620px;margin:0 auto;background:#FFFFFF;border:1.5px solid #D0C9B2;border-radius:14px;overflow:hidden;">' +
'<div style="background:#3D7A5A;color:#FFFFFF;padding:18px 20px;">' +
'<div style="font-size:11px;font-weight:700;letter-spacing:0.08em;text-transform:uppercase;opacity:0.88;">BentoBoard Family Digest</div>' +
'<h1 style="margin:4px 0 2px;font-size:20px;line-height:1.25;">' + escapeDigestHtml_(titleText) + '</h1>' +
'<div style="font-size:13px;opacity:0.92;">' + escapeDigestHtml_(subtitleText) + '</div>' +
'</div>' +
'<div style="padding:18px 20px;">' + bodyHtml + '</div>' +
'<div style="padding:14px 20px;background:#F2EFE4;border-top:1px solid #E5E0CE;text-align:center;">' +
'<a href="' + escapeDigestHtml_(DIGEST_APP_URL) + '" style="display:inline-block;background:#3D7A5A;color:#FFFFFF;text-decoration:none;font-weight:700;font-size:13px;padding:9px 18px;border-radius:8px;">Open BentoBoard</a>' +
'</div>' +
'</div>' +
'</body></html>';
}
function sendDailyMorningDigest(options) {
var opts = options || {};
var tz = getDigestTimeZone_();
var now = new Date();
var sheet = getStateSheet_(opts.spreadsheetId || getSavedDigestSheetId_());
var state = readSheetState_(sheet) || {};
var sched = (state && state.digestSchedule) || {};
var weekdaysOnly = (typeof sched.dailyWeekdaysOnly === 'boolean') ? sched.dailyWeekdaysOnly : DIGEST_WEEKDAYS_ONLY;
if (!opts.recipients && weekdaysOnly) {
var dowCheck = Number(Utilities.formatDate(now, tz, 'u'));
if (dowCheck > 5) {
Logger.log('Daily digest skipped: weekend under weekdays-only setting.');
return { ok: true, skipped: true, reason: 'Weekend skipped (Weekdays only enabled)' };
}
}
var recipients = resolveDigestRecipients_(state, opts.recipients);
var todayKey = formatDateKeyTz_(now, tz);
var mondayKey = getMondayKeyForKey_(todayKey, tz);
var dayLabel = formatDigestDayLabel_(todayKey, tz);
var childName = state.childName || 'Family';
var dow = Number(Utilities.formatDate(now, tz, 'u'));
var isSchoolDay = dow >= 1 && dow <= 5;
var dayMeals = buildDayMealsSummary_(state, todayKey);
var dayNote = (state.dayNotes && state.dayNotes[todayKey]) ? String(state.dayNotes[todayKey]).trim() : '';
var noSchoolInfo = (state.noSchoolDays && state.noSchoolDays[todayKey]) ? state.noSchoolDays[todayKey] : null;
var events = sortAndFilterEventsForDay_(getDigestEventsForRange_(state, todayKey, todayKey, tz), todayKey);
var goalsSummary = getWeekGoalsSummary_(state, mondayKey);
var textLines = ['BentoBoard Morning Digest β ' + dayLabel, ''];
var bodyHtml = '';
if (isSchoolDay || dayNote || noSchoolInfo) {
bodyHtml += '<div style="margin-bottom:16px;">' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">π± ' + escapeDigestHtml_(childName) + '\'s School Meals</h2>';
textLines.push('SCHOOL MEALS (' + childName + '):');
if (dayNote) {
bodyHtml += '<div style="background:#FFFBEB;border:1px solid #FDE68A;border-radius:8px;padding:8px 10px;font-size:13px;color:#B45309;margin-bottom:8px;"><strong>Day Note:</strong> ' + escapeDigestHtml_(dayNote) + '</div>';
textLines.push(' Note: ' + dayNote);
}
if (noSchoolInfo) {
var noSchoolReason = noSchoolInfo.reason ? ' β ' + noSchoolInfo.reason : '';
bodyHtml += '<div style="background:#FFFBEB;border:1px solid #FDE68A;border-radius:8px;padding:10px 12px;font-size:13px;color:#B45309;font-weight:700;">ποΈ No School / Day Off' + escapeDigestHtml_(noSchoolReason) + '</div>';
textLines.push(' No School / Day Off' + noSchoolReason);
} else if (isSchoolDay) {
var slotMeta = [
{ key: 'Breakfast', icon: 'π₯', bg: '#FFFBEB', border: '#FDE68A', text: '#B45309' },
{ key: 'Snack', icon: 'π', bg: '#FFF1F2', border: '#FECDD3', text: '#BE123C' },
{ key: 'Lunch', icon: 'π±', bg: '#F0FDFA', border: '#99F6E4', text: '#0F766E' }
];
for (var sm = 0; sm < slotMeta.length; sm++) {
var cfg = slotMeta[sm];
var list = dayMeals[cfg.key] || [];
var itemText = list.length
? list.map(function(m) { return (m.emoji ? m.emoji + ' ' : '') + m.name; }).join(' + ')
: 'Not assigned yet';
textLines.push(' ' + cfg.key + ': ' + itemText);
bodyHtml += '<div style="background:' + cfg.bg + ';border:1px solid ' + cfg.border + ';border-radius:8px;padding:8px 10px;margin-bottom:6px;font-size:13px;">' +
'<span style="font-weight:700;color:' + cfg.text + ';display:inline-block;min-width:92px;">' + cfg.icon + ' ' + cfg.key + '</span> ' +
'<span style="color:#252A24;font-weight:600;">' + escapeDigestHtml_(itemText) + '</span>' +
'</div>';
}
}
bodyHtml += '</div>';
textLines.push('');
}
bodyHtml += '<div style="margin-bottom:16px;">' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">π
Today\'s Schedule</h2>' +
renderEventsHtmlBlock_(events) +
'</div>';
textLines.push('TODAY\'S SCHEDULE:');
if (!events.length) {
textLines.push(' No events scheduled.');
} else {
for (var ei = 0; ei < events.length; ei++) {
var ev = events[ei];
textLines.push(' β’ ' + formatDigestEventTimeRange_(ev) + ' β ' + (ev.isWork ? 'Work' : ev.title));
}
}
textLines.push('');
bodyHtml += '<div>' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">β
Weekly Family Goals (' + goalsSummary.completedCount + '/' + goalsSummary.totalCount + ' done)</h2>';
textLines.push('WEEKLY GOALS (' + goalsSummary.completedCount + '/' + goalsSummary.totalCount + ' done):');
if (!goalsSummary.open.length) {
bodyHtml += '<p style="margin:0;color:#3D7A5A;font-size:13px;font-weight:600;">All goals for this week are complete!</p>';
textLines.push(' All goals for this week are complete!');
} else {
bodyHtml += '<ul style="margin:0;padding-left:18px;font-size:13px;color:#252A24;">';
for (var gi = 0; gi < goalsSummary.open.length; gi++) {
var g = goalsSummary.open[gi];
var pinPrefix = g.pinned ? 'π ' : '';
bodyHtml += '<li style="margin-bottom:4px;">' + pinPrefix + escapeDigestHtml_(g.title) + '</li>';
textLines.push(' β ' + pinPrefix + g.title);
}
bodyHtml += '</ul>';
}
bodyHtml += '</div>';
var subject = 'π± BentoBoard Morning Brief β ' + dayLabel;
var htmlBody = wrapDigestEmailShell_('Good Morning!', dayLabel, bodyHtml);
MailApp.sendEmail({
to: recipients,
subject: subject,
body: textLines.join('\n'),
htmlBody: htmlBody
});
return { ok: true, recipients: recipients, subject: subject, date: todayKey };
}
function sendWeeklyDigest(options) {
var opts = options || {};
var tz = getDigestTimeZone_();
var now = new Date();
var todayKey = formatDateKeyTz_(now, tz);
var dow = Number(Utilities.formatDate(now, tz, 'u'));
var defaultMonday = (dow === 6 || dow === 7)
? addDaysToKey_(todayKey, dow === 6 ? 2 : 1, tz)
: getMondayKeyForKey_(todayKey, tz);
var mondayKey = opts.weekMonday || defaultMonday;
var fridayKey = addDaysToKey_(mondayKey, 4, tz);
var sundayKey = addDaysToKey_(mondayKey, 6, tz);
var sheet = getStateSheet_(opts.spreadsheetId || getSavedDigestSheetId_());
var state = readSheetState_(sheet) || {};
var recipients = resolveDigestRecipients_(state, opts.recipients);
var childName = state.childName || 'Family';
var weekRangeLabel = formatDigestDayLabel_(mondayKey, tz) + ' β ' + formatDigestDayLabel_(fridayKey, tz);
var allEvents = getDigestEventsForRange_(state, mondayKey, sundayKey, tz);
var goalsSummary = getWeekGoalsSummary_(state, mondayKey);
var textLines = ['BentoBoard Weekly Preview β ' + weekRangeLabel, '', 'SCHOOL MEALS (' + childName + '):'];
var bodyHtml = '<div style="margin-bottom:18px;">' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">π± ' + escapeDigestHtml_(childName) + '\'s School Week Meals</h2>' +
'<table style="width:100%;border-collapse:collapse;font-size:12px;">';
for (var d = 0; d < 5; d++) {
var dKey = addDaysToKey_(mondayKey, d, tz);
var dLabel = formatDigestDayLabel_(dKey, tz);
var meals = buildDayMealsSummary_(state, dKey);
var dNote = (state.dayNotes && state.dayNotes[dKey]) ? String(state.dayNotes[dKey]).trim() : '';
var dNoSchool = (state.noSchoolDays && state.noSchoolDays[dKey]) ? state.noSchoolDays[dKey] : null;
if (dNoSchool) {
var nsText = 'No School / Day Off' + (dNoSchool.reason ? ' β ' + dNoSchool.reason : '');
textLines.push(' ' + dLabel + (dNote ? ' [' + dNote + ']' : '') + ': ' + nsText);
bodyHtml += '<tr><td style="padding:6px 0;">' +
'<div style="border:1px solid #FDE68A;border-radius:8px;padding:8px 10px;background:#FFFBEB;">' +
'<div style="font-weight:700;color:#252A24;margin-bottom:3px;">' + escapeDigestHtml_(dLabel) +
(dNote ? ' <span style="color:#B45309;font-weight:600;">β’ ' + escapeDigestHtml_(dNote) + '</span>' : '') +
'</div>' +
'<div style="color:#B45309;font-weight:700;">ποΈ ' + escapeDigestHtml_(nsText) + '</div>' +
'</div>' +
'</td></tr>';
continue;
}
var fmtSlot = function(arr) {
return arr.length ? arr.map(function(m) { return (m.emoji ? m.emoji + ' ' : '') + m.name; }).join(' + ') : 'β';
};
var bStr = fmtSlot(meals.Breakfast);
var sStr = fmtSlot(meals.Snack);
var lStr = fmtSlot(meals.Lunch);
textLines.push(' ' + dLabel + (dNote ? ' [' + dNote + ']' : '') + ': B=' + bStr + ' | S=' + sStr + ' | L=' + lStr);
bodyHtml += '<tr><td style="padding:6px 0;">' +
'<div style="border:1px solid #E5E0CE;border-radius:8px;padding:8px 10px;background:#FAF8F1;">' +
'<div style="font-weight:700;color:#252A24;margin-bottom:4px;">' + escapeDigestHtml_(dLabel) +
(dNote ? ' <span style="color:#B45309;font-weight:600;">β’ ' + escapeDigestHtml_(dNote) + '</span>' : '') +
'</div>' +
'<div style="color:#535A51;line-height:1.45;">' +
'<strong style="color:#B45309;">Breakfast:</strong> ' + escapeDigestHtml_(bStr) + '<br/>' +
'<strong style="color:#BE123C;">Snack:</strong> ' + escapeDigestHtml_(sStr) + '<br/>' +
'<strong style="color:#0F766E;">Lunch:</strong> ' + escapeDigestHtml_(lStr) +
'</div>' +
'</div>' +
'</td></tr>';
}
bodyHtml += '</table></div>';
textLines.push('');
bodyHtml += '<div style="margin-bottom:18px;">' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">π
Week Events (MonβSun)</h2>';
textLines.push('WEEK EVENTS:');
var anyWeekEvents = false;
for (var w = 0; w < 7; w++) {
var wKey = addDaysToKey_(mondayKey, w, tz);
var dayEvs = sortAndFilterEventsForDay_(allEvents, wKey);
if (!dayEvs.length) continue;
anyWeekEvents = true;
var wLabel = formatDigestDayLabel_(wKey, tz);
bodyHtml += '<div style="font-size:12px;font-weight:700;color:#535A51;margin:8px 0 4px;">' + escapeDigestHtml_(wLabel) + '</div>' +
renderEventsHtmlBlock_(dayEvs);
textLines.push(' ' + wLabel + ':');
for (var k = 0; k < dayEvs.length; k++) {
var wev = dayEvs[k];
textLines.push(' β’ ' + formatDigestEventTimeRange_(wev) + ' β ' + (wev.isWork ? 'Work' : wev.title));
}
}
if (!anyWeekEvents) {
bodyHtml += '<p style="margin:0;color:#676D63;font-size:13px;">No events scheduled for this week.</p>';
textLines.push(' No events scheduled for this week.');
}
bodyHtml += '</div>';
textLines.push('');
bodyHtml += '<div>' +
'<h2 style="margin:0 0 8px;font-size:15px;color:#252A24;">β
Weekly Family Goals (' + goalsSummary.completedCount + '/' + goalsSummary.totalCount + ' done)</h2>';
textLines.push('WEEKLY GOALS (' + goalsSummary.completedCount + '/' + goalsSummary.totalCount + ' done):');
if (!goalsSummary.open.length) {
bodyHtml += '<p style="margin:0;color:#676D63;font-size:13px;">No open goals yet for this week.</p>';
textLines.push(' No open goals yet for this week.');
} else {
bodyHtml += '<ul style="margin:0;padding-left:18px;font-size:13px;color:#252A24;">';
for (var gi = 0; gi < goalsSummary.open.length; gi++) {
var g = goalsSummary.open[gi];
var pinPrefix = g.pinned ? 'π ' : '';
bodyHtml += '<li style="margin-bottom:4px;">' + pinPrefix + escapeDigestHtml_(g.title) + '</li>';
textLines.push(' β ' + pinPrefix + g.title);
}
bodyHtml += '</ul>';
}
bodyHtml += '</div>';
var subject = 'π
BentoBoard Weekly Preview β ' + weekRangeLabel;
var htmlBody = wrapDigestEmailShell_('Weekly Family Preview', weekRangeLabel, bodyHtml);
MailApp.sendEmail({
to: recipients,
subject: subject,
body: textLines.join('\n'),
htmlBody: htmlBody
});
return { ok: true, recipients: recipients, subject: subject, weekMonday: mondayKey };
}