Tads [VAM] Look-A-Pedia

[PRES1DENT]

I think she's Mil Bob Brow
View attachment 5390118

Done, thanks.

What would be your ideal column order preference?

 

[_lp52_]

Done, thanks.

What would be your ideal column order preference?

I like the timestamp being 1st column, I often just open the sheet and look at the timestamp to see if anyone added anything. As is it right now all I need is visible, I dont have to scroll horizontally for anything. I dont use the VAR File names personally I dont mind if it's further back. I just wish that the sheet can fetch and show the thumbnail image when I hover over the hub link haha.

Btw these two are swapped

 

[PRES1DENT]

Yeah... you can't make an embeded sheet go fetch a thumbnail on hover in Google Apps Script. It does this in the sheet itself, but not in the app page.

The way around it would be to make a hovering button that you can click on and make it fetch that thumbnail, or a separate button outside the sheet, like somewhere around the form grid. But that makes it harder than just clicking on the link itself, doesn't it?

Maybe it will be possible in the future when I'll have time to move all this to github pages.

 

[_lp52_]

Yeah anything that needs even one click would be less beneficial than clicking on the link itself.

 

[PRES1DENT]

Also, not sure if helping or not, but just in case, I chose the colours with the Dark Reader extension in mind.

Think it looks much nicer, but of course, colours are just personal preference.

 

[Austin Powers Shagadelic]

Don't worry about errors, I am actually happy people use it.

Thank you for your ideas, I am also thinking about an edit solution, but here are the issues so far:

• If I make it publicly editable, then the sheet might get improved, but it might also get spammed, deleted, etc. At the moment, if someone adds (they can't edit) 500 spam rows, I can just select them all and delete in one go. But if someone edits a lot in spite, then it's harder.
  I was thinking to leave this one as it is, and make a copy of it publicly editable, like a safety buffer, with newly edited rows coming to the top like here, but it would involve quite a disproportionate procedure in terms of user experience, checking, approving and coding. So at least for now, since there aren't that many submissions anyway, it doesn't make a lot of sense to complicate things.
  If you make a typo or forget to add something, just submit the row again and I will see it doubled at the top, no worries.
  If you want to make an edit to an existing row that's lower down, again, submit the whole row again, and put something like "EDIT - *thislookslike*" in the This Looks Like form and then I will check it.
• And it doesn't seem like blocking from adding the same URL is a good idea because sometimes there are more than 1 looks in 1 resourse, like
  You must be registered to see the links
  there are 4.

If you have an idea, just let me know.

yea definitely don't make it public, my sheet got deleted I assume because it got spammed, filled with trash or reported, or all 3

 

[PRES1DENT]

yea definitely don't make it public, my sheet got deleted I assume because it got spammed, filled with trash or reported, or all 3

Oh, wow, thank you. Made several backups on different cloud services thanks to you.

 

[Nulixir]

im having trouble flitering stuff

 

[lolnibba]

Danielle Fishel (Topanga in Boy Meets World)

1. TvIRL - Boy Meets Hoe
   You must be registered to see the links
2. Daniell F - Dr.Vamenstein

 

[PRES1DENT]

Danielle Fishel (Topanga in Boy Meets World)

1. TvIRL - Boy Meets Hoe
   You must be registered to see the links
2. Daniell F - Dr.Vamenstein

Go to the OP, click the big link, paste

You must be registered to see the links

in the Hub Link box, wait 2 seconds and scraper autofills everything for you, type "Danielle Fishel" as I see this would be the first entry, type "lolnibba" in the By box, press Submit.

im having trouble flitering stuff

Let me know if the spoiler from the first post helps you, and if not, tell me where you get stuck.

 

[JoeEveryPerson]

Spoiler: Wrestlers

You don't have permission to view the spoiler content. Log in or register now.

These are the not super obvious ones I was able to identify, if there are more out there that I know are wrestlers I can identify them most likely.

 

[PRES1DENT]

Spoiler: Wrestlers

You don't have permission to view the spoiler content. Log in or register now.

These are the not super obvious ones I was able to identify, there are more out there that I know are wrestlers I can identify them most likely.

By the way, you might already know this, but you can add those yourself too, if you want. Just thought it might save you the time formatting the links.

 

[JoeEveryPerson]

By the way, you might already know this, but you can add those yourself too, if you want. Just thought it might save you the time formatting the links.

Got it, anything I can identify I'll add them when able.

 

[PRES1DENT]

2000 looks, y'all... yay...

 

[_lp52_]

PRES1DENT Would you please rename Jan Won-young to the one above? Just to follow the "singer [group]" nomenclature. Thank you

 

[PRES1DENT]

Renamed to "personal Google page name" [band/video game]

 

[shiyota]

Suggestion: Influencer category? I feel like there's a distinction between proper celebrities (actors, musicians, etc) and people who are famous on the internet but not necessarily NSFW. Streamers, IG models, etc fall into this category.

 

[PRES1DENT]

Suggestion: Influencer category? I feel like there's a distinction between proper celebrities (actors, musicians, etc) and people who are famous on the internet but not necessarily NSFW. Streamers, IG models, etc fall into this category.

Oh yeah, welcome to my world.

I think what you're trying to say is "make categories like this:
- SFW Celebs
- NSFW Celebs
- SFW Internet People
- NSFW Internet People"

The thing is different people have different personal limits.

SFW->NSFW and Celebs->Internet People are not categories, they are spectrums. And many people fall in between or encompass two or more.

Spoiler: Explanation With Examples So Long I Had to Put It in a Spoiler

You don't have permission to view the spoiler content. Log in or register now.

Unless you have a good idea that's gonna work for all celebrities long term, I'm thinking to just categorize them in Real People and Fictional Characters pretty soon.

My personal conclusion is (but please contradict me) categorizing sucks because not 1 person is 1 thing only.

Tags would be ideal for this, but don't know a good idea to implement them in a Google sheet. Maybe I'm gonna move it soon to GitHub Pages and would be doable, easy to implement and use there.

But, if you think about it, categories don't even matter that much. You just filter by Creator, This Looks Like and that's it.

Sorry if I wrote too much or if I sound condescending, but this question keeps bugging me since I started Look-A-Pedia and sometimes I researched a person whom I've never heard of before for way too long.

 

[shiyota]

I totally get the issues with managing categorization, and at the end of the day I really do appreciate you putting this together. I guess for me the roles are assigned by what people primarily are known for. Yeah there's a spectrum of NSFW-SFW but I would say the best way to distinguish that is based on that individual's brand.

Spoiler: My thoughts on the listed examples

You don't have permission to view the spoiler content. Log in or register now.

Many people have multiple "lives" and there are always going to be shades of grey.

Plus, what they do now, they might not do tomorrow. So you should change categories over time because "now they're better known as"

Unless you have a good idea that's gonna work for all celebrities long term, I'm thinking to just categorize them in Real People and Fictional Characters pretty soon.

My personal conclusion is (but please contradict me) categorizing sucks because not 1 person is 1 thing only.

There are always going to be shades of grey, but I do think we can at least categorize them as "light grey" or "dark grey", so to speak. ofc there's some room for interpretation but they way I see it, one's category is again dependent on how they brand themselves and where their audience comes from. You can see some of my thought processes in the examples above and I think those are reasonable.

Tags would be ideal for this, but don't know a good idea to implement them in a Google sheet. Maybe I'm gonna move it soon to GitHub Pages and would be doable, easy to implement and use there.

But, if you think about it, categories don't even matter that much. You just filter by Creator, This Looks Like and that's it.

Sorry if I wrote too much or if I sound condescending, but this question keeps bugging me since I started Look-A-Pedia and sometimes I researched a person whom I've never heard of before for way too long.

You don't sound condescending at all, and again I appreciate how much thought and work you put into this project. I'm just happy to offer feedback and help improve the gooning experience for all of us

 

[PRES1DENT]

OK, will do it your way if you're willing to hand a list of proposed changes. The hardest thing for me was to research internet thots I never cared about, and decide if they are NSFW enough or not.

Categorizing them is better than dumping them into 1 Real, of course, and If someone is willing to hand a ready list, then I'll change the code and then just filter the "This Looks Like" column by what you propose, select all and paste new value and replace, GG EZ.

Just let me know if the above categories are ok for you, the 2xSFW and 2xNSFW, or if you have a better idea.

And, of course, if you don't have the time to write propositions and only made an improvement suggestion, that's fine too, I get that there are better priorities in life than VAM.