# Count boolean "true" contents **URL:** \ **Category:** Ask for Help\ **Created:** [October 15, 2022, 7:31am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785 "2022-10-15T07:31:24Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 7:31am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/1 "2022-10-15T07:31:24Z")
Hello!! My app is about an online course. Users can mark an article as completed with the boolean component. I want to show in the user profile a Chart component with the user’s progress, by displaying how many articles are marked as “true” (user-specific) by the user. I used the Rollup, but the count results are the same for all users, not for each one. How can I make it? Thank you in advance, ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2022, 7:40am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/2 "2022-10-15T07:40:15Z")
You will need a multiple relation that matches each user with the results/progress table. Can you provide a screen shot that shows how your data is laid out? (from the Glide Data Editor) ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 7:45am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/3 "2022-10-15T07:45:47Z")
hi Darren, thanks for your quick response! I have a column in the course table, “Completed” boolean ![Captura de pantalla 2022-10-15 a las 9.41.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ffc10a63148d777609c8a01b93e365fb1b4c6bc8.png) And in the user table, another column with the count ![Captura de pantalla 2022-10-15 a las 9.42.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9fba0419e6c56574c6e9b11211cd5f4be2e7cc7.png) Just it… I don’t know to make the relation boolen vs users ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2022, 7:53am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/4 "2022-10-15T07:53:58Z")
mmm, okay. You have a challenge. The boolean column in your Courses table is User Specific, which means that the data in that column is only ever available to one user at a time - which is the user that is signed in (or the user that you are viewing as in the App builder). So what you have at the moment is most likely giving you correct results - but only for the user you are viewing as. Unfortunately there is no way to summarise/rollup user specific data for multiple users. So if that is your goal, I’m afraid you will need to re-think things a bit. Would you like some help with that? ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 7:59am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/5 "2022-10-15T07:59:14Z")
mmm so I don’t know if I’m doing it well… I want to display summarise/rollup user specific for the current user (not for multiple users), in his user profile. Is it correct? ![Captura de pantalla 2022-10-15 a las 9.58.51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/443bcfbce8507e74af60623898986a5dba6c6dca.png) ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 8:01am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/6 "2022-10-15T08:01:38Z")
By the way, I really appreciate the help and the offer, but I think this problem is simple to solve, or it should be, right? I have a list of other more complicated things that maybe if you need help pro 🙂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2022, 8:09am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/7 "2022-10-15T08:09:17Z")
> [@DESIGNROOT](#): > > I want to display summarise/rollup user specific for the current user (not for multiple users), in his user profile. If that’s all you need, then what you have should be fine. You should be able to test it by viewing as different users in the builder. The numbers should change as you switch from one user to another. > [@DESIGNROOT](#): > > By the way, I really appreciate the help and the offer, but I think this problem is simple to solve, or it should be, right? hehe, I wasn’t fishing for payment. I just wanted to confirm that was what you needed before I went to the trouble of outlining a solution 🙂 ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 8:22am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/8 "2022-10-15T08:22:19Z")
Doesn’t works… ☹ Boolean is not working as a user-specific value… why? Maybe is better to do that with a button and custom action to define everything (mark as completed \> add a number in completed articles, etc… ? ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 8:24am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/9 "2022-10-15T08:24:11Z")
> [@Darren\_Murphy](#): > > hehe, I wasn’t fishing for payment. I just wanted to confirm that was what you needed before I went to the trouble of outlining a solution 🙂 🙂 I appreciate “the time”, and I guess if you’ll spend on my project, is good to pay for it. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2022, 8:27am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/10 "2022-10-15T08:27:54Z")
> [@DESIGNROOT](#): > > Doesn’t works… ☹ > > Boolean is not working as a user-specific value… why? Yeah, you can have a boolean as a user specific value, and that’s what I saw in your screen shot. When you say it doesn’t work - can you explain more? What do you do, what do you see, and how is that different from what you expect to see? ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 8:33am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/11 "2022-10-15T08:33:53Z")
Doesn’t works because if I activate the value with a user, and I change to another user, is the same result. For this reason, in the user table, the count is always the same number for all users (and graph display always the same number, obviously). ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 8:36am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/12 "2022-10-15T08:36:17Z")
Weirder… if I change between profiles several times, the value is deleted automatically for each one. 😑 I don’t understand where is a different between that and the favorite boolean ?? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2022, 8:43am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/13 "2022-10-15T08:43:26Z")
I suspect that it’s working, but you might be not understanding or misinterpreting what you are seeing. When you are working with user specific column values, the results that you see in the builder can sometimes be a bit misleading or confusing. Try this: Open your published app on your phone or in a web browser, sign in as one user and check the results. Then sign out and sign in as a different user and see what you get. ---
**Author:** ![DESIGNROOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designroot/32/48282_2.png) [@DESIGNROOT](https://community.glideapps.com/u/DESIGNROOT)\ **Post date:** [October 15, 2022, 10:08am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/14 "2022-10-15T10:08:06Z")
Really? As simple as that 🙈 It works perfectly. Thank you! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 16, 2022, 10:08am UTC](https://community.glideapps.com/t/count-boolean-true-contents/51785/15 "2022-10-16T10:08:12Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.