Guides

I think I got everyone on there (that was old enough, haha)! Hope that helps you out! c: I think it's super neat.

So.quick update: I haven't been able to update the master sheet yesterday or today but I will tomorrow! Though it'll probably be around 5ish FR time

I think one of the fae on the master sheet has an error? Lamia (ID 51281857) was entered with a length of 0.

@Stelaris

Thanks for telling me, I'll fix that tonight

Added my data. Thanks for doing this, I think it's pretty neat.

So, a small update: I'm currently on mobile, and for some reason this goofy tablet won't let me edit google docs. I have to find a keyboard to set up the computer again, so it may be a couple days until I manage to update the master sheet. Thank you everyone for entering your dragons! I'm checking in, and promise to update the master sheet as soon as I am able!

[center]Hi @Ketchalin Congrats on undertaking this awaited renewal! Sampling stats & visuals is so delightful for lore addicts to indulge in [emoji=gaoler star size=1] I have a couple suggestions for optimizing your census: [b]Idea N°1[/b][/center] Instead of having submitters manually link every entry, you could use this formula: [indent][color=grey]=HYPERLINK("http://flightrising.com/main.php?dragon="&[color=purple]B:B[/color],"[color=green]Caption[/color]")[/color][/indent] So submitting the Dragon [b]ID#[/b] in the [color=purple][b]B[/b] column[/color] automatically fills in the dragon's [u]permalink[/u] under a preset [color=green]Caption[/color] [size=2](e.g. Lair, Profile, Visit, Check me out, ...)[/size] [b]Pros:[/b][LIST] [*]Less of a hassle for everybody: [*]100% directly available data for easy verifications [*]Links won't ever break when dragons move lair or exalt themselves [emoji=gaoler tongue size=1][/LIST] [b]Cons:[/b] [size=2][i]I'm no coder so I may just have missed it but...[/i][/size] Can't apply formula to a whole column and at the same time allow text to be input afterward to customize each cell's hyperlink; so it's not possible to combine the feature with the [i]Name[/i] [b]G[/b] column -there'll have to be a separate one. [size=2] In that regard, with the basic [i]lair-untied[/i] permalinks, the [i]Lair #[/i] [b]A[/b] column becomes quite needless so you could retask it for this purpose! Otherwise, if you'd rather keep it, fortunately, there's already space in the [b]H[/b] column so there wouldn't be any rearrangement needed.[/size] To implement, input the formula directly into the [u]column [b]n[color=brown]*[/color]1[/b] [i]title[/i] cell[/u]: [size=2][color=brown]*[/color][i]n[/i] designates a non-specific column, yours to elect (e.g. [i]Lair #[/i] A or H column)[/size] [indent][color=grey]=[color=#060AA3]ARRAYFORMULA([color=teal]IFS([b]ROW[/b](B:B)=[b]1[/b],"[color=#2495D5]Title[/color]"[/color][/color],[color=teal]IS[b]NUMBER[/b](B:B)[/color],[i]HYPERLINK("[color=blue]http://flightrising.com/main.php?dragon=[/color]"&[color=purple]B:B[/color],"[color=green]Caption[/color]")[/i],[color=teal]ISBLANK(B:B),[b]""[/b])[color=#060AA3])[/color][/color][/color][/indent] It'll apply the hyperlink formula to the [color=#060AA3]whole column[/color] -but the [color=teal][b]n1[/b] title cell[/color] that'll feature your choice [color=#2495D5]title[/color] instead, and display the [color=grey]links[/color] for rows with [color=teal]Dragon [b]#ID[/b][/color] or [color=teal]leave [b]blanks[/b][/color] otherwise. [size=2]If you do decide to overwrite the [i]Lair #[/i] [b]A[/b] column, delete everything inside first or the old entries will retain priority and the formula won't apply.[/size] [i]Probably best to [b]lock [/b]the [b]n column[/b] to ensure the formula isn't tampered with.[/i] [emoji=bogsneak scared] [size=2]Click the [b]column header[/b] [i]right arrow menu[/i] then [u]Protect Range[/u]: [color=grey][i]SheetName[/i]![b]n:n[/b][/color] [right][size=2](Set Permissions to Only you.)[/right] [center][b]Idea N°2:[/b] Enact [u]Data Validation[/u] in the [i]Gender[/i] [b]F[/b] column with a Male/Female [b]drop-down list[/b] -submissions will run even smoother with caps lock toggled all the way but for the names. [size=2]Or maybe it's just me driving myself crazy juggling, typing whole series of punctuation marks instead of numbers, undoing, repeating the same mistake, ...[emoji=bogsneak deadpan][/size][/center] To implement, select cell [b]F2[/b] then in [u]Data Menu: Data Validation[/u]: [LIST] [*]Cell Range: [i]SheetName[/i]![b]F2:F[/b] [*]Criteria: [u]List elements[/u] > Female,Male [*]Toggle on [u]Show drop-down list in cell[/u] [*][size=2]Toggle on Reject input on invalid data if you care [*][size=2]Toggle on Show validation help text, if you'd like to detail instructions upon hovering the cursor over the cell (e.g. "Select non-lore game-generated gender")[/LIST] [color=grey]Just in case to save you some trouble, the very neat function that would allow you to [b]group[/b] all sheets & edit them all together...[b]is not an available feature on Google Docs.[/b] So that's a bit of a manual repeat, but you can simply edit on any first sheet, then: [LIST] [*][color=grey][u]Select + Ctrl C[/u] the [b]n/ F column headers[/b] [*][color=grey][u]Special-Paste[/u] respectively [i]formula/ data validation only[/i] over every other sheet's n/ F column headers.[/LIST] [size=2]Don't forget to [b]lock[/b] the [i]n[/i] [u]column[/u] that holds the hyperlink formula on each sheet![/size] [center]In any case, thank you for breathing life back into a tremendous project [emoji=familiar heart] Best of luck with your dreary tablet & keyboard quest [emoji=spiral laughing] Take heart ~[/center]