I need help figuring out how to stamp a date, once another field has been updated.
In the screenshot, once a User enters a value in the "ServiceNow ID" field, I would like the "ServiceNow EntryDate" to be stamped. Any way to accomplish this as a calculated field? Or do I need to use JS (gulp)?
I believe if its at form level you would need to resort to JS. if you want to avoid JS do you also have access to nintex workflow? You could just create a Nintex list workflow on item update/create and update the date stamp if the service now ID is filled with any value?
If its JS then as well its not very difficult though. You would just need to be sure that you update the value at the very end (i.e. after the user clicks the save button etc).
Thank you for the reply!
I have another date field (calculated field) that autopopulates when a User saves the form.
formatDate(Created,'MM/dd/yyyy hh:mm tt')
Is there no way to make a formula like this work based off the ServiceNow ID field being completed? Or would I put a similar formula in the JS area?
You can set the value of the field via JS invoked through a button click.
NWF$('#' + varServiceNowDateTimeStamp).val(NWF$('#' + varFormatedDate).val())
varServiceNowDateTimeStamp - variable name for ServiceNowDateTime
varFormatedDate - variable name for formattedDate
I am assuming you do the basic check that this code fires only if the existing field is not empty (to not overwrite previous date) and also the ServiceNowID field is not blank (to only fill when someone has filled in the servicenowid field.