Latest Contributions by erica_poisson

‎09-13-2023

Hi - I am developing a summary report and running into an issue. After re-reading the tricks of the trade blog about summary reports, I am confused about the behavior I am experiencing. It seems as if filtering and aggregate functions within a summary report should honor the selected records from the Survey123 website when generating a report, unless the !important parameter is used. So far, most of my summary report is working properly and returning what I'd expect. I have a table w/ aggregate functions that is returning responses based on the entire hosted feature layer instead of on the selection made in the Survey123 website. I am wondering if this is expected behavior, or if I have done something wrong with my syntax. Here is the summary section causing issues (full template attached): ** Update: The problem appears to be an issue in multiple sections of the template - namely "Inspection Conditions" and the last section "Details...". In both instances, the counts returned are for all records for each CGP File Number, instead of only the remaining records after Filtering and selections are made on the Survey123 website. In the Survey123 website, I have 9 parent records selected; I've checked and all repeat records have been properly filtered based on the selection. When I generate a preview report, instead of getting the above information for each of the 9 selected records, I get it for every CGP File Number in the hosted feature layer if the 'where' clause has been met. Can anyone provide advice on why this is? Is this expected behavior? Here are the Filters applied on the Survey123 website: This narrows me down to 195 Site Visit Inspections that meet this criteria (and are associated with the 9 parent files), however the total number of Site Visit Inspections for these 9 parent files is being included in the report (673). Thank you,

‎09-13-2023

I've spent the last week or so performing various tests with Esri Technical Support; it appears that somehow this Survey123 form item in AGOL or the XLSForm itself became corrupted. The solution was to create a brand new Survey123 form and to publish that from the most recent version of Connect. I'd been trying to avoid this as this form is embedded in an Experience Builder app for data entry and has multiple webhooks associated with it, but this seemed like the only option and worked to resolve the issue

‎09-06-2023

Hi @ZacharySutherby , No, that option is enabled. Thanks,

‎08-31-2023

Hi - I made a very minor change to an established Survey123 form by updating the label for a question in the form. I republished from Survey123 Connect version 3.18.123. This form is used as a web form, and when my user checked again, the label was not changed. I downloaded Survey123 Connect version 3.18.124 and tried to republish again - same thing, the change was not honored in the web form. I then opened the Survey123 form in the mobile app on my iPhone (app version 3.18.145) and the change was present in the mobile version of the form. This seems to be a bug and I will open a case with Esri Tech Support, but also wanted to ping @IsmaelChivite w/ this info. Thank you,

‎08-28-2023

Using pulldata("@layer") works well to solve this issue, however I still think this could use some finessing from the Survey123 team to make this work without pulldata... Some cleaning up needed, but as a proof of concept, this supports Workflow A above, which is what I was hoping for as I need to support reinspection of assets with extremely long inspection forms.

‎08-28-2023

Hi Josh, We use the Field Maps solution for many of our inspection workflows, and it's great, however this survey is extremely long and detailed. It would just not be possible to use this for this situation. I actually thought of pulldata last Friday and plan on trying it this week. I think that will work and might be the best option for grabbing the proper GlobalID and writing it to my "dam_guid" field to solidify the relationship. @IsmaelChivite It would be great if it was possible, within a repeat, to view the most recent repeat record and just copy that to a new/editable repeat record and use that to edit the inspection form (Workflow B above).

‎08-28-2023

I agree that if the data is shared with you in a group, any group member regardless of user type, should be able to download the data to use locally. This should NEVER require a Creator-level account.

‎08-25-2023

Hi - Hoping for some help in resolving a workflow issue. We are building a new dam inspection form. We have a dam inventory (point) with a 1:M relationship to an Inspection table. Because the inspection form is very long and does not change much from inspection to inspection, we want users to be able to easily copy the previous inspection into a new form, make updates and submit. The relationship between the Dam points & inspection table is based on GlobalID/GUID; this has already been published as a hosted feature layer (AGOL). I've tested two workflows which both have benefits and drawbacks. I am hoping for some advice on how to accomplish my goal. GOAL: Easily copy previous inspection to a new form AND maintain the relationship to the Dam point. Workflow A: Use Survey123 Inbox w/ the following settings - inbox surveys to be viewed (no editing of previously submitted inspections), allow inbox surveys to be copied to a new survey. THIS DOES NOT MAINTAIN RELATIONSHIP -- when I tested, the GUID is not populated with the Dam's GlobalID, hence relationship is broken. This is ideal because the entire form is copied and the user can make updates and submit a new inspection. Workflow B: Use Survey123 form that contains dam information and all inspections conducted. Allow editing via Inbox. Can view previous inspections, but not edit them. Can add new inspections. Can not copy past inspection into new repeat. MAINTAINS RELATIONSHIP -- when I tested, the GUID is populated with the Dam's GlobalID and relationship is maintained. This is not ideal because while I can view the previous inspections, I can not select the most recent and copy it to a new repeat. Potential Workaround: Use Workflow A to trigger Power Automate on submission. Power Automate grabs the GlobalID of the dam using another unique identifier and writes the GlobalID to the inspection's GUID field. This would work, however I am wondering if I am missing something obvious that would be a better solution. Thank you,

‎07-20-2023

I did not ever get this figured out. Each time my flow is triggered, it runs through all related records for the parent record.

‎06-23-2023

Hi - I have formatted pop-ups in my map using Arcade and they're working well, however I am hoping someone can help me figure out how to add 'alt text' to the icons in my pop-ups. The thought here is, if the icon (for some reason) doesn't load, then the user could still see if some activity was allowed or not allowed. Currently, if the icons do not load, the right side of the table appears empty, which is confusing. We've experienced issues when users access this from our work network - sometimes the icons are blocked/don't load and other times they work fine. Any suggestions would be welcome. Example of pop-up: Here is the Arcade used to return the icons: var passIcon = "https://x123x"; var failIcon = "https://x123x"; function makeFlexItem(HTML) { return '<div style="flex:1 1 auto; font-size:12px; font-weight:200; opacity:0.8">' + HTML + '</div>'; } var AppStatusIcon = When($feature["Hunting_Allowed"] == "N", failIcon, $feature["Hunting_Allowed"] == "Y", passIcon, failIcon); var flexItems = ''; flexItems += makeFlexItem(AppStatusIcon); Return(AppStatusIcon); Here is the HTML used to build the table: {Permit_Type}  Game Allowed: {Game_Allowed}  <figure> <figure> <figure class="table"> <table cellspacing="3px" cellpadding="0px"> <tbody> <tr valign="top"> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> Hunting </td> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> <img src="{expression/expr0}" alt="" width="25"> </td> </tr> <tr valign="top"> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> Trapping </td> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> <img src="{expression/expr1}" alt="" width="25"> </td> </tr> <tr valign="top"> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> Dogs </td> <td style="background-color:#e6e5e5;padding:3px;text-align:center;width:150px;"> <img src="{expression/expr2}" alt="" width="25"> </td> </tr> </tbody> </table> </figure> </figure> </figure> Thank you!

‎06-13-2023

Hi Josh - That modified code snippet worked perfectly and now is returning the proper values. Thank you so much!

‎06-12-2023

Ah yes! That is exactly what's happening. My select_multiple field is a string w/ length of 2. This was an exercise in bringing to region's data together - one region used numeric codes 1 to 90 and the other used two-letter abbreviations. When I look at an example that has comma separated two-letter abbreviations, the code appears to work properly. The correct subbasin names are returned and there are no odd duplicates. Any idea how to get around this? Thank you!

‎06-09-2023

Hi @jcarlson - I know this is a few years old, but hoping you might be able to assist. I came across this solution and it looked like it would fit the bill for my problem, however I am experiencing a strange output and am baffled. Problem: I have a hosted feature layer that is managed via Survey123. One of the select_multiple questions stores codes for each selected subbasin. These codes are not helpful in a pop-up, so I wanted to use Arcade to replace the code with the subbasin name. I am not getting an error, but the returned values are incorrect when I compare the stored subbasin codes with the reported subbasin names in the pop-up. My code is: var basinNames = { '1': 'Asnebumskit (Mill St)', '2': 'Asnebumskit (Princeton)', '3': 'Asnebumskit Pond', '4': 'Babcock Brook', } // and so on - this is a sample of code list, which contains 212 values var splits = Split($feature.Subbasin, ',') for(var a in splits){ for(var k in basinNames){ splits[a] = Replace(splits[a], k, basinNames[k]) } } return Concatenate(splits, ', ') For example, one record has stored values in the Subbasin attribute field of: 23,40,44,65. These codes correspond with: But instead, my returned value in the pop-up is: Even in a situation where only one subbasin was selected the returned subbasin from the Arcade script is incorrect. In this example, there was only one subbasin selected so the name (from domain label) shows up for "Subbasin(s)" in bottom row (65 = this option) and you can see the incorrect name returned in the first row: Do you have any suggestions? I will keep working on this, but if you see something please let me know! Thank you,

‎06-09-2023

Hi Josh, Thanks for sharing that example - I'll give it a try. I was actually going to try it out this morning, but when I open the Map Viewer (in Chrome or Firefox) and select the layer, there is no longer a "transparency by attribute" option under the symbology settings. I'm mystified.

‎05-25-2023

We are testing a new public-facing app and have received this question from many people - "Why can't you just add a scroll bar? I didn't know I could scroll to see more". Scroll bars are pretty basic elements when something "overruns" the current view. It would be nice to have a scroll bar option when configuring ExB widgets. We are using a grid layout to house a nice combination of photos and text; in instances where the text overruns, the jumping arrows are either a) not always there, or b) not an obvious indicator to users that they can scroll.

Online Status	Offline
Date Last Visited	‎02-14-2025 01:16 PM

My Ideas

Latest Contributions by erica_poisson

Summary report aggregate function result not honoring selected records on export

Re: Bug - changes made in Connect not honored in web form, but honored in mobile form

Re: Bug - changes made in Connect not honored in web form, but honored in mobile form

Bug - changes made in Connect not honored in web form, but honored in mobile form

Re: Copy inbox survey to new survey and maintain relationship to parent

Re: Copy inbox survey to new survey and maintain relationship to parent

Re: Allow Viewers with "View and Export Data" the ability to Export Survey

Copy inbox survey to new survey and maintain relationship to parent

Re: Update feature layer with most recent related record

Add 'alt text' to pop-up icons returned with arcade

Re: Arcade expressions adding comma to multiple expressions

Re: Arcade expressions adding comma to multiple expressions

Re: Arcade expressions adding comma to multiple expressions

Re: Control layer transparency by scale using Arcade

Re: Scrollable Text Widget Visual Indicators

Image captions in sidecar

Add "Colorblind friendly" toggle option when selec...

ArcGIS Dashboard Data Expression, "unable to execu...

Re: Image captions in sidecar

Re: Stop Survey123 Entry if Duplicate Project ID E...