Small and medium business | Business Central, N...

Hiding Columns based on row values

(1) Share

Report

Posted on by Indira88

980

Hi All,

I have a requirement where in the Job Task Table based on the Task Type a column would be hidden or shown row wise.

Is this possible to achieve?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

DAnny3211 11,389 on at

Like (1)

Report

RE: Hiding Columns based on row values

Hi

not on you can obscure a column common to several rows

meaning, since it is common to rows, how can you make it appear for one row and not for the other?!?

you could instead use customisation to make the value obscured for a particular row

that's what I would do:

create a variable of the same data type as the field you want to make hide or show.

in the onaftergetrecord of the page you assign to that variable a blank value if your flag is up, otherwise you assign it the value of the field you want to show.

this variable you expose as a column within the page instead of your field

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

RE: Hiding Columns based on row values

hi DAniele,

thanks for this but since this is a boolean checkbox can we hide the checkbox?

I couldn't do that .Is there a way to do that.

Indira

Was this reply helpful? Yes No
Suggested answer

pankaj.k 994 on at

Like (1)

Report

RE: Hiding Columns based on row values

Hi Indira88,

On the bases of your requirement you need to create one page Because you already have Boolean Data Type Field so you can use it as a filter based on your data requirement.

Please find the attached screenshot that will may be beneficial for you.

Without Filter Data...

With Filter Data...

SourceTableView = where(ShowHide = const(true));

Thanks

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,514 Super User 2025 Season 2 on at

Like (1)

Report

RE: Hiding Columns based on row values

Hi, I think it can be done.

First, add a default filter to the OnOpenPage trigger when opening the page.

Add filtering logic to OnValidate Trigger in the Task Type field, and refresh the page.

Here are some related links that hopefully give you some hints.

https://yzhums.com/14752/

https://yzhums.com/16756/

Thanks.

ZHU

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

RE: Hiding Columns based on row values

Hi Zhu,

Thanks for this I understand how that could be done on a header part but how a column control boolean could be hidden is my question.

For a certain value say '1' in a table the column type boolean(checkbox) has to be hidden and for the column value '2' the checkbox should be visible.The checkbox is a part of the same column,Referring to the diagram pasted above.

Thank you once again for all your help

Was this reply helpful? Yes No
Indira88 980 on at

Like (1)

Report

RE: Hiding Columns based on row values

Pankaj Thank you for the explanation,but the values which are controlling the column hide/show cannot go away as described in the above example,and I will have to do this as a part of an existing page customisation.If you can understand from the screenshot described in my strating email.

Was this reply helpful? Yes No