Filter only those changed line items
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
Best Answers
-
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 rows0 -
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
0
Answers
-
You can create a line item subset with the line items and use it for filtering.
0