How to build a daily location opening and closing checklist with automatic manager escalation in Formaloo

A daily opening and closing checklist that any location, clinic, restaurant, or retail store fills out at the start and end of every shift, branching automatically to show only the relevant tasks for that shift type. The moment any item fails or gets missed, the record escalates itself: status flips, a district or regional manager gets an alert email, and a private AI field writes a quick risk read so the manager doesn't have to reconstruct what happened from raw checkbox answers. A portal gives location staff, managers, and leadership their own view of the same data, including a cross-location trend chart and an AI-generated narrative for spotting sites with recurring problems.

This is where the form itself gets built: shift details, the opening and closing task sets, and the exception fields that only apply when something fails. The fastest way to build it is Magic Create, since it can generate all of this from one plain-language prompt.

1. Open Magic Create: From your Formaloo homepage, click Magic Create.

2. Paste this prompt: "Build a daily location opening and closing checklist form. Include a dropdown asking which location this is for, a short text field for the staff member's name, a dropdown asking whether this is an opening or closing shift, and a date field for today's date. For opening shifts, add a yes/no field asking if the cash drawer was counted and verified, a number field for the counted cash amount, a yes/no field asking if all safety and emergency systems were checked, and a yes/no field asking if all scheduled staff clocked in on time. For closing shifts, add a yes/no field asking if the cash drawer was counted and reconciled, a number field for the reconciled cash amount, a yes/no field asking if all equipment and appliances were powered down, a yes/no field asking if all doors, windows, and registers are locked, and a yes/no field asking if the alarm system was armed. Add a yes/no field asking if any checklist item failed or got missed, a long text field to describe the issue, a file upload field for optional photo evidence, and a long text field for any additional notes. Also add these admin-only fields, hidden from whoever fills out the form: a status dropdown with Pending review, Escalated, and Resolved, an assignee field, and a long text field for internal notes."

3. Click Create: Formaloo generates the full form from your prompt.

4. Verify your fields: Your form should look like this. Magic Create will have generated most of it. Verify each field and field ID matches exactly.

5. Save your form: Save your form from the island bar at the top of the editor.

This is what makes the checklist AI-based, not just a list of yes/no answers. An AI Analysis field runs automatically after every submission and stays entirely internal: it reads the failed items, the description, and the photo, and writes a short risk read plus a suggested next action for whoever picks up the escalation.

1. Open the Add field panel: In your form editor, click Add field and look for AI Analysis.

2. Add the field: Click AI Analysis to drop it onto the canvas, and title it "Shift risk read" with field ID ai_shift_risk.

3. Write its prompt: "Review this shift checklist. Shift type: @shift_type. Whether any item failed or was missed: @item_failed. Description of the issue: @issue_description. Photo evidence is attached in @issue_photo if provided. Write a short risk read for the manager reviewing this: state how serious the issue looks based on what failed and what was described, then suggest one concrete next action. Keep it to two or three sentences."

Note: Admin-only is locked on for the AI Analysis field and can't be turned off, so this stays a private read for your team, never something the staff member filling out the checklist sees.

4. Save your form: Save your form from the island bar.

Advanced logic is what makes this one form work for both opening and closing shifts, and what keeps the issue fields out of sight until something actually goes wrong.

1. Open Advanced logic: In the form settings panel on the right side of the editor, open Advanced logic and go to the Logic tab.

2. Click Magic Logic: In the top right corner of the Logic panel, click Magic Logic.

3. Paste this prompt: "Hide these fields by default: Was the cash drawer counted and verified?, What was the counted cash amount?, Were all safety and emergency systems checked?, and Did all scheduled staff clock in on time?. If Is this an opening or closing shift? equals Opening, show all four of those fields. Also hide these fields by default: Was the cash drawer counted and reconciled?, What was the reconciled cash amount?, Were all equipment and appliances powered down?, Are all doors, windows, and registers locked?, and Was the alarm system armed?. If Is this an opening or closing shift? equals Closing, show all five of those fields. Also hide Please describe the issue and Upload photo evidence by default, and require Please describe the issue. If Did any checklist item fail or get missed? equals Yes, show both of those fields."

4. Generate and review: Click Generate Rules. Approve the preview, or redo it if anything looks off.

5. Save: Save your logic from the top right corner of the Logic panel.

6. Add the escalation rule: Still in Advanced logic, go to On Submit and add one more rule: if Did any checklist item fail or get missed? equals Yes, set Status to Escalated.

Two emails run this workflow: one alerts the assigned manager the moment something fails, and one closes the loop once that manager marks the issue resolved.

1. Open the template builder: Click your profile icon, go to Apps and Integrations, find Custom Email Templates, and click Add New Template.

2. Build the escalation alert: Clear the body, add an AI block, and write: "Write a short, urgent, factual internal alert to a district or regional manager. State plainly that a shift checklist at @location just reported a failed or missed item, submitted by @staff_name during the @shift_type shift on @shift_date. Include the risk read from @ai_shift_risk as the core of the message. Tell the manager to review the full record and respond. Keep it under 100 words, this is a notification, not a report." Set the subject to "Escalation: @location shift checklist flagged an issue," name the template, and save it.

3. Send it automatically: Go to Advanced logic → On Submit, add a rule that sends this template to @assignee whenever Did any checklist item fail or get missed? equals Yes.

4. Build the resolution confirmation: Add a new template. Write: "Write a brief, calm confirmation email to the assigned manager confirming that the flagged issue at @location from @shift_date has been marked resolved. Reference the original issue described in @issue_description and note that internal notes contain the resolution details. Tone: factual, closing the loop. Keep it under 80 words." Subject: "Resolved: @location shift checklist issue closed out." Save it.

5. Send it on resolution: Go to On Update, add a rule that sends this template to @assignee whenever Status changes to Resolved.

Every checklist can generate a print-ready PDF record, useful for a district audit or for handing a physical copy to a location manager during a site visit. Here's the full HTML.

1. Open the PDF template builder: Click your profile icon, go to Apps and Integrations, click Custom PDF Template, and click Add New Template.

2. Switch to HTML view: Toggle the editor to HTML.

3. Paste this code:

4. Name and save: Give the template a name like "Daily shift checklist record" and save it.

Note: The reference number uses @rowid, the incremental row ID of the submission, piped directly into the text as "CHK-@rowid." There's no separate field for it, and no @submission_id variable exists.

Four roles need four different views of the same data: location staff submitting checklists, district or regional managers handling their own escalations, operations leadership overseeing every location, and a reporting layer surfacing patterns across all of them. Start a new project from Dashboard so you have an empty canvas to build these pages on.

Page specification table

A daily checklist that runs itself across every location: one form branches by shift type, flags the moment something fails, and gets a manager on it without anyone forwarding an email or making a call. Every escalation carries a private AI risk read next to the raw answers, so a manager can triage in seconds instead of reading a dozen yes/no fields. Location staff, managers, and leadership each open a portal built around exactly what their role needs to see, and leadership gets a bar chart and an AI-written narrative for spotting the location that keeps showing up with the same problem.

Don't build this from scratch, we've already put it together for you.