Latest Contributions by NDFAdmin

Hello, I am attempting to create a database trigger that concatenates values from two different fields into an already existent empty field (or is set to null) for a newly inserted row. I'm not a DBA and I have no issue creating this type of statement in Python, but I am missing the mark in SQL. I am using an enterprise geodatabase as the backend for Collector and have used attribute rules or Python to accomplish this in the past (at a different job), but we really need this function to occur on submit and currently only have ArcGIS Server 10.5 and can't publish a feature service using ArcGIS Pro. The basic structure would be something like: IF [ProjectIDColumn] IS NULL    THEN CONCATENATE (FieldOne + "-" + FieldTwo); Any help would be greatly appreciated, thanks! ... View more

Hello, I have been using an archived feature dataset that is set up to sync for a map in Collector. Recently, I had the need to create a versioned enterprise geodatabase with Collector using ArcMap. I set up everything as I usually do and published the service, adding the REST url to the map in ArcGIS Online. However, when I try to submit data using Collector I get an error: "Unable to Submit: Error performing apply edits operation."  Does anyone who what could be the issue? Thanks! Aaron ... View more

Hello, For some reason exporting from ArcGIS Online is taking a very long time to complete or is hanging. The feature layer only has 250 records, so I don't think it has anything to do with size. Has anyone else experienced this? Thanks, Aaron ... View more

Hello, I've been trying to figure out the best way using Integromat, to iterate through a series of survey submissions for a specific day (by noon each day), find names missing from the submissions, and then email those missing names to a supervisor. I've played with a number of options, including using filters but keep coming up short. It would also be of interest to be able to iterate through a set of responses, find names that are missing and then notify those missing people via email. Has anyone tried to do this or know of a method? Thanks! Aaron ... View more

I am running into an issue when trying to filter features on a web map in ArcGIS Online. I have added a feature service from another account, which pulls all the same data they have hosted. However, when I try to filter features with a date type the date fields do not appear in the dropdown list. I added the feature service to a map on their account (the host) and they show up (they also show up just fine and can be filtered in an Operations Dashboard in my account), but just not in my account when I add the data to a new map (see attachments). ~Thanks ... View more

I have a form with two geopoint questions, an initial gepoint question and another in a repeat. I haven't been able to figure out a way to change the initial map starting location from 0,0 for the geopoint question within the repeat. Is there a way to do this? I know that I can set the initial location by pulling coordinates from a CSV, but I would like the form users to set their own location. ~Thanks! ... View more