Hi All,
I have a virtual field that displays the current user score (see .gif. Field in blue).
Note: I cut out from this gif the waiting time for the score to be updated.
Every time the user taps on the Complete button, a record is added in a another table called Class_Card_Logs that stores all exercise cards that have been completed for that session. The expression of the virtual field is using a SUM(SELECT(Class_Card_Logs[Points], filter)). Then the user is redirected right away to another exercise card. The problem is that the virtual field doesnโt have time to load the updated score before the page is loaded. So the user has to wait 5-10s to see the accurate score.
I canโt think of any simple solution that wouldnโt involve changing the architecture (ex: have a table to keep the score in a non-virtual field and showing it via a dashboard while showing the exercise detail view in another window of the dashboard). I could also do a full sync after each exercise completion but that wouldnโt be user friendly.
Has anyone found some alternative to this problem?
Thank you!
Solved! Go to Solution.
Itโs using the virtual column weโve already established wonโt be updated, so of course itโs going to have the same problem. Try computing the counts in the Content expression.
User | Count |
---|---|
34 | |
31 | |
30 | |
18 | |
17 |