Secret Sneepsnop 2k17 is a user on octodon.social. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.
Secret Sneepsnop 2k17 @sneepsnop

Gosh!! 94 people are signed up for this is gonna be more work than I thought it was gonna be lmao

if any tech savvy ppl out there wanna write me a script to help with randomly assigning these to each other and sending out emails get in touch cuz my original plan for this isn't gonna scale haha.

· Web · 7 · 4

@sneepsnop Sure. Easily done with google drive stuffs. (I was solving a similiar problem a few weeks ago. Well similiarish.)

@sneepsnop the plugin "autoCrat" will do the mailing and forms and whatnot (With... less pain than I expected, TBH). And a ransom order thingo will take care of it. private message me some samples and I'll do some templates for you.

@sneepsnop I'm going to record some Opus Magnum right now, but uh share with this masto username at the gmails a templated sheet of what you want to do and I'll be back in 30-60m.

@DenubisX Dex already wrote something that works but thank you for the offer

@sneepsnop I could probably help with that, if you like. :)

@Dex ooh!! Incredible! That's nearly perfect. If its possible to have it look at the column of who each person doesnt want to match with & make sure that doesn't happen either then it would be totally perfect. I can hand-massage the column to be regular and use whatever values to mark the exclusions. If I have A, B, C, D, F and for B they said they don't want to match with C then B shouldn't get assigned to C and shouldn't be assigned to B. If that's not easy to implement I can do it by hand

@sneepsnop gist.github.com/venusyprime/36

Try this. I've also added some warning messages - in the event of an infinite loop if not enough recipients available, press Ctrl+C to stop.

@Dex This looks really good! Just to check, this makes sure each person only gets matched once, right?

@Dex thank you so so so much i will most likely use this

@sneepsnop Yeah, that's what the "$recipients = $recipients | where ID -ne $recipient.ID" line does, it removes that recipient from the pool of remaining recipients.

Should also mention that I only tested it on PowerShell v5 on Win10. It should work on everything down to PSv3 (which came by default with Win8, but is downloadable for 7), and should probably work with PS Core for Mac/Linux as well since there's no Windows specific functionality here.

@Dex PowerShell v5 on W10 is what I'll be using. So this is perfect then. You're incredible Dex thank you so much this is gonna make my life a lot easier tomorrow.

@Dex do you want a Special Thanks post tomorrow