Form Response Competition

{ "edges": [ { "to": "7da3b2b3-4ed6-45fc-b449-f89db55f6255", "from": "06dca842-339b-48e8-b8b3-d4e32133ffe6", "toPort": "0", "fromPort": "0" }, { "to": "79c8f4c6-2185-4c0f-824a-1a4f4d07f4cd", "from": "293d5e4a-abb4-4657-8291-62def169bdd0", "toPort": "0", "fromPort": "0" }, { "to": "9010c1ef-e482-4fb3-9bbe-5b8cc530644c", "from": "eacc15c8-c5f6-4d0f-a294-e8a8e2c4b764", "toPort": "0", "fromPort": "0" }, { "to": "dffed0d2-c867-47e4-b485-7ad7c90cdf99", "from": "79c8f4c6-2185-4c0f-824a-1a4f4d07f4cd", "toPort": "0", "fromPort": "0" }, { "to": "eacc15c8-c5f6-4d0f-a294-e8a8e2c4b764", "from": "7da3b2b3-4ed6-45fc-b449-f89db55f6255", "toPort": "0", "fromPort": "0" }, { "to": "63171447-5c6f-4608-b65d-1a987271af89", "from": "dffed0d2-c867-47e4-b485-7ad7c90cdf99", "toPort": "0", "fromPort": "0" }, { "to": "293d5e4a-abb4-4657-8291-62def169bdd0", "from": "6e2f85d6-bd25-42ed-ade6-0ed783989bc4", "toPort": "0", "fromPort": "0" }, { "to": "6e2f85d6-bd25-42ed-ade6-0ed783989bc4", "from": "9010c1ef-e482-4fb3-9bbe-5b8cc530644c", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "63171447-5c6f-4608-b65d-1a987271af89", "name": "📧 Send Competition Report", "type": "integration", "params": { "sendTo": "={{ $('🚀 Start here!').item.json['Your email address please'] }}", "message": "={{ $json.html }}", "options": {}, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 2416, 1296 ] }, { "id": "293d5e4a-abb4-4657-8291-62def169bdd0", "name": "Get Orgchart Info", "type": "integration", "params": { "nodeId": "={{ $json.orgunits[0] }}", "service": "keephub", "resource": "orgchart", "operation": "run", "__originalType": "n8n-nodes-keephub.keephub" }, "position": [ 1744, 1296 ] }, { "id": "7da3b2b3-4ed6-45fc-b449-f89db55f6255", "name": "Find form submissions by form", "type": "integration", "params": { "options": {}, "service": "keephub", "resource": "formSubmission", "operation": "findByForm", "contentRef": "={{ $json['Form ID (copy from the form URL)'] }}", "__originalType": "n8n-nodes-keephub.keephub", "authentication": "loginCredentials" }, "position": [ 848, 1296 ] }, { "id": "dffed0d2-c867-47e4-b485-7ad7c90cdf99", "name": "📊 Aggregate Stats & Build Report", "type": "code", "params": { "jsCode": "const allItems = $input.all();\n\n// Guard: no submissions — return a helpful empty report\nif (!allItems.length) {\n const d = new Date().toLocaleDateString('en-GB', { day: '2-digit', month: 'short', year: 'numeric' });\n return [{ json: { html: '

No submissions found for this form. Verify the Form ID and ensure the form has at least one response.

', subject: '📊 Competition Report — ' + d + ' — No submissions found' } }];\n}\n\nconst safeNum = v => (v == null || isNaN(Number(v))) ? null : Number(v);\n\nfunction formatDuration(s) {\n if (s == null) return '—';\n s = Math.round(Number(s));\n const d = Math.floor(s / 86400);\n const h = Math.floor((s % 86400) / 3600);\n const m = Math.floor((s % 3600) / 60);\n const sc = s % 60;\n if (d > 0) return `${d}d ${h}h ${m}m`;\n if (h > 0) return `${h}h ${m}m ${sc}s`;\n if (m > 0) return `${m}m ${sc}s`;\n return `${sc}s`;\n}\n\nfunction esc(str) {\n return String(str ?? '')\n .replace(/&/g, '&')\n .replace(//g, '>')\n .replace(/\"/g, '"');\n}\n\nfunction fmtDate(dt) {\n if (!dt) return '—';\n const d = new Date(dt);\n if (isNaN(d.getTime())) return '—';\n return d.toLocaleString('en-GB', {\n day: '2-digit', month: 'short', year: 'numeric',\n hour: '2-digit', minute: '2-digit',\n });\n}\n\nfunction median(nums) {\n const a = nums.filter(n => n != null).map(n => Number(n)).sort((x, y) => x - y);\n if (!a.length) return null;\n const mid = Math.floor(a.length / 2);\n return a.length % 2 ? a[mid] : Math.round((a[mid - 1] + a[mid]) / 2);\n}\n\nfunction avg(nums) {\n const a = nums.filter(n => n != null).map(n => Number(n));\n if (!a.length) return null;\n return Math.round(a.reduce((s, v) => s + v, 0) / a.length);\n}\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Normalize submissions\n// userOrgunit is already a resolved name from 🔗 Enrich with User Data\n// ─────────────────────────────────────────────────────────────────────────────\nconst submissions = allItems.map(i => {\n const j = i.json || {};\n const seconds = safeNum(j.durationSeconds);\n return {\n submissionId: j.submissionId || j._id || null,\n userName: j.userName || 'Unknown',\n userEmail: j.userEmail || '',\n userOrgunit: j.userOrgunit || 'Unknown',\n submittedAt: j.submittedAt || null,\n seconds,\n durationFormatted: j.durationFormatted || formatDuration(seconds),\n };\n});\n\nconst totalSubs = submissions.length;\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Aggregate per participant\n// ─────────────────────────────────────────────────────────────────────────────\nconst participantKey = s =>\n (s.userEmail ? s.userEmail.toLowerCase() : `${s.userName}::${s.userOrgunit}`).toLowerCase();\n\nconst pMap = new Map();\nfor (const s of submissions) {\n const key = participantKey(s);\n if (!pMap.has(key)) {\n pMap.set(key, {\n key,\n name: s.userName,\n email: s.userEmail,\n orgunit: s.userOrgunit,\n submissionsCount: 0,\n bestSeconds: null,\n bestSubmittedAt: null,\n _sum: 0,\n _count: 0,\n });\n }\n const p = pMap.get(key);\n p.submissionsCount++;\n if (s.seconds != null) {\n p._sum += s.seconds;\n p._count += 1;\n if (p.bestSeconds == null || s.seconds < p.bestSeconds) {\n p.bestSeconds = s.seconds;\n p.bestSubmittedAt = s.submittedAt;\n }\n }\n p.name = s.userName || p.name;\n p.orgunit = s.userOrgunit || p.orgunit;\n p.email = s.userEmail || p.email;\n}\n\nconst participants = Array.from(pMap.values()).map(p => ({\n ...p,\n avgSeconds: p._count ? Math.round(p._sum / p._count) : null,\n bestFormatted: formatDuration(p.bestSeconds),\n}));\n\nparticipants.sort((a, b) => {\n if (a.bestSeconds == null && b.bestSeconds == null) return 0;\n if (a.bestSeconds == null) return 1;\n if (b.bestSeconds == null) return -1;\n return a.bestSeconds - b.bestSeconds;\n});\n\nconst participantsCount = participants.length;\nconst fastest = participants[0] || null;\nconst slowest = participants[participants.length - 1] || null;\nconst bestTimes = participants.map(p => p.bestSeconds).filter(v => v != null);\nconst avgBestSeconds = avg(bestTimes);\nconst medianBestSeconds = median(bestTimes);\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Org unit aggregation\n// ─────────────────────────────────────────────────────────────────────────────\nconst ouMap = new Map();\nfor (const p of participants) {\n if (p.bestSeconds == null) continue;\n const ou = p.orgunit || 'Unknown';\n if (!ouMap.has(ou)) ouMap.set(ou, { name: ou, total: 0, count: 0 });\n const d = ouMap.get(ou);\n d.total += p.bestSeconds;\n d.count += 1;\n}\n\nconst orgunits = Array.from(ouMap.values())\n .map(x => ({\n name: x.name,\n avgSeconds: x.count ? Math.round(x.total / x.count) : null,\n avgFormatted: formatDuration(x.count ? Math.round(x.total / x.count) : null),\n count: x.count,\n }))\n .sort((a, b) => (a.avgSeconds ?? 9e15) - (b.avgSeconds ?? 9e15))\n .slice(0, 15);\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Bar chart helpers\n// ─────────────────────────────────────────────────────────────────────────────\nfunction barRow({ left, right, pct, color, muted, emphasis }) {\n const leftTxt = esc(left || '—');\n const rightTxt = esc(right || '—');\n const labelColor = muted ? '#6b7280' : '#111827';\n const rightColor = emphasis ? '#4f46e5' : '#6b7280';\n const weight = emphasis ? '800' : '600';\n const bgFallback = color.includes('linear-gradient') ? 'rgba(99,102,241,0.85)' : color;\n return `\n \n ${leftTxt}\n \n \n \n \n \n

\n \n ${rightTxt}\n \n `;\n}\n\nfunction buildParticipantsBarChart(rows) {\n const max = Math.max(...rows.map(r => r.bestSeconds || 0), 1);\n const body = rows.map((p, i) => barRow({\n left: p.name.length > 22 ? p.name.slice(0, 22) + '…' : p.name,\n right: p.bestFormatted,\n pct: Math.round(((p.bestSeconds || 0) / max) * 100),\n color: i < 3\n ? 'linear-gradient(90deg, rgba(99,102,241,0.95), rgba(139,92,246,0.95))'\n : 'rgba(99,102,241,0.75)',\n muted: false,\n emphasis: i < 3,\n })).join('');\n return `${body}

`;\n}\n\nfunction buildOrgunitBarChart(rows) {\n const max = Math.max(...rows.map(r => r.avgSeconds || 0), 1);\n const body = rows.map((ou, i) => barRow({\n left: ou.name.length > 22 ? ou.name.slice(0, 22) + '…' : ou.name,\n right: `${ou.avgFormatted} · ${ou.count}`,\n pct: Math.round(((ou.avgSeconds || 0) / max) * 100),\n color: i === 0\n ? 'linear-gradient(90deg, rgba(16,185,129,0.95), rgba(52,211,153,0.95))'\n : 'rgba(16,185,129,0.75)',\n muted: true,\n emphasis: i === 0,\n })).join('');\n return `${body}

`;\n}\n\n// ─────────────────────────────────────────────────────────────────────────────\n// Leaderboard rows\n// ─────────────────────────────────────────────────────────────────────────────\nconst medals = ['🥇', '🥈', '🥉'];\nconst top10 = participants.slice(0, 10);\n\nconst leaderboardRows = top10.map((p, idx) => {\n const bg = idx % 2 ? '#f9fafb' : '#ffffff';\n const medal = idx < 3 ? medals[idx] : String(idx + 1);\n return `\n \n ${medal}\n ${esc(p.name)}\n ${esc(p.orgunit)}\n \n ${esc(p.bestFormatted)}\n \n ${fmtDate(p.bestSubmittedAt)}\n ${p.submissionsCount}\n \n `;\n}).join('');\n\n// ─────────────────────────────────────────────────────────────────────────────\n// HTML\n// ─────────────────────────────────────────────────────────────────────────────\n// Reference time label for the report header\nconst formData = $('🚀 Start here!').first().json;\nconst dateRaw = formData['Competition start date (optional)'] || '';\nconst timeRaw = formData['Competition start time (optional)'] || '';\nconst customStartRaw = dateRaw ? (dateRaw + (timeRaw ? 'T' + timeRaw : 'T00:00')) : '';\nconst customStartDt = customStartRaw ? new Date(customStartRaw) : null;\nconst refTimeLabel = (customStartDt && !isNaN(customStartDt.getTime()))\n ? 'from ' + customStartDt.toLocaleString('en-GB', { day: '2-digit', month: 'short', year: 'numeric', hour: '2-digit', minute: '2-digit' })\n : 'from form creation (Keephub default)';\n\nconst weekStr = new Date().toLocaleDateString('en-GB', { day: '2-digit', month: 'short', year: 'numeric' });\nconst fastestNamePlain = fastest?.name || '—';\nconst fastestTimePlain = fastest?.bestSeconds != null ? formatDuration(fastest.bestSeconds) : '—';\nconst safeFastestNameHtml = esc(fastestNamePlain);\nconst safeFastestTimeHtml = esc(fastestTimePlain);\nconst kpiMinHeight = 138;\nconst kpiBottomSpacer = 18;\n\nconst html = `\n\n\n \n \n \n \n Form Response Competition\n\n\n \n \n \n \n

\n \n\n \n \n \n \n\n \n\n \n \n \n \n\n \n\n \n \n \n \n\n \n\n \n ${orgunits.length ? `\n \n \n \n \n ` : ''}\n\n \n \n \n \n\n

\n \n \n \n \n

Competition Report

Form Response Competition

${esc(weekStr)}

Response times measured ${refTimeLabel}

\n \n \n \n \n \n \n

\n \n \n \n \n

Fastest

${safeFastestNameHtml}

${safeFastestTimeHtml}

Best time

\n \n \n \n \n

Participants

${participantsCount}

from ${orgunits.length || 1} org unit${(orgunits.length || 1) === 1 ? '' : 's'}

${totalSubs} total submission${totalSubs === 1 ? '' : 's'}

\n \n \n \n \n

Typical best time

${esc(formatDuration(avgBestSeconds))}

Median: ${esc(formatDuration(medianBestSeconds))}

Slowest: ${esc(formatDuration(slowest?.bestSeconds))}

\n \n \n \n \n \n \n \n \n \n \n

Top performers

Ranked by each participant's best response time

${buildParticipantsBarChart(top10)}

\n \n \n \n \n \n \n \n \n \n ${leaderboardRows}\n

Participant

Org unit

Best

Submitted

Subs

\n \n \n \n \n \n \n \n

Org unit performance

Average of participant best times per org unit

${buildOrgunitBarChart(orgunits)}

\n Generated automatically by n8n · Powered by Keephub\n

\n\n`;\n\n const subject = `📊 Competition Report — ${weekStr} · 🏆 ${fastestNamePlain} in ${fastestTimePlain} · ${participantsCount} participant${participantsCount === 1 ? '' : 's'}`; \n\n return [{ json: { html, subject } }];" }, "position": [ 2192, 1296 ] }, { "id": "79c8f4c6-2185-4c0f-824a-1a4f4d07f4cd", "name": "🔗 Enrich with User Data", "type": "code", "params": { "jsCode": "// Guard: bail out early if no enrichment data available\nconst orgItems = $input.all();\nif (!orgItems.length) return [];\n\nconst userItems = $('Get submitter details for a form submission').all();\nconst durationItems = $('Calculate response duration for a form submission').all();\nconst splitItems = $('✂️ Split into Items').all();\n\n// Check if a custom competition start date/time was provided on the form\nconst formData = $('🚀 Start here!').first().json;\nconst dateRaw = formData['Competition start date (optional)'] || '';\nconst timeRaw = formData['Competition start time (optional)'] || '';\nconst customStartRaw = dateRaw ? (dateRaw + (timeRaw ? 'T' + timeRaw : 'T00:00')) : '';\nconst customStartDate = customStartRaw ? new Date(customStartRaw) : null;\nconst useCustomStart = customStartDate && !isNaN(customStartDate.getTime());\n\n// Direct id -> name map from all orgchart nodes\nconst orgById = new Map();\nfor (const o of orgItems) {\n const n = o.json;\n if (!n?._id) continue;\n const id = String(n._id);\n if (!orgById.has(id)) {\n orgById.set(id, String(n.name || id).trim());\n }\n}\n\nfunction resolveOrgunit(orgunits) {\n if (!Array.isArray(orgunits) || orgunits.length === 0) return 'Unknown';\n // Try each orgunit the user belongs to — return the first one we have a name for\n // Prefer non-root nodes (more specific), so skip root#### if a better match exists\n const nonRoot = orgunits.find(id => !String(id).startsWith('root') && orgById.has(String(id)));\n if (nonRoot) return orgById.get(String(nonRoot));\n const any = orgunits.find(id => orgById.has(String(id)));\n if (any) return orgById.get(String(any));\n return String(orgunits[0]) || 'Unknown';\n}\n\nfunction parseDuration(str) {\n if (!str) return null;\n const d = parseInt(str.match(/(\\d+)d/)?.[1] || 0);\n const h = parseInt(str.match(/(\\d+)h/)?.[1] || 0);\n const m = parseInt(str.match(/(\\d+)m/)?.[1] || 0);\n const s = parseInt(str.match(/(\\d+)s/)?.[1] || 0);\n return d * 86400 + h * 3600 + m * 60 + s;\n}\n\nfunction formatDuration(totalSeconds) {\n if (totalSeconds == null) return '—';\n totalSeconds = Math.round(totalSeconds);\n const d = Math.floor(totalSeconds / 86400);\n const h = Math.floor((totalSeconds % 86400) / 3600);\n const m = Math.floor((totalSeconds % 3600) / 60);\n const s = totalSeconds % 60;\n if (d > 0) return `${d}d ${h}h ${m}m`;\n if (h > 0) return `${h}h ${m}m ${s}s`;\n if (m > 0) return `${m}m ${s}s`;\n return `${s}s`;\n}\n\nconst count = Math.max(userItems.length, durationItems.length, splitItems.length);\nconst results = [];\n\nfor (let i = 0; i < count; i++) {\n const user = userItems[i]?.json || {};\n const dur = durationItems[i]?.json || {};\n const raw = splitItems[i]?.json || {};\n\n const submittedAt = dur.submittedAt || raw.createdAt || null;\n\n let durationSeconds = null;\n let durationStr = null;\n let durationFormatted = null;\n\n if (useCustomStart && submittedAt) {\n // Custom start provided — measure from that moment\n const subDate = new Date(submittedAt);\n if (!isNaN(subDate.getTime())) {\n durationSeconds = Math.max(0, Math.round((subDate.getTime() - customStartDate.getTime()) / 1000));\n }\n } else {\n // No custom start — fall back to Keephub API duration\n durationStr = dur.duration?.timeSinceFormCreated || null;\n durationSeconds = parseDuration(durationStr);\n }\n durationFormatted = formatDuration(durationSeconds);\n\n const fullName =\n user.name ||\n [user.firstName, user.insertion, user.lastName].filter(Boolean).join(' ').trim() ||\n user.loginName ||\n raw.createdBy ||\n 'Unknown';\n\n const userOrgunit = resolveOrgunit(user.orgunits);\n\n results.push({\n json: {\n submissionId: raw._id || null,\n contentRef: raw.contentRef || null,\n submittedAt,\n durationSeconds,\n durationStr,\n durationFormatted,\n userName: fullName,\n userEmail: user.email || '',\n userPosition: user.position || '',\n userLevel: user.level || '',\n userOrgunit,\n }\n });\n}\n\nreturn results;\n" }, "position": [ 1968, 1296 ] }, { "id": "6e2f85d6-bd25-42ed-ade6-0ed783989bc4", "name": "Get submitter details for a form submission", "type": "integration", "params": { "service": "keephub", "resource": "formSubmission", "operation": "getSubmitterDetails", "__originalType": "n8n-nodes-keephub.keephub", "formSubmissionId": "={{ $('✂️ Split into Items').item.json._id }}" }, "position": [ 1520, 1296 ] }, { "id": "9010c1ef-e482-4fb3-9bbe-5b8cc530644c", "name": "Calculate response duration for a form submission", "type": "integration", "params": { "service": "keephub", "resource": "formSubmission", "operation": "calculateResponseDuration", "__originalType": "n8n-nodes-keephub.keephub", "formSubmissionId": "={{ $json._id }}" }, "position": [ 1296, 1296 ] }, { "id": "eacc15c8-c5f6-4d0f-a294-e8a8e2c4b764", "name": "✂️ Split into Items", "type": "code", "params": { "jsCode": "return $input.all().map(item => ({ json: item.json }));" }, "position": [ 1072, 1296 ] }, { "id": "06dca842-339b-48e8-b8b3-d4e32133ffe6", "name": "🚀 Start here!", "type": "trigger", "params": { "kind": "n8n-nodes-base.formTrigger", "options": { "customCss": "@import url('https://fonts.googleapis.com/css2?family=Open+Sans:wght@400;600&display=swap');\n\n* {\n font-family: 'Open Sans', sans-serif;\n box-sizing: border-box;\n}\n\nbody {\n background: #f0eeff;\n margin: 0;\n padding: 0;\n}\n\n.container {\n min-height: 100vh;\n padding: 32px 16px;\n display: flex;\n justify-content: center;\n align-items: flex-start;\n}\n\nsection {\n width: 100%;\n max-width: 448px;\n}\n\n.test-notice {\n background: #fefaf6;\n border: 1px solid #f6dcb7;\n border-radius: 8px;\n padding: 10px 16px;\n margin-bottom: 12px;\n text-align: center;\n}\n\n.test-notice p {\n color: #e6a23d;\n font-size: 12px;\n font-weight: 600;\n margin: 0;\n}\n\nhr {\n border: none;\n border-top: 1px solid #dbdfe7;\n margin: 12px 0;\n}\n\n.card {\n background: #ffffff;\n border-radius: 12px;\n box-shadow: 0px 4px 24px 0px rgba(99, 77, 255, 0.12);\n overflow: hidden;\n margin-bottom: 16px;\n border: none;\n padding: 0;\n}\n\n.form-header {\n background: linear-gradient(135deg, #634dff 0%, #7c3aed 100%);\n padding: 28px 24px;\n margin-bottom: 0;\n border-bottom: none;\n}\n\n.form-header h1 {\n font-size: 22px;\n font-weight: 600;\n color: #ffffff;\n margin: 0 0 8px 0;\n line-height: 1.3;\n}\n\n.form-header p {\n font-size: 13px;\n font-weight: 400;\n color: rgba(255, 255, 255, 0.8);\n margin: 0;\n line-height: 1.6;\n}\n\n.inputs-wrapper {\n padding: 24px 24px 8px 24px;\n}\n\n.form-group {\n margin-bottom: 18px;\n}\n\n.form-label {\n display: block;\n font-size: 13px;\n font-weight: 600;\n color: #525356;\n margin-bottom: 6px;\n}\n\n.form-label.form-required::after {\n content: ' *';\n color: #ff6d5a;\n}\n\n.form-input {\n display: block;\n width: 100%;\n padding: 11px 14px;\n font-size: 14px;\n font-weight: 400;\n color: #525356;\n background: #fbfcfe;\n border: 1px solid #dbdfe7;\n border-radius: 8px;\n outline: none;\n transition: border-color 0.15s ease, box-shadow 0.15s ease;\n}\n\n.form-input:focus {\n border-color: #634dff;\n background: #ffffff;\n box-shadow: 0 0 0 3px rgba(99, 77, 255, 0.1);\n}\n\n.form-input::placeholder {\n color: #a0a3a8;\n}\n\n[class^=\"error-\"] {\n font-size: 12px;\n color: #ea1f30;\n margin: 4px 0 0 0;\n display: none;\n}\n\n[class^=\"error-\"].error-show {\n display: block;\n}\n\n#submit-btn {\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 8px;\n width: calc(100% - 48px);\n margin: 0 24px 24px 24px;\n height: 48px;\n background: #ff6d5a;\n color: #ffffff;\n border: none;\n border-radius: 8px;\n font-size: 14px;\n font-weight: 600;\n cursor: pointer;\n transition: opacity 0.15s ease, transform 0.1s ease;\n}\n\n#submit-btn:hover {\n opacity: 0.9;\n transform: translateY(-1px);\n}\n\n#submit-btn:active {\n opacity: 1;\n transform: translateY(0);\n}\n\n#submit-btn:disabled {\n opacity: 0.6;\n cursor: not-allowed;\n transform: none;\n}\n\n#submit-btn span {\n display: none;\n}\n\n#submit-btn svg {\n fill: #ffffff;\n}\n\n.n8n-link {\n text-align: center;\n margin-top: 16px;\n}\n\n.n8n-link a {\n font-size: 12px;\n color: #7e8186;\n text-decoration: none;\n display: inline-flex;\n align-items: center;\n gap: 6px;\n}\n", "respondWithOptions": { "values": { "formSubmittedText": "Processing... Please check your email shortly!" } } }, "formTitle": "Run a form response time competition with Keephub", "formFields": { "values": [ { "fieldLabel": "Your email address please", "placeholder": "your@email.com", "requiredField": true }, { "fieldLabel": "Form ID (copy from the form URL)", "placeholder": "699848533ab62d9d50409890", "requiredField": true }, { "fieldType": "date", "fieldLabel": "Competition start date (optional)" }, { "fieldLabel": "Competition start time (optional)", "placeholder": "12:35" } ] }, "responseMode": "lastNode", "formDescription": "Enter your email and a Keephub Form ID to receive a detailed competition report.\n\nOptionally provide a competition start date & time — response durations will be measured from that moment. Leave blank to use Keephub’s default (time since form creation).\n\nThe workflow fetches all submissions, calculates response times, enriches each result with org-unit data, and emails you a ranked leaderboard." }, "position": [ 624, 1296 ] } ] }

Gamify Keephub form response times and email a ranked leaderboard via Gmail