Playing with the Jalopnik Rides sheet and Google forms - input needed.

"JustWaitingForAMate" (justwaitingforamate)
12/27/2013 at 21:58 • Filed to: None

Ignore my sentence structure and grammar, this is stream of conciousness writing when I'm in developer mode.

So I've set up a Google form for input, pinched a couple of questions from the Jalop car points game sheet and protected the spreadsheet so it can be viewed but not edited.

The 'View Summary' link shows a bunch of graphs that are built from the drop down list inputs. I haven't managed to find a way to block the text inputs from showing on that summary, so it could get messy over time. To counter that, it's quite easy to remove the summary view link and move all the graphs into a new sheet in the spreadsheet, also gives the option of creating graphs/charts from text inputs which the summary page doesn't seem to be able to do.

No way to upload images yet without crazy coding and formatting, It would more then likely end up as a large batch of images at the end of the summary. To get around this, you could potentially upload images to imgur then drop the link in the 'comment' section, users could then click it directly from there.

I've left Countries as a simple text box for the moment as I have to manually input each one, as for the years, and models etc, since it looks like the form can't read a list of values from a linked spreadsheet.

The 'year of manufacture' summary chart is broken, not sure why, could be the 100+ segments it's trying to calculate, I may shrink that to the 1940s to Today range, I'm guessing most Jalops don't have a car that old.

So dear readers, what you can do at the moment is click on that link, poke around, throw some data in, see what I'm missing, leave comments either here or in the comment section of the sheet.

I'll look to extracting the old data from the original ride sheet and dump it into the new one.

Just remember : THIS ISN'T OFFICIAL YET, STILL SPIT BALLING IDEAS FOR STRUCTURE.

At the moment this is just a test sheet, I'm trying to get back user input, so if you ping me here, I'll make edits and update data you've punched in.

It's a pity something like this can't live under the Gawker roof and use our gawker logins or allow it to be added to our profiles then collate all the data in a nice format.

If any of the Jalop writers are listening, is something like that possible?

Oh and I removed the current celebrity crush column, since the only answer is Jennifer Lawrence.

Updates -

Make and Model switched correctly.

Europe added.

Buick Added.

Transmission 'Other' option added.

Transmission 'Other' text field added.

MA added to states.

DISCUSSION (41)

IDROVEAPICKUPTRUCK > JustWaitingForAMate
12/27/2013 at 22:02

You've got make and model reversed.

TheLOUDMUSIC- Put it in H! > JustWaitingForAMate
12/27/2013 at 22:02

Make and model are switched.

Laird Andrew Neby Bradleigh > JustWaitingForAMate
12/27/2013 at 22:08

Say what? J. Lawrence only? But. . But... Whattabout MEW? Other than that, looks kinda cool.

edit: can't find Europe..

Alex Murel > JustWaitingForAMate
12/27/2013 at 22:11

Good choice with the celeb.

Luke's Dad Sold His 2000TL To Get a Sienna > JustWaitingForAMate
12/27/2013 at 22:12

I MUST SEE THAT si-R ACCORD CLONE.

Brian Silvestro > JustWaitingForAMate
12/27/2013 at 22:13

If I want to edit my addition (forgot my dream car), how would I go about doing that?

JustWaitingForAMate > Brian Silvestro
12/27/2013 at 22:19

On the page that appears after you submit, there is an 'edit my response'. All the links that you click from that page (view summary, view all results) should pop up in new windows/tabs, so you can always click 'edit my response'.

If you close the window, there's no return, unless you have the post submit page cached.

Only way I've found to get around this is to submit a new line with an ERROR or EDIT comment and have an administrator add the value you want, or, submit a new line with all the correct details, leave an ERROR or EDIT note saying delete row X in the table, X being the original line.

This is the trade off with having everyone input data into the sheet manually, and potentially delete stuff they shouldn't, or having it protected via the google form.

Dusty Ventures > Laird Andrew Neby Bradleigh
12/27/2013 at 22:21

Also, having just watched The Wolverine, Tao Okamoto

Kinja'd!!!

JustWaitingForAMate > TheLOUDMUSIC- Put it in H!
12/27/2013 at 22:21

fixed

JustWaitingForAMate > IDROVEAPICKUPTRUCK
12/27/2013 at 22:21

fixed

JustWaitingForAMate > Laird Andrew Neby Bradleigh
12/27/2013 at 22:22

Fixed.

I'll do each country in a drop down when I summon up the nerve to punch in all 100+ by hand.

Brian Silvestro > JustWaitingForAMate
12/27/2013 at 22:22

Damn! I closed the window unfortunately. I'll just submit an entire new line and tell an administrator to delete my original one.

JustWaitingForAMate > Brian Silvestro
12/27/2013 at 22:31

I'll add some text blurb to the top of the form with instructions, or any gotcha's I've found.

Dusty Ventures > JustWaitingForAMate
12/27/2013 at 22:31

I need an "other" selection on the transmission

iDriveCode3 > JustWaitingForAMate
12/27/2013 at 22:31

Nicely done! Can't wait to see more results.

Dusty Ventures > JustWaitingForAMate
12/27/2013 at 22:33

Also in the US state selection dropdown you're missing Massachusetts (MA)

JustWaitingForAMate > Dusty Ventures
12/27/2013 at 22:33

'Other' added as a choice, want a second text column after it to specify exactly what you have?

Spaceball-Two > Dusty Ventures
12/27/2013 at 22:33

Pedals or bus pass?

Dusty Ventures > JustWaitingForAMate
12/27/2013 at 22:34

Sounds good to me

Dusty Ventures > Spaceball-Two
12/27/2013 at 22:36

Automatic with a manual valve body. In other words technically an automatic but is shifted manually. Which is awesome because it means no lifting on upshifts. Downshifts are a bit rough though, especially second to first.

JustWaitingForAMate > Dusty Ventures
12/27/2013 at 22:37

Added. It's appearing at the end of the table, I'll do a shuffle of columns later on to match the order in the form.

cuts_off_prius > Luke's Dad Sold His 2000TL To Get a Sienna
12/27/2013 at 22:38

Kinja'd!!!

Not lowered anymore. Signals are out due to condensation. But my window trim is now black like the SiR/VTS lol. 66k miles. Giving to my lil' brother soon.

JustWaitingForAMate > Dusty Ventures
12/27/2013 at 22:39

fixed.

Spaceball-Two > Dusty Ventures
12/27/2013 at 22:41

Nice! Miss the Cady ?

ddavidn > JustWaitingForAMate
12/27/2013 at 22:41

Hey I had Grumpy Cat as my celebrity crush. Not that I'd turn down Jenny if my wife didn't exist.

Dusty Ventures > Spaceball-Two
12/27/2013 at 22:42

What Cady?

Spaceball-Two > Dusty Ventures
12/27/2013 at 22:57

My apologies I thought for some reason you just parted with a Cadillac wagon.

TyFc3s-A car hating millennial > JustWaitingForAMate
12/27/2013 at 23:06

I just posted my car, and ill admit, i jumped the gun a bit, none of the modifications have been done yet, but will be in the next month (I swear!) if not, ill fix it then

DancesWithRotors - Driving Insightfully > JustWaitingForAMate
12/27/2013 at 23:08

Who are the other two that have owned 2001 S60s on the list? (Not judging, even if it was the car that chased me away from Volvos...)

JustWaitingForAMate > DancesWithRotors - Driving Insightfully
12/27/2013 at 23:14

If you go to the spreadsheet from the link on the form page and do a CTRL+F and punch in S60 you'll find them.

It will actually highlight all the cells in the sheet with S60 in them.

DancesWithRotors - Driving Insightfully > JustWaitingForAMate
12/27/2013 at 23:17

Looks like it was one user, who had two entries...

Same guy has a 16V 242... I may need to change my entry on the dream car list, now.

bhardoin > JustWaitingForAMate
12/27/2013 at 23:19

you done good.

Dusty Ventures > JustWaitingForAMate
12/27/2013 at 23:44

I assume you have editing abilities on the spreadsheet? I forgot our F-350 has a turbo and listed it as Naturally Aspirated.

Stef Schrader > JustWaitingForAMate
12/27/2013 at 23:48

Whoever submits Flat-12 as their engine is my new best friend.

(The Coupe Quattro is pinging my best-friend-o-meter right now, though.)

JustWaitingForAMate > Dusty Ventures
12/27/2013 at 23:51

edited.

Dusty Ventures > JustWaitingForAMate
12/28/2013 at 01:01

Cheers :)

Scary__goongala! > JustWaitingForAMate
12/28/2013 at 01:01

Country I live in?....Murica

71MGBGT Likes Subarus of Unusual Colors > JustWaitingForAMate
12/28/2013 at 02:49

Thanks for doing this. I would really like to see everyone (or at least a lot of people) fill it out

Bird > JustWaitingForAMate
01/01/2014 at 00:46

Is it possible to access an older version? Both mine and Ferrero1911's entties are gone...

JustWaitingForAMate > Bird
01/01/2014 at 00:54

I can see your and Ferrero1911's entries in the old sheet .

Check this post on how to update what's there, and I'll import it into the new sheet.

!!! UNKNOWN CONTENT TYPE !!!

Bird > JustWaitingForAMate
01/01/2014 at 01:08

Oh...I'm sorry. I'm confused.

We'll check out that post and do the update.