Solved

Mailing records filemaker pro 11

Posted on 2011-03-13
2
431 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Changing color in a logo 7 332
FMP auto filed input? 3 123
Filemaker Pro 10 display order 2 34
Scanning Files and Merging with Existing PDF file 6 87
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now