Thu, 24 Sep 2026
Login

5 related tables (one-to-many relationship) design in forms

Confluence User - 02 Jan, 2020

Good day to all.

I have 5 entities which i need to reflect it on the forms.
They are inter-related and with dependencies (see attached image)


*  Modules can have the ff. data (user mngt., auditing, data recording)

*  Roles can have selected modules only (selection of modules should be a checkbox list)

*  User can have limited grants based on Role (i think this is the hard part but same using checkbox list)

Is this possible to implement in the forms builder?

(There is also a similar scenario but in a different process that's why i used this drawing for clearer view)

Your help is highly appreciated.

Thank you.

forms;datalists;datarelationship

2

Confluence User •
03 Jan, 2020 •
confluenceUser •
•
confluenceUser •

Hi Christine

Joget already has an internal Setup Users, User Role and User Groups screens, as follows:

You can also connect to a Directory Manager such as LDAP or Active Directory.

Confluence User •
06 Jan, 2020 •
confluenceUser •
•
confluenceUser •

You can start with designing 5 such forms with the table named as per your ERD.

Then, use grid or selectbox to maintain the relationship. You may need to use multirow binder inside your grid. You can check out the sample expenses claim app where relationship such as:-

  1. claim has many item
  2. each item has one category

are maintained.

cheers

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print