I am testing the latest version of my app in the editor and everything is working fine. However, when a colaborator tests the app returned different data. We are both using the same version of the app, but see different data.
He tried clearing his cache, runing in incognitor mode, doing a hard reset, and running the app as me, no luck. This is consistent, and I see no errors in the log.
My data source is Cloud SQL (MySQL). Has anyone else run into this behavior? How can I diagnore / fix the issue?
Try using a different browser or a different computer with the same user to understand whether it is a cache problem or that the appsheet data in the cloud that you are accessing is different than the data on each of the terminals.
If there were changes to your SQL table which, for some unknown reason, were not updated to the appsheet server, some users/terminals do not see those changes.
No, it involves four columns. None are virtual columns. One column is editable, the other three read-only. The table is not private, and the data is not partitioned.
Please take a screenshot or just explain what are the differences with these 4 columns and take them from one row. What the app shows to you, to the app user and what are values in DB.
You have said that you are using slices and that you ‘made sure’ that the slice filters are correct for both users. Do the slices have any time or date components to the filters? Is your collaborator in a different time zone to you?
Let’s have a look at the row filter applied to your slice and can you guarantee that the views you and your collaborator are looking at are both on the same slice?
Note that it is a required field, so how could the record exist if the field is not populated? The anser is it is populated, as here is what is in the database:
Interestingly, if the “bad” account sets the On Hold field to Yes and saves the record, the first screen does show the red icon, but only until the record is re-synced.
