Prayer Day Sign‑Up
We’ll send a confirmation to your email. By signing up, you agree not to share contact info publicly.
/*
* Code.gs — Google Apps Script backend for Prayer Sign‑Ups
*/
function doGet(e){
try{
const action = (e.parameter.action||'').toLowerCase();
if(action==='list') return list_(e);
return json_({ status: 'error', message: 'Unknown action' }, 400);
}catch(err){ return json_({ status:'error', message: String(err) }, 500); }
}
function doPost(e){
try{
const payload = JSON.parse(e.postData.contents||'{}');
const action = (payload.action||'').toLowerCase();
if(action==='create') return create_(payload);
return json_({ status: 'error', message: 'Unknown action' }, 400);
}catch(err){ return json_({ status:'error', message: String(err) }, 500); }
}
const SHEET_NAME = 'PrayerSignups';
function getSheet_(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sh = ss.getSheetByName(SHEET_NAME) || ss.insertSheet(SHEET_NAME);
if(sh.getLastRow()===0){
sh.appendRow(['date','org','name','email','notes','ts']);
}
return sh;
}
function list_(e){
const year = Number(e.parameter.year);
const month = Number(e.parameter.month); // 1‑12
if(!year || !month) return json_({ status:'error', message:'Missing year/month' }, 400);
const sh = getSheet_();
const values = sh.getDataRange().getValues();
const out = [];
for(let i=1;i
