Skip to main content

Count of record in multi-select. Is it possible?

  • March 30, 2022
  • 1 reply
  • 30 views

Hey all!

I have a table where I have lots of columns, but two in particular:
Primary column = article title (text)
secondary column = hyperlinked articles (multi-select)

The hyperlinked articles are a multi-select built with the list of all available article titles.

My question is: I want to add another column that counts the number of times “Article A” appears in all the multi-select arrays.

And repeat this calculation for every row, Article B, Article C, etc.

How do I do this?

1 reply

Databaser
Forum|alt.badge.img+25
  • Brainy
  • 868 replies
  • April 5, 2022

Hi @Josh_Gladstone and welcome to the community!

You could change the multiple select field to a linked record field and add a count field in the newly created table.