Hi
I have a user table with a text column containing information about a users role in the team - it’s just text but it’s used by a choice field on a profile page which links to another table with a list of roles.
The field isn’t user specific
It only seems to happen on my user table
I can save the data on one device - eg when I load on an iPhone I can edit lots of users. It seems to ‘save’ (multiple fields have been edited because the role changes show in the collection). But when I refresh the page it reverts to blank.
If I do this in the app editor I can see the data saved in the front end and back end but doesn’t show up on other devices
Very frustrating as this drives a lot of my app functionality in terms of who can do what!
It will not fail just because the name of the column is “Role”. It will fail because your user profile configuration designates the column named “Role” as a true role column.
Can I change that? I’ve created a column called role for organisation role, ie sort of a job title and want to make that user selected Role as a function makes more sense now, thanks for the explanation
Yes, you can change it. I recommend reading through this document first.
Native Role functionality mostly applies to the ability to assign row owners to multiple users of the same role. It’s more of a data security feature. You can still have a column that functions as pseudo role for other things as long as you don’t set it as a role column in your user profile configuration and don’t plan to use it for row owners.
