Fred Young

Hi guys! Thanks for the heads up, now I removed all portals, sorts and unsorted calc. Now I have a last problem. It takes like over a minute just to open the database. The Database contains approx. 8000 records and is the size of 16mb, without the records it's approx 5mb... Must each of my remote users download the entire database upon connecting or why does it take so long just to open it? My opening scripts only adds 4 values to global variables, running a simple check filemaker version script and goes to my "home" layout. Thanks for all the help.

Hi. I do realize that the solution will be acting as the main email client, never mind that... I just need a way to store emails sent and received to each client so that we can track the email conversations... Plug in seems to be the only option... Sad... I really don't want to spend any more money on this solution... Any other options are most welcome. Thanks everyone for your help so far.

Hi everyone. This is what I've got and the story of my problem. I have a Solution with approx 2000 clients, 10 staff, 50 products and about 30 manufactures. It has Several Layouts, portals and relations. Also, script triggers and calculated value lists and validations. I got a host "MacUSA" but it takes almost 30 seconds just to enter the first layout. If I create new records it takes about 10sec before something happens and the same if I create new portal rows (ie. Note Utility) and just swishing between records has a delay on 5 seconds. I got 1 BIG portal that contains 4 checkbox fields, several dropdowns, popupmenus and text fields, many of them with conditional formating and that one might be a reason why it goes slow (I've got no clue at this point) Now, the question I've got is: Is there any way to "pre-cache" major parts of the records in all the several layouts on the startup or any other way to make the solution faster? The thing is, if I just browse my records and then later on goes back to a record I already visited it pops up almost instant. My skills in FM11 is somewhere between beginner and intermediate. Thankful for ANY help I can get, thanks.

Hi! I got a quick question. Is there any way to make my Filemaker solution to send and recieve emails strait from within my solution? I need the outgoing and incoming emails to be saved like a "chat" or "log" so that i can follow the Email conversations for each and every client in my database. There will be multiple users and they will all be using Gmail. Really really grateful for any help I can get. Thanks Freddy

I'll try to describe my problem as detailed as possible... I got 2 tables. Clients and Products. On the client layout i got a 3 dropdown lists "EmailProd1", "EmailProd2" and "EmailProd3" and they are getting their values from the Value List ProductList from the Product Field "ProductName" so that the dropdown list contains of all my products. I want a button now that sends an Email to the clients email and IN the email, it should write out the "PruductName" AND a short description from the Products field "ProductDesc" In the calculation, I said to write out "EmailProd1", "EmailProd2" and "EmailProd3" but how do I make it write out the 3 different descriptions on all of them? Please help... Thanks everyone!

First off, my Filemaker Pro "Skills"... I know how to create some relations, simple scripts and calculations but nothing advanced really... I got a database with several Layouts and Tables. 1 Layout and Table, Staff Management, is for adding staff and Database users. Then I have a layout and table, Client Management, in which I want to create 3 Value List based from the Staff Management In the Staff Management i got a field "Name" and a Checkbox "Department". The Checkbox gets its values from a Value List "Departments" and has the custom values: "Sales", "Marketing" and "Admin". Now, I want 3 different dropdown lists, Sales Rep:, Marketing Rep: and Admin Rep:, Containing the Names from the Staff Management field "Name" depending on if the values from the Checkbox list. Some Reps will be both Sales and Marketing, and some are both Sales and Admin, and so on, so every selection combination in the Checkbox "Department" must be considered... I'm very grateful if someone could help me out here or at least point me in the right direction. I posted this in the Script forum as well, I don't know what to use for this one... Thanks all! Great Forum! /Freddy Young

Okay, let me see if I can explain this simple and short. I'm not brand new to Filemaker Pro but I'm not very skilled ether. I know how to create some relations, simple scripts and calculations but nothing advanced really... I got a database with several Layouts and Tables. 1 Layout and Table, Staff Management, is for adding staff and Database users. Then I have a layout and table, Client Management, in which I want to create 3 Value List based from the Staff Management In the Staff Management i got a field "Name" and a Checkbox "Department". The Checkbox gets its values from a Value List "Departments" and has the custom values: "Sales", "Marketing" and "Admin". Now, I want 3 different dropdown lists, Sales Rep:, Marketing Rep and Admin Rep, Containing the Names from the Staff Management field "Name" depending on if the values from the Checkbox list. Some Reps will be both Sales and Marketing, and some are both Sales and Admin, and so on, so every selection combination in the Checkbox "Department" must be considered... How will I do this the easiest way? Is there any other easier way to do it than with a Checkbox like I have it now? I'm very grateful if someone could help me out here or at least point me in the right direction. If you got any questions, please ask and I'm sorry if my English skills might prevent me a bit when it comes to describing my problem. Thank all! Great Forum! /Freddy Young

Thanks everyone!!

Hi! I'm using Windows 7 and Filemaker Pro 10 Advanced. I'm having a field "Phone 1". This field is for local Mobile Numbers (10 digits) As someone enters a number XXXXXXXXXX, I want it to reformat automatically to XX XXXX XXXX. What kind of calculation do I need to do... I'm brand new to calculations... Thanks for all the help I can get! /Fred

Background: New to Filemaker pro, got the hold of the basics, but yet to learn the correct "Filemaker Language". Problem. I've been using the "contact management" template that comes with Filemaker Pro 10 Advanced. The "Notes function" creates a timestamp when the note is being made. It will print out "11/30/2009 2.23pm by FredYoung" The timestamp is made from a calculation: "Month ( Date_Created ) & " / " & Right ( Year ( Date_Created ) ; 2 ) & "By: " & UserName_Created" were "Date_Created" is a "Date-field" with Auto-Enter Creation Date. What I need is for the print out to be "DD/MM/YYYY 2.23pm by FredYoung" instead. To look on the entire function, just open the "contact management" template (or starter solution at it's called) that comes with Filemaker Pro 10 Advanced (Don't know if it comes as standard but I would guess so.) Is there maybe a way to change a setting in Filemaker Pro to change "standard date display"? I haven't manage to find it... Or do I need to do a new/change calculation? Some help or a point in the right direction, please? Thanks

It worked! I got it working! Thank you a million times! I've been sitting for 12 hours trying to figure this out and I was as simple as that! Thank you!

My background: I'm brand new to Filemaker Pro and I just got version 10 from my boss. I'm know HTML and Java but don't know to much about databases. I been playing around now for about 3 days, starting to get the very basics. My question: Database1.fp7 got 3 fields, (Name, Number, Street). Database2.fp7 got a scroll down list, where i manage to list all the "Name" from Database1. How do I make the "Number" and "Street" to automatic come in to Database2 from Database1 from the right record depending on what "Name" i pick in the scroll down list? I don't know if I need to do a relation or calculation or whatever is needed, can someone help me or at least point me in the right direction?

My background: I'm brand new to Filemaker Pro and I just got version 10 from my boss. I'm know HTML and Java but don't know to much about databases. I been playing around now for about 3 days, starting to get the very basics. I'm running it on windows 7. My Problem: I Used the Contact Management template to create a customer registration database and a Hotel List Database. I changed the values so they would fit for my use. Now, in the customer registration database, I've got "current_hotel" and "Hotel_number" as scroll down lists. I manage to link the "current_hotel" to my second database, hotel list, to display all "Hotel_name_sort1" as the options for this list (all hotels i add to the database). But I also want the "hotel_number" in the customer database change to the "hotel_phone1" from the hotel list database at the same time. i.e If i select Hilton in my customer database it should also change the "Hotel_number" to what is written in the "hotel_phone1" in the hotel list database. Hope you understand what I mean and would be very glad for any help I can get. Thank you! /Fred Young