WTF NO CODE DROP #7

Last time we kicked tires with a drop we were looking to create unique referral codes and urls that effectively let you use an Airtable form to attribute a newly created record in one table to an existing record in another.

There’s a number of things you can create with this sort of functionality and we’ll be looking at something you can use to gather feedback or collect public opinion.

Don’t worry, we’re not veering into politics.

Realistically, this would be fitting for something like a book club or an online community of some sort.

Basically, anytime you want to solicit feedback about an array of items this is what I recommend you do.

The best example to showcase is another banger called Podcast Delivery Reviews. In my case, I engage my newsletter audience to let me know what they think of the podcast I recommend them every week.

I want them do at least one of two things:

1. give the recommended podcast a 5-star rating

2. leave a review about the podcast

This is all done using an Airtable form that’s generated for each of the specific podcasts or records I have in my database.

⇩ There’s more to take in! ⇩
Subscribe for free to WTF NO CODE to continue reading!

• Airtable

Since all of this is contained to Airtable we don’t have to worry about passing URL parameters to a whole other platform – this will all happen with the help of an Airtable Concatenate() formula.

In the end, you end up with two tables:

1. Your primary table with records that you want people to rate or provide feedback for. In our case that’ll be 📰 Newsletter Content.

2. Your ratings table which will end up being populated by each of the form submissions you capture representing the rating or feedback. That’ll be ⭐️ Votes & Ratings.

I hint at this above but once you have the fundamental piece in place – specifically the right formula to generate a unique form for each of the items you want reviewed then it’s a matter of wrapping that in the correct context and ushering people through a two-step process.

My favourite part of it all is that is soooo simple it almost can’t be extended upon too much. One thing you can do pretty easily is setup an Airtable automation to fire off a Slack alert whenever a form is submitted so you can maintain visibility into what people are saying–

Let’s pull it all together.

⇩ There’s more to take in! ⇩
Subscribe to WTF NO CODE Premium to continue reading and to get started with your own template!

Become a paying subscriber of WTF NO CODE PREMIUM to get access to this post and other subscriber-only content.

Already a paying subscriber? Sign In