Okay, so given that the goal is to get a list/count of reviews per Company:
I’ll assume that you don’t currently have any computed columns in any of the tables you’ve listed.
- In your Reviews table, add a single relation column that matches the ReviewFor column with the same value in your People table.
- Use a lookup column to fetch the Company name/identifier via that relation.
- In your Companies table create a multiple relation column that matches the Company identifier with the same value in the Reviews table (the lookup column).
- Use a rollup through that relation to get a count of reviews for each company.
I guess you can probably figure out the rest.
@Darren_Murphy I feel like I’m missing something basic here; maybe I’m overthinking it?
I built what you described in your last response, above (very clear, thanks!)…but it’s still counting/rolling up the total reviews by all companies for TargetCompany (4 total reviews), like this…
A) Reviews for TargetCompany:
- Company ABC, Company XYZ, Company 123
- 4 reviews
…instead of what I want: how many reviews by each company for TargetCompany, like this:
B) Reviews for TargetCompany:
- Company ABC, 2 reviews
- Company XYZ, 1 reviews
- Company 123, 1 reviews
Am I making any sense? Or missing some simple logic?
Can you show me the configuration of the Rollup column?
It sounds like you might not be targeting the relation correctly.
Sure thing. The names are long, so they get cut off if I take a screengrab. Does this work?
In Companies-Table
Rollup column name: {ReviewFor-RelationLookupRollup}
- Configuration: {ReviewFor-Table-RelationLookup}
- (Which is the multi-relation column name matching CompanyRecID values in Reviews-Table)
- Calculate: Count
Does that help?
No, please show me a screenshot.
The reason I asked for a screen shot is because as soon as I see that I will know whether or not it is correctly configured. I cannot deduce that from you describing how it is configured.
Like this?
Companies-Table → ReviewsFor:
And, in case it helps, Companies-Table → ReviewsFrom:
Is that what you’re looking for?
Also, see the screen grab below from Companies-Table. For Target Company A, you can see 2 reviews from AT&T and 2 reviews from Humi, etc. I need a single field that lists how many reviews a company has from all other companies.
Target Company A reviews:
- 2 reviews from AT&T
- 2 reviews from Humi
- 1 reviews from dripdrop
- 1 reviews from Rose Rocket
- 1 reviews from Kritik.io
Target Company B reviews:
- 1 reviews from 6ix
- 1 reviews from SkillsCamp
- 2 reviews from Autumn
- 1 reviews from dripdrop
@Darren_Murphy @ThinhDinh Does what I posted here help clarify? I’m trying to get all this in one field in Data, not multiple fields stacked on each other by using Layout.
