Latest Contributions by Jim-Moore

‎01-20-2019

Hi Sayed You're correct, times and dates are stored in Survey123 (and across ArcGIS Online) in UTC. Please see this useful post by James Tedrick‌ that has links that should help you to use pulldata("@property", 'utcoffset') to add a local time to your survey. And this comment shows a quick example. The time stored in Survey123, as well as the rest of ArcGIS Online, is UTC time; while browsers automatically compensate for that when displaying data, other applications and the export display the value as stored (as if there are no time zones). If you are using Survey123 Connect, you can include a question to retrieve a device's time zone, which you can then use to offset the time. Work with date fields—ArcGIS Online Help | ArcGIS https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis Prepopulate answers—Survey123 for ArcGIS | ArcGIS (how to get the UTC offset) Please also see the Dates & Time sample in Survey123 Connect for more on working with dates and times in Survey123. Hope this helps. Kind regards, Jim

‎01-20-2019

Hi Anthony Thanks for the screenshot. To show a repeat in a table, the repeat start and repeat end expressions should be placed inside the table (with the repeat's questions in-between). Please see https://community.esri.com/groups/survey123/blog/2017/07/26/introducing-custom-form-report-templates-in-survey123-for-arcgis for more handy info (Tip 6: Working with Repeats): If you want to print repeated records within a table, put the expression ${#repeatname} in the first cell of the repeated section and the expression ${/repeatname} in the last cell of the repeated section. Hope this is useful. Kind regards, Jim

‎01-20-2019

Hi Rawand Just to clarify, you are unable to see the drop-down list of question types in column A, as shown below? If so, it could be that the data validation rule has been removed for these cells. However, you should still be able to manually enter the desired question type in this column (in your example, delete 'hidden' and type in 'text'). The list of question types is shown on the types tab. Note that if you've already published your survey and wish to republish it with changes, certain changes to fields are not permitted (e.g. changes to field name, type, etc.). Survey123 Connect will show a warning about this when you attempt to republish the survey. Hope this helps, any further questions please let me know. Kind regards, Jim

‎01-20-2019

Hi Nicole This suggestion originally posted here by James Tedrick‌ might be what you're after: - if you have a few calculations, you can use the coalesce() function to provide an alternative value if a question is not answered (null) - coalesce(${q1}, 0) will return the value in q1 when present, 0 otherwise - an alternate formula to coalesce would be: if(string-length(${q1}) = 0, 0, ${q1}) - If you have a large number of calculations, you can add a calculate question after each measurement to store the coalesce or if/string-length function (likely making the bind:esri:fieldType null to not add fields to the table) and use the calculate questions' values instead. Two other (less elegant) options, using your default 0: User could simply enter more digits immediately after the zero - the leading zero will be ignored. Experiment with different appearance options. The 'spinner' appearance could be handy for questions accepting small numbers (say < 10). The 'calculator' appearance overwrites the default on entry (however, the other calculator functions it presents could cause confusion). Hope this helps. Kind regards, Jim

‎01-20-2019

Thanks Matt, this is useful information. As mentioned I'll pass this on to our team and add any updates to this post.

‎01-17-2019

Hi Lars Apologies, I overlooked that you're using Enterprise. Updating the domain values via the REST API should work (ensuring the values match the choices in the XLSForm of the republished survey). Advise that you proceed with caution and back up your data before making the changes. Please let us know if you have any queries. Jim

‎01-17-2019

Hi Phillip Confirming that this has been logged in our system as an issue for further investigation. In the web form, when used inside a repeat the count() function resets to 1 for each record in the repeat. Our team is looking into this and I'll update this post with any developments. Regarding Question 2, this goes some way to explaining why the Step 3 group does not appear in the web form: the relevant expression is never satisfied because the count() is never greater than 1. A workaround in the meantime would be to put a count() calculation in a question outside of the repeat and use this for the relevant expression. Also, the repeat_count set in your XLSForm will be honoured in the web form. I notice that the XLSForm you provided has repeat_count set to 6; this should be 7 if you're expecting 7 daily entries. The count() function will return a zero until there's a valid entry in the field it's counting. Please see the attached XLSForm as a demo. Hope this is useful. Kind regards, Jim

‎01-17-2019

Hi Matt, apologies another question - when older surveys with photo attachments were working successfully, would this have been surveys published prior to the Portal for ArcGIS Privilege Escalation Security Patch being applied? Thanks, Jim

‎01-17-2019

Thanks very much Matt for the additional info. I'll pass this on to our team and keep you up-to-date with any developments. Jim

‎01-17-2019

Hi Dudley One option could be to use the constraint as described, but also have a note that appears immediately below the select_multiple to warn the user when they've selected 'NONE' and one or more other choices, e.g. add selected(${TreeFailureResult}, 'NONE') and count-selected(${TreeFailureResult}) > 1 to the relevant column for the note. Alternatively, you could add a preceding question to control if the user sees the select_multiple, as described here. Jim

‎01-17-2019

Very close!

‎01-16-2019

Hi Nicole Great idea for the constraint. A similar query came up on GeoNet recently - the constraint syntax below might be of use? (With thanks to James Tedrick‌.) if(selected(${category}, 'None') and count-selected(${category}) > 1, false(), true() )‍ Cheers, Jim

‎01-16-2019

Hi Lars For select_one questions the domain values are created in the feature service when the survey is first published, however the domain is not updated on subsequent modifications to the choices in the survey. The workarounds are to manually add the domain values to the existing feature service in ArcGIS Online, or publish the survey again from scratch to create a brand new feature service. The ability to update the domain when republishing from Survey123 Connect has been raised as an enhancement. I'll add your post to our internal discussion and update this thread when we have more information. Kind regards, Jim

‎01-16-2019

Hi again Matt It looks like this issue could be specific to Portal 10.6. Have you recently upgraded to this version? If so, which version were you previously running (when surveys with photos were submitting successfully)? Thanks, Jim

‎01-16-2019

Hi Phillip Thanks for providing your XLSForm. At first glance it looks like this could be a limitation with how the count(repeat) function works in the web form. We're investigating the issue and will get back to you with an update. Thanks, Jim

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by Jim-Moore

Re: Date issue; date field shows one day back

Re: Survey 123 report template not reading survey value syntax

Re: survey123 XLSForm

Re: cursor position when jumping from field to field

Re: Cannot upload attachments

Re: Update coded values

Re: Connect vs. Web form functionality: repeats, calculations, relevant statements

Re: Cannot upload attachments

Re: Cannot upload attachments

Re: Constraint on select_multiple answers

Re: Constraint on select_multiple answers

Re: Constraint on select_multiple answers

Re: Update coded values

Re: Cannot upload attachments

Re: Connect vs. Web form functionality: repeats, calculations, relevant statements

Re: Calculating Hours between two Time questions

Re: Survey123 videos on mediaspace site presenting...

Re: Select_Multiple conditions

Re: Survey123 Report Template Error

Re: Multiple-page Survey123 form