Austin Allman
These Leaderboards were developed for The Stray Banana which is a community for players of the game Sonic Robo Blast 2 Kart.
These leaderboards are run entirely off of Google Sheets and Google App Script. Runs are submitted through a Google Form to the backend (image 1) where Moderators can type Y to approve or N to reject a run. Once a run is approved it automatically gets populated on the public frontend with no further action required of the Moderator approving the run.
I later added a Google App Script that will notify a mod only channel in the community Discord whenever a run has been submitted. These notifications include a direct link to the row of the submission so moderators don't have to scroll through over 700 records of submissions and if moderators don't review the pending runs it will give a weekly reminder.
(Ignore the "2 months ago" in the 3rd image. This updates automatically based off the timestamp in the notification.)
I later hooked the backend up to an HTML/JS frontend with a layout courtesy of a fellow moderator in the community. The frontend caches the data every time a new record gets approved to massively improve the load times.
With release of Dr. Robotnik's Ring Racers the leaderboards have gotten a complete overhaul complete with parsing of replay files (courtesy of a friend). For the most part the backend is the same but without any of the filtering beyond run approval. All the real work happens on the website which you can read about here.