Latest Contributions by AmyRoust

‎03-29-2022

For background: I am using the Table widget in a hosted Experience Builder site. The data layer is published as a feature service from SQL Server to a standalone ArcGIS Server. Editing is enabled on the table. My first suggestion is to provide the option to hide the time input on date/time fields. My dataset tracks the date that a location opens and closes, but time is irrelevant for us to track. I can hide time in the Edit widget using Smart Forms on the Map Viewer map, but that setting does not carry over to the Table widget. My second suggestion is to add an "Update" button to the Table widget, just like the one that is in the Edit widget. My end users are using the table widget like an Excel spreadsheet, but since every change has to be immediately written to the database, the entire table refreshes every time a change is made. It is really disorienting to suddenly be kicked back to the first record, first column when you are editing something further down and over.

‎03-08-2022

Update: I chatted with tech support about this. Map Viewer has a special "Arcade" content option for pop-ups that you have to use to embed the html code that uses Arcade. The first part of the workflow is the same - you go to Manage expressions and set up the IIF statement so that it checks to see if your field is empty. Then, you go back to the main config window and choose Arcade from the Add Content menu: AmyRoust_0-1646757220551.png In the dialogue box that opens, you have to put the HTML code in the text parameter like this: AmyRoust_1-1646757241160.png Unfortunately, this new method means that you'll have a blank line in your pop up if there is no data for that particular feature. Here's my example where I'm suppressing empty phone numbers (the Arcade content is in between two text contents: AmyRoust_2-1646757528967.png On the bright side, it appears that the original methodology from Conditional Field display with Arcade in Pop Ups (revisited) still works. It requires knowing how to create a table using HTML, but at least it works!

‎03-07-2022

This is interesting - I can get it to work with expressions if I nest them inside a table like your example. But using span or div tags on their own, as described in this tech support article and this community post does not work in the new Viewer. Thanks for testing, @JohannesLindner !

‎03-04-2022

Am I correct that this only works in Classic Map Viewer and not the new one?

‎03-04-2022

I'm running the Export Web Map tool in Pro 2.9.2 in preparation for publishing a custom print service. One of the parameters is Format, which has a predefined list of options that is much longer than what I want to offer. Is there any way to reduce the choices in this list? AmyRoust_0-1646423258204.png

‎03-04-2022

We had very similar experiences, @KimberlyGarbade. (I laughed when you made the comment about the mysterious ESRI_ID field appearing. What the heck??) The only thing I can't replicate in your second answer is in the last step. I cannot find a way to add the modified view to Pro if it doesn't have the UniqueID field. Fortunately, between your tips and the suggestion from @Reinaldo_Cartagena, I thought up a new solution. I saved my view without a unique id, and then created a second view where I joined my first view to a master table that contains a single list of all CONTENT_AREA values. In that second query, I added the OID from the master table and got what I needed. I have a hunch that Reinaldo's solution is more elegant than what I did, but I couldn't quite parse out his example in my own mind. (I've never been good at nested queries.) Appreciate the help!

‎03-03-2022

Thank you, @KimberlyGarbade! That partially worked, but didn't get me all the way across the finish line. In SSMS, the query works, but when I try to save it as a view, I get this error message: AmyRoust_0-1646343945778.png I saved anyway and tried to add the table to Pro, but got this message when I tried to open the attribute table: AmyRoust_1-1646344046993.png Then I tried adding the actual query as a query layer in Pro. That worked - it added to the map and I was able to open the attribute table and view its contents. But, when I tried to publish a REST service to our stand-alone ArcGIS Server, it gave me several unhelpful errors: AmyRoust_2-1646344732591.png

‎03-03-2022

I love using SQL views to summarize my data for use in Dashboards and Experience Builder. However, I keep running into the problem of not having a unique identifier for Pro to use. Here's an example query: SELECT CONTENT_AREA, COUNT(CONTENT_AREA) AS Count FROM SDE.Dataset GROUP BY CONTENT_AREA That gives me a nice table that looks like this: CONTENT_AREA Count Metric1 99 Metric2 2 Metric3 73 This query gives me the numbers I need, but Pro can't add it to the map because there is no unique identifier. In other queries that don't use the GROUP BY clause, I can use this trick: CAST(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS INT) AS OBJECTID ... but this doesn't work in Pro unless I include OBJECTID in the GROUP BY clause.

‎02-18-2022

Thank you, @ShengdiZhang . Unfortunately, the table widget in Experience Builder does not honor that setting. I already have the time suppressed in the Map Viewer, but it still displays in the table widget.

‎02-17-2022

@ShengdiZhang - that won't resolve my problem. I'm asking about hiding the time in a date/time field. I don't want to hide the entire field, but rather just the time. (See screenshot in original post.)

‎02-16-2022

I'm using the Table widget in Experience Builder (the online version, not developer edition). My date fields are displaying the time, and I'm wondering if there is a way to hide that? Time is irrelevant for this dataset - they just need to track the date. screenshot.PNG

‎02-15-2022

FANTASTIC! Thank you, @ShengdiZhang. That definitely fits the experience that we want.

‎02-11-2022

Thank you! That worked.

‎02-11-2022

After looking through the list of Arcade operators, I don't see an alternative to OR. I need to make a statement along these lines, and it doesn't seem to work: IIf(textField=='Yes' OR IsEmpty(dateField), 'TRUE', 'FALSE') If I replace OR with &&, the expression works. Is there an alternative to OR in Arcade?

‎02-11-2022

Oh my gosh. I feel foolish! Thank you for the syntax correction! I was moving back and forth between Arcade and SQL and got my operators mixed up.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by AmyRoust

Tablet Widget: Add "Update" button and Suppress Time on Date/Time fields

Re: Using Arcade or HTML to hide/display hyperlink in popup

Re: Using Arcade or HTML to hide/display hyperlink in popup

Re: Using Arcade or HTML to hide/display hyperlink in popup

How to reduce choices in export formats in Export Web Map tool

Re: Adding a Unique ID/ OBJECTID to a SQL Query Layer that uses GroupBy

Re: Adding a Unique ID/ OBJECTID to a SQL Query Layer that uses GroupBy

Adding a Unique ID/ OBJECTID to a SQL Query Layer that uses GroupBy

Re: Hide time in Table widget

Re: Hide time in Table widget

Hide time in Table widget

Re: Experience Builder - Select in the map widget should trigger the selection to move to the top of the List widget

Re: Does Arcade have an OR operator?

Does Arcade have an OR operator?

Re: Can IIf() handle a conditional expression with more than one clause?

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