How can I use Omni Field Security to provide Record Level security?
You can use conditional scripting to create record level security. The best way to explain this is with an example: Your customer has multiple warehouses and certain Users are only allowed to sell from certain warehouses. By using the Country field on the Site Maintenance window and putting a User Class ID into it and then associating Users to the same User Class, we can create a many to many relationship between Users and Sites. Attached are 3 screenshots demonstrating how this relationship can be used to limit warehouses in SOP. Screenshot/Script of Field Security settings to control access to Site ID field in SOP (under LAN and SQL). Screenshot/Script of Field Security settings to limit Site Lookup (under LAN only). Screenshot/Script of Field Security settings to limit Site Lookup (under SQL only).
