Latest Contributions by Jim-Moore

Hi @ElizabethHovsepian thanks for providing your XLSForm and report template. The photos question is inside the tasks repeat, so in the report template this question must be placed inside the repeat's start and end tags (noting that if your repeat is in a table, the start and end tags must be in the first and last cells in the table, respectively). Please find attached an example report template showing a couple of options: The photos question included in the table with the other repeat questions, so that you'll get each repeat record and its photos in pairs of rows. Note the two closing tags ${/} - one for the repeat, the other for the multiline image question. A second repeat section that shows the photos question only - this will output all photos submitted across all repeat records.  For more information, please see the section on repeats in the Report templates documentation. Hope this helps. Best, Jim ... View more

Hi @JulietK  That's strange! A couple of things to double-check to help with troubleshooting: Which version of Connect and the field app are you using? Was the content in the CSV saved before you updated the form preview in Connect? Best, Jim ... View more

Hi @GIS_1234_KS  In Connect, you can customise the text that appears in the thank you screen in the web app using a note question with generated_note_prompt_submitted as the question name. This supports using question placeholders in the label (and also HTML), so for example the label for the question could read something like: Thank you for taking part. Your URN is <font color="red">${urn}</font>. You can also customise the text for the footer, submit button, and more. Please see the Rewrite UI elements documentation and the Survey123 Tricks of the Trade: Introducing Multilingual Surveys blog post for more details. Hope this helps. Best, Jim ... View more

Hi @JonahW  The media::image column accepts a file name (with extension) only - you cannot use expressions in this column. One way to approach this would be to have a separate note question for each image, then use an expression in the relevant column to show the note that corresponds to the selected flush day, e.g. ${flush_day} = 'Monday_1'. Another approach would be to include an image for each choice in the FlushDay choice list by adding file names to the media::image column on the choices sheet; this will show the image as a thumbnail alongside each choice for the select_one question. Tapping/clicking on the thumbnail will open it in full-screen. Note that file names are case-sensitive in XLSForm so be sure to enter these exactly. Check out the Media sample XLSForm in Connect for a demo and also the Media documentation for more. Hope this helps! Best, Jim ... View more

Hi @DavidBuehler  At first glance, I think a JavaScript function would probably be most suitable for solving this problem. That said, please find attached an attempt at solving it using XLSForm functions alone. There's probably more than one way to accomplish this but hopefully this provides some ideas. Your calculations for finding the occurrences of each rating were a great starting point; I've simplified them slightly by making the counts = 1 (so no need to then do a separate division by the rating). While finding the maximum rating is straightforward, the trickiest part is determining the second-highest rating. I've used a combination of nested if() statements with the max() function to get a result. I wasn't sure what should happen if all ratings are the same (i.e. there is no second highest rating). In the attached example, the calculations should return zero for the second highest rating if all ratings are the same. For example, if all five ratings are 4, the result is 4500. A disclaimer that these calculations would need to be tested thoroughly to ensure they're working as expected. Hope this is useful. Best, Jim ... View more

Hi @MarkEastwood your syntax above is almost there, but try enclosing the emoji in quotes, e.g. concat(":warning: ","<b>Subregion:</b> ", ${subregion}, " &#9888; ", "Circuit: ", ${circuit}, " ", "Span From: ", ${span_from}, " ", "Span To: ", ${span_to}) Also ensure you're copying and pasting the actual emoji character into the string in Excel. The link that Ismael references in this post is a useful reference for emoji characters. Hope this helps. Best, Jim ... View more

Hi @JamesBotterill4 you can use the following syntax to print the name of a choice (instead of its label) for a select_one question: ${condition | getValue:""} If you haven't seen it, there's a useful quick reference that provides report syntax examples for your survey questions. You can access it from the Manage Templates dialog. See this post for more info. Hope this helps. Best, Jim ... View more