Hello all,
I'm trying to let the users of my app be able to submit a record into a table, but not be able to view all the records from other users.
Right now the table ACLs give Create and Write access to users, and Read access to admin.
I also have an extra ACL to give Read access to users but only if they are the "Requested for" owners of the record (so they can see the table through a filter "My Records")
But when the users click "New" on the table they don't see any fields to fill out (because they don't have read permission)
Removing the extra ACL makes it so they can see the fields and submit a new record--but then they can also view the master table consisting of everybody's records.
Is there any way to let a user create record/see the form but restrict access to viewing the list of the entire table?
Or is there a better way to go about this?
