Automate Number of Customers in Job Board

Hi all,

I have two board, the 1st is for the customer database which has over 100 rows each having a unique customer along with data in a separate column dedicated to phone number, email, etc. My 2nd board is a job list with 200 rows displaying jobs numbers 1-200 in sequential order.

I connected the first board to the second board which assigns a customer to each job number (Which we pick manually depending on who we want on it). I was hoping there is a way to display a column in the 2nd board showing the number of jobs a customer has been assigned on that 2nd board.

Ex. If Customer ABC is assigned to jobs 3, 80, 125, and 170. there would be a 4 in each one of the rows.

Thanks in advance for any help!