TIme Stamp When a Record Enters a View

I’d like to achieve the following.

When record enters a view, both update that record with a date 90 days in the future and stamp it with the date it entered that view. I can’t jimmy it to make this work with various attempts.

I was trying automations and the last modified field. Both of which won’t work, at least in how I attempted. The problem with last modified is that impacts the record when other, unrelated changes are made.

Thoughts?

You would need to add extra formula fields to your base which are equal to the dates that you want to use as timestamps. You can hide these fields because you don’t need to see them.

Then, for your automation actions, you can set your other date fields to the values of these hidden formula fields.

p.s. Airtable doesn’t recommend using the “when a record enters a view” trigger. Since entering a view is based on filtered conditions, it would be best to trigger your automation for “when a record matches conditions” — based on those same filtered conditions.