You need to send the email whilst sitting on a layout based on Table C.
Just before your Send Mail script set, add a Go to Related Record on Table C, pointing to the Table C layout. When you run the Send Mail script step, the found set of records will be the ones you want to send to in Table C.
At the end of your script add: Go to Layout, Original Layout, which will put you back where you started.
Best wishes - Alan Stirling, London UK.
I tried your suggestion but it will email to ALL the FIRST record of table C (Registration) that match ALL the record in table A (Preview).
I also try-and-error using the radio button "Match all records in current found set" but the result is the same.
In additional an "error" pop up while I execute the script.
The ERD diagram attached
I believe you need to select the proper layout to display the related records. You have it set to current layout.
Your screenshots are very helpful.
I suggest trying the following change in your "Go To Related Record" Options:
Where it says:
Show record using layout: <Current Layout>
Change it to specify a layout which is:
based on your Registration table occurrence.
Leave the rest of the options as you already have them in the screen shot.
This should avoid the error that your are presently seeing, and it should get you to the correct set of records that you need to send your email.
As Alan has already noted, you will probably want a "Go To Layout: Original Layout" script step after you send the email, so that you return back to your layout based on Table A.
I hope this helps & very best,
Hi Alan, Steve,
It WORKS! Thanks for everyone's time and effort, you are awesome
My customer reckons that this email feature is very important to his current issue with spreadsheet, integrate email with client contact (that is kept in spreadsheet) etc. He is also looking into SMS which I have no idea at this moment. I hope I can excite him when I show him the above solution. FileMaker rocks!
I have another request for this same app, do I open a new case or I can continue from here?