Define AppSheet DB table schema programmatically or via a csv

Hi,

I wanted to ask if it is possible to define the schema of an AppSheet DB table based on a csv.

I would like to create it as a table instead of gSheet so that everything is in a database, which will help us keep things more organized and I presume would have some performance gains.

I tried importing the csv as a gSheet and then changing the storage to the DB I want to create the table in, but the table is not actually created in the DB.

Does anyone know how to do this? or in general how to define a table schema programmatically in AppSheet (if I am not wrong one can only add rows via the REST API right)?

Thanks!

0 1 44
1 REPLY 1

At the moment, you cannot create schema programmatically.  AppSheet Databases are fairly new and still undergoing growth.  

If you haven't seen it yet, there is this article on creating and copying AppSheet databases:

Create and Copy databases

Top Labels in this Space