So you want a read only copy of your User Profiles sheet, which is a Glide Table, yes?
Here is what I would do:
- Firstly, ensure you have a Row ID column in your User Profiles table (that’s obviously the case if you already have User Specific columns)
- Create your second table, and add a Row ID column
- Add a second (text) column, and call it User ID.
- Use that second column to create a single relation back to your User Profiles table, matching on User Profiles → Row ID
- Now you can add Lookup columns through that relation, one for each column that you want a copy of.
To initially populate the User ID column, you’d either have to copy/paste manually, or if there are many existing rows you could adapt this technique.
Dealing with new users could be a bit tricky, and it depends what your app privacy settings are and how new users are added. But it would probably need to be a two step process. The first step would be adding a new user to the User Profiles table, and the second step would be adding a row to the second table, using the Row ID of the newly created user (you could probably identify this using a Single Value or Rollup column)