Assign User to a Colum Filter of Data to only Edit rest all read only

[anonymous]

Hi
How should I assign specific user email to edit specific Client ID?

here is my main table look like :-

SWITCH(USEREMAIL(),
“test1@gmail.com”, “ADDS_AND_UPDATES”,
“test2@gmail.com”, “READ_ONLY”,
“test3@gmail.com”, “READ_ONLY”,
“test4@gmail.com”, “READ_ONLY”,
“READ_ONLY”)

Thank you

[Marc_Dillon]

ahmed_shah:

SWITCH(USEREMAIL(),> “test1@gmail.com”, “ADDS_AND_UPDATES”,> “test2@gmail.com”, “READ_ONLY”,> “test3@gmail.com”, “READ_ONLY”,> “test4@gmail.com”, “READ_ONLY”,> “READ_ONLY”)

The “Are updates allowed?” section is for determining access level for the entire Table, not specific records in the Table.

---

If you need to limit edit for specific records, you have 2 options:

1. Set Editable_If expression for every editable column in the Table, to match the [Client ID] to the user.
2. Set up a Slice that matches the [Client ID] to the user, and set the slice as editable. Probably set up a 2nd Slice for all non-matching records, which is not-editable.

[anonymous]

Thank for reply.
I am just starting appsheet only 1month.
if you not busy I really appreciate if you can help me with this.
How to write and where to write those Editable_IF?

let me know I can add you to my app to see more Infor on this and help me
Thank you

[Marc_Dillon]

ahmed_shah:

How to write and where to write those Editable_IF?

I posted a help article about it above, start there.

[anonymous]

Thanks