Count blank fields values with a calculation

Discussion created by user28397 on Dec 2, 2016
Latest reply on Dec 2, 2016 by erolst


I'm trying to create a message system and i would like to show a badge that show the number of "unread messages". What i've done until now is:


- Create a message table with: ID, Title, Date, Message text and 15 field (that are the number of users) that hold "read" or "unread" values.


How can I count the number of "unread" messages from message table (and this for all users)?

How can I hold different values for different users?


Thank you.