Skip to content

Spreadsheet

Non-Visible component
Category Requires Version
Storage API 19, Android 4.4 - 4.4.4 KitKat 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

Table Name

Text ➖ Read Write - Designer Blocks

View Name

Text Default: Grid view ➖ Read Write - Designer Blocks


Last update: January 27, 2020