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 |
|
| Starter |
|
| Core |
|
| Enterprise Standard, EnterprisePlus |
|
In addition, the following technical limits apply across all plans:
- 20 tables per database
- 100 columns per table
- 250,000 rows per table for Enterprise plans; 50,000 rows per table for all other plans
- 2000 characters per cell
See also:
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
- Switching the Source Path when configuring table settings in the app editor causes an error
Note: As a workaround, you can delete the table you’d like to replace and add a table using the new data source.
- Manual changes to the database will not yet trigger an automation