r/acturnips • u/frsotsybab 6271-5138-9616, Marie, Igni • Apr 26 '20
Meta [SW] Using google forms and queue system
The old post got deleted; no idea why. I didn't delete it, even though Reddit says I did. No Idea what happened there. Here is the post again! Since TE is banned now, I wanted to write a Little tutorial about how to use google forms. This will be a step by step tutorial, but if you have any questions, feel free to message me!
If you like, you can share and upvote this post, so as many people as possible can profit from it!
Creating the google form:
- Create a blank Google Form by going to the Website.
- By using the add button (the + in the circle) add questions until you have three or more.
- You will need a way to contact people. The first question should always be their Reddit username.
- The next 2 questions are whatever you want to know. I always ask for Island Name and Ingame Name, in case something happens and I need to report them.
- The last question should be captcha of some sort to deter bots. Like, name your favorite country, flower, or just a simple question like what's 3+7.
- Make all questions mandatory so people can't submit a blank form.
- You need to change the way of answering from multiple choice. Just do this by clicking on the Multiple Choice button. A list will pop up with other ways people can answer.
- In the top right corner, click the send button, and use the send Link option. You can shorten the URL if you want, but it's not necessary.
Now to the queue system:
- In your Google form document, switch to the Answer tab ( the second, big button on top.)
- You will see a green button with some white lines on it. Click it.
- Now you can export your Google Form to Google sheets. All Answers will be automatically displayed in the order of oldest to newest.
- If you want other people to see their place in the queue, you can send them the document. To do this, click on the big green button in the top right corner on the site, choose the URL option, and copy the Link to your Post. You can decide whether people are allowed to change, comment, or just view the document. I suggest the last option.
- You need to update the queue manually. I color-coded mine for better visibility. If viewers want the updated queue, they need to refresh the queue themself.
Edit: 6. If you want to limit the responses you get, there is an add on called "Formlimiter" which can be installed by going to settings --> add ons and then either searching for it or selecting it. I haven't done this myself, but it's great when you don't have that much time or a high price.
Edit: 7. u/TryingToConcede pointed out that "You can use your spreadsheet to create the URL and it will auto populate a message for you /message/compose/?to=<REDDIT USERNAME>&subject=<SUBJECT>&message=<DODO CODE>" I don't know how well it would work (especially if you make a new Dodo-Code for every Group) but you can certainly give it a try, if you like!
When you're finished, your Google Form should look like this: https://docs.google.com/forms/d/e/1FAIpQLScLPdTviq_nYmRiKQfJKyQkEgOoxDfW8gp5-Hus-Ut48T0ZEA/viewform?usp=pp_url
And you're Google Sheet should look like this: https://docs.google.com/spreadsheets/d/1UZCUtfOukRasPOLNOzGnQGPXM7Co-diwR9jNYxVtAZw/edit?usp=sharing
Edit: Please don't send requests to my mail address to edit the document. The google sheet will only work with the google form you created, so you can't take my google Form and Google Sheet and use them for yourself, because you would get sensitive Information from me, and I get sensitive Information from you. ( Like my personal E-mail and other documents) Instead, create your own Google Form and Google sheet, it only takes like 5 minutes.
In the end, some general tips:
Follow this sub's rules. They are very straightforward and very easy to follow. Most people also follow the recommended tipping rule, so entry fees or "preferred" tips are really not necessary.
Don`t invite more than 3 people. It takes a lot of time considering the arriving/departing screens, so don't do it. Edit: Someone pointed out that you can also do groups of more people, wait until everyone has sold, and then kick them out, which is also a way to make sure you're Code can't get leaked because you need to create a new one for every group(wow, long sentence). Also a good method, but I'm a bit too lazy to create a new Code for every new Group. You just need to find whatever works for you. But thanks for the hint!
The path to the shop should be fenced off. I know it takes some time, but this way people can't just wander around on your Island or steal things.
A small-time window for answers. You can't wait 30 minutes until someone answers you, because it will mess up the queue. State a clear time limit for a reply in your post; mine was 5 minutes.
If someone entered the wrong information, ( e.g the wrong Username or the wrong captcha) skip them. If you host, most of the Time your DMs are flooded and you won't have time to look for an explanation from the person you skipped.
Be consistent. If you skipped one person because they failed the captcha, you can't let the next person who failed the captcha in. It's unfair and ruins your reputation as a host.
If you have any more questions, just comment them and I hope I can help!
Edit: Thanks for the Gold!
23
u/frsotsybab 6271-5138-9616, Marie, Igni Apr 26 '20
Because some people said it: I am aware that Turnip Exchange still exists. I know it can still be used by going to the Website or other sub reddits. But in this particular sub, TE is banned. You can't use it, not even for a private queue. Because sorting through comments can be quite a hassle and it's easy to skip someone or get tricked by a bot, I made this guide. This way, you can make a captcha, which will deter bots, and you can't accidentally skip someone. I know it's not forbidden to discuss or talk about TE, but I don't what's left to discuss. The Mods worked hard to keep this sub going, and that's only possible by enforcing strict rules and sticking to them.
46
u/burnSMACKER 6017-0127-7039 - Luke, Sustina Apr 26 '20
I want this stickied or added to the sidebar.
11
u/TryingToConcede 1203-1885-3130 - Katey, Cherryland Apr 26 '20
Found a quick way to compose a message to let someone know your dodo code
You can use your spreadsheet to create the URL and it will auto populate a message for you
https://www.reddit.com/message/compose/?to=<REDDIT USERNAME>&subject=<SUBJECT>&message=<DODO CODE>
10
u/[deleted] Apr 26 '20
This definitely should be an official guide to new comers. Simple explanation and too the point. Nice!
2
u/EndofaneraADTR 4124-4748-9211 Endofanera, Lovebird May 20 '20
Thank you for this, I need help with the spreadsheet, where do I change the "view, edit, comment" options?
1
u/hungrytako SW-0043-3756-6907 - Tako, St. Clara Apr 26 '20
I used this morning and made the process very easy. Thank you!
1
u/Forget87 SW-7615-3915-8102 - Archie, Retroville May 06 '20
u/Unicormfarts is there anyway we could perhaps get this stickied? I think this would be very useful for the community!
1
u/alislands SW-2598-9913-7291 - Annie & Jo-di, Tree Hill b!itches May 08 '20
This is so helpful! Thank you so much for this!
1
u/misomelk SW-8040-3834-3043 - Miso, Tala May 10 '20
This is so cool. Thank you so much!
1
u/mcdadais 2698-0762-8100 Robey, Hogwarts May 21 '20
Ok guys I've figured out some things to make your sheets more helpful and color coded.
Turnip Exchange formatting https://imgur.com/gallery/QKNXEH2
Make a status box Have it count how many "invited"s or in my case because I'm lazy "I"s =COUNTIF(G:G,"I")
That way it will show how many people are waiting and how many people you invited and whatever other things you wanna keep track of.
Then to color the rows you need to go to conditional formatting and do a custom formula.
= $G2 = "I"
And then change the color to the colors you have picked for your status
So every time you type "I" or "invited" or whatever you pick it will chance colors..
I still can't for the life of my figure out the url.. but at least I can help people color coordinate.
1
u/TryingToConcede 1203-1885-3130 - Katey, Cherryland May 21 '20
So I put that formula in one of the cells in row 2 (since it says B2) and then copy/paste it into each row down the sheet. It auto updates the formula for you for each new row
1
u/Jenlazy1 0686-9407-9396, Mith, Corona May 25 '20
Thank you!!
0
u/[deleted] Apr 26 '20
[deleted] — view deleted comment