Share a database with individual users or the owner's team to allow them to edit or use the databases in an app.
- Understand the database permissions
- Share a database with individual users
- Share a database with the database owner's team
- Manage permissions for individual users
- Send users a link to the database
- Restrict external database sharing
Understand the database permissions
The following permissions are supported for AppSheet databases.
Permission | Description |
Viewer |
|
Writer |
|
Editor |
|
Owner |
|
Share a database with individual users
To share a database with individual users:
- Open the database in the database editor.
- Click Share.
- Enter the email address of the individual user with whom you want to share your database, such as ahamilton@example.com.
- Repeat to share with additional users.
- Select one of the database permissions.
- Optionally, click Copy link to database to share with users.
- Click Save.
Share a database with the database owner's team
Team members are not notified when a database is shared with a team. You can view the databases that are shared with your team, even if you haven't accessed them, by clicking the Shared with me filter on the My Apps page.
To share a database with the database owner's team:
- Open the database in the database editor.
- Click Share.
- Select one of the database permissions for Everyone in the owner's team.
- Click Save.
Manage permissions for individual users
To change the owner, see Change the owner of a database.
To manage permissions for individual users:
- Open the database in the database editor.
- Click Share.
- Change the database permissions for an individual user.
- Click Save.
Send users a link to a database
To send users a link to your database:
- Open the database in the database editor.
- Click Share.
- Click Copy link to database.
- Click Done.
- Send the link to users using your preferred method.
Restrict external database sharing
Restrict the sharing of AppSheet databases to only emails or domains internal to the domain belonging to the app owner's organization. For an AppSheet organization, this includes all secondary domains managed by the parent Google Workspace account, if applicable.
Restrict external database sharing:
- Access the Policies page by selecting one of the following:
- Admin > Policies in the top navigation
- Policies from the account profile drop-down
- Select the scope, Team or Account.
- Click + Account Policy or + Team Policy to add an account or team policy, respectively.
- Select Restrict external database sharing from the Policy Template drop-down.
- Click Next.
- The policy is preconfigured for you. You can modify any of the field values. See Add a predefined policy for a description of each field.
Important: If you modify the Condition field, ensure that you retain the functionality defined below:
NOT([IsSharedExternally])
- Click Save.