Sort items in a drop down list in form

[Jennie_Lewis]

Hello,
I have a form that pulls in data from a reference table. When you open the drop down to select an item, I want to sort the values in the drop down menu.
Any ideas?
Thank you!!
jennie

[Suvrutt_Gurjar · Accepted solution]

I believe you could try in the valid_if of the dropdown column in the child table

ORDERBY(Parent Table [Parent Key], [Parent Label])

help.appsheet.com

ORDERBY()

Sort row references

[Jennie_Lewis]

That worked! Thank you!!