Many apps require a simple table of data to perform a number of essential tasks. One way to add this data is via an online Spreadsheet but a faster and simpler way to do so is through a Local DB, short for database.
The first thing you want to do after you add the component is to edit the data table.
| Event | Description |
|---|---|
Get Cell (column, row number) |
Gets the data in a cell based on the column and row number |
Get Column (column) |
Gets the data in a column formatted as a list based on the column number |
Get Row (row number) |
Gets the data in a row formatted as a list based on the row number |
| Number of Rows | Gets the number of rows |
You may want to update the data in your locally stored table from the app itself. At the moment, you can only update a specific cell. We are hoping to add the ability to add and delete an entire row. Any updates you make to the table from the app will only be seen by the specific user of the app. To make changes that will be reflected across all apps, we suggest you use the Spreadsheet component where data is stored n the cloud.
| Event | Description |
|---|---|
Set Cell (column, row number, value) |
Updates the data in a specified column and row with a value |