Latest Contributions by GuyNizry

Hello everyone, I'm encountering an issue with an Arcade expression in the Popup window of a feature layer. My goal is to display selected fields in an HTML table format within the Popup, only showing fields that have values and omitting those without values. The Arcade expression works perfectly and displays fields with values while hiding those without. However, this functionality only works if I include a Field list component in the Popup with those selected fields. If I remove the Field list component or any of the selected fields from the component, the resulting HTML table from the Arcade expression does not display correctly, or it doesn't show the fields that are not in the Field list component. The idea was to display only the result table from the Arcade expression in the Popup window, showing fields with values, without duplicating fields by having a Field list component that includes fields with no values. Has anyone else encountered this issue? Does anyone have a solution or workaround for this problem? Here is the Arcade expression I am using:   var fieldNames = [ "Treatment", "TreatmentActivityType", "WPFSWorkEssence", "ExecutionStatus", "WorkYear", "OriginalWorkYear", "Date", "ReporterName", "DistrictName", "RegionName", "FOR_NO", "FOR_Name", "Stands", "TreatmentUnitAreaDunam", "BuildWPSFMethod", "InvasiveSpecies", "InvasionPattern", "InvasionInfectionLevel", "InvasionInfectionSourceNeighbor", "AgeGr", "ForAgeComposition", "CurForestType", "CurDensity", "CurCover", "ForStatusMain", "ForStatusSecondary", "ForVitality", "AreaDesignation", "ReqForestType", "ThinningPurpose", "OtherThinningPurpose", "TRTPriority", "ThinIntensity", "ThinType", "PruningType", "InvasionTrtNo", "InvasionTrtMechanic", "InvasionTrtChemical", "InvasionTrtDate", "BurnPermission", "WPFSRejectApproveReason", "WPFSRoundName", "BufferZoneType", "AnnualsTRT", "LineInfrastructureType", "Comments" ]; var fieldAliases = [ "נושא", "תת נושא", "מהות העבודה", "סטטוס ביצוע", "תוכנית עבודה לשנת", "שנת תכנון מקורית", "תאריך", "ממלא הטופס", "מרחב", "שם אזור", "מספר יער", "שם יער", "חלקות עומדים", "שטח היחידה בדונם", "שיטת בניית יחידת העבודה", "מין צמח פולש", "דפוס פלישה", "רמת נגיעות", "מקור הדבקה שכן", "גיל השכבה המטופלת", "מספר שכבות היער", "תצורת צומח יערנית קיימת", "צפיפות קיימת", "כיסוי צמרות קיים", "מצב יער עיקרי", "מצב יער משני", "חיוניות היער", "ייעוד השטח", "תצורת צומח מתקבלת", "מטרת עיקרית", "מטרה משנית", "סדר עדיפות לביצוע", "עוצמת דילול", "אופי דילול", "אופי גיזום", "טיפול מספר", "טיפול מכני", "טיפול כימי", "מועד טיפול רצוי", "האם תנאי שטח מצריכים בקשה לשריפת גזם", "סיבה לדחיית האישור", "סבב הבקשה", "סוג אזור חייץ", "טיפול בקומת הקרקע", "סוג תשתית", "הערות" ]; var html = "<div style='direction: rtl; font-family: Segoe UI;'><div style='background-color: lightgrey; font-weight: bold; font-size: 14px; text-align: center; padding: 5px;'>מאפייני היחידה</div><table style='width:100%; border-collapse: collapse; font-size: 12px;'>"; var stripe = false; for (var i = 0; i < Count(fieldNames); i++) { var key = fieldNames[i]; var alias = fieldAliases[i]; if (HasKey($feature, key)) { var value = $feature[key]; if (!IsEmpty(value)) { var displayValue = value; if (key == "Date") { displayValue = Text(Date(value), 'DD/MM/YYYY'); } if (key == "TreatmentUnitAreaDunam") { displayValue = Text(Round(Number(value), 1), '#,##0.0'); // Format to one decimal place } else { displayValue = Replace(displayValue, "_", " "); // Replacing underscores with spaces } var rowColor = IIf(stripe, "#EDEDED", "#FBFBFB"); // Using the specified colors html += "<tr style='background-color:" + rowColor + ";'><td style='border-right: 1px solid #ddd; padding: 8px;'>" + alias + "</td><td style='padding: 8px;'>" + displayValue + "</td></tr>"; stripe = !stripe; } } } html += "</table></div>"; return { type: "text", text: html };     Part of the resulted table in the popup: Thank you in advance for your assistance!   ... View more

Hi, I'm encountering an issue with a calculation expression that works correctly in Map Viewer but not in Field Maps. I have an expression that computes a fire incident number automatically based on the fire's status. When the fire status is 1 (new fire), the calculation finds the maximum number in the layer and adds one. When the fire status is 2 (continuing fire), the calculation finds the last fire number for the same user. In Map Viewer, the calculation works perfectly. However, in Field Maps, I'm experiencing two issues: For status 1, I get a number smaller than the maximum number. For status 2, I get 0 instead of the expected number. Here's the expression I'm using:    // Check if the edit type is 'INSERT' if ($editcontext.editType == 'INSERT') { // Access the FeatureSet of the relevant layer with required fields var fs = FeatureSetByName($map, 'מדידת שריפה', ['FireEditStatus', 'FireGisID', 'created_user'], false); // Get the current user's username var username = GetUser($layer).username; // Initialize variables var MaxidStatus1 = 0; var MaxidStatus2 = 0; var hasStatus2 = false; // Iterate through the features in the FeatureSet for (var f in fs) { var fireEditStatus = f['FireEditStatus']; var fireGisID = Number(f['FireGisID']); // Check if the FireEditStatus is 1 and update the maximum FireGisID if (fireEditStatus == 1) { MaxidStatus1 = Max(MaxidStatus1, fireGisID); } // Check if the FireEditStatus is 2 and the created_user matches the current user if (fireEditStatus == 2 && f['created_user'] == username) { hasStatus2 = true; MaxidStatus2 = Max(MaxidStatus2, fireGisID); } } // Determine the new FireGisID based on FireEditStatus if ($feature.FireEditStatus == 2) { // If FireEditStatus is 2, return the maximum FireGisID for the current user if (hasStatus2) { return MaxidStatus2; } else { return null; } } else if ($feature.FireEditStatus == 1) { // Increment the maximum FireGisID by 1 for status 1 return MaxidStatus1 + 1; } else { return null; } } else { // For other edit types, return the existing FireGisID return $feature.FireGisID; }   Has anyone experienced similar issues with expressions in Field Maps, and what solutions might you suggest? Thank you for your assistance! Guy ... View more

Hi, I have been working on a custom Arcade expression that displays a table of related inspections in the popup for a feature in ArcGIS Online Map Viewer. The code is working perfectly in the Map Viewer, but when I try to use it in ArcGIS Field Maps, I'm encountering an error (Error code 7018) that states "Arcade expression is invalid". I've included the Arcade code below for reference:   var parentGlobalID = $feature.GlobalID;   var tbl = "<table border='1' cellpadding='5' cellspacing='0' style='width:100%; direction:rtl;'>"; tbl += "<tr style='background-color: #D3D3D3;'><th>Inspection Date</th><th>Inspector Name</th><th>Status</th></tr>";   // Get related records sorted by date var relatedRecords = filter(FeatureSetByName($map, "Inspections", ["InspDate","InspReporterName","InspStatus"], false),                      'ShepardParentGlobalID = @parentGlobalID',);   if (Count(relatedRecords) > 0) { for (var i in (OrderBy(relatedRecords, "InspDate DESC",))) { var rowBackgroundColor = "background-color: #CCFFCC;"; // add backround to row if InspStatus is "Not Valid" if (i.InspStatus == "Not Valid") { rowBackgroundColor = "background-color: #FFCCCC;"; } // format date field to DD/MM/YYYY var formattedDate = Text(Date(i.InspDate), 'DD/MM/YYYY'); tbl += "<tr style='" + rowBackgroundColor + "'><td style='text-align:center;'>" + formattedDate + "</td><td style='text-align:center;'>" + i.InspReporterName + "</td><td style='text-align:center;'>" + i.InspStatus + "</td></tr>"; } } else { tbl += "<tr><td colspan='3'>Inspections not found</td></tr>"; }   tbl += "</table>";   return {  type : 'text',  text : tbl //this property supports html tags  }       Has anyone encountered a similar issue or has insights on what might be causing this error specifically in ArcGIS Field Maps? Any help or suggestions would be greatly appreciated. Guy Nizry ... View more