AnsweredAssumed Answered

Extracting info to be displayed in portal

Question asked by TheNovice on Jun 10, 2016
Latest reply on Jun 18, 2016 by user17152

Hello all,

I’m using FM 14. In my DB, I have a table called Books. One of the fields in that table is Books::DateRead. On a layout based on Books, I have a field that displays the date, month and year the book was read. I’ve created a TO of Books and on a layout based on that TO and I’ve put a two-column portal.

I’d like to display in the first column all the years from say 1990 to 2016 and in the second column, the number of books read in each of those years. How do I extract the years from Books::DateRead to display them in the portal and do I create a total of the books read in each year and display that total alongside the appropriate year in the portal? I’ve tried different things but to no avail. Any help would be greatly appreciated.

 

Thanks.

Outcomes