idea Auto populate Date on data entry in ArcGIS Pro Ideas

Auto populate Date on data entry

JohnCourtright — Wed, 22 Jan 2014 22:37:35 GMT

We need the ability put in the Date default entry a function that allows the current date to be entered when a new record is added to a feature class.

The Default Value for a date field should take something like NOW() or DATE() or GETDATE() so that when a user creates a new record that the current date is automatically populated into the data field so the user does not have to enter a date.

Thanks,

Re: Auto populate Date on data entry

RonnieRichards — Wed, 22 Jan 2014 22:44:31 GMT

I agree functions as default would be helpful for many data types, especially if one column is related on another. You do have some work-a-rounds depending on the environment being used.

1) Attribute Assistant but this tool only supports desktop does not scale to web or mobile solutions

2) Enable Editor Tracking Fields - however this deaults to UTC and not local time zone so it can be confusing for end users.

3) SQL Server and other RDBMS can use calculated columns. I have noticed performance issues using these but they seem to do their job and will not allow the user to override the date.

Re: Auto populate Date on data entry - Status changed to: Closed

SSWoodward — Wed, 16 Aug 2023 15:15:30 GMT

There are multiple strategies accessible to users looking for this type of functionality. The simplest, as mentioned in the comment above, would be to enable editor tracking on the feature class. This will record who created each feature, and when.

Its also possible to configure an attribute rule using arcades Now() function to achieve this goal.

I've linked some useful documentation for those looking to implement either of these strategies.

Editor Tracking

Arcades Now() Function

Attribute Rule Introduction and Examples