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 !

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

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 !

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.

Minor update.

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