2 Replies Latest reply on Aug 14, 2012 9:14 AM by MartinShippey

    Concatenate Portal rows

    MartinShippey

      Title

      Concatenate Portal rows

      Post

      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