i have a column on my user profile sheet that has data put in by the user that dictates the role, a lot of my interactions and visibility condition rely on this information but anywhere from 5 seconds to 3 hours later, that data disappears. nothing is set to empty them, nothing forces it to reshow empty, it will just happen, i can leave the data table open and just watch the data disappear.
i have changed the text entry space, the visibility conditions, the button the confirms everything. i have tried everything i can think of yet the data still vanishes/
Open this post to understand what’s happening. This is normal with a Role column.
Are you using Roles for Row Ownership to secure your data, or are you simply using it to control visibility and filters. If data security is not your goal, you might be better off not using the User Profile Role functionality and instead use a normal column as a Pseudo Role that’s not configured as a User Profile Role. You can still use it to control visibility and filters.
The main purpose of Role functionality is for data security through a Row Ownership.