I have a table of records of my published works containing a Multiple Select column with the formats of those books. What I need is an automation that will create records in another table with the options from that format Multiple Selection column that are not selected. So if my multiple selections are ebook, paperback, and audio and I only select ebook, I want to automatically create a record that lists the audio and then a record that lists paperback to use as a task list. I’d appreciate any ideas because I’m stumped.
