Hello.
Using Group X, how can i save multiple fields of Group X in separate columns.
Scenario:
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
How can i achieve this. Please could you help.