Relevant Field Not Working

[MatthewMorehead]

Hey everyone,

I just started diving into survey 123 connect ant making surveys using the XLSForm. It has been pretty straight forward, but I am encountering an issue using the relevant field. I am using:

${RANGER_DISTRICT} = 'AUSTIN TONOPAH'

to hide my allotment question unless the user selects AUSTIN TONOPAH as their ranger district. The function successfully hides the ALLOTMENT question, however when I select AUSTIN TONOPAH in the RANGER_DISTRICT question, the allotment field does not populate.

I used the same function, except to hide a PASTURE/UNIT question unless the user selects a relevant ALLOTMENT, and it hides then populates with no issue when the ALLOTMENT is selected (I tested this by deleting the relevant field for the ALLOTMENT question so it would not be hidden).

Any help is appreciated, it is a little frustrating that the same function works for one question but not the next.

[Katie_Clark]

I'm a bit confused, just because a field appears when it is relevant does not mean it will autopopulate. Do you have an additional expression in the calculate column?

It would be helpful if you could provide the XLS form or at least some screenshots. 

[MatthewMorehead]

Thanks for the reply. The Allotment question is successfully hidden by the ${RANGER_DISTRICT} ='AUSTIN TONOPAH' expression, however when AUSTIN TONOPAH is selected in the DISTRICT question, the ALLOTMENT question does not appear like I want. I attached my XLSForm below. I appreciate any help.

[Katie_Clark · Accepted solution]

Ok, thanks for sharing! That cleared things up. The equivalency expressions refer to the 'name' of the choices worksheet, not the label. 

In your form, all the choices for DISTRICT have the same name. Change the names to be the same as what's in the label column and the relevant statement should work.

[MatthewMorehead]

Amazing, that you for catching that, it fixed it perfectly!