Latest Contributions by Jim-Moore

Hi @LeoDeRuiter looks like there's an issue with the if() statement for the assignmentType question. An if() statement requires three arguments: a condition; the result if the condition is true; and the result if the condition is false, i.e. if(condition, value if true, value if false). The final false argument is missing (i.e. what to return if all conditions are false); also the parentheses need to enclose the whole if() statement in each case. Please try something like: if(selected(${requestm}, "Yes"), 1, if(selected(${requestl}, "Yes"), 2, if(selected(${requestnm}, "Yes"), 3, if(selected(${requestnl}, "Yes"),4,'')))) Note the additional empty '' value for the final false argument. An if() statement returns the first true argument, e.g. the requestm question is evaluated first, so if requestm = 'Yes' then assignmentType will be 1, regardless of the answers to the other three questions. As a side note, please see this useful blog post by my colleague Josh Clifford regarding setting up Workforce assignments in Survey123. Best, Jim ... View more

Hi @JamieUrquhart the cascading selects are almost there. Please see an example attached, which demonstrates cascading selects for the catchment and site_ID questions. Note that the syntax used here is column_name=value, where column_name is the column header on the choices sheet (e.g. 'partner') that contains the values for the filter, and value is the value to filter on (e.g. ${partner}). I wasn't sure about the local_name question, but it appears this is a 1:1 relationship with catchment_name, in which case you could just add the corresponding catchment name to the catchment column for this choice list and then use the catchment=${catchment} expression in the choice filter column. In addition to the Connect sample, there's lots of great info and examples in this blog post which could be useful. Hope this helps! Best, Jim ... View more

Hi @AlainChouinard  The suggestion from @Anonymous User is a good one - if you get the column order set up in another workbook first, you can then copy/paste the whole lot into the new template (at cell A2). Should be significantly quicker than copying each column one-by-one. It is recommended to always use the paste values option when copying and pasting any content (cells, rows, ranges) in the survey worksheet, as this will ensure the data validation is preserved and erroneous links to other workbooks are not created. Please see this blog post for a few best practices that might be of use. Best, Jim ... View more

Hi @FedericoRiet_Sapriza  Thanks for the screenshot of your XLSForm. Try using the round() function in your calculation, instead of int(). As described in this GeoNet post, in the field app the int() function discards the decimal places. Here is the calculation split into a few questions - you can see the number of months should be rounded to 24: Hope this helps, Jim ... View more

Hi @DavidBuehler there shouldn't be an issue passing values to a question inside a group; however, you cannot pass a value to a question inside a repeat. You can pass values to questions inside groups (or pages) using the same field:fieldname={value} syntax that you would use for a question outside of a group. Please see this documentation for more info on URL scheme and parameters. Hope this helps, Jim ... View more

Hi @Anonymous User  Your syntax is almost there, however, for these expressions in a report template, you need to use the choice and question names (not their labels). For select_one questions you can also use the following 'selected:' syntax: ${if Unknown | selected:"emergence"}Your conditional text goes here.${/} This is equivalent to: ${if Unknown == "emergence"}Your conditional text goes here.${/} To check if a choice is not selected, you can use: ${if Unknown != "emergence"}Your conditional text goes here.${/} If you haven't already seen it, there's a really useful quick reference that provides syntax examples for all the questions in your survey (see link on the Manage Templates dialog): More on conditional elements can be found here.  Hope this is useful Best, Jim ... View more