Record security by field and user

12 replies
14 views

I have a read-only grid with the following data (image below)
Currently all my users can see all the data
In my case, i want "User1" should be able to see just "Vendor1" in vendor_selected column, "User2" should be able to see just "Vendor2",....etc.
How can I do that?

D

deepakg681722

Inspiring

for this, you have to use filters while query the record.

D

danna3499Author

Known Participant

how?

can you help me with the basic steps or expression example ?

D

deepakg681722

Inspiring

Configure a source filter and make the value as an expression and in that you can provide the value based on your logic and field will be vendorName. For vedorName based on user name you can create a decision table for the user and vendor mapping and use that decision table to get the vendor name which you have to show to them. Also, by using the Security you can achieve.