Thu, 24 Sep 2026
Login

1 id with multiple data?

Confluence User - 07 Jan, 2019

Hai all, I Have one question about the multiple data in 1 id? Do in Joget workflow can do this ?

For example : 

Id 1 = the property name ( ABC company)  with a Tenant (MKTrading) with unit no (floor 21). After the tenant expirate, we want to keep the data of the tenant as history part and maintain the property name and also the unit no. how can we solve this problem?

 

 

datalists;forms

1

Confluence User •
07 Jan, 2019 •
confluenceUser •
•
confluenceUser •

Hi there Abdul Fattah,

I am unsure what you meant by "1 id". Do you mean 2 records having the same primary key in the same table? Or separate table? Or a foreign key that identifies a relationship between tables?

Anyway, this is possible with the use of foreign keys. Joget is certainly capable of doing this. This question is related more about database design. You may have 2 tables where one stores the property information, while the other table will store information about tenants that references the Property table. Perhaps you can gain some inspiration about form designs by having a look at Multirow Form Binder and JDBC Form Binder. Or you can also have 2 forms with different tables and then perform join/aggregation in the datalist with the Advanced Form Data Binder.

Hope this helps!

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