Hide Related Items Filter Column

[aran.shearsby]

Morning,

I have successfully setup a related items list and filtered it using a Customer_ID column.
This column has little significance for the end user and i would like to hide it while still maintaining the filter.

Is this possible?

I tried removing the Customer_ID column, under EXTENDED view settings, but when i do this the related items list returns all items.

Thanks in advance

[Nikita Kurguzov]

Hello, aran!
You can simply click on the Customer_ID field in Designer, select Style on the right in LAYOUT section and add this CSS to it:

Code: Select all

display: none;

DisplayNone.png (1.55 KiB) Viewed 1707 times

[aran.shearsby]

Nikita,

Thanks for the quick response, however this does not work - It might be down to my explanation, so here is a screenshot of the form:

customer_id_column.PNG (31.9 KiB) Viewed 1706 times

I want to hide the CustomerID column, highlighted in red, in the related items list at the bottom.

[Nikita Kurguzov]

Oh, I see, thought you were talking about the form field, my bad.
To hide the column, try to open View setting in EXTENDED section and remove it from <ViewFields></ViewFields> section:

RelatedItemsView.png (14.04 KiB) Viewed 1704 times

[aran.shearsby]

Afternoon Nikita,

After removing the column from the extended view section, the filtering no longer works and all items are returned.
Do you have any other ideas on how to hide the column but keep the filter?

Thanks

[Nikita Kurguzov]

Not sure why that would happen as it doesn't repeat in my tests.

Here is my Children list:

RelatedItemsFilteringChildren.png (7.53 KiB) Viewed 1697 times

And here is my Parent with Children filtered by Parent, but I've removed Parent column from View:

RelatedItemsFilteringNoColumn.png (5.59 KiB) Viewed 1697 times

Are you sure you open the form after it was saved?
It takes a lot of time sometimes to save a form with Related Items and if form is opened in the process of saving, it can show all items as if filtering doesn't work. I had this happen to me while testing, so I thought that I managed to recreate the bug, but in fact it was just my form saving. After saving, it started working fine.

Also, about your filtering, are you using default filtering mode in Data Source -> Filter by form field, or is it dynamic JS filtering?

[aran.shearsby]

Hmm, let me retry hiding the column from view and give it longer to save.

As for the filter mode, I am using the default filtering mode in Data Source.

Thanks

[aran.shearsby]

Bingo!

It's working, I will be sure to give it ample time to save in the future.

Thanks for the quick replies - you can park the post as resolved now