Skip to main content

πŸ“ Lesson 7.3: Notion Forms β€” Collect Data into a Database

So far your databases have been filled by you, typing. But what if other people could add rows for you β€” cleanly, in exactly the shape you want β€” without ever touching your workspace? That's Notion Forms. You share a friendly link, someone fills it in, and their answers appear as a brand-new row in your database. In this lesson you'll build one and watch a test submission land.

πŸ“š What You'll Learn

By the end of this lesson, you will be able to:

  • Explain how a Notion Form connects to a database so each submission becomes a row
  • Create a form (from a database or standalone) and add questions that map to properties
  • Set required fields, a confirmation message, and share the form link (including pre-filling)
  • View and manage responses right inside the connected database
  • Describe honestly where the Free limits sit and when a Paid plan raises them

⏱️ Estimated Time: 45 minutes

🎯 Project: Build a working form (a "quick capture" or "request" form) that feeds a database, submit a test entry, and see it appear as a new row.

In This Lesson

The Big Idea: Form β†’ Row

Here's the whole concept in one sentence: a Notion Form is a friendly front door to a database. Visitors see clean questions; you get structured data.

Think of the database as a restaurant kitchen and the form as the order slip. The customer never walks into the kitchen β€” they fill out a simple slip ("burger, no onions, table 4"), and it appears in the kitchen as a perfectly formatted ticket. Notion Forms works exactly like that: each question on the form corresponds to a property (column) in the database, and each submission creates a new row with those values filled in.

graph LR A["πŸ“ Someone fills
your form"] --> B["Answers map to
database properties"] B --> C["πŸ—‚οΈ A new row appears
in your database"] C --> D["You sort, filter &
work with it like any row"]

πŸ“– Definition

Notion Form: A shareable form, tied to a database, whose questions correspond to the database's properties. Every submission adds one new row (which is a page) to that database, with the answers filled into the matching properties.

Why this is powerful: you already know how to work with database rows β€” sort, filter, group, view as a board or calendar. Forms just give you a clean, no-training way for other people (or future-you on your phone) to create those rows. Intake requests, event RSVPs, feedback, bug reports, a quick capture inbox β€” all of them are "add a row to a database," and a form is the nicest way to do it.

🧠 Mindset

If "make a form" sounds like a whole new skill, relax β€” you already did the hard part when you built your database in Module 3. A form is just a prettier face on properties you already understand. If you can picture the columns you want filled, you can build the form in a few minutes.

πŸ› οΈ Creating a Form & Its Questions

There are two natural ways to start, and they end up in the same place:

  • From an existing database β€” add a new Form view (alongside your Table, Board, Calendar views). Its questions line up with the database's existing properties.
  • Standalone / new β€” create a form directly (via /form or the Forms area); Notion creates a matching database behind it to hold the responses.

Here's what the form builder looks like β€” you're essentially arranging questions, each backed by a property:

Book Request Β· Form
πŸ“š Request a Book
Title Text   Required
Author Text
Format Select   Print Β· eBook Β· Audio
Needed by Date
Your email Email   Required
βž• Add question

Each row here is a question. Notice each one carries a property type pill β€” that type decides how the answer is captured and stored.

Building the questions

  1. Give the form a clear title and a short intro line so people know what it's for.
  2. Add a question per piece of information you need. Keep it short β€” every extra field lowers completion.
  3. For each question, pick the property type (text, select, date, etc.) and a clear label.
  4. Mark the essentials as required so you never get a submission missing the one thing you actually needed.

πŸ’‘ Keep it short

The single biggest factor in whether people finish a form is its length. Ask for what you truly need and nothing more. You can always follow up. A 3-question form gets filled; a 15-question form gets abandoned.

πŸ”— Question Types Map to Properties

This is the concept that makes Forms click: a form question is a database property, wearing an input control. Choosing the right property type gives you clean, filterable data instead of a mess of free text.

You want to collect… Property type What the person sees
A name or short phrase Text A one-line text box
A longer message Text (long) A bigger box for paragraphs
One choice from a list Select Pick one option
Several choices Multi-select Tick multiple options
A date or deadline Date A date picker
A quantity or rating Number A number field
An email / link / phone Email / URL / Phone Validated fields for that data
A yes/no Checkbox A single toggle
An attachment Files An upload button

⚠️ Use Select, not free Text, for categories

If you want to sort or filter answers later β€” "show me all the eBook requests" β€” make it a Select, not a text box. Free text gives you "ebook", "e-book", "E book", and "digital" all meaning the same thing, and you'll never filter them cleanly. Structured types are the whole point of collecting into a database instead of an inbox.

Because every answer lands in a real property, everything you learned in Module 3 applies instantly: filter to new requests, sort by date needed, group by status, or flip the responses into a board. The form is just the doorway; your database skills do the rest.

πŸ“€ Sharing, Pre-filling & Confirmation

A form nobody can reach collects nothing. Once it's built, you share a link (and often you can embed it or drop a QR code). Anyone with the link can submit β€” they do not need a Notion account, which is what makes forms great for the outside world.

The confirmation message

Set what people see after they submit β€” a friendly "Thanks, we'll be in touch!" or next-step instructions. It's a small thing that makes your form feel finished and trustworthy. You can also decide whether to let someone submit again.

✨ Pre-filling

Pre-filling lets you send a link with some answers already filled in. It's handy when you know part of the context in advance β€” for example, a link that pre-sets Team = Marketing so everyone from that team submits pre-tagged, without you cleaning it up later. You generate a special pre-filled link and share that instead of the blank one.

πŸ’‘ Pre-fill to save yourself cleanup

If you'll send the same form to several groups, make one pre-filled link per group (each tagging its own category). The submissions arrive already sorted, and you skip the tedious "which team was this from?" step entirely.

⚠️ The form is public β€” the database isn't

Sharing a form link does not expose your database to submitters. They can only add a row through the questions you defined; they can't see other responses or browse your workspace. That separation is exactly why forms are safe to share widely.

πŸ“₯ Viewing Responses & Free vs. Paid

Here's the satisfying part: responses aren't stored in some separate "form results" screen you have to export. They're just rows in your connected database. Open the Table view and every submission is right there, ready to work with.

Title Format Needed by Status
Atomic Habits Audio Mar 20 New
The Pragmatic Programmer Print Apr 2 Ordered

Each row above arrived from a form submission. Add a Status property yourself and you've got a simple request-tracking workflow β€” capture and follow-up in one place.

Because responses are ordinary rows, you can:

  • Add your own properties (like a Status they never see) to manage each submission.
  • Filter, sort, and group them β€” e.g. a board grouped by Status.
  • Set up notifications or (in a later lesson) automations so a new submission pings you.

πŸ’³ Free vs. paid β€” honestly

Basic forms are available to everyone and are genuinely useful on the Free plan Free. Where limits and extras come in β€” described qualitatively, because Notion adjusts these over time:

  • Number of forms and/or responses can be limited on Free, with higher or unlimited allowances on paid plans Paid.
  • Advanced form features (things like removing Notion branding, richer logic/customization, or higher response volumes) tend to sit on paid tiers Business.
  • Exact caps change. Don't trust a specific number from this page β€” check notion.com/product/forms and notion.com/pricing for what's current.

βœ… The bottom line

For a personal capture form or a small team's intake, the free tier is very likely all you need. You only bump into the paid features when you're collecting at real volume or want to strip the Notion branding. Start free, and let an actual limit β€” not a hypothetical one β€” decide when to upgrade.

🎯 Project: Build a Form That Feeds a Database

Let's make a small, real form and watch a submission arrive. A "quick capture" or "request" form is perfect β€” pick whichever you'd actually use.

πŸ‹οΈ Create, share, submit, verify

Objective: A working form whose test submission appears as a new row in a database.

Instructions (about 15 minutes):

  1. (3 min) Create a database (or reuse one) β€” e.g. Requests or Quick Capture. Add a Form view, or create a standalone form.
  2. (4 min) Add 3–4 questions with the right property types: at least one Select and one Date, not all text.
  3. (2 min) Mark 1–2 questions required, and write a friendly confirmation message.
  4. (2 min) Copy the share link. Optional: generate a pre-filled version.
  5. (2 min) Open the link (an incognito window is a great test), fill it in, and submit.
  6. (2 min) Go back to the database's Table view and confirm your test row appeared with the right values.
πŸ’‘ Hint β€” a simple "Quick Capture" form
Quick Capture
- What is it?        β†’ Text        (required)
- Type              β†’ Select      (Idea / Task / Note)
- When?             β†’ Date
- Details           β†’ Text (long)

Four fields, one Select for clean filtering, and you have a phone-friendly inbox that dumps straight into a database.

βœ… Project Completion Checklist

  • A form is connected to a database
  • It has at least one Select and one Date question (not all free text)
  • At least one field is required and there's a confirmation message
  • You submitted a test entry via the shared link
  • The submission appears as a new row in the database with correct values

🎯 Quick Quiz

Question 1: When someone submits a Notion Form, what happens?

Question 2: You want to filter responses by category later ("show all eBook requests"). What should that question's property type be?

Best Practices for Notion Forms

βœ… Do's

  • Keep it short. Ask for what you truly need; short forms get finished.
  • Use structured types. Select/Date/Number for anything you'll filter or sort.
  • Mark essentials required so no submission arrives missing the key field.
  • Test it yourself from a logged-out window before sharing it widely.
  • Add your own management properties (like Status) that submitters never see.

❌ Don'ts

  • Don't make categories free text β€” you'll never filter them cleanly.
  • Don't over-ask. Every extra field lowers completion.
  • Don't assume free is unlimited. Check current form/response limits before a big campaign.
  • Don't forget the confirmation message β€” it's what tells people it worked.

πŸ““ Learning Journal

Keep a learning journal β€” the best place is inside your own Notion. After each lesson, take a few minutes to write down:

  • Key concepts you learned
  • Techniques that clicked for you
  • Questions or confusion points to revisit
  • Ideas you want to try
  • Your progress and feelings about learning this

✍️ This lesson's prompt: What's something you currently collect the hard way β€” over email, chat, or in your head β€” that a form could tidy into a database? Sketch the 3–4 questions you'd ask and which property type each would be.

πŸ“ Lesson Summary

πŸŽ“ Key Takeaways

  • A Notion Form is a friendly front door to a database β€” each submission becomes a new row.
  • Every question maps to a property; choose structured types (Select, Date, Number) for anything you'll filter or sort.
  • Share a link (no account needed to submit), set required fields, a confirmation message, and optionally pre-fill answers.
  • Responses are just rows you manage in the database; basic forms are Free, with higher limits/extras on Paid plans β€” check notion.com/product/forms.

πŸŽ‰ What You've Accomplished

You built a data-collection pipeline β€” the kind of thing people reach for a separate survey tool to do β€” entirely inside Notion, and connected straight to the database skills you already have. A form in, clean rows out. That's a professional-grade capability, and you now own it.

❓ Common Questions at This Stage

Do people need a Notion account to fill out my form?

No. Anyone with the link can submit β€” that's what makes forms perfect for the outside world. They only see the questions you defined; they never enter your workspace or see other responses.

Where do the responses go?

Straight into the connected database as new rows. Open the Table view and each submission is right there, ready to filter, sort, group, or manage with your own added properties (like a Status).

Are forms free? Is there a limit?

Basic forms are available on the Free plan Free and are genuinely useful. There can be limits on the number of forms or responses, with higher allowances and advanced features on paid plans Paid. Caps change over time β€” check notion.com/pricing for the current details.

πŸ”­ Looking Ahead

You've published pages out (Sites) and pulled data in (Forms). Next we step outside the workspace to two companion apps: Notion Calendar and Notion Mail β€” bringing your time and your inbox alongside everything you've built.

βœ… Before the Next Lesson

  • Keep your form's database around β€” you'll appreciate it once we add automations later
  • Have your Google account details handy if you want to try Notion Calendar next lesson
  • Write your Learning Journal entry for this lesson

πŸ“š Additional Resources

🌟 Encouragement for the Journey

You've now got Notion working in both directions β€” sharing out to the world and collecting back in. That's the shape of a real system, not just a notebook. Two more products to meet, and you'll see the full Notion universe. πŸ“