I’m building a football evaluation app using Glide, and I’ve hit a roadblock I can’t figure out a clean workaround for.
Scenario:
Each coach (user) evaluates multiple players.
Each player has multiple skills (dribbling, passing, etc.).
I use a selected JSON object stored in the User Profile table to dynamically populate a helper table (let’s call it Questions Helper) with related skill data when the coach taps “Start Evaluation.”
The Questions Helper table has a user-specific column for Rating, which the coach fills in per skill.
The Problem:
When the coach switches to a new player, I want to reset all ratings to blank for the current user.
However:
I cannot delete and re-add 100 rows each time (not scalable, bad UX).
I can’t trigger custom actions from the Rating component, so I can’t hook into it to reset or tag the rating with a session ID.
The Ratings are user-specific, but they persist even when the data is re-populated from JSON → I need them to visibly reset.
The closest you can get is to employ some variation of the technique that I linked to earlier.
What I would do is something like the following:
“Reset” the values on submit by invalidating the ParentID and hide all the values
When an evaluation starts, display the skills as a collection
Use an Item click action to rate each skill. The action should first clear the user specific column in that row, and then open a custom form screen to select the rating.
It may not be the greatest in UX terms, but I believe that’s about the best you can do.
That would work, but there would need to be 100 relations (or Single Value->Whole row) columns, and 100 corresponding Set Column Value steps. Which is why I didn’t suggest it.
This, will create a lot of fuss, another idea that works by deleting all rows and adding the 100 rows everytime the user clicks on start evaluation but this will not work with multiple users
Well, you start by creating a series of Single Value->Whole row columns, one for each row. The first will take 0 from start, the second will take 1 from start, then 2 from start, and so on. Then in your workflow, you string 100 Set Column Values actions one after the other, which each one operating through a separate Single Value column.
This is a decent approach if you have a fixed and relatively small number of rows, but I really wouldn’t recommend it for 100 rows. But you can always try it if you want. I could imagine it would be incredibly slow
Hi guys, I am a newly glide certified expert and was looking to collaborate with other experts but when I tried going to slack or its forum pages both have their links expired. So, can someone add new invite links and then let me know please – I will be really glad.
Scenario:
The Problem:
