All Collections
General Questions
Use Cases Guide
How to create a simple voting system?
How to create a simple voting system?
Updated over a week ago

In this tutorial, we will make a simple portal that you can use as a voting system for your users. To start, we need to have 3 tables in our base:

  1. Story - The table that contains the list of stories that will be reviewed

  2. Reviewer - The table where the list of reviewers that can log in to the portal is saved

  3. Reviews - The table that contains a list of reviews per story per reviewer

Let's go through the important fields that you need to set up for each of the tables.

Story

  • Title - This contains the title of the story that can be reviewed

  • Description - This can contain some more information about the story

  • Reviews - This is a linked record field to the Reviews table. Make sure you can only link one review for each row.

  • Overall Ratings* - In this tutorial, this field will average

* This is the setup for the Overall Ratings

Reviewer

  • Name - This contains the name of the reviewer

  • Notes - This is not a mandatory field. This can contain additional information about the reviewer

  • Reviews - This is a linked record field to the Reviews table. Make sure you can only link one review for each row.

Reviews

  • Review ID - This is the primary field for this table. In this tutorial, it shows the Story Title + Reviewer.

  • Feedback - This can contain text from the reviewer for more context on why the reviewer come up with the review

  • Rating - This is the rating field.

  • Story Title - This is a linked record field to the Story table.

  • Reviewer - This is a linked record field to the Reviewer table.

Now that the Airtable base is ready, we can now set up our form.


miniExtensions Portal

In the portal, use the Reviewer table as the user table.

You must have the Reviews table as a portal table.

In this tutorial, we disable creating records in the Reviews table. The admin will assign stories to review per reviewer.

This is the child form that will be used where the reviewers can enter their reviews.

When we open the portal, there are no records yet in the portal.

The records will only appear when an admin assigns a story for review by adding a record in Reviews table. The record is added for this tutorial.

After creating a record to the Reviews table and assigning a story and a reviewer, the record will now show up in the portal. Now, the reviewer can click the tile. The child form will pop up where the reviewer can set a rating and enter more details in the feedback field.

Did this answer your question?