Using Group X, how can i save multiple fields of Group X in separate columns.
I am trying to create a User Form for Hospital patients. So i am using Group X to assign multiple diseases to patient along with duration of that disease. In the disease drop-down of Group X, it has long list of pre-assigned diseases.
As an example, i have created user "U1" with two diseases assigned: "Back Pain" & "Neck Pain".
Now what i see is that the data of Group X fields are stored in a single cell in database. So when i show the data on content-view, it brings all the data of that cell.
My purpose are:
1. When the data of the user "U1" is shown on content-view, only the assigned diseases should be shown.
2. In the search form - Select Dynamic field, only the assigned diseases should be shown. Though the disease list is long, but as till now only "Back Pain" & "Neck Pain" have been assigned, so only these two should appear in Select dynamic field.
Using Group X, how can i save the disease in separate columns and disease duration in separate column
I developed own version of groupx that can do that, but it so not made in very user friendly way (you have to follow certain field and table columns naming rules), also it does not have reading part (it can only save) as I didn't need it.