I’m working on an app to store/organize/use data for proposals for architecture clients. Here is the setup:
I have three main datatypes: Proposals, Completed Projects, and Team members.
Typically an architectural proposal will feature past projects and team members, so that datatype has list fields for both Completed Projects and Team Members that reference back to relevant things in those datasets.
I would like to be able to track or see how much each Complete project (thing) or Team Member (thing) is being used across all Proposals. So for example I could then be able to see what the most popular project to use in a proposal is (base off of how many Proposals have included it in its “featured project” data field.) Same goes for team member. Any ideas on how to do this?