Simple Update Record Automation Failing

[addfrench]

Hello,

I’m setting up my first Airtable Automation where I have two fields: Date and Status. If a Date field is on or more than 7 days old (for instance, if today is January 21, I would need it to pull from dates that are January 14 or older), I need the Status field to say “Old.” For dates that are within the past week, I need it to say “New.”

When I set up the Automation, I get a failed test, with “Received invalid inputs” as the error message. I have a feeling it has something to do with my Record ID not matching up, but I don’t know what to do there and I’m having trouble finding documentation on it.

Any help is appreciated. Thanks!

[augmented · Accepted solution]

It looks like you have put the Status field where you should have put Record ID. Set it like this…

[addfrench]

Thanks @augmented! I knew it was something simple like that.

Now, when I run the tests, it says it’s successful on both the Trigger and the Action. But, when I turn the Automation on, it’s not updating the records, they’re staying the same as what I’d entered in that field before. And, if I create a new record, and assign it a date, it maintains its default value from the Single Text field type that I’d set, rather than adjusting it based on its age.

Is it possible that my trigger of When Date Is Before/After One Week Ago isn’t recognizing the dates in my Date field? I created an Automation for Before One Week Ago, and a second Automation for After One Week Ago so it should assign Old and New appropriately. Neither seem to be triggering.

Thanks again!

[augmented]

You can look in the test of your trigger to see what record(s) matched the conditions. There’s a lot of info in there.

“on or after” “one week ago” should fire for dates 1/15/2021 (ish) and newer right now. I just tried your automation and it worked for me.

[addfrench]

Thanks for testing it! It does work on new records created after turning on the Automation, but I suppose I thought it would update existing records to meet the new criteria. I can live with this as a solution, I just need to create my Automations before I enter my data.

If there’s another workaround to getting it to update existing records, let me know! Thanks again!

[augmented]

Automations run only once while a record matches the condition in the trigger. So, I think if you change the date so that it no longer matches the condition, and then change it back, it should fire again.