Web Browser public question not pulling data/functioning

3CDCOrganizationalAccount

Hello S123 Community,

I am making an incident report for my organization and we are trying to make one report for our 2 difference public facing departments (1 of which uses Survey123 everyday and has the app and one never uses ESRI products). I made a survey and published it publicly so that we could start testing it out and I noticed that some of my choice filters, pulldata() calculations, and autocomplete appearances questions were not functioning in the web browser, but they are functioning in Connect and when I use the survey within the application.

Choice Filters: The first questions is whether this survey is for our Ops Team or Garage Team and that influences the possible locations within the choice filter layer. This for some reason is being changed into a normal text box it appears as opposed to an autocomplete appearance.

pulldata(): Furthermore, these locations do appear as an autocomplete in the location question before I select either Ops or Garage, but they do not pull the lat/long information from the CSV. To mark on the map which location we are referencing.

I went ahead and attached the CSV of garages and a draft of the Incident Form. I know that the web browser is a lot more particular than the app/connect, but any help would be greatly appreciated!

Garage_List1.csv

Form 6.xlsx

Vinzafy

Hey there, 

Thanks for adding your .csv and form! Helped a lot. I seem to have it working on my end in both S123 Connect and the corresponding Web Form.

The changes made were the following:

CHOICE LIST

• This one was a simple fix! In the choices worksheet, I changed the name of column D from 'Incident' to 'Incident_Loc', then updated the choice_filter formula in cells O8 and O17 to be selected(${incident},Incident_Loc).
  
  
• I have a feeling S123 was getting the choice filters mixed as the first question is named 'incident' and there is also a list_name on the choices worksheet named 'incident'. Giving it a unique name seemed to work. 

 

GEOPOINT QUESTION

• In this case, the locationCal calculate could actually be simplified. From Ismael's example here, he used the substr() function as he was pulling from a value that had the full coordinates in it. As you're pulling data from the csv for the lat and long individually, you actually don't need a substring calculation.
  
  
• One of the things I did to troubleshoot was add a null note question for the locationCal to see what was being generated. In S123 Connect, this looked fine. However in the web form, it returned an NaN value.
  
  
• I changed the calculate as seen below and that seemed to work:
  • substr(${latCal},0,12)+' '+substr(${lonCal},0,13) 
    to
    concat(number(${latCal}), ' ', number(${lonCal}))
    
    
• The geopoint question called ${locationCal} as before. 

Hope that works on your end too!