Latest Contributions by KenBuja

That code should work. Did you check whether you're getting any valid related records? It would be something like this (untested) var portal = Portal("https://gis.clark.wa.gov/portalpw/"); var Stmdocs = FeatureSetByPortalItem(portal, "4b35b095430d47d699dea875e62dd0b6", 3, ["MmsId", "FilePath"]); //42 is the table ID in the service // Filter related features by using a common attribute // Here both table have identical MMSID fields var MMSID = $feature.MmsId; var filterStatement = "MMSID = @MMSID"; // Related features as a variable var relatedData = Filter(Stmdocs, filterStatement); var output = 'No images found' if (Count(relatedData) > 0) { // Sort related features by oldest to newest var relatedDataSorted = OrderBy(relatedData, "MmsId"); // Build the pop-up string by iterating through all related features ideally as hyperlinks var thenewpath = ""; var theurl = ""; var list = []; for (var f in relatedDataSorted) { thenewpath = Replace(f.filepath, "olympus", ""); thenewpath = Replace(thenewpath, "gisdata", ""); thenewpath = Replace(thenewpath, "Images", "ccimages"); thenewpath = Replace(thenewpath, "\\", "/"); thenewpath = Replace(thenewpath, "////", "https://gis.clark.wa.gov/"); theurl = `<a href="${thenewpath}">Image</a>`; Push(list, theurl); } output = `<b>Image Links:</b> ${Concatenate(list, TextFormatting.NewLine)}`; } return { type: "text", text: output };   ... View more

The null field shouldn't be a problem, but those other values for Time are confusing. What does something like "9:30, 10, 11, 15:30, 18:30"  or "9, 8, 19, 21" represent? ... View more

You have to replace the test variables with your feature like this: function ConvertTime(input) { var theTime = input; if (Find(":", theTime) > -1) { var times = split(theTime, ":"); theTime = Number(times[0]) + Number(times[1]) / 60; } iif(theTime < 6, Number(theTime) + 12, Number(theTime)); } //var DaysOpen = "Th, F"; //var fTime = "8, 2"; var days_abbr = ["Su", "M", "Tu", "W", "Th", "F", "Sa"]; var weekday = Weekday(Today()); var timeofday = Time(Now()); var current = hour(timeofday) + (minute(timeofday)/60); var opening = Split($feature.Time, ","); var start = ConvertTime(opening[0]); var end = ConvertTime(opening[1]); if (Find(days_abbr[weekday], $feature.DaysOpen, 0) != -1 && (current >= start && current <= end)) { return "Open Now"; } else { return "Closed"; } What are the earliest and latest times?   ... View more

OK, that made it a bit tougher. Here's my solution, with one big assumption. I assumed that there wouldn't be any openings/closings before 6 am or after 6 pm (line 7) to convert it to a 24 hour time. I used the dummy variables "DaysOpen" and "fTime" for testing, which you can replace with your fields. function ConvertTime(input) { var theTime = input; if (Find(":", theTime) > -1) { var times = split(theTime, ":"); theTime = Number(times[0]) + Number(times[1]) / 60; } iif(theTime < 6, Number(theTime) + 12, Number(theTime)); } var DaysOpen = "Th, F"; var fTime = "8, 2"; var days_abbr = ["Su", "M", "Tu", "W", "Th", "F", "Sa"]; var weekday = Weekday(Today()); var timeofday = Time(Now()); var current = hour(timeofday) + (minute(timeofday)/60); var opening = Split(fTime, ","); var start = ConvertTime(opening[0]); var end = ConvertTime(opening[1]); if (Find(days_abbr[weekday], DaysOpen, 0) != -1 && (current >= start && current <= end)) { return "Open Now"; } else { return "Closed"; } ... View more

And what types of values would it contain? ... View more

What type of field is "Time": a date field, a string field, or a numeric field? What type of values does it contain? ... View more

That's curious, since it worked in my testing. I created a new date field, copied an existing field's dates into the records, then set them to null again. The screen image was the last step in my process. ... View more

Even though you do get that warning, the date values are calculated to null.   ... View more

Could you post your code to see what's on line 9? I'm wondering if there's a null geometry in your data. I tested this on the USA States and USA Major Cities dataset from the Living Atlas and didn't get any errors. ... View more

My apologies...I had the syntax incorrect. Give this a try (using your own layer and field names) var intersectLayer = OrderBy( Intersects( FeatureSetByName($map, "other layer"), Buffer($feature, -1, "feet") ), "sortField DESC" ); var results = []; for (var f in intersectLayer) { results[Count(results)] = f["displayField"]; } var output = Concatenate(results, ", ");       ... View more

I've also gone the route of altering my data to get the correct symbology before reverting it back to its original state. I'll look forward to that code you provide! ... View more

Could you use the Vector Tile Style Editor to modify the symbology of an existing basemap? ... View more

The code I posted initially used a layer with 68K records, so that size of data shouldn't be a problem. Another way to cut down on the request is not to return the geometry of the features. I'm curious on what result you got when doing a test run vs. getting the error in the Dashboard ... View more