In FilemakerPro it is possible to limit a user’s ability to browse/edit/delete by specifying a calculation, which is effectively providing record level permissions.
Is it possible to achieve similar functionality with Servoy?
see onRecordSelect , onRecordEditStart or on onDeleteRecordCommand in those things you can disabled editing or overriding delete so that you can control if they can delete the specific record.
to make sure:
browse: use addFoundsetFilterParam
no edit (but can view): use onRecordEdit or onRecordSelect
no delete (but can view): use onRecordDelete
Got it. Thank-you.
I have also discoverd that instead of using the addFoundsetFilterParam, one can set a global and then use that global in the relation, thus the user will only see their own records.
For example:
When entering the solution, the userID is set in a global (globals.UserID).
When creating records, the field UserID = globals.UserID
A relationship is set up that links the globals.UserID to the field UserID.
So each user that enters the solution will only see their own records via the relation. This avoids having to use addFoundsetFilterParam wherever it is needed.