Discord Leaderboard - Powered by Airtable
Everyone wants their Discord server to be as engaged as possible, but sometimes it's difficult to know how to encourage activity. This plug-and-play leaderboard app is designed to make it as easy as possible to add a scoreboard to your Discord server. By default, users earn points for sending messages, adding reactions and creating threads, although you can modify the project to award points for almost any action.
/scoreboard command (automatically setup when you install this app) which shows your top 10 members and links to a web-based leaderboard
- Leaderboard website showing your full rankings, which is automatically deployed when this app is installed
- Automatic points tracking - you don't have to do anything manually!
- Scoreboard automatically updates hourly
- How many requests will this app use if I install it?
- This app is quite request intensive, as we use endpoints such as
message.create (which runs every time anyone sends a message on your Discord server) to award users points. We recommend updating to a paid Autocode plan if you're planning to use this project on a large server.
- Is this app suitable for large servers?
- In general, yes! This app is provided as a starting point, so you might want to add some optimisations if you have many members - such as modifying how often the scheduler runs, or adding pagination to the scoreboard website. However, these are quality of life changes and shouldn't strictly be neccesary.
- Can I modify how many points a user gets for each action? Can I modify the cap of how many actions count per scheduler run?
- Yup! Just modify the values in
- Where can I learn more about building Discord bots?
You will need
Setting up the Airtable template
- Visit this link and click
- Select the workspace that you want to install the base into, then click
- Open the base that was just created from the template by clicking on it.
- We'll need the base's ID in the next part of this guide, so copy it down for safe keeping. The base ID is the characters between the first two slashes in the base's URL that begin with app. In the example below, the base ID is
Awesome - our Airtable template is all setup and ready to go! Now let's install our Autocode app.
Setting up the Autocode project
- Scroll up on this page and click the green
Install Free button.
- Select the organization you'd like to install this app into, give your project a name, then click
- For each account type (Airtable and Discord), click
Link New Resource. Then follow the instructions in the window that pops up.
- You should ensure you link to the same Airtable account that you duplicated the base onto
- Once you've finished linking all the required resources, your page should look like the screenshot below. Once it does, click the
Nearly there! We now need to set some environment variables
- KV Prefix - we'll prefix all KV names with this value for internal purposes. This allows you to run multiple instances of this app on one Autocode account. If you're not sure what to set this to, and you've not already installed this app, use
- Airtable Base ID - the base ID, beginning with
app, that you copied earlier in this tutorial.
- Discord Guild ID - the ID of your Discord server. To find this, right click your server's icon with Developer Mode enabled and click
Awesome, your app is now installed! You should now be able to use
/scoreboard on your Discord server!
Modifying points values
The settings for this project are stored in
/helpers/config.json. For each event type (
THREADCREATED) there is a
points value is the number of points a user gets each time they complete the action. For example, if
MESSAGESENT's points is set to 2, the user will get two points for each message they send.
limit value is the maximum number of events of that type that counts towards earning points per scheduler run. In simpler terms, if the scheduler is set to run hourly and
MESSAGESENT's limit is set to 10, only the first ten messages every hour will earn points. Think of this as an anti-spam measure to avoid users being awarded for spammy behaviour.
You can also add your own events that earn points to this app. Simply copy the code inside
/functions/events/discord/message/create.js into a new file, set that file's event trigger to be whatever you want to earn points, then replace
context.params.event.author.id with whatever value contains the user's Discord ID. You should then replace
MESSAGESENT with a unique identifier for this event, then add that event's settings (points and limit) to