Customized Year filter

KharansuESSPL — Thu, 17 Feb 2022 18:18:00 GMT

Hi All,

I have a situation where I need to show a table with 3 columns - Country, Re-certification date and Re-certification status.

Twist is, a Year filter should be provided and the status column should change dynamically according to the selection of the Year filter -

For example –

If 2022 is selected in the filter and some of the Re-Certifications don’t expire in 2022 (Re-Cert. Date is available for 2022) then the Re-Cert. Status shall be updated as ‘Complete’, else it should show the status as in excel and for the past years, if the certification is not extended (not ordered or complete - and nothing further) then the status should show 'expired'

Similarly, when 2023 is selected, the record numbers shouldn’t change, only the status should be changed for the Re-Cert. Status column

Note - When any of the year is selected, the record numbers should not change, rather the Re-certification status should change

Attached the sample excel.

Thanks,

Kharansu

topic Customized Year filter in App Development

Customized Year filter