Working on Mehrican exchange need google forms help; suggestions
8So I am putting together the pieces to run the mehrican exchange. Never used google forms before. Grabbed the form from a previous exchange and did a save as. Renamed it v.6 (this is correct isn’t it? if we count in a linear whole number fashion rather than the last one which would have been v5 had we done that and instead was something like v4.1 or there about? Correct?).
Entered my own information. Saw I could see it. Not sure what url to post here. Is it the one you see in “preview”? Tried to email it to myself and both msn and yahoo rejected it as spam (was going to see what link was sent) and didn’t even list it as spam, rather I got a refused email.
I need to know if anyone had any suggestions to improve the signup, rules or running of this.
Also @studerc and @Yoda_Daenerys if you could email me at my user name and then using the usual yahoo. I need from both of you the list of people who didn’t send the promised boxes or are otherwise on the shit list. And I could use any advice you have for running this smoothly. For example what have you found to be the optimal length of time for signup, between sending the who has whom and when they need to send their boxes out, have you made any effort to keep people from getting someone they have had before (I was just going to do random unless there is a good reason not to), should I set the form so people can go back in and edit it, anything else you’d care to offer… Also is there a meh exchange existing email address (since obviously that name is taken already) I could temporarily borrow for this and then “give” it back to you? Thank you in advance!
TO EVERYONE ELSE - I will start a new thread with all the information when it is time you can sign up and I have everything good to go (I do not want to prematurely start that thread, have it buried in chit chat and then cause confusion). This thread is for suggestions, comments, and other ON TOPIC (please!!) discussion/comments.
PS - READ THIS @f00l and @PlacidPenguin If you want me to run this then the two of you who trying to make me goat need to focus your efforts on the others you (and @jbarus) have determined are in line. I am not doing both at once and the exchange gets priority. You have been warned (grin).
- 23 comments, 128 replies
- Comment
Yeah, you’ll want the preview link.
@PlacidPenguin Thanks. That is what I thought but no where in the instructions did I see which link to send and I wanted to make sure I didn’t post something that was screwed up.
@kidsandliz
Contemplating.
/giphy no good deed goes unpunished.
However, punishment can linger in the twilight, waiting for its prime moment to appear …
@f00l Do remember I had NO votes more than once.
@Kidsandliz
That’s the setup. Keep believing.
I actually have a enough worthless shit to participate. Just keep me away from @f00l and @placidpenguin. I am afraid of what they might send.
@mfladd I thought you’d be more worried of your mortal enemy @kittysprinkles. This is disappointing.
@dashcloud Hmm…if I was sure to get that loser, I’d be in!!
@dashcloud I wasn’t sure if they had postal services for her to use in Mordor.
@KittySprinkles Awake from your evil slumber I see.
@mfladd
@mfladd
What I will send you:
Lots and lots of these:
/image “enormous smiley face”!
@mfladd
Awww.
/giphy penguin love
@mfladd @Kidsandliz
Two things:
I have not heard any negative things about my junk in the past.
My junk is already boxed and sealed. So, who gets which box will be random since I don’t know which box is which.
As such, I hope to get wither @mfladd or @kdsandliz
Personally, there are 3 names who I hope not to send to or receive from.
@PlacidPenguin Good thing it will be random… @mfladd and I probably would need to be shaking in our boots for fear of what is in there were either one of us "luck
outin. (grin)@Kidsandliz
You keep on leaving out the ‘pseudo’ from ‘pseudorandom’
/image pseudo
@PlacidPenguin Hey listen - you said you wanted to “wither” me and @mfladd!!!
Random. Trust me. Random. Totally random. Besides why should I trust someone who had threatened me with goatdom? There are probably glitter bombs in there (grin).
@PlacidPenguin
/giphy sudo
advice(s):
/giphy don’t axe me again
/image ship for brains
/youtube every little thing, it’ll be alright
@Yoda_Daenerys thanks
Unofficial
@medz thanks for the reminder…
@kidsandliz you spelled my name wrong.
The exchange will just have to wait.
P.S. if you want help with the forms let me know.
To answer the specific question you asked, while the preview link may or may not work (probably will) you can be sure to get a working link by clicking the same button you did to send it as an email to yourself and instead of filling out the form to have it emailed to you click on the chain link icon near the top and it will take you to the shareable link. It will also offer automatically generate a much shorter link for you.
@jbartus thanks… and I spelled your name by memory (obviously not a good memory LOL) rather than hunt for you and copy/paste.
I just swiped an old form, did a save as, changed the first line to update the exchange # and left it alone. I saw where the second tab allows you to look at the submissions. I presume from there I just copy/paste into a spreadsheet (plan to use that to randomly assign, eg. have duplicate columns of the info and then use =RAND() on one set, sort by number on that column and then just assign by rows. - unless there is an easier way to do that) although if there was a way to easily get the responses into a spreadsheet that would save steps that would be great.
@Kidsandliz You don’t need to copy and paste, Google Forms will send it to a spreadsheet for you if you ask it nicely and rub its tummy while whispering sweet nothings in its ear.
On the responses tab near the top is a green button with sort’ve a cross-shaped white mark that’s, I think. meant to be representative of a spreadsheet with a fixed column and row of data. Whatever the icon designer sought to evoke, it represents Google Sheets and clicking it will result in the creation of a workbook for the data or an offer to send the data to a new sheet in an existing workbook.
I am not sure RAND() does what you think it does.
Don’t think that cause I’m helping you I won’t get you goated! Especially now that you butchered my name!
@jbartus Cool about the spreadsheet. Thanks! Rand ()would get me a column of random numbers. To keep them stable I’d copy/paste the column. Then sort that new column (and names column) on number. Over a couple of columns would be the names in the original order. I’d assign by reading across rows… Except of course if I am bribed enough for mfladd and kittysprinkles to get each other… that might be quite entertaining…
As far as being goated for butchering your name… you have a few before me to get first, based on previous goat nomination threads - and that isn’t goat worthy enough based on other’s “offenses” - not even close to fingering a dog, emailing support 18 times or being nice to everyone. I’ll just have to run the assignments into April…(subtle threat…evil grin)… actually at the rate I am going that might happen anyway. I need to look up when easter is and miss that in the schedule of events too.
@Kidsandliz poor @marklog
You’ll get yours!
For those of you who have no clue what this is about - if you want to be involved we exchange boxes of crap (not actual trash or broken crap though, at least some of the stuff has to be something people might want, some stuff that gets sent is way outdated, sometimes some meh stuff gets sent…). You send one you get one (up to three boxes exchanged with up to three different people unless you haven’t done this before and then you get to do only one box). Here are two reveal threads, there are more, these are just the first ones I ran into with a search.
https://meh.com/forum/topics/project-wohler--the-mehrican-exchange-4-0-reveal
https://meh.com/forum/topics/meh--exchange-4-01-a-v2-reveal-thread
@Kidsandliz Dunno if I’ll partake this time or not. I need to come up with like five prize boxes (inclusive of participant contributions) for the FML contest. I shall have to ponder this.
@Kidsandliz I’m also torn on whether I want to participate. Last time I spent too much money sending out what I thought was a decent box to not get any feedback at all. The box I received was pretty useless to me. It was on par with my BOC from woot that went straight to the donation pile.
I wish shipping wasn’t so expensive.
@Kidsandliz I appreciate the breakdown.
@RiotDemon please email at my user name at yahoo
@RiotDemon ooooo…you don’t want to get me because someone is getting a lot of wOOt and meh crappy crap.
@mfladd One might ask why you bought it to begin with??? Just trying to be helpful here (grin)…you know, save you money…
@Kidsandliz
@Kidsandliz presents??? i like to buy presents… i like to send presents… i like to get presents…
@mfladd my woot BOC was outdated school textbooks. As long as it’s something mildly useful, that would be cool.
@RiotDemon Really? textbooks - ouch. I guess mine would be better.
@mfladd yep. A really outdated American history book and a workbook for primary school math.
@mfladd I did get a magnet though.
/image woot disappointment rainbow magnet
Not my BOC, but same magnet. Summed up my experience.
@RiotDemon I had the same thing happen. I did my best with the box I sent out, whether it was great or not I don’t know but it wasn’t from lack of trying. No response at all. However the box I received was awesome so I really shouldn’t complain.
@Kidsandliz I wasn’t around for past exchanges, thanks for the heads up.
Just a heads up that I acknowledge your exchange and appreciate you clueing me in and will do what i can to help. I am pretty busy at the moment but will do whatever I can to help.
May be best to hold me accountable using the mehexchange @gmail.com route.
Good luck!
If you people really want to be rewarded with crappiest of crap, you better hope I get you.
@mfladd Random assignment random assignment random assignment reciprocal with @kittysprinkles oh wait random assignment random assignment random assignment
@kittysprinkles @mfladd since the two of you starred this, and in fact were the first two that did, does this mean what I think it means and an exception to random assignment should be granted…?
@Kidsandliz In all honesty I starred because you made me giggle. Besides, if I needed to send him a box of crap, I’d just toss it out the window to his favorite row of bushes he’s usually hiding in.
Although I’m honestly beyond curious what someone would get from him.
***besides the herp
@KittySprinkles You are evil (grin). So would the world as we know it end if “randomly” this were to happen? And perhaps, more importantly…would I live long enough to see if the two of you nuked each other with glitter bombs (or worse)? For the last couple of years meh has only had a friend’s address for me and now they have my actual, I live here, address too. I’d be in real trouble if someone there can be bribed. On the upside, at least you’d save on postage.
@Kidsandliz @KittySprinkles
@KS And I told you before it was only a mild skin irritation - geesh!
@mfladd
@mfladd Oh my - the dragon awakens… should I be scared? LOL
@Kidsandliz this would be @mfladd…
If I do this, someone may get an avalanche of crap dumped on them. You’ve been warned.
@ACraigL As long as some of the crap is decent crap… then I am sure people will be happy : )
@Kidsandliz
Great news - I found somebody who may actually pose a threat not only to your record 0 votes when it comes to goat voting, but also to the negative votes which @JasonToon gets.
@PlacidPenguin Just like there are no 1/2 stars there is no way to make negative votes. By the way, who might that be that you say would have less votes than 0 besides the two of us?
@Kidsandliz
No spoilers.
(Found some great images for this, and I’d rather not reuse Dr Who, so…)
@PlacidPenguin
I’m safe
good luck with this
like some others, i feel this is Meh. at times, you might send PRIMO and get no feedback
you might send Meh. and receive Meh.
who knows?
i still am planning to send deets on the dregs (in my black book)
i will send deets-for-dregs after i sea dis es panningout
Since there was just a fuko today (April 1) I am going to put this off until end of April or early May - whenever the fuko reveal thread has run its course.
@Kidsandliz Or as long as it takes for you to keep ducking being the GoaT! Pfft…
@mfladd That’s a thought. But if they’d tell us when they were going to do the fuko it wouldn’t be an issue LOL
@Kidsandliz If a frog had wings it wouldn’t bump it’s ass on the ground - and I would actually have “1” fuko.
@mfladd Yeah well that will happen …
/giphy when pigs fly
@Kidsandliz
Any chance you’d take bribes to help some “coincidental” match-ups happens?
@someRiverNoise Well I had already threatened a couple of matches made in some part of the universe that explodes on a regular basis (not to mention on here LOL- you know kittysprinkles and mfladd and somewhere or other there was something close to justifiable homicide threatened if placidpenguin and f00l were matched - I think it was them anyway, I’d have to go find that again…) but then I’d be goated for this not being totally random…
@Kidsandliz
So what you’re saying is that you would accept bribes…
@someRiverNoise Nope. That would for sure goat me, besides not being fair since I promised random… : )
@Kidsandliz Your getting goated regardless. Might as well get some cash in your pocket.
@Kidsandliz
Yeah. Get some cash + the opportunity to make @mfladd regret having a physical address and a pseudo-human disguise.
@mfladd That will take votes. Repeatedly F00l has tried and I get no votes… there are others more worthy according the the monthly goat nomination threads… I am way down the list. : )
@Kidsandliz
And now that @katylava is eligible…
@someRiverNoise @mfladd hmm… the only bribe I’d accept is pay off all my medical bills plus pay for my insurance and medical bills for the rest of this year… not worth being unethical for less : )
Out of curiosity though… what are the pairings you folks would bribe for? Of course answering that question might put you both on the endangered human list…
@Kidsandliz
Can’t go into them publicly. Don’t wanna scare anybody off.
Also, what do ethics have to do with anything?
@someRiverNoise Translation: don’t want to make yourself a target…?
@Kidsandliz
Nah. I just don’t want people to regret their decisions to participate in the mehxchange.
@someRiverNoise Right (LOL). While I am exceedingly tempted to pair a couple of folks for the entertainment value for the rest of us, I won’t because I promised random… and I really don’t want one or the other to get a 5 pound glitter bomb or something similar in their box. That is too mean LOL
@Kidsandliz You got few votes because you made it clear about the goat/exchange timing.
@someRiverNoise Katylava…had not crossed my mind yet. No flask, no foul.
@mfladd
She could easily get more votes than @jasontoon. (And then she’d be tied with @Kidsandliz).
@mfladd the time before that I got a perfect zero : )
@mfladd Now that is a good idea - Katylava
@Kidsandliz @mfladd
So from what I see, @katylava would get more votes than @Kidsandliz (who averages 0 votes) and @Jasontoon (who gets less than that).
I have never done a Mehexchange before but definitely interested…-- looks like fun –
Any chance the form could have an optional comment box in case someone has alleges to particular things or important things which the sender should be aware of?
Or should we just let you know in an email?
Although I guess what was done last time (having a thread) could be done this time.
@someRiverNoise Yes I plan to put one there.
what is happening? why am i getting mentions from this thread? i’m confused.
@katylava
@Kidsandliz was talking about goat nominations and how there are people more worthy than her.
So naturally I mentioned you.
@someRiverNoise
a sneak attack would have been better
@mfladd
¯\_(ツ)_/¯
@someRiverNoise @katylava actually I was being threatened with a goat nomination and told people I wasn’t going to do the exchange and goat the same month, goat loses. Then right when I was ready to start the exchange, there was a fuko so I announced I was going was going to postpone it. Then I was, umm, accused of using the exchange to more or less permanently get out of goat; I’d just keep postponing it… and THEN… when I said I wouldn’t accept bribes to pair certain people for entertainment value, if I did then I’d be goated for sure and @mfladd said I should accept bribes since I was going to be goated anyway… and then you got brought up as a potential goat by @mfladd… See? In true meh style this is a typcial, nice and linear transition from the exchange thread to a premature goat nomination thread… Got it? LOL
@Kidsandliz
I mentioned her first. NOT @mfladd.
@katylava You mean you don’t read all the threads on Meh.com ?
@Kidsandliz
Holy shit!
You Bitch!
@mfladd Well it is all in the messages… all I did was summarize - you know - to help the confused and/or lazy
/giphy you can run but you can’t hide
well not exactly what I was looking for but this one is sort of neat.
@someRiverNoise I stand corrected. @mfladd mentioned second then. : ) Either way
@mfladd PS you should be glad I won’t accept bribes… you and @kittysprinkles paired would be very entertaining for sure : )
PPS @mfladd Sweet. I have managed to trigger gifs aimed at me. Does that mean I get to play with the “cool kids” now? LOL
@Kidsandliz @someRiverNoise thanks for clarifying. Was afraid I was being volunteered to ship random stuff to people, and I’m way too lazy for that.
@katylava
Implying that if you were volunteered to ship stuff to people then you would consider it?
@katylava well you could volunteer to be a participant in the meh exchange and then you’d voluntarily mail random stuff to someone… just sayin’
@someRiverNoise no… implying the opposite. implying there would be some very disappointed exchangers. katy doesn’t like errands.
@katylava
On the bright side, Katy could get herself put on the naughty list for these mehxchanges so as not to be bothered again.
@Kidsandliz That’s how I show love. Same with "fuck or bitch"
AND YES YOU DID DO IT (throw me under a bus), BITCH!
@mfladd Was an honest bus accident though LOL - hope it was at least a gory under the bus ride… On the other hand the real culprit couldn’t stand you getting credit for the misdeed so the ride was short.
@someRiverNoise missed that post, i could add ka tyla va to the list of dregs i just s§ent
/youtube list of dregs
sent you an email with a list of possible trouble makers
/youtube possible trouble makers
/giphy form your own opinion
@Yoda_Daenerys Thanks - I just sent you an email back with a question. Do you check that email with any regularity?
@Kidsandliz i don’t, but it does forward to one that i do.
some of those lower on the list eventually sent.
buyer beware on the top half of the list
@Yoda_Daenerys There’s a naughty list?
@mfladd
People who received boxes but never sent out (or maybe they did but they never said that they did and the boxes weren’t received).
@mfladd we both are on it!
@PlacidPenguin
@PlacidPenguin I don’t like that some people are shitty.
@mfladd
@mfladd you make it sound much sexier than the reality of it
/youtube you make it sound much sexier than the reality of it
So somehow I missed the last one and don’t want to do the same this time since I actually used stuff from the ones I did play. So since this thread has gotten TL/DR, bottom line… timeframe is???
@readnj When the fuko has wound down. I had planned to do it now but the fuko sort of wrecked that. I will create a new thread when I do.
@readnj
However long @Kidsandliz keeps on stalling her goathood.
So probably June or July…
²⁰¹⁸
@PlacidPenguin @readnj nah… it will be sooner than that. Don’t want to overlap the fuko fun. Then I will do it. Likely that should have died down in 3ish weeks maybe. I’ll give it a week or so after than then post to sign up. Don’t want to time it to hit the memorial day weekend as so many people go out of town and that complicates mailing.
@Kidsandliz convenient how 3ish weeks is right about when we’ll be voting for May goat.
well?
/youtube no time like the present
@Yoda_Daenerys
I approve of Happy Tree Friends.
(As does @narfcake as long as Cuddles isn’t primary. There was an ‘incident’.)
@PlacidPenguin OK OK OK… been busy, had tooth issues, next week going to MD Anderson Cancer center…can probably think of other excuses if I wasn’t so tired… Will try to get the sign up up and running in the next few days (eg before I leave on my road trip to Houston).
@Kidsandliz
I haven’t made an inquiry for a few days.
Give me a chance to bug you before you beat me to it with explanations.
Sheesh.
@PlacidPenguin Well if you need practice bugging people to figure out how to do a good job at it…feel free. We will grade you on your efforts. : )
@Kidsandliz
(I’d prefer to be judged by the garbage which I’ll mail people.)
@f00l - Quack
@Kidsandliz yeah hurry up already, we’ve been on hold for two goat elections now over this thing!
@jbartus @PlacidPenguin blah blah blah blah bah goat blah blah blah inquiry blah blah blah blah bah blah blah blah garbage…snooze
@Kidsandliz
You may like how I filled in the blanks in my mind…
@PlacidPenguin Let me guess - it involved Russia, Trump and the ex-FBI director… Right? LOL Oh wait this post belongs as a response to @tightwad on the Simongate thread ( https://meh.com/forum/topics/simongate-is-taking-on-a-life-of-its-own#5913351b2202b208f832f579 ) who doesn’t want anymore -gates. (@f00l Collin1000 )
@Collin1000 see the post above this one. I forgot the @ before your name.
@Kidsandliz
No, but it does involve toothpaste, a mule, and a rabid butterfly.
@PlacidPenguin using a butterfly to brush the teeth of a mule?
@Kidsandliz mistag-gate
@Collin1000 Ben-gate in simongate thread
@Yoda_Daenerys @PlacidPenguin OK so it isn’t up yet. I can’t do it today, tomorrow I drive to MD Anderson so Wednesday when I am in the hurry up and wait game there I can finish the form and start the exchange thread sigh up thread.
@Kidsandliz
Take your time.
There’s no reason you should rush to start something you’ll quickly end up regretting.
tick tock, tick tock
/giphy whatever
@Yoda_Daenerys Yeah…I know… On another thread two of us were discussing this. The issue I see now is overlapping the likely early July fuko… I think the exchange reveal thread and the fuko shipping thread would overlap and I am not so sure that would be a good idea…
@Kidsandliz @Yoda_Daenerys
September-January are also out of the picture using this logic.
And then there’s the Fuko which will be in February, so February-March are out.
April-May are also out.
June wouldn’t be good because the reveal thread would be around at about the same time as the July Fuko, which would mean that June-August are out as well.
@Yoda_Daenerys So @PlacidPenguin now that you have eliminated the entire year…
@Kidsandliz
I could continue if you want, but I think you get the gist.
@PlacidPenguin demented minds think alike
/youtube dr. demento
@Kidsandliz I would just do it. I’m assuming the majority that enter the exchange are the more frequent meh posters, so posting two items (assuming they also get the fuko) should be no big deal.
/giphy do it
Make it soon, please. I have 15 lbs of T-shirts arriving tomorrow, and today I got some sweatshirts I don’t need.
OK OK OK… it is likely going to overlap. I’ll set it up tomorrow. Too tired tonight.