Set a limit of how many digits can be inputted in ...

Purple_Gallery · 01-22-2021 11:04 PM

Hi community 😃

I’m trying to make a simple app for member registration and facing a problem with data validation. desperately need help.

I need an formula/expression that sets limit of digits can be inputted in a cell based on the value of other column.

say i have 2 columns, BANK and ACCOUNT NUMBER
i need to limit digits in ACCOUNT NUMBER to 10 if value in BANK is CENTRAL BANK, and limit 15 digits in ACCOUNT NUMBER if value in BANK is LOCAL BANK.

Any help is much appreciated

OptimiX_XcrY

[acc] must be text.

A valid if , something like

OR(
And(isnotblank([bank]);isnotblank([acc]);[bank]=“nameA”;Len([acc])=10) ;

And(isnotblank([bank]);isnotblank([acc]);[bank]=“nameB”;Len([acc])=15) )

Koichi_Tsuji

Sounds like the subject of the topic is same as ; -

ehnz

Hello, I cannot see ‘Under the hood’ for this app, can you please share the valid if formula you used for the PIN column?

Set a limit of how many digits can be inputted in a cell