Latest Contributions by DerrickWestoby

‎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.

‎12-28-2020

Ismael or James, is there a way to limit a (repeat) table in a feature report to a maximum number of records, continuing on with the rest on a new page if needed? I have a 1-page report that contains a 15-row table in it for the repeat values, as well as other unrelated tables below it. Instead of leaving a large amount of white space at the bottom of the page (instances where only a few repeat values are included) OR pushing them onto the next page (instances where >15 repeat values are included), I was hoping to format the pages and the report generation in a way that it will accept up to 15 entries for 1 page, and then duplicate the entire 1st page (with it's 15-row table) as page 2 and continue filling in all of the values, repeating as many times as necessary. An idea I had for accomplishing this was putting *everything* except my 15-row table into the header or footer and formatting from there as needed, but wasn't sure if that was the easiest approach. Thank you

‎12-23-2019

Thanks for the quick reply, Xander. The end goal is making a project-specific dashboard, which would include multiple Survey123 (company-wide) surveys. Our field staff uses a S123 form, called "Daily Field Report", on more than one project. What we'd like to be able to do is having those feature layers filtering into project/client specific dashboards based on project numbers. On this survey, Layer 0 contains general site information for that trip (client name, project number, site location, weather, etc) and layer 1 is a repeat that contains photos and comments about specific observations (found contaminant in room 27, etc). Internally, our project managers and field staff can view the private "Daily field report" dashboard to see what all of our field staff are doing and what sites they're working on. Externally, we'd like to be able to offer these same dashboards to clients, but only showing data for their specific site.

‎12-23-2019

Xander Bakker - Can you please tell me if it's possible to create an arcade expression that will return a value from a layer's parent layer? I have a feature layer created in Survey123 with two layers. Layer 0 has a "projectnumber" attribute in it and I would like to filter layer 1 (the repeat layer) to only display features for a certain project number, with that project number value being pulled from it's parent feature.

Online Status	Offline
Date Last Visited	‎09-13-2024 07:27 PM

My Ideas

Latest Contributions by DerrickWestoby

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: Understanding Survey123 Feature Reports

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

Re: Operation rolled back (No recent changes)

Re: Operation rolled back (No recent changes)

Re: Suggested Software and Workflows

Re: Site Scan Flight App: What Drones Next?

Re: Survey123 Email Attachments using Gmail in Int...