Max 300 char

Post Reply
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Max 300 char

Post by daya007 »

Hello Gurus

I have a requirement where user enters a comment in xl application through tm1 web. Is there any wy that i can restrict max characters. User cannot be able to write the comment which is more than 300 characters. Please help me with ideas.

Thanks
Daya
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Max 300 char

Post by Wim Gielis »

Hello Daya

You can use Data > Validation if you select that cell.

There, in the first tab, you can limit the text length.

Wim
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Re: Max 300 char

Post by daya007 »

Hello Wim

Thankyou
Its working!!
Post Reply