Build a Slack Polling App with Airtable, Standard Library, and Node.js
Whether you’re trying to figure out lunch or which bit of copy sounds best, polls are a simple way to get quick feedback from many people. Slack doesn’t have a native polling solution, but fortunately, with Build on Standard Library and Airtable it’s easy to roll your own. This guide will go step by step through the process of creating a fully customizable polling app, but if you’re just interested in the result, there’s a GitHub repo available where you can deploy a complete version to Build on Standard Library in just a few clicks.
What You’ll Need Beforehand
Step 1: Create your Airtable Base
Part spreadsheet, part database, and entirely flexible, teams use Airtable to organize their work, their way.
Backing your polling system is Airtable, which you can think of as Google Sheets meets a database. The polling app relies on a specific schema. The base has two tables,
Polls has a record of each poll created, and
Votes contains a record of each vote. Votes are limited to one per Slack user per poll. The
Votes tables are linked together, similar to using a foreign key with a SQL database.
Copy this template to your Airtable account by following the link and clicking “Copy base” in the top-right corner of the screen. It’s that simple! You can try interacting with the embedded base below.
Step 2: Start your workflow
Head over to https://build.stdlib.com (Build on Standard Library) to start building your workflow. You are going to start with the Slack command to create polls, so you’ll want to pick the following options:
Slack → command
With this command name… → poll
Airtable → Insert a Row into a Base
Slack → Create a new Message from your Bot
Step 3: Link your Accounts
Standard Library provides the concept of Identities that manage third-party API credentials. Identities allow you to link your Airtable and Slack accounts once and use it with any workflows you build. After clicking “Create Workflow” in the last step, you should see a screen like this:
Step 3a: Linking your Airtable Account
From here, you’ll want to click the Link Resource button to the right of Airtable, and you’ll be prompted with this screen:
If you haven’t linked an Airtable account before you won’t see any bases to choose from. Either way, click “Link New Resource”, and you’ll be prompted with this screen:
To add an Airtable account, you need to set a display name, which we recommend to be the email you used to sign up for Airtable. You also need to copy and paste your API key, which can be found in the Airtable account management page. Once you’ve filled out the required fields, click “Finish”, and you’ll be prompted with this screen:
You’ll be presented with a list of bases that your account has access to. You want to pick the one you copied from the template earlier, which is called “Slack Polls”. Click “Finish”, and you’ll be brought back to the Identities page:
Step 3b: Linking your Slack Account
From here, you’ll want to click the Link Resource button to the right of Slack, and you’ll be prompted with this screen:
If you haven’t linked a Slack account before you won’t see any Slack Apps to choose from. Regardless, click “Link New Resource” and you’ll be presented with detailed instructions on creating your Slack App. Once you’ve finished you’ll be brought back to your, now complete, Identity page:
Click “Next” to continue to the next step, where you’ll be asked to create your slash command:
You’ll be given the command name (which was set when you picked the Slack → Command event) and your Request URL, which should be
<username> is your Standard Library username. Follow the instructions on the page and create your slack command:
Once you’ve created your slash command, click “Next” and you can start to configure your workflow.
Step 4: Configure your Workflow
After clicking “Next” in the previous step, you’ll be prompted with the following:
At the top are the APIs used by this workflow. The first two are automatically added, and they enrich the event data sent by Slack. The second two are the ones you picked when you started building. Click the “Developer Mode” toggle, and you’ll see the code generated for the workflow. Delete the body of the function and replace it with the following code:
This code responds to the slash command by adding a record of it to Airtable and sending a message to Slack. With the new code in place, its time to test it out. Before doing so, you need to edit the test event data by clicking the gear icon next to “Run with Test Event”.
Copy and paste the following for the new test event:
"text": "\"Test poll\" \"Option One\" \"Option Two\"",
Now click “Run with Test Event”, and you should see some logs, a message in Slack, and a new Record in Airtable. Note: The message in Slack won’t be quite complete, because
U00000000 is not a real Slack user id.
Step 5: Ship your Workflow
After running your workflow successfully in the last step, the blue “Next” button on the bottom right should be enabled. Click it to proceed, and you’ll be presented with this screen:
The name of your Project should be automatically generated, along with the filename in which we’ll store our code-based workflow. Click “Alright, Ship it!” to proceed. You’ll see the following prompt:
That’s it! Your workflow is live. Upon clicking “View Project” you’ll be brought to a project management screen.
For now, click “dev (click to manage)” to see your workflow development environment. You’ll see a summary of your workflow project and the API actions it’s taking. Now, from your Slack workspace, you can try creating a poll with
/poll "<question>" "<option>" "<option 2>"! However, people won’t be able to vote on the poll just yet. To fix that you need to add one more handler.
Step 6: Add a new Handler
At this point, you have one endpoint that handles the slash command. However, there is nothing set up for when a user votes. For that, you need to add another handler. From the integrations table, set Slack → interactive_message as the event and click “Add New Workflow”. You’ll be prompted with a familiar screen:
callback_id of the event to
vote and add Airtable → Select Rows by querying a Base to the list of actions. Click “Next” and you’ll be brought to the Identities page. Everything is already linked so just click “Next” again to continue to the workflow configuration page.
Click the “Developer Mode” toggle, and you’ll see the code generated for the workflow. Delete the body of the function and replace it with the following code:
This code responds to the interactive_message event (i.e., a button is clicked) by adding a record of the vote to Airtable and updating the Slack message to reflect the new vote. Now click “Run with Test Event”. You won’t see much, because there is no poll up yet to test voting on.
After running your workflow successfully, the blue “Next” button on the bottom right should be enabled, click it to proceed. You should see a familiar screen:
Click “Alright, Ship it!” to proceed. When it’s finished click “View Project” you’ll be brought to a project management screen. Again, click “dev (click to manage)” to see your workflow development environment. It should now have two endpoints.
With both endpoints up, you can now test out your app. Go to slack and type:
/poll "Test poll" "Option one" "Option two" "Option three"
After a moment you should see a poll pop up in the channel:
Click the numbers to vote for each corresponding option. You can only vote once, but you can switch your vote by picking a second number.
In just a few minutes you set up a Poll App with Airtable, Slack, and Standard Library. As you just saw, you have full control when customizing your workflow with code. You can configure it do just about anything.
Thanks for reading, and happy building! You can follow us for more updates on Twitter at @StdLibHQ or check out our blog, https://stdlib.com/blog for frequent updates. For additional help see our documentation, or join our Slack workspace by visiting https://docs.stdlib.com/ and clicking “Request Slack Community Invitation” on the right.
Steve Meyer is a Software Engineer at Standard Library. When he’s not programming, you can find him maining Yoshi in SSBU.