🗳SayIt

Open Source, Self-hosted and Free

SayIt helps you gather feature requests and feedback, organizes them based on their priority, and helps you plan your roadmap. Also, it engages everyone with the new updates when a requested feature is updated.

Authentication Overview

Admin panel overview

User panel overview

✨ Features

✅ ️Collect Customer Feedback

✅ Product feature voting board

✅ Comment on posts to get more insights

✅ See all votes from a specific user on their profile

✅ Track project status and keep your team on the same page

✅ Get track of Status updates, Post creations, New comments, and Post ownerships by notifications

✅ Manage posts

✅ Send Invite to the user over mail

✅ User signup

✅ Role-based access

✅ Manage tags for posts

⭕ Manage profile

⭕ Change board visibility to private

⭕ Manage Company

⭕ Publish on Product Hunt

🔨 Build with

ℹ️ INFO You can differentiate the manual code from DhiWise-generated code by referring to the comments made in the code.

💾 Database

For this project, Supabase is used for data storage. Once you log in to Supabase, you will be asked to create a project.

📖 Prerequisites

Step 1: Create a project in Supabase.

Login to your Supabase account and create an empty project in Supabase

Go to Supabase -> Projects -> New project

Give your project a proper name, set a password to secure your project, and click Create new project.

Step 2: Email configuration in Supabase project

Go to Project dashboard -> Authentication -> Providers and enable the Email option to authenticate your application using Email.

Now, go to Project dashboard -> Authentication -> Email Templates.

Add the following query for Confirm signup email:

<h2>Confirm your signup</h2>

<p>Thank you for joining SayIt. We’d like to confirm that your account was created successfully.</p>
<p>To get you started, Please click on link to <a href="{{ .ConfirmationURL }}login">Confirm your mail</a></p>

<p>Best,</p>
<p>The SayIt team</p>

Add the following query for Invite user email:

<h2>Invitation to SayIt Board</h2>

<p>You have been invited to join SayIt team. You can use it to raise feature requests, give feedback and get help.</p>
<p> Click <a href="{{ .ConfirmationURL }}signup">here</a> to accept the invite </p>

<p>Hope you will find SayIt useful!</p>

<p>Best,</p>
<p>The SayIt team</p>

Step 3: Create a storage bucket

Go to Project dashboard → Storage; click on 📝 New bucket.

Provide bucket name and set it public.

Now go to Project dashboard → SQL Editor -> + New query and RUN the following query to create policy.

create policy "Allow upload on <BUCKET_NAME>"
on storage.objects for insert
with check ( bucket_id = '<BUCKET_NAME>' );

📄 Note: Replace <BUCKET_NAME> with the name of your storage bucket.

Step 4: Create tables and create public users

Create tables:

Go to Project dashboard -> SQL Editor -> + New query.

And get the query from here and paste it.

Now, click RUN.

This will create tables in your project.

To view the created tables go to; Project dashboard -> Table Editor.

Create public users:

This function duplicates data from the Supabase auth.users table to the public.profiles table.

Go to Project dashboard -> SQL Editor -> + New query.

And get the query from here and paste it.

After the function is created, run the following query in Project dashboard -> SQL Editor -> + New query to create a Trigger from the function.

create trigger on_create_public_user
  after update on auth.users
  for each row execute procedure public.create_public_user();

📄 Note Once the tables are created, go to Project dashboard → Authentication → Users and click on + Invite and provide the email ID of the admin user. Once the admin accepts the invite, he will be redirected to the signup page, where admin needs to provide his Name, email and password.

An admin user entry will be created in public.profiles table change the type of that admin user to 1.

ℹ️ Info In the profiles table, field type has below values
1 : Admin
2 : User

Step 5: Functions and Triggers

Now, once the tables are created, RUN the following Functions.

Go to Project dashboard -> SQL Editor -> + New query.

Copy and paste the function query from here for the specific function.

Then, click RUN.

This will create a function. You can view this function from Project dashboard → Database → Functions.

Functions:

⚠️ Caution Do not change the function names

ℹ️ Info Function which requires arguments to be passed along will automatically take arguments after you run the query.

📄 Note Follow the same steps for all the below functions.

1️⃣ Post list with filters:

This function is used to fetch posts of users along with user activity filters (posts, votes, comments). Here we need to pass user ID and activity filters as requested, and according to the request, it will return a filtered post list.