Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About KenBuja
KenBuja
MVP Esteemed Contributor
since
07-04-2014
a week ago
4914
Posts created
334
Kudos given
965
Solutions
2293
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(7 Idea Submissions)Latest Contributions by KenBuja
|
POST
|
If the field UTCTime is a text field, here's one way to convert it to Eastern Time for April 8, 2024 var UTCTimeSplit = Split($feature.UTCTime,':');
var theDate = Date(2024,3,8,UTCTimeSplit[0],UTCTimeSplit[1],UTCTimeSplit[2],0,'UTC');
return Text(ChangeTimeZone(theDate, 'America/New_York'),"h:mm:ss A");
... View more
12-06-2023
12:12 PM
|
1
|
0
|
1844
|
|
POST
|
You can substitute a Arcade variable in the sql statement like this var Park_Name = $feature.PARK_NAME;
var results = Filter(athleticfields, "Name_Primary = @Park_Name"); In my testing, this was able to filter attributes that contain apostrophes and parenthesis.
... View more
12-06-2023
07:44 AM
|
1
|
0
|
1207
|
|
POST
|
You can check that here: https://status.arcgis.com/ [11:27 PST - Resolved] Between approx. 5:40 am and 10:05 am Pacific we experienced performance issues on one of our Hosted Feature Services clusters (services6.arcgis.com) which affected a subset of customers. The issue has been resolved and our Hosted Feature Services infrastructure is performing as expected. [09:10 PST] We are experiencing intermittent performance issues with our Hosted Feature Services affecting a subset of our customers. We are investigating the problem.
... View more
12-05-2023
12:47 PM
|
1
|
0
|
1590
|
|
POST
|
Another thing to try is to open the Task Manager, right click on the program and select Maximize. task.png
... View more
12-05-2023
10:21 AM
|
2
|
1
|
10600
|
|
POST
|
The Filter function's SQL syntax is very picky with quotes. Try this var fs = featuresetbyname($datastore, "Meter Box")
RETURN filter(fs, "facilityid in ('B07371314','B22661311')")
... View more
12-05-2023
07:59 AM
|
0
|
0
|
1982
|
|
POST
|
The quotes you're using aren't the standard ' or ". Replace those and it should run properly. var out_fs = { geometryType: '', fields: [ {name: 'Value', type: 'esriFieldTypeDouble'}, ], features: [] }
var v1 = $datapoint['TOTAL_MKT_VALUE']
var v2 = $datapoint['NEAR_DIST_WATER'] * 200
var v3 = $datapoint['NEAR_DIST_SEWER'] * 100
var v = v1 + v2 + v3;
Push(out_fs.features, {attributes: {Value: v}})
return FeatureSet(Text(out_fs))
... View more
11-30-2023
01:09 PM
|
1
|
1
|
1825
|
|
POST
|
I updated my reply with some code that will write those negative wait times to the console.
... View more
11-30-2023
01:01 PM
|
0
|
1
|
3029
|
|
POST
|
Have you examined the data itself? You probably have dates that were added erroneously (wrong month or year), leading to those negative numbers. You could put in a statement like this to record in the console any dates that have a negative waiting time when you run the script in the editor if (waitingTime < 0) console(`Feature: ${record.ID}, Date Received: ${Text(dateReceived, 'MM-DD-YYYY')}, Date Abandoned: ${Text(wellAbandonmentDate, 'MM-DD-YYYY')}`)
... View more
11-30-2023
12:46 PM
|
0
|
3
|
3037
|
|
POST
|
IsEmpty returns a boolean, but you're comparing it to the string "False". This will always return False. Use this instead var inspected = $feature.INSPECTION_STATUS;
var userInfo = GetUser();
IIF(!IsEmpty(inspected), userInfo.username, '');
... View more
11-29-2023
12:43 PM
|
0
|
0
|
1072
|
|
POST
|
Is the field empty ('') or does it have spaces (' ')? You can use the IsEmpty function and incorporate the Trim function if there are one or more spaces. var mail = $feature.email;
if (Isempty(Trim(mail))) {
mail = 'no email adress';
}
return mail;
... View more
11-29-2023
06:12 AM
|
0
|
1
|
4104
|
|
POST
|
You can filter your records to return only the ones from the last four years like this var fs = FeatureSetByPortalItem(
Portal('your portal'),
'your item id',
0
);
var filterDate = Text(DateAdd(Today(), -4, 'years'), 'YYYY-MM-DD');
var filteredData = Filter(fs, "datefield > @filterDate");
... View more
11-28-2023
11:47 AM
|
1
|
0
|
1614
|
|
POST
|
You can use the Floor function to round the age to integer years. var startDate = Date($feature.birthdate);
var endDate = Date($feature.deathdate);
var age = Floor(DateDiff(endDate, startDate, 'years'));
return age;
... View more
11-28-2023
09:17 AM
|
0
|
1
|
1975
|
|
POST
|
From the ArcGIS Assistant User Guide: ArcGIS Assistant is a community-driven app developed by a team from Esri Professional Services. This app streamlines certain administrative tasks for ArcGIS power users who have an advanced understanding of the ArcGIS geoinformation model, and want to perform advanced tasks outside the scope of existing ArcGIS apps. ArcGIS Assistant is the successor to AGO-Assistant. Read more about the new Assistant, as well as future intentions for the project, in the Guides.
... View more
11-27-2023
07:22 AM
|
0
|
0
|
11087
|
|
POST
|
You can examine the JSON of a web map using the original ArcGIS Online Assistant or the newer ArcGIS Assistant
... View more
11-27-2023
07:02 AM
|
0
|
2
|
11150
|
|
POST
|
Switch the order of the dates in the DateDiff function in line 37.
... View more
11-27-2023
06:32 AM
|
2
|
0
|
3489
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 3 | 2 weeks ago | |
| 1 | 02-04-2025 06:39 AM | |
| 1 | 05-01-2026 08:26 AM | |
| 1 | 04-10-2026 12:01 PM | |
| 1 | 04-13-2026 09:11 AM |
Activity Feed
- Got a Kudo for Re: Web Map Popup - Display URL Hyperlink if Exists?. a week ago
- Kudoed Re: Upload Web Experience from ExB Dev to ExB AGOL with a Custom Widget (folderUrl not found) for LReis. a week ago
- Got a Kudo for Re: Web Map Popup - Display URL Hyperlink if Exists?. a week ago
- Got a Kudo for Re: Web Map Popup - Display URL Hyperlink if Exists?. a week ago
- Posted Re: Web Map Popup - Display URL Hyperlink if Exists? on ArcGIS Online Questions. 2 weeks ago
- Got a Kudo for Re: Create dynamic map pop-up with only answered fields from Survey123. 4 weeks ago
- Got a Kudo for Re: Indicator Arcade Assistance. a month ago
- Got a Kudo for Re: Wrap/stack a text string label in an AGOL web map. 07-09-2026 04:58 PM
- Got a Kudo for Re: Arcade: Month Function Returning Wrong Value. 06-16-2026 07:45 AM
- Got a Kudo for Re: Hosted Feature Layer Details: Views. 05-29-2026 11:49 AM
- Posted Re: Attribute expression - show/hide fields if value is NULL on ArcGIS Online Questions. 05-29-2026 10:25 AM
- Posted Re: Attribute expression - show/hide fields if value is NULL on ArcGIS Online Questions. 05-29-2026 06:26 AM
- Posted Re: Hide Null values in pop up on ArcGIS Enterprise Portal Questions. 05-26-2026 09:51 AM
- Got a Kudo for Re: Wrap/stack a text string label in an AGOL web map. 05-19-2026 05:26 AM
- Got a Kudo for Re: Need help creating a pop-up chart pulling data from related table. 05-11-2026 10:35 AM
- Posted Re: create a unique ID using date and time using Arcade on ArcGIS Field Maps Questions. 05-01-2026 09:19 AM
- Got a Kudo for Re: create a unique ID using date and time using Arcade. 05-01-2026 08:28 AM
- Posted Re: create a unique ID using date and time using Arcade on ArcGIS Field Maps Questions. 05-01-2026 08:26 AM
- Kudoed Re: Arcade User Group for DanPatterson. 04-30-2026 12:37 PM
- Got a Kudo for Re: Wrap/stack a text string label in an AGOL web map. 04-27-2026 09:40 AM
User Groups for KenBuja
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
a week ago
|