Jump to content

Extracting Data as Text from a Portal


This topic is 6572 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6572 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.