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
Solved! Go to 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'
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'
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
User | Count |
---|---|
17 | |
12 | |
7 | |
4 | |
3 |