Level 1

Question

Creative solutions for showing/enforcing WORD COUNT in "text w/ formatting" field

Forum|Forum|1 year ago
April 24, 2024
3 replies
1478 views

Hi there,

Wondering if anyone here has a creative solution for showing or enforcing word count in a "text with formatting" field?

Context - we are trying to show and enforce a word limit at the custom form level on text fields so authors can send content fragments (e.g., paragraphs of text) from Workfront to other downstream systems that will assemble them into various pre-formatted templates; therefore, it is important that they do not author too much text or it will spill over in the final product (e.g., paragraph will run off the PowerPoint slide), which is why a word limit or word counter would be helpful

Recognize there is no native Workfront functionality to achieve this, so willing to go the custom route to achieve this.

Open to hearing your thoughts and ideas!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

M

Mary413

I have had the same problem with my client. It has been very frustrating and unnecessarily complicated dealing with this. This should absolutely be a native Workfront function!

R

Richard_Le_

Community Advisor

Hi,

Unfortunately there is no functionality to limit the number of characters in a text field and prevent users from typing over that limit.

What you could do however, is build a calculated field that counts the number of characters used and then returns a value of "over character limit" (or any words of your choosing) if the character limit is exceeded. Although this wouln't stop people from entering too many characters, it would provide a visual representation of if the limit as been exceeded and act as a validation check.

The calculation needed to count characters in a field would be:

LEN({DE:Name of Field To Count})

Hope this helps!

Best Regards,

Rich.

R

Richard_Le_

Community Advisor

Apologies, just re-read your question. You would like to count words, not characters.

Using the following text mode in a calculation would get you a lot closer:

SUM(1,SUB(LEN(REPLACE({DE:Name of Field To Count}," ","**")),LEN({DE:Name of Field To Count})))

What this calclulation is doing is counting the number of spaces in a string. Since each word is separated with a space it will give you a count of the number of words. It's not perfect since words may be separated with other characters such as forward slashes or dashes, but it will get you a lot closer to what you are trying to achieve.

Best Regards,

Rich.

Doug_Den_Hoed__AtAppStore

Community Advisor

Hi @madelainela and @mary413,

I concur with the clever formula @richard_le_ provided, but (since this Ask has been around for a long time) also considered creating a solution for it...then (fortunately) decided to look for a solution for it, first.

Turns out that there are indeed free plugins that already do the trick, such as this Word Counter Plus for Chrome which I just installed, and invite you to consider: users can simply highlight any text block and right click to see a popup up the Word Count you are after, the Character Count others have asked for, etc. as below.

Enjoy, and if anyone else finds (or creates) a better one, let everyone know!

Regards,

Doug

RandyRoberts

Community Advisor

Until Adobe gets serious about form validation, this and all related problems will remain… well, problems.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded