Best answer

Update Airtable records date from yesterday to today

  • 6 June 2021
  • 3 replies
  • 273 views

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.)

icon

Best answer by Troy Tessalone 6 June 2021, 22:05

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

@brewster3

Try typing in the word “today” into the Date field.

Otherwise, use a Formatter > Date & Time > Format step in your Zap.

Check out this help article about inserting a timestamp: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

 

Thanks @Troy Tessalone 

Having 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?

Userlevel 7
Badge +14

Hi @brewster3 

Consider using Airtable Automations to do this instead: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-Overview

 

Or if using a Zap, use this as the trigger step: Airtable New Record in View

Airtable Views: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views