Latest Contributions by LanceCole

Malcolm Little ‌ First is you are getting a lock acquisition error, do you have multiple copies open of the table you are attempting to update? Second use something like TravelMode = speedType (!Speed!) .  "Type" is a function in Python and should not be used as a def name.  It will work, but is poor practice. Third for the Code Block, the way you have it coded "sp" is not assigned a value you have assigned the speed to "modey" when you called your function.  "sp" is only defined as a global and never set.  Your logic also does not handle NULL values or negative values that could be in your data. def speedType(sp): if sp == 0: return "stationary" elif 1 <= sp <=6: return "walk" elif 7 <= sp <= 19: return "cycle" else: return "drive" ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

egypt gas‌, 1) Please insure you have allowUpdates=true (case sensitive with no spaces) in the bind::esri:parameters for the repeat you are trying to edit in your XLSForm.  If you need to include a query statement such as allowUpdates=true query="Editor='MyName'" make sure there is a space between the key value pairs. The query parameter is optional.  Make sure to refresh your survey in the Survey123 App for the changes to show after republishing.  See Prepare for editing existing survey data for additional info. 2) When was your survey published and how was it published?  If using Survey123 Connect,  what version?  There have been recent changes (June 2019)  to the editing ability of Surveys and if your survey was published before this time or using an older version of Survey123 Connect may be your issue. A quick check: go to https://survey123.arcgis.com and logon    Navigate to "My Surveys" Hover over the pencil/designer button for the survey in question and click Go to Settings/Version Tab This will display the version the survey was published - 3.0 in the sample below Select "Always use the latest version" - currently 3.5 Click Save Test your survey now If this works, try downloading and installing he most recent version of Survey123 Connect and/or republish your survey.  You can just use the option noted above, but if your survey is large it may be slow to load. ... View more

Catherine,  Those are the underlying metadata tables for the two surveys you have loaded into your session, DO NOT DELETE THEM. ... View more

Hi Albert,  If/Else and When statements only return the first true condition.  To do this you will need create a variable to hold your return string or list of values to return, check each condition and then return the string.  Something along the lines of the following: (Code is not tested and meant as a sample only) var i = 0; var ret = []; function add(f, s) { if (f == 'y') { ret[i++] = s; } } add($feature["HiF1"], 'Strong and Engaged Leadership'); add($feature["HiF2"], 'The Text for this Feature'); add($feature["HiF3"], 'The Next Feature to Check'); add($feature["HiF4"], 'Etc.'); return Concatenate(ret, ", ")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I believe you could also use a dictionary containing the feature name and text to clean this up even more: var i = 0; var ret = []; function add(f, s) { if (f == 'y') { ret[i++] = s; } } var d = dictionary( "HiF1", 'Strong and Engaged Leadership', "HiF2", 'The Text for this Feature', "HiF3", 'The Next Feature to Check', "HiF4", 'Etc.'); for (var x in d){ add($feature[x], d[x]); } return Concatenate(ret, ", ")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ You can change the comma (", ") in the Concatenate line to what ever you would like to join the strings together.  ... View more