More elegant expression than AND(ISNOTBLANK([column1]),ISNOTBLANK([column2)) etc for 20 columns?

[michael12]

Hi everyone, I'm a newbie to expressions. I'm sure there is a shorter way to do this, but I tried using LIST and couldn't figure it out.

I have 5 tabs that help break up a form with about 100 columns. I am making each next tab visible only if each of the columns in my current tab are filled. So, for example, if Columns 20-35 are filled, that means the next tab which is a show column in Column 36 will be unlocked.

The only way I have this working is with the formula AND(ISNOTBLANK([column1]),ISNOTBLANK([column2)) but this seems not elegant to have to list columns 20-35 individually.

Is there a better expression?

Thanks!

[stilllifemuseum]

Hello! I think the most elegant solution would be to make each column "required", this way you won't have to hide the column with a formula, but to go to the next page of the form you will have to fill in each column. Greetings!

[MultiTech · Accepted solution]

Kinda sounds like maybe you should split your table up into child-records?

This might help:

https://youtu.be/JqttMtwM8gg

 - I see there's no in-line viewer to watch that video here on this page.... *sigh*

Also, any items on a page will be hidden if you hide the page itself.

 - This can make it easy to hide a complete group of columns, say Page 3, if something on Page 2 isn't complete.