|
POST
|
Hello, I've done something similar where I have the output be bold in the report if it's above a certain threshold (indicating it's out of compliance). I think this should do what you need. It should only print out the value for the expression that evaluates to true. A few things about the syntax for conditional report formatting that I learned through trial and error.....you might already be aware but thought it could still be helpful to share: the "if" goes within the curly brackets In the above example, I highlighted all of "${question1}", but keep in mind that it's only the formatting of the dollar sign that dictates the final output. This can be useful if, for example, you want to reduce the font size for the rest of the question name to make room in your report template. Also, note that I don't have any spaces between the expressions. It might not read as cleanly, but if you add spaces it will produce them in the final report output Let me know if that works!
... View more
03-01-2023
12:07 PM
|
0
|
0
|
1228
|
|
POST
|
In this case, since there is a set number of entries (maximum of 5 pipes in, two pipes out) I think your best bet will be to have specific questions for each cell. Each column in the table (pipe) could be a different group to help keep things a little better organized in the UI. But that way, you can reference specific field names to pull into the feature report. I know that's not the ideal answer, but as far as I know, you can't format repeats to populate vertically like that. I'd love to know if that's incorrect, though!
... View more
02-28-2023
09:15 AM
|
2
|
3
|
7048
|
|
POST
|
Is the first screenshot you shared what you want the output to look like? I'm not quite sure what you mean by a "sideways" table.
... View more
02-28-2023
08:54 AM
|
0
|
5
|
7058
|
|
POST
|
To get a hidden field to permanently show up in the data table, you have to configure the pop-up through the Visualization tab of the item details page and then save the layer. Not quite sure why the values aren't saving for you....does toggling on sync change anything with that?
... View more
02-24-2023
02:00 PM
|
0
|
1
|
3983
|
|
POST
|
Check out the "Media" sample template in Survey123 Connect. It shows you how to set up images for the choices that looks like this (see below). FYI you can click on the image to enlarge it in the survey interface.
... View more
02-24-2023
01:53 PM
|
1
|
0
|
778
|
|
POST
|
See the section here for "Can I show specific questions based on the answers from other questions?" https://doc.arcgis.com/en/survey123/faq/faqcreatesurveys.htm#anchor3 That should have what you need, but happy to follow up if you have additional questions.
... View more
02-24-2023
01:39 PM
|
0
|
0
|
1234
|
|
POST
|
Thanks, Doug! With the form I'm currently working on, it's getting fairly large because the user specifically requested that everything be contained in one survey so the end-users would "only have to worry about the one survey". I wanted to accommodate and it seemed simple enough at first, but as I've dug in a bit more it's become much more cumbersome. My main concern is simply managing that many fields in a single feature layer within AGOL. I really appreciate you sharing your experiences and advice! Very helpful. 🙂
... View more
02-17-2023
11:49 AM
|
1
|
0
|
3122
|
|
POST
|
Thanks @ZacharySutherby ! Sorry I missed that in my initial research, I wasn't using the right search terms I guess. Appreciate your quick response! A silly question maybe, but can you clarify what is meant by "system fields" in the FAQ? "a survey can contain a maximum of 1,024 columns (including system fields)"
... View more
02-17-2023
11:32 AM
|
0
|
1
|
3133
|
|
POST
|
Hello, I am wondering if there is a recommended best practice for an upper limit to the number of rows to include in an XLS form for a survey. For some complex surveys, with a lot of conditional questions and even entire sections, I've found it's pretty easy to reach several hundred, or even over 1,000 rows at times. Any advice or "lessons learned" stories to share on this topic? Thanks in advance!
... View more
02-17-2023
11:11 AM
|
0
|
6
|
3161
|
|
POST
|
Hi, I think this should work for you. It needs to be in the calculation column, not the relevant column. if(${Marks} = 'None', 'None', '') When using if statements, you need to provide the else condition as well (the third argument). In this case, it's just empty quotes so nothing happens if ${Marks} isn't 'None'. Also, keep in mind that your expression needs to use the name of the choice, not the label.
... View more
02-16-2023
06:05 AM
|
1
|
1
|
2081
|
|
POST
|
Interesting! Well, glad you got it figured out, and thanks for posting your solution here!
... View more
02-06-2023
10:26 AM
|
0
|
0
|
1690
|
|
POST
|
Are you able to share the XLS form? Might be helpful with trying to help troubleshoot
... View more
02-03-2023
09:36 AM
|
0
|
1
|
9222
|
|
POST
|
What does the data look like that you're trying to pull in? I had issues with this the other day, where it worked on PC but not iPad. The facility ID's all had a pound sign (#) in front of all the ID's, when I removed that, it worked. One thing I would recommend for testing is to remove all of the variables you're trying to populate and add them in one at a time. This can help you isolate if there's one particular field/data type that's causing the issue.
... View more
02-02-2023
12:51 PM
|
0
|
3
|
9342
|
|
POST
|
I think the position(..) function should work for this. Use that in the calculate column for a hidden field, then reference that field in the label of the question you want to display. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm
... View more
02-02-2023
07:00 AM
|
2
|
0
|
1162
|
|
POST
|
So, I actually did think about something along these lines, but was worried it would complicate the user interface too much so that the field crew wouldn't be on board... First off, there isn't specific transect data to enter, because one transect is one form submission. So that's good! And having them enter the quadrat number wouldn't be too bad... I want to make sure I'm following what you're suggesting though. Are you saying that for a record in the repeat they would enter a species name (from a standardized drop down) and the percent cover and the quadrat number it's in, and then click the + sign for a new record for each new observation?
... View more
01-26-2023
10:12 AM
|
0
|
1
|
2663
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 1 | a week ago | |
| 2 | 2 weeks ago | |
| 1 | 3 weeks ago |
| Online Status |
Offline
|
| Date Last Visited |
Friday
|