School Maintenance - Multi-User System

🔧 Setting up Google Sheets connection...

🚀 5-Minute Multi-User Setup

Quick Setup Instructions:

Go to sheets.google.com and create a new spreadsheet
Name it "School Maintenance Requests"
In the first row, add these column headers exactly:
ID | Title | Location | Category | Priority | Status | Reporter | Description | Date
Go to Extensions → Apps Script
Delete any existing code and paste the provided script
Click Deploy → New deployment → Web app
Set access to "Anyone" and copy the URL
Paste the URL below and click Connect

Google Apps Script Web App URL

💡 Why Google Sheets?
• FREE - Uses your existing Google account
• Real-time updates - All users see changes instantly
• Familiar interface - Everyone knows Google Sheets
• Easy backup - Data lives in your Google Drive
• No technical skills - Just copy, paste, and go!

📋 Apps Script Code (Copy This):

function doPost(e) {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = JSON.parse(e.postData.contents);
  
  if (data.action === 'create') {
    sheet.appendRow([
      data.id, data.title, data.location, data.category, 
      data.priority, data.status, data.reporter, data.description, data.date
    ]);
    return ContentService.createTextOutput(JSON.stringify({success: true}))
      .setMimeType(ContentService.MimeType.JSON);
  }
  
  if (data.action === 'update') {
    const values = sheet.getDataRange().getValues();
    for (let i = 1; i < values.length; i++) {
      if (values[i][0] == data.id) {
        sheet.getRange(i + 1, 6).setValue(data.status); // Status column
        break;
      }
    }
    return ContentService.createTextOutput(JSON.stringify({success: true}))
      .setMimeType(ContentService.MimeType.JSON);
  }
  
  return ContentService.createTextOutput(JSON.stringify({success: false}))
    .setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  const headers = data[0];
  const rows = data.slice(1);
  
  const result = rows.map(row => {
    const obj = {};
    headers.forEach((header, index) => {
      obj[header.toLowerCase()] = row[index];
    });
    return obj;
  });
  
  return ContentService.createTextOutput(JSON.stringify(result))
    .setMimeType(ContentService.MimeType.JSON);
}

Total Requests

Pending

In Progress

Completed

Recent Activity

Loading maintenance requests...

🏫 School Maintenance Hub

🚀 5-Minute Multi-User Setup

Quick Setup Instructions:

📋 Apps Script Code (Copy This):

Recent Activity

All Maintenance Requests

Submit New Maintenance Request