2 answers
- 210
Hi there,
when you use the Options format type in the Form Grid, did you specify the ID of the form with the multiselect field in the Format column next to it?
This should solve the issue of properly displaying the multiselect values instead of displaying the ID.
Attached below is a sample app demonstrating the use of options in form grid with a multiselectbox. Do try it out and view the properties in the forms to see how it works.
Steps after importing and publishing the app:
- Go to Manage Setup Country to key in some lookup records. Example code='US', country='United States'.
- Then go to Manage Parent With Form Grid to add a record, click on the PLUS button to add a form grid row.
- Select more than one country. On submitting the form grid popup form, the form grid will display the each countries name but internally it will store as an 'id' value. Example display as United States' but stores into db as 'US'.
- You can view to confirm how the child records are stored in this Manage Child Subform menu.
- Camilo A. García
Hello, in fact the example that you sent me is presenting the same error (the grid presents me the codes but not the names of the countries). But I notice that in your screenshots it is separated with commas. However my joget implementation separates multiselect fields with semicolons. Does this have something to do with the format shown?
Add your comment... - 10-1
I am with the same problem. (using Joget Cloud (on demand) - last version
Insert and edit it's ok. But there are problems in Datalist displaying Select Box fields.
When I set a Select box with Options typed in Hardcoded , the Datalist shows the fields ok
But when I use "Choose Options Binder" and " Default Form Options Binder" to get data from another Joger existent form , I can get the values when I insert and edit the form, but the DATALIST shows the ID content instead of the correct value of the field
I've followed the Ian's instruction, but no sucess. I couldn't understand in which screen I have to set the ID.
And I didn't find the "Manage Parent With Form Grid" option
Add your comment...
Hello team. I have a form in which there is a multiselect field. This form serves as the basis for a Form Grid controller in a main form. In order to properly display the multiselect values I used the Options format, relating the name of the base form. However, when more than one option is chosen in the multiselect, in the form grid the system shows the IDs of the elements and not their text label.
We could see that when the load event is done through JDBC in the first screen the information is loaded with the correct format, however, when a record is added or edited, the format is lost.
Has anyone faced the same inconvenience?
The labels should appears as comma separated, can you attach some screenshot that show this problem?
Hello Walter, I attached screenshot. The example that was sent to me shows the same error (the grid shows me the codes but not the names of the elements). But you tell me it must be separated with commas. However my joget implementation separates multiselect fields with semicolons. Does this have something to do with the format shown?