Need to get count of referenced field

oogabooga
Tera Contributor

Hello,

 

I have requirement to create a field in a table that counts how many times checkbox is checked in field from another table.

 

What is the best way to achieve this?

1 ACCEPTED SOLUTION

Najmuddin Mohd
Mega Sage

Hi @oogabooga ,

If Table 1 is referencing Table 2, and number of times a checkbox is checked in Table 2 should be reflected in Table 1 then, 

 

Create a Business rule, on Table 2 and GlideRecord Table 1 with filter that is a reference to Table 2 and update the field in Table 1.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

View solution in original post

2 REPLIES 2

Najmuddin Mohd
Mega Sage

Hi @oogabooga ,

If Table 1 is referencing Table 2, and number of times a checkbox is checked in Table 2 should be reflected in Table 1 then, 

 

Create a Business rule, on Table 2 and GlideRecord Table 1 with filter that is a reference to Table 2 and update the field in Table 1.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

Thank you, 

 

Followed the steps and got it to work.

 

Thank you!