Knack does a good job of allowing filtering by logged in user, or by user role.
But what’s missing is “groups” … a method to provide access to users based on membership of user defined groups (that doesnt require Builder access to create like roles).
Groups are common in business apps. But unavailable natively in Knack. Has anyone come up with a method to create and use “groups” as an access filter in Knack?
Or a way to create new ROLES from the live app? (not the builder) - then they could act as a proxy for user defined groups…
I hear you Leigh. Myself I would rather they implemented and/or flexibility in filters. rather than it having to be all AND or all totally OR criteria. By not allowing the first sub criteria to be AND and subsequent one’s to be OR variations of the subset it really limits what you can do in boiling down lists. In our app, military servicemene\\Show me all men who were in XYZ Unit and were born in the state of victoria or the state of tasmania or the state of western australia. It just can’t happen currently necessitating 3 passes from top levele to get the required results.
I have to do something similar with “Divisions” and “Service Areas” as groups. I created a separate table as a domain drop down and connected them to the “accounts” table. When I had this enabled, I can create a grid/table and the settings would be show the record that is connected to the account based on a this connected domain table.
I was creating a “My Profile” type page that I wanted to associate based on a division so that their leadership team could review records of their staff. It would be a different situation if I was just filtering a group of records, I ended up doing pivot tables for the group and then creating separate pages.
