Latest Contributions by erica_poisson

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

‎05-22-2023

That does not make any difference unfortunately.

‎05-19-2023

I've recently used @jcarlson's custom "Memorize" function within one of my Data Expressions at the behest of @JohannesLindner and it significantly improved the performance of my dashboard - user load times went from ~2 minutes to ~5-10 seconds. It would be nice if something like this was built into Arcade to help users improve performance.

‎05-19-2023

Hi @TonghuiMing - would this behavior also explain this? https://community.esri.com/t5/arcgis-experience-builder-questions/image-position-not-honored-in-tablet-or-mobile/m-p/1291233#M7010

‎05-19-2023

Hi - I am designing the tablet and mobile layouts for my Experience. In all of my designs, I am using the same background image for my apps home page. I've got the image position set to "fill" and this is honored within the Experience designer, however when I view the published version on my tablet and mobile device, this is no longer honored. On my iPhone, I have tested this in both Safari and Chrome with the same results. Please see both sets of examples below. Is this expected behavior? Any ideas to make this work as shown in the designer? Thank you! Mobile preview in designer: Published mobile version on iPhone: Tablet preview in designer: Published tablet version on iPad:

‎05-19-2023

Hi @JohannesLindner - Thank you! This speeds up my dashboard significantly! I go from about 2 minutes to load to maybe 10-15 seconds.

‎05-15-2023

I wanted to post my solution to this in case it is useful to others. I reached out to our local Esri contacts and was informed that while this is possible using Arcade, there is a bug in the map viewer which prevents it from working properly. Below is a workaround which I tested and was successfully able to implement in my map: Open your web map and select the layer > Styles. Set symbology and then toggle on "Transparency by attribute" at the bottom of the Styles dialog. Click the </> and add a new expression. Leave expression title as "New expression". In body, type $view.scale Click Save. Select a numeric field for transparency normalization (I selected "Shape_Length"). Open AGO Assistant and view the JSON of your web map. In the JSON code, locate the code that looks like this: 10. Replace it with something like this. Note that where I have "36111.909643" should be the scale at which you want the transparency to change. I tested this and it worked. I would recommend testing in a copy of your web map and copying/pasting default JSON into Notepad just in case.

‎05-15-2023

Hi Johannes, Thank you for this suggestion. Unfortunately, I am getting an unknown error when I test my expression. Here is what I've done: function Memorize(fs) { var temp_dict = { fields: Schema(fs)['fields'], geometryType: '', features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(Text(temp_dict)) } // skip some lines to make this concise... // load the watersheds var watersheds = Memorize(FeatureSetByPortalItem(p, '4a7abb05f6eb42d78e31587b05e3ebec', 0, ['NAME'], false)) // create an empty feature array var features = [] // iterate over the input layers for(var i in layers) { var layer = layers[i] // load and filter var fs = Memorize(FeaturesetByPortalItem(p, layer.id, layer.subid, [layer.file_number], true))

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by erica_poisson

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

Re: Image position not honored in tablet or mobile design

Re: Arcade FeatureSet Functions should have the option to output to RAM

Re: Image widget: tablet and mobile "fill" settings only top-align, not center

Image position not honored in tablet or mobile design

Re: Data Expression with GroupBy and Intersect

Re: Control layer transparency by scale using Arcade

Re: Data Expression with GroupBy and Intersect

Re: June 2026 Update - No data No Selection text

Re: Category Selector RESET missing?

Image captions in sidecar

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

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