|
POST
|
Hi @LuisGarcia6 just to double-check, is the choice filter expression in the choice_filter column? If possible, could you please share your XLSForm so I can take a closer look? Best, Jim
... View more
05-18-2021
09:02 PM
|
0
|
2
|
1351
|
|
POST
|
Hi @JulietK good to hear it's working as expected in the field app. Just a note about the templates - the Advanced and Standard templates available in Connect are updated at each release (as indicated on the Version sheet). When creating a new survey from a template you will always get the latest version of the template, regardless of which version of Connect you're using.
... View more
05-10-2021
06:00 PM
|
1
|
0
|
3388
|
|
POST
|
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
05-09-2021
11:13 PM
|
2
|
8
|
16564
|
|
POST
|
Hi @SummerlynBingaman The web app only supports decimal time, while Connect and the field app support both Epoch time and decimal time. Converting your dateTime questions to decimal time using the decimal-date-time() function should do the trick. For more info please see the Dates and Time in Survey123 blog post and the Decimal date time documentation. There's also a Dates and Times sample XLSForm in Connect that has some examples (in particular, see the calculation for lunch break duration). Hope this helps. Best, Jim
... View more
05-09-2021
10:30 PM
|
0
|
0
|
1129
|
|
POST
|
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
05-09-2021
10:19 PM
|
0
|
2
|
3413
|
|
POST
|
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
05-09-2021
10:07 PM
|
2
|
1
|
1582
|
|
POST
|
Hi @Jaileen91 it sounds like you would like to capture a date range, is that right? The date and dateTime question types in Survey123 allow you to record one discrete date (and time), which gets stored in a date/time field in the feature layer. If you're recording a range of consecutive days you could have two date questions in your survey - one for the start date and one for end date. If you're using Connect, check out the Dates and Time in Survey123 blog post for some useful info; there's also a Dates and Times sample XLSForm available in Connect. Best, Jim
... View more
04-28-2021
07:41 PM
|
0
|
0
|
1195
|
|
POST
|
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
04-28-2021
07:29 PM
|
0
|
1
|
2958
|
|
POST
|
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
04-20-2021
08:49 PM
|
1
|
1
|
2783
|
|
POST
|
Hi @JustinCallahan further to @Anonymous User's comments, one method that might be useful in this case is to use the autocomplete appearance on a select_one_from_file question. If the 'label' field in your CSV includes both the project ID and the project name as one string (you could concatenate the two together, e.g. "A12345-Project Name 1"), users will be able to search for either the project ID or project name in the one question. You could then have the project ID as the 'name', so that would get stored in the select_one_from_file question; and then in a separate hidden question retrieve the project name from another column in the CSV. So your CSV might look something like: name,label,ProjectName A12345,A12345-The Main Project,The Main Project B34211,B34211-Another Project Name,Another Project Name C49592,C49592-Project Number 3,Project Number 3 ...etc... Hope this helps. Best, Jim
... View more
04-13-2021
11:23 PM
|
0
|
0
|
1075
|
|
POST
|
Hi @MarkEastwood your syntax above is almost there, but try enclosing the emoji in quotes, e.g. concat(":warning: ","<b>Subregion:</b> ", ${subregion}, " ⚠ ", "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
04-11-2021
09:23 PM
|
0
|
0
|
1106
|
|
POST
|
Hi @JoshBillings one way to overcome this would be to pad the single-digit minimum ages with a zero, so for example 5-18 would be stored as "05-18". You could build this into the calculation using a nested if() statement to add a leading zero if the minimum age is greater than zero and less than 10, for example: if(${age_group}='all_ages', 'All ages', if(${min_age} > 0 and ${min_age} < 10, concat(0, ${min_age},' - ',${max_age}), concat(${min_age},' - ',${max_age}))) This should sort the values correctly in your dashboard; if you want to remove the leading zeroes it looks like you could then use the Load Categories setting for the category selector to modify the labels for each age group individually. Best, Jim
... View more
04-07-2021
04:11 PM
|
0
|
0
|
4475
|
|
POST
|
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
04-06-2021
07:11 PM
|
0
|
0
|
1514
|
|
POST
|
Hi @JulietK yes the jr:choice-name() function should work inside an if() statement and your example looks good to me. Best, Jim
... View more
03-31-2021
05:20 PM
|
1
|
1
|
2645
|
|
POST
|
Hi @JoshBillings thanks for the screenshots. Not sure what's causing the NaN error in the web app without seeing your XLSForm, but please see example survey attached demonstrating one way to set up the questions. The calculation for age group uses the if() and concat() functions to return the formatted age range. If you don't want to store the min/max age fields in the feature layer you could set bind::esri:fieldType to null for these questions. Hope this helps! Best, Jim
... View more
03-31-2021
05:02 PM
|
1
|
2
|
4550
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-25-2020 06:40 PM | |
| 1 | 08-11-2024 10:11 PM | |
| 1 | 08-04-2019 06:44 PM | |
| 1 | 01-08-2025 03:26 PM | |
| 1 | 06-29-2020 07:21 PM |
| Online Status |
Offline
|
| Date Last Visited |
4 weeks ago
|