How to restrict character limit of a string field?

[Manikandan Subr]

Hi, Taking description field in Incident table as an example. I have set the Max length of description field to 4000 characters. But when i update this field through a script( i am not sure if the same happens when i update manually), i can even update 50000 characters. I dont want this to happen. Irrespective of the method of update, this description field should not take more than 4000 characters.

How do i add this restriction on the description field. 

[asifnoor]

Hi,

The max length attribute works only with the string data type and not with others.

To restrict the max length to 4000 characters on your field, you can write an onchange client script like below

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
   if (isLoading || newValue === '') 
   {
      return;
   }
   if(newValue.length>4000) 
   {
      g_form.showErrorBox("your_field","You cannot enter more than 4000 characters",true);
   }
}

Mark the comment as a correct answer and helpful if it answers your question.

[Manikandan Subr]

Thanks, i can run this on onChange client script. but my question is when i have set the character limit in the dictionary entry of this string field, how is it not limiting to 4000 characters? how does it auto expand with character limit being 4000 in the dictionary entry?

Also, will this client script run on Journal fields? 

[asifnoor]

Hi,

If the field is of string data type, then it will not allow you to go more than the mentioned characters. It will stop taking input.

Even the script will not work.

I just ran a code on my incident table short_description field (whose max length is 160) and it did not allow to enter more characters. When i run it through the script, it ran successfully, but the update never happened. The short description is still showing 160 chars data only.

Kindly check your field dictionary once.

The scripts work on any input field. 

[Manikandan Subr]

Hi, Thanks for your reply.

I have attached 2 files.

1. Description field type which shows character limit.

2. Data from the description field of an incident which nearly 62000+ records. This is updated through scripts from Alerts.