Latest Contributions by Nicole_Ueberschär

That’s in fact also a good idea Weng! ... View more

?Hi James, they are using Android tablets and as I said, in Collector it works fine but it doesn't seem to be recognized in Survey123 which doesn't make sense to me. ... View more

Unfortunately the required issue is not totally solved yet for repeats from my point of view. I am still able to submit a form as long the first repeat is filled and the others are untouched. As soon as I answer question 1 in the second repeat it will also ask me for the other questions to be answered. So it only works partly and not the way I would expect.  And we still have the problem that a select_one field would loose it's value when switching between repeats and going back to the first.  ... View more

So, I think I see now where the problem is.  When the input fields are set as text everything works fine, also when not all fields are filled.  When the input fields are set as integers (which would make sense in this context), it is working as long as all fields are filled, but not any more when some are left empty. The problem is the way an empty integer field is saved (NaN) in contrast to an empty text field being just "".  In connect it seems to be working also with Integer fields, but not in the app.  Since I want the people only to enter numbers I did a workaround now with additional fields checking first if the fields are not empty and calculating then the result of those check fields:  type name label calculation integer landuse_share_1 landuse_share_1 integer landuse_share_2 landuse_share_2 integer landuse_share_3 landuse_share_3 integer landuse_share_4 landuse_share_4 hidden lu1_txt lu1_txt if(${landuse_share_1}>0,${landuse_share_1},0) hidden lu2_txt lu2_txt if(${landuse_share_2}>0,${landuse_share_2},0) hidden lu3_txt lu3_txt if(${landuse_share_3}>0,${landuse_share_3},0) hidden lu4_txt lu4_txt if(${landuse_share_4}>0,${landuse_share_4},0) note show_text All_values ${lu1_txt} +", "+${lu2_txt}+", "+${lu3_txt}+", "+${lu4_txt} integer total total number(${lu1_txt})+number(${lu2_txt})+number(${lu3_txt})+number(${lu4_txt}) Maybe this helps also someone else with a similar problem... ... View more

Hi Weng,  This is in fact an interesting question. But I don't have an idea at the moment how to accomplish that.  I have additionally the problem with my data, that I have a related table where the data is not shown at all in survey123 but at least I can look at the table in AGOL...  ... View more

Here Required Fields ignored in repeats · Issue #226 · Esri/Survey123Community · GitHub  it sounds like the problem was solved but obviously it wasn't... (Having similar problems with required fields in repeats. It's working in Connect but not in the app...) ... View more

Thank you James. Is the sum() function somewhere among the things that is planned to be implemented soon? As I have just seen the constraints should work now within repeats. (Required Fields ignored in repeats · Issue #226 · Esri/Survey123Community · GitHub )  So at least I could check if the fields are not empty.  ... View more

Hi Tom, could you share your excel file for us to test it? ... View more

Hi Dan,  I think it's in fact a good strategy to back up the sqlite database in the field instead of uploading it straight away. The way it is described here Troubleshoot—Survey123 for ArcGIS | ArcGIS should work for you.  ... View more

After changing my search to something similar to "survey123 export from sqlite" I found this post for troubleshooting Survey123:  Troubleshoot—Survey123 for ArcGIS | ArcGIS  The last topic deals with how to recover data from a mobile device. I tested it with my own copy of the survey, not the original one that my client was using. I adjusted the path to the survey in the database with the sqlite database browser matching the path that was created when I filled a survey on my desktop. Then my survey showed me the four surveys that were not uploaded.  After removing some of the constraints in the survey I opened the failed surveys, saved them without changing anything and was able to upload them. I only had the impression that one value got lost in a repeated field (which is bad enough). Maybe this helps someone having similar issues. I still can't really tell, what caused the Error Code 1003 but at least the data is online now. It might have been something to do with those constraints.  (no answer from Ismael yet) ... View more

Hi Zoltan,  I didn't get the idea that I could open the sqlite database straight in ArcGIS 🙂  Thanks for that.  I think I will contact Ismael directly to see if he has something in his pockets to help me.  ... View more

Hi Zoltan,  I was able to copy a database abc.sqlite from the tablet and could access the data somehow but the way it is stored will be a bit tricky to have it exported into a gdb. Unfortunately the tool you mentioned is not working for sqlite databases as it seems.  ... View more