Latest Contributions by DerrickWestoby

‎07-30-2021

Here you go https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-embedding-a-survey/ba-p/899140

‎07-22-2021

Your dummy field should be OUTSIDE of the repeat. The issue you are seeing happens when you are adding a new field within a repeat, but no changes outside. Add a field like delete_me outside of the repeat, publish, then remove it and republish.

‎07-22-2021

You can embed a web format of your survey into a dashboard. Use a list element to display responses, then an action to load an edit version of the survey123 form (allowing your affected workers to update the location). I'm on my phone right now and can't find the post, but there is a survey123 blog describing this process.

‎07-21-2021

Sorry if you were already aware of this, but I just wanted to make sure that you saw this note in the "Dynamic choice lists" post in the early adopter community: Important: All ArcGIS layers have a maxRecordCount setting that determines the maximum number of features that can be returned in a single query. This can have implications on the number of choices that will be populated in a choice list, especially when the search() appearance is used without any other search parameters (ie only the tableName parameter is specified - you want all features to be loaded as choices). For example, if the maxRecordCount setting is 2,000, but the layer has 5,000 features, the resulting choice list will only contain a maximum of 2,000 choices. Using search parameters (searchType, searchColumn, searchText) helps reduce the impact of the maxRecordCount setting by reducing the number of query results, but in some circumstances you may need to increase this value. This Tech Support article shows how to update the maxRecordCount value. I think that the linked content approach that @DougBrowning recommended is probably the best approach.

‎07-21-2021

What about using once() on the geotrace calc, along with adding a condition to the relevant column that the geotrace isn't calculated until you have 2 repeat entries, using count()? I don't know if this will work or not, but I did use the relevant/count approach when geoshape & geoshape were first released to keep from having to hit the refresh button on the geoshape once 3 or more repeats were added. I'm assuming that using once(sum(${repeat_location}) for the geotrace calc would work, but haven't tried it. edit: After re-reading, hopefully I'm not misunderstanding the question too. I'm assuming that you're just wanting to calculate a 2-vertex line out of any random two geopoints in a repeat, and that it only needs to happen once, and you don't care which 2 points. Now that I noticed you're creating a tool for surveyors, I'm thinking I misunderstood the workflow. Is this just a tool for them to input coordinates and calculate a projected bearing and distance as-needed or something? I guess a different approach if that is the case could be to create nested repeats, where the the geotrace is contained within a repeat and max-2 geopoints are contained in a nested repeat. I assume this would allow the surveyors just to add + a new repeat (the geotrace) each time they need to do a new calc, instead of changing the existing points and refreshing the existing geotrace. Apologies if I'm way off the mark on one or both of these comments...

‎06-28-2021

In my tables, I only call & close the repeat once per row. I'm not sure if that's the problem or not, but I would try this: ${#station_depth}${station} ${depth} ${Offset}${/}

‎06-21-2021

@JamesTedrick , would you mind helping to clarify this answer? I've tried everything I can think of to get it to work, but no luck so far (and this is something we'd like to do on other reports, so it would be widely used). The doc I attached is the one I've been using as a test to get that table displayed as needed. The first table in there works great to summarize by tree condition, but still no luck with the By-Species table at the very end.

‎06-14-2021

Hey James, thanks for the response. Do you mean I should have something like this in the "Poor" column? ${#trees_repeat | stats:"count,objectid,PoorCount":"tree": "" | where:"condition='poor'" | orderByFields:"tree ASC" }${PoorCount} I thought I tried that last week, but maybe it was just a syntax error I was getting if so. If I'm way off, would you mind giving an example?

‎06-11-2021

Good Morning, I have a Survey123 form for a Tree Inventory survey which contains a repeat (${#trees_repeat}). Within the repeat, I have a field that lists the species of the tree ( ${tree} ) and the assessed condition of the tree ( ${condition} ), populated from a list with values like "poor", "fair", etc. My feature report template includes a table listing every individual tree by ${tree_ID} that is working well: but I also need to create a summarized section with a count of condition ratings, grouped by species. Here is an example from the reports that are arborist are currently making manually, which is the goal I'm aiming for: And this is as close as I've been able to get thus far (orderBy and the TreeCount for each species working as I want it to, but I'm not sure how to summarize the condition counts for each species in the table): The code I'm using in the feature report table to print out the repeat records sorted by species is: ${#trees_repeat | stats:"count,objectid,TreeCount":"tree": "" | where:"1=1" | orderByFields:"tree ASC" }${tree} And the whole table (including the counts by conditions for all the records in the repeats, not just the species) Species Count Excellent Poor ${#trees_repeat | stats:"count,objectid,TreeCount":"tree": "" | where:"1=1" | orderByFields:"tree ASC" }${tree} ${TreeCount} ${trees_repeat | where:"condition = 'excellent' " | stats:"count,objectid"} ${trees_repeat | where:"condition = 'fair' " | stats:"count,objectid"}${/} If what I'm after is possible, I assume that I need to add in these other summaries to the code in the first column using multiple outStatistics parameters, but I haven't been able to figure out how to include a filter or where clause for just those specific outputs/results. I was thinking something like this (which doesn't work): ${#trees_repeat | stats:"count,objectid,TreeCount;count,condition='poor',PoorCount":"tree": "" | where:"1=1" | orderByFields:"tree ASC" } Any help would be greatly appreciated. I've been using the help doc here as a reference, but haven't been able to make it work for my purposes - Report queries—ArcGIS Survey123 | Documentation Thanks

‎04-30-2021

It looks like changing the polygon appearance in the "visualization" page of the survey's feature layer is what affects the appearance of the polygon.

‎04-30-2021

Correct on the first half. The web map I am using only has a feature layer with points in it (the checkboard pattern. EDIT: Sorry, the black circles. I forgot what screenshot I had used). There is no polygon layer in the web map. The displayed polygon is just the geoshape from the S123 form and that's how it's displayed when the map renders (even if you just use ${geoshape} in the feature report, without specifying a web map ID).

‎04-30-2021

Say what now? I *want* the symbology of the other (point) feature layer in there. That's supposed to be displayed. The stroke & fill appearance of the polygon from the geoshape question in the XLS is what I'm trying to change in the feature report. How do I change the appearance of that polygon in the feature report?

‎04-29-2021

Good Morning, Is it possible to change the appearance of geoshape polygons in the Survey123 feature report yet? I have a feature report that shows mapping extents on a web map with an underlying dataset that contains symbols and labels and the default fill color of the polygon in the rendered map obscures the other symbiology. Thanks

‎04-16-2021

I have a feature layer with ~9,000 point features that contain a photo attachment. I could never get backups to succeed for this, so I tried out "CivicLens" in the ArcGIS Marketplace and ended up buying it. It's been working great for about 6 months now. (Backup size is currently 8.5gb)

‎04-14-2021

This was a very helpful post, Josh. Thank you for taking the time to post those examples.

Online Status	Offline
Date Last Visited	‎07-11-2025 11:41 AM

My Ideas

Latest Contributions by DerrickWestoby

Re: Best Workflow for editing point location after collecting survey

Re: Survey123 hangs up on "checking feature service" when trying to publish already published form

Re: Best Workflow for editing point location after collecting survey

Re: Using a feature layer for predictive text and auto-populate in Survey123 Connect

Re: Calculating a geotrace from 2 geopoint repeat records

Re: Populating a table in a print template from repeats in Survey123 form

Re: Feature Report summary statistics / aggregate functions for orderBy with multiple filters

Re: Feature Report summary statistics / aggregate functions for orderBy with multiple filters

Feature Report summary statistics / aggregate functions for orderBy with multiple filters

Re: Feature Report - Geoshape / Polygon appearance

Re: Feature Report - Geoshape / Polygon appearance

Re: Feature Report - Geoshape / Polygon appearance

Feature Report - Geoshape / Polygon appearance

Re: How to back up a feature layer along with the attachments

Re: Related Tables in Arcgisonline

Re: Survey123 reporting service down?

Re: Adding Domain to Existing Feature Service

Re: map zoom level when clicking on item list

Re: Operation rolled back (No recent changes)

Re: Operation rolled back (No recent changes)