Is there a way that I can parse the first letter of a retrieved field value to use in creating folder structure and is there a way to force capitalization of said parsed value in workflow?
(10.2.0.216)
Is there a way that I can parse the first letter of a retrieved field value to use in creating folder structure and is there a way to force capitalization of said parsed value in workflow?
(10.2.0.216)
You can do that all in one step. When you are at a move entry (if moving a document) or create entry (if just making a folder) everything can be done in the token editor. In the path you will choose (or type in) the path up to the point of what you want to dynamically create. The choose the token from the retrieve fields. Apply a regular express of (.) to pull the first character of the value. Apply the To Upper function to force it to a capital letter.
For example if I want to dynamically create a subfolder for everyone who's last name starts with the same letter. I retrieve the Last Name field. Go to move the entry and in the path I put the Last Name token. Then I apply the Expression and Function to the token.
If you are attempting to enforce a capital letter in the field value, you would have to retrieve the field and reassign the field. For example if I want to make sure every first name starts with a capital letter, I would retrieve the field value then turn around and reassign the field value using the function of either ToTitleCase if you want the first letter capital, or ToUpper if you want it all in Caps.
Is there a way to use ToTitleCase in Forms to work the same as this toTitleCase function does in Workflow? We do have a toTitleCase JavaScript function class set up in Forms, but it doesn't work the same as the function in Workflow. The first letter of each word is capitalized. However, everything after the first letter is changed to lowercase. For example, some companies/agencies use abbreviations, like the Attorney General Office or "ATG". When typing in ATG in all caps, and then tabbing out, the TG are changed to lowercase tg. Is there a better way to handle that in Forms on the front end without using Workflow to do this correctly? See my screenshot attached.
Thank you so much! I'm still pretty green with workflow, you have been a lifesaver!