Hide Columns & Datapoints at Detail View when value is 0 or empty

[Sheikh_FARHAN]

Hello, an appsheet newbie here and not very clear on how to use the Show_if column constraints formula. Most of the existing qns/ans are more towards the form. Mine has no forms. Just pulling off datapoints from a database/table.

Qn: How do I hide the column and its value from showing up at the front-end/detail view if the value is 0 or empty cell?

Example:

Im hoping to have those 3 info/datapoints not show up the detail view. The rest of the columns are not affected and will shopw up accordingly as usual.

Thank you…

[Sheikh_FARHAN]

And does it matter if the column type is yes/no or decimal?

[Marc_Dillon]

Columns that are blank will automatically not show up in Detail views.

To hide a column with a 0 value, enter this into its show_if:

[_THIS] <> 0

Sheikh_FARHAN:

And does it matter if the column type is yes/no or decimal?

To hide a yes/no column that is “no”, use this formula in show_if instead:

[_THIS]

Coincidentally, this thread was just posted today…

What is [_this]? Questions

The majority of the times I use [_this] is inside a Show If/Required if/etc. when I need to use the value that has been entered or selected by the user. For instance: If I have a reference field in a form, that’s always preset by an action, I can usually hide that inside the form. There’s nothing for the user to do (it’s already set by the system (and in fact any interference would cause the appropriate links to be switched)), so hiding it when the user is submitting data can be helpful (to …