- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 09, 2022 04:42 PM
I have two tables, one with products and one with parts of the product. On the parts table, I include a team member who's responsible for that part. Sometimes the same team member is responsible for all the parts, and sometimes the responsibilities are split.
In the products table, I'd like to summarize the team member who's most responsible for the product, who'd be the person assigned to the most product parts. I can't figure out a way to do a rollup that shows the most common value of the linked parts, though. Is there a way to do that?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 12, 2022 06:19 AM
Hmm, off the top of my head I think you'd have to do this with an automation that runs a script every time a `Product`'s `Part` list gets updated I'm afraid
Hopefully someone else has an idea for a non-script solution
