ChrisH

Thanks for those Ralph, I will copy and past and put it all back together again and see if it works over the next few days and report back.

Well I reckon that I best keep fiddlin with the faulty one as FM8 is not in this weeks budget. Maybe a kind soul would give a screen shot of what the other 3 tabs are supposed to look like so I can move things into place nicely, then it should work ~ me thinks. Thanks RalphL

Yes it does have the PDF & Excel features but on the FM web site it shows ~ Email Campaign Management FREE .fp7 The screen shot has 4 tabs and yes I am seeing all at once with no tabs with everything on top of each other.

I have downloaded the Free Email Campaign Management from the FileMaker web site but instead of it opening up as the screen shot shows the first form layout has so many overlapping fields looking like all of the forms have been dumped on top of each other in the first. So has anyone found this also and has anyone got a cleaned up version by chance. I have spent a little time trying to clean it up but without screen shots of the various forms showing their contents I am just making a mess of it. :idunno:

Great little programme thanks, hope that I find a use for it. I did have trouble downloading on Safari, which at times is not unusual and it downloaded and unzipped fine using FireFox.

After creating all manner of extra tables for address and phone variables I am really no further forward and go back to Stash's suggestion of using Related Records to search but I am still unsure of how to formulate such a search as creating a new field to suit the requirements. I have noted that in the Relationships section there are 3 Similars tables but in the actual list of tables these do not appear and under the table for full contacts management there are a number of fields for Similars but but I have tried to create one for searching the SponsorNetwoker and it does not seem to happen. Can anyone walk me through this one please?

This may be of particular interest to many which I found on a Skype Forum: "Please take a look at Jon's Phone Tool which handles all of the transformations for you from Address Book as well as from Entourage, Palm Desktop, Now Contact, FileMaker Pro, or just about any application and also provides many other useful features such as pausing iTunes, a call log, a call timer, and much more." (Shareware) http://homepage.mac.com/jonn8/jpt/

tell application "Skype" activate end tell After a few hours looking around I found what I needed at the Apple Forum for Applescripts

I am trying to do a real simple script which is just to open Skype using a button but the script above is doing far more than I want to at this stage. Could someone please give me a little script that will just open Skype, I would really appreaciate it. Thanks.

In my contacts db I wanted to find a way to clicking a button to call some one with Skype. I figured if I put in a field for it and then create a button which would then have a script to open Skype and maybe call the contact or if this was not possible to at least open Skype. As my ability on sripting is copy and paste etc and not seeing any option that allows opening an application such as Skype I am wondering if this is possible. On the Skype Forum the following script was offered to us to put into our users/library/address book plug-ins and I am wondering if this could be adapted to be used in FM7. using terms from application "Address Book" on action property return "phone" end action property on action title for p with e return "Call with Skype" end action title on should enable action for p with e return true end should enable action on perform action for p with e set x to (value of e as string) if character 1 of x is not "+" then if (character 1 of x is "(") or ((character 1 of x is greater than "0") and (character 1 of x is less than "9")) then set x to "+1" & x end if end if set SKYPEurl to "callto://" & x tell application "Skype" get URL SKYPEurl activate end tell return true end perform action end using terms from 2005_04_08Skype.zip

Well yes sorry, a novice talking is like grasping at straws for a language that one does not quite understand. So there is a Contact - Everyone has the contact status 1. The Contact Status can/will have Business and Personal attributes or content. 2. The Contact may remain Business or Personal 3. The Contact may become Business - Personal - Networker - Employee 4. The Networker may become a Sponsor and Networker, be an Employee, be in business as of course a networker has their own business operation and also still has Personal content. 1. The Package Status is listed as an item Package ID# with attributes (colour) 2. The Package may remain red or green 3. The Package may be customised by the purchaser to include an additional attributes 4. The package may be included in an additional order which is made up of additional packages. Yes this does look and sound like one to many, this is what I saw but my words were not adequate to convey it clearly. A Sponsor is a Networker in the first instance with one ID# and this relationship becomes one to many, one Networker Sponsors other Networkers, one ID# links to many ID#'s which link to many more ID#'s like a spreading virus. Each are individual Contacts with all of the colours and attributes as one might have. As clear as mud, eh!

I kind of look at the Sponsor Networker thing like a product package group that contains a number of items and at one level the networker is just a list of various product names. The Sponsor Network may have the same or similar product package groups by product name but would also show the subsequent packages that go to make up the product package group, these are peoples names rather than product components. I think that this makes sense and may be a road to follow if anyone understands my simplistic way of looking at things. And I messed up on the download and got the FM Pro 30 day trial, that will mean mine imploads in 30 days so now downloading the Business Tracker much faster this time.

The reason or my logic for having separate layouts/tables for Sponsors and Networkers is that the DownlineGroups in each layout/table were to show once the script was worked out the downline to one level, a broad horizontal line for the Networker and it was hoped that for the Sponsor table possibly showing the Sponsored Networker and that the Networkers group below each. So that one could see those networkers that had sponsored or not sponsored and the groups that they belonged to. I kind of figured that this sort of thing would be possible and so the layout was designed to display it either inputted manually intially or automatically updated once a script was worked out. I am not sure of the benefits of having a checkbox field other than just as an indication of a networkers initial activity. There is another layout/table being Executive Business Programme which relates to intensive networker training and so from this programme the Sponsor Netwok table becomes important to monitor the growth of the networkers business for assessing the results of the training and commissions structures for their business activities. I am aware that there are specific network marketing type programmes available and I suppose that I am trying to design my own version but from those that I have seen they are just spread sheet based and pretty uninspiring from a design perspective, I also want it all to be within FM as I have a major redesign plan for the future if I can find the right person to do it or FM do it themselves. Once I have the business set up in India I shall have to find a pretty switched on FileMaker IT person to keep everything working but that is my plan and for now just to get the basics running to see what is possible initially. I have downloaded your table of occurrence graph and will add a couple of extra tables as suggested and am in the process of a 5 hour download of the Business Tracker, it seems from the promo to have many of the elements that I am using as additional db's which operate from another Office Management administration db that I have set up, this links into all the other db's. It is set up like a web site with 156 layouts/pages which has info on it and links to external db's, documents and resources that will be required to run the business and give everyone easy access to policies and procedures and is set out like an e-manual for business operation. The Business Tracker looks to have many of the external free 'mini' db's brought together as one so it will be interesting to see the diffrence and functionality. I have attached a screen shot of the Office Management db. OfficeManagementDB.pdf

Hi Ender, The purpose of this db is to have a one comprehensive db of all contacts whether they are business, personal, employees or networkers as the case may be, this is the Full Contact Management (FCM) a one stop access point. Some areas such as Employees Details will have that layout password secured as will parts of Networkers Details be blocked from view by password. There is a separate db for Employees Details that is to be used for the future Personnel Department. There is a separate db for Networkers Details that is to be used for the future Networkers Services Department. Now the point of all this is that being in India people will be pushing to know me and the business this is a fact of life, so any contact firstly is just a contact, they may provide me some personal information and or business and as we get to know them more information is transferred, they could remain just personal contacts or business contacts. It also becomes interesting because they may wish to become Networkers and so while they are personal contacts, that are involved in a business but also become part of my business as a Networker. The plot thickens, some of these contacts may become Employees as well as being Networkers, or becomes Networkers while continuing their business operations as well. So let us see and please forgive if my understanding of your meanings are off. 1. An employee will have one record that will show employement details, personal details and possibly networkers details and if they work for me part time or casual they may have business deatils as well. This is still one record. 2. Each main FCM there is one record with many layouts for specific details of each Employee. So one to one I think. But on 2 db's, FCM plus Personnel Management. 3. Each main FCM there is one record with many layouts for specific details of each Networker. So one to one I think. But on 2 bd's. but also on Networker Contact Management db. 4. Each Networker one Contact FMC but also on Networker Contact Management DB and maybe Personnel Management db. 5. Each Sponsor also being a Networker has one record possibly on all three db's. 6. Each Sponsornetworker essentially has only one record, shared over the 3 db's. 7. Everyone is a contact, they could all be one in the same. Ravi has a partime business, is becomes a networker and joins the business partime and also becomes a SponsorNetworker, someone that has signed up nertworkers to join his downline etc. 8. Some contacts are from the same company and many other things as well. 9. If it is possible to track mulitple addresses and telephone numbers and alias's, family members (as family involvement in India is important for social occassions and good relationship building then all this would be very helpful. This all sounds complicated and it is I suppose, but that seems to be the way it unfolds in the type of business that I am setting up. Confused join the club.

Hi Ender, I will work my way through what has been suggested, for me it is a matter trying to find examples with all these terms for me to absorb, trouble is things like portals don't seem to work or at least about 6 months ago they did and containers for holding pdf's etc but now when I try to do them zipp zero. So I am finding previously I was understanding and now I am starting again from scratch, it does not pay to turn your back on these things for to long. I have attached my Full Contact Management, it works very well in many ways and I have tried to set it up based on ACT which I used to use extensively but had to drop once I shifted to Macs, such a shame, best contact management system going. Well anyway a few on my scripts do not work and others do when the appropriate other db's are near by but this will show you the set up and may help in understanding better my direction and problems. FullContactManagementcopy.fp7.zip

Hi Stash & Ender, I look at what you have written and think huh huh, maybe what I am wanting to do is above my level at least in terminology so rest assurred my novice level is real on all levels but maybe the results of this work will also be useful to others. I am trying to develop this thing for a business that I am hoping to launch in the near future. I have looked at the EmployeeTree.fp7 and if this is not the same as the Simple Employee Tree I shall look further. My setup is DB 1: a table - Full Contact Management, table - Networker Details, table - Sponsor Networker Details, table - Business Details, table - Personal Details, table Executive Business Programme, table - Charity Gift Club, table Employee Details, table - ID Nimbers, table - SponsorNetworker Resources. DB2: a table - Networker Contact Management (which is a duplicate of the Full Contact Management with all the same subsequent tables but is designed only to hold specific Networker Contacts). DB3 : a table - Personnel Records. This is linked to the previous db's by the EmployeeID# only. Presently only the Full Contact Management db, Networker Details table, Networker Contact Management db and Personnel Records db are linked via Networker ID# or Employee ID#. The complete range of fields are in the Full Contact Management db and the Networker Contact Management db with duplicate specific fields in the other tables/layouts/forms as is appropriate. So essentially there is the master table (Parent) with all info available and then the subsequent tables (Children) which have their fields linked showing appropriate data for the specific table/layout. So based on the info that you have given me I possibly have the elements available to work with but not the knowledge of how to pull it all together. My thought is that I possibly have 10 tables which have the same info on them as in Networker ID# and SponsorNetworker ID#, this ID# is actually the same ID# so when the networker begins to sponsor those that are directly sponsored share the same number but beyond that the down line expands using the next sponsoring networkers ID#. So if it is suggested that I create a table for each SponsorNetworkerID#, then in my simple language I can see the logic but it would potentially mean about 50,000 SponsorNetworkerID tables or more as I shall be based in India. I know that my Full Contact Management db will possibly hold in excess of 250,000 records within about 5 years so another solution may be required before then. In some ways the Similars Tables look an interesting option but I cannot find how to create new customised ones. Clutching at straws. Simple solutions for a brain dead dreamer.

I am slowly working on developing a DB for a business launching in the near future and struggling with a couple of seemingly simple scripts. I have a Full Contact Management DB using the standard template but customised layouts/forms for business details, personal details, networkers details, sponsor networker details, charity gift club, executive business programme, alternative contacts, employees postion, empl personal, empl emergency, and activities. Each contact has info entered into each layout as appropriate. I have a separate Networkers Contact Management DB and an Personnel Management DB. A long time back I managed to input trial info into the Personnel Management DB and using a script linked to a button was able to go to the Full Contact Management DB, create a new record and the Employee info based on an Empoyee ID# would insert it to the appropriate fields of the particular employee layouts. All I had to do was click to another layout and back into the employee layout and all the info was there. Now for the life of me I cannot utilise this script with appropriate changes to copy a record from the Full Contact Management DB and insert it into the Networker Contact Management DB. I can script to open a new record in the Networker Contact Management DB and if I type in the Networker ID# which is the link in the relationship and tab to another field all of the info gets inserted quite nicely. I was trying to script to: Open File ["Networker Contact Management"] Perform Script ["New Networker Record" from file; "Networker Contact Management"] Perform Script ["Insert NetworkerID" from file; "Full Contact Management"] Refresh Window[] This I had hoped would do it all as well as refresh the window or layout so one did not have to click out and back in again. I have tried many varying scenarios on this and really it is the inserting the Networker ID# that does not happen, if that did then all the info would appear I am sure. So this is a real simple one I am sure but for me and after about 36 hours of reading threads, tutorials and manuals I am scripted into a loop of confusion. Your guidance please and very much appreciated.

Hi Stash, I have created separate databases for my main complete contacts, another db for the networkers db and for another secific group I will create a separate db. The db's are defined and linked via the Networker ID# as I can create a Networker ID# in the main complete contacts db and then by creating a new record and inserting the Networker ID# into the correct field in the Networker Contacts db all of the details for the contact are then in place. I am trying to create a script for doing this automatically but no luck so far. Okay I am unsure what is meant by "separate occassions" and "via foreign keys". Possibly the Networker ID# is the foreign key but the seaparate occassions is alien to me at present.

Steep learning curve from 0 to 7 for a new kid in the class. Using the standard Contact Management template that I have expanded to 10 layouts for various types of information relating to various types of contacts. One layout I have developed for network marketing contacts and I am trying to find a 'simple' (as scripts etc make little sense to me at this stage) way of deloping a report or list that shows a hierarchy using a combination of ID's such as the Networkers Personal ID # and Sponsors Personal ID #. Presently I can do a Find on the Sponsors ID and this will give me a list of all of the first level of networkers showing their Networker ID linked to the sponsor which is fine, Now to also show subsequent levels where the relationship is links to the Networker ID which has become a Sponsors ID with the obvious groups of networkers spreading out like a tree roots below is what I am trying to acheive and I really do not know how to begin. I have searched about through the forum but so far no joy, the book that I have by Jonathan Stars does not help and I have the loan of a training CD which is more about bakeries and schools. Some things get close to what I am wanting but not in a language that is clear, I have tried setting up a Report with grouped data using the Sponsors ID as the filed of choice as I felt this was in the right direction. So if anyone knows what I am on about then I would really appreciate any guidence.