Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Trigger in specific date

Topic Labels: Automations
103 3
cancel
Showing results for 
Search instead for 
Did you mean: 
denysyudin
4 - Data Explorer
4 - Data Explorer

Hello, 
I am using Airtable for a long time integrating with N8N.
I have one issue.
I am using Airtable for store data.
This data have to be processed in specific time.
Client can set process time in airtable process_time column.
I want to make trigger at that time and process date in N8N.
Does anyone have any suggestions on what I could do for a consistent system?

3 Replies 3
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Does the the process need to be initiated at a specific time to the minute?

If so, this isn't doable within Airtable as far as I know. If having a buffer of ~15 minutes is close enough, do the following:

Create a formula field that compares the current time with the stated process_time:

IF(NOW() > {process_time}, 'Execute')

You can set up your automation in n8n to execute when this field returns 'Execute'

denysyudin
4 - Data Explorer
4 - Data Explorer

@Kenneth_Raghuna ,
thank you for your answer.
I am trying to make trigger when time is now.
I tried to get table by using table.selectRecordsAsync()

but I can get only id.
how can I get all records data?

this is my airtable script

let table = base.getTable("Output")
let query = await table.selectRecordsAsync({fields: table.fields});
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

Where are you using the script?