Hi everyone, here's what I'm trying to do. This is a base used to track enrolment in classes.
- Column 1 (linked values): Enrolment History
- Column 2 (linked values): Classes - Current Enrolment
I want an automation that will run every day and add any linked values in "current enrolment" to the list of values in "enrolment history", **without** overwriting it.
Here's how I've tried to set it up, but as you can see it doesn't work:
