topic Re: Displaying a Table based on User filter selection in App Development

Displaying a Table based on User filter selection

Kandimal — Sat, 16 Nov 2024 01:30:18 GMT

Hi All,

I have a peculiar requirements from my stakeholders,

I have a table and 4 filters in my sheet. Initial requirement was to make the sheet to display based on Customer_ID Selection and was achieved using GetSelectedCount(Customer_ID)>0.....Now user wants to expand this to other filters as well, where by default the table should show a message "please select atleast one filter" and post selection, the table should be filled with user selected data.

Re: Displaying a Table based on User filter selection

chrismarlow — Wed, 09 Sep 2020 17:56:32 GMT

Hi,

If they want it to show if any of the fields has filters can you string them together with OR? e.g.;

GetSelectedCount(Customer_ID)>0 OR GetSelectedCount(Other_ID)>0

Cheers,

Chris.

Re: Displaying a Table based on User filter selection

Kandimal — Thu, 17 Sep 2020 11:15:53 GMT

Hi Chirs,

@chrismarlow

Thanks for the input. Suggested approach was already used in the report. that was due to the if else statements in side the filter columns in the front end app.

To overcome this, As a turn around solution, i have moved all the calculations to back end and calling final columns in the front end and on top applied

GetSelectedCount(Column1) or GetSelectedCount(column2) and gave me the desired results.

Thanks