Poly Track Google Sites !!hot!! Instant
<!DOCTYPE html> <html> <head> <base target="_top"> <style> body font-family: Arial; padding: 20px; max-width: 600px; margin: auto; input, select, textarea width: 100%; padding: 8px; margin: 6px 0; button background: #1a73e8; color: white; padding: 10px; border: none; width: 100%; #result margin-top: 20px; </style> </head> <body> <h2>➕ Add Poly Track Item</h2> <form id="polyForm"> <label>Item Name</label><input type="text" id="itemName" required> <label>Category</label><select id="category"><option>Polymer</option><option>Polytechnic</option><option>Polygon</option><option>Other</option></select> <label>Status</label><select id="status"><option>Not Started</option><option>In Progress</option><option>Completed</option></select> <label>Progress (%)</label><input type="number" id="progress" min="0" max="100"> <label>Due Date</label><input type="date" id="dueDate"> <label>Notes</label><textarea id="notes"></textarea> <button type="submit">Add to Poly Track</button> </form> <div id="result"></div> <h3>📊 Live Poly Data</h3> <div id="dataDisplay"></div>
function loadData() google.script.run.withSuccessHandler(function(data) let html = '<table border="1" cellpadding="5"><tr>'; if(data.length > 0) data[0].forEach(h => html += `<th>$h</th>`); html += '</tr>'; for(let i=1; i<data.length; i++) html += '<tr>'; data[i].forEach(cell => html += `<td>$cell</td>`); html += '</tr>'; html += '</table>'; document.getElementById('dataDisplay').innerHTML = html; ).getPolyData();
function doGet() return HtmlService.createHtmlOutputFromFile('PolyTrackForm') .setTitle('Poly Track Manager') .setSandboxMode(HtmlService.SandboxMode.IFRAME); poly track google sites
function getPolyData() const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const data = sheet.getDataRange().getValues(); return data;
Delete default code and paste:
This is a great request. "Poly Track" isn't a standard Google Sites feature, so to build it, you’ll need to combine (for the UI/container) with Google Sheets + Google Apps Script (for the tracking logic).
<script> document.getElementById('polyForm').addEventListener('submit', function(e) e.preventDefault(); google.script.run .withSuccessHandler(function(msg) document.getElementById('result').innerHTML = "<p style='color:green'>✅ " + msg + "</p>"; document.getElementById('polyForm').reset(); loadData(); ) .addPolyItem( document.getElementById('itemName').value, document.getElementById('category').value, document.getElementById('status').value, document.getElementById('progress').value, document.getElementById('dueDate').value, document.getElementById('notes').value ); ); body font-family: Arial
Click File → New → HTML file , name it PolyTrackForm .
