Community Help Request Airtable + Make Reminder System Failing (Timezone Issue)

Custom Apps
1

(Timezone Issue)

I’m using Airtable + Make to send scheduled Telegram messages. I have a table with a field called DateTime (Raw) (entered in IST), and I want to trigger a reminder 15 minutes before that time.

Here’s what I’m doing:

Airtable formula (Remind_at):

airtable

IF( {DateTime (Raw)}, DATETIME_FORMAT( DATEADD( DATETIME_PARSE({DateTime (Raw)} & ' +05:30'), -15, 'minutes' ), 'YYYY-MM-DDTHH:mm:ss\\Z' ) )

Make Search Records formula:

make

AND( IS_AFTER(DATETIME_PARSE({Remind_at}), DATEADD(NOW(), -15, 'minutes')), IS_BEFORE(DATETIME_PARSE({Remind_at}), DATEADD(NOW(), 1, 'minutes')), NOT({Reminder_sent}) )

What I Need:

  • A working Airtable formula that handles IST-to-UTC correctly

  • A Make search filter that actually catches records at the right time

Thanks in advance :folded_hands:

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.