AnsweredAssumed Answered

Count Duplicate Values

Question asked by 4sellff on Apr 8, 2018
Latest reply on Apr 9, 2018 by philmodjunk

Hello FileMaker community. I have two tables: users and reviews.  Our app allows each user to provide a review of every other user. Would like to have auto updating count of "reviews given" and "reviews received" for each user.

 

- Data will be displayed on a form layout with updated counts

- The form layout will include a portal, with list of "reviews received" in reverse chronological order

 

Provided a couple of screen shots which illustrate simplified table layout and the desired outcomes. Are able to obtain correct value for "reviews given" using summary field. Not able to obtain correct value for "reviews received." Have tried multiple table instance designs and self-joins, but not yet able to crack this. Appreciate any thoughts or ideas. Thank you.

users
reviewsreview counts
fm-users-table.PNGfm-reviews-table.PNGfm-review-counts.PNG

 

P.S. I have reviewed this post as part of my work: Count the number of duplicates

Outcomes