Dropdown field does not pick up

I have a Drop Down Single Select field. The Group is always required to be No and the database shows all the fields as set to 0.
The problem is that whenever we want to add or edit a value in the Drop down several of those group fields lose their apparent setting and force us to reselect No before we can save the change. See image attached.



Is there some means of avoiding this?

Regards

Nick

So when you press "Add Rows" it resets all the Groups that were set to Yes to No? or is it only doing this after adding a new row then saving? Please describe your exact steps as this appears working fine in my tests. Please also be sure you're on latest CB 2.5 release.

No - not that Krileon.

The situation is that, as you know, you must set a value on each of these fields before you can save the update. That I do and from a users perspective all is fine. The new option is available in the users form. The problem is that next time I load the editor for that same field then several/many are cleared again. Just now there are 20 odd cleared so.


The values in the db table are still all set to 0.

It isn't a huge problem as we don't change the values often but a puzzle.

We are on the latest version of Joomla (3.9.22) and Community Builder (2.5)
Regards
Nick

By values in the database being 0 do you mean in the _comprofiler_field_values table? That is only after saving for a second time? How many dropdown options are configured on the field? It's possible you're hitting PHP input limit and that could explain weird save behavior. You also have several Groups with no Yes/No selected. Please be sure either Yes or No is selected as well.

Hi Kyle,

Yes - in table comprofiler_field_values.
For the particular fieldid - in fact all fieldids the fieldgroup is set to 0. And that doesn't change as I save that field. I have 2 of this type (dropdown (single) in use but for this fieldid whenever I load the field editor - several are not shown as either Yes of No. There are 66 entries for that field id. The only other dropdown (single) field that I have used has 47 values and is fine.

Comparing those two I see that the offending field is flagged as required and the other not. I will compare the two fields and see if there are other differences but presumably that should not make any difference.

Nick

several are not shown as either Yes of No.

Strange, try setting all of them as either Yes/No and save to be sure they have stored value. Each option is around 4 inputs so roughly 264 inputs there. I guess combined with other inputs from other parameters it's possible you're hitting input limits and some inputs are just being excluded from the POST. Is there any other heavy configuration on the field like lots of conditions? Typically when you've dropdown that large you'll want to turn to external storage and use CB Query Select fieldtype instead which will build a dropdown from a custom database table. It starts to get pretty unmanageable on that tab with too many options.