chriscooning/formant / .cursor/skills/formant
formant
VerifiedGenerate interactive HTML forms from natural language. Use when the user wants to create a form, survey, questionnaire, registration page, or feedback form. Also use when mentioning Formant, form schemas, or form building.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 11.8 KB |
| schema-reference.md | markdown | 24.3 KB |
| templates/admin-local.html | other | 26.8 KB |
| templates/responses-dashboard.html | other | 20.3 KB |
templates/responses-dashboard.html
View on GitHub<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>{{FORM_TITLE}} — Responses</title>
<style>
* { box-sizing: border-box; }
body { font-family: system-ui, sans-serif; margin: 1rem; max-width: 1200px; }
h1 { font-size: 1.25rem; margin-bottom: 0.5rem; }
.auth { display: flex; gap: 0.5rem; margin-bottom: 1rem; align-items: center; }
.auth input { flex: 1; max-width: 400px; padding: 0.5rem; }
.auth button { padding: 0.5rem 1rem; cursor: pointer; }
.tabs { display: flex; gap: 0.25rem; margin-bottom: 1rem; }
.tabs button { padding: 0.5rem 1rem; cursor: pointer; border: 1px solid #ccc; background: #f5f5f5; }
.tabs button.active { background: #fff; border-bottom-color: #fff; margin-bottom: -1px; }
.partial-filters { margin-bottom: 0.5rem; }
.partial-filters select { padding: 0.25rem 0.5rem; }
.actions { margin-bottom: 1rem; }
.actions button { margin-right: 0.5rem; padding: 0.5rem 1rem; cursor: pointer; }
table { border-collapse: collapse; width: 100%; font-size: 0.875rem; }
th, td { border: 1px solid #ccc; padding: 0.5rem; text-align: left; }
th { background: #f5f5f5; }
.error { color: #c00; margin: 0.5rem 0; }
.meta { color: #666; font-size: 0.875rem; margin-bottom: 1rem; }
.analytics { margin-bottom: 1.5rem; }
.analytics-range { display: flex; gap: 0.25rem; margin-bottom: 0.75rem; }
.analytics-range button { padding: 0.35rem 0.75rem; cursor: pointer; border: 1px solid #ccc; background: #f5f5f5; font-size: 0.875rem; }
.analytics-range button.active { background: #e0e8f0; border-color: #4a6fa5; }
.analytics-chart-wrap { margin-bottom: 1rem; max-width: 800px; height: 200px; }
.analytics-cards { display: grid; grid-template-columns: repeat(4, 1fr); gap: 0.75rem; margin-bottom: 1rem; }
@media (max-width: 640px) { .analytics-cards { grid-template-columns: repeat(2, 1fr); } }
.analytics-card { border: 1px solid #ccc; padding: 0.75rem; background: #fafafa; }
.analytics-card .label { font-size: 0.75rem; color: #666; margin-bottom: 0.25rem; }
.analytics-card .value { font-size: 1.25rem; font-weight: 600; }
.analytics-dropoff { font-size: 0.875rem; color: #555; margin-bottom: 0.5rem; }
.sheets-connect { margin-bottom: 1rem; padding: 0.75rem; border: 1px solid #ccc; background: #fafafa; }
.sheets-connect button { padding: 0.5rem 1rem; cursor: pointer; }
.sheets-connect .connected { color: #16a34a; }
.sheets-connect .sheets-link { margin-left: 0.5rem; }
</style>
<script src="https://cdn.jsdelivr.net/npm/chart.js@4"></script>
</head>
<body>
<h1>{{FORM_TITLE}} — Responses</h1>
<div class="meta">Form ID: {{FORM_ID}}</div>
<div class="auth">
<input type="password" id="apiKey" placeholder="Paste your API key" autocomplete="off">
<button type="button" id="loadBtn">Load responses</button>
</div>
<div id="sheetsConnectSection" class="sheets-connect" style="display:none;">
<div id="sheetsConnectContent"></div>
</div>
<div id="analyticsSection" class="analytics" style="display:none;">
<div class="analytics-range">
<button type="button" id="range7" class="active">7 days</button>
<button type="button" id="range14">14 days</button>
<button type="button" id="range30">30 days</button>
</div>
<div class="analytics-chart-wrap">
<canvas id="analyticsChart"></canvas>
</div>
<div class="analytics-cards">
<div class="analytics-card"><div class="label">Total Submissions</div><div class="value" id="cardSubmissions">—</div></div>
<div class="analytics-card"><div class="label">Total Views</div><div class="value" id="cardViews">—</div></div>
<div class="analytics-card"><div class="label">Completion Rate</div><div class="value" id="cardCompletion">—</div></div>
<div class="analytics-card"><div class="label">Avg Completion Time</div><div class="value" id="cardAvgTime">—</div></div>
</div>
<div class="analytics-dropoff" id="dropoffLine"></div>
</div>
<div class="tabs">
<button type="button" id="tabFull" class="active">Full submissions</button>
<button type="button" id="tabPartial">Partial submissions</button>
</div>
<div id="partialFilters" class="partial-filters" style="display:none;">
<label>Filter: </label>
<select id="emailFilter">
<option value="all">All</option>
<option value="with">With email</option>
<option value="without">Without email</option>
</select>
</div>
<div id="error" class="error" style="display:none;"></div>
<div class="actions" id="actions" style="display:none;">
<button type="button" id="exportCsv">Export CSV</button>
<button type="button" id="exportXlsx">Export XLSX</button>
</div>
<script type="application/json" id="schema-json">{{SCHEMA_JSON}}</script>
<div id="tableWrap" style="overflow-x: auto;">
<table id="table">
<thead id="thead"></thead>
<tbody id="tbody"></tbody>
</table>
</div>
<script>
(function() {
const WORKER_URL = "{{WORKER_URL}}";
const FORM_ID = "{{FORM_ID}}";
const CONNECT_SHEETS_DOCS_URL = "{{CONNECT_SHEETS_DOCS_URL}}";
const schemaEl = document.getElementById("schema-json");
const SCHEMA_JSON = schemaEl ? (function(){ try { return JSON.parse(schemaEl.textContent || "{}"); } catch(e){ return {}; } })() : {};
const NON_INPUT_TYPES = new Set(["welcome", "statement", "ending"]);
function getInputFields(schema) {
const fields = schema?.fields;
if (!Array.isArray(fields)) return [];
return fields.filter(f => f && typeof f.type === "string" && !NON_INPUT_TYPES.has(f.type));
}
const columns = getInputFields(SCHEMA_JSON).map(f => ({ id: f.id, title: f.title || f.id }));
function getEmailFieldId(schema) {
const field = schema?.fields?.find(f => f && f.type === "email");
return field?.id ?? null;
}
function hasEmail(answers, emailFieldId) {
if (!emailFieldId) return false;
const val = answers[emailFieldId];
return typeof val === "string" && val.trim().length > 0;
}
const emailFieldId = getEmailFieldId(SCHEMA_JSON);
const apiKeyEl = document.getElementById("apiKey");
const loadBtn = document.getElementById("loadBtn");
const errorEl = document.getElementById("error");
const actionsEl = document.getElementById("actions");
const tabFull = document.getElementById("tabFull");
const tabPartial = document.getElementById("tabPartial");
const partialFilters = document.getElementById("partialFilters");
const emailFilter = document.getElementById("emailFilter");
const thead = document.getElementById("thead");
const tbody = document.getElementById("tbody");
const exportCsvBtn = document.getElementById("exportCsv");
const exportXlsxBtn = document.getElementById("exportXlsx");
const analyticsSection = document.getElementById("analyticsSection");
const range7 = document.getElementById("range7");
const range14 = document.getElementById("range14");
const range30 = document.getElementById("range30");
let currentTab = "full";
let analyticsDays = 7;
let chartInstance = null;
tabFull.addEventListener("click", () => { currentTab = "full"; tabFull.classList.add("active"); tabPartial.classList.remove("active"); partialFilters.style.display = "none"; if (getKey()) loadBtn.click(); });
tabPartial.addEventListener("click", () => { currentTab = "partial"; tabPartial.classList.add("active"); tabFull.classList.remove("active"); partialFilters.style.display = "block"; if (getKey()) loadBtn.click(); });
emailFilter.addEventListener("change", () => { if (getKey()) loadBtn.click(); });
function getKey() {
const k = apiKeyEl.value.trim();
if (k) try { sessionStorage.setItem("formant_api_key", k); } catch (_) {}
return k || (typeof sessionStorage !== "undefined" ? sessionStorage.getItem("formant_api_key") : null) || "";
}
const SHEETS_DB = "formant_sheets_config";
const SHEETS_STORE = "urls";
function openSheetsDB() {
return new Promise((resolve, reject) => {
const req = indexedDB.open(SHEETS_DB, 1);
req.onerror = () => reject(req.error);
req.onsuccess = () => resolve(req.result);
req.onupgradeneeded = (e) => { e.target.result.createObjectStore(SHEETS_STORE, { keyPath: "formId" }); };
});
}
async function getStoredSheetsUrl(formId) {
try {
const db = await openSheetsDB();
return new Promise((resolve) => {
const tx = db.transaction(SHEETS_STORE, "readonly");
const req = tx.objectStore(SHEETS_STORE).get(formId);
req.onsuccess = () => { db.close(); resolve(req.result || null); };
req.onerror = () => { db.close(); resolve(null); };
});
} catch { return null; }
}
async function setStoredSheetsUrl(formId, config) {
const db = await openSheetsDB();
return new Promise((resolve, reject) => {
const tx = db.transaction(SHEETS_STORE, "readwrite");
tx.objectStore(SHEETS_STORE).put({ formId, url: config.url, spreadsheetUrl: config.spreadsheetUrl, connectedAt: config.connectedAt || new Date().toISOString() });
tx.oncomplete = () => { db.close(); resolve(); };
tx.onerror = () => { db.close(); reject(tx.error); };
});
}
async function handleSheetsCallback() {
const hash = (location.hash || "").replace(/^#/, "");
if (!hash) return;
const params = Object.fromEntries(new URLSearchParams(hash));
const url = params.url;
const spreadsheetUrl = params.spreadsheetUrl;
const formId = params.formId;
if (url && formId) {
await setStoredSheetsUrl(formId, { url, spreadsheetUrl });
history.replaceState(null, "", location.pathname);
renderSheetsSection();
}
const err = params.error;
if (err) showError("Connect failed: " + (params.message || err));
}
async function renderSheetsSection() {
const section = document.getElementById("sheetsConnectSection");
const content = document.getElementById("sheetsConnectContent");
if (!WORKER_URL || !WORKER_URL.trim()) { section.style.display = "none"; return; }
const isFile = location.protocol === "file:";
if (isFile) {
section.style.display = "block";
content.innerHTML = '<span class="error">Connect requires the dashboard to be served over HTTPS. Deploy the dashboard or run <code>npx serve forms</code> and open from localhost.</span>';
return;
}
let configured = false;
try {
const statusRes = await fetch(WORKER_URL.replace(/\/$/, "") + "/api/connect-sheets/status");
if (statusRes.ok) {
const statusData = await statusRes.json();
configured = !!statusData.configured;
}
} catch (_) { /* assume not configured on fetch error */ }
section.style.display = "block";
if (!configured) {
const docsLink = CONNECT_SHEETS_DOCS_URL
? '<a href="' + CONNECT_SHEETS_DOCS_URL.replace(/&/g, "&").replace(/"/g, """) + '" target="_blank" rel="noopener">Setup guide</a>'
: "";
content.innerHTML = '<strong>Connect to Google Sheet</strong><p>How to set up: Configure OAuth credentials in Google Cloud, then set secrets via your deployment platform. ' + docsLink + '</p>';
return;
}
const stored = await getStoredSheetsUrl(FORM_ID);
if (stored) {
content.innerHTML = '<span class="connected">Connected.</span><a class="sheets-link" href="' + (stored.spreadsheetUrl || "#") + '" target="_blank" rel="noopener">View in Google Sheet</a>';
} else {
content.innerHTML = '<button type="button" id="connectSheetsBtn">Connect Google Sheet</button>';
document.getElementById("connectSheetsBtn").addEventListener("click", async () => {
try {
const redirectUri = location.origin + location.pathname;
const res = await fetch(WORKER_URL.replace(/\/$/, "") + "/api/connect-sheets/init", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({ redirect_uri: redirectUri, form_id: FORM_ID, schema: SCHEMA_JSON })
});
if (!res.ok) { const j = await res.json().catch(() => ({})); throw new Error(j.error || res.statusText); }
const data = await res.json();
if (data.auth_url) location.href = data.auth_url;
else throw new Error("No auth URL");
} catch (e) { showError("Connect failed: " + (e.message || "Unknown")); }
});
}
}
function showError(msg) {
errorEl.textContent = msg;
errorEl.style.display = msg ? "block" : "none";
}
function buildHeaders(includeLastActivity) {
const cols = columns.map(c => c.title);
if (includeLastActivity) cols.push("Last activity");
cols.push("Submitted At");
return cols;
}
function filterByEmail(responses, filter) {
if (filter === "all" || !emailFieldId) return responses;
if (filter === "with") return responses.filter(r => hasEmail(r.answers, emailFieldId));
return responses.filter(r => !hasEmail(r.answers, emailFieldId));
}
function renderTable(responses, includeLastActivity) {
const headers = buildHeaders(includeLastActivity);
thead.innerHTML = "<tr>" + headers.map(h => "<th>" + escapeHtml(h) + "</th>").join("") + "</tr>";
tbody.innerHTML = responses.map(r => {
const cells = columns.map(c => normalise(r.answers[c.id]));
if (includeLastActivity) cells.push(normalise(r.metadata?.updatedAt));
cells.push(r.submittedAt || "");
return "<tr>" + cells.map(c => "<td>" + escapeHtml(String(c)) + "</td>").join("") + "</tr>";
}).join("");
actionsEl.style.display = responses.length > 0 ? "block" : "none";
}
function normalise(v) {
if (v == null) return "";
if (Array.isArray(v)) return v.map(String).join(", ");
if (typeof v === "boolean") return v ? "Yes" : "No";
return String(v);
}
function escapeHtml(s) {
const d = document.createElement("div");
d.textContent = s;
return d.innerHTML;
}
function formatDuration(seconds) {
if (seconds == null || typeof seconds !== "number" || isNaN(seconds)) return "—";
if (seconds < 60) return Math.round(seconds) + "s";
if (seconds < 3600) {
const m = Math.floor(seconds / 60);
const s = Math.round(seconds % 60);
return s > 0 ? m + "m " + s + "s" : m + "m";
}
const h = Math.floor(seconds / 3600);
const m = Math.floor((seconds % 3600) / 60);
return m > 0 ? h + "h " + m + "m" : h + "h";
}
function formatNum(n) {
if (n == null || typeof n !== "number" || isNaN(n)) return "—";
return n.toLocaleString();
}
async function loadAnalytics() {
const key = getKey();
if (!key || !analyticsSection) return;
analyticsSection.style.display = "block";
document.getElementById("cardSubmissions").textContent = "…";
document.getElementById("cardViews").textContent = "…";
document.getElementById("cardCompletion").textContent = "…";
document.getElementById("cardAvgTime").textContent = "…";
document.getElementById("dropoffLine").textContent = "";
try {
const res = await fetch(WORKER_URL + "/api/responses/" + FORM_ID + "/analytics?days=" + analyticsDays, {
headers: { Authorization: "Bearer " + key }
});
if (res.status === 401 || res.status === 403 || res.status === 404) return;
if (!res.ok) return;
const data = await res.json();
const t = data.totals || {};
document.getElementById("cardSubmissions").textContent = formatNum(t.submissions);
document.getElementById("cardViews").textContent = formatNum(t.views);
if (t.submissions != null && t.submissions === 0) {
document.getElementById("cardCompletion").textContent = "—";
document.getElementById("cardAvgTime").textContent = "—";
document.getElementById("dropoffLine").textContent = "No form completions yet";
} else {
document.getElementById("cardCompletion").textContent =
t.completionRate != null && !isNaN(t.completionRate)
? t.completionRate.toFixed(1) + "%"
: "—";
document.getElementById("cardAvgTime").textContent = formatDuration(t.avgDurationSeconds);
const d = data.highestDropoff;
document.getElementById("dropoffLine").textContent = d
? 'Highest dropoff: "' + escapeHtml(d.fieldTitle) + '" — ' + formatNum(d.count) + " abandoned"
: "No dropoff data yet";
}
const series = data.series || [];
if (chartInstance) chartInstance.destroy();
const ctx = document.getElementById("analyticsChart");
if (ctx && typeof Chart !== "undefined") {
chartInstance = new Chart(ctx, {
type: "line",
data: {
labels: series.map(s => s.date),
datasets: [
{ label: "Views", data: series.map(s => s.views), borderColor: "#2563eb", backgroundColor: "rgba(37,99,235,0.1)", fill: true },
{ label: "Submissions", data: series.map(s => s.submissions), borderColor: "#16a34a", backgroundColor: "rgba(22,163,74,0.1)", fill: true }
]
},
options: {
responsive: true,
maintainAspectRatio: false,
scales: { y: { beginAtZero: true } },
plugins: { legend: { position: "top" } }
}
});
}
} catch (_) {}
}
range7.addEventListener("click", () => { analyticsDays = 7; range7.classList.add("active"); range14.classList.remove("active"); range30.classList.remove("active"); loadAnalytics(); });
range14.addEventListener("click", () => { analyticsDays = 14; range14.classList.add("active"); range7.classList.remove("active"); range30.classList.remove("active"); loadAnalytics(); });
range30.addEventListener("click", () => { analyticsDays = 30; range30.classList.add("active"); range7.classList.remove("active"); range14.classList.remove("active"); loadAnalytics(); });
loadBtn.addEventListener("click", async () => {
const key = getKey();
if (!key) { showError("Enter your API key"); return; }
showError("");
try {
const statusParam = currentTab === "full" ? "?status=completed" : "?status=in_progress";
const res = await fetch(WORKER_URL + "/api/responses/" + FORM_ID + statusParam, {
headers: { Authorization: "Bearer " + key }
});
if (res.status === 401) { showError("Invalid API key"); return; }
if (res.status === 403) { showError("Access denied"); return; }
if (res.status === 404) { showError("Form not found"); return; }
if (!res.ok) { showError("Error " + res.status); return; }
const data = await res.json();
let responses = data.responses || [];
if (currentTab === "partial") responses = filterByEmail(responses, emailFilter.value);
window._responses = responses;
renderTable(responses, currentTab === "partial");
loadAnalytics();
} catch (e) {
showError("Network error: " + (e.message || "Unknown"));
}
});
function downloadBlob(blob, filename) {
const a = document.createElement("a");
a.href = URL.createObjectURL(blob);
a.download = filename;
a.click();
URL.revokeObjectURL(a.href);
}
exportCsvBtn.addEventListener("click", async () => {
const key = getKey();
if (!key) { showError("Enter your API key"); return; }
try {
const res = await fetch(WORKER_URL + "/api/responses/" + FORM_ID + "/csv", {
headers: { Authorization: "Bearer " + key }
});
if (!res.ok) { showError("Export failed: " + res.status); return; }
const blob = await res.blob();
const fn = (res.headers.get("Content-Disposition") || "").match(/filename="?([^";\n]+)"?/);
downloadBlob(blob, fn ? fn[1] : "responses.csv");
} catch (e) {
showError("Export error: " + (e.message || "Unknown"));
}
});
exportXlsxBtn.addEventListener("click", async () => {
const key = getKey();
if (!key) { showError("Enter your API key"); return; }
try {
const res = await fetch(WORKER_URL + "/api/responses/" + FORM_ID + "/xlsx", {
headers: { Authorization: "Bearer " + key }
});
if (!res.ok) { showError("Export failed: " + res.status); return; }
const blob = await res.blob();
const fn = (res.headers.get("Content-Disposition") || "").match(/filename="?([^";\n]+)"?/);
downloadBlob(blob, fn ? fn[1] : "responses.xlsx");
} catch (e) {
showError("Export error: " + (e.message || "Unknown"));
}
});
handleSheetsCallback().then(() => renderSheetsSection());
if (getKey()) { loadBtn.click(); }
})();
</script>
</body>
</html>
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |