I need to change a single select record based on a separate date record. The single select has multiple options with the same name but different colours, so how I can using automation specify which option to select as well as which colour
As can be seen in the image Confirmed has blue, orange and pink. With automation I need to select a specific Confirmed colour based on the date. I don’t know how to do this.