Gdocs oh gdocs

[coolohoh]

Ok... So I had a bit of free time and decided to do my fanfic masterpost on gdocs.... and then I hit my first roadblock.

Here's the masterpost so far: https://docs.google.com/spreadsheets/d/17zrkZLUWpkvFZLEaul_50EEyuLrzfNFfXvwZqfN2MiI/edit?usp=sharing

Ok...

So...

I initially wanted to just have different sheets for drabbles and one shots... since they are so many pairings...

And you can just sort the pairings using a filter. BUT.

I forgot, some of my fics have multiple pairings. How can I deal with it then? Anyone has any clues?

Besides making a ton of different sheets for each of the pairing. Not sure how user friendly that will end up being. Oh gosh esp on mobile.

Maybe I can't get rid of my masterpost on LJ after all.

And to think that I'd just figured out how to use 'query' too.

Darn.

OR, is there any other tool besides gdocs that I can use?

Comments

[renchan27.livejournal.com]

I generally put both in the pairing box, but i wonder why would you want to make it so complicated? This looks exactly like my excel spreadsheet once I start doing Jade's so it's fine as it is i think... Depends what you're trying to do with it.

[coolohoh]

Yeah... but if I do that, it becomes hard to search fics by pairing ><.

[renchan27.livejournal.com]

True but... Will you ever search your own fics? And if thats the case just nake yourself an order, like all pairings with jun come first and blabla and just do a sort and you'll be fine.

[coolohoh]

Nah, I wanted the gdocs to replace my masterpost on lj, so it'll be for the public...

[renchan27.livejournal.com]

Ah.... I wonder how practical that is... You'll  have to block it to read only, that's for sure. No idea what you can do for the pairings though... Good luck figuring that out XD

[coolohoh]

making it read only is easy enough on gdocs. the link I shared above is read only. but yeah... that... we'll see. Maybe I'll just give up after all... since it's so much trouble to transfer the links over etc... :P