Summary field of all text fields in a portal

[RichGags]

I have staff portal on an event layout when I add staff members who perform at events. Is there any way to make 1 text field in the event table that is a calculated summary of all the entries in the portal?

 

For example...

 

STAFF PORTAL (on Event Layout)

Richie

Vinny

Josh

Nelson

 

would give...

 

All_Staff_Field: Richie, Vinny, Josh, Nelson

 

 

Thanks!

[AHunter3]

Assuming that the staff member names are in a single field, yeah.

 

Create calcfield in Event, let's call it "StaffList", formula is:

 

Substitute (List (StaffMembers::FirstName); "¶"; ", ")

 

RESULT type = "text".

[RichGags]

You're the best! Thanks!