How do I not show a show column in certain veiws?

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 Solved
0 3 92
  • UX
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

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)?

View solution in original post

3 REPLIES 3

HI @Tameron 

Have you tried using CONTEXT view type ?

Steve
Platinum 4
Platinum 4

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).

Top Labels in this Space