Skip to content

[TRIGGER] Airtable Polling Trigger with filter #15982

@QualityAgileFlow

Description

@QualityAgileFlow

Describe the event source. What app is this for, and what event does the trigger correspond to?
The actual Airtable-Trigger let you:

  • get instant updates (which fire a lot when editing a table)
  • polling on new/modified/deleted....in view

But there is very relevant trigger not available.
The API supports filtering on polling via the formula field

It would be great to use this field also in the trigger (it is implemented in the get_records-Action).

A usecase would be:

  • You can define an Airtable field with a modified-date from a specific field (or field set)
  • Filtering on this field like IS_AFTER({${modifieddatefield}}, DATETIME_PARSE("${lastworkflowrun}", "YYYY-MM-DD HH:mm:ss"))` would give all records where the field changed since last call of this workflow

Please provide a link to the relevant API docs for the specific service / operation this trigger is tied to.

Filter-Formula-Possibilitities: https://support.airtable.com/docs/formula-field-reference
Airtable API used for the trigger: https://airtable.com/developers/web/api/list-records
n8n has this implemented in their trigger: https://github.com/n8n-io/n8n/blob/c06ce765f11dcde4731d3739e1aa5f27351c3cc2/packages/nodes-base/nodes/Airtable/AirtableTrigger.node.ts

Metadata

Metadata

Assignees

Labels

enhancementNew feature or requestgood first issueGood for newcomershelp wantedExtra attention is neededtriagedFor maintainers: This issue has been triaged by a Pipedream employeetrigger / sourceNew trigger / source request

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions