Solved

Mailing records filemaker pro 11

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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