Latest Contributions by Jim-Moore

Hi Nicole Looking at your IF statement and the last line of the error message, it looks like the false argument is missing from the final nested IF statement (i.e. the value to return if all arguments are false). IF statements require three arguments: if(condition, value if true, value if false). So your calculation could look like: if(${CurrentCapacity}>${Capacity_Total}, 'Over Capacity', if(${CurrentCapacity}=${Capacity_Total}, 'At Capacity', if(${CurrentCapacity}<${Capacity_Total}, 'Under Capacity','No capacity entered'))) If you want to return null instead, use '' in place of 'No capacity entered'. Hope this helps! Best, Jim ... View more

Hi Fiorella Many thanks for the XLSForm. I stripped the survey down to retain only the calculations that are causing an issue, namely the s# and l# sets of questions. If I further reduce the number of calculations I get to a point where 23 or 24 sequential calculations will work, but any more than that and Connect crashes. I'll investigate further and get back to you. One thought though is perhaps there's a way to achieve the same result without the need for all the iterative calculations? The ${calc_cant_lect} question returns how many readings have been entered. Would it be possible to replace the 60 x l# questions by using this number along with ${calc_fact_dat} in a calculation? Something like: (${calc_cant_lect} * ${calc_fact_dat}) - (${calc_fact_dat} - 1) Or... ((${calc_cant_lect} - 1) * ${calc_fact_dat}) + 1 Not sure how that would affect your calculations further down the form. Best, Jim ... View more

Hi Fiorella Thanks for the additional info about the crash. Strange! Would it be possible to share your XLSForm so I can help troubleshoot? Also please note the latest version of Connect is version 3.9.120 (released last week). Best, Jim ... View more

Hi Yaser The 'or' operator evaluates two expressions and returns 'true' if either of the expressions is true. If set up correctly an 'or' expression should return true or false. For example, you could use an expression like the one below in the relevant column to show/hide a question if either of the expressions is true, or use it inside an if() statement: ${age} < 20 or ${age} > 60 XLSForm operators are listed here: Formulas—Survey123 for ArcGIS | Documentation    You cannot use 'or' to substitute one calculation or value for another. Could you please provide some more detail on what you're trying to achieve with the calculation and what your expected result is so I understand the logic? If you could share your XLSForm that would be useful; you can attach files to your post using the 'advanced editor'. Best regards, Jim ... View more

Hi Fiorella Perhaps a pulldata() function would be useful for your survey. This method allows you to do a lookup from the values in an external CSV file. Please see a great explanation on this method here: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-data  And more here: Formulas—Survey123 for ArcGIS | Documentation  Regarding the crashes, which version of the app are you using and on what device and OS version? Best, Jim ... View more

Cheers Ben, glad to hear it's working well! ... View more

Hi Louise Thanks for the screenshot. In XLSForm, the operator for division is "div". If you replace the forward slashes with "div" this expression should work, i.e. (((${max1}-${min1}) div ((${max1}+${min1}) div 2))*100)<=10 XLSForm operators and functions are described here: Formulas—Survey123 for ArcGIS | Documentation  Hope this helps. Best, Jim ... View more

Hi Jules Could you please provide your XLSForm and a bit more detail (perhaps as an example) on what you're hoping to achieve? You can attach files to your post using the 'advanced editor'. Thank you, Jim ... View more

Hi Branden At first glance your XLSForm looks okay (besides a superfluous closing parenthesis on the location calculation). Could you please provide your XLSForm and CSV so I can take a closer look? You can attach files to a GeoNet post using the 'advanced editor'. Best, Jim ... View more

Hi Michael You could use an IF statement inside the Google Sheets module for the target date field, i.e. if the incoming date question is TRUE (contains a value) write the formatted date, else write null. The function might look something like: Hope this helps. Best, Jim ... View more

Hi Kristin Would it be possible to provide your XLSForm so I can take a closer look? You can attach files to a GeoNet reply using the advanced editor. Thanks, Jim ... View more