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
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
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’
1 Like
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”)
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.
1 Like
Thank you so much. it solved my problem.
1 Like
ive try to find setting in appsheet but didnt find. can i see where i can find this setting ;thank you