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.
P.S. I have reviewed this post as part of my work: Count the number of duplicates