Extracting Data as Text from a Portal

[voxelman]

I am having difficulty extracting text from the fields in a portal that I need to include in an e-mail.

Each portal row contains two text fields and the portal can have 1 to many rows. I want to include the contents of each of the portal rows in an e-mail and therefor I am trying to create a script that loops through the portal rows and concatenates each of the row's field contents into a text field in the front database record.

I think that the process should be as follows:

1) Identify the portal

2) Got to the portal's first row

Loop

3) get first text field in portal row into front record field 1

4) get second text field in portal row into front record field 2

5) concatenate front record field 1 and front record field 2 into front record field 3 to build e-mail contents

End Loop after last portal row is processed

Platform is Windows 2000, FileMaker Developer 6

[John Caballero]

Consider going to the source (the portal's data) file and building your field from there:

Your script would look something like this:

Go To Related Record (show)

Perform Script (external)

Set Field (EmailContent, relationship::gField1 & gField2)

External script:

Set Field (gField1, "")

Set Field (gField2, "")

Go To Record/Request (first)

Loop

Set Field (gField1, gField1 & Field1)

Set Field (gField2, gField2 & Field2)

Go To Record/Request (next, exit after last)

End Loop

[voxelman]

Thank you John

Works like a charm. Hope that I can return the favor someday.