and the data would populate like so (each return is a new row):
Morgan Dawn | Y | your-vid-name | etc Unknown | N | another-vid-name | etc Mary Sue Lamb | N | another-vid-name | etc
and you're probably not gonna like this, but to handle multiple guesses, the best way to do it is to create a new row for each guess, with only the vidder name being different.
That's not intuitive, because it feels like it's redundant--and if you're only ever gonna be using this for personal use and only reading it with your eyes, then you don't have to--but if this is ever going to grow or be used as an actual database, then it's best to do it that way. I call it 'machine readable' -- it's called first normal form.
In an actual database, you'd want to do this and attach a unique identifying number to every vid name and every vidder name.
Doing it like that will also help you set up pivot tables, where you can condense info and sort quickly.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
branchandroot
(no subject)
Date: 2017-09-17 05:05 am (UTC)Vidder Name | Confirmed (y/n) | Name of Vid | etc
and the data would populate like so (each return is a new row):
Morgan Dawn | Y | your-vid-name | etc
Unknown | N | another-vid-name | etc
Mary Sue Lamb | N | another-vid-name | etc
and you're probably not gonna like this, but to handle multiple guesses, the best way to do it is to create a new row for each guess, with only the vidder name being different.
That's not intuitive, because it feels like it's redundant--and if you're only ever gonna be using this for personal use and only reading it with your eyes, then you don't have to--but if this is ever going to grow or be used as an actual database, then it's best to do it that way. I call it 'machine readable' -- it's called first normal form.
In an actual database, you'd want to do this and attach a unique identifying number to every vid name and every vidder name.
Doing it like that will also help you set up pivot tables, where you can condense info and sort quickly.