Dynamically updating an image at the top of a data grid view

Ask for Help
1

Hi, I wonder if anyone can point me in the right direction.

I would like to display an image at the top of a data grid view that changes to the image associated with the person at the top of the list. So, by way of example, there is a list of test scores for 50 students. I would like to display the picture of the person who scored the highest in the title of the screen and then show all the scores in a data grid view. The scores get updated automatically each time there is a test and therefore when the scores change, Iā€™d like the image of the person ranked #1 to appear at the top of the list.

Hope this makes sense and thanks in advance for ant advice.

2

There are a few ways to do it, but you could start with a Rollup column to get the max score, then use that Rollup score in a single relation to the Scores column to get the row of the user that matches that score. Then add some Lookup columns to get the values you need from the relation.

1 Like
3

Thanks Jeff, I eventually worked this out for myself. The problem I had was that my app had originally beena private app but was subsequently changed to a public app. For some reason Glide overrode the instruction to display a single value image column and continually reverted to the image for a user in the original User table. I got around this by creating a new table with just the images for the people in the scores table.
Thanks again for your speedy response.
Regards
Andrew

4

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