AnsweredAssumed Answered

Concatenate Portal rows

Question asked by MartinShippey on Aug 14, 2012
Latest reply on Aug 14, 2012 by MartinShippey


Concatenate Portal rows


Hi – this is driving me crazy. I am simply trying to list all of a company's categories (it may be in up to 30) into one field, as a list. So in a portal which lists all of the category ids which the company comes up under, a company may show as belonging to category id nos 1, 3, 5, 8, 9 10 etc.

I need to export the company details along with the list of category ids.

I have tried to write a looping script which goes to the first portal row, copies the category id, pastes it into a text field, inserts a comma and space, then goes to the next portal row and repeats, exit after last etc.

The script partially works, but somehow picks up the content of fields which ren't even in the portal and pastes them, and then after one iteration seems to break down, listing the ids in a column and including address fields.

What should the script look like, or is there a better way to do it?

Filemaker Pro 10

Many thanks