Referencing specific date and time within formula

[denysyudin]

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?

[Kenneth_Raghuna]

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]

@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]

Where are you using the script?