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.