Enable multi-field record-level-security
I have an application where multiple data pages need to be viewed by 4-5 different types of users. I would like to use record-level security to restrict what data that page displays based on the logged-in user. I cannot use OpenID as an authentication method for this application.
Since Caspio's current authentication scheme only allows you to filter based on one field in the authentication, I would have to duplicate the page for each role that needs access to that page's content.
Could the authentication scheme allow for multiple fields to be used to determine whether a user has access to something. For example,
(
dataSource.field == authenticationSource.field1 OR
dataSource.field == authenticationSource.field2 OR
dataSource.field == authenticationSource.field3 OR
dataSource.field == authenticationSource.field4
)
The application will take ~50 data pages. Without this feature, that quickly scales up to ~180 pages
For more context, see my comment in this other thread: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/16251463-record-level-security