Selecting Portal Rows

[jimlongo]

Hi, I have a layout with a portal view of another table.

This table contains multiple client's information.

If I want to send an email to each client in the table I've found I can do this . . .

Go To Portal Row [First]

Send Mail [To:clients::email, etc., ]

Go To Portal Row [Next: Exit after last]

Send Mail [To:clients::email, etc., ]

However in the case that there is only one row present in the portal this script creates a second empty email.

How can I avoid that?

Many thanks,

jim

[jimlongo]

I take it back, that only emails the first 2 records in the portal. If there are more than 2 it stops after the second one.

So I did this . . .

Go To Portal Row [First]

Send Mail [To:clients::email, etc., ]

Loop

Go To Portal Row [Next: Exit after last]

Send Mail [To:clients::email, etc., ]

End Loop

Still there will now always be an empty email as the last one.

So still the question . . . how do I email multiple records in the portal?

Thanks.

Edited November 22, 2010 by Guest

[bcooney]

I would gtrr and now be in a found set in the child table (your client's table).

Go to Related Related (match current)

Go to Rec first

Loop

Send Email

Go to Next, Exit after last

End Loop

Go to original layout

But, you can do this from the parent, and loop thru the portal recs:

go to portal row first

Loop

Send Mail

go to portal next, exit after last

end loop

[jimlongo]

Thanks Barbara, your Go To Related Records method did the trick, it worked perfectly.

For some reason the 2nd suggestion - attempt to loop through the portal rows got the same results as I had been getting . . . an empty email as the last one.

Thanks again!

[comment]

For some reason the 2nd suggestion - attempt to loop through the portal rows got the same results as I had been getting . . . an empty email as the last one.

It looks like your relationship is set to allow the creation of new portal records - so the last portal row is actually an empty "ghost" row.

[jimlongo]

aha, I see . . . that explains that, and a few other things.