> For the complete documentation index, see [llms.txt](https://docs.buzzy.buzz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.buzzy.buzz/the-building-blocks/datatables-fields-and-data.md).

# Datatables, Fields & Data

Datatables are the data backbone of a Buzzy app. They store records, define fields, model relationships, control row and field access, and give screens something concrete to display or edit.

A new user can think of the data model this way:

* **Datatables** are the main record types in the app, such as Property, Booking, Guest, Care Plan, Task, Ticket, Product, Invoice, or Review.
* **Rows** are individual records in a datatable.
* **Fields** define what each row stores, such as text, numbers, dates, locations, images, files, selections, links, sub-tables, viewers, or Private Data.
* **Relationships** connect records through sub-tables and linked-table fields.
* **Access settings** decide who can view rows, add rows, delete rows, see fields, edit fields, or reveal Private Data.
* **Screens** use datatables to render views, forms, filters, details, dashboards, maps, calendars, widgets, and actions.

**New to Buzzy's datamodel?** Start with our [Buzzy Datamodel Overview](/the-building-blocks/datatables-fields-and-data/buzzy-datamodel-overview.md) for a comprehensive guide to understanding relationships, fields, and how to work with data programmatically.

Please note - Datatables were previously called "Microapps" - some code snippets may still refer to a microapp (e.g. the API end-point `microappdata`). If in doubt, email support.

### Table of contents

Start with the overview pages, then use the field-type sections as references when you need a specific behavior.

* [Buzzy Datamodel Overview](/the-building-blocks/datatables-fields-and-data/buzzy-datamodel-overview.md) - **Start here for a comprehensive guide**
* [Introduction to Fields](/the-building-blocks/datatables-fields-and-data/introduction-to-fields.md)
* [Basic Fields](/the-building-blocks/datatables-fields-and-data/basic-fields.md)
* [Advanced Fields](/the-building-blocks/datatables-fields-and-data/advanced-fields.md)
* [Display Fields](/the-building-blocks/datatables-fields-and-data/display-fields.md)
* [Metadata Fields](/the-building-blocks/datatables-fields-and-data/metadata-fields.md)
* [Filter Controls](/the-building-blocks/datatables-fields-and-data/filter-controls.md)
* [External Fields](/the-building-blocks/datatables-fields-and-data/external-fields.md)
* [Sort Fields](/the-building-blocks/datatables-fields-and-data/sort-fields.md)
* [Formula language](/the-building-blocks/datatables-fields-and-data/formulas.md)
* [Datatable to Datatable Relationship](/the-building-blocks/datatables-fields-and-data/datatable-to-datatable-relationships.md)
* [Security and Access Control](/the-building-blocks/datatables-fields-and-data/security-and-access-control.md)
* [Display Formula](/the-building-blocks/datatables-fields-and-data/display-formula.md)
* [Hiding a field based on role using a display formula](/the-building-blocks/datatables-fields-and-data/hiding-a-field-based-on-role-using-a-display-formula.md)
* [In-App Debugging](/troubleshooting/in-app-debugging.md)
* [Examples by Use Case](/the-building-blocks/examples.md)

***