What you'll build
By the end of this guide, you'll have a complete scholarship and grant review workflow: a public application form where applicants submit their project details and supporting documents, a scoring form where two committee members independently rate each application, and automated email notifications that confirm submissions, alert your admin team, and deliver acceptance or rejection decisions. You'll also have a PDF export template that turns any application into a clean, branded document — ready for board review or record-keeping.
When to use this
You run a scholarship, grant, or award program that receives multiple applications per cycle and routes them to a review committee
Your current process relies on spreadsheets or email threads, and reviewers end up seeing each other's scores before submitting their own
You need a clear record of each reviewer's score and a calculated total that drives the final decision automatically
You want to send applicants a professional confirmation when they submit and a clear acceptance or rejection email when the decision is made
You're managing the program for a university, foundation, nonprofit, or accelerator and need the entire workflow in one place
Part 1 — Build the scholarship application form
This is where applicants submit their project details, budget, and supporting documents. You'll build one form that captures everything — from contact info to file uploads — and includes hidden admin-only fields your team uses to record the final decision and internal notes.
1. Create a new project: From the Formaloo homepage, click + New project and select Form. This creates a project with one form already attached.
2. Open Magic Create: Inside the form editor, click Magic Create in the top bar. Upload a picture or PDF of your program brief, or describe your form in plain text — for example: "A scholarship application form collecting applicant info, project description, budget, and supporting documents." Hit Create and Formaloo builds the form for you instantly.
3. Check your form fields: Your form should look like this — Magic Create will have generated most of it. Verify each field and field ID matches exactly, as these IDs are used later in email templates and the PDF template.
Field | Type | Field ID | Values / notes |
Full name | Short text |
| Required |
| Required | ||
Organization / institution | Short text |
| Required |
Grant category | Dropdown |
| Academic research / Community development / Arts & culture / Environmental & sustainability / Health & wellbeing / Education & youth / Technology & innovation / Other |
Project title | Short text |
| Required |
Grant name | Short text |
| Required |
Project summary | Long text |
| Required |
Objectives | Long text |
| Required |
Expected impact | Long text |
| Required |
Total amount requested | Number |
| Required |
Budget breakdown | Long text |
| Required |
CV / Resume | File upload |
| Required |
Project proposal | File upload |
| Optional |
Letters of support | File upload |
| Optional |
Application status (admin-only) | Dropdown |
| Under review / Accepted / Rejected — default: Under review |
Award amount (admin-only) | Number |
| Admin-only |
Committee notes (admin-only) | Long text |
| Admin-only |
Part 2 — Add reviewer scoring fields and set up the logic
The scoring fields live in the same form as the application. You'll add reviewer assignee fields, score fields, and a variable that calculates the total automatically — then use Magic Logic to set the acceptance rule.
1. Add the scoring fields to your form: In the form editor, add the following fields and set each field ID exactly as listed:
Field | Type | Field ID |
Reviewer 1 | Assignee |
|
Score 1 | Number (0–100) |
|
Reviewer 2 | Assignee |
|
Score 2 | Number (0–100) |
|
Total | Variable |
|
2. Set up the Total variable: Open the Total field settings and configure it to calculate as score_1 + score_2. This variable updates automatically whenever a reviewer enters or updates their score.
📖 See How to add advanced logic to your form for more on variable fields and calculations.
3. Set up the scoring logic with Magic Logic: In the form settings panel on the right side, click Advanced logic, then navigate to the Logic tab. Click Magic Logic in the top right corner and paste in this prompt:
If Reviewer 1 and Reviewer 2 are filled and Total is greater than 60, set Application status to Accepted. If Reviewer 1 and Reviewer 2 are filled and Total is less than 60, set Application status to Rejected.
Click Generate rules. The AI previews the rules for you — review them, hit Approve, make any manual adjustments if needed, and click Save.
Part 3 — Create the email templates
You need four email templates: a confirmation to the applicant on submission, an alert to your admin team when a new application arrives, and two decision emails — one for accepted applicants, one for those not selected. All templates use answer piping to pull the applicant's details in dynamically.
1. Open the email templates builder: Click your profile icon in the top right → Apps & integrations → Custom email templates → + Add new template.
2. Create Template 1 — applicant submission confirmation: Remove the default content, add an AI box, and paste the prompt below. Set the template name and subject as listed, then save.
Template name: Application received — applicant confirmation
Subject: We received your application, @name
AI prompt: Create a gorgeous HTML email template for a scholarship and grant application system. The email confirms to the applicant that their application was received and is under review. Use a clean, professional design with a header banner, a warm confirmation message, and a summary card showing the applicant's details. Include these piped fields: applicant name (@name), organization (@organization), project title (@project_title), grant name (@grant_name), and amount requested (@requested_amount). End with a note that the review committee will be in touch and a soft branded footer. Color palette: deep navy and gold. Make it mobile-friendly.
3. Create Template 2 — admin new application alert: Click + Add new template and repeat the process with the following details.
Template name: New application submitted — admin notification
Subject: New application: @project_title by @name
AI prompt: Create a gorgeous HTML email template for an internal admin notification. A new scholarship or grant application has been submitted and needs review. Use a clean dashboard-style design with a header, an alert banner saying "New application received", and a structured data card showing: applicant name (@name), email (@email), organization (@organization), project title (@project_title), grant name (@grant_name), grant category (@grant_category), and amount requested (@requested_amount). Add a clear CTA button labeled "Review application". Professional and minimal. Color palette: white with a dark navy header.
4. Create Template 3 — application accepted: Click + Add new template and use the following.
Template name: Application decision — accepted
Subject: Congratulations @name — your application has been accepted
AI prompt: Create a gorgeous HTML email template for a scholarship and grant application system. The email informs the applicant that their application has been accepted. Use a celebratory but professional design with a gold and navy color palette, a congratulations header, a confetti or subtle award icon, and a warm message. Include: applicant name (@name), project title (@project_title), grant name (@grant_name), and award amount (@award_amount). Add a section explaining next steps (our team will contact you shortly with details). End with a branded footer. Mobile-friendly.
5. Create Template 4 — application not selected: Click + Add new template and use the following.
Template name: Application decision — not selected
Subject: An update on your application, @name
AI prompt: Create a gorgeous HTML email template for a scholarship and grant application system. The email informs the applicant that their application was not selected this cycle. Use a warm, empathetic tone — never cold or dismissive. Clean and minimal design with a soft color palette (light grey and navy). Include: applicant name (@name), project title (@project_title), and grant name (@grant_name). Add an encouraging message that they're welcome to apply in future cycles. End with a branded footer. Mobile-friendly. No harsh language anywhere.
Part 4 — Set up email notifications
With your templates ready, you'll now connect them to the form — so emails fire automatically on submission and when a decision is made.
1. Set up submission notifications: Go back to your application form. In the form settings panel on the right, click Notify.
Toggle on Receive email notification, enter your admin email address, and select Template 2 (admin alert) as the custom template.
Click Send email to respondent, toggle it on, and select Template 1 (confirmation) as the template.
Click Publish.
2. Set up conditional decision emails: In the application form, open Advanced logic from the form settings panel on the right → go to On update → click Add rule.
Rule 1: When
application_statusis changed to Accepted → Send email using Template 3 to@email.Rule 2: When
application_statusis changed to Rejected → Send email using Template 4 to@email.
Click Save.
Part 5 — Create the PDF template
The PDF template turns any application submission into a clean, branded document — useful for board review packages or keeping a record of awarded grants. You'll paste the HTML directly into Formaloo's PDF template editor.
1. Open the PDF template builder: Click your profile icon → Apps & integrations → Custom PDF templates → + Add new template.
2. Switch to HTML view: In the template editor, switch the editor mode to HTML view.
3. Paste the template code: Copy and paste the following HTML:
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <style> * { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 13px; color: #1a1a2e; padding: 48px; background: #fff; } .header { border-bottom: 3px solid #1a1a2e; padding-bottom: 20px; margin-bottom: 32px; } .header-label { font-size: 10px; letter-spacing: 2px; text-transform: uppercase; color: #888; margin-bottom: 6px; } .header-title { font-size: 24px; font-weight: 700; color: #1a1a2e; } .header-sub { font-size: 13px; color: #555; margin-top: 4px; } .section { margin-bottom: 28px; } .section-title { font-size: 10px; letter-spacing: 2px; text-transform: uppercase; color: #b8860b; font-weight: 700; border-bottom: 1px solid #e8e0cc; padding-bottom: 6px; margin-bottom: 14px; } .field-row { display: flex; margin-bottom: 10px; } .field-label { width: 180px; min-width: 180px; font-size: 11px; color: #888; font-weight: 600; text-transform: uppercase; letter-spacing: 0.5px; padding-top: 1px; } .field-value { flex: 1; font-size: 13px; color: #1a1a2e; line-height: 1.5; } .badge { display: inline-block; padding: 4px 12px; border-radius: 20px; font-size: 11px; font-weight: 700; letter-spacing: 0.5px; text-transform: uppercase; } .badge-review { background: #f0f4ff; color: #3b5bdb; } .badge-accepted { background: #ebfbee; color: #2f9e44; } .badge-rejected { background: #fff5f5; color: #e03131; } .footer { margin-top: 48px; padding-top: 16px; border-top: 1px solid #e0e0e0; font-size: 10px; color: #aaa; text-align: center; } </style> </head> <body> <div class="header"> <div class="header-label">Application summary</div> <div class="header-title">Scholarship & grant application</div> <div class="header-sub">@grant_name</div> </div> <div class="section"> <div class="section-title">Applicant information</div> <div class="field-row"> <div class="field-label">Full name</div> <div class="field-value">@name</div> </div> <div class="field-row"> <div class="field-label">Email</div> <div class="field-value">@email</div> </div> <div class="field-row"> <div class="field-label">Organization</div> <div class="field-value">@organization</div> </div> <div class="field-row"> <div class="field-label">Grant category</div> <div class="field-value">@grant_category</div> </div> </div> <div class="section"> <div class="section-title">Project details</div> <div class="field-row"> <div class="field-label">Project title</div> <div class="field-value">@project_title</div> </div> <div class="field-row"> <div class="field-label">Project summary</div> <div class="field-value">@project_summary</div> </div> <div class="field-row"> <div class="field-label">Objectives</div> <div class="field-value">@objectives</div> </div> <div class="field-row"> <div class="field-label">Expected impact</div> <div class="field-value">@expected_impact</div> </div> </div> <div class="section"> <div class="section-title">Budget</div> <div class="field-row"> <div class="field-label">Amount requested</div> <div class="field-value">$@requested_amount</div> </div> <div class="field-row"> <div class="field-label">Budget breakdown</div> <div class="field-value">@budget_breakdown</div> </div> </div> <div class="section"> <div class="section-title">Review & decision</div> <div class="field-row"> <div class="field-label">Application status</div> <div class="field-value"> <span class="badge badge-review">@application_status</span> </div> </div> <div class="field-row"> <div class="field-label">Committee notes</div> <div class="field-value">@committee_notes</div> </div> </div> <div class="footer"> This document was generated automatically · @grant_name · @name </div> </body> </html>4. Name and save: Give the template the name Scholarship application summary and click Save.
What you now have
You now have a complete, automated scholarship and grant review workflow. Applicants submit their project details, budget, and documents through a structured form and immediately receive a professional confirmation email. Your admin team gets an instant alert with all the key details. Two reviewers score each application independently on a 0–100 scale, the total is calculated automatically, and the application status updates to Accepted or Rejected based on the score threshold — triggering the right decision email to the applicant without any manual steps. Every application can be exported as a clean PDF for board meetings or archiving.
What's next
Add a portal for applicants and reviewers Give applicants a login page where they can check their application status, and give reviewers a private page showing only the applications assigned to them — no back-and-forth emails needed. → How to create a portal and manage users' access
Let applicants view their own submission status If your program allows applicants to check in on their application after submitting, you can enable a read-only portal view so each person sees only their own record. → How to let users view and edit their own data in your portal
Collect follow-up data from email threads If your review process involves back-and-forth emails with applicants, you can use CC Formaloo to capture that data directly into your form — without asking anyone to fill out another form. → How to use CC Formaloo to collect data from email threads
Ready-to-use templates
Don't build this from scratch — we've already put it together for you.
Scholarship & grant application with scoring and approval workflow, The exact workflow from this guide, ready to use. Includes the application form, reviewer scoring fields, weighted total variable, acceptance logic, four email templates, and a PDF export template. Customize the fields, scoring threshold, and email copy to fit your program in minutes.
Learn more how-tos
Build a student submission and teacher review portal The same multi-reviewer pattern applied to education — students submit work, teachers score independently, and results are tracked in a portal. A close cousin of the scholarship workflow built here. → How to build a student submission and teacher review portal in Formaloo
Build a dual-approval request workflow If your grant program requires two approvers to sign off before a decision is final, this workflow shows you how to chain approval steps with conditional logic and automatic status updates. → How to build a dual-approval request workflow in Formaloo
Turn form responses into proposals and contracts Once a grant is awarded, turn the application data into a formatted grant agreement or award letter — automatically generated from the form submission. → How to turn form responses into proposals and contracts
Ready to build this?
💬 Get help from our concierge team Our team will help you set this up for your specific use case.
📅 Book a demo for Team/Enterprise setup See how teams use Formaloo at scale with advanced permissions and integrations.




