ExploreEducationHow do I build?ToolsComponent libraryDiscuss

Running a community of 700+ people from Airtable

Lorenzo Castro
posted on
February 21, 2020
challenge

At The Family we help 700+ european founders (~250 startups) to grow their businesses by helping them make decisions faster, avoid mistakes done by others, and by connecting them to a larger network of investors & partners.

We run our community on Slack, but "offline" events are also a big part of our culture. We use Airtable to automate and track all processes related to this.

Our base is quite complex, so I've attached screenshots for clarity, but had to cut some parts of those as they contain sensitive information (Screenshots here)

 

Here are some of my favorite features:

- I can fill out all the information about a company (name, url) and its founders (names, emails, topics they take care of) and then change the company's status to LIVE, and it triggers a workflow that will create a private channel in slack, with the company's name as the channel's name, url as description, and also create accounts for all founders, as well as add them to the correct channels (private company channel + 1 public channel per topic). Channel ID + Slack ID get sent back to webflow so that I can use that later on for more automation 

- I've also embedded a card view of Companies in our community platform (built on webflow) so that our startups can search/filter to find other startups. That platform has a passwordless auth system built using firebase, which uses Airtable's API to check if the email used to sign in is on the 'Founders' table to know whether to let them in or not.

- I can make a list of people to invite to events, which triggers a workflow that sends personalised invites in DMs on Slack, and RSVPs are automatically sent back to Airtable

- we have a "No founder left behind" tool (that we had to custom build because Slack "analytics" are terrible) which uses our team members' slack tokens to check how many interactions we have with founders every day, which gets sent back to Airtable (the D-0, D-1 D-2... fields) and see if someone recently onboarded is being forgotten

Some of these required a bit of code to build, but we don't have developers in-house and limited budget (we already pay for a lot of SaaS subscriptions ) so I've done my best to keep the code as simple as possible. Big shout out to the simplifier.eu team for making most of this possible, most of our workflows run on there.

Go to link

Answers

Users who've remixed this project

Responses to the challenge

Submit your project to this challenge

Only PRO members can enter challenges. Come join us today
Thank you! Your submission has been received!
Head back to your profile to see the post.
Oops! Something went wrong while submitting the form.

Remix this project

Only PRO members can remix and post projects. Remixing is a way to use the same tools, copy + edit the functionality and/or show off what you can do with a similar system. Come join us today
What is a remix? When you remix a project on Makerpad, you’re submitting a project that relates to an existing project. You're trying to use the same Tools, copy and edit the functionality in new ways and/or show off what you can do with a similar system. So for example, the community submits a number of projects that are examples of doing specific things without code that you can remix to get started with your own projects. Currently there's no functionality for cloning the existing projects.
Thank you! Your submission has been received!
Head back to your profile to see the post.
Oops! Something went wrong while submitting the form.

Answer this question

Only PRO members can ask and answer questions. Come join us today
Please make your answers specific to the problem. Provide an image, link and/or video links to help solve the question.
Thank you! Your submission has been received!
Head back to your profile to see the post.
Oops! Something went wrong while submitting the form.