I’ve made an app in which users can play a Survivor for the NFL. In the game users have to choose a different team who they believe won’t loose in each week.
Logically is very important for users to only be able to select only teams who haven’t yet played. They have a time limit for doing this, I called this a timer. The timer is placed in airtable and is a formula which returns 1 if the ‘current time’ is after limit date and 0 if it isn’t (Before I had it in glide with ‘relative time’ column and I had the same problem that i will describe). Games are in another table and related to the timers that correspond to them. Through a lookup the Game receives the 1 form the timer, and through another lookup each Team-Week receives the 1 from the Game.
In the front-end Teams and Games are filtered to only be visible if the column containing the Lookup for the timer is not one. Also users are able to see each other’s pick in the leaderboard only after said selected team receives the 1.
The issue right know is that some users are never getting this 1 and continue to see games that have already past, and can’t see the other users picks. I have logged in with their email in my device and the ap does not have any issues. Also I see the 1 in their user role form the Data editor.
There aren’t any user-specific columns in any of the tables involved and users have been asked to delete and redownload the app as well as their caché, but that hasn’t helped.
Any advice? or possible causes for this issue?
Thanks.