How to create a favourite (Star) option

[Fadi_Boutanos]

I created an App for Teachers conference, one of the views has the list of sessions how can I add a Star icon so teachers can pick the session as their favourite and generate another a view for all favourite sessions and potentially email the list of favorite sessions?

[Octfolio_Seb]

Hi @Fadi_Boutanos,

I haven’t personally done this, but one suggestion would be to have a ‘starred’ table.

This would have some columns such as Session Name, Starred, User Email.

You could then create a Workflow / Action which when pressed adds a new line of data to the Starred table with a Boolean value of 1 in Starred. If pressed again it could keep the row but set it to 0 in Starred.

You could then set up a view which refers to a slice which shows all Sessions with Starred equal to 1 and then where User Email matches the logged in users email address.

Helpful articles:

help.appsheet.com

Changing Data from a Workflow Rule or Scheduled Report

How to change data in your app on a schedule or when some event happens.

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

Alternatively, if your app is always online and you are using a SQL based database you could look at using a similar concept and then implementing some database triggers to set the values.

MySQL Tutorial

MySQL Triggers

MySQL triggers are stored programs that are executed automatically to respond to specific events associated with table e.g., insert, update or delete a record.

[Grant_Stead]

Done it quite a bit pretty simply…
Read through this…

I would like to create a Favorites behavior ... Questions

I would like to create a Favorites behavior that bookmarks table items. Ideally there would be an action where the user could check (for example) a star icon for any item he/she would like to add to his/her list of favorites. There would be some indication that the star had been selected. Then that list could be called up at any time from some filtered slice view in the menu. I’m assuming this would be a user sign in app. Is there a most common practice for designing this feature in Appsheet ap…