Display data in repeating panel

Anvil Q&A
1

Hello,

What I am trying to do is showing unique rows to a repeating panel filtering by date (older than) but ignoring duplicated rows as explained below.
I am displaying a table,which gets update, to a repeating panel as below:

First report on 05 September

Anent name / ID Points Date
Agent1 8 01-Mar Original
Agent2 4 30-Apr Original
Agent3 8 15-May Original
Agent4 8 12-Aug Original
Agent5 8 01-Sep Original
Totals 36 05-Sep

On 15 of September I add a new row for “Agent 2” (I do not want to update the row not to miss historical data) with a new value on column Points.

Anent name / ID Points Date
Agent1 8 01-Mar Original
Agent3 8 15-May Original
Agent4 8 12-Aug Original
Agent5 8 01-Sep Original
Agent2 8 15-Sep Update
Totals 40 20-Sep

If I select the date 20 September to display the report(repeating panel) as shown in the second table I want to display only the recent updated row and the other that are unique

How can I display the unique rows ignoring the previous duplicated rows?

Thank you

2

If I’m understanding correctly, this is more of a general Python question than an Anvil-specific question. I would probably use a list comprehension. It would probably take me some trial-and-error until I got it right (and clarified exactly what I was wanting the code to do).

3

Thank you, I thought it was related on how to display data in the repeating panel excluding duplicate rows-taking the recent one

4

You can share a clone link to your problem if you still need help. It’s quite difficult to help people without actually seeing the problem yourself. Although I’ll agree with @hugetim about a list comprehension being better in this situation.

1 Like
5

Well, underlying the repeating panel is a list of items, right? So, the way I’m thinking about it, the issue is to do with how to define that list, removing the items you don’t want.

2 Likes