|
POST
|
Hi Will I once had a similar issue and it turned out that I used a reserved keyword in my survey... Not sure if you could have done something similar? Sounds like you're just building a plain survey though
... View more
10-08-2021
07:26 AM
|
1
|
1
|
3343
|
|
POST
|
One of our clients has the same issue... @JamesTedrick
... View more
10-08-2021
12:19 AM
|
0
|
0
|
1005
|
|
POST
|
Hi Maya > I don't want the form to pull the value from the csv, but want to check what the user input as the same as the csv. I am not sure what you mean with this statement but since you will only have one password at any one time for your survey I think its a bit of an overkill to use a CSV file. If you only have one password then you might as well hardcode the password into your survey and republish it whenever you want to change the password. You can then enable "Require update to the latest version of this survey" to enforce the user to update the survey to reflect the new password. If you really want to use a CSV file to store your password then you can verify the entered password in your survey with the following pulldata function into a calculate field named password_onfile: pulldata('loginfile','password','password', ${Password}) where: loginfile is your CSV filename without the extension placed in the media folder password is the only heading in your CSV file ${Password} is the field in your survey where the user types the password You can then simply check if the pulldata() calculation matches the entered Password: ${Password}=${password_onfile} I would propose that you create a link to a hosted CSV file to make the process a bit more automated. If you update the hosted CSV file it will automatically be downloaded to your survey whenever it changes. I attached a working example for your convenience.
... View more
10-08-2021
12:16 AM
|
2
|
1
|
2299
|
|
POST
|
Hi Christopher This issue is related to your other post. You need to fill in the label field of both the Num_RS and "soap" questions: integer Num_RS select_one yes_no soap
... View more
10-07-2021
01:14 AM
|
1
|
1
|
916
|
|
POST
|
Hi Christopher It seems your "soap" question is throwing a spanner in the works. You have an empty label for that question so it seems that that is causing the problem. If you add the label description it seems to be working fine.
... View more
10-07-2021
01:09 AM
|
1
|
0
|
2728
|
|
POST
|
Hi This is totally possible if you have a logged in user - you can perform a live query via JavaScript to a feature layer and extract information based on, for instance, the closest or an intersecting facility by using the ArcGIS REST API: var url = featureLayer + "/query?where=1=1&geometry=" + coords + "&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&outFields=*&returnGeometry=false&returnCount=1&f=json" You can then manipulate the return of the call to retrieve the attributes and use them in your survey: return JSON.stringify(responseJSON.features[0]); pulldata("@javascript","myFunctions.js","queryPolygon",string(${location}),true) pulldata("@json",${my_json},"attributes.Region") Please see this blog for more info: https://community.esri.com/t5/arcgis-survey123-blog/extending-survey123-smart-forms-with-custom-js/ba-p/898782
... View more
10-06-2021
05:55 AM
|
2
|
2
|
1614
|
|
POST
|
Hi Ben The short answer is - no - there is no appearance setting that will give you the first/last name of the logged in user. My first thought was that you could maybe use an API call to figure out the username/first name/last name: https://developers.arcgis.com/rest/users-groups-and-items/user.htm But it seems you need to be an admin to get that information returned because of privacy concerns. So your best bet would be a hosted CSV file linked to your survey - but like you say you will have to manually update that CSV file, even though it will be automatically linked to your survey. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm Look at "Working with external content": If you manually place the .csv file in the survey's media folder, and at a later time upload a .csv file of the same name to ArcGIS and link it to the survey, the .csv file in the survey is updated from the linked content (if newer).
... View more
10-06-2021
02:52 AM
|
0
|
2
|
2754
|
|
POST
|
Hi Christopher Its hard to debug without having your Excel file but i suspect you have duplicate yes/no choices in your choice tab of your survey. If you share your survey we can definitely assist better.
... View more
10-06-2021
02:38 AM
|
0
|
2
|
2755
|
|
POST
|
Hi Sarah Thanks for explaining your scenario so well. I do however think you will be better off doing most of the heavy work in Excel. You can achieve your requirement with the SEARCH function of Excel: =IFERROR(IF(SEARCH(F$4;$E$5);"Y";"N");"") I hope this helps. I have attached my Excel example for your convenience.
... View more
10-06-2021
12:02 AM
|
0
|
0
|
1642
|
|
POST
|
Hi Kaitlyn You just needed to put single quotes around the true parts of your if statement: (if(selected(${utility}, 'Hydrant'), 'Water Distribution', if(selected(${utility}, 'Gate Valve'), 'Water Distribution', if(selected(${utility}, 'Curb Stop'), 'Water Distribution', if(selected(${utility}, 'Sanitary Manhole'), 'Sanitary Sewer', if(selected(${utility}, 'Clean Out'), 'Sanitary Sewer', if(selected(${utility}, 'Storm Manhole'), 'Storm Drain', if(selected(${utility}, 'Inlets/Catch Basin'), 'Storm Drain', 'Other')))))))) It was complaining about 'water' not being a defined expression because it was the first string that wasnt quoted in single quotations. Hope that helps. If there's still issues then please post your survey, it would make it easier to assist
... View more
10-05-2021
08:32 AM
|
1
|
1
|
2687
|
|
POST
|
Hi Ming There is no option to ignore the capitalization of field names in the survey. If you need to replace the calculations then i would propose you do a find and replace to make it faster.
... View more
10-05-2021
02:40 AM
|
0
|
0
|
956
|
|
POST
|
Hi Sara Your actual survey seems quite straight forward - i do however see that you have an input mask on the hidden fields - is this by design or by accident? I'm not sure but perhaps that could cause an issue?
... View more
10-05-2021
02:16 AM
|
0
|
2
|
2180
|
|
POST
|
Hi Judith I see that FieldMaps supports recent values: https://doc.arcgis.com/en/field-maps/android/help/fill-out-forms.htm Reuse recent values You can reuse field entries between forms to minimize repetitive data entry tasks. When mobile workers open another form after completing one, they can select from their recent entries to populate the new form. To use a recent value, select the entry where you want to use it, and choose the value from your available recent values. Hope that helps.
... View more
10-05-2021
01:43 AM
|
1
|
0
|
1309
|
|
POST
|
Hi Colin Did you manage with this requirement? Perhaps you could share your survey and an example so I can get a better understanding of the workflow
... View more
10-05-2021
12:29 AM
|
0
|
1
|
887
|
|
POST
|
Hi Sarah Survey123 creates the comma separated list according to the sequence that the user selects the options. I think for some people that would be the expected behaviour, for others it might be less so. Regardless, there are two options to get the list sorted. The first option is to use a JavaScript function in your survey to sort the list alphabetically. As far as I know this will require a logged in user so doing that with a public survey wont be an option. Nonetheless, you can look at something like this to sort the values in JavaScript then just save the output to a new field in your survey: str.split(",").sort().join(",") The other option is to use the functions in Excel to achieve this. There is an Excel blog which details this exact scenario: https://exceljet.net/formula/sort-comma-separated-values Basically you can use the following formula to convert a cells comma separated values to be alphabetical: =TEXTJOIN(",";1;SORT(FILTERXML("<x><y>"&SUBSTITUTE(B5;",";"</y><y>")&"</y></x>";"//y"))) - which assumes your data is in cell B5
... View more
10-04-2021
11:47 PM
|
2
|
2
|
1666
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-17-2021 12:13 AM | |
| 1 | 09-10-2025 07:00 AM | |
| 1 | 08-26-2025 05:58 AM | |
| 1 | 08-17-2025 10:00 PM | |
| 1 | 08-15-2025 05:26 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-18-2025
02:24 AM
|