Loading responses...
JSON definition · shared/definitions/dashboard.json
View on GitHub
{
"title": "Product feedback",
"elements": [
{
"type": "rating",
"name": "satisfaction",
"title": "How satisfied are you with the product?",
"rateMin": 1,
"rateMax": 5
},
{
"type": "rating",
"name": "recommend",
"title": "How likely are you to recommend us?",
"rateMin": 0,
"rateMax": 10
},
{
"type": "radiogroup",
"name": "channel",
"title": "Where did you hear about us?",
"choices": [
"Search",
"Social media",
"A colleague",
"Conference"
]
},
{
"type": "checkbox",
"name": "features",
"title": "Which features do you use?",
"choices": [
"Forms",
"Dashboard",
"Creator",
"PDF export"
]
},
{
"type": "comment",
"name": "improve",
"title": "What should we improve?"
}
]
}
Client · shared/client/dashboard.js · sjs:dashboard.client
View on GitHub
// Load answers with their submission dates for Dashboard's built-in date filter
async function loadResults(signal) {
const query = new URLSearchParams({ formId: "feedback", includeCreatedAt: "1", limit: "5000" });
const [definition, response] = await Promise.all([
loadSchema(), fetch(`/api/responses?${query}`, { signal })
]);
if (!response.ok) throw new Error("Responses load failed");
const data = await response.json();
if (!Array.isArray(data)) throw new Error("Invalid responses");
return { definition, data: data.map(row => ({ ...row.data, createdAt: row.createdAt })) };
}
function renderResults(definition, data) {
if (!dashboard) {
const survey = new Model(definition);
dashboard = new Dashboard({
questions: survey.getAllQuestions(), data,
dateFieldName: "createdAt", datePeriod: "last30days"
});
dashboard.render(container);
} else {
dashboard.updateData(data);
}
}
Server · app/routes/dashboard.py · sjs:dashboard.server
View on GitHub
# GET /api/responses?formId=&includeCreatedAt=&from=&to=&limit=&offset=
@router.get("/api/responses")
def responses(
db: Db,
form_id: Annotated[str, Query(alias="formId")] = "",
include_created_at: Annotated[bool, Query(alias="includeCreatedAt")] = False,
since: Annotated[str, Query(alias="from")] = "1970-01-01",
to: str = "",
limit: int = 500,
offset: int = 0,
) -> Response:
rows = db.execute( # ISO 8601 UTC strings compare as dates; `to` includes that whole day
"SELECT data, created_at FROM responses WHERE form_id = ? AND created_at >= ?"
" AND (? = '' OR substr(created_at, 1, 10) <= ?) ORDER BY created_at, id LIMIT ? OFFSET ?",
(form_id, since, to, to, min(max(limit, 1), 5000), max(offset, 0)), # page on the server for large volumes
).fetchall()
# Include submission dates separately when requested by Dashboard
if include_created_at:
return JSONResponse([{"data": json.loads(row["data"]), "createdAt": row["created_at"]} for row in rows])
return Response("[" + ",".join(row["data"] for row in rows) + "]", media_type="application/json") # as stored