Latest Contributions by JohnathanHasthorpe

@ Hugo GAIGNARD  we have this open as a bug and hope to address this in a future release: BUG-000106578 - When choice_filter used, the name text is saved as the data value, instead of the label text. I will update this post with any developments. Thanks John ... View more

mbrueningesi‌ We will fix this in 2.8 ... View more

Done. The steps will create a .dbf that you can open in excel. ... View more

Hi Todd This is a known issue with select_one questions. The data itself is written as the name column and a domain is created to so that the labels seen in Survey123 will be seen in ArcGIS Online; in all but file geodatabase exports, ArcGIS Online provides the code (choice names) instead of labels.  You can export the data with the labels via ArcGIS Desktop tools - see How To: Export a table to include domain descriptions and coded values to export to .dbf. Thanks John ... View more

Hi Dragos   Survey123 does not use Excel formulas. You need to use the XLSForm Spec instead. A couple of things to note on your calculations: =IF(SUM(choices!F54,choices!F63,choices!F71,choices!F79,choices!F87,choices!F95)=0,"",choices!F54/(SUM(choices!F54,choices!F63,choices!F71,choices!F79,choices!F87,choices!F95,))) Don't use = before an if() statement Don't refer to excel cells - you need to refer to question names e.g. ${Calc_C4} An if statement should be on the lines of if(condition, a, b) for example if(${q1}>0, 1, 0) Don't use sum() in this context. You should use +. e.g ${Calc_C4} + ${Calc_C5} Please take a look at the following for more background on the above XLSForm essentials—Survey123 for ArcGIS | ArcGIS  Formulas—Survey123 for ArcGIS | ArcGIS  Thanks and let me know if you need any further clarification John ... View more

Hi Sarah If you can establish what question is causing the issue, go to the service item online and check its field length. A select_one submission can get long if multiple answers are selected. e.g. if you had A B C or D as names and all were selected, then we would submit the following as a string: 'A,B,C,D'. If the names for your choices are are long, then you could end up with a string that is longer than the field. You should definately check this. Thanks John ... View more

We have an enhancement request open to do a search on a feature layer. I'll add you to it. An alternative approach would be to make use of the geo-search functionality currently available in beta: Welcome to our Feedback Community  ... View more

HI Tjeerd This is by design. If you apply a choice filter to the choice list, then Connect will not create domains for the list items. This is because choice lists in this situation tend to be very long and a creating a domain for each item would be difficult to manage. To work around this you will need make your name values more descriptive. Alternatively you could use the pulldata() function to perform a lookup on the name and return the label - and then store the label in a separate field. To do this you would need to create a .csv to form the basis of the lookup. Thanks John ... View more

Should be later this week..... ... View more

Hi Nicole This is a bug in 2.6. From 2.7 the hide_input appearance applied to a gp question will look like this: ... View more

Hi Renato This is not possible. But you can create all 12 questions in the survey and then use relevance to hide the questions that are not required. You would use a calculate to do the rows times columns sum and then use the answer as the basis of the relevance (i.e to determine which select_one questions are displayed). Please let me know if you need an example of this. Thanks John ... View more

Hi Dorn - How many sites are you looking to include? It could be possible to use the pulldata() function to update the location of a geopoint question. This would be based on the user selecting from a list.  Take a look at the following example:  https://survey123.arcgis.com/surveys/cda53bf550924a8abf23c53330a86492/collaborate  ... View more