Display a reference field as a choice list

[servicetrout]

Need insight to get this working correctly.  Trying to set a reference field in the base table to show a lookup/choice list on the form for the table. 

Display reference as choice list

Lookup table, badgMgma, has two fields cFte1 and Specialty.  Specialty is set to display "True".

Below is what it looks like on the form, and, if I enter "derm" and click the magnifier, I get the pop up window, but what is odd to me is that is it showing the cFte values, not the Specialty values in the popup... and it isn't working as a choice list per se. 

Any insight would be appreciated. 

-G

[Tim Deniston]

How many records can appear in this list? There is a system property that determines how many records can appear in a dropdown: glide.ui.max_ref_dropdown

By default, if there are more than 25 (as defined in the system property), the platform will display it as a regular reference field. 

As the Docs site says in the link you provided "Users with the personalize_dictionary role can also override the property value for a specific field by adding the max_ref_dropdown attribute to the field's dictionary entry."

[servicetrout]

Ah, the bottom line.  Yes, there are roughly 250 values in the table.  So I am not getting a choice list, but the reference lookup. 

If the user enters a couple of letters the pop-up box could work. 

Now, I'm thinking I need client script to populate this as a drop down... if that is possible.  

thank you for the insight. 

[Tim Deniston]

Try setting the "max_ref_dropdown" attribute in that field's dictionary. The format is probably "ref_auto_complete=AJAXReferenceChoice,max_ref_dropdown=300" which should allow it to be a reference choice list with a max number of choices of 300 before it switches to a standard reference lookup field.