Reference field changes to choice list

[Gunjan Agrawal]

Hi Team,

"The glide.ui.max_ref_dropdown' system property determines whether a reference field is displayed as a choice list or a reference icon. The value given for this property is maximum number of records allowed for a reference field displayed as a choice list. If more records than this are available, default reference field.

But I am facing issue that I have more record then the number specify in property and still the field it's showing as choice only.

If anyone can help please let me know.

Thanks and regards,

Gunjan Agrawal

[Community Alums]

Hi @Gunjan Agrawal ,

You can override the system property (glide.ui.max_ref_dropdown) by setting an additional dictionary attribute, max_ref_dropdown with a value.   For instance, having set the Choice field to be "Dropdown with -- None --", you might also have an Attributes setting of:

ref_auto_completer=AJAXReferenceChoice,max_ref_dropdown=20

If you don't specify the extra attribute, you should determine for your own sake what is being defaulted to.   If the system property is not set, the value further defaults to 25.

If the actual number of records on the referenced table—possibly whittled down with a reference qualifier—does not exceed the max_ref_dropdown value, then the display will be as a choice list.   Otherwise, users are presented with a standard reference lookup popup window, via the standard magnifying glass icon, which can be further filtered by any characters possibly entered into the field by the user.   Either way, we're still talking about a reference field, here: it's just a question of presentation.   At some point, a reference lookup window is thought to provide a better user experience, giving users the ability to use the standard Go to and list filter UI mechanisms, allowing them to limit the returned list of choosable items according to the needs of the moment.

You the administrator can set the point at which that display-type switch occurs.   If you think it will be confusing for your users, you might set a max_ref_dropdown value to be high enough to effectively preclude the possibility.   This is not generally advised, but might make sense in some particular case.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Gunjan Agrawal]

Hi Sandeep,

I have tried max_ref_dropdown property but still no luck it is showing as choice list only. If exceed the no. of record then it should be reference.

Thanks and regards,

Gunjan Agrawal

[Ankur Bawiskar]

Hi,

Did you try to logout and login again to verify?

Regards
Ankur

[Gunjan Agrawal]

Hi Ankur,

Yes tried it but not working.

Thanks,

Gunjan Agrawal