- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 10:49 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 11:55 AM
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'
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 12:19 PM
@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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 03:26 PM
Where are you using the script?
