Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The form developer will enable form permissions by record/submission using fields available in the form.

image-20240417-171011.png

image-20240412-212414.png

Solution Approach

Here bellow the high-level system design wireframe of the proposed solution to handle RLS

RLS solution wireframe.pngImage Added

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.

RLS db new table architecture.pngImage Added