Showing columns in edit mode only

Andrew_Hock · 08-07-2020 09:18 AM

Is there a way to show a column in edit mode only? And vise versa, is there a way to show a column in non-edit mode only?

Steve

Define “edit mode”, please.

Andrew_Hock

When you click on an action that takes you into a form that edits the current row.

Steve

So in a form.

There are several ways to control whether a column is visible in a form. The easiest is to use a Show_If column constraint (an expression for the Show? property of the column):

A Show? expression of (CONTEXT("ViewType") = "Form") will cause the column to only appear in the form view. The expression, (CONTEXT("ViewType") <> "Form"), will prevent the column from appearing in a form view.

See also:

Andrew_Hock

Simple enough. Thank you.

Andrew_Hock

I’m using the equation CONTEXT(“ViewType”) = (“Detail”) as instructed but it’s not hiding the column when it’s in Form View. It’s a virtual column. Could that cause issues?

Steve

I gave no such instruction. CONTEXT(“ViewType”) = (“Detail”) will only be TRUE when the view type is Detail. Why would you think this would also be true in a form view?

To revisit my suggestion:

Nope.

Andrew_Hock

You are correct, you gave no such instructions. However, with a different column, I used the equation, (CONTEXT(“ViewType”) = “Form”), but it still appears in the Detail view.

Steve

Please post a screenshot of the complete Show_If expression, and a screenshot of the view in which the column is displayed improperly.

Andrew_Hock

In this one screenshot you can see both the Show_If expression and the detail view to the right. The column we are working with is Lat.

Steve

Nick25

Hi, is there a way to hide column if value is no greater than 0 but still show in edit mode?