Can you have multiple constraints/choice filters on an external select?

IngridAldridge1

I am attempting to create a select one question based on the x,y location of the geopoint.  Preferably I wanted to have all assets within a 50m radius of the surveyor's location appear in the drop down.  It does not appear that you can use greater than or less than within the choice filter.  So, I have modified the process to use x and y locations rounded to the nearest 100.  This is working as expected on a subset of data in the choices tab.  However, it is not working at all with the external_choices tab.  I have tried forcing the attributes to integers int() which did not help.  I've attached an example  for reference.

Testing Functionality.xlsx

Captura.JPG

Anonymous User

Hi Ingrid,

Yes, you can use multiple fields in the choice filter with external selects (such as x and y). I had a look at your survey and have been able to get it working with just a few minor changes. Note that as you have 50,000+ choices in your external choice list, the survey is very slow to load and respond. Unfortunately this is because you are pushing the limits of the application using such a large choice list which must be searched/filtered with every focus change.

Firstly, the pulldata() function is a string function and causes the field type in the app schema to be created as a string and any further calculations to be processed as a string, this can cause issues with field type mismatches when doing numeric calculations. The calculate questions you used were created as field type string in the app, check the schema preview. Even though you set the esri field type to double, this only applies to the feature service, and not the field being used in the app. Therefore we must manually set these calculations fields to decimal. You can do this in two ways, change the question type to decimal (not calculation), however then these fields are no longer hidden from the user, but you could make them read only.

The other option is to use the bind::type column to set the two final calculations fields to be of type decimal, which will keep them hidden, and your calculations and choice filters will work as expected.

I also cleaned up the xlsx file by removing the un-needed select one and associated choice list and columns in the choices sheet, only leaving the fields and options needed to get this to work correctly using the external select. Also note I added a test record to your external choice list so that it would work based on my location, don't forget to remove it. Updated xlsx file is attached. 

Hope that helps.

Regards, Phil.

Geopoint Pulldata External Choice List.xlsx