📊 Ashby Offers Dashboard

\n \n

${stats.rows[0]?.total_offers || 0}

Total Offers

${stats.rows[0]?.accepted || 0}

Accepted

${stats.rows[0]?.declined || 0}

Declined

${stats.rows[0]?.pending || 0}

Pending

\n\n

Recent Offers

\n ${\n offers.rows.length > 0\n ? `\n \n \n \n \n \n \n \n \n \n \n \n \n \n ${\n offers.rows.map((offer) => `\n \n \n \n \n \n \n \n \n \n `).join(\"\")\n }\n \n

Offer ID	Status	Salary	Start Date	Author	Created	Action
${\n offer.id ? offer.id.substring(0, 8) + \"...\" : \"N/A\"\n }	\n ${\n offer.acceptance_status\n ? `\n \n ${offer.acceptance_status}\n \n `\n : \"-\"\n }\n	${\n formatCurrency(offer.salary_currency, offer.salary_value)\n }	${formatDate(offer.start_date)}	${offer.author_name \|\| \"-\"}	${formatDate(offer.created_at)}	\n ${\n offer.id\n ? `View Markdown`\n : \"-\"\n }\n

\n `\n : `\n

No offers received yet. Waiting for webhooks from Ashby...

\n `\n }\n\n

Recent Webhook Activity

\n ${\n recentWebhooks.rows.length > 0\n ? recentWebhooks.rows.map((log) => `\n

\n 📥 ${log.action || \"Unknown\"} - Offer ${\n log.offer_id ? log.offer_id.substring(0, 8) + \"...\" : \"N/A\"\n } - ${formatDate(log.processed_at)}\n

\n `).join(\"\")\n : '

No webhook activity yet

'\n }\n

\n \n \n `;\n\n return html;\n}\n\n// Original markdown generation function\nfunction generateOfferMarkdown(offer: any, latestVersion: any): string {\n const formatCurrency = (salary: any) => {\n if (!salary || !salary.value) return \"Not specified\";\n const formatted = new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency: salary.currencyCode || \"USD\",\n minimumFractionDigits: 0,\n maximumFractionDigits: 0,\n }).format(salary.value);\n return formatted;\n };\n\n const formatDate = (dateString: string) => {\n if (!dateString) return \"Not specified\";\n try {\n return new Date(dateString).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n timeZone: \"UTC\",\n });\n } catch {\n return dateString;\n }\n };\n\n const formatStatus = (status: string) => {\n return status.replace(/([A-Z])/g, \" $1\").trim();\n };\n\n const getCustomField = (fields: any[], title: string) => {\n const field = fields?.find((f) => f.title === title);\n if (!field?.value) return \"Not specified\";\n if (field.value.includes(\"T\") && field.value.includes(\"Z\")) {\n return formatDate(field.value);\n }\n return field.value;\n };\n\n const statusEmoji = {\n \"Accepted\": \"✅\",\n \"Declined\": \"❌\",\n \"Pending\": \"⏳\",\n \"WaitingOnApprovalStart\": \"⏸️\",\n \"Sent\": \"📤\",\n };\n\n const emoji = statusEmoji[offer.acceptanceStatus] || \"📋\";\n\n return `# ${emoji} Offer Details\n\n## 📊 Status Information\n| Field | Value |\n|-------|-------|\n| **Offer ID** | \\`${offer.id}\\` |\n| **Application ID** | \\`${offer.applicationId}\\` |\n| **Acceptance Status** | ${offer.acceptanceStatus} |\n| **Offer Status** | ${formatStatus(offer.offerStatus)} |\n| **Decision Date** | ${\n offer.decidedAt ? formatDate(offer.decidedAt) : \"Pending\"\n } |\n\n## 💼 Offer Terms\n| Field | Value |\n|-------|-------|\n| **Start Date** | ${formatDate(latestVersion.startDate)} |\n| **Salary** | ${formatCurrency(latestVersion.salary)} |\n| **Expected Start Date** | ${\n getCustomField(latestVersion.customFields, \"Expected start date\")\n } |\n| **Opening ID** | \\`${latestVersion.openingId || \"Not specified\"}\\` |\n\n${\n latestVersion.customFields && latestVersion.customFields.length > 0\n ? `\n## 📝 Custom Fields\n| Field | Value |\n|-------|-------|\n${\n latestVersion.customFields.map((field: any) =>\n `| **${field.title}** | ${\n field.title.toLowerCase().includes(\"date\")\n ? formatDate(field.value)\n : field.value\n } |`\n ).join(\"\\n\")\n }\n`\n : \"\"\n }\n\n${\n latestVersion.fileHandles && latestVersion.fileHandles.length > 0\n ? `\n## 📎 Attached Files\n${\n latestVersion.fileHandles.map((file: any) =>\n `- 📄 **${file.name}** (\\`${file.id}\\`)`\n ).join(\"\\n\")\n }\n`\n : \"\"\n }\n\n## 👤 Created By\n| Field | Value |\n|-------|-------|\n| **Name** | ${latestVersion.author.firstName} ${latestVersion.author.lastName} |\n| **Email** | ${latestVersion.author.email} |\n| **Role** | ${latestVersion.author.globalRole} |\n| **Created** | ${formatDate(latestVersion.createdAt)} |\n\n---\n*🤖 Generated from Ashby webhook on ${new Date().toISOString()}*\n`;\n}","deleted","label",[99],"permalink","https://www.val.town/x/mvly/untitled-8271/code/main.ts","extension","actionData","errors"]