Latest Contributions by Jim-Moore

Hi @ShaneHertzog3 in case you haven't seen it, there's a Community sample available in Survey123 Connect named Water Quality Survey that might provide a good starting point. It's derived from this Water Quality Inspections ArcGIS Solution (now in mature support). Best, Jim ... View more

Hi Nathan, good to hear we're getting there! Note that a few releases back our product name changed from "Survey123 for ArcGIS" to "ArcGIS Survey123" and the name of the install directory was updated accordingly, so it is possible to have an older version and a newer version installed on a desktop machine at the same time. As an example, the old and new install directories for Connect on Windows are as follows: Prior to name change: C:\Users\<username>\Applications\ArcGIS\Survey123ConnectforArcGIS After name change: C:\Users\<username>\Applications\ArcGIS\ArcGISSurvey123Connect More info on installation here. Note that from 3.12 Survey123 supports 'over the top' installations (i.e. without having to uninstall the previous version first). For older versions you must uninstall and then reinstall. Best, Jim ... View more

Hi @KelliW  The time question type stores the time as a text string in "HH:mm" format. One way to convert this to a string that displays the time in 12-hour format would be to use a combination of if(), int(), substr(), format-date(), and concat() functions to take the hours, subtract 12 if required, and then append "AM" or "PM". Here is an attempt at a calculation (in a text question) using a time question named time1. Note that it might need some testing and refinement! if(int(substr(format-date(${time1},'%h:%M'),0,2)) < 12, concat(format-date(${time1},'%h:%M'),' AM'), concat(int(substr(format-date(${time1},'%h:%M'),0,2))-12,':',format-date(${time1},'%M'),' PM')) The condition checks if the hours are less than 12, in which case make this an AM time; else subtract 12 to get the 12-hour time and add 'PM'. For a dateTime question you could use ${date_time | format:"hh:mm A"} in your report template to show the 12-hour time in the report and disregard the date portion (which is probably simpler, but appreciate you don't wish to use a dateTime question). Check out the Dates and Time in Survey123 blog post for more useful info and examples for working with dates and time. Hope this is useful. Best, Jim ... View more

Hi @dgray yes you're spot on - the second if() is the 'value if false' for the first if(). In other words, if Guage_Count does not equal 1 (condition is false), do this other if() statement. The conditions are evaluated in sequence and returns the first 'true' result, so the 'value if false' for the final if() statement will be the result if none of the conditions are true. Each if() must include three arguments. To illustrate the nesting: if(condition, value if true, value if false) if(condition, value if true, if(condition, value if true, value if false)) if(condition, value if true, if(condition, value if true, if(condition, value if true, value if false))) ...and so on. Best, Jim ... View more

PS. Noticed the bind::esri:fieldType is set to esriFieldTypeDouble for the integer questions. If you want these to be integer fields in the feature layer, leave the bind::esri:fieldType column blank and the field type will be set by the question type (in this case, esriFieldTypeInteger). ... View more

Hi Nathan, apologies I should've confirmed this earlier but which versions of the Survey123 field app and Connect are you using? Support for the indexed-repeat() and position(..) functions was introduced at 3.12. You can download the latest from app stores and the Survey123 Resources page. Please let me know what version you're on and we can take it from there! Best, Jim ... View more

Hi Leo It looks like your survey could've been created initially in the Survey123 web designer, is that right? This error message can occur if the survey was first published in the web designer (which creates feature layer views) and you then add fields in Connect and attempt to republish. Please see this reply for some useful info on this. Regarding creating assignments, the usual workflow (as described in Josh's blog post) is to create a survey in Connect from the Assignments feature layer that was created as part of the Workforce project. The survey would then be used to create one assignment per submission. Is your aim to have a survey that would create multiple Workforce assignments per submission? For this to work you would need the assignments layer to be a related table, so you could then use a repeat to capture and submit multiple assignments in the form; however, the Assignments feature layer in a Workforce project is the parent layer, so it wouldn't be possible to use a repeat for this layer. I also note from this reply that it's not possible to specify the feature layer for your Workforce project. Would it be feasible in your case to have a separate form for creating assignments? Best, Jim ... View more

Hi @NKneisel thanks for sharing your XLSForm and the additional info. Looks like an interesting project! I'm still not 100% on the objectives for the form so my apologies if I've missed something, but here are a few suggestions that hopefully will assist you with your form design. I've attached an XSLX file demonstrating some of these calculations. The repeat_count sets the number of repeat records to display in the form. The lyr_depth question used in the repeat_count expression is inside the repeat, so when opening this form the repeat is inaccessible (has a null repeat count so zero records are shown). The repeat count uses count-selected(${lyr_dpth}). The lyr_depth question is decimal; however, the count-selected() function works with select_one, select_multiple, and file attachment questions only.  Similarly, the selected-at() function used for the lyr_depths note only works with select_multiple questions. To return the index of a repeat, use position(..) on its own inside a repeat. There's a default and a calculation for lyr1depth - this should be one or the other. To return the lyr_depth from the first repeat record, the calculation for this question could be indexed-repeat(${lyr_dpth}, ${lyr_calcs_rpt}, 1). Note that the repeat index number must be 1 or greater (i.e. the first record in a repeat is numbered 1, the second record is 2, and so on). You then don't need the additional calculate question. The required_message is 'yes' for some questions. This column contains the text that is displayed when you submit the form and have not completed a required question. You could set required to 'yes' and then add a required_message, e.g. "You must enter a depth for this question." Note that a required/required_message shouldn't be used on a readonly question because the value cannot be modified by the user. For more info on repeats, please see this blog post and documentation. For more info on functions, please see Formulas. Hope this is useful. Best, Jim  ... View more