Hiding columns

[Sarah_Keown]

Hi,

I am looking to hide/show different columns within an inline view in my app. I have two different order types:

• Daily Request
• Bulk Order

These each have their own associated status

• Daily Request = Request Status
• Bulk Order = Installed Status

Although they are two separate order types I have the data held on one table; an Order Details Tbl. So, each Order has related Order Details but an Order will either be for multiple daily requests or multiple bulk orders. Showing Installed status’ for Daily Requests is not required as they are blank values and likewise with Request status’ for Bulk Orders.

Currently the inline view is showing both columns and its not visually appealing to the user, is there anyway I can hide the irrelevant status? I do already have a Show_If constraint for each status depending on the Request type but that doesn’t seem to apply to inline views? This is an example of the inline view, as shown the Request Status column is blank as this Order is associated with Bulk Orders.

[Aleksi]

Create a normal (or virtual column) with an app formula like [Request_Status]&[Installed_Status]. Then instead of showing both columns, show just this extra column.

[Sarah_Keown]

Thanks Aleski, I understand what this is trying to achieve but I think the way in which I have set up the two status’, concatenating the values sets a default value for the irrelevant status.

So instead of just showing the status that is relevant and having a blank value for the other, its setting the value its joining with e.g. The Request Status of the Daily Request is ‘Ordered’ but the ‘Not Yet Drawn Off’ is actually a default value from Installed status. The two status columns are virtual and contain an IFS formula to update when data is changing in the app, they don’t have initial values set but concatenating the two is causing this.

[Aleksi]

Okay… I understood that you have either one of them, not both statuses. If you need to show both statuses, you could combine them with one virtual column with a suitable IF expression.

[Sarah_Keown]

Is there issues hiding columns that contain app formula? Because the values are being hidden from view but the actual column/header remains?

[Aleksi]

The option UX > Options > Apply show-if constraints universally is probably set as ON

[Sarah_Keown]

Yes, I checked earlier its on

[Aleksi]

Set is as OFF and then it should not show blank fields.

[JPAlpano]

Why does it need to be OFF?
If we set it to off, then that means the show if expressions will only apply to forms.
But I think the idea is that the show if expressions should apply to all views, whether form, deck, or table.

Care to clarify?

[Steve]

What are you trying to accomplish?