Page 1 of 1

Hide Related Items Filter Column

Posted: 27 Nov 2017
by 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

Re: Hide Related Items Filter Column

Posted: 27 Nov 2017
by 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
DisplayNone.png (1.55 KiB) Viewed 1711 times

Re: Hide Related Items Filter Column

Posted: 27 Nov 2017
by 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
customer_id_column.PNG (31.9 KiB) Viewed 1710 times
I want to hide the CustomerID column, highlighted in red, in the related items list at the bottom.

Re: Hide Related Items Filter Column

Posted: 27 Nov 2017
by 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
RelatedItemsView.png (14.04 KiB) Viewed 1708 times

Re: Hide Related Items Filter Column

Posted: 28 Nov 2017
by 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

Re: Hide Related Items Filter Column

Posted: 28 Nov 2017
by Nikita Kurguzov
Not sure why that would happen as it doesn't repeat in my tests.

Here is my Children list:
RelatedItemsFilteringChildren.png
RelatedItemsFilteringChildren.png (7.53 KiB) Viewed 1701 times
And here is my Parent with Children filtered by Parent, but I've removed Parent column from View:
RelatedItemsFilteringNoColumn.png
RelatedItemsFilteringNoColumn.png (5.59 KiB) Viewed 1701 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?

Re: Hide Related Items Filter Column

Posted: 28 Nov 2017
by 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

Re: Hide Related Items Filter Column

Posted: 28 Nov 2017
by 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