Read more here about User Specific Columns. They just allow multiple users to write values to the same column without getting in each others way. Imagine you and I are viewing your app at the same time, and I change the selected month to October. If that wasn’t using a user specific column, then the month would also change for you. So it just allows us to have our own view of the data independently of each other.
Back to the issue at hand. This is all quite odd, and I can’t immediately think what the problem is. Is there any way that I could see this for myself?
Would it be an option to allow me to make a copy of the app?
So the issue here ended up being the buggy Format Date plugin.
Explanation
The Format Date plugin was being used in multiple tables to coerce date values into a common format, so they could be used to establish relations. There are known issues with some of the Glide date plugins where they will fail for some combinations of device/browser date format and locale settings. So whilst it worked fine in the builder (and in a desktop browser), it was failing on a mobile device.
Solution
Discard the Format Date plugin, and instead use math/template columns to format the dates, and build the relations using the templated dates.
Thank you so much @Darren_Murphy! It works perfectly and after looking at your corrections, it makes sense now. I hope Glide can fix this bug in the format date plugin as it was quite frustrating.