<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Conditional Relevant Question in ArcGIS Survey123 Questions</title>
    <link>https://community.esri.com/t5/arcgis-survey123-questions/conditional-relevant-question/m-p/835513#M19521</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, I think you will want to use a combination of thing here.&lt;/P&gt;&lt;P&gt;You can use something like this to hide a note when no selection has been made in a select_one:&lt;/P&gt;&lt;BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"&gt;&lt;P&gt;string-length(${village})&amp;gt;0&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;Then you can use the &lt;A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91"&gt;pulldata() function&lt;/A&gt; in the calculation column to populate the note with a lookup.&lt;/P&gt;&lt;BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"&gt;&lt;P&gt;pulldata("villagesCSV","staffname","village",${village})&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To illustrate this, I am attaching to this response a couple of files so you can see how things work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Import the Species.xlsx file into Survey123 Connect. Create New Survey/From File&lt;/LI&gt;&lt;LI&gt;Copy the speciesCSV.csv file into the media folder of your survey's directory&lt;/LI&gt;&lt;LI&gt;Select a bird species name from the list and a note will show its scientific name&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Birds....Villages...the same thing... &lt;IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;div class="lia-vid-container video-embed-center"&gt;&lt;div id="lia-vid-6162651281001w320h240r208" class="lia-video-brightcove-player-container"&gt;&lt;video-js data-video-id="6162651281001" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"&gt;&lt;/video-js&gt;&lt;/div&gt;&lt;script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"&gt;&lt;/script&gt;&lt;script&gt;(function() {  var wrapper = document.getElementById('lia-vid-6162651281001w320h240r208');  var videoEl = wrapper ? wrapper.querySelector('video-js') : null;  if (videoEl) {     if (window.videojs) {       window.videojs(videoEl).ready(function() {         this.on('loadedmetadata', function() {           this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) {             bar.setAttribute('role', 'presentation');             bar.setAttribute('aria-hidden', 'true');           });         });       });     }  }})();&lt;/script&gt;&lt;a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6162651281001"&gt;(view in My Videos)&lt;/a&gt;&lt;/div&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 25 Feb 2018 19:27:59 GMT</pubDate>
    <dc:creator>IsmaelChivite</dc:creator>
    <dc:date>2018-02-25T19:27:59Z</dc:date>
    <item>
      <title>Conditional Relevant Question</title>
      <link>https://community.esri.com/t5/arcgis-survey123-questions/conditional-relevant-question/m-p/835512#M19520</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all. I'm relatively new to Survey123 Connect and would like to know if there is a way to create a conditional relevant question based upon which a note may appear in the note field based on selection from the drop down list? For example, I have a list of villages in the Select_one question and I want to show in a note field below that question the name of a staff working in that village. If a person selects a certain village from the drop down list, the person's name working in that village should appear in the note field. How may I achieve this?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 25 Feb 2018 07:47:51 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-survey123-questions/conditional-relevant-question/m-p/835512#M19520</guid>
      <dc:creator>ManeeshMassey</dc:creator>
      <dc:date>2018-02-25T07:47:51Z</dc:date>
    </item>
    <item>
      <title>Re: Conditional Relevant Question</title>
      <link>https://community.esri.com/t5/arcgis-survey123-questions/conditional-relevant-question/m-p/835513#M19521</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, I think you will want to use a combination of thing here.&lt;/P&gt;&lt;P&gt;You can use something like this to hide a note when no selection has been made in a select_one:&lt;/P&gt;&lt;BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"&gt;&lt;P&gt;string-length(${village})&amp;gt;0&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;Then you can use the &lt;A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91"&gt;pulldata() function&lt;/A&gt; in the calculation column to populate the note with a lookup.&lt;/P&gt;&lt;BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"&gt;&lt;P&gt;pulldata("villagesCSV","staffname","village",${village})&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To illustrate this, I am attaching to this response a couple of files so you can see how things work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Import the Species.xlsx file into Survey123 Connect. Create New Survey/From File&lt;/LI&gt;&lt;LI&gt;Copy the speciesCSV.csv file into the media folder of your survey's directory&lt;/LI&gt;&lt;LI&gt;Select a bird species name from the list and a note will show its scientific name&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Birds....Villages...the same thing... &lt;IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;div class="lia-vid-container video-embed-center"&gt;&lt;div id="lia-vid-6162651281001w320h240r767" class="lia-video-brightcove-player-container"&gt;&lt;video-js data-video-id="6162651281001" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"&gt;&lt;/video-js&gt;&lt;/div&gt;&lt;script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"&gt;&lt;/script&gt;&lt;script&gt;(function() {  var wrapper = document.getElementById('lia-vid-6162651281001w320h240r767');  var videoEl = wrapper ? wrapper.querySelector('video-js') : null;  if (videoEl) {     if (window.videojs) {       window.videojs(videoEl).ready(function() {         this.on('loadedmetadata', function() {           this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) {             bar.setAttribute('role', 'presentation');             bar.setAttribute('aria-hidden', 'true');           });         });       });     }  }})();&lt;/script&gt;&lt;a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6162651281001"&gt;(view in My Videos)&lt;/a&gt;&lt;/div&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 25 Feb 2018 19:27:59 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-survey123-questions/conditional-relevant-question/m-p/835513#M19521</guid>
      <dc:creator>IsmaelChivite</dc:creator>
      <dc:date>2018-02-25T19:27:59Z</dc:date>
    </item>
  </channel>
</rss>

