Calculation Engine (Define Fields)

I need to place a logo and various graphic icons into FM 5. After placing the pictures into a container, they look sharp at 100% view. But when reducing the view to 75% or enlarging it to 150%, image quality is lost. What is the best way to import graphics (mac & windows) into FM5 while preserving image integrity when the page is reduced or enlarged? Thanks in advance for your advice

I have finally worked myself into complete brain inertia - much like the flat line of a heart monitor. I am trying to return a result from a caculated value to a unit of measure based upon a predefined UOM such as I want the result to be in LBS / OZ / Grams and fractions thereof where appropriate. There are several factors involved and I will try to explain: In a portal row of a master record (Master Formula Manager (1)) I am listing ingredients of a particular compound. These records are individual in my BOM Formulai (2) db. When the formula is complete, I receive a "Total Parts" calculated result (sum(BOM formulai:Qty). A batch size is predefined (in th…

Dear All, I have a text field but when people type in the text field, it must be like a number if not the number then it show a message. Like in that text field , we can have ..1230 but not 123-0. Is there a way to check it? Thanks

Hi there. I use IWP for my db's - as I have several users in different locations. I know that I can have a field for a record's "modified date" and also "modified by (user)". Is there a way to define a field that names WHICH FIELD was last modified?? Example: I could pull up a record and see a company's record was modified by "Joe" on "1/27/03" and "XYZ field" was modified. Is this possible?

I set up a database that keeps track of all the work I do and has all the standard fields... job number, client, date, fees, etc... To send out invoices every month, I've set up a button with a simple script to search by a range of dates as well as by the specific client and throw it into a list layout. This works fine. What I'd also like to do is be able to do is total the fees for that date range. When I define a field as a number and then have it auto-calc the sum of the fees, it only spits back the fees of one of the jobs that results from the find and doesn't add anything. I've set up a "Total Fees" field and a "Monthly Fees" field. I'd also like to be able to …

Hi, Is there a plug-in that would allow me to re-size a picture before I save it in an FM database? I am working on a ID badge app and would like the option of "zooming in" on a photo to have all employee faces about the same size. Thanks --Dan

[color:"green"] Can You Import Fields from one database into another?

is it possible to extract the first number from a text box by this i have a long list of water heater capacity which vary in content from '10 - 15 litres','<15 litres' 'and unpressurised 10 - 100 litres'. and i really need to sort by the capacity size, but this really does not work with it all being mixed with bits of text. what i would like is to be able to have a calc field that equals the first number it find in the text help Cheers

I have tried inserting jpeg and eps and both come up fuzzy or bitmapped, the vector images look poor and forget any text that might be in the graphic. I can't print my invoices with fuzzy logos, it looks very unprofesional. Any ideas? Thanks, Ryan

I have a system for registering sales and Sales People. Each Sales Person belongs to a Branch, and some Branches have Departments. I want to make sure that the Dept is entered for those who belong to Branches WITH Depts. On the other hand, I don't want the validation to be triggered when there are NO Depts for the particular Branch the Sales Person belongs to. Branches are kept in one file, Depts in another. I 've tried Validate by Calculation: Case(Count(bsg|fk_branch_id::pk_dept_id)>0, not(IsEmpty(fk_dept_id)), "") but it doesn't work. It keeps demanding that a value be entered in fk_dept_id even for those Sales People who belong to a Branch with no Depts registe…

Hi everyone!! I have four text fields which will accept a Diagnosis code. Example codes are 309.9 or V61.2. A Client can be assigned up to four different diagnosis. Currently, these four fields (field format pop-up list) are based upon a Value List (use values from field Diagnosis::Diagnosis Code, all values). I also have (in Field Defs) each DiagnosisCode field, set to validation by member of this same Diagnosis Value List. But I have a hitch There is an additional validation required and I'm unsure whether to re-do my Value Lists (and thus validation by Value List) to trap this issue; whether I should create a validate by calc through Field Defs; or incorp…

Hello, I am creating a hardware inventory for a college campus, I need to be able to associate OEMs with their products, both the type of product and the actual models they sell. Each of my fields would be a pull down list. Here is an example of what I would like to do: Field #1: Device Type: Desktop Computer, Laptop Computer, Laser Printer, Inkjet Printer, etc ... Now based on your selection from Field #1 I want different options to be available for Field #2. If you chose Desktop Computer then Field #2 will display only manufacturers of Desktop Computers, however, if you choose Laser Printer it will only display manufacturers of Laser Printers. Field …

Does anyone knows how to sort field in hebrew language ?

Hi everyone! I've implemented a Field Defs Validation calc to keep Users from accidently inserting

I have a validation I've created on more than two fields (thanks to an FMI tip) and it works great, but I would like the validation message to appear (or not appear) as soon as those two fields are filled in. Currently, it waits until I finish filling out the record and try to go on to another, which doesn't work too well (if people don't need to create another record, then they don't get the validation message). I put the DupeCheck field immediately after the two fields it's checking in the Tab order but got the same result. Any suggestions?

Hello, I would like to a automatically insert a value based on a value form a field. For example if Company name is Ford then customer # = 114. Any suggestions? I have messed around with the

I am working with a single-file contact list that we use to send mailings out to recipients. I would like to have two features that I am unsure how to implement. First, on the data entry page I want to have a running total that shows records for each city, displayed either by city name (mailAddressCity) or by zip code (mailAddressZip). Second, I need to establish a related file that shows who was sent what mailings (i.e., initial letter, version 1 sent to cities x, y, z, and initial letter with flyer sent to cities d, g, h. The letters currently are forms within the contact file. Is this the best architecture, or do I need to create a seperate file that has jus…

I can't get these result shown and this is very very very irritating. I wan't to see for a set of records in my Line Item (children) attached to one customer order (parent) the number of different vendors. For the moment, using self realtionships, all I reached to do is : - Having the total number of lines for Customer Order # X - not useful ! - Having the number of duplicates (shown for each lines) - i.e. Line N

Howdy. I am importing a string that looks like 20030122070000. I want the string to remain exactly as it appears here. FM seems to insist that it needs to be a date and consequently turns it into January 22, 2003 07:00:00 am. I have tried number and text data types and selected the box that says "leave data as entered" to no avail. Can anyone tell me how to get FM to leave this string in the string o' numbers format instead of the January.. format? Many thanks, Paul

I am new to filemaker 6 and scripting for that matter. This has to be an easy problem to fix (I am so defeated that I haven't figured this out!) Problem: After importing from MS Excel my book of Annuity customers. I have a number field named "Invested" -> I want create a field that will take all of these sale amounts (about 625 of them) and add them up in a running total field to track all of my sales. I tried to created a calculation field called "Total Sales" and did this: Sum(Invested) This obviously doesn't work - any suggestions... eric2k

I need to have a field (text and background) formatted based on the condition in the cell. For example if the value in the cell is greater than "x", the text should turn blue, if the value in the cell is less than "y" the text should turn red. Any help is much appreciated.

A coworker came to with this problem: He has a database where a user is entering in a dollar amount. He wants to format that field to have 2 decimal places and have a leading C$ to denote canadian dollars. He would like the user to only have to enter in the number and not have to enter in the extra decimal places if the amount is a whole dollar. So this is what he wants: User Entered amount: 24 Auto formatted amount: C$24.00 I can't seem to get it to work correctly with a calculation field. We did think of a way to script it but it seems messy. We thought we could do a pattern count on the user entered amount and look for a decimal point. If we find…

Hi there, I've made a database template with some global fields in the header. My problem is that when the database is hosted, any data I enter into those fields is lost when the file is closed and then opened again. The simple solution (or so I thought), was to change the field from global to just a normal text field. The only thing is that now, the header will go blank whenever I select a different record (hence, I'm guessing the reason for global in the first place). Is there any way of having a global field and still be able to save the data after the database has been hosted? Help!!!

I have a field for "units sold" and when there is a cancelation I simply put a negative number relative to the amount of the cancelation. What i need to do is have SUM(units sold) calculate only positive units and then another field with SUM(units sold) and add all the negative units... this way i get a total of cancelations and a total of sales seperately...is this posible?

Hello. I have a long formated text (with bold, italic...) in a non-editable text field (the help screen). So the scroll bar is locked. The solution is to create a calculated field with the text field as source (as seen in this forum). Good Idea, but in practice I loose the formating of my text. Can someone help me please !!

How do you purge duplicate values with a field? For example: We are holding a tradeshow in Los Angeles next month and there are duplicate registrations, email addresses, etc. First, in the short run, I need to send out a thank you letter with some of the last minute show add-ons, etc., and I don't want to send out more than one to the attendees. So a simple purge duplicates on the email field would be appreciated. Know of one??? Secondly, the MySQL database that the guy set up for us allows duplicate records and so I'd really like to purge duplicate records without having to manually go through them all one by one by hand, there will be 3,000 or more good ones …

I have a file which lists drugs. One of the fields for each record is for the drug "class". I would like to be able to do a find on any of the classes. In order to select one value from possible entries in this field, I created a global field and set the field properties to make this a lookup list that contained the values in this field. The problem I have is when I place this field in the header of a form using list view, the field doesn't work. I've run into this problem in other settings where I can't get a global field to work in the header when a form is in list view. Could someone who has a better understanding of global fields comment on this problem?

From my first use of FM, I always defined an autoentered serial n

I've downloaded and studied the Phone_Format demo. My need is to format several data-entry fields for phone numbers so that no matter how the multiple data entry staff format values that they enter in these fields (i.e., with or without dashes, etc.), the entries will end up with the format (xxx) xxx-xxxx The demo provides options for formats. Can someone please provide an explanation of how to accomplish the above goal? BTW: I'm not a professional FMP programmer. Many thanks in advance and cheers!

There is a great big problem with the date formats. I don't know why but there are some date fields that sometimes when I save a file as clone and import new records these date fields turn up with a different date format and when I try to find a date period in this file using this date field the result doesn't have the correct dates. Is there some trick with the date fields when making a file copy (save as clone or save the current records). Luiza

I have a system for registering sales and Sales People. Each Sales Person belongs to a Branch, and some Branches have Departments. I want to make sure that the Dept is entered for those who belong to Branches WITH Depts. On the other hand, I don't want the validation to be triggered when there are NO Depts for the particular Branch the Sales Person belongs to. Branches are kept in one file, Depts in another. I 've tried Validate by Calculation: Case(Count(bsg|fk_branch_id::pk_dept_id)>0, not(IsEmpty(fk_dept_id)), "") but it doesn't work. It keeps demanding that a value be entered in fk_dept_id even for those Sales People who belong to a Branch with no D…

I want to create a relationship from File A to File B, based on the result of a calculation in File A. The problem is that this calculation cannot be indexed because it is a Case calc based on the result of another Case using a selfjoin : c_Activity = Case (selfjoin = 1;No stock,Stock Available). c_Relation2key = Case (c_Activity = No Stock;"",Product_ID) As this record is based on a self join, I want this record to be updated in all the lines of my line items where the Product_ID is used. I Did read the article on indexing not indexable field but cannot imagine how to make it work on my file. Please help...

If I put a global in a db with only one record... will multiple users be able to modify that global at the same time? I know the values of globals are unique to each user, but will it allow two people to modify it when they're on the same record?

I can't seem to get any compressed files to display when they are an inserted object....this seems strange. (They must be inserted in the record.) I need to allow the user to edit the image--therefore, insert object is required. Is this normal? Is there any way to have the inserted object display. Please help. Each record needs to have such an image. So, if the images must be bmp files to work, the database will be very large.

Hi! using FileMaker 5. I need to figure out a simple "expiration date" I have a DealDate field (xx/xx/xxxx date format), a TermsInMonths field (number format) and need a calculation that shows the date the terms expire. For example, if the DealDate is 1/13/2003, and the Terms field is 18, the result should say 7/13/2004. What's the simple way to do this? (I tend to overlook the obvious and make it way too complex! heh) Thanks for any help!

Who can help me with this? I couldn't find a solution at FMForums... I like to have a calculationfield that makes initials from a text field 'company'. Example: 'Daily Times' becomes 'DT" or 'Super Market' becomes 'SM'. I tried First(company,1) & RightWords(company,1), but that gives me the whole second word...

Is there a way to calculate how many lines of text there is in a field Thank you

Hi All, Does anyone know of a method of increasing the cursor thickness which appears in a FM field thereby making it easier to see which field is 'active'. I am able to do this under "accessibility options" in the windows control panel , which works fine until one opens FM. The cursor appears to be encoded within FM.exe. Any suggestions would be appreciated. TIA Paul

Is there anyway to hide one field on a layout, so only the administrator of the file can see it? I need to add a password to a very public inhouse database, but I don't want the whole building to see the actual password. If I use the security file and limit their access to this field....does it also not allow them to see what's in it? Any help would be appreciated.......thanks! Donna

This is going to be tough to explain, but here it goes... I'm working on a system for tracking music performances for several artists. Among others, I have the following files: 1. artists 2. performances (by the artists) 3. songs (a pool for each artist) 4. setlists (a subset of the pool of songs by an artist from a specific performance) My question involves the use of recordID numbers. Songs are linked to artists by an artistID, but also have a unique ID. I then concatenate these two ID into yet another (unsightly long) ID which I want to use for portal filtering later. To get all these IDs right, I'm scripting the creation of songs records from a portal i…

Hi, I've written a solution for a publishing company for storing and managing an Image DB. Situation is: WE have all images (23,000 +), in high-res and low-res and they are stored on our raidsystems etc. WE upload the low-res thumbs to our webservers. THEY insert image data (filename, comments, size etc) and a cField creates the correct path to the image. Thats all working fine. but now this: I've written a complete workflow solution for managing images and editorial stuff, aswell as lay-out setups, colorcharts for pages etc... al working fine too. The managing sulotion however checks for available images in the Image DB and sets a flag (either …

I have several fields. Main one being "Date of Accident" calculated from this are various "milestones". E.g Milestone 1 = Date of Accident + 91 (being three months) Milestone 2 = milestone 1 + 185 (being six months) etc etc 1st Question is this the best way to add set time frames onto a user field?? 2nd Question If Instructions were received Up to and including 30 June 2001 i need to add 30 days, if received on or after 1 July 2001 i need to add 14 days. DateInstruction + If( DateInstruction >= "01/07/2001", 14 , 30 ) but it doesn't work... it just adds 14 whether it be post or prior to 1/7/2001???

I

Hi. I'm relatively new to Filemaker. I've been racking my brains on this one: I've created a database for the thousands of sound effects we have here at our audio facility. Each sound suite needs to be able to preview/download various sound-effect wav files across our LAN. At the moment, I've installed FMP5.5 on another computer on the network, and it can play the wavs (they are stored as linked objects, with the real files on a firewire drive). But when you right-click and select 'edit linked sound', it opens Windows sound recorder. Not good. I need to be able to open that wav in a pre-determined programme ie. Cool Edit or Sound Forge etc., or better still…

Hi all I want to know if there is a validation of a field ( not empty) depend on other field if Yes Or No. For Example Field A = Yes then Field B must not be empty and strict, it means they have to type something in filed B. I check by Validation by Calculation but doest not work for not-empty validation. Thanks

I have a telephone call log style database which contains the following fields: Log Date Log Time Close Date Close Time I already use a number of calculation fields to give me how many hrs/mins/secs a call was open for (calculated upon entry of the Close Date & Time). This works fine, but my next step is to calculate the number of 'Working Hours/Mins & Secs' (Between the Log Date/Time and Close Date/Time) a call has been open for based upon a 9 - 5 working day. Some calls stay open for a few minutes, others can be several days. Where do I start with this one!! ?

hi, I'm using Filemaker pro 5.5 I wanted to define field that would accept a non-gregorian date (its Arabic Hijri date). I have set the date on my system as the hijri date , but I still cant make filemaker's STATUS(CURRENTDATE) function to return the date in hijri . it returns it in Gregorian format. I need to do some calculaiotns using these dates. Is there a way of making filemaker use non-gregorian date or does it support only gregorian dates? Thanks

Hi, I am creating my first FM Pro database, but I am kind of stuck. Here is a basic overview of a file. The file has two fields, Film Name and Year. I want to create a report that will list each film and its year, and then place a delete button next to it that will give me the option of deleting the film. I have been able to create a report (using the wizard) that has the films and year, but I just cannot set up that darn button. I can draw one out in Layout mode and give it some properties, but it just will not appear in Browse mode. Can anyone give me some advice on how I can do this? Thanks.

hi, all ! what is the recomanded default option for store compatible graphic ? ( specially if i'm not going for cross platform. ) also i heard by turning it on and off could yield a different result in file size. is this true ? if it is true , which option should i go for ? another words which option will not give me a file size problems later ? regards, kyle

Is it possible to specify the maximum character count of a text field in FM Pro 5.0 v3? Thank you. Scott Miller

Is 'tab' the only way through fields in browse mode? We can't assign 'Enter' for this? Also I'm trying to find what other databases would call input masks, but can't see it anywhere. Is it called something different in FM, or not there??? Thanks again, Glenn

Is it possible to have both ? To simplify things, lets say I have C = A + B. If I enter A and B, C is calculated. However, sometimes, I have a C value, but no A and B, and I want to fill C myself. Since it is a calculated value, it won't allow me to edit it (even if I check allow entry). Anyway I could o this ?

This might be simple, but I'm just not getting it. (FMP v.6 Mac 9.2) I have a text field containing a series of page numbers to build a book index. There are often multiple instances of the same page number for a subject, and I want to have a field which I can later export that will not contain any duplicates. e.g., 3, 5, 5, 5, 6, 8, 10, 12, 12, 20, 30, 100 should become: 3, 5, 6, 8, 10, 12, 20, 30, 100 Any suggestions much appreciated! Kathleen

I need to create a list of the fieldnames in my database in the order that they export so that I can make a list that matches the export data to its fieldname. (EX: the 5th word in my tab delimited export file actually is the fieldname "whatever") I have created a fieldnames calc field, and in place of layout name, I have inserted "". This gives me the list of all the fields, but in their creation order OR: is their a way to export the fieldnames and not just the record data? Thanks in advance for any help!

How would I go about a calculation involving more than one test for an 'if' calculation. In other words, I need a calculation that in effect says: If(a=(b or c or d), e). The 'Case' function allows multiple scenarios, but the 'if' calc doesn't seem to. I don't see "else" or "elseif" type functions available except in scripts. With the 'Case' function, how do I create a Case statement where the test involves comparing two sets of information? eg: something like Case((field a = field b AND field c = field d), result). Your help and a lessening of my confused state is very much appreciated. Glenn

How do I edit the text on a button once it has been created? Glenn

I have 600 records that I've imported and the telephone numbers have no - in them. How do I add the dash into the phone number?

hi, all ! i happened to have a graphic which came from screen capture. i pasted it into fmp layout. now i like to find out whether this graphic is GIF OR JEPG. can somebody tell me what it is or how to find out :? thanks, kyle

I think this must be something simple but I'm not figuring it out. If I have a company name field, that obviously will have different companies in it, and I want a count of how many records belong to each company what do I do? Not simply a total either. There's a company number 001, 002, 003 and then the next number in the sequence would be 001-1, 001-2 etc as new records from each company are created. Summary fields may be the answer but I need the number to display and update as new records are inputed. It would need to be accurate in the browser view. It would be displayed on each record as a part of item number. Once displayed it shouldn't change.

I have imported about 1000 records from an Excel spreadsheet. One of the fields is CSZ (city state zip)...when the data came in, it was enclosed in quotation marks, which I don't want. I need to know 1 or both of these things: A. where did they come from? B. how do I get rid of them? I'm sure there is a script or combination of functions/calculations I could write to remove the first and last characters in the field, but nothing I've tried so far seems to work...There is some duplication, but not every CSZ is the same length, which complicates it for me... Any help would really save me a lot of piddly deleting... Thanks! Susan

I'm trying to include some buttons in the tab order on one layout. I don't find the way to do this. What I'm trying to do is like this: field1->field2->field3->Button1(enter) and with that button is a script that adds new record to a related file through a portal. Like you are on a web site and uses tab key then buttons get the status onFocus() Thanks, Reynir. Best regards from Iceland (one of the coolest place you can find, but not in the moment)

Dear All, I would like to know why I have a field used for look-up based on realtionship, when the record is deleted, the field related still got the the content of the original, the field is supposed to get 0 or blank. When the record is deleted, the look-up field can not get the data? is that right? ...but in my case it still gets the content even I used relook-up script? Anybody know why? Thanks Anh Tran

Hi, I am using repetitive fields to create an invoice. Say I have 10 repetitions of description and price. Description is a pop-up list using the description field from catalog.fp5, that way, I can simply click too choose the description I want, and price (from the invoice) looks up the associated price in catalog.fp5. If the description takes 2 lines, it will only show the first. Is there a way to force it to show all lines, even if it overlaps on the next description field ? Thanks !

I am trying to preserve text formatting for some form letters I am building into the database. However, I keep losing features such as "bold" everytime I create the final letter field thru a script. In the field I use the "set field" function. Any advice. I just want my final printable letter to have "bold" words without having to go revisit each letter and manually do it in browse mode.

Hi Everyone! I have two date fields representing a date range. I always enter a date in the FROM date field. I want the option of data-entering the TO date or have it *update daily* with the current date Status(CurrentDate) *if blank*. 80% of the time, this field will be blank. Would I need two fields - one Date field and one calc? I tried date field, auto-enter calc Status(CurrentDate) but it doesn't allow me to *do not store* so it will update daily (?). This TO date will be used in scripts so it must stay current. Or should I create a calc which *unstored* is: Case(IsEmpty(ToDate),Status(CurrentDate),ToDate) and always reference that in my scripts? …

hi all ! when i update old file with new one, if i import the old data to the clone of the updated file, people said i have to update the auto enter serial number. how is this a problem and what should i do to solve this problem ? and i heard i can solve this problem with fmp 5.5's get next serial number feature. if it is , can somebody show me the way ? so basically i like to know why this become a problem and how i can solve this problem on fmp5.0 and fmp 5.5. Thanks, kyle

This seems like a dumb question, but I thought I'd ask just in case there are some smart answers! If you're not going to be performing any mathematical computations on a field, but you expect it only to contain numbers (eg: Invoice Number)... are there any advantages to using a number or text field?

I hope someone can help with this date calculation.. I have a "Hire date" and I want to calculation how long an employee has been employeed by "days, weeks, months, and years." Thanks alot in advance, Linda

Don't you ever get sick of the pain white reports in filemaker... I found a way to make every other line have a background color.... (line1 = white, line2 = blue, line3 = white, line4 = blue, etc.) Create a container field named "color_1" Create another container field named "color_2" Create a calculatiuon field named "color_calc" with this for the calculation If(Mod(Status(CurrentRecordNumber), 2) = 0 , color_1 , color_2) now Cut and paste a color block into "color_1" and a different color into "color_2". Put the color_calc field behind the fields in your report layout and set the graphic format to "reduce or enlarge" and uncheck the "maintain or…

FM4 Mac Share investment file with a record for each transaction. Each record shows investment, costs, profit, etc., plus profit expressed as a simple annual interest rate, e.g. 250 dollars made on 1000 in 6 months would be shown as 50 percent Annual rate. Each record also shows the to date figures for all transactions via Summary fields. My problem is that I wish to show the average annual interest rate for all records to date BUT I don't want the rate to change on older records. For example if the third record shows a cumulative average for records 1 to 3 of 30 percent but the 4th record pushes this up to 50 percent, I want record 3 to still show 30 and 4 to …

Help! I must be overlooking something simple. I have a calculated field that shows the status of of

[color:"blue"] What [color:"red"] is [color:"blue"] a [color:"red"] "portal" [color:"blue"] field! [color:"red"] and [color:"blue"] what [color:"red"] is [color:"blue"] its [color:"red"] functions [color:"blue"] and [color:"red"] purposes.

Hello, I am creating a database solution which I want to run in Kiosk mode, using the full screen. At the moment it is being designed to run on 1024x768 screens but it will be modified later to work on all sizes. My graphics take advantage of the full screen area, and are exactly 1024x768 - I am working on an iBook which has a maximum of 1024x768 screen res and using FileMaker Developer 6 The problem is that when I create my kiosk mode DB for some reason FileMaker displays the kiosk mode version, but with scroll bars - so eating into my graphics and not displaying all of the screen. I don't want scroll bars, because my screen should fit exactly on the…

Was working through the audit trail solution in the book Advanced FileMaker Pro 5.5 by Bowers and Moyer. As some of you have noted in previous posts, if you follow the book it doesn't work but it does on the supplied CD file. The problem is that in the book (pg.88), the authors say that calculations will trigger before lookups, allowing time for a calculation (Audit_Current Text) to capture both the old and new values in the field. But it doesn't work if you constuct the fields as they suggest in the book as the capturing calculation is created AFTER the lookup has been created - hence only the new value is captured. If you go to the CD file which does work and in Define …

In these forums you can find numerous threads telling you how horrible it is to allow access via the OS to the files being served by FMS (because the OS will allow bad things to happen to the data). But these forums commonly recommend that you pull images out of the FMS database and stick them in directories accessible from anywhere on the network via the OS. But that leaves a portion of your database easily corruptible! There does not seem to be a *good* solution for serving up a database of photos (or other large field values). Please help me figure this out... First, ignoring other complicating factors for a moment, I'd like to understand the answer to thi…

Hi I use FM for a contact database and if I type in a persons name, their contact profile comes up - great! I would like to (somehow) be able to type a company name, and a drop down box of my contacts within that company appears so I can then make a further selection of the person. Currently, if I type in a company name, the first person on the sort list appears only. Hope you can assist many thanks in advance

Happy Holidays to everyone. Working on a contract database for a client and I'm having a problem with a deposit calculation. The way the system works is when a deposit is received for a contract, the date and amount are entered into two seperate fields. The agency gets a % of the deposit which is taken off the top, the rest going into an escrow account. I was able to set up a calc which compared the deposit to the agency's % and then split it accordingly into an agency % field and an escrow field. The problem I have is this. About 5% of the time, the agency will receive deposits in two shifts. There is a separate date and amount field for the instance of a second deposit.…

I am trying to reduce the size of a field according to the amount of text input to the field so that a report layout doesn't have so much blank space between fields. I have applied the slide/print function to the specific fields requiring various widths which works in the preview mode. How can I get this function to work in the Browse mode? Thanks, Scott

When I insert a bmp the object into a container on one PC the filename does not show. But when running the same file on a second PC (PCs are not networked I simply took a copy of the file) the filename displays under the image. I am not sure which setting to change. Any ideas?

I have a layout with a field and I have enabled scroll bar, but in brows mode the scroll bar are not visible if I don

I can't figure this out! and hope that y'all have a solution for this... I'm importing data from a .csv file into my FM database, so all the data is text formatted. Once I've done my importing, a date (date) shows the date as follows: 20010702. What I would like to have, is this text converted to a date format field and listed like this: 02-07-2001. Is this possible?

I have a few hundred records in a list view and I like to sum up all the numbers (in the money field) that have "Add" in a different textfield in the same record. I can imagine the calculation would be something like this: If (Type) = "Add" then SUM (money) Does this makes any sense?

I should be able to figure this one out, but my brain must be in holiday mode. Ok, heres the situation. My Prospects file is related to my Sources file. Long story short, I have a variety of calc fields in the Prospects file that return "1" if they evaluate to true. These 1s are counted in the Sources file. One field is called ApptSetDt (the date an appointment is set). I need to be able to count records created in the current month that have apppointment dates in the current month OR records created in the current month that have appointment dates in the next month. The calc I set up goes like this: ApptDtMonthCalc= If ((Month(ApptSetDt) = Month(Status…

Here is the scenario I have a field named "info_Package" and a field named "z_Calc" I need a calculation that will put the number "1" in the "z_Calc" field if the "info_Package" contains a "C" So if the field "info_Package" contains "ACL" i need a "1" in the 'z_Calc" field .... however if "info_Package" contains "AL" need "z_Calc" to have a "0" Here is the calculation i currently have and it doesn't work If(info_Package = "C", "1", "0")

If( PatternCount(info_Package,"C"), "32", "0") I now have a calculation that will give me any given number if the field(info_package) contains a "C". Lets just say that that number is "32" ... Does anyone know what calc I can use for the following problem I want it to double the number (32) if there are two "C"s in the field or triple of there are three of them Any Suggestions?

I am trying to create a prorated amount calculation based on a birth month and the month of an exam. Example: Birthday is 7/6/03 and the exam is 2/6/03. A difference of 5 months. That number is then multiplied by $14.58. I can't seem to get a calculation that will get the difference between the two dates and make it positive integer to multiple by the $14.58. Any suggestions? Thanks, Josef

Here is the scenario I have a field named "info_Package" and a field named "z_Calc" I need a calculation that will put a number that i can set in the calculation such as "34" in the "z_Calc" field if the "info_Package" contains a "C" So if the field "info_Package" contains "ACL" i need a "36" or a "27" (number that i can set in the calc) in the 'z_Calc" field .... however if "info_Package" contains "AL" need "z_Calc" to have a "0" Here is the calculation i currently have and it doesn't work If(info_Package = "C", "1", "0")

If Month Ref is janvier and Year Ref is 2002 then it should return de janvier de l'ann

I'm using John Osborne's visibility trick to hide a menu button when it's not applicable. I defined the field 'visibilityLodging' as a compound IF function -- if (attending? = "yes" and commute? = "stay", 1,""). The relationship is valid (visibilityLodging on the left; constant on the right) and the correct fields are in the correct portals. Can anybody tell me what I'm doing wrong? Does the visibility trick not work on a compound IF? Or (horrors!! ) have I defined my field wrong? It seems such a simple thing and I don't get any FM error message when I save my field definition. Feeling totally brain dead -- ti's been a long, hard day... I know tha…

I have a database that holds about 150 records. There is a repeating field that holds the stats for each of the 52 weeks of the year, that is to say that each record can be "Full", "Part", "On the road" and/or "Absent". These elements are in checkboxes. It's easy to calculate, as an example, how many times an employee has been "Full". That's OK for me. But how can I calculate how many employees has been "Full" for each Week without having to define a field for each week that would look like that FIELD1 --------- GetRepetition(Week, 1) Then creating another that will count the number of "Full" in the FIELD1 : FIELD2 --------- PatternCount (Fiel…

Got a bit stuck on this one. Probably easy but maybe someone can give this amateur a push in the right direction. Trying to get the calculation together for displaying zodiac based on field "birthdate". And this is aint the way: Case( Day("23") & Month("12") >= Day(birthdate) & Month(birthdate), "Steenbok", Day("23") & Month("11") >= Day(birthdate) & Month(birthdate), "Boogschutter" Etc.. ) Thanks in advance..

I have a solution where I will have 1 - 15 photos per record. When printed, each photo will take up 1/2 page, for a potential total of 7.5 pages. However, if I only have 2 photos, I don't want to print 7 pages of blank paper. I've tried sliding, portals, etc, but I haven't found a way to do this....any ideas?

I can't be the first to wonder about this, but I couldn't find a previous post... I would like to be able to play a sound stored in a global field from a script. Is this possible?

If I have two database files... Is there a way to copy fields (and it characteristics from the define fields) from one filemaker file to another (and have it added to the list of fields)

I am setting up a computer issues database so that our teachers can submit a problem via our intranet. i would like when they hit the "new record" button that the date field and the time field would auto-generate. as i have been trying to do this, i've used the Insert--Current Date and the Insert--Date Symbol. i also used the appropriate inserts for the time field. i have made sure that my fields are appropriately defined as date and time. i noticed when i used the time symbol, every time i review the record in FMP, it updates to the current time. when i use the Insert--Current Time, well, the record will show that exact time, but it doesn't show updated on th…

Hi, I have a text field that uses radio buttons and i want it to change colour depending on which radio button is selected. Does anyone know how to do this in fm6? Thanks

I've been fooling around with Erik F's Aqua graphics (thanks Erik!) as well as Joe O's over at layoutmode.com (thanks Joe!). I like the results so far, but was wondering if anyone knew of any available "brushed metal" graphics? I know some folks don't care for the brushed metal look but I kind of like it. Joe

I need to embed photos in each record. It is important that the images can be edited by paintshop or some other program....therefore, I have been attempting to use the insert object option. Everything works great when I use bitmap images. However, I would like to use jpg or gif files to minimize file size. Unfortunately, when I attempt to use jpg or gif images, filemaker only shows an icon and name of the image. I need the image to display as is the case with bmp files. Please help. I must embed these images in each record--therefore, file references will not work.

I've been using Filemaker Pro 6 for about 3 hours now, and finding out it is very easy to learn. However, I am trying to do an inventory of my home, and have multiple pictures of larger value items. Is there any way to have more than one picture for a single entry? I had placed several picture container fields, but when I fill one field, the others fill with the same image! Is there a way around this, or do I have to go into Photoshop and stitch a bunch of photos together for one big image?? Thanks!!! Shawn

Help I have a field that I want to extract the middle number using a calculation field. 3-5-4 ---> 5 or 10-10-7 ----> 10 the lenght of the numbers are not consistent but the dashes are there to separate the numbers.