Getting the total votes in a related list.

Andrew112
Kilo Guru

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.

2 REPLIES 2

Community Alums
Not applicable

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

 

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