I have duplicated the dependent drop down behavior in this app (see the dependency between 'Lead Region' and 'Lead Country'). https://www.appsheet.com/templates/An-app-to-add-and-update-sales-leads?appGuidString=2f43eb0a-1dbf-...
Except my app is not sorting the data the way the demo app is, and I cannot figure out why. If you look at the tables in the test app, the columns are not in any order, however, the presented drop downs are in alphabetical order. Additionally, the test app is not using any ORDERBY() in the Valid_IF field.
My app is not sorting. I have tried both a SORT() and an ORBERBY() in the valid_if field, but everytime I do that, the linkage between the dependent fields break.
This post seems to indicate that the sort is not possible with a dependency. However the demo app above shows that indeed there is some internal feature in AppSheet that can do this.
Anyone have any ideas how to exactly duplicate the Demo App's sorted dependent drop downs?
LinkedIn
Twitter
