Forum Discussion

JeremyLahners's avatar
JeremyLahners
Qrew Cadet
3 years ago

Querying from many-to-many table to populate field value

I have a many-to-many relationship of employees to campaigns.  Each employee can serve one of three roles within a campaign.  In my scenario I will only ever have one employee serving each role.  Tabl...
  • MarkShnier__You's avatar
    MarkShnier__You
    3 years ago
    The combined text summary field only works on field types of text.  Your employee name field is actually a user field.

    So just make a text Formula Field called [Employee Name (text)] with the following formula

    UserToName([Employee Name])

    and  summarize that field.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------