All videos

Apps · 1:05

Connect an app to your data

Give an app access to a database in its settings, so the page can read and change rows.

Transcript

0:00Connect an app to your data

Sam’s Refund review app should list open refund requests from the Refund cases database. Sam owns that database, yet the app says it cannot read it. An app works with its own access, not the access of the person using it. Settings lists the databases the app can use. This app has none yet. Add database offers the databases you own. Sam picks Refund cases. Read only lets the app read the schema and select rows. Read and change also lets it insert, update and delete. Row rules still apply. The page only lists requests, so Sam keeps Read only and adds the database. The database also shows as a tab on the app’s page. Reload the preview. The app now reads the rows with its own grant. Only the database’s Owner can add or change this access. Saving the app’s code gives it no access. Sharing the database does.