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?
Trigger in specific date
+2
+20Does 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'
+2@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});
+20Where are you using the script?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.