> ## Documentation Index
> Fetch the complete documentation index at: https://zite.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Zite Database FAQs

> Common questions about how the database works and its features.

## Getting Started

<AccordionGroup>
  <Accordion title="What is Zite Database?">
    [Zite Database](https://www.zite.com/database) lets you store, organize, and manage data in a centralized place without needing coding knowledge or a developer.
  </Accordion>

  <Accordion title="What can I use Zite Database for?">
    Zite Database is commonly used to manage leads or customers, inventory, projects, tickets, content, and [other business data](https://www.zite.com/blog/what-is-workflow-automation#real-world-use-cases).
  </Accordion>

  <Accordion title="I've only used spreadsheets before. What's the learning curve?">
    If you've used Google Sheets or Excel before, you'll feel right at home. Zite combines the familiarity of spreadsheets with the power of a database.
  </Accordion>

  <Accordion title="What's the difference between a spreadsheet and a database?">
    [Spreadsheets](https://www.fillout.com/blog/database-vs-spreadsheet#what-is-a-spreadsheet) are designed for simple lists and calculations. [Databases](https://www.fillout.com/blog/database-vs-spreadsheet#what-is-a-database) help you organize larger amounts of information, connect related data, and support workflows inside apps.
  </Accordion>
</AccordionGroup>

## Tables, Fields & Records

<AccordionGroup>
  <Accordion title="Can I change the primary field?">
    Yes. Most text-based fields can be set as the primary field. Some field types are not eligible to be used as a primary field. Check [this quick guide](https://www.zite.com/help/database/configure-database/manage-fields#set-a-default-value).
  </Accordion>

  <Accordion title="Can I change a field's type after records already exist?">
    Yes. However, changing a field type may modify or remove data that isn't compatible with the new field type. For example, text values that can't be converted into numbers may be removed when switching to a number field. Check [this quick guide](https://www.zite.com/help/database/configure-database/manage-fields#convert-field-type).
  </Accordion>

  <Accordion title="Can I temporarily remove fields without deleting them?">
    Yes. You can [hide fields](https://www.zite.com/help/database/configure-database/manage-views#hide-fields) to remove them from your current view.
  </Accordion>

  <Accordion title="Where can I find a record's ID?">
    Right-click any cell within a record to view or copy the record ID.
  </Accordion>

  <Accordion title="How do I delete a record?">
    Right-click the record you want to remove and select Delete. You can also bulk-delete multiple records at once. Check out [this quick guide](https://www.zite.com/help/database/manage-data/delete-records).
  </Accordion>

  <Accordion title="I've accidentally deleted records. Can I restore them?">
    Yes. Zite automatically stores database history for up to 7 days on paid plans and up to 1 day on the free plan. Learn more [here](https://www.zite.com/help/database/manage-data/backup-and-restore).
  </Accordion>

  <Accordion title="Why are some records missing?">
    Records may be hidden by filters, sorting, views, permissions, or search criteria. Try clearing any active filters or switching views. Check our [quick troubleshooting steps](https://www.zite.com/help/database/tips/quick-fixes).
  </Accordion>

  <Accordion title="Can I experiment without changing my original data?">
    Yes. You can create testing environments. We recommend using [Views](https://www.zite.com/help/database/configure-database/manage-views) to create different ways of viewing your data without modifying the original records. You can also [create manual backups](https://www.zite.com/help/database/manage-data/backup-and-restore#create-a-backup).
  </Accordion>
</AccordionGroup>

## Permissions

<AccordionGroup>
  <Accordion title="Can multiple people collaborate on the same database?">
    Yes. You can [invite teammates](https://www.zite.com/help/database/access) to view, edit, and manage your database together.
  </Accordion>

  <Accordion title="Can I control who can view or edit data?">
    Yes. You can configure permissions to control who can view, edit, create, or delete records.
  </Accordion>
</AccordionGroup>

## Relationships

<AccordionGroup>
  <Accordion title="Can one record be connected to multiple records?">
    Yes. [Link to Table fields](https://www.zite.com/help/database/configure-database/link-records) support both one-to-one and one-to-many relationships.
  </Accordion>

  <Accordion title="How do I keep data synced across multiple tables?">
    Use Link to Table fields to connect records between tables and keep related data in sync. Learn more [here](https://www.zite.com/help/database/configure-database/link-records).
  </Accordion>

  <Accordion title="What are Lookup fields?">
    Lookup fields automatically display information from linked records, helping you avoid duplicate data. Learn more [here](https://www.zite.com/help/database/configure-database/lookup-field).
  </Accordion>
</AccordionGroup>

## Importing & Migration

<AccordionGroup>
  <Accordion title="Can I import data from Google Sheets or Airtable?">
    Yes. Zite lets you [import data](https://www.zite.com/help/database/getting-started/import-data) from your existing spreadsheets and databases so you can get started quickly.
  </Accordion>

  <Accordion title="Can I import data from other spreadsheets or databases?">
    Yes. Simply export your data as a CSV file and upload it into Zite Database.
  </Accordion>

  <Accordion title="Will my data be changed during import?">
    Zite preserves your data whenever possible and lets you review field mappings before importing.
  </Accordion>
</AccordionGroup>

## Calculations

<AccordionGroup>
  <Accordion title="Does Zite Database support formulas?">
    Yes. Formula fields let you calculate values automatically based on other fields. Learn more [here](https://www.zite.com/help/database/configure-database/formulas).
  </Accordion>

  <Accordion title="When do formulas update?">
    Formula fields automatically recalculate whenever the data they depend on changes.
  </Accordion>

  <Accordion title="What types of formula functions are available?">
    Zite supports a wide variety of formula functions, namely Math, Text, Statistical, Date, Logical, and Information functions. View the lists [here](https://www.zite.com/help/database/configure-database/formulas).
  </Accordion>
</AccordionGroup>

## AI Features

<AccordionGroup>
  <Accordion title="What are AI Fields?">
    AI Fields automatically fill database fields using AI. Categorize records, generate summaries, extract information, score responses, and more. Learn more [here](https://www.zite.com/help/database/configure-database/ai-fields).
  </Accordion>

  <Accordion title="How do AI Fields work?">
    Simply add a prompt to a field and Zite will automatically generate values for every record. More info [here](https://www.zite.com/help/database/configure-database/ai-fields#set-up-an-ai-field).
  </Accordion>

  <Accordion title="Can AI Fields update existing records?">
    Yes. AI Fields can populate both new and existing records.
  </Accordion>

  <Accordion title="What is the Database Agent or Assistant?">
    The Database Agent is an AI assistant built directly into Zite Database that helps you create tables, organize data, analyze records, update fields, and connect integrations. Learn more [here](https://www.zite.com/help/database/getting-started/database-agent).
  </Accordion>

  <Accordion title="When should I use AI Fields vs. the Database Agent?">
    Use the Database Agent when you want to interact with and manage your database. Use AI Fields when you want AI-generated values to be automatically maintained for each record.
  </Accordion>
</AccordionGroup>

## Storage & Limits

<AccordionGroup>
  <Accordion title="How many databases can I create?">
    Even on the Free plan, you can create as many Zite Databases as you'd like.
  </Accordion>

  <Accordion title="How many records can I store?">
    Each plan includes a total record limit across all databases in your workspace:

    * Free: 5,000 records
    * Pro: 100,000 records
    * Business: 250,000 records
    * Team: 1,000,000 records
    * Enterprise: 1,000,000+ records
  </Accordion>

  <Accordion title="Can I attach files to records?">
    Yes. You can upload and attach files directly to records for easy access and organization.
  </Accordion>

  <Accordion title="What is the maximum file size per upload?">
    Each file uploaded to an attachment field can be up to 20 MB in size.
  </Accordion>

  <Accordion title="How much storage does my organization receive?">
    Storage limits vary by plan and are shared across all databases in your organization:

    * Free: 1 GB
    * Pro: 10 GB
    * Business: 100 GB
    * Team: 100 GB
    * Enterprise: 100 GB
  </Accordion>

  <Accordion title="What happens if I reach my storage limit?">
    You'll need to free up storage or upgrade your plan before adding additional files or data.
  </Accordion>
</AccordionGroup>

## More Things You Can Do With Zite

<AccordionGroup>
  <Accordion title="Can I build interfaces or tools from my Zite database?">
    Yes. Every Zite Database can power apps, portals, dashboards, and internal tools built with Zite. More info [here](https://www.zite.com/help/platform/how-to-build/creating-an-app).
  </Accordion>

  <Accordion title="Can customers add data without seeing my database?">
    Yes. You can automatically generate a form from a new or existing Zite Database using its sister product Fillout, allowing customers to submit data without accessing your database. Check out [this quick guide](https://www.fillout.com/help/guides/sync-form-results#create-a-form-with-your-database).
  </Accordion>

  <Accordion title="How many users or visitors can my app have?">
    There is no limit to the number of users or visitors your Zite apps can have — even on the Free plan.
  </Accordion>

  <Accordion title="Can one Zite database power multiple apps and forms?">
    Yes. A single Zite Database can power multiple apps, forms, and portals while keeping all of your data in sync. Workflows live inside apps and can read from or update that shared database.
  </Accordion>
</AccordionGroup>

## API & Integrations

<AccordionGroup>
  <Accordion title="Does Zite Database have an API?">
    Yes. Zite Database includes a REST API for accessing databases, tables, fields, and records programmatically. More info [here](https://www.zite.com/help/database/api/database-api).
  </Accordion>

  <Accordion title="What can I do with the API?">
    You can create databases, manage schemas, define field types, and perform create, read, update, and delete (CRUD) operations on records. Learn more [here](https://www.zite.com/help/database/api/database-api).
  </Accordion>

  <Accordion title="What are the rate limits?">
    Rate limits are enforced per database:

    * API requests: 30 requests per second
    * Internal Zite Database activity that does not use the API: 50 requests per second
  </Accordion>

  <Accordion title="Can I connect Zite Database to other tools?">
    Yes. You can connect Zite Database to external applications using the REST API, integrations, and automations.
  </Accordion>

  <Accordion title="Can I use Zite Database as a backend for my Zite apps?">
    Yes. Zite Database is designed to power [apps built with Zite](https://www.zite.com), making it easy to manage and display data across your applications.
  </Accordion>
</AccordionGroup>

<div className="zite-related-topics">
  <a href="/help/platform/getting-started/overview">Welcome to Zite</a>
  <a href="/help/platform/how-to-build/troubleshooting">Troubleshooting</a>
  <a href="/help/platform/getting-started/glossary">Glossary</a>
</div>