Forum Discussion

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...

Relationships

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
------------------------------

JeremyLahners

Qrew Cadet

Hi Mark,

I've been trying to do that but keep getting the message "That summary function cannot be applied to this field...". I've tried with both the Related Employee field and the Employee Name field.

------------------------------
Jeremy Lahners
LeadBaller
------------------------------

MarkShnier__You

Qrew Legend

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
------------------------------