Calculation to sum portal text

[cinolas]

Hi,

Is it possible (if so how ?) to have a calculation field result in the concatenation of the text contained in one field of every portal row ?

Just to make sure I am being clear I will give you an example:

I have an office DB (containing all of the company's offices) and a related employee DB (containing all the employees of all the offices).

In the office DB there is a portal showing the employees of each specific office.

I am looking for a text calculation within the office DB that will result in a list of all the employees of this office with a carriage return in between each employee.

I know how to do this with a script and I know I can achieve something similar with a whole bunch of relationships, I'm looking for a calculation that will do that.

Thank you !

[Razumovsky]

How about defining a value list "Employees" of all values in field from related file, and then defining calc c_AllEmployees:

ValueList(Offices.fp5, Employees)

I think this could work for you.

-Raz

[cinolas]

Following the tradition of answering my own questions... (at least the tip is available to others )

I have found a way of doing just that !

- Create a value list using values from field

- Set the value list to use "only related values from" and select the relationship (in my case "employees")

- Then create a text calculation field with the following code: ValueListItems( "Offices.fp5", "employees").

- In "storage options" select "Do not sotre calculation result -- calculate only when needed"

Voila !

[cinolas]

Razumovsky, you are faster than me! Good thinking

But it doesn't work unless you specify not to store the calculation result.

Thanks for the help.

[cinolas]

Minor update.

Only the first 253 characters of each text field (each portal row) will be returned by the calculation.