Count the books of an author

siimsand

Hello!

I've created this table Author. In the classic client under the "Items" I've created some sample books for the author with some details (fields), including "Number of Pages", "Type of Cover" (Softcase, Hardcase, ), etc. I've also created pages Author List and Author Card, on each an action button called "Statistics", which should display a message with:
1) the number of books by the author
2) the number of pages of the books by the author
3) how much of the author's books are in the reserve
4) how much (%) of the author's books have a softcase
etc.

How should I execute this? I presume for 1) I should count the author somehow? Maybe some of you have come up against this, but I'm struggling a little bit.