Latest Contributions by BenBaker1

I noticed the same thing start happening yesterday. Can you elaborate on what you did to "refresh" the module? ... View more

Is there an alternate way of accomplishing this now that Arcade is better supported in Dashboards? Specifically, I'm wanting to calculate an average to display in a Dashboard Indicator to show days to completion that would be calculated from 'days' in the expression below: var startDt = $feature.SubmitDt; var endDt = $feature.CompletedDt; var status = $feature.Status; var days = Round(DateDiff(endDt, startDt, 'days'), 2); if (status == 'wo_completed'){ return days }   ... View more

Hi @JamesTedrick , your solution may be what I'm looking to do in a post I just replied to  before I saw this thread. I'm having trouble with the syntax of adding a web map to the report that is not linked to a survey. Can you expand on that? ... View more

@IsmaelChivite , Is there any plans for incorporating a single map into a summary section. We're working on a project that would drop locations of bulk waste/brush to be picked up using QuickCapture. I want to take all of those locations and put them on a single map, along with a list of addresses that has been reverse geocoded from the QuickCapture points. I have the summary table set up to create the list of addresses, but I'd like a map that shows all of the points on a map so they can plan their route to pick up at each location. Currently, the drivers don't have the ability to use Survey123 or Workforce to mark a pile as picked up.   Another obstacle I just encountered is how to automate a summary report in Integromat when a "survey" is not being submitted. if the points are created using QuickCapture, then I want to print a list of locations to be picked up for the driver, how might I go about creating that summary report through Integromat? Sample report template:   ... View more

After a closer look, I had applied a Date Filter within Survey123 that was hindering the queries in the template: Once I removed the date filters and re-ran the report, the numbers match up. ... View more

That resolved the issue on the first and part of the second items. I had been dumping a new row into a tab by month of an Excel file using Integromat, then had a set of formulas that was summarizing each month into a table. I'm trying to recreate that table in a summary report that I can send to administrators once a month. Here's the query I'm using: ${FireInspections_pts|where:"InspType=100 AND ReceivedDt BETWEEN DATE '2020-01-01 00:00:00' AND DATE '2020-02-01 05:00:00'"|stats:"count,OBJECTID"} The InspType field is a coded domain (select_one in S123) and 100 corresponds to "Annual".  I tried Jan - March, which should show these numbers: Instead, I'm getting this in the feature report: When I filter the data in Survey 123, I get the the same (14), but when I look at the feature layer, there are 19 inspections. So, now I am not sure 1)how I should be filtering the data to include all results and 2) why the same formula with dates changes for February and March are just showing 0s. ... View more

This is a really helpful feature for reporting workflows that require a "hard copy" medium in addition to a Dashboard! Ismael Chivite‌, I'm having a couple issues formatting the queries in my Summary Report Template. The first one is formatted like others that works, so I don't understand why it's failing. The other is related to filtering by dates. I'm not clear on the proper syntax to achieve what I'm wanting to. First, this query if producing the following error when I try to create a sample report. ${FireInspections_pts |where:“ActionTaken= ‘approved’ !important”|stats:"count,OBJECTID"} Next, I'm trying to populate a table showing a total of each inspection type by Month. I have the query working to summarize total inspections by type, but I have not been able to get an expression to work that will parse the counts by a specified date range. The "Total" (far right) query is: ${FireInspections_pts|where:“InspType=100 !important”| stats: “count,OBJECTID”} I've tried including date ranges for the January cell, but the syntax does not seem to be correct: ${FireInspections_pts|where:“ReceivedDt = BETWEEN DATE ‘2020-01-01 00:00:00’ AND DATE ‘2020-01-31 00:00:00’”| stats: “count,OBJECTID”} What am I missing with these two queries? ... View more

I spoke too soon. The code above is passing the field parameters dynamically, but the centerpoint variable is pulling the same lat/lon for every point in the popup instead of from each feature. When I changed the expression to what is shown below, the Lat/Lon is changing for the respective point I select, but now the field parameters are 'hard coded' into the URL and are not pulling the attributes. I think I'm missing something? Var urlsource = 'arcgis-survey123://?' function MetersToLatLon(mx, my) { // Converts XY point from Spherical Mercator EPSG:900913 to lat/lon in WGS84 Datum // Fuente: http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (mx / originShift) * 180.0; var lat = (my / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); return [lat, lon]; } var poly = Geometry($feature); var result1 = ""; if (!IsEmpty(poly)) { var pnt_centr = Centroid(poly); var latlon = MetersToLatLon(pnt_centr.x, pnt_centr.y); result1 = Round(latlon[0], 6); } else { result1 = ""; } function MetersToLatLon(mx, my) { // Converts XY point from Spherical Mercator EPSG:900913 to lat/lon in WGS84 Datum // Fuente: http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (mx / originShift) * 180.0; var lat = (my / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); return [lat, lon]; } var poly = Geometry($feature); var result2 = ""; if (!IsEmpty(poly)) { var pnt_centr = Centroid(poly); var latlon = MetersToLatLon(pnt_centr.x, pnt_centr.y); result2 = Round(latlon[1], 6); } else { result2 = ""; } //return result1; //return result2; var centerpoint = result1 + ',' + result2 Var params = { itemID: '14fcceaf30084ace8c3345efc006469b', center: centerpoint }; Return urlsource + UrlEncode (params) + '&field:Address={Address}&field:OccType={OccType}&field:BusName={BusName}&field:BusType={BusType}&field:InspType=102'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Thank you, James Tedrick. I've been testing this function but am not familiar with how to pass field parameters (from the attributes or other Arcade expressions). I finally settled on the following, although if there's a way to set up each field parameter with the params variable, I'd be interested to try it out. Var urlsource = 'arcgis-survey123://?' var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (Geometry($feature).x / originShift) * 180.0; var lat = (Geometry($feature).y / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); var centerpoint= Round(lat,6)+','+Round(lon,6); Var params = { itemID: '14fcceaf30084ace8c3345efc006469b', center: centerpoint }; Return urlsource + UrlEncode (params) + '&field:Address={Address}&field:OccType={OccType}&field:BusName={BusName}&field:BusType={BusType}&field:InspType=102' ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I'm having a similar issue. I have a link in a web map popup that was working a few weeks ago. When I revisited that project this week, the link is no longer pulling the custom URL scheme correctly. The map and dashboard the link is included in are published to ArcGIS Online. The URL Scheme matches the recommended formatting, although it's not pulling into the survey form. The map is centering on current location instead of the parameters passed in the URL scheme. This is the case on Android and Apple devices, although if I launch S123 from a Chrome browser on my desktop, the parameters are passed correctly. Here's my HTML as well as the URL that launches S123 from the Dashboard: <a href="arcgis-survey123://?itemID=14fcceaf30084ace8c3345efc006469b&amp;field:Address={Address}&amp;field:OccType={OccType}&amp;field:BusName={BusName}&amp;field:BusType={BusType}&amp;field:InspType=102&amp;center={LAT},{LON}" rel="nofollow ugc" target="_blank">Complete Reinspection</a> arcgis-survey123://?itemID=14fcceaf30084ace8c3345efc006469b&field:Address={Address}&field:OccType={OccType}&field:BusName={BusName}&field:BusType={BusType}&field:InspType=102&center={LAT},{LON} ... View more

Does this method still work with the new Collector links (e.g. https://collector.arcgis.app?itemID=....&referenceContext=center&center=....,....) outlined here: Deploy your map—Collector for ArcGIS | Documentation  I'm trying to launch to Collector from an Operations Dashboard and have the URL configured in the web map Popup, but Collector is not centering on the point when it launches from the Dashboard.  ... View more

I created them under the Visualization tab of the Item Details, hoping that they would participate in any analysis processes applied to that layer, but that was not the case in my experience. Perhaps that could be an improvement in future AGOL releases. ... View more

An unrelated note, so please advise if I should direct this elsewhere, but am I correct in my understanding that Arcade expressions don't pass through to the hosted view when a Join function is run in ArcGIS Online? ... View more

That was exactly what I needed. I've just started using Arcade, so those nuances are tricky. I'll have to set up expressions for each category and then each attribute, but the HTML is working well and reducing the blank spaces. Thank you! ... View more