Help

Re: Data Validation for character limit

Solved
Jump to Solution
962 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Matranga
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to enforce data validation on a field? For example, if I want to enforce users to enter a name under 20 characters or less, can I do that?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

No, but you can create a formula field that shows a word or an emoji if the name is above 20 characters.

For example, you can create a formula that looks something like this:

IF(LEN({Name Field})>20,"","")

Replace “Name Field” with the name of your actual field.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

No, but you can create a formula field that shows a word or an emoji if the name is above 20 characters.

For example, you can create a formula that looks something like this:

IF(LEN({Name Field})>20,"","")

Replace “Name Field” with the name of your actual field.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

QuantumStep
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes! just use the DataGuard extension to enforce the maximum length rule for your field. If a user attempts to input a name that exceeds the set limit, the change is automatically reverted and the user is shown an alert.