XLSForm $ notation and select questions

Unfortunately, I am pretty sure the answer is that this is not possible. You might also be tempted to use pulldata but the external itemset and pulldata implementations are completely unrelated and incompatible. This is related to our discussion about interacting with data outside the form from the developer call a couple months back and illustrates why a single approach to external data that is complete will provide value. @dcbriccetti and @michal_dudzinski have been working on this (thanks!).

How many records are you loading, on what devices and how slow is it to use non-external select_ones? One step towards unifying the external data implementations is to improve performance internal select_one performance. If you can provide a sense of the size of your dataset (how many states, how many countries, how many cities) and the performance of the devices you work with, that will provide more information for that work. You can also follow it at https://github.com/opendatakit/javarosa/issues/170