- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 05:47 PM
Hello Team
I have a custom table that has all these fields. I have teacher role and student role.
- I want the teacher can see everything on the table (read and edit) - I use table.None for read and edit. It works fine. Teacher can see all fields & edit all the fields.
- I want the student to be able to read field1 through field4 but not field5 through field7. Field5 through field7 shouldn't be display to the student. I'm not sure how to do that. Thanks for your help
-
Custom table
Field1
Field2
Field3
Field4
Field5 Field6 Field7
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 09:04 PM
Hi @huyjor ,
1. Write a table level acl for student which is table.none It is working fine
2. Write 3 field level acl to hide the field (i.e) Field5 to Field7. Write a Read acl and add the student role and in script write answer = false.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 05:54 PM
Hi, for student access you would need a table acl and also separate field acl's IE table.field1, table.field2, table.field3 etc.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 06:22 PM
Hi @huyjor in that case, for student your ACL will look like this
grant access for student in table.none and for all fields you would need 1 field level acl for each field,
if 10 fields then you need 10 field level ACL for student role.
Harish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 08:43 PM
Ok. this is how i understand from you below. I tried to do that it doesn't work. I still see all fields on the table.
table.none with student role(read)
table.field1 with student role(read)
table.field2 with student role(read)
table.field3 with student role(read)
table.field4 with student role(read)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024 08:51 PM - edited 03-19-2024 09:06 PM
Hi @huyjor can you enable debug ACL and see which ACL is granting access for student role.
Also in advanced script of ACL did you put answer = false;
Harish