Skip to main content

Outputting a linked record based on 2 criteria

  • March 1, 2020
  • 1 reply
  • 3 views

  • Participating Frequently
  • 6 replies

I have 2 tables, let’s say one is a variety of companies (alpha, bravo, etc) and their different talent areas (managment, engineering, hr, IT, etc)

The next table is personnel which lists the company they work for, their talent area, and then contact info.

I want to populate a column in the companies table which will have a linked record to those personnel who match based on company and talent for each row.

If the syntax were Excel I’d be okay to figure this out using Match… but my Javascript experience is basically zero. Any help would be greatly appreciated!

1 reply

  • Author
  • Participating Frequently
  • 6 replies
  • March 9, 2020

Please disregard this post, i wrote a new one with a more detailed description