Enumlist of Ref Type not Saving Multiple Choices

[BobSig]

Application FormAbilities EnumlistTable showing only one AbilitySelected three Abilities

I am attempting to build a Tabbed form to input Volunteer Application information.  I am using a parent table, Volunteer Application for basic information.  In the parent table I have included three columns, referencing separate tables.  Job Type, Abilities and Days Available.  The parent table columns are set up as Enumlist referencing each respective table.  I have four tabs, one for each table type.  When entering/selecting information in the Enumlist tabs, the system shows my multiple selections within each tab.  In other words, when I am on tab 2 for Job Type, the dropdown list presents the correct choices and I am able to choose multiple items.  After selecting it correctly displays the choices in a box.  So, if I selected three Job Types, they are properly listed.  I do the same on the other tabs and all looks good.  When I get to the end of the last tab and click Save, all appears to be OK.  But when I go to the

Parent table and view the saved row, only one item is recorded in each of the Enumlist fields.

I used the system generated form for one of the tables, Job Type, and it allowed me to pick on existing Volunteer and choose from the Job Type Enumlist.  I selected three items and all three where recorded in that users row.

What am I missing?  Is there a problem with Enumlist selctions and the Save button on a Tabbed form?

[BobSig]

I have tested further by making a simple Form for the Volunteer Application table.  It contains no tabs. Just a Last Name column and the three Enumlist ref type columns. The result was the same, so the Tabbed Form does not appear to be the problem.

Each of the Enumlist columns has a Valid If statement referencing the appropriate refenced table and the Row ID of each.  The Dropdown and selection of values is working correctly.  However, the returned and stored value is only one of the selected values from each list.  The parent table column is not a Text Type,  It is an Enumlist type column.

I tried to add a Select statement to the App Formula, but this did not work.  It removed the dropdown and prepopulated the box with all items from the Ref table.

[jerrygen · Accepted solution]

Hi Bobsig,

You're right to test the form structure and isolate the issue—since the dropdowns work correctly, the problem likely lies in how the EnumList columns are configured. Make sure each column is truly set as an EnumList with a base type of Ref, and that the “Allow multiple values” option is enabled. Avoid using an App Formula for this kind of dynamic input, as it can override user selections. Stick with the Valid If expression to filter options, and everything should save properly once the setup is aligned.

Regards

[BobSig]

Thanks for the help.  DETAILS, DETAILS, DETAILD.....

I had the TABLE columns set up as Ref instead of Enumlist/Ref.,  Within the App I had the column set up as Enumlist and Ref to child table.  So, the issue was in the TABLE setup of the columns