dotwalked fields visibility
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2024 01:34 AM
Hi everyone, I have few fields on a form which are included by dot walking two different tables, I want to enable an specific role to see all the dotwalked fields on the form, they have the read ACL on each table, on the reference fields that connects the tables and on each specific field, but still the fields are not visible to that specific role although they exist in the form layout (there are users with other roles that can see the fields). my question is how can I create ACL for fields that come by dotwalking to different tables ? what are the requirements needed to see those fields?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2024 01:48 AM
Hi,
ACL rules are for a particular table/field. For your case you need to have the ACLS on the referenced table, but you will face challenge in adding condition that it only applies to the form in question of the columns are dot walked.
My suggestion, use a combination of Display BR and Onload Client script to control visibility.
In the Display BR check for the role and set value in a scratchpad variable.
In the onload script check the scratchpad and control visibility of fields,