AnsweredAssumed Answered

Summary list of or Calculation field or Other for creating list of field IDs within a single Record?

Question asked by ezeitgeist on Oct 11, 2017
Latest reply on Oct 11, 2017 by ezeitgeist

Setup: I have a table of Projects. There are up to 3 different leads on the project (Lead_1, Lead_2, Lead_3), an Associate, and an Assistant, and a few other positions. All of these fields, within the record, are pulled from (and populated with) a drop-down of Contact_IDs from a Contacts table.


Goal: I would like to create a list of all the Contact_IDs in the record fields within a single field (to hopefully then utilize in a portal on a Contacts table layout).


What is the best approach? I'm pretty sure I could create a Calculation field to do it. I've done Summary (list of) lists for IDs across multiple records but am not sure if that can be applied to within a single record. Is there another one not mentioned that is more efficient?


NB: I am utilizing Web Direct with this project.