relationship into a string

[rivet]

Do you think it is possible to create a calculation that would string a related column of information into a field in the master record.

I am afraid that it will have to be a tedious script, but I thought I should pass it by the collective.

From this:

[Manufacture]

[Related Widget1]

[Related Widget2]

[Related Widget3]

To This:

[Manufacture][Widget1,Widget2, Widget3]

The result is for a final export that will publish a listing of manufactures and their products. A line return would take up to much space so that is why I need it all on one line.

[Rigsby]

If I understand you correctly, you simply want to remove the returns in a field, so you are listing items on one line with a comma to separate! This is easy! You can use a calculation or a script, but the trick here is to use the Substitute command. So, for example, you have a column of:

Apple

Orange

Pear

Grapes

In the field <FruitName>, and want to set the field <FruitLine> to the list without the returns.

Use the following:

--------------------------------------------------

SetField <FruitLine>

Substitute(<FruitName>, “ ”, “, “)

--------------------------------------------------

This will replace the returns with a comma and a space!

Hope this helps,

Rigsby

[danjacoby]

Assuming each related Widget is in a separate record in the related file...

First you need a value list that returns the related Widgets.

Next, a calc field that uses the ValueListItems formula.

Then, a calc field that strings the individual items from the previous calc field, replacing the paragraph marks with, say, commas (use the "Substitute" formula).

Now create a calc field that strings the Manufacturer, a semicolon (or whatever), and the final calc field.

HTH,

Dan

[Rigsby]

PS: If you want to add items from different related files, you will need to loop through the portal row, adding each item as you go!

[rivet]

Thanks guys