topic Re: Question about Survey123 in ArcGIS Survey123 Questions

Question about Survey123

Ozman — Wed, 03 Aug 2016 18:40:21 GMT

Hi, why my survey takes too long to load on my device? Any recommendations, please

Re: Question about Survey123

IsmaelChivite — Thu, 04 Aug 2016 16:27:24 GMT

Hi Osman. To provide any advice to you you will need to include your XLSFile in this thread.

Re: Question about Survey123

Ozman — Thu, 04 Aug 2016 16:37:33 GMT

Thank you for your replay Ismael, I just attach the xml file to my original comment, if you can see if there's anything this bad ...

Re: Question about Survey123

IsmaelChivite — Thu, 04 Aug 2016 18:05:20 GMT

Hi. I had a quick look at the survey. Thanks for sharing. I was able to make it load in my iPhone6 in 4 seconds. Here are the changes I made:

First I changed the appearance of long lists into 'minimal'. This helps because the choices in the list are loaded only when you tap on the drop-down. I left short lists (under 5 choices) as they were. I got marginal improvement in this particular case.
Then I looked at your relevant column to find sets of questions using the same expression. I found a couple large sets in section 22 (Gastos) so I first removed all the relevant expressions, then grouped the questions and applied the relevant expression to the Group. In this manner, the mobile app only needs to execute the relevant expression once for the group as opposed to every question. The survey started to make some noticeable improvements here.
Then at the very beginning of the survey, in Section 3 (Codigo Encuestador), I collapsed a sequence of questions into a single Cascading Select with External Choices. This also made a significant difference.
I applied minimal appearance to your repeat. By using minimal appearance you delay the rendering of questions within the repeat until you click on Plus. Made minor difference but applied anyways.
Fixed typo in the header (Settings Worksheet), applied like-rt appearance to Encuesta de Satisfaccion. Just for the looks, no chance in performance.

I noticed you are using the field-list appearance. Unfortunately we are not supporting this XLSForm feature just yet. I left them there although they will be ignored in the app.

I imagine we could look at optimizing a bit more, but that is how far I was able to get it for now. For a survey of this type, which typically would take several minutes to complete, it seems like 4 seconds to open should be bearable. I did not test on other devices, the time to load will change depending on the compute time in the phone or tablet.

Attaching survey with my changes.

Re: Question about Survey123

Ozman — Thu, 04 Aug 2016 19:03:23 GMT

Thank you, you're great ... I'm new using this app, so I will make all the suggested changes and incorporate into my version and again thank you so much for your support

Re: Question about Survey123

Ozman — Mon, 17 Apr 2017 20:04:09 GMT

Hi, Ismael sorry for asking again, but I modified a little the xlsfile that you suggested me the last time in a new form using the external choice, but now it doesn't work, I checked everything several times but I can not find my mistake. Could you help me please or suggest any changes.

Attach the xlsfile

Re: Question about Survey123

IsmaelChivite — Tue, 18 Apr 2017 00:00:45 GMT

Hi.

I made some tweaks to your XLSForm and got the cascading select to work. All changes were made on the external_select worksheet. You will note I did:

rename your Frontera and Label columns to Frontera_old and Label_old
created new columns for Frontera and Label

Your syntax was correct, but cascading selects do not like numbers. That is why I added the two columns and transformed your numbers into text.

Hope this helps!

Re: Question about Survey123

Ozman — Tue, 18 Apr 2017 17:09:03 GMT

Thanks man, you are awesome ... I had the idea that the problem was in the numerical format, but your suggestion will serve me a lot. Thanks again