Solved

Mailing records filemaker pro 11

Posted on 2011-03-13
2
435 Views
Last Modified: 2012-05-11
I have a database (see attached) that has two tables (Contacts and Projects). I want to be able to mail out the items in the 'Projects' table to the some, all, one of the contacts found in the 'Contacts' table. I want to have a layout to be able to do this and add the contacts to whom I want to mail the records found in the 'Projects' table.
Mailing.fp7
0
Comment
Question by:PachecoPrimo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
North2Alaska earned 250 total points
ID: 35127989
Create a portal for the contacts on the layout for the project.  I'm not sure if you want to see all the contacts or just some of them, but you should be able to select the ones you want via the relationship.

Now add a new field to the contacts table that is a checkbox.  Remember to reset all the checkboxes before/when you first come to the lay out.  

Now the user clicks the check box of the ones they want to include and runs the final script (by clicking a button is what I would suggest) that gathers up all the checked items and sends only to them.
0
 
LVL 4

Assisted Solution

by:rjplus
rjplus earned 250 total points
ID: 35206012
1. Create new table ContactsProjects - id ato enter ; idContact ; idProjectDetails; Boolean (for checkbox)
2. Create relationship from idProjectsDetail (ProjectDetails table) = idContactsProjects (new table ContactsProjects)
3. Create relationship from idContacts (Contacts table) = idContactsProjects (new table ContactsProjects)
4. Create button on Project details (form view) to add contact using script
5. Create button on Contacts list view   "Add" (parameter = idContact) script below set to "resume"
6. Create portal on Project details (form view) using relationship in "2"
7. Add fields to portal created in "6" - ContactProjects::Contacts Name, Email, + ContactProjects Boolean (set as check box)
8. Create Script as described below
___________________________________________________________________________
Starting Point - Project details layout (form view)
set variable $ProjectDetails = idProjectDetails

navigate to Contacts list view
Pause script
select contact click the new "Add"
set variable $contact = Get(Script Parameter)

navigate to new ContactsProjects layout
create new record
set field idContact = $contact
set field idProjectDetails = $ProjectDetails
set field boolean = 1

return to Project Details layout (form view)
_________________________________________________________________________

The Portal created in "6" will now show all contacts selected to receive details for this project.
_________________________________________________________________________

9.  Now Create a button on Contacts layout (list view) to Send Email to Contacts using script described below.
10. Create Script as described below
_____________________________________________________________________________
Go to Related Record from newly created portal - ProjectDetails::ContactProjectDetails navigating to ContactsProjectDetails layout - showing only related records
Send Mail - choose to create One email using data from the current file, or create Multiple emails (one for each record in found set).
Return to Project Details layout

The above outlines the process that is required - one extra table, one portal, a couple of relationships, three buttons and two scripts - that should do the trick!!

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question