Spreadsheet¶
Non-Visible component| Category | Requires | Version |
|---|---|---|
| Storage | API 21, Android 5.0 Lollipop | 1 |
Overview¶
A non-visible component that provides access to the Airtable spreadsheet storage
Component credits: Jerin Jacob
Permissions
Events¶
Cell Changed¶
Triggered when changing cell data. ResponseCode is a number
| Params | |
|---|---|
| response Code | Number |
Deleted Row By Number¶
Triggered when destroying a row. ResponseCode is a number
| Params | |
|---|---|
| response Code | Number |
Got All Rows¶
Triggered when getting all rows. ResponseCode is a number, ResponseContent is a string
| Params | |
|---|---|
| response Code | Number |
| response Content | Text |
| total Rows | Number |
Got Cell¶
Triggered when receiving cell data. ResponseCode is a number, the other ones are strings
| Params | |
|---|---|
| response Code | Number |
| value | Text |
| row Id | Text |
| created Time | Text |
Got Column¶
Triggered when receiving column data. ResponseCode is a number, the other ones are lists
| Params | |
|---|---|
| response Code | Number |
| values | List |
| row Ids | List |
| created Times | List |
Got Row¶
Triggered when receiving row data. ResponseCode is a number, Values is a list
| Params | |
|---|---|
| response Code | Number |
| values | List |
Row Created¶
Triggered when creating a row. ResponseCode is a number
| Params | |
|---|---|
| response Code | Number |
Row Updated¶
Triggered when updating a row. ResponseCode is a number
| Params | |
|---|---|
| response Code | Number |
Methods¶
Create Row¶
Creates a new row
| Params | |
|---|---|
| column Names | List |
| values | List |
Delete Row¶
Deletes the given row
| Params | |
|---|---|
| row Number | Number |
Get All Rows¶
Gets all rows
Get Cell¶
Gets cell data
| Params | |
|---|---|
| row Number | Number |
| column Name | Text |
Get Column¶
Gets column data
| Params | |
|---|---|
| column Name | Text |
| max Record | Number |
Get Row¶
Gets row data
| Params | |
|---|---|
| row Number | Number |
Set Cell¶
Changes the value of a cell
| Params | |
|---|---|
| row Number | Number |
| column Name | Text |
| value | Text |
Update Row by Number¶
Updates the given row data
| Params | |
|---|---|
| row Number | Number |
| column Names | List |
| values | List |
Properties¶
API Key¶
Text 
Read Write - Designer Blocks
Your apiKey
Base ID¶
Text Read Write - Designer Blocks
Property for BaseId
Table Name¶
Text Read Write - Designer Blocks
Property for TableName
View Name¶
Text Default: Grid view Read Write - Designer Blocks
Property for ViewName