# Create an online database without coding | 23 field types | BaseTable

> Create databases without coding from your browser: 23 field types (currency, date, selection, attachments, rating, formula, lookup, rollup) and linked tables. Free with BaseTable.

- **Source (source):** https://aistohire.com/basetable-flexible-online-database-154/f/create-online-database-without-coding
- **Platform (platform):** AIstoHire
- **Language (language):** en

## In summary

- Create your database without coding, with 23 field types
- The power of a database with the simplicity of a spreadsheet: you choose the type of each column and BaseTable takes care of the rest.
- True types, not plain text
- Tables that talk to each other
- Formulas you already know how to write

## Create your database without coding, with 23 field types

BaseTable is the database app from AIsToHire: you open the browser, create a base, and write like in a spreadsheet. What changes are the columns. In BaseTable, each field has a true type, and that type decides how the data is written, how it is sorted, how it is filtered, and how it looks on screen. There is no need to create a schema, install anything, or write SQL.

The selector groups types based on what you need to do with the data. For writing: text, long text, URL, email, and phone. For counting: number with the precision you choose, currency with its symbol, percentage, and duration in h:mm format. For classifying: single selection and multiple selection with color tags, checkbox, star rating, and collaborator. For day-to-day use: date with or without time, attachments (images, PDF, Word, Excel, ZIP), and the Vault field, which stores the link to a secure document.

And there are fields that work for you: link to records from another table, lookup to bring a value from the linked table, rollup to sum or count the linked data, formula with more than 50 functions in Excel style, and editor with autocomplete, auto-numbering, and creation and last modification dates that fill in automatically.

Changing your mind costs nothing: you can rename a field, describe it, move it around, or convert it to another compatible type. And if you make a mistake, there’s undo and redo, a change history field by field with who and when, and a trash bin to restore deleted items. You can see everything the app does at https://aistohire.com/basetable-flexible-online-database-154

## What's included

- **True types, not plain text** — an amount can be summed, a date can be sorted by calendar, and a rating can be filtered by stars. The field type does the dirty work for you.
- **Tables that talk to each other** — with the link field, you connect records from two tables, and with lookup and rollup, you bring or summarize their data without duplicating a single row.
- **Formulas you already know how to write** — over 50 Excel-style functions (IF, SUM, DATEDIFF, SWITCH, DATETIME_FORMAT…) with an editor that autocompletes and alerts you if something doesn't add up.
- **Nothing to install or manage** — it's a web app. You log in, create the database, and that's it. No servers, no migrations, and no lines of code.
- **The same data, six views** — as soon as the fields have types, the table can be viewed as a grid, kanban, gallery, calendar, timeline, or form.
- **Correcting is inexpensive** — undo and redo, history per record, comments, and a trash bin to restore deleted databases, tables, or rows.
- **Bring in what you already have** — import an entire Airtable base with its tables, fields, and attachments, or a CSV with a preview before confirming. And export any view to CSV.

## Frequently Asked Questions

### Can I create a database without knowing how to code?

Yes. In BaseTable, you create a base, add a table, and choose the type of each column from a dropdown; there's no need to write SQL, define a schema, or install anything. If you know how to use a spreadsheet, you already know how to use it: you enter data cell by cell and changes are saved automatically.

### What types of fields does BaseTable have?

23 field types, plus the Vault field to store a link to a secure document. The 23 are: text, long text, number, currency, percentage, duration, single selection, multiple selection, date, checkbox, attachments, URL, email, phone, rating, collaborator, link to records, lookup, rollup, formula, auto-increment, creation date, and last modification. Each type comes with its options: decimal precision, currency symbol, date or time format, maximum stars, or rollup aggregation.

### Can I relate two tables to each other like in a relational database?

Yes. The link field to records connects rows from two tables in the same database. From there, a lookup field brings in a value from the linked table and a rollup field summarizes it using COUNT, COUNTA, SUM, AVG, MIN, or MAX. This way, you don't duplicate data: you query it where you need it.

### Can calculations be made like in Excel?

Yes. The formula field supports over 50 Excel-style functions across text, logic, dates, and mathematics (IF, SWITCH, CONCAT, LEFT, SUBSTITUTE, DATEADD, DATEDIFF, DATETIME_FORMAT, ROUND, POWER, AVERAGE…), with operators and references to other fields. The editor autocompletes names and shows the signature of each function.

### What happens if I make a mistake when choosing a field type?

You can edit it: rename it, add a description, change its position, or convert it to another compatible type (for example, from text to URL, or from number to currency). You also have undo and redo, the change history for each record field by field, and a recycle bin from which to restore anything you've deleted.

- [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/create-online-database-without-coding

### Other languages

- `es`: https://aistohire.com/es/basetable-base-datos-flexible-online-154/f/crear-base-de-datos-online-sin-programar
- `fr`: https://aistohire.com/fr/basetable-base-de-donnees-flexible-en-ligne-154/f/creer-une-base-de-donnees-en-ligne-sans-programmer
- `it`: https://aistohire.com/it/basetable-database-flessibile-online-154/f/creare-database-online-senza-programmare
- `pt`: https://aistohire.com/pt/basetable-banco-de-dados-flexivel-online-154/f/criar-base-de-dados-online-sem-programar
- `de`: https://aistohire.com/de/basetable-flexible-online-datenbank-154/f/datenbank-online-erstellen-ohne-programmieren
- `bg`: https://aistohire.com/bg/basetable-onlayn-baza-danni-kato-elektronna-tablitsa-bez-programirane-154/f/sazdavane-na-baza-danni-onlayn-bez-programirane
- `ja`: https://aistohire.com/ja/nokodo-database-spreadsheet-154/f/puroguramingu-fuyo-database-online-sakusei
- `nl`: https://aistohire.com/nl/basetable-online-database-als-spreadsheet-zonder-code-154/f/online-database-maken-zonder-programmeren
- `ko`: https://aistohire.com/ko/basetable-nocode-database-spreadsheet-154/f/coding-eopsi-online-database-mandeulgi
- `sv`: https://aistohire.com/sv/basetable-databas-online-i-kalkylbladsstil-utan-kod-154/f/skapa-databas-online-utan-kod
- `da`: https://aistohire.com/da/basetable-online-database-som-et-regneark-uden-kode-154/f/opret-database-online-uden-kode
- `ar`: https://aistohire.com/ar/basetable-qaada-bianat-aunlain-shbiha-bjdul-albianat-dun-brmja-154/f/create-online-database-no-code
- `no`: https://aistohire.com/no/basetable-database-pa-nett-i-regnearkstil-uten-koding-154/f/lage-database-pa-nett-uten-programmering
- `fi`: https://aistohire.com/fi/basetable-taulukkolaskennan-kaltainen-tietokanta-netissa-ilman-koodausta-154/f/luo-tietokanta-verkossa-ilman-koodausta
- `zh`: https://aistohire.com/zh/basetable-no-code-spreadsheet-database-154/f/build-online-database-no-code
- `pl`: https://aistohire.com/pl/basetable-baza-danych-online-jak-arkusz-bez-programowania-154/f/baza-danych-online-bez-programowania
- `he`: https://aistohire.com/he/basetable-msd-ntonim-aonliin-bsgnon-gilion-bli-tknot-154/f/yetzirat-masad-netunim-online-bli-tichnut
- `cs`: https://aistohire.com/cs/basetable-online-databaze-ve-stylu-tabulky-bez-programovani-154/f/vytvorit-online-databazi-bez-programovani
- `id`: https://aistohire.com/id/basetable-basis-data-online-seperti-lembar-kerja-tanpa-coding-154/f/buat-database-online-tanpa-coding
