Latest Contributions by JasonCyphers

I have an arcade expression symbolizing a feature (valve) and related table (valve inspection) join. I created an arcade expression to symbolize on the map based on inspection date being within 14 months of today: IIF(DateDiff(now(), $feature.InspectionDate, 'months') < 14, "Last Inspection Within 14 Months", "Last Inspection > 14 Months") Works great, except it's symbolizing all the records (thousands of them) from the previous years. Is there additional expressions I can include to only look at the most recent inspection date, and determine if that is within 14 months of "now"? ... View more

I set up an Integromat integration to send an email whenever a new point is added to a hosted feature layer via Field Maps. Is it possible to also set up an Integromat integration that would update an attribute field in the point feature ("inspection complete"), if a record was added to its "inspection" related table?  Or, are there any other means to have Integromat update a specific attribute of a feature? ... View more

I have a hosted feature, with two related tables, in Portal 10.8.1.  Since I'm unable to perform in-memory joins in ArcMap or Pro, to then publish to Portal, and our version of Portal (10.8.1) does not have the "Create Results as hosted feature layer view" option, I turned to AGOL...   I created a map and added the feature to the map via Add layer from Web, entering the rest URL of the feature in Portal.  From there, I attempted to join the feature to one of its related tables.  I can perform the join, but the "Create results as a hosted feature layer view" option is grayed-out, and I cannot select it. This would be fine, if I didn't need to have the join view update whenever a new record was entered. Any ideas of why I can't create the view (is it because the hosted feature doesn't live in AGOL?) or any ideas of how I can create a live, joined view of the data? ... View more

In either the Web AppBuilder, Field maps, or in a Dashboard (Portal 10.8.1), is there a way to auto-populate a feature's "Response Time" attribute field, based on two other date fields ("Report Date/Time" and "On-Scene Date/Time") any time a new feature is added? ... View more

Looking for ideas on how to no longer have a point visible on a map once it has a related record... I have web mapping app that allows dispatchers to add point features whenever a natural gas problem is reported (damage, leak, smell of gas, low pressure, etc.).  Once the crew arrives on scene, the dispatcher edits the point's "on-scene" time.  If the incident involves a gas leak, the dispatcher also edits the point's "gas off" time, so we can calculate how long the gas leaked. Once the crew adds a related investigation record to the point, I'd like for the point to disappear from the dispatchers map, since they really don't have anything else to do with the incident at that point. I've thought about doing some filtering based on report type, on-scene times and/or gas off times (not being null), but there are too many variables for me to do that - a report of "low pressure" could be because someone cut your service, which would have a "gas off" timestamp; or, the low pressure could be because your appliance is messed up, so there wouldn't be a "gas off" timestamp captured since no gas was leaking. Best I can come up with is to filter the points on the map based on a time duration (only show points with a creation date/time within the last X hours).   ... View more

Is there a way to change the formatting of the time field in a date/time attribute? I built a web form for dispatchers to enter incidents.  They then go back and edit the point once dispatched units are on scene, then again when the incident is under control. Dispatchers want the ability to simply enter time in 24-hr. format (13:52, instead of the web app's 1:52:00 PM) format). ... View more

Is it possible to join two Hosted Feature Layer Views?  When I try, the "Create results as hosted feature layer view" option is grayed out, and I'm not able to check it. I have a point feature (problem report) and two related tables (one for investigations, and one for repairs).  I'd like to combine all three into a single hosted feature view, so I can symbolize based on inspection and repair dates: if the feature's investigation date is blank, symbolize the feature as a red point. If the feature's investigation date is not blank and the repair date is blank, symbolize the feature as an orange point. If the feature's repair date is not blank, symbolize the feature as a green point. I can join the problem report to the investigation table, then perform another join of the problem report to the repair table; however, I'd like to combine all three.  I need the ability, for our dispatchers who initially add the problem reports to the map, to no longer see ones that have an investigation associated with them, and eliminates the stacking of points on top of each other for the various layers. ... View more