Creating a label from a portal

[Jason Goldsmith]

I have a portal which contains a field from a related file. The portal is set to display multiple rows (thus displaying the field of interest from multiple records from the related file). I would like to make a label, presumably by using a calculation field, which 'adds together' the related fields in the portal rows, thus creating a single field containing the field of interest from all the records in the related file.

I hope this makes sense. Does anyone have any suggestions? Thanks!!

[BobWeaver]

Usual way to do this is with the valuelistItems design function. Create a Value list using related values from the relationship that is used for your portal. Let's call the Value list "LabelList."

Then create a calculated field cLabel with the formula:

Valuelistitems(Status(CurrentFileName),"LabelList")

[Charles Delfs]

I don't think thats what he means Bob,

If you want a Label say above your portal that would give the total of all of a given field in your portal below then,

1. make a calc or summary field in the related file that adds on the given field of interest,

2. In the prarent file put the new related clac or summary field outside of the portal. You can even merge it into a text label so that is can say "The total of widgets is: <<merged_summary_field>> "

C.D.

[Jason Goldsmith]

C.D.,

Your suggestion intuitively makes sense, but I havn't gotten it to work yet. I should mention that the contents of the field in the related file that I'm trying to merge are text. And I need to merge only the found set in the related file, and then display as a text label in the parent file.

Thanks!

[Charles Delfs]

So do you mean that the related field's data to be summarized would be like "Red blue green" assuming that the Red Blue and green records are found by the portal? and the label you want to make is something like

"Colors I found are Red,blue, green"?

[Jason Goldsmith]

Yes. If the field in the related file is labeled color, and one record has an entry in this field of "red", a second record has "green'' , a third "blue", and a whole bunch of other records have other color entries, but only the first three records are in the found set, then my question is, how can I create a label that returns "red, green, blue" (the field entries of the three records in the found set?)

[Ugo DI LUCA]

Found set ?

Your portal shows related datas, independant from the found set.

The order in which the records appear in a portal is dependant from the sort defined for your relationship.

My guess is that you'd need a little quick script to set this "label", involving a loop through the 3 first related records with a Set Field (g_label, g_label & color).

At least this one seems easier.