Latest Contributions by BugPie

‎08-31-2023

Oh for goodness sake, I'm so disappointed in myself! OK, this makes so much more sense on why I could figure out how to use the code block to format the return. It's formatting!! That did the trick and I am eternally grateful for your help... again.

‎08-31-2023

I have a Data Expression in a Dashboard that is used to create a table. Works great, was built by someone else. I have one change I need to make but have been unable to get the syntax correct. I'm trying to get the table to return the date as a date only, no time. The bottom half of the code is attached here. I left out the variables and portal item stuff. How do I get Date only in the return?

‎07-21-2023

Yes! Thank you KenBuja, this is what I needed. I struggle with the syntax and formatting for if statements. Thank for advancing my knowledge of Arcade formatting, I appreciate it.

‎07-21-2023

Looking for an example of how to apply the advanced formatting of a Dashboard list that evaluates a string field for a comma. IF the comma exists then I need to return the background cell as red. I've been able to get formatting working to evaluate date fields for how many days out from today but I can't seem to get anything working for my comma example. This is what I came up with based on what has worked for me in the past but the table does not get formatted and stays in the original formatting. var gpm = $datapoint["mystringfield"]; var hasComma = Find(mystringfield, ","); var isGreaterThanMinusOne = hasComma > -1,"#D94534"; return { cells: { number: { displayText: $datapoint["number"], textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, gpm: { displayText: $datapoint["mystringfield"], textColor: '', backgroundColor: isGreaterThanMinusOne, textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, creationdate: { displayText: $datapoint["datefield"], textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, } }

‎07-12-2023

Unfortunately I did not. We just kind of swept this under the rug until it piles up too much and we trip over it.

‎06-26-2023

Thanks for brining us for your ride. I was able to fix some of my method formatting thanks to your follow up post. Cheers.

‎05-03-2023

I hate to pile on ESRI but how is it possible there is no measure tool in Dashboards? I can't think of a basic tool/function more inline with GIS than measuring. Ugh, you're killing me Smalls!

‎04-04-2023

@Ann123 Did you ever find out what happened to this second option? I also remember that option at one point and would love to know if I'm losing it or not.

‎03-08-2023

Hello! I was asked how to edit the metadata on a geodatabase feature class both created in and trying to edit in Pro 3.0. When I was trying to give a demo on how to do this, I was kind of surprised to see this message displayed in the metadata tab. "This item has metadata in HTML format. It can't be displayed or edited in ArcGIS Pro" Additionally, when you right click > Edit Metadata this error displays "This document already has a 'DocumentElement' node." We have adjusted the backstage > Options > Metadata Style and that doesn't seem to work either. I'm striking out in he documentation trying to understand how to change HTML to .....? Anything that will work. All the metadata manage tools in the menu are grayed out. Anyone able to tell me both why this happened and how to fix it so we can edit the metadata? Officially stumped.

‎03-08-2023

Yep, in PRO. Thanks for the links, these will get me what I am looking for. Thanks for your kind response, I appreciate it. Cheers!

‎03-07-2023

@Anonymous User Trying to understand the workflow to provide the child records (related tables) the globalID from the parent and I stumbled on this thread. Hoping you can give me a hint, feeling a little silly not able to figure this out. My parent geometry feature has a globalID field. My related tables have a guid field/type but are all empty. What is the best practice to provide the id from parent to child in this scenario prior to any publishing of the service. Should the relationship class be created before this guid is populated?

‎03-03-2023

That's what that option does! Viola! Thanks for sharing.. Life in the GIS world I guess. We are blessed to have all this great software that is always expanding, improving so fast sometimes that I don't get a chance to absorb everything as it rolls out and I know that there are all these great functionalities that I just need to "discover". Like this one. Cheers!

‎01-05-2023

@JustinOdell Same issue here once I publish to a tiled image service on our Portal. Can you clarify what you changed in the No Data option within the raster referenced in your mosaic dataset? Did you enter 255,255,255 and then click compute or just select OK?

‎12-12-2022

Thank you @jcarlson - this has been extremely helpful in allowing me to better understand syntax and these simple date functions. I've been able to get the first part of the statement to work, no problem. Getting barked at when I add in the else if statement "Unexpected End of Script" and I'm not sure how to conquer this error. Any tips for troubleshooting? I'd love to become more self sufficient with these simple arcade expressions and dates. Endless use cases here...

‎12-02-2022

Hello fine folks of the Geonet boards. Finally dipping my toes into advanced formatting by way of Arcade within the Dashboard, List widget > Advanced formatting. I've made some progress understanding the syntax and getting some customization proof of concept testing (successful) to change background colors based on a status field. This article was great. var color = Decode($datapoint["status"], 'Tentative', 'lightgreen', 'In-Progress','orange', '') return { textColor: '', backgroundColor: color, separatorColor:'', selectionColor: '', selectionTextColor: '', // attributes: { // attribute1: '', // attribute2: '' // } } But now I'm looking for examples, advice etc. to getting to the next step, which is to color the background based on some date fields and logic. Essentially replicating the filter, I have enabled on the data options tab to display records where Date field1 is within xx days OR datefield1 is before today AND date field2 IS NULL. -One color if Date field1 is WITHIN XX DAYS OR -Second color if date field1 is BEFORE NOW AND date field 2 IS NULL

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by BugPie

Re: Data Expression Date Formatting Dashboard Arcade

Data Expression Date Formatting Dashboard Arcade

Re: Dashboard table advanced formatting

Dashboard table advanced formatting

Re: Unable to edit/view HTML metadata in Pro 3.0.

Re: Report Template Summarize repeats on geometry, format stats values, sort rows in repeats

Re: Operations Dashboard: Measure Widget

Re: What happened to overwrite in ArcGIS Online?

Unable to edit/view HTML metadata in Pro 3.0.

Re: GlobalID and GUID

Re: GlobalID and GUID

Re: Adding related table records in arcgis pro

Re: Making NoData pixels transparent on Image Service / Image Layer

Re: Arcade Advanced formatting list - $datapoint.datefield within x days

Arcade Advanced formatting list - $datapoint.datefield within x days

Re: ModelBuilder - Select Table Records then Delet...

Re: Data Expression Date Formatting Dashboard Arca...

Dashboard table advanced formatting

Unable to edit/view HTML metadata in Pro 3.0.

Re: Editing Existing Records in Survey 123

Web AppBuilder Custom Widgets

Imagery and Remote Sensing User Group