Hi, I’ve spent hours on this and I’m not sure what I’m doing wrong. Here’s what I’d like to accomplish:
- Each row in the table is a person (a child in daycare)
- I want to automate a way to change the location of their daycare on a certain date
- I have these columns:
Current Location
(multi-select)
Change Date
(date)
New Location
(multi-select containing the same values asCurrent Location
)
- I’m trying to set up the automation so that on
Change Date
it will updateCurrent Location
to match the value inNew Location
, but it isn’t working and I haven’t been able to figure out why. I get a “received invalid inputs” message.
Any help is much appreciated!