Latest Contributions by MilesMcCoy-Sulentic

‎12-20-2019

Hi James, I was able to get \n working, and it appears to work for both note and text outputs. I think my attempts at concatenating questions from the repeat in the note were also causing an issue. Is it possible to concatenate multiple questions from a repeat inside of a join calculation (something like: join(',\n',concat(${species},${aacover})) - though this doesn't work)? My goal was a summary table for the data in the repeat but I understand that's in the works? Way to summarize existing items inside a repeat? For plant surveys it's nice to have the whole list visible at once when reviewing it in the field to finalize things. My work around was to create a group of notes to summarize each individual questions in the repeat

‎12-19-2019

Is it possible to incorporate a new line/line break into a join calculation for a note or text type in survey123? I believe my question is similar to Counting "unique" selections across repeats. I'm hoping to create a summary list of all species at a site that were recorded in the repeat and what percent cover value was assigned to each species in a vertical list format, rather than one continuous string. Two questions inside the repeat are "species", and "cover"; my thought was to join the species and cover fields, and create a new line for the next pair responses. I played around with <br> and \n and multiline appearance but I wasn't able to figure anything out. Thanks

‎04-20-2018

Another approach I've come up with is to avoid the county species lists, and load one list of the entire state species list into the external choices and link it to a question in the choices tab to enable autocomplete search for species. To supply additional relevant info that I want to see but don't need to edit (i.e- which counties it's known from, it's nativity, and state sensitivity) I've put this info into a .csv in the media folder and used a combination of calculate question and pulldata, and note questions to pop up a species nativity, sensitivity, and known locations after selecting it. It is nice to have the entire list as there are some species that are known to occur in the state, but do not have any county records listed in the USDA plants list (yet).

‎04-13-2018

Jonathan - Thanks for the help! I was hoping to have an entire state's worth of species in the list (~4,000 species), and thought that having each county list would be to large, but I've limited the species list to a limited number of counties within the work area, and the cascading select to get a county species list is a great approach.

‎04-11-2018

I'm hoping to create a pop-up note when a selected response is not within a list of set responses. I believe it is possible using the selected(question,value) formula in the relevant column and some sort of substring search, but am not sure what the syntax might be. The survey is for plant species, and I would like to pop up a warning if the user records a plant that is not within it's known range (list of counties). My thought is that I can have the user select the county they are in, and then use that response to search for a match in the range list. I think the structure might be something like: selected(${County}) %in% Range, but I don't know how to go about a substring search in Survey123 syntax. type name label text example Example select_one county County County begin repeat plantList Species select_one species species Select Species: note outside known county end repeat Survey Tab example of species data from choices tab list_name name label Range species Pseudelymus_saxicola Pseudelymus saxicola Beaver, Box Elder, Cache, Carbon, Daggett, Davis, Duchesne, Emery species Abies_sp. Abies sp. Cache species Achnatherum_parishii Achnatherum parishii Carbon, Dag

‎03-30-2018

new to survey123 and not sure if this is the right place for this question, but I want to pop up a warning note if a species is observed outside of it's known range, based on county. I am using a cascade select and a repeat question to record all species found at a site. My species data also has a column with a comma-separated list of counties where it is known to occur. I was thinking that I could use a relevant statement for a note that would occur only when the survey location county string is not found in the list of "Range" counties for each species, but I'm struggling to piece it together. Thanks Survey Tab type name label text example Example select_one county county County begin repeat plantList Species select_one species species Select Species: end repeat note outside known range example of species data from choices tab list_name name label Range species Pseudelymus_saxicola Pseudelymus saxicola Beaver, Box Elder, Cache, Carbon, Daggett, Davis, Duchesne, Emery species Abies_sp. Abies sp. Cache species Achnatherum_parishii Achnatherum parishii Carbon, Daggett, Davis

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by MilesMcCoy-Sulentic

Re: join answers from repeat in outside note

join answers from repeat in outside note

Re: Syntax to search substring for selected(question,value)

Re: Syntax to search substring for selected(question,value)

Syntax to search substring for selected(question,value)

Re: Survey123 -- relevant field won't allow two values

Re: join answers from repeat in outside note

Re: Syntax to search substring for selected(questi...

Re: Syntax to search substring for selected(questi...