topic Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect in ArcGIS Survey123 Questions

IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Wed, 17 May 2017 15:16:50 GMT

I am making an alarm registration form in connect, publishing to AGOL, sharing it with everyone, and using the web address in Connect through "Open in Survey123 Web App" for citizens to fill out and submit. I am testing and finding that my form does not display in internet explorer 11.00.9600.18666. This System requirements—Survey123 for ArcGIS | ArcGIS says it should be fine but has anyone experienced this issue? The form attempts to load but eventually I receive a "arcgis.com is not responding due to a long-running script" and when I stop the script (an option in the pop up box) the form appears but is not complete. Drop downs are missing for example.

Also I am trying to calculate a geopoint for the form by following this blog: https://community.esri.com/groups/survey123/blog/2016/06/08/calculations-on-geopoints and have success in the Connect form preview but when viewing in chrome\firefox (because IE does not work) the calculate does not work and when I submit the form it highlights the geopoint box as needing to be answered. I have it marked as read only and NOT required just as in the blog post. Any ideas on the issue?

Another note- I have a calculation that displays fine in the connect form preview but not completely correct in the Survey123 Web App link.

Here is the calculation: if(${Confirm_email}=${Email}, ${Confirm_email}, '<font color="red">Submitted Emails do not match! Please review your email address!</font>')

Here is the result in the browser:

this isn't a problem until the calculation returns a false and the gray box displays the "<font color="red......" and then below that is the correct display.

Any help on any of these will be appreciated!!

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Wed, 17 May 2017 21:55:13 GMT

Hi Kevin,

If you're calculating a geopoint, are you making use of large choice lists? This is probably where you're seeing the script 'freeze' (it's looping throng a lot of choices).

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Thu, 18 May 2017 12:19:11 GMT

The long-running script error in IE is unrelated to the geopoint calculation and it seems is more related to simply having large choice lists. I truncated much of the lists for testing purposes and it loads very slowly in IE. This is not helpful however because I need all of my original choices. However, I also noticed differences in the way the forms behave in different browsers, for instance autocomplete boxes work in IE while they are not functioning in Chrome.

The calculated geopoint still does not work in browsers even when calculating from a list of only 2 options. You cannot submit with a calculated geopoint in publicly shared forms answered in a browser page.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Thu, 18 May 2017 17:35:21 GMT

Hi Kevin,

Can you share the XLSForm? Here's an example that works: https://survey123.arcgis.com/webclient/cf44ffb345964aa88d402bda7084a50c Valid station id values are a 5 digit number beginning with '3' (file attached).

Also, I'm a little puzzled by your statement that autocomplete is not working in Chrome- again, on the form above, it works correctly for me

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Thu, 18 May 2017 18:37:43 GMT

Sure here also is the link to the form https://survey123.arcgis.com/webclient/6635fe7a81034980a5dd3742a5b1d6f7

The autocomplete in mine is for the street input.

I reviewed your form and looks like it calculates slightly different format from this blog as well https://community.esri.com/groups/survey123/blog/2016/06/08/calculations-on-geopoints. I might have to be utilizing the pulldata function and rework my lists?

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Thu, 18 May 2017 18:39:34 GMT

I should mention that for my testing purposes I only allowed one input to properly calculate the geopoint as you will notice. 3 ABBEY LN.

Appreciate any feeback!

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Mon, 22 May 2017 20:34:53 GMT

I've now modeled my form in light of what you have shown here as working and I am still having difficulties. I upload to AGOL but when I go to "Open in Survey123 web app" it says that there is no csv for the pulldata function. Specifically the error is: FormLogicError: instance "itemsets" does not exist in model.

I have deleted the folder and the iteminfo file and republished with the same results.

In the Connect for preview everything works fine. Where\how does the csv data get uploaded?

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Tue, 23 May 2017 23:11:04 GMT

Hi Kevin,

I've working with your Excel file and it looks like there are a set of issues that are causing the problems you've identified. I'm still working to isolate them.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Mon, 05 Jun 2017 14:45:49 GMT

Are there known limitations to the lists\browsers\geopoints\calculations that I may have missed somewhere? Can you direct me to additional documents, my understanding was I should have been ok in both versions of my xlsx, especially after remodelling from your working example.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Mon, 12 Jun 2017 17:52:33 GMT

I've gotten rid of any select_external questions and external selects sheet and moved it to a csv in the media folder. It now references fine, however the underlying issues I have been experiencing and still am seem to be more related to the calculations. No matter the different set ups to limit location to known addresses and calculate geopoints, the calculations associated are not working. Either pulldata, external selects, or otherwise. You can see here that it is still unsuccessful at calculating the address or cross referenced calculate field. Again all of these have worked in the form preview in Connect, none have worked in the browser as publicly shared forms. If all these scenarios were solely related to the size of the lists wouldn't have the pulldata function resolved this since it is not being loaded directly into the form but is only being referenced? It seems lists can't be more than about 450 records long according to your sample here James and my trial and errors of shortening the lists until browsers loaded the form.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Mon, 12 Jun 2017 19:23:43 GMT

Hi Kevin,

Sorry to not reply back. In the form you attached, there are a few issues that may be contributing to some problems with the form:

- In your labels, there are a few places that you specify the font color. The color name should be in quotations

- the field masks are not supported in the web form

- One issue on the Survey123 form processor- there seems to be an issue with eh concat() function to calculate location. This works in other contexts, so we need to investigate why it isn't working. Using the '+' operation (mobile device only) does work- not particularly useful in your specific case (as this is intended for the web)

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Mon, 12 Jun 2017 20:37:00 GMT

I changed the quotations in the labels and I still get returned the entire string:

Are you referencing the field masks for the phone number fields? Those seemed to have been working ok, but I have removed them now and not seen any difference with other issues.

I also think that the issue with the Survey123 form processor extends beyond the concat() function because as in my original form it did not work with the substr() either. Also my select_externals were also not working properly, this may be related. This is why I switched to the pulldata() with a csv and no select_externals sheet to work around this and still it does not work. I havent tested this most recent case with only using the pulldata() and CSV, but the substr() and select_external seem to be working when used with significantly fewer choices at around 400-600 records for the choices. Any more than that and the form is too slow to load\unusable. Since I have 11000+ choices this may be causing issue no form loading in IE and no successful calculations in Chrome or Firefox?

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Tue, 18 Jul 2017 19:38:12 GMT

Hi James

I've worked with Brandon from ESRI case #01943601 and he helped me get to a point where the map appears to be calculating the geopoint properly. I was missing the note field in my survey originally. However it is not holding that location. When I fill out the survey the map moves to the right location but when I submit the survey and then go add the layer to a map, the location for all records is at 0,0 off the coast of Africa. My calculate fields are all accurately populating but the geopoint is not holding its calculation upon submitting. I marked the geopoint question as read only and required. I've tried to calculate the geopoint directly and also just return the value from an addition field. Is there a character limit to the lat and long values? What is the last step here for the map?

Also using internet explorer is still an issue, as well as my html being displayed in the form.

I didn't mention this earlier but is there a way to get rid of the decimal points in my street list? The form generator seems to automatically add decimals to numbers in the external choice list. It makes picking 6 over 60 a lot harder for users

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Tue, 18 Jul 2017 22:39:02 GMT

Hi Kevin,

On the geopoint issue- I was able to get success by removing the inputMask values (which the web form doesn't support currently). I do see that your form does take a surprisingly long time to process in Chrome and breaks in Safari (which might be related to the IE issue)- we'll investigate that further. As for the decimal processing, you could attempt to format your values as text explicitly (by placing a ' - single quotation mark - in front of the values in Excel), but that is probably more work than you want. I've added this comment to the issue we have logged on this.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

KevinDunkin1 — Wed, 19 Jul 2017 12:56:10 GMT

I removed the inputMask values and am noticing no functional difference with or without them. I will keep them removed since you have made this point a few times now. But in fact the only time I am getting different results (with or without the inputMasks) is when I mark the geopoint question as read only. When read only is 'yes' the form does not save location. When left unmarked (blank) it will save the location. This is great but not what I need. I need the map to be read only and save the calculated location.

I tried to change one address with to prefix with a single quotation mark as such: '1 --The excel gave a cell warning saying it was a number stored as text which I ignored and went to publish to AGOL anyway. It works. It would otherwise be tedious to do this to all but I did some VBA code to change them all at once. For those needing instruction:

Select the range of cells you need to add the ' to

With your xlsx open press ALT+F11

Go to insert>module and paste this:

Sub Addapostrophe()

'updateby Extendoffice 20151207

For Each cell In Selection

cell.Value = "'" & cell.Value

Next cell

End Sub

press F5 to run. All the selected cells will have updated. Close the VBA windows. To save your xlsx form save as normal and when prompted you must save without macros, your cells will keep the applied formatting. You will no longer have decimals in your lists. Trying to add the single quotation in another workbook like this ="'"&CELL will not work.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

LeahSperduto — Mon, 20 May 2019 11:43:53 GMT

I seem to be experiencing a similar issue and this post mentioned an issue with the Calculate Geopoint (why I am posting here). I have a survey that publishes successfully and seems to work well in the app however gives the following error when attempted to submit via a web browser. "

Error: Initializing form...

FormLogicError: instance "Addresses" does not exist in model

I am attaching my form here along with the referenced csv file it references in the pulldata function.

Are external choices supported in the web browser? Are the inputMask values supported in web forms yet?

Thanks in advance!

Leah

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Tue, 21 May 2019 20:21:08 GMT

Hi Leah,

The error with 'Addresses' refers to how the pulldata function is used in your form - they should be in a calculate question by themselves and then converted to a number in another question. With regard to the input mask, that has not been implemented on the web form as well.

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

LeahSperduto — Wed, 22 May 2019 12:31:07 GMT

Should the external choices function work properly in the web form? It seems like the app gives the appropriate options in the drop down as expected, but the web from does not. Only allows free-form entry.

Leah Sperduto, GISP

Public Works GIS Analyst

3419 Coachman Pt | Eagan, MN 55122

Office: 651-675-5214

https://www.cityofeagan.com<https://www.cityofeagan.com/>

Re: IE Browser Compatability and Geopoint Calculation with Public Surveys made in Connect

JamesTedrick — Thu, 23 May 2019 20:55:37 GMT

Hi Leah,

I'm seeing a performance issue in IE 11 with your form - this may be related to BUG-000114091. Unfortunately, this is a known limitation with IE at this time.