I have a list of people in a table named ‘Responses’. On a specific date and time I want an automation (or script?) to run that will create random pairings from the names on this list. I would like pairings to be created for the next 6 months in a separate ‘Assignments’ table and no two people paired together more than once.
If anyone has insight into the best way to accomplish, I would greatly appreciate the help. Thank you!