I am utilizing an external choice list in my form and have a Spanish column included in the external table. I am managing the choice list with a search() appearance.
However, I am not able to get the form to utilize the Spanish column of my external table. My current setup will return the choices from Column D of my external table. If I put "Area_Spanish" in the label column of my choices tab in the Survey123 Excel workbook, I get the Spanish options.
Is it possible to have Survey123 automatically switch between the English options and the Spanish options in the same way it does with an internal list?
Survey Tab:
| type | name | label | hint | guidance_hint | appearance | required | required_message | readonly | default | calculation | constraint | constraint_message | relevant | choice_filter | repeat_count | media::audio | media::image | bind::type | bind::esri:fieldType | bind::esri:fieldLength | bind::esri:fieldAlias | body::esri:style | bind::esri:parameters | parameters | body::accept | body::esri:visible | body::esri:inputMask | label::Español(es) | hint::language (xx) | guidance_hint::language (xx) | required_message::language (xx) | body::accuracyThreshold | bind::esri:warning | bind::esri:warning_message | bind::saveIncomplete |
| select_one area | hwp_area | Please Select an Area | | | minimal search('Project_Area_Super_Level_List','matches' ,'Building',${hwp_building},'Level',${hwp_level}) | yes | | | | | | | | | | | | | | | | | | | | | | Área | | | | | | | |
Choices Tab:
| label | media::image | media::audio | areaname | levelname | buildingname | company | projectname | indiname | scope | workisfor | pmlist | label::Español(es) |
| Area | | | | | | | | | | | | Area_Spanish |
External Table:
I deleted name and contact information from my table, leaving those cells blank.
| Project | Building | Level | Area | Area_Super | Area_Email | Area_Phone | Building_Super | Building_Email | Building_Phone | Map_ID | Area_Spanish |
| EAG | EAG 5 | Level 1 | EAG 5 A Front of House | | | | | | | | Eag 5A - Frente a la Casa |
| EAG | EAG 5 | Level 1 | EAG 5 A Back of House | | | | | | | | Eag 5A - Trasera de la Casa |
| EAG | EAG 5 | Level 1 | EAG 5 B Front of House | | | | | | | | Eag 5A - Generador Patio |
Thanks,
Alex Steiner
