# Create a form that saves to your database | BaseTable

> Design a form based on any table: choose the fields, the required ones, the help texts, and the confirmation message. Each submission enters as a record. Free with BaseTable.

- **Source (source):** https://aistohire.com/basetable-flexible-online-database-154/f/form-that-saves-to-your-database
- **Platform (platform):** AIstoHire
- **Language (language):** en

## In summary

- Forms to capture data that goes directly into your database
- Design a form for any table: you choose what to ask, what is mandatory, and what message the sender sees. Each response is saved as an additional record.
- One form per view, not one per table
- Real required fields
- Field-by-field help texts

## Forms to capture data that goes directly into your database

BaseTable is AIsToHire's no-code database app, and in it, the form is not a separate tool: it is one of the six types of views a table can have. You create a Form view and have, over those same records, a registration screen with the questions you decide.

In Design mode, you choose what to ask and how. Each field in the table can be shown or hidden, marked as mandatory, have its own help text, and be moved up or down. At the top, you place the title and a description, and at the bottom, the text of the submit button and the confirmation message that the person filling it out will see. Calculated fields (formulas, lookup, rollup, auto-numbering, creation and modification dates) are not asked: the app fills them in.

In Fill mode, the form works for real, with the same editors as the rest of the app: selections with their colors, dates, ratings, attachments, durations, amounts, collaborators, or records linked to another table. Upon submission, BaseTable checks the mandatory fields, creates the record in the table, and displays your confirmation message with a button to submit another response, which is convenient when multiple entries need to be made in succession.

This record is born already within your database, so it appears instantly in the other views: in the grid to complete it, in the kanban by status to move it, or in the calendar if it has a date, with the filters and colors you already have set up. And if the person filling it out should not see the entire table, you invite them to the database and give them access only to the form view. You have BaseTable at https://aistohire.com/basetable-flexible-online-database-154

## What's included

- **One form per view, not one per table** — you can have multiple form views on the same table, each with its own fields and texts, for quick entries and complete ones.
- **Real required fields** — mark those that cannot be left empty, and the form won't allow submission until they are filled, highlighting the missing one in red.
- **Field-by-field help texts** — a line under each question to explain the format or provide an example, so you don't receive incomplete responses.
- **Hide what shouldn't be asked** — internal fields (status, responsible, notes, priority) are excluded from the form, and you fill them in later in the grid.
- **Title, description, button, and confirmation in your words** — the form appears as you wish, and upon submission, it shows your message, not a generic one.
- **All 23 field types with their real editor** — long text, number, currency, percentage, duration, date, single or multiple selection with colors, checkbox, rating, attachments, URL, email, phone, collaborator, and linked records.
- **Each submission is a record, not an email** — the response enters the table and is instantly visible in the grid, kanban, gallery, or calendar, ready for you to work with.
- **Fair access for the person filling it out** — you invite that person to the base with a one-time invitation link and allow them to see only that form view and the fields you choose.

## Frequently Asked Questions

### How do I create a form to add records to a table?

In BaseTable, you add a new view of type Form to the table, and it's ready: the form is automatically generated with the fields from that table. Then, in Design mode, you decide which fields are required, the order they appear in, what help text each one has, and what title, description, button, and confirmation message are displayed. No programming is needed, and you don't have to create a separate table for responses.

### Can I mark required fields and add help texts?

Yes. Each field in the form has a required switch and a help text field that appears below the question. If someone tries to submit with a required field empty, BaseTable will not allow it: it will alert and highlight in red the missing fields. You can also hide fields from the form that you don't want to ask, and calculated fields (formula, lookup, rollup, auto-numbering, creation date) are never requested because the app fills them in.

### Where do the form responses go?

Directly to the table where the form is located: each submission creates a new record with the filled values. There is no intermediate inbox or export to do. You can see that record in the other views of the table (grid, kanban, gallery, calendar, timeline) with its filters, groupings, and colors, and you can continue to complete it, comment on it, or change its status.

### Can someone fill out the form who should not see the rest of the table?

Yes. BaseTable shares bases with granular permissions: you invite that person from your collaborator directory with a one-time invitation link, and when granting access, you choose which tables they can see, which views of each table, and which fields they can edit, view, or hide. If you only give them the form view, that's all they will see upon entering. However, they need an account on the platform: access is tied to their invitation.

### Can the form be published as an open link or embedded in my website?

Not today. The BaseTable form exists within the app: it is filled out by anyone who has access to the base, whether that’s you or a person you have invited and can limit access to that single view. There is still no public link for anyone or code to embed it in a website, and anonymous submissions do not exist. If what you collect comes from outside, the method that works today is importing those responses into the table in CSV, which BaseTable supports with a preview before confirming.

- [BaseTable — Flexible spreadsheet-style database](https://aistohire.com/basetable-flexible-online-database-154)

## About the platform

**BaseTable — Flexible spreadsheet-style database** — an app by AIstoHire. Available at: https://aistohire.com/basetable-flexible-online-database-154/f/form-that-saves-to-your-database

### Other languages

- `es`: https://aistohire.com/es/basetable-base-datos-flexible-online-154/f/formulario-que-guarda-en-tu-base-de-datos
- `fr`: https://aistohire.com/fr/basetable-base-de-donnees-flexible-en-ligne-154/f/formulaire-qui-enregistre-dans-ta-base-de-donnees
- `it`: https://aistohire.com/it/basetable-database-flessibile-online-154/f/modulo-che-salva-nel-tuo-database
- `pt`: https://aistohire.com/pt/basetable-banco-de-dados-flexivel-online-154/f/formulario-que-salva-em-seu-banco-de-dados
- `de`: https://aistohire.com/de/basetable-flexible-online-datenbank-154/f/formular-das-in-deiner-datenbank-speichert
- `bg`: https://aistohire.com/bg/basetable-onlayn-baza-danni-kato-elektronna-tablitsa-bez-programirane-154/f/formulyar-koyto-zapisva-v-bazata-danni
- `ja`: https://aistohire.com/ja/nokodo-database-spreadsheet-154/f/database-ni-hozon-suru-form-sakusei
- `nl`: https://aistohire.com/nl/basetable-online-database-als-spreadsheet-zonder-code-154/f/formulier-dat-opslaat-in-je-database
- `ko`: https://aistohire.com/ko/basetable-nocode-database-spreadsheet-154/f/database-e-jeojangdoeneun-form-mandeulgi
- `sv`: https://aistohire.com/sv/basetable-databas-online-i-kalkylbladsstil-utan-kod-154/f/formular-som-sparar-i-din-databas
- `da`: https://aistohire.com/da/basetable-online-database-som-et-regneark-uden-kode-154/f/formular-der-gemmer-i-din-database
- `ar`: https://aistohire.com/ar/basetable-qaada-bianat-aunlain-shbiha-bjdul-albianat-dun-brmja-154/f/form-that-saves-to-your-database
- `no`: https://aistohire.com/no/basetable-database-pa-nett-i-regnearkstil-uten-koding-154/f/skjema-som-lagrer-i-databasen-din
- `fi`: https://aistohire.com/fi/basetable-taulukkolaskennan-kaltainen-tietokanta-netissa-ilman-koodausta-154/f/lomake-joka-tallentaa-tietokantaasi
- `zh`: https://aistohire.com/zh/basetable-no-code-spreadsheet-database-154/f/online-form-saves-to-database
- `pl`: https://aistohire.com/pl/basetable-baza-danych-online-jak-arkusz-bez-programowania-154/f/formularz-zapisujacy-do-bazy-danych
- `he`: https://aistohire.com/he/basetable-msd-ntonim-aonliin-bsgnon-gilion-bli-tknot-154/f/tofes-sheshomer-bamasad-netunim-shelcha
- `cs`: https://aistohire.com/cs/basetable-online-databaze-ve-stylu-tabulky-bez-programovani-154/f/formular-ktery-uklada-do-vasi-databaze
- `id`: https://aistohire.com/id/basetable-basis-data-online-seperti-lembar-kerja-tanpa-coding-154/f/formulir-yang-menyimpan-ke-database-anda
