...
The form developer will enable form permissions by record/submission using fields available in the form.
Solution Approach
Here bellow the high-level system design wireframe of the proposed solution to handle RLS
To accommodate this on DB level we need to add new table form_rls
as well as add new column to form
table - rls
as bool (false
as default) to make it easier to determine if we call list of submissions would we need additional filter by user’s field assignment.