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.
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.
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.
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
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… ?
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).
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.