user28397

Count blank fields values with a calculation

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

Hi

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.

Outcomes