Counting by group in a portal

[Helder Moreira]

Hello good afternoon,
I have 3 tables (Students - Readings - Books) related
Students (ID; Name); Books (ID; Title); Readings (uuid; Date; fk_Studente; fk_Book)

Students --- <Readings> ---- Books

I intend to show a portal which books were ordered per student, how many times he took each book, knowing that he can take the same book more than once.

I did follow this steps: https://scarpettagroup.com/filemaker-portal-show-distinct-value-tutorial/  to group the book.

Any help to maker the counting by group?

[comment]

  On 5/5/2020 at 3:34 PM, Helder Moreira said:

I intend to show a portal which books were ordered per student, how many times he took each book, knowing that he can take the same book more than once.

Expand  

Do you mean a portal placed on a layout of Students? Showing which books were ordered by the currently viewed student?

 

  On 5/5/2020 at 3:34 PM, Helder Moreira said:

Any help to maker the counting by group?

Expand  

What exactly is a "group" here? A group of readings of the same book by the same student?

 

[Helder Moreira]

Do you mean a portal placed on a layout of Students? Showing which books were ordered by the currently viewed student?

Yes, a portal placed on a layout of Students. exactly 

  On 5/5/2020 at 3:41 PM, comment said:

What exactly is a "group" here? A group of readings of the same book by the same student?

 

Expand  

Group of books

[comment]

If you want to see which books were read by the currently viewed student, with each title appearing only once, you can simply place a portal to the Books table onto the layout of Students. There is no need to add anything to your file's schema for this.

I am afraid I still don't understand your counting requirement. What is a "group of books"? Grouped by what?

 

Edited May 5, 2020 by comment

[Helder Moreira]

  On 5/5/2020 at 4:20 PM, comment said:

If you want to see which books were read by the currently viewed student, with each title appearing only once, you can simply place a portal to the Books table onto the layout of Students. There is no need to add anything to your file's schema.

I am afraid I still don't understand your counting requirement. What is a "group of books"? Grouped by what?

 

Expand  

on the book's portal within the student layout, it should show all the books the student has picked up; To avoid presenting repeated books, I intend to show this book only once but showing a counter how many times this book has been taken.

[comment]

Okay, then.

My preferred method for this is to add a global StudentID field to the Books table. Then add a calculation field cCountReadings (result is Number) =

ValueCount ( FilterValues ( List ( Readings::fk_Studente ) ; gStudentID ) )

Next, define a script that does:

Set Field ( Books::gStudentID ; Students::ID ]

On the layout of Students, place a portal to Books showing the Title and cCountReadings fields. In Layout Setup, add a OnRecordLoad script trigger that calls the above script.

This will cause each book to count the number of related readings by the currently viewed student (whose ID is in the global field).

 

[Helder Moreira]

  On 5/5/2020 at 4:46 PM, comment said:

Okay, then.

My preferred method for this is to add a global StudentID field to the Books table. Then add a calculation field cCountReadings (result is Number) =

ValueCount ( FilterValues ( List ( Readings::fk_Studente ) ; gStudentID ) )

Next, define a script that does:

Set Field ( Books::gStudentID ; Students::ID ]

On the layout of Students, place a portal to Books showing the Title and cCountReadings fields. In Layout Setup, add a OnRecordLoad script trigger that calls the above script.

This will cause each book to count the number of related readings by the currently viewed student (whose ID is in the global field).

 

Expand  

Finally it works...   you saved my day.

THANK YOU SO MUCH.... "MUITO OBRIGADO"