Latest Contributions by Trippetoe

Hi @Neal_t_k I've wandered pretty far down the 'roll-my-own-report-with-python' path. It's probably too far to back out of that path now 😉 Thanks again for all your help.

Thanks for the link. I've been looking for something like that. There are a couple hundred sites so that may not be an efficient approach for this problem. I'm looking at other programmatic python based pdf report generators now. The Survey123 Report generator just may not be the right tool for this situation.

Hey @Neal_t_k Thanks for your super fast response. Agreed that just storing the label value is the easiest for reporting. The reason it's not my preferred approach is that currently i am storing the 'id' value which can never change whereas the 'label' value can and does change. The data is the 'location' where the work was done - its id value wont/cant change based on company 'business rules'. However the name of the site can change. It doesn't happen often, but it does happen. In those cases, i'd have to go back thru all the previously submitted records and change the location label value. So, it's a classic data maintenance and QA/QC reason for not storing the 'label'

Greetings. In my survey i have a select_one question where the answers are populated via 'autocomplete search()' functionality. The 'name' value, that is the 'id' of the selected answer, is being stored in the survey's feature class as the actual answer to the question. The 'label' value of the selected answer is stored in the Survey as a calculated field but its esri:fieldType is 'null' so i think it's value is not kept when the survey is submitted. Is there a way to get that 'label' value for display in the survey Report template. The 'id' value won't mean anything to Report readers; only the 'label' will. Thank you

‎07-09-2025

Perfect! 'join' is exactly what I was looking for. Thank you. A few 'concat' statements later, i've got the sql query working exactly as needed.

‎07-08-2025

Hello. I'm wondering how to get the all values from a 'select_one' question that exists within a repeat. Ultimately, I'd like to use that list of values in a 'search()' expression to populate the list of values to that select_one in the 'next' repeat. I'm confused just re-reading that last sentence, so here's some background. My survey is used to track 'treatments' of various trees. Each tree has a unique 'tree tag id'. A single survey can be used to track treatments for any number of trees. The 'TreeTagId' is a select_one question within a repeat. I am hoping to create a drop-down list of tree tag ids that does not include any tree tag ids already selected in the survey. To do that, I'm using the approach described here to create a URL query that excludes previously selected tree tags. So, something like where=treetagid NOT IN ('101', '102', '103') . In that example, the user has completed three 'repeats' and selected tree tag ids 101, 102, 103. So in the 4th repeat, none of those TreeTagIds would be in the select_one list. I hope that makes sense.... As a new repeat is added, I am hoping to somehow 'iterate' over the previous repeats, pull out the value of the 'TreeTagId' question and append it on to the 'where' statement to be used in the 'search()' calculation for the TreeTagId select_one of the new repeat. Is such a thing possible? Thank you

‎04-01-2025

@MikeSweeney This is fabulous. Thank you for the example code!

‎03-17-2025

I figured it out. I needed to open / create my notebook after opening a Lake House in my workspace so that the notebook was in the 'context' (i guess) of a lake house. When i got the error, i had started by creating a new notebook as a sort of 'stand alone'. All is working as expected now.

‎03-17-2025

Hello. At the Dev Summit i had a great conversation with someone (Noah maybe) at the GeoAnalytics booth about getting AGOL data into Fabric. He pointed me towards the 'GeoAnalytics in Fabric' blog. This first morning after the Dev Summit i was excited to get started testing some of the functionality. I had our Fabric Admin enable the required tenet setting, and fired up my first notebook. I copy/pasted the first bit of example code, and ran into an error. import geoanalytics_fabric from geoanalytics_fabric.sql import functions as ST spark.sql("show user functions like 'ST_*'").show() There was a much longer exception message, but this part seems to be the summary, maybe AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.) The next section of code (creating a data frame and echoing out the schema) worked fine. I'm gonna keep on plugging thru the tutorials, but is there something i need to do, like creating a lakehouse, before i can run that first bit of code (and maybe other sections as well)?

‎02-20-2025

Hello. We have several older data processing scripts that manually sync data from AGOL to our enterprise spatial databases (in older person's vernacular - SDE databases). Generally speaking, the scripts - find the last date the script ran successfully - find data in a hosted feature service that have a last edit date more recent than the last date the script ran successfully - export that data as a file geodatabase (fgdb) - inserts/updates data in SDE based on fgdb I am starting a new project that needs to do the same basic process - one-way sync of data from AGOL to an SDE database, but before i follow the tried-and-true well-worn path, i am reconsidering the approach to see if there are other, better ways of completing the task. I've spent some time reading the REST API docs about sync functionality, but i haven't seen anything that specifies a sync client that's an SDE data table(s). Or any workflow examples that match what i'd like to do. I'm wondering if there are better / alternative ways of performing the sync from AGOL to SDE than the manual approach we're using now. Thank you

‎01-17-2025

It's looking like this is a bug. Interestingly, if you use the "Inbox" to open the survey, the cascade works as expected - for example, clearing out Q1 clears out Q2. However, if you use the "Sent" folder, the cascade does not work as expected - clearing out Q1 has no effect on Q2. In fact, I can't change the value of Q2 at all.

‎01-14-2025

Thanks for your suggested workaround. I'll give it a try. There's already a complicated relevant statement on the field. Might as well add some additional complexity 😉 I've filed a bug report with Esri about this behavior, and i'm working with the Esri technician to identify what's going on. I'll let you know what i learn about this.

‎01-13-2025

Hello. I have a survey that has a standard cascading select so that selecting a value in Question 1 (let's say "State" is the question) impacts the possible options in Question 2 ( and "State capital" is the question). When a survey response is first created, I am seeing the expected behavior when selecting and clearing the value in Question 1. For example, if I've selected, say "Oregon", in Question 1, and then "Salem" is selected in Question 2. If i then clear "Oregon" from Question 1 answer, "Salem" is cleared from Question 2. However, if the survey has already been submitted and the user is coming back to edit their responses, the expected 'auto-clearing' of Question 2 does not happen when Question 1 is cleared. And worse, when selecting a new value in Question 1, the value in Question 2 does not update. So, its possible to have the value "Alabama" in Question 1 and "Salem" in Question 2. This seems like a bug to me. Has anyone else seen this behavior? I am using Survey123 Connect 3.19.116 and viewing the survey in Survey123 Android 3.19.121 Thank you

‎12-10-2024

I'd like the ability to apply 'sensitivity' labels to items in AGOL, particularly hosted feature layers. Application of the labels would be optional and could be set by either the item owner or an Org Admin. I'm imaging a workflow and presentation like the current 'Authoritative' tag that users can apply to AGOL items. Specifically, the tag would appear alongside the layer's name in Item Details pages where ever the layer is used. The purpose of the label would be to provide one more reminder to users of the sensitivity of the layers they are adding to a map. Yup, groups can certainly limit access to data and other agol items, but it'd be nice to have that additional reminder to a user that a certain hosted feature layer is 'confidential' and should be used with appropriate caution and restraint. AGOL could follow sensitivity labeling patterns established by Fabric and Power BI

‎11-04-2024

Hi @Laura . The Arcade approach that you linked to is working for me. Thanks again for the tip.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by Trippetoe

Re: Display a select_one label in a Report template

Re: Display a select_one label in a Report template

Re: Display a select_one label in a Report template

Display a select_one label in a Report template

Re: How can i access answers to a specific question in a collection of repeats

How can i access answers to a specific question in a collection of repeats

Re: Can arcade return the coordinates of a map click?

Re: Problem with getting started with GeoAnalytics in Fabric

Problem with getting started with GeoAnalytics in Fabric

How to do a one-way sync from AGOL to enterprise spatial geodatabase?

Re: Clearing a cascading Select not working in Edit mode

Re: Clearing a cascading Select not working in Edit mode

Clearing a cascading Select not working in Edit mode

Apply sensitivity labels to AGOL items, particularly hosted feature layers

Re: Create a Point symbology that uses color and shape from two attributes

Re: Problem with getting started with GeoAnalytics...

Apply sensitivity labels to AGOL items, particular...

Re: Repeat Always Creating Record

Links in Experience Builder popups fail WCAG stand...

Re: Create a Point symbology that uses color and s...