Latest Contributions by DeonLengton

Hi Nick You can have a look at working with existing data in Survey123 https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepareforediting.htm You can create a new editing survey based on your existing base information survey by clicking New Survey in Connect, Then choose Feature service and choose the base information survey's service (you need to be logged into Connect to do this). Then you can set up your editing survey to edit the status and enable the Inbox to retrieve the existing base data for editing. Hope that helps. ... View more

Hi Personally I would do the following: 1) Create a new survey based on the Feature Layer provided  2) Publish the new survey at least once then remove the submission url - do this BEFORE you make changes to the survey 3) After publishing and removing the submission url, add the additional 16 fields into the survey by mapping existing fields and adding the new ones that isnt in the feature layer 4) Publish the survey again - it should ask if you want to add the new fields to the Feature Layer  ... View more

Hi You have done everything correctly except that your CSV file has semi-colons (;) instead of commas (,) in. Replace the ; with , in your file and it will work. ... View more

Hi You should probably have a look at the Settings tab of your survey's Excel design file. The form_id should match the destination table / layer name. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformsettings.htm ... View more

EDIT: I enhance our code 🙂 function MissingFloorList(lower,upper,floors) { let arr = []; for (let i = lower; i <= upper; i++) { arr.push(i); } var all_uniq_floors = [...new Set(arr)]; var visited_floors = [...new Set(floors)]; return all_uniq_floors.filter(x => visited_floors.indexOf(x) === -1); } Now you can just call one function to retrieve the missing floors and show them in red: pulldata("@javascript", "functions.js", "MissingFloorList", ${floor_lower}, ${floor_upper},${floor_number}) Show it in a note field with HTML formatting: <div style="text-align:center; font-size:large; font-weight: bold; color:red"; >Missing floors: ${missingfloors}</div>     ... View more

Hi Marie You could create a hidden field with a comma separated list of the code descriptions... I know its a work-around. Not sure if there is a setting to export the code descriptions though ... View more

Hi I accepted your challenge (in part) and came up with one possible solution: Hopefully your survey is not a public survey, then you can use JavaScript to achieve your requirement: I'm not sure if you will have a floor zero but in any case, your solution could be similar. Basically I made a list of all the floors visited and passed it to a JavaScript function to remove duplicates, sort the floors entered, and comma separate the list: pulldata("@javascript", "functions.js", "CapturedFloors", ${floor_number}) Where floor_number is the floor entered into your repeat... function CapturedFloors (floors) { var uniq_floors = [...new Set(floors)]; var sort_floors = uniq_floors.sort(); return sort_floors.join(","); } Next I used the floor numbers indicated to create a similar comma separated floor list: pulldata("@javascript", "functions.js", "FloorList", ${floor_lower}, ${floor_upper}) function CapturedFloors (floors) { var uniq_floors = [...new Set(floors)]; var sort_floors = uniq_floors.sort(); return sort_floors.join(","); } I would then compare the two lists with each other and they should be similar when a fieldworker has visited all the floors of the building:   I hope this helps!   ... View more