Implementing a Favorite Feature for Records

Introduction

This article demonstrates how to implement a user-specific favorite feature in Joget, allowing users to mark certain records as favorites in a List and view them in a separate personalized menu. It shows how to configure the form, List actions, and filters to achieve this functionality for logged-in users.

How does it work?

1. In Form Builder, add a CheckBox field in the desired form and set its value to “yes”. This field serves as the indicator for whether a record is marked as favorite. In the List, add two Database SQL Query Actions: one for marking a record as favorite and another for unmarking it. The following is the SQL for marking a record as favorite:
   
   

   update app_fd_f1 set c_CheckBox=""
   where id = {id}

2. Set the visibility control for this action to:
   

• • Join Type: And
  • Field: CheckBox
  • Operator: Equal
  • Value: Yes

3. Click the Database SQL Query for 'unfavorite'. The following is the SQL for unmarking a record as favorite:
   
   

   update app_fd_f1 set c_CheckBox="Yes"
   where id = {id}

4. Set the visibility control for this action to:
   

• • Join Type: And
  • Field: CheckBox
  • Operator: Not Equal
  • Value: Yes

5. To create a separate “Favorited” menu, create a new List pointing to the same form. Apply a filter condition:
   

• • Join Type: And
  • Field: CheckBox
  • Operator: Equal
  • Value: Yes

This ensures that only the records marked as favorites by the logged-in user are displayed in the favorites list.

Expected Outcome

Users will be able to mark competitions as favorites by clicking the action in the menu. The selection is stored per record via the checkbox field. When accessing the “Favorited” menu, only the records that the user has favorited will be displayed. Users can unfavorite records from this view, which immediately removes them from the list, providing a dynamic and personalized favorites experience.

Video Tutorial

Download sample app