#Move Aircraft Livery List to Google Sheets

30 messages · Page 1 of 1 (latest)

gentle rose
#

@dapper nova refi had a brilliant idea in creating this aircraft livery list, and it has been a great resource.
i'm just suggesting a small improvement to help realize the idea more efficiently. currently,
the list is manually edited in a google doc, which is well-organized but can be time-consuming to update and manage.

google doc before : https://docs.google.com/document/d/1VIRG8vDKTr_JFOWINSCW9U6fUT6ewytMqUzfIFNJdHM/edit?usp=sharing

structure of the google sheet

the spreadsheet will have three sections:

  1. list reviewed (final list) – a fully reviewed and finalized list.

    • access: only admins can edit; the public can view.

  2. admin sorting (pending review) – a working sheet where admins verify and approve public submissions.

    • access: only admins can edit; the public can view.

  3. submission public (open edits) – a community-driven section where users can submit and update information.

    • access: public can edit.
    • version history ensures changes can be tracked and reverted if necessary.

google sheet after : https://docs.google.com/spreadsheets/d/1yoXsR2r0czPMAy7lBBUY5knsuPTeM5wtPoQdndiIklg/ (example)

why move to google sheets? key benefits ?

  • more efficient data management – easier to update and organize.

  • faster updates – the community can contribute without waiting for manual edits.

  • admin oversight – changes go through a review process before final approval.

  • data integrity – version history prevents accidental data loss.

  • livery tracking – ensures visibility into completed liveries to prevent duplicates.

  • kit availability check – provides clarity on available resources for each aircraft type.

  • improved organization – data is structured in a more accessible format.

  • community collaboration – members can update and submit information directly.

  • edit tracking – if member deleted list in public submission, admin can undo/ rollback in history.

transitioning to google sheets will streamline the process, making it more effective and collaborative for the entire community.

note: key benefit is from gpt and gpt make my word not broken


the list is just to check if a livery is already done or not. there’s no need for an admin to approve every livery in public livery, 
they only confirm if it’s already uploaded on "public livery discord" or not. and put in google sheet,

everyone can still make duplicate liveries like before```
image.png
dapper nova
#

whart

#

i made that list for fun, it's not gonna be used for anything official unless other staff are interested in it

upbeat dust
#

that doc should be enough proof to lock refi up in a mental institution

dapper nova
gentle rose
#

members can update and submit information directly. admin just need to approve, I hope its making admin job easier

upbeat dust
dapper nova
#

if it became an official thing i'd have some sort of way for the public to do something but it's absolutely not official by any means currently

gentle rose
#

your idea was awesome for keeping track of liveries and avoiding duplicates, plus, it helps the community see what’s missing
so they know what to make next.

ripe forge
gentle rose
#

there is 65 pages google docs

image.png
daring steppe
#

Is this for public liveries

#

If so it seems kinda useless

dapper nova
#

indeed, that is what the majority of my pet projects are: useless

daring steppe
#

The system that we already havr for public liveries is good enough

dapper nova
#

even if this stupid project of mine were implemented it wouldn't be replacing anything

#

it'd just be there

#

though this suggestion is already denied anyway

#

unless for some reason someone wants to implement my thing which I doubt anyone would want to

daring steppe
#

It would also be useless in the sense that most admins are kinds busy so youd have to wait ages for your liveries to be accepted

#

And having duplicate liveries is not a bad thing hence one may be lets say more detailed than the other one and yeah

#

And maybe other liveries have something that the others dont

#

Like idk little details

#

Yeah

#

Okay

gentle rose
gentle rose
topaz depot
#

if you can do it yourself, then maybe

gentle rose
#

my brain isn’t built for this level of responsibility