Yes, that makes sense (sorry for the delay; I’ve had to cut way back on my time in here, plus I took the weekend off).
That could be done via an automation if your base is in a Pro-plan workspace or higher. This would need to be triggered by a record entering a view. However, if the view filter is simply looking for records that have a date, it might trigger the moment you begin editing the date, which would be bad. There needs to be a delay of some kind set up so that it triggers a few minutes after the date has been edited. I haven’t tested this setup specifically, but it’s a variation of a setup that I have tested, so I’m confident that it will work.
Add a Last updated time field named something like {Pickup Updated} that only tracks changes to that {Scheduled Pick Up} date field. Add a formula field named {Pickup Update Delay} that takes the date from the Last updated time field and adds 5 minutes to it. Add another formula field named {Pickup Trigger} that compares that delayed time against NOW(), and outputs a 1 when NOW() is later.
Make a new view that only shows records where that formula outputs a 1, and use that to trigger an automation. In theory, this will trigger the automation no sooner than 5 minutes after that {Scheduled Pick Up} date is edited. The automation will create a new record on your calendar table, linking to the triggering customer’s record via its ID (pulled from the trigger step) and copying the date you chose.
