Question

Limit a value entered for a metadata template field to six digits only

Laserfiche

Updated September 28, 2020

asked on June 17, 2015

Hi all,

I have created a metadata template field(for e.g a Customer code) which is of Number data type but I want to limit the value to 6 digits only. That is if the value for the field is greater or less than 6 digits, it should prompt that only 6 digits is acceptable in the field.

Please reply

Thanks

Kind Regards,

Sheila

0 0

Replies

replied on June 17, 2015

Please see this help page. You can use the following constraint in your number field

>=100000 & <=999999

0 0

replied on June 17, 2015

You could restrict the field's width to 6 characters if it's a text field. Or you could set up a constraint if it's a number field.

0 0

replied on June 19, 2015

Ok many thanks.. It is working..

0 0

replied on August 27, 2015

will it cause issues for the previous documents set at 6 digits if you change the field restraint from 6 to 7 going forawrd?

0 0

View 1 previous reply

replied on August 27, 2015

When you try to change the constraint and save, you'll see a message like

The following entry has a field value that that does not satisfy the constraint on the field: "\New Document". [9901]

which prevents you from doing so.

0 0

replied on August 27, 2015

Hi all,

I have noticed an issue with it. While entering the 6 digits in the Number field, it is changing it to another value. (For e.g: I added '987653', it is displaying '467930').

Can you please help me?

Thanks

0 0

replied on August 28, 2015

You may want to use Audit Trail to see if something else is acting on that field and changing the value.

0 0

replied on September 28, 2020

is there a way to have a range of characters from 1 to 999999? I've been playing with it an I keep getting error messages that the constraint isn't possible

0 0

You are not allowed to follow up in this post.

Question

Question

Limit a value entered for a metadata template field to six digits only

Replies

Sign in to reply to this post.