Filter only those changed line items

fpopa

Hello,

I want to apply a filter to a module in order to import the new values re-writing the old ones. Let me explain a bit.

I have a module dimensioned by Projects (a,b,c)
This is my view of the grid in the first phase:

Project	Start Date	End Date	New Start Date	New End Date
A	15/8/2023	30/8/2015
B
C

Second Phase:

Project	Start Date	End Date	New Start Date	New End Date
A	15/8/2023	30/8/2015	22/8/2023	15/9/2023
B
C			1/9/2023	15/10/2023

Third Phase: In order to modify the old start date and old end date only for Project A and Project C I want obtain this view before running the action.

Project	New Start Date	New End Date
A	22/8/2023	15/9/2023
C	1/9/2023	15/10/2023

There is a way to apply a filter in order to have the view from the Third Phase?

Cheers,

Adi

pyrypeura

Hi,

You can set your formula to be something like (ISNOTBLANK(New Start Date) AND New Start Date <> Start Date) OR (ISNOTBLANK(New End Date) AND New End Date<>End Date). This will give you a boolean that you can use to filter out the view to contain only changed rows

BenjaminNiel

Hi @fpopa,

In your dashboard, you can add a table with the same source module but which only displays the 2 line items ("New Start Dat" and "New End Date").

In order to show only Project A & C, you can created a boolean line item with the formula "ISNOTBLANK(New Start Date") OR ISNOTBLANK (New End Date)" and use this line item as a filter in your table.

Hope this helps!

Benjamin

AlejandroGomez

You can create a line item subset with the line items and use it for filtering.