Latest Contributions by DataOfficer

We are launching a survey tomorrow using a Survey123 web form, published from Connect. In browsing through some test data colleagues have entered, I noticed that some answers for a particular question are being recorded as 'undefined'. This seems to only occur when the user is completing multiple repeats. In my own testing, I have now noticed that when I start entering data in to a second (or third, fourth etc....) repeat, the answer to the question (what Species did you see) in the previous entry becomes overwritten to a blank value. When checking the results, these fields are either left blank, or recorded as 'undefined' (screenshot attached), when they should contain the species name. In some instances, going back to a previous repeat to try and fill out the answer again after it has been removed by the subsequent repeat shows a greyed out box that cannot be filled in (screenshot attached). The only reason I can think this may be occurring with this particular field is because it uses a coalesce argument in the calculation column (workflow described below) or because the question is dependent on a choice filter / cascading select. This issue does not seem to occur if only a single repeat (i.e. the original repeat) is filled in. The form can be accessed publicly at https://survey123.arcgis.com/share/046b1389d4884f659e06baafba1119eb for reference. Workflow leading up to the error: Within a repeat User select what sort of species they have seen - the species group (e.g. frog, lizard, snake), from a question called spgroup User selects species from dropdown list, with choices based on a choice_filter (SpeciesGroup=${spgroup}) from the previous selection If the user selects 'other' as the species, a new text entry opens (field name: 'Species_Other') allowing free text for the species name Hidden in the background, a second 'Species' field (named 'SpeciesCo') uses a coalesce argument to store the species / other text choice: coalesce(${Species_Other},${Species_label}) If the user selects a predefined species from the list (e.g. common lizard), a pulldata calculation pulls in some other attributes (e.g. Scientific name) from an external csv to some hidden fields. Breakdown of the erroneous behaviour: In repeat 1, the user fills out the details including the species group and specific species choice In repeat 2, the user fills out the details including the species group and species choice. The species entry for repeat 1 becomes blank once the second species group ('spgroup') choice in repeat 2 has been made. The user can go back and select the species in repeat 1 again to fix it. In repeat 3, the user fills out the details including the species group and species choice. The species selection in repeat 1 becomes blank again (if it was fixed after repeat 2), and the species selection in repeat 2 becomes greyed out with no way of entering data. The user can go back and select the species in repeat 1 again to fix it. Repeats 4 onwards result in the same behaviour with all but repeat 1 Species entries becoming greyed out and inaccessible, and again erasing any species entry that was in repeat 1. Note that in the last repeat, it still pulls in the correct information via the pulldata calculation (see below). In the results, this is stored as follows (with some dummy data) - errors shown in red: Repeat number species group (spgroup) Species (SpeciesCo) Scientific name (via pulldata function) 1 Frog/toad common frog (correct because this was filled in again after the last repeat removed it, but otherwise would be blank or show as undefined) Rana temporaria 2 Newt/Salamander blank (actual selection was smooth newt) blank 3 Snake blank (actual selection was grass snake) blank 4 Lizard undefined (actual selection was slow-worm) Anguis fragilis #coalesce #repeat #Survey123 #webform #webapp #undefined ... View more

Is there any way of creating a dynamic spatial Join in ArcGIS Online? As an example, our use case is that we have have species point data being generated via a Survey123 form. We want that point data to be visualised in a dashboard/webmap publicly but at a coarser resolution. To do this, we want to spatially join the attributes from the species points to a grid (e.g. 10km). However, using the Join Features analysis tool in ArcGIS Online only allows the creation of a new, static, layer if using a spatial join. It is possible to create a (dynamic) hosted feature layer view if using a join based on attributes. However this latter option is not suitable for us as it would require assigning the relevant spatial attributes (e.g. grid id or other spatial id) to every new record that comes in. I have also looked at the Aggregate Points and Summarize Within tools but neither of these can be used to create a hosted feature layer view, and neither are running successfully for me in any case (Failed - "the number of features is zero"). ... View more

Survey123 currently supports images to be attached to choices (e.g. in select_one and select_multiple questions), with those images stored in the media folder when creating a survey form in Survey123 Connect. The form with images can be used in the field apps. However, these images are not supported when the survey is loaded in the web form. Enabling support for these images that have been assigned in Connect, within the web form would be extremely useful, as a large target audience of our forms is through anonymous users accessing the form via a web browser. This is a big limitation on the utility of Survey123 at the moment. Supporting images would broaden the scope of what Survey123 web forms can achieve. ... View more