topic Re: Arcade Find Weekday && Time in ArcGIS Pro Questions

Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 14:51:12 GMT

This is a nice snippet I got from an ESRI dev that returns what day a location has open in the Pro Symbology Expression Builder. It uses the DaysOpen field in my layer. My field values are like so: Su,M,Tu,W,Th,F,Sa.

Here is the expression:

My question here is how to expand on that to include time using the Find() function. I created similar variables to get the time.

Here is one attempt which returns an error (see pseudo text below) on the If() line.

var days_abbr = ["Su", "M", "Tu", "W", "Th", "F", "Sa"]; var days = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"]; var weekday = Weekday(Today()); var hours = ["8","8.5","9","9.5"]; //I also tried ["8","8:30","9","9:30"] which resulted in error var timeofday = Time(Now()); //this displays the time the way I anticipated it If(Find(days_abbr[weekday],$feature.DaysOpen,0)!=-1 && Find(hours[timeofday],$feature.Time,0)!=-1) { return "Open Now"; } else { return "Closed"; } // Error: Invalid expression. Integer index expected.

Re: Arcade Find Weekday && Time

JeffSilberberg — Fri, 26 Jul 2024 15:07:08 GMT

It may be as simple as you are missing the closing right parenthesis for the IF statement on line 8.

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 15:34:21 GMT

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

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 15:36:51 GMT

@KenBuja
Thanks for pointing that out. It's a text field. Same goes for the DaysOpen field.

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 15:37:52 GMT

And what types of values would it contain?

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 15:46:11 GMT

The values would be opening and closing times. For example:

8, 4:30

9,5

1,3

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 17:03:50 GMT

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.

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 18:54:04 GMT

Thanks for that. I replaced the dummy variables and it verified OK. However, there was only the Closed symbol class showing. It's not returning Open Now. So, it's hard telling where it's going wrong.

var DaysOpen = "Su,M,Tu,W,Th,F,Sa"; var fTime = "8,8:30,9,9:30,10,10:30,11,11:30,12,12:30,1,1:30,2:30,3,3:30,4,4:30,5,5:30,6,6:30,7,7:30,8,8:30,9";

Unfortunately, there are more that a few Time field values that are after 6pm.

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 19:21:19 GMT

You have to replace the test variables with your feature like this:

What are the earliest and latest times?

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 19:36:57 GMT

Ah, yes. Thank you. Earlier I changed the values to 24hr times. The earliest is 8:00 and the latest is 21:00. There's also one oddball open 24hr location, which I'll have to work in somehow.

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 20:06:33 GMT

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?

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Fri, 26 Jul 2024 20:26:28 GMT

Here's the bigger picture. The locations rarely have simple hours. It changes on certain days and on weekends. My logic along the way was to put the starting and end times for each day into the Time field.

Edit: I'm more or less experimenting on a working dataset. The LocationHours field is being used in the pop-up currently.

Re: Arcade Find Weekday && Time

KenBuja — Fri, 26 Jul 2024 21:18:02 GMT

I found it almost impossible to figure out how to extract the days and times logically in an Arcade script. The only thing I could come up with it to have a string field (LocationHoursByDay) with each day's time span or closed in a concatenated list, where "M - Tr 9:30 AM - 8 PM, F 9:30 AM - 6:30 PM, Sa - 10 AM - 3:30 PM, Su 11 AM - 3:30 PM"

would be represented as "9:30-20, 9:30-20, 9:30-20, 9:30-20, 9:30-18:30, 10-15:30, 11-15:30"

while the line "M,W,F 8:30 AM - 11 AM"

would be "8:30-11, closed, 8:30-11, closed, 8:30-11, closed, closed"

That field would be utilized in this script

function ConvertTime(input) { var theTime = input; if (Find(":", theTime) > -1) { var times = split(theTime, ":"); theTime = Number(times[0]) + Number(times[1]) / 60; } return Number(theTime); } var current = ConvertTime(Time(Now())); var fTime = '8:30-11, closed, 8:30-11, closed, 8:30-11, closed, closed'; //$feature.LocationHoursByDay, var times = Split(fTime, ', ') var todaysTime = times[Weekday(Today()) - 1]; if (todaysTime == 'closed') return 'Closed' var todaysTimes = Split(todaysTime, '-') var start = ConvertTime(todaysTimes[0]); var end = ConvertTime(todaysTimes[1]); iif(current >= start && current <= end, 'Open Now', 'Closed')

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Mon, 29 Jul 2024 19:56:58 GMT

Thanks for the code. Unless I'm doing something wrong, I'm only seeing two Closed symbols created (highlighted in table below). And what's odd is that when when you zoom in Closed symbols for all features appear. There are no Open Now symbols created.

On what's your line 10 I used this variable:

var fTime = $feature.LocationHoursByDay

I created a text field called LocationHoursByDay.

Re: Arcade Find Weekday && Time

KenBuja — Mon, 29 Jul 2024 20:16:25 GMT

I used a testing layer to try this out and it does show different symbols. I put that same code in the Label expression for more testing.

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Mon, 29 Jul 2024 20:38:23 GMT

I see what I did wrong. You have a space after the comma in the string here. In my table I didn't have spaces. I removed it in the script and it worked! Thanks a lot.

var times = Split(fTime, ',')

But I'm still getting weird behavior with what appears to be scale. Most features aren't visible until I zoom in. And I do not have the layer set with zoom in/out values. I'll have to investigate.

Re: Arcade Find Weekday && Time

KenBuja — Mon, 29 Jul 2024 20:46:23 GMT

Is there a scale restriction on the layer? Check in the layer properties to see if the layer is showing at all scales.

And you can always change the split function to take into account a space after the comma.

var times = Split(fTime, ', ')

Re: Arcade Find Weekday && Time

JaredPilbeam2 — Tue, 30 Jul 2024 14:30:59 GMT

I created a new post regarding the issue.

https://community.esri.com/t5/arcgis-pro-questions/symbols-dissapearing-after-applying-arcade-script/m-p/1512353#M86184