Restrictions, limits, and known issues

The following sections capture the restrictions, limits, and known issues for AppSheet databases.

Restrictions

The following restrictions apply to AppSheet databases:

• AppSheet databases are available by default, but can be disabled for your team by your administrator
• If your Workspace account is available for K12 audience, then AppSheet and AppSheet databases are automatically disabled as a security precaution

Limits

The following limits are in effect based on your subscription plan. For example, if you have 5 AppSheet Core licenses, each of those 5 users are entitled to create 10 AppSheet databases with a maximum of 2500 rows per database.

When the limits summarized below are reached, existing data will be retained and you will continue to have read and edit access it. However, you won't be able to add new data.

Subscription plan	Limits
Free	1000 rows per AppSheet database 5 AppSheet databases
Starter	2500 rows per AppSheet database 5 AppSheet databases
Core Publisher Pro	2500 rows per AppSheet database 10 AppSheet databases
Enterprise Standard, EnterprisePlus	200,000 rows per AppSheet database Unlimited AppSheet databases (200 databases per user)

In addition, the following technical limits apply across all plans:

• 20 tables per database
• 100 columns per table
• 2000 characters per cell

• 5000 characters per LongText column

See also: 

• Performance considerations for common data sources
• AppSheet pricing

Known issues

The following list the known issues when using AppSheet databases:

• Copying and pasting text over a linked Lookup column is not supported yet
• Grouping and filtering is not supported for every column type yet
• Grouping on linked rows will pick the first linked Lookup column for the group headers
• Chromebooks and Apple Macs have system settings that can hide scrollbars so that scrollbars are missing
• Manual changes to the database will not yet trigger an automation