Introducing Formclick Databases: Save Every Form Response as a Record

Today we're launching Formclick Databases.

Until now, every Formclick submission landed in your inbox and your submissions dashboard. That's perfect for a contact form. But many forms collect data you want to work with: job applications you move through stages, event sign-ups you check in, leads you follow up, orders you track. For that, a list of emails isn't enough.

Formclick Databases gives those responses a proper home. Connect a form to a table once, and every new submission is saved there as a structured record you can filter, link, update and export.

What is a Formclick database?

A database is a set of tables, like a lightweight spreadsheet with real field types. Each table has fields (the columns) and records (the rows). You can create as many tables as your plan allows and link them together, so a candidate can belong to a job opening, or an order to a customer.

You don't need to know SQL, and there's nothing to host.

Save form responses to a database

This is the part we're most excited about. In any HTML form's Settings → Database:

1. Under Save responses to, pick Existing database, or choose New database to create one with a table for this form.
2. Map your form fields to table fields. Auto-match pairs most of them for you.
3. Choose how submissions are written:

Mode	What it does
Create new record	Every submission becomes a new record.
Find or update	Updates the record whose match field (say, email) has the same value; creates one if none matches.
Update only	Updates a matching record. Submissions without a match never create records.

Turn on Don't overwrite with empty values if a blank field shouldn't wipe existing data. You can also save submission details such as the date, page URL and sender email into their own fields.

Your original submission is never at risk. Formclick always saves the submission first, exactly as before, then writes the record as a separate step. If that step fails (for example, a value doesn't fit a field), the form's Recent sync results show what happened and you can retry.

What's inside

• 27 field types: text, long text, email, phone, URL, number, currency, percentage, date, date and time, time, checkbox, single and multiple select, rating, attachments, images and more.
• Linked records, lookups and rollups: connect tables and pull or summarise values across them.
• Formulas: calculated fields with familiar functions such as IF, SWITCH, CONCAT, ROUND, SUM, DATEADD and DATETIME_DIFF.
• Filter, sort and search: AND/OR filter groups, relative dates like "past week" and "this month", and search across a whole database.
• CSV import and export: bring in an existing spreadsheet with column mapping, or export any table.
• Record history: see what changed on a record, and who changed it.
• Team roles: give each teammate admin, editor or viewer access per database.
• Automatic fields: auto number, unique ID, created and modified time, and created and modified by.

Start from a template

Not sure how to structure your data? Start from a ready-made database with tables, fields and links already set up: CRM, Project Management, Customer Management, HR & Recruitment, Event Registration, Inventory or Support Tickets. Or start with a blank database and build your own.

Included on every plan

Databases and form-to-database sync are included on every plan, including Free:

	Free	Starter	Pro	Business
Databases	2	5	20	Unlimited
Tables per database	5	20	50	100
Records (all databases)	1,000	10,000	50,000	250,000
File storage	100 MB	2 GB	20 GB	100 GB
CSV rows per import	1,000	10,000	25,000	50,000

See the pricing page for every plan detail.

A few ideas

• Job applications: save each application to a Candidates table linked to Open roles, then track every candidate's status.
• Event registration: collect sign-ups into an Attendees table and use Find or update on email so people who register twice don't create duplicates.
• Lead capture: every enquiry becomes a lead in a CRM table, linked to its company.
• Waitlists and surveys: filter and export responses whenever you need them.

Get started

1. Open Databases in your Formclick dashboard and create a database, blank or from a template.
2. Open a form's Settings → Database and connect it to a table.
3. Send a test submission and watch the record appear.

The Databases documentation covers every option step by step. Read more on the Databases page.

We'd love to hear what you build. If you have questions or ideas, get in touch.