Update Airtable records date from yesterday to today

Question

I am building a simple daily task management zap connected to airtable. I want any task that was not “Done” to be forwarded to the following day (at 3AM) so when I start work I have all uncompleted tasks automatically in today's task list.

So far my zap steps are
1 - Zaper Schedule, trigger is everyday at 3am
2 - Airtable, find record where Status is not Done
3 - Airtable, update Record so Date is today not yesterday

Step 3 is where I'm struggling, how can I change all not “Done” dates to today?

(New to Zapier.)

Troy Tessalone · Accepted Answer

Hi@brewster3Consider using Airtable Automations to do this instead: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-OverviewOr if using a Zap, use this as the trigger step: Airtable New Record in ViewAirtable Views: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views

brewster3 · Answer

Thanks @Troy TessaloneHaving a look at Airtable Automations again thanks.The View idea is a good one.Step 1.New Record in View in Airtable [all good]2.Update Record in Airtable…hmm I’ve chosen Record:Date: Date;wondering how do I update date records to today?

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded