please correct me if I am wrong, but from my modest (couple of weeks) experience, I have noticed some discrepancy in the glide app (FREE) between “preview” mode and published mode!
It’s hard to say without concrete examples, or screenshots, or a video. Personally I’ve never experienced any noticable discrepancies. What I see in the builder is exactly what I see in in the published app.
Well, without divulging too much information, I have a database (table) that is correctly changed when in “preview mode” (roles are correctly changed in the table)… but in “published mode” the table is unchanged… the roles get displayed correctly though!!
How is that possible?
when I check the table (during published) the role values remain unchanged, but in preview mode, the table is changed!
If you have configured Role functionality through the user profile configuration, and that same role column is the one you are trying to change via the app, then that is your problem. Roles cannot be changed by the front end of the app for security reasons. Same goes for changing emails in the user table. Are you utilizing Role functionality for row owner data security, or just to control some visibility or filters?