Auto input current date Field maps forms

397
6
05-12-2021 10:54 AM
LouiseHarris1
New Contributor II

Is it possible to set the date to automatically enter the current date in Field Maps form? I have tried using these expressions, now() and today() but you still have to click into the field and select the date from a calendar that appears.

 

 

6 Replies
DougBrowning
MVP Frequent Contributor

I also have found that if you make a Date field required (set not allow nulls) then the date defaults to 12/21/1899 for some reason.  The user must manually hit the today button, which most forget to.

Where is the 1899 coming from?  If you are going to prepopulate a date it should be today.

thanks

0 Kudos
DougBrowning
MVP Frequent Contributor

Anyone else have any workaround here?  It is already creating a QA nightmare for us.  The point of required was to solve issues like this.  But instead of it starting blank and forcing the user to pick it defaults to 1899 so the user just skips it and keeps going.

I do not see a way to default to today?  The field default wants a static value not a formula.  Note I am on Map classic.

Any ideas?  thanks 

0 Kudos
BenWalker1
New Contributor III

We noticed this today as well and we could not get it auto-opulate. I think it would be very useful as it will keep the number of clicks that field users need to make to get their job done.

JonathanMcDougall
Occasional Contributor II

Could this be added as to the ideas page? Really frustrating especially the 1899 date - not sure why ESRI think this is acceptable.

DougBrowning
MVP Frequent Contributor

It is happening so often I added some Arcade to the popup to help point it out to crews.

Set the formula (for us anything not this year is bad)

Check FieldEvalDate {expression/expr33}
if (Year($feature.FieldEvalDate) < Year(Today())) {
     return "Warning you have entered a bad date!"
}
else {
     return ""
}

Then in the popup text add the expression in red.

DougBrowning_1-1622553824352.png

Crew sees

DougBrowning_0-1622553796628.png

Hope that helps

DougMorgenthaler
Esri Regular Contributor

For those of you who haven't done so already, I'd encourage you to comment/contribute to this idea.

0 Kudos