WTF NO CODE DROP #7

How to capture ratings and feedback for specific content

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 NEED

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.

Check it out and give it a try yourself!

The form is accessed via the Cast Your Vote button and, once clicked, you’re taken to an Airtable with prefilled and hidden fields that include information about the podcast you’ve just chosen to rate.

Dropping that gallery onto a landing page by using an HTML embed means you can have something pretty official-looking while using little more than Airtable and some well-placed formulas.

Let’s dive in.

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

THE STACK

THE RESULT

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.

THE EXTENDED VERSION

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!

Subscribe to WTF NO CODE PREMIUM to read the rest.

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

A subscription gets you:
All WTF NO CODE DROPS
WTF NO CODE Slack Access
30 Minute Project Discovery Call
Reduced Project Rates for any Collaboration

Subscribe to keep reading

This content is free, but you must be subscribed to WTF NO CODE to continue reading.

Already a subscriber?Sign In.Not now

Join the conversation

or to participate.