topic Re: How does one have predefined filter on whole sheet? in App Development

How does one have predefined filter on whole sheet?

dwighttrumbower — Thu, 19 Aug 2021 18:14:26 GMT

I would like to show only certain products on a sheet.

I have several objects on the sheet and need to exclude a few of the products. Is this easily done?

Thanks

Re: How does one have predefined filter on whole sheet?

canerkan — Tue, 24 Aug 2021 11:41:31 GMT

Hi Dwighttrumbower,

i haven't done it yet but i found a video on youtube. It seems pretty simple.

https://www.youtube.com/watch?v=d85WIgy35Ig

Regards,

Can

Re: How does one have predefined filter on whole sheet?

dwighttrumbower — Tue, 24 Aug 2021 12:05:12 GMT

Thanks I was able to do it with a default bookmark.

Re: How does one have predefined filter on whole sheet?

stevejoyce — Tue, 24 Aug 2021 12:07:21 GMT

My thoughts:

-Have an action on opening your sheet to select your "certain products".

-Variabilize your common sheet set analysis (vSheetCommonFilter = [Product] = {'ABC', 'XYZ'} and use this $(vSheetCommonFilter) in all of your objects' expressions.

-Create a secondary product field with just the values you want to show on this sheet. Use this dimension in your sheet's objects. But you'll have to keep in mind excluding the real product field so there is no unexecpted conflict

I would probably go with (2) but depends on UX.