Explore Plans
Mobile menu Close menu
AirtableAirtable

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 ID 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 URLThe URL for the record.

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

Created timeThe date and time the record was created.

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

Record jsonThe full JSON object for the record.

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

Record nameThe name of the record.

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

Record IDThe ID of the record.

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