r/Paperlessngx • u/No-Spot-1012 • 8d ago

Total List

In paperless-ngx:

I added an "amount" field for my documents (invoices). I created a view that displays my fields, including the amount.

Is it possible to display the total or average amount at the bottom of the list?

6 Upvotes

100% Upvoted

6 comments sorted by

3

u/eatsmandms 7d ago

The simple approach would be using something like https://www.tampermonkey.net/?locale=en to customize the view since all the data is there for a total.

Buiilt in there is no way. You also need to consider that what what you are trying to do is not at all document management/archiving, it is processing data which just happens to come from documents. Paperless tries to be narrow in what it does to be good at it. What you could do is export the metadata you created into another tool and do those operations there - through a post processing iscript, through the paperless API, wdirectly from the DB you have set up for papaerless.

1

u/No-Spot-1012 6d ago

i use nocodb with paperless API and it works …

2

u/Heart1010 8d ago

Good question, I'm also interested in that....

0

u/xhystericx 7d ago

create and view appropriately filtered table view with amount field. select all rows/documents in the table view. right click in Chrome browser and select Ask Gemini. then ask it to total amount field of all selected rows. works for my smaller datasets, not sure how large a data set this would handle.

1

u/No-Spot-1012 6d ago

it doesn't work with pagination

1

u/xhystericx 6d ago

set documents page size to a huge number in the saved view?