Hi there. I have these views:
Data Entry (Data Entry > Data Entry_Details > Data Entry_Form)
Records View (Records View > Records View_Details > Records View_Form)
They display 3 show columns that act as headers with 1 name displaying underneath. However, I want the headers to not show if the data is blank. As an example, if the NAME 1 column is blank, the Name 1 show header should not show.
I got it working for all views but not sure how to have this expression happen on JUST the Records View, Records View_Details, and Records View_Form. Here's the show_if expression I tried using in Name 1 show:
OR(ISNOTBLANK([NAME 1]),CONTEXT("View")="Records View")
I know I'm missing something here. Thanks in advance!
Solved! Go to Solution.
Maybe this?
OR(
ISNOTBLANK([NAME 1]),
NOT(
IN(
CONTEXT("View"),
LIST(
"Records View",
"Records View_Details",
"Records View_Form"
)
)
)
)
Check the name of your detail view: is the name singular (_Detail) or plural (_Details)?
HI @Tameron
Have you tried using CONTEXT view type ?
Maybe this?
OR(
ISNOTBLANK([NAME 1]),
NOT(
IN(
CONTEXT("View"),
LIST(
"Records View",
"Records View_Details",
"Records View_Form"
)
)
)
)
Check the name of your detail view: is the name singular (_Detail) or plural (_Details)?
Awesome!! Yes yes!! That did it. Thank you!!! (Oh and Detail was singular. I adjusted it. Thanks for catching that too).
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |