Best answer

Update Airtable records date from yesterday to today

2 years ago
6 June 2021
3 replies
262 views

brewster3
New
1 reply

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

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

+14

Troy Tessalone
Certified Zapier Expert
23934 replies
2 years ago
6 June 2021
Answer

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

brewster3
Author
New
1 reply
2 years ago
6 June 2021

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

+14

Troy Tessalone
Certified Zapier Expert
23934 replies
2 years ago
6 June 2021

@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