Latest Contributions by AmyRoust

‎01-09-2023

When you click the Export Data button and select your format, the current process generates a downloadable file and saves it in your ArcGIS Online account as a new item. You then have to go to that new item page and download it to actually get the data you want in the requested format. It would be a much better end user experience if the data downloaded directly to your machine instead of adding in the extra step of creating an item page. In my experience, the extra item page does nothing more than create clutter in the user's account.

‎11-30-2022

Issue resolved! Our in-house IT support did two things: 1. upgraded the users' version of Microsoft Office products, and 2. changed the default web browser from Internet Explorer to Chrome. I suspect that the latter step is what resolved the issue because we're not allowed to use IE anymore. My guess is that there was an IT setting that blocks IE, which is what the Excel add-in was trying to use to connect to ArcGIS Online.

‎11-21-2022

Well, I'm sorry to say that the debugger and refresh didn't fix the issue. Clicking on debugger did not open the dev tools window, and a refresh had no impact either. I just put in a help desk ticket, so we'll see what comes of it. Appreciate the suggestion!

‎11-18-2022

When you create a chart on a feature class in Pro, there are many customizations that can be set up. You can label the axes, format the numbers, add guides, change the colors, and so forth to ensure that your chart is easy to read. No such options are available in the pop-up charts, but if they were, it would make the pop-up charts far more useful. As-is, there is so little customization available that most charts are largely useless.

‎11-18-2022

It's great to have the ability to add a chart into a pop-up, but the current format is too hard to read. No matter how large your screen is or how large you make the pop-up, the charts stay very small. I'd like to see the option to make them bigger by default. Ideally, they would resize responsively. Here is what the charts look like right now when I display the count of virus cases in males and females: AmyRoust_0-1668808360062.png With the bar chart, the label for Females is cut off by two letters and I can't change them to M and F (or really anything other than what the field name is). With the pie chart, there is no way to tell which slice is males and which slice is females because the label only shows the percentages. I can't even change the color coding, which would allow me to add a caption that says "red is females, purple is males" to work around the labeling issue.

‎11-18-2022

Thank you! We will give this a try when the users who are still having the issue return from a conference. I hope I can mark Accept as Solution!

‎11-18-2022

Currently, when you use a Date (not Date and Time) question in your survey, the default time of 6 pm is included in Excel and CSV downloads. In the survey: AmyRoust_0-1668781313236.png In the exported CSV and Excel: AmyRoust_1-1668781365276.png When we use the Date only field, we do so because a time is not relevant to the data collection. We would prefer to have a consistent experience in the download so that we don't need to take the extra step of removing the time.

‎11-15-2022

Several people in my organization installed the ArcGIS for Excel add-on today. Two of us had no issues; the other two see a blank screen instead of the Choose an ArcGIS connection screen. In other words, they should see this: AmyRoust_0-1668550954047.png But instead, they only see this: AmyRoust_1-1668550975087.png Troubleshooting so far: I don't think it's a firewall thing since we're all on the same network and two of us were able to connect. Everyone has the Microsoft Access driver that is required for using Excel in ArcGIS Pro. The only other difference that we can think of is that the two who are successful have local admin rights on their machine and the other two don't. It seems odd that admin rights would block a simple sign-in screen, though. Anyone have any ideas on what else we can try?

‎11-04-2022

I use Power Automate to send email notifications when someone submits a Survey123 form. I have three total. Two continue to work just fine; the third stopped working several months ago and I'm just now noticing it. I had to recreate the flow from scratch to get it to work again. I have no idea what caused it to fail, and since I don't know when it failed, I can't attribute it to a Survey123 or Microsoft update. Has anyone else had a Power Automate flow with Survey123 stop working without any notification? I'm looking for any clues as to the cause. Here's what I can tell you: - Survey was created with the web app. - Survey was set to Use the version the survey was published with (3.13). - One of the other surveys that still has a working flow was created with the web app, but it was set to Always use the latest version. It was originally created in version 3.15.

‎11-01-2022

Thank you - this is the clue that I needed. I was getting a null value in both formulas without realizing it. Once I fixed the bad reference to another field, it worked.

‎11-01-2022

Looks like others have had similar issues to this, but I'm not finding a solution to my version yet. I have two notes fields that are doing simple calculations based on values from other fields. Here is a sample: ${Ravg_after}*${Kavg_after}*${LSavg_after}*${Cavg_after}*${Pavg_after} In the Connect desktop application, it calculates as expected: AmyRoust_0-1667324198016.png When I try it in a web browser, I get NaN: AmyRoust_1-1667324228837.png I tried adding a round function since it had so many decimal points, but no luck. What am I missing?

‎10-27-2022

Oh my gosh, yes! Thank you so much! Breaking it apart fixed the problem. You are my hero!

‎10-27-2022

I'm working on a really complicated Survey123 Connect XLSForm and have hit a roadblock. Everything works until I introduce this question: type: note name: Ravg_before label: Ravg Before appearance: horizontal calculation: if(pulldata('BMPMod_Chart','ChangeBefore','PracticeName',${practice})='None',pulldata(${LandType_Before},'Ravg','County',${county_bmp_location}),pulldata(${LandType_Before},'Ravg','County',${county_bmp_location})*pulldata('BMPMod_Chart','MultiplyBefore','PracticeName',${practice})) When I fill out the form inside Survey123 Connect, I get the correct result: AmyRoust_0-1666903383993.png But when I publish the survey and open it in a web browser, I immediately get this error message: AmyRoust_1-1666903506350.png I realize that this is really hard to troubleshoot without providing the XLSForm and the related media files that drive all of the lookup values. I'm just hoping for some clues that might get me across the finish line without having to call tech support. Things I've tried: Ensured that all column names in all CSV files in the media folder have no spaces or special characters. Ensured that every record in every CSV in the media folder is fully populated (no null values/empty cells) Renaming the two CSVs that have a - in their file name to remove the - I have not removed the underscore from the CSV called BMPMod_Chart because I am successfully calling that CSV and returning values in earlier questions without error. Any other ideas on what I can try? I don't know what the web browser is checking that the desktop app is not.

‎10-26-2022

Fantastic! Thank you!

‎09-16-2022

Experience Builder allows you to add REST URLs as a data source, which is nice when you don't need or want a separate map just to make your data available to ExB. However, when you use a service as your data source, the table widget does not honor the integer formatting. I would like to have the ability to remove commas and decimal points from integer fields directly in the Table widget, rather than having to create a web map, configure the pop-up, and then use the web map as the data source. For my use case, I have an int field that contains years only. The year 2,022 looks odd!

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by AmyRoust

Allow Export Data without creating another item in AGOL

Re: No option to choose an ArcGIS Online connection

Re: No option to choose an ArcGIS Online connection

Provide the same functionality for charts in pop-up

Make charts in pop-ups larger

Re: No option to choose an ArcGIS Online connection

Suppress time in date-only fields when downloading to CSV/Excel

No option to choose an ArcGIS Online connection

Power Automate send email flow stopped working

Re: Calculation works in Connect but not web app

Calculation works in Connect but not web app

Re: FormLogicError: Could not evaluate...

FormLogicError: Could not evaluate...

Re: Enhance pie chart color configuration options for "top five" lists

Allow number formatting in Table Widget

Re: GIS for Asset Management

Cityworks / ArcGIS Enterprise user groups?

Re: Color Blind Color Palette - Pro

Re: Map pop-ups run off the edge of the map; Featu...

Provide an option to turn off "Use In Field Maps" ...