Getting the total votes in a related list.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2023 09:22 AM
I have a custom table named "u_eagle_awards2022"
In it I have a custom related list (custom table) called "eagle_award_votes"
One of the fields in eagle awards votes is a choice field called "vote" that has 3 options:
No / Yes / Maybe
I would like to put 3 fields on the parent list (u_eagle_awards2022) called "Yes" "No" and "Maybe" and count how many of each related records we have and put that number in the table. Is that possible?
Business rule or calculated field? I went through a few examples I found online but I could not find a script close enough that works. Any help would be greatly appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2023 09:47 AM
Hi Andrew,
You can create Related List using the below video.
Please mark this comment as Correct Answer/Helpful if it helped you.
Cheers,
Hardit Singh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2023 09:54 AM - edited 10-03-2023 09:56 AM
I have a related list, I want to know how many votes for each choice are in the related list I want the total on the parent record.
Like:
Parent Record
Related list records, each has different votes (no/yes/maybe)
On the parent record, I have 3 fields, "Yes" "No" and "Maybe" I want a number for how many yeses how many nos and how many maybe related list records on the parent form if that makes sense