Referencing Columns

[hartable]

I have a data Table with 6 columns that need to be viewable by 1 specific user each. Additionally, I have a Users Table where I need to reference back a list of rows that match the column if it has been changed.

How can I make a single columns visible to 1 user only? And then reference in a different table (the user table), what rows they have updated that column on?  

Data Table

Info	R1 (User1)	R2(User2)	R3 (User3)
Xyz	Y	N	Y

User Details View

User 1

Info	R1
Xyz	Y

[Aurelien]

Hi @hartable 

"How can I make a single columns visible to 1 user only?"

You have various ways to achieve this, you may want to be more specific. If is it about displaying one column only to users, you may want to use this in the UX settings of your view:

The columns you choose to display will be the only one displayed to the user.

"And then reference in a different table (the user table), what rows they have updated that column on?  "

You may want to use dereference expression.

Alternatively, you may want to use the LOOKUP() expression.

For reference:

Dereference expressions - AppSheet Help

LOOKUP() - AppSheet Help

[hartable]

I ran into issues because I can make specific columns visible to all Users or specific roles , but I can't figure out how to make Only 1 specific column viewable by 1 user.

Like in my example:

Column R1 would only be visible to User 1. User 2 and 3 would not see R1, but would see their respective rows, R2 for user 2, and R3 for user 3. 

I have been trying to add an expressions using useremail() and my user list (which also has a column that references the column names)  in the columns Show_If Area, but can't get anything to work.

[Aurelien · Accepted solution]

Basically, all columns are visible by all users.

You can choose to display content or not.

One workaround can be to use Slices, with a Show_If condition on the views based on these slices.

Basically, Slices are "table mirror" which allow to decide which column, in which order you like, to display with a specific set of actions.

In your case, you would need to create 3 slices for your 3 users.

For reference:

Slices: The Essentials - AppSheet Help

[hartable]

Ah Okay, let me try this

[Steve]

Limit users to their own data - AppSheet Help

[hartable]

I actually looked at his first, but it didn't cover this situation.