I have a client database that we use on a regular basis, runnning in FileMaker 8.

Displayed in this client layout is a portal containing the user contact information. Such as;

Name, Phone, email.

I am tring to create a script so that I can click a button in the portal row to send an email to the user of that row. This works for the first entry in the portal. If I click the button in the second or third portal row the email is always addressed to the email recored in the first row.

Any ideas how I get my script to pick up the email address from the second or third row?

Edited November 28, 200520 yr by Guest

If you have the button (in the portal row) that envokes a script, which performs a send mail step with a calculated result that references a email field in the realted table then it should be working.

in other words, if you have a portal in your companies layout that displays all the conacts from the company table for that specific company, when you run the script it should work properly.

Can you double check to make sure you referenced the correct relationship when picking your field?

If you have done all of this correctly, and it still is not working, please a copy of your file.

I am fairly certain that the relationship is correct. I have attached a screen shot of the script I am useing.

If you need the database I can send it off line.

Thanks

When you perform the commit records step, it no longer has the relted portal row record that you selected, active. Therefore you will always get the first email address.

You may be able to get around this by using a varible to set the last portal row number and then going back to it after the commit step, or getting rid of the commit step in that part of the script all together.

Thank you for your help, however this did not seem to work. I was not sure about setting the last portal row number, so I just commented out the commit step as you suggested. Unfortunately this did not help.

I think I must be missing something.

If you have time I would appreciate any other suggestions.

Thank you.

Well looking at the file you sent me, your relationship in your script is not the same relationship of your portal. You are using Email Confirmed::Communication Data 3 instead of Client Contact Database::Communication Data 3, which your portal reflects.

Make sure this is correct. In the PNG you posted it was correct however with the sample fiel you sent me it was not.

You were correct. I made the change and all is working well. Thank you very much for your time.