Rollup average of scores submitted by the user

Ask for Help
1

Hey there. I need help.

Video:


Daily Score App · Glide - 19 March 2024 - Watch Video

In the app, the user submits an entry for the day, gives it a score, and outlines some activities of the day.

I want to be able to show a rolled up average to the user for all of their submitted entries, NOT for all submitted entries by all users.

How do I make this happen?

2
  • Create a multiple relation column in your Users table that matches each user email with the same value in the Date Entries table
  • Do your rollups through that relation

NB: I see you already have a relation column in your Users table, but it appears to be a single relation. You can’t do rollups through that.

2 Likes
3

Thanks @Darren_Murphy


Rollup average of scores submitted by the user - Ask for Help - Glide Community - 19 March 2024 - Watch Video

I already had that, but now I’m not sure what I’ve got to change - I thought it was already matching multiple, but chances are I’ve pointed it to the wrong place.

Appreciate your help!

4

Yes, your relation is correct (after you adjusted it).
Ignore the Lookup - that’s not required or relevant.

I suspect it’s the Rollup that is the problem - check and make sure it is referencing the values directly via the relation, and not via the table.

If you can’t get it to work, show me a screen shot of the rollup configuration.

1 Like
5

Solved, thanks @Darren_Alderman!! I removed the other computed columns and modified the rollup to look at the right relation and it’s sorted.

Really appreciate the assist!

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.