Hide blank column in "detail view"

i used "show if" (as shown in screenshot) in column (contact number) to limit user by their roles. but in "details view" column (contact number) is shown even it is blank (see screenshot). can you please help me to hide column which is blank. @Steve 

Screenshot 2024-05-31 212459.pngScreenshot 2024-05-31 212532.png

Solved Solved
0 7 611
1 ACCEPTED SOLUTION

OR(AND(ISNOTBLANK([_this]),IN(LOOKUP(USEREMAIL(),user,table,user mail,'CONTACT NO.'),LIST("view only","edit"))),CONTEXT(VIEWTYPE)<>"detail")

Add a CONTEXT() condition so it will show in all views except 'detail'

View solution in original post

7 REPLIES 7

I believe you can just add a ISNOTBLANK([_this]) condition to your other condition. Something like:

AND(ISNOTBLANK([_this]),IN(LOOKUP(USEREMAIL(),user,table,user mail,'CONTACT NO.'),LIST("view only","edit")))

but then it also get hidden from "form view" becaue column is empty when we're adding, see screen shotโ€ƒScreenshot 2024-05-31 223246.png

 

OR(AND(ISNOTBLANK([_this]),IN(LOOKUP(USEREMAIL(),user,table,user mail,'CONTACT NO.'),LIST("view only","edit"))),CONTEXT(VIEWTYPE)<>"detail")

Add a CONTEXT() condition so it will show in all views except 'detail'

Or if you only want it in 'form' you can use CONTEXT(VIEWTYPE)="form" instead

OR(AND(ISNOTBLANK([_this]),IN(LOOKUP(USEREMAIL(),user,table,user mail,'CONTACT NO.'),LIST("view only","edit"))),CONTEXT(VIEWTYPE)="form")

Thank you so  much. it solved my problem.

There is a setting for this purpose. You can find it from Settings > Views. If it's OFF, your formulas only affect on form views.

ive try to find setting in appsheet but didnt find. can i see where i can find this setting ;thank you

Top Labels in this Space