JJFernandez
Registered User.
- Local time
- Today, 03:23
- Joined
- Oct 29, 2018
- Messages
- 18
Hi all,
I am trying to automatically populate the first part of an Incident_ID field with the date of the incident.
The kicker is that the date is entered DD/MM/YYYY, and I'd like the ID to start with YYYYDDMM_ (reversed and no slashes with underscore added) and then have the user add a unique number and their initials to it (make update of the field required).
An example:
Incident Date: 15/08/2018
Incident ID: 20180815_1_JO
Any ideas are greatly appreciated!
Jeremy
I am trying to automatically populate the first part of an Incident_ID field with the date of the incident.
The kicker is that the date is entered DD/MM/YYYY, and I'd like the ID to start with YYYYDDMM_ (reversed and no slashes with underscore added) and then have the user add a unique number and their initials to it (make update of the field required).
An example:
Incident Date: 15/08/2018
Incident ID: 20180815_1_JO
Any ideas are greatly appreciated!
Jeremy