We have one user table shared across five apps.
We have used a Row ID as a User ID so we can update emails and details if needed.
However the Row ID column has turned into a text column in all the apps. The values are not editable. When adding a new user we have to manually enter a new ID.
Has anyone else had the same issue? Is there any way to use a row id column on the users table across apps?
When you link an existing table to another App, you have to add a new RowID column. Once you do that, you should see the same values in the new RowID column.
Just to clarify, a RowID column is by definition an uneditable Text column. If the column type is disabled for new columns, that indicates that you do already have a RowID column in the table.
Can you confirm again that when you add a new row the RowID column remains empty?
Can you show me a screen shot of that?
Some of our apps hadn’t had the user id column added and it was just a plain text column. We’ve added the row id column as you said and updated all the uses.
Our User ID text column is behaving exactly like a Row ID column and generating new codes when new rows are added.
The only difference is it isn’t displaying the padlock icon in the column name.