Back

History of records created

This query returns a list of every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.

Developer info

API endpoint slug: airtable.history_of_records_created
Runtime method: performQuery("airtable.history_of_records_created"}

Query fields

Base Dropdown list

Label: Which base?
Slug: base_id
Required: true
Can have default value: false

Table id or name Text input > Other

Label: Table name
Helper text: Fire when a new record appears in this table.
Slug: table_id_or_name
Required: true
Can have default value: true

View name Text input > Other

Label: View name
Helper text: (Optional) Only fire when a record appears in this view. Learn more
Slug: view_name
Required: true
Can have default value: true

Sort field Text input > Other

Label: Sort field
Helper text: (Optional - Advanced) Sort your records by a specific field. Learn more
Slug: sort_field
Required: true
Can have default value: true

Ingredients

Record url The URL for the record.

Slug: record_url
Filter code: Airtable.historyOfRecordsCreated.RecordURL
Type: String
Example: https://airtable.com/

Created time The date and time the record was created.

Slug: created_time
Filter code: Airtable.historyOfRecordsCreated.CreatedTime
Type: Date (ISO8601)
Example: 2020-07-07

Record json The full JSON object for the record.

Slug: record_json
Filter code: Airtable.historyOfRecordsCreated.RecordJson
Type: String
Example: {"Name": "Buy milk", "Important": true}

Record name The name of the record.

Slug: record_name
Filter code: Airtable.historyOfRecordsCreated.RecordName
Type: String
Example: Buy milk

Record The ID of the record.

Slug: record_id
Filter code: Airtable.historyOfRecordsCreated.RecordId
Type: String
Example: rec12345678901234