Styling individual collection items based on user progress

Hi everyone :waving_hand:

I’m currently building a daily puzzle game in Glide and I’d appreciate some guidance on the best approach for handling UI state per item in a collection.

Each puzzle has a set of letters (e.g. A, E, F, G, P, S, V), displayed in a grid (see attached image). Each letter corresponds to a correct answer, and when a user submits a correct guess (e.g. “egg” for E), I want only that specific letter tile to update visually (e.g. turn green with a checkmark).

My current setup includes:

  • A Puzzle Answers table (each row = letter + answer)

  • A Solved Answers table (each row = a correctly solved answer per user)

  • A User Progress table

What I’m trying to achieve is:

  • Each letter tile in the collection should independently reflect its solved state for the current user

  • Styling (background color, icon) should update only for the matched letter, not the entire collection

My question is:
What’s the most reliable way in Glide to conditionally style individual items in a collection based on whether a related record exists (filtered per user)?