Jump to content

How to filter the email addresses to be used in the “send email” script step Ask Question

Recommended Posts

  • Newbies

In FM18, I have two tables: "documents" and "recipients".

The "documents" table has (among others) the "owner" attribute, while the "recipients" has the attributes "department" and "emailAddress".

I'm working on a script that sends an email message to all the email addresses included in the records having recipients::department = documents::owner.

The script is executed when clicking on a button in a layout related to the "documents" table.

In the "send email" option form, I have selected "Collect addresses across found set" but now, what should I put in the calculation?

Below you can find some script (they are in Italian) and the relationship screenshots

enter image description here


enter image description here

The script as is now sends the email to the correct addresses. However, it sends an email for each record in the table and not only for the current record.

I'm not sure how to limit the number of sent email just to one.



Link to post
Share on other sites

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
  • Create New...

Important Information

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