We need to limit the # of characters a requestor submits into a text field. Is that possible to do? Can Fusion help with that? TY
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
I use a report to display the character counts where we need it limited for reporting purposes.
Views
Replies
Total Likes
I use a report to display the character counts where we need it limited for reporting purposes.
Views
Replies
Total Likes
That's really neat! How did you set that up?
Views
Replies
Total Likes
displayname=Executive Brief Characters
textmode=true
valueexpression=IF(LEN({name of your field})>#,CONCAT("message you wan to display if it's over count: ",LEN({name of your field})," /# characters"),CONCAT(LEN({name of your field}),"/#"))
valueformat=HTML
Here is the code for the column I use. Enter the name of the field you want it to read and set your character count limit where the # sign is. If it's over the count I have it display a message, if it's not over the count it just displays the count with the number it can't go over (example: 200/372).
Views
Replies
Total Likes
Hey Deborah - yes, Fusion could help with this. You could create a scenario that reviews requests as they are submitted and identifies fields that exceed your desired character limit. You could then do a couple of things with Fusion:
I think it depends on why you need the character limit. Is it for reporting or integration/ingestion purposes?
Views
Replies
Total Likes
The above suggestions are all good ones. The hard answer to your question is no, you cannot limit how many characters the user types in. You can only affect the field after they've typed it in.
I believe the max character count is 4,000 for built-in fields and 2,000 for custom fields.
Views
Replies
Total Likes
You can add a calculated field that will do the trick:
IF(
ISBLANK({DE:customFieldName}) || {DE:customFieldName} = "" || {DE:customFieldName} = "N/A",
"Character Limit is 100 Characters",
IF(
LEN({DE:customFieldName}) > 100,
" Exceeding Limit of 100 Characters",
IF(
LEN({DE:customFieldName}) <= 100,
CONCAT(" ", LEN({DE:customFieldName}), " Characters"),
"Character Limit is 100 Characters"
)
)
)
Views
Replies
Total Likes
Views
Likes
Replies