POST
|
I have an If statement that stopped working correctly after the last AGO update. I have in a ticket with Esri, but wanted to see if anyone else has any ideas. if (${permitstatus} = 'Submitted', . > date(decimal-date-time(now()) + 20), . > date(decimal-date-time(now()))) 'Submitted' is my default value for the permitstatus field. Internal staff changes the permitstatus from Submitted before they begin their review of the survey. If the dateTime for the event is within 20 days of the date that the survey is submitted, the survey cannot be submitted and a constraint message is shown. If I put just ". > date(decimal-date-time(now()) + 20)" in the constraint field, it works as intended with the constraint message. However, then the survey cannot be edited internally or attachments added if within 20 days of the event, which is why I need the If statement. Any help or ideas as to why the statement is no longer working is much appreciated! It worked as intended until around mid-September.
... View more
11-09-2021
07:30 AM
|
0
|
1
|
210
|
POST
|
The blog was very helpful, thank you! This is what worked: .> date(decimal-date-time(now()) + 15)
... View more
03-30-2021
02:24 PM
|
1
|
0
|
1067
|
POST
|
Thanks, but unfortunately that did not work and I got the same error message again using any date. Is your field dateTime or just date?
... View more
03-29-2021
12:09 PM
|
0
|
0
|
1093
|
POST
|
I need to add a constraint to a dateTime field that only allows a date that is at least 15 days after the submittal date. I am trying to use this calculation: .>=(today() + (1000 * 60 * 60 * 24 * 15)) but get a 'Please enter a valid value' message now when trying to enter ANY date. Can anyway determine what I'm doing wrong? I modified a formula in the Constraints section here: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm Thanks!
... View more
03-29-2021
10:30 AM
|
0
|
5
|
1140
|
POST
|
Hello all, I have a survey that collects several manually entered dates & times. The times are submitted in Eastern Standard Time (UTC -5 or UTC -4 during Daylight Savings). For any surveys with dates of March 14-Nov 6 (the DST window), if a survey is opened to view or edit (using web app, not field app), the times are shifting up an hour from the time that was submitted to account for the UTC -4 offset in the feature layer. For example, for a survey submitted today, Feb. 24, with a date/time of March 12 at 2:00 pm, the feature layer shows a time of 7:00 pm, and when I open the survey, the time says 2:00 pm. But for a survey submitted today with a date/time of March 15 at 2:00 pm, the feature layer shows a time of 6:00 pm, and when I open the survey, the time now says 3:00 pm. Even if just reviewing the survey, this can cause confusion, but it's especially a problem when editing a survey, since, if this shift in time of the survey isn't noticed and moved back to 2:00 pm before the updated survey is submitted, the time is now wrong. I have an Esri Support case open, but wanted to see if the wider community had any input into how I might keep this time shift from happening. Perhaps somehow using the pulldata("@property", 'utcoffset') function? Thank you kindly!
... View more
02-24-2021
01:43 PM
|
0
|
0
|
240
|
POST
|
Hello, I have shared an AGO group with you that has my feature layer in it. As I’ve been researching through Esri documentation and blog posts on how to create the desired dashboard, I’m wondering now if I’ll be able to even get there using the current data schema. So before continuing with doing research, working out attribute expressions, and testing for my popups, I’d like to give you some history and what I’d like to accomplish. I’d appreciate if you can let me know if it’s feasible and what would be needed to make it happen. Our current Capital Projects viewer that was created many years ago in SQL is here: http://cip.durhamnc.gov/ In its current state, it hasn’t been possible to have a mapping component because the only geographic information included is a parcel PIN, and that won’t work and is blank for many projects. City management has requested that we create a more updated viewer that includes a map, and would like a dashboard that has charts and graphs as well. Phase 1 of the overall project is creating the viewer using existing data. For the mapping component, I created polygon and point (with many points for multipart polygons) feature classes with the Account Number, then joined and related tables that were exported from the existing SQL database; I tried adding a Query Layer, but it wouldn’t publish. The feature layer in the group that I shared with you is these polygon and point layers and the related tables. Ideally, I was hoping to make a Capital Projects Operations Dashboard<https://solutions.arcgis.com/local-government/help/capital-project-dashboard/> or use Web AppBuilder with the Dashboard theme. It would include filters for Service Area, Fiscal Year, Completed Projects, etc., the popup panel would include Phase data, and there would be charts for the Expenditure and Financials tables. Is this even possible with how the data is currently setup? If not, do you have any suggestions on how to properly setup my data schema so that all needed data is in one table? I’ve viewed the feature layer, map, and dashboard included with the Capital Projects Dashboard Solution to see its schema and settings, and, along with your popup arcade expression help, it is greatly helpful for the popups, but not for the expenditure and financial data. Phase 2 of the overall project is converting to a new system that can be used for all city projects, not just capital projects. My department was going to test drive Aurigo, PPM software and an Esri partner, but that has hit a snag. Thank you so much for your time. From reading through the blog posts and help requests, you are an incredible asset to the community! I’ve been at my job for a little over a year now, and my whole team is learning all of the new AGO and Portal capabilities on the fly as needed. Kelly Doss, GISP GIS Analyst Technology Solutions Dept. City of Durham 101 City Hall Plaza Durham, NC 27701 P 919-560-4122 x33218 F 919-560-4808 Kelly.Doss@durhamnc.gov
... View more
12-13-2019
09:14 AM
|
0
|
1
|
15236
|
POST
|
Thank you so much for taking the time to help me! I’ll let you know if I have success. Kelly
... View more
12-12-2019
08:25 AM
|
1
|
0
|
15236
|
POST
|
Xander Bakker I had posted this same question at the bottom of the "Overlapping Features in Pop-Ups.....FeatureSets with Arcade" blog post and you responded with: " Hi You could probably try something like shown below. Keep in mind that you need to change some field names to match your data. The idea is to get the ID from the current feature and create a filter to get the related project phases. This is sorted descending on the date and you get the first element from the result, which should be the most recent change in project phase. var yourid = $feature . YourIdField ; // change the name of the field
var tblphases = FeatureSetByName( $map , "CIP Test - Project Phase");
var sql = "YourIdField = '" + yourid + "'"; // if field is text
var relphases = Filter( tblphases , sql );
var cnt = Count( relphases );
Console( cnt );
var result = "";
if ( cnt > 0) {
result = "Project phase:" + TextFormatting . NewLine ;
var currentphase = First(OrderBy( relphases , 'DateModified DESC'));
result += "Date : " + currentphase . DateModified + TextFormatting . NewLine ;
result += "Phase: " + currentphase . ProjectPhase ;
return result ;
} else {
result = "There are no project phases defined";
}
return result ; If the data is related using a relationshipclass, it can be done in a more easy way." My question is for this last sentence. I've setup my data now in ArcMap with relationship classes and published it as a feature layer. Can you explain the easy way, please? Thanks, Kelly
... View more
12-12-2019
06:30 AM
|
0
|
36
|
15241
|
POST
|
Hello all, I'm pretty new to Arcade and I'm having problems. I believe I need to be using FeatureSets in Arcade. I have a hosted feature layer with several related tables, some of which are 1:M. In the CIP_Test pop-up, for the 1:M related tables, I only need to show the data from the rows with the latest "Date Modified". I've attached a screenshot of the related table. Where there are duplicate AcctNo, I only want to show the ProjectPhase (and maybe other fields) for the record that was last modified. Any suggestions on how to do this are much appreciated! I have gotten nothing but errors in everything I've tried from any forum posts I've found....
... View more
11-06-2019
02:38 PM
|
0
|
37
|
23577
|
BLOG
|
Hello all, I'm pretty new to Arcade and I think this is the right blog for what I want to do, but I'm having problems. I have a hosted feature layer with several related tables, some of which are 1:M. In the CIP_Test pop-up, for the 1:M related tables, I only need to show the data from the rows with the latest "Date Modified". I've attached a screenshot of the related table. Where there are duplicate AcctNo, I only want to show the ProjectPhase (and maybe other fields) for the record that was last modified. Any suggestions on how to do this are much appreciated! I have gotten nothing but errors in everything I've tried from any forum posts I've found....
... View more
10-30-2019
04:58 PM
|
0
|
0
|
5168
|
Title | Kudos | Posted |
---|---|---|
1 | 03-30-2021 02:24 PM | |
1 | 12-12-2019 08:25 AM |
Online Status |
Offline
|
Date Last Visited |
3 weeks ago
|