Apply show-if constraints everywhere except forms?

[Palmbus_Palminf]

How to do please ?

[LeventK]

@Palmbus_Palminfo
NOT(CONTEXT("ViewType")="Form")

[Palmbus_Palminf]

Thank you, it works well in detail, but when I’m in the form, the constraint applies anyway!

[LeventK]

@Palmbus_Palminfo
Do you want to display the column only in Form View? Please elaborate.

[Palmbus_Palminf]

Permanently in the forms and conditionally in the other views.

[LeventK]

Then you can simply set Show_if to FALSE for that column.

[Palmbus_Palminf]

Yes, but in this case, can i impose show conditions for other views?

[Steve]

To hide a column in all views except forms, set the column’s Show_If to:

CONTEXT("ViewType") = "form"

To hide the column only in form views:

CONTEXT("ViewType") <> "form"

To show only in select specific views but hide in all others:

IN(CONTEXT("View"), LIST("MyTable_Form", "MyTable_Detail"))

Note the use of "View" versus "ViewType" with CONTEXT() in the above.

[LeventK]

@Steve
Is there a reference doc for creating colored text? I have tried Markdown, BBCode or HTML but it didn’t worked out other than specific tags like <pre>, <code> etc. Thnx.

[Steve]

The colored text happens automatically when I begin and end my sample text with three consecutive backticks (```) on a separate line. The colorizing seems inconsistent.

[LeventK]

Thnx for the info @Steve

[LeventK]

@Palmbus_Palminfo
You don’t need to specify any condition for other views. It totally depends on selecting that column explicitly in the column order for that view i.e. Table or Detail

[Palmbus_Palminf]

Thank you, it’s very nice, I will try your solutions. But for example, I would like the column to always appear as a form but only if it is “Not Compliant” in the other views. It does not work with my next formula, which is correct. The column disappears well in the detail view but also in the form!

and([pc_caisse]=“Non conforme”,CONTEXT(“ViewType”)<>“Form”)

[Steve]

Try instead:

or([pc_caisse]=“Non conforme”,CONTEXT(“ViewType”)=“Form”)

[Palmbus_Palminf]

Thank you. With this solution, the column disappears as soon as you select “Non compliant” and therefore the user can change his mind and the worst is that it appears in detail, even if it is not equal to “Non conforme”. Something as simple as that, it makes me crazy not to do it.

[Palmbus_Palminf · Accepted solution]

Thanks a lot to both of you. Your ideas especially helped me. The correct logical formula is therefore:

OR ( AND ( [pc_caisse]=“Non conforme”,CONTEXT(“ViewType”)<>“Form” ) , CONTEXT(“ViewType”)=“Form”)