I have a somewhat complex scenario, but it is working differently if it is a Brand New Entry, versus an Existing Entry.
I have a Project Drop Down field that a User can select a Project. I have a calculated field on the form, that takes that project selection and parses out the first 5 characters (project ID) and stores it into another field (Project ID).
With an Existing Request, if a user goes in and selects an option from the Project Drop down, the Project ID (first 5 characters) is successfully parsed out and the ID is loaded into the Project ID field upon hitting 'Submit'.
With a New request, when the user selects an option from the Project Drop Down and hits, 'Submit' the calculated field is not parsing out and loading the project ID into the Project ID field. The user needs to go back into the request in Edit mode, and hit 'Submit' again....one thing to note with this...when they go back into the request, the Project is still selected from the initial entry, just the calculated field is not storing the Project ID into the Project ID field.
Thank you!