Calculation Engine (Define Fields)

does anyone know how to build a calc that can go into a field and automatically extract the area code then paste the area code and phone number into seperate fields? Thanks in advance...

Does anyone know if it is possible to combine a text field *and* a container field formula into a single field via a calculation?

I understand that container fields are basically holding areas for lots of things. What I have is a database of members in an organization. What I would like to do is to create a membership ceftificate and be able to populate it with the member number, name, etc from the database. Is this possible using the container field to hold the graphic file (or Word file, whatever I use to create the membership certificate.) TIA for you assistance, Roger

I may have posted in the wrong forum, so please forgive me. In any case I have a prospective membership database of over 3000 entries, with over 100 members registered in an organization. I would like to create a membership certificate to be printed from info in the FMP database. I would like to be able to open the database, "Find" the members, click on a link (or??) and have the information (name, membership number) be filled in from the "Find", then printed. Is this possible using a container field, and if so, how?

Hi, I am working on a solution that will be shared by 9 users. I created one table called Users. Each record in this table will handle all temporary data, like layout name, IDs from other tables, etc. Next, I set up relationships to all other tables to filter information or to create records. This way every user will have his/her own "globals". My problem is that I don't have a network to test what I am doing and this is my first shared solution. So I don't know if it is better to use Global Fields or to do what I am doing at this moment. Thanks for any feedback

Does anyone know of or have a function that converts a date to a calendar quarter, e.g., 1/1/2004 to "First Quarter"? Thank you.

Hello to all this is my first time to erery thing lol Need info about this I have i'm my db a field how is a phonenumber (number ) for user to place whem he fills the record the problem is that I have almoust 250 record's , and specially the are repeated , and wich to know how can I avoid that kindo of situation and make a script to permits the user , whem he's filling the form to check the phone number or name or SSN and if exist make a box to tell the user that the person allready exist's and don't save if ot fill's the form and save the record Please help me , I'm really a newby on this thanks neomag ps. sorry about the english

I'm trying to create a simple If statement for a membership database. I want to use a simple calculation like this: If ( ExpirationDate < TODAY ; "expired" ; "active") but I can't figure out how to substitute the current date for TODAY. What's the simplest solution? (I've been using FMPro for years (since version 3) but I've never really done anything with date calculations.) TIA

I have a statement in a calculation that says "SchSlots_StartTime::Location Code" What does the : mean in this statement. I am trying to have this bring about a different result and without any idea what :: means it is not possible.

Most likely I'm a novice FMP user and I need some basic help. I've searched the forum for my exact question and I've seen some pretty close but not close enough for me to understand completely. So here goes... I am using file numbers to keep track of my employees (I have an employment agency so I am always adding people to my data base). I don't know how to get FMP7 to sequentially auto enter the next number.. ie: 4056, 4057, 4058, 4059 etc. I know how to get FMP to add 1 to the value number you select such as 4056 + 1. But if the person entering the data has to delete the file for some reason, then the upon adding the next file... instead of 4056 + 1 = 4057, the…

I've created a Number field called Record_Number that's an auto-enter calculation, [Get (RecordNumber)]. As I create new records it jives perfectly with the Record Number shown in the Status Bar area, as it should. The problem is that if I delete a record, let's say record #1 out of 5 records-found, the Record_Number field won't update to jive with the Record Number shown in the Status Bar, even after a new Found Set is created. How can I make this field Record_Number always reflect the number shown in the Status Bar? Thanks!

Hi. How do I define a field that totals the fields in the latest (newest) of multiple records? For example, say I have several records for each of account numbers 1, 2, 3 and 4. Under each account number, I have salesmen A, B and C. What I need, is a total of salesman A's commissions, for example, but only in the latest records that he shows up in. So if salesman A is in records with account numbers 1,2, and 4, then I need the total of his commissions in the latest of those records. I guess the thing I'm missing is the command that says to look for something in the latest record it shows up in. Thanks in advance.

Hi. I have a calculation field, and when data is not available, it returns a question mark. How do I tell FMP to leave the field blank, when there is insufficient data to make that calc? I tried turning it into a number field, and lookup the calc. That allows me to manually delete the question mark out of the field, but that doesn't seem like the best solution to me. Any help is appreciate. Thanks! -Emery

hi y'all! at the risk of posting in the wrong forum and of posting a rather naive question at that - here goes. i have a text field which has many references to many images i have on file (jpegs) is there a way to make a key word in the text field a hyper link to a particular image which is sitting somewhere in the database? and can this image be made to pop up in a container which sits right alongside the text field? thanx in advance! edgaroso

Ok I am need to know how do I find the window that has the script that actually will allow me to change the Fricking global container fields. I have read almost every script in this DB and cannot find where the graphic is being referenced from. So I can change it.

Hi- I created a huge db in FM7PRO on a Mac OSX 10.3.5 and I inserted many pics (three containers per record, over 200 records). Unaware of this, I didn't make the pics format "compatible" -whatever that was- with both platforms (Win and Mac). So now I found that some users work on PC and of course I want to make the db compatible on both platforms. When users open the db on a Mac, it works fine but when on a windows PC, all pics (actually most of them) on the containers show text saying something like "a QuickTime application and TIFF decompressor is needed to view this picture". Some very few pics work. Now, I suppose I should have used JPG pics or s…

Does anyone know a field calculation which will be true/1 if and only if the record on which it resides is the current record? This would be a single-user file. - - - Why? This is part of a remarkably convoluted approach to getting MS Word to create a form letter using the current record for its merge fields. A Word form letter template can pull data from FM, but only supports the ability to select the record(s) by a <field>=<constant> criterion, where <constant> is bound manually at the time the template is created. Thanks for your consideration, Chap

I have this file, but can

From one of my workers, When inserting a picture into a container, it shows up on the screen (browse mode), hwoever when I go to print the layout, the picture does not show up. I have looked at this record. I see that the picture was there on the screen in browse mode, however when I go to preview mode, the picture is not there. The first place I checked was the Sliding/Printing rules to make sure that the picture was allowed to print. It was. so I go back to preview mode and it still does not show. Any other ideas where I should look??? Thanks

Hi, I have a drop down list of about 5 options.... how do I make it so that if the user chooses a certain option... option a, then the other field (money) will automatically be set to zero and cannot be changed? I tried going through validation but I may be misunderstanding that because it seems that it only validates that field on specified criteria, not based on another field. Thanks.. VANDY

I have a startup screen which I use to display the time and date etc while the database is opening all the files. What I want to do is have a field which can calculate if anyone in the database has a birthday = todays date and simply count a number? Any ideas on this? Thanks

Hi, new here but I've been using fm for 3 months now. I need help. Request: Each time someone adds a comment to a comment field, it inserts their new comment at the beginning and also puts current date in blue first, like: 9-4-04: new sentence here. Previous comment text. Also, that it only keeps 5 comments then drops the oldest each time a new is added. They don't want a portal, just one field. Here is what I've done so far, but I'm stuck: Script attached to Comment field with Set Selection [ Start:0, End:0 ] I'm not concerned about it not activating when tabbed to ... the layout is such that most are radio, checkbox and popup and they would need to …

Hi I have a field that contains a radio button value list ("Color", "Black and White"). How would I calculate the number of times either one of these items are selected in the database and place the result in the header area of a columnar list/report layout. Thanks in advance. Dave

How would I go about doing this? What I want to do is have 3 fields (Type, Skew, ID). The "Type" field is a pop-up window with the words (clothes, food, household) in the window. The Skew window is a number that I type in. I know how to do everything above. What I don't know how to do is this Example: When the "Type" field is clicked on and household is selected the letters "hh-" show up in the "ID" field, and when I type in the "skew" field, the skew numbers show up in the "ID" field after the letters that are already there. ie. hh-123456 Hopefully someone knows how to do this. Heathbo

In a Time Clock Function we calculate overtime hours in a subsummary sorted by week. When we have a date range that includes multiple weeks we can not figure out how to sum the overtime hours from more than one week. How do you sum up calculated values that appear in a subsummary part. [color:"black"]

I just upgraded my very simple photo database to FMP7 mainly for the increased file size. I have a script to import photos (2 per record) that used to open a Choose File box and show a preview of whichever image I selected. Now it just shows me the generic jpeg image for each file. Since the photos are directional (ie, right and left orientation), I really need to be able to see what the picture is before I insert it intot he container field. The Finder does appropriately show the preview. How can I restore this basic function that FMP6 had? Thanks, Dave

This is an offshoot of another thread.... Average() gives you a Mean average. There is no function for Median or Mode averages. I've sorta thought of ways -- though I haven't gotten to execution yet -- to get each of these by setting up relationships, sorting them, counting them, using the mod() function, other calcs, etc. But this wouldn't be a clean as just typing Median(var). So before I do need this... Has anyone actually done this already? Has anyone come up with a custom function for this? Why wouldn't this be a standard function anyway? Thanks, Dan

Hey guys, I'm relatively new to Filemaker, so I'd greatly appreciate any help: I have a table called 'Articles' with about 2000 records of publications with a field that contains addresses. Those addresses have within them the country name, although not always in the same place. I also have another table with the names of every country. I would like to be able to perform a count of the Articles that were written in each country. (Eg: 'Canada = 13 articles, Ireland = 4 articles and so on) by seeing if any of the countries in the 'Countries' table is a match anywhere in the address field for all the 'Article' table records. Could anyone point me in the right dir…

Hello All, I have a DB of around 10k records. One of the fields, "company", has 10k entries, with say 5k unique entries. For each record there is a count field that gives the total no. companies for the particular company in that record. for example: record 1 has company "IBM", the count field gives 25 as there are a total of 25 IBMs in the DB. I want to create twenty new fields: Company#1, Company#2.....Company#10 CompanyCount#1, CompanyCount#2......CompanyCount#10 Is there anyway I can populate these fields with the top ten company names together with their counts. Any suggestions/comments appreciated. CHEERS

Is there a manner to which multiple pdf files stored in individual container fields could be automatically printed via a script? We are attaching pdf images of our products to our invoice database so that we can quickly find and print an image if necessary. But I think it would be nice if the database gave you the option to view and print all the pdf files which relate to the invoice you are producing in a single step. Is a container field the proper way to go about this. Or are there any plug-ins which may perform this type of activity? Thanks!!

Let's say I have 10 number fields in each record. I would like to create a field that counts how many times a value over 400 (for example) has been entered in those 10 number fields. So if 2 of them are over 400 and the other 8 under, I would get a value of 2 in this new field. Any help is much appreciated. I am still a beginner with this software.

Hello, I am creating a book search solution for kiosk mode- which means that none of the toolbars will show in the layouts. I have a search function for a user to locate book records. Each search will bring a user to a layout listing all of the books for a certain author for instance. I would like to have a field at the top of the page that says "your search returned [x amount] of results". I am unsure how to create a field that will calculate the number of records found and display it. Any help appreciated! Catherine

I have a text field containing some numbers seperated by carriage returns (so they are displayed as a column). Now my question is how can i format a text string to a number. For example 12356,00 should be Eurosign 12.356,00 So what i actually want is to have the number formating as standard in filemaker used on my text field. Is this possible? Thanks Jitse

is it possible to validate emails on a certain field on filemaker 5.5? ex: when user enters email address 1. enter on a certain field: hello@example,com user enters invalid char "," would it be able to correct or prompt the error?

I have about 1,000 records with one container in each with a .jpg picture. The jpg pictures are in the range of 10-80 kb, but once they are inserted into filemaker (via insert... picture...) they grow to around 600-1000 kb. What is going on and is there an easy fix? I'd rather not go back and reference (link) each picture individually and shouldn't have to given the small size of each photo. I've tried compressing and cloning/reimporting. Thanks- any help is much appreciated!

I have a field that is an auto-enter calculation. When I create a new record, it automatically calculates it. The problem is that the calculation is based on info that will be added to the record. How can make sure that the calculation gets fired again? Thanks! John

Hi This may be asking too much... :-) I would like to be able to somehow find out what has changed in a particular filemaker database over a period of time, for example one day (assuming the field definitions have remained unchanged) I know I can set each record to contain a "date last modified" field, but this does not tell me which aspects of that record have changed. Is there any way of doing this short of doing a full export and comparing the csv files ? Thank you ! Daniel

Hi can someone help us with this problem. My friend she has written a calculation which calulates how old was the kid when he/she joined the program. i.e 10 yrs 7 months and 3 days. all calculations work fine till filemaker encounters someone less then 10 yrs. filemaker goes haywire. what are we doing wrong, or is it a bug in filemaker? Thanks

All, I'm having trouble with an FMP6 database. The machine hosting the file crashed. When we opend the database, FMP complained that it was inconsistent, and made some repairs. The problem is that the value of a calculated field is empty, and we'd like to re-enter the value. We use the database to track document workflow. The field in question is the document number, which is generated when a new record is created. Can anyone help with this? Thanks, Chris

I am still a filemaker beginner. This is my first post so I hope this question is in the right place. My question is: Let's say I have 4000 records in a database. Is there a way to automatically fill one of the fields for all records with numbers that are chosen randomly and that have a specific range (for example 1 as minimum and 500 as maximum)? some kind of formula maybe? Any help is much appreciated

I have a field (label_heading) that I would like to fill with 3 other fields - first_name, middle and surname. I can copy and paste with a script, but it only shows the last copy and paste - the surname. I have also tried to make it (the label_heading field) a calculation, but it shows nothing. As in first_name& " "&middle&" "&surname. What am I doing wrong? Thanks in advance for your assistance, Roger

We are trying to create a field to calculate fiscal year of an existing date field. This is what we came up with: Case( Year(Date of Intake = "2004" and Month( Date of Intake >= "07" and Month(Date of Intake <= "12"))), "2005" , Year(Date of Intake = "2005" and Month( Date of Intake >= "01" and Month(Date of Intake <= "06"))), "2005" ,Year(Date of Intake = "2005" and Month( Date of Intake >= "07" and Month(Date of Intake <= "12"))), "2006" , Year(Date of Intake = "2006" and Month( Date of Intake >= "01" and Month(Date of Intake <= "06"))), "2006" ) Can anyone tell us what is wrong? Thanks!

I could use a little help because I just can't figure this one out. I have a file with about 300 records. In one layout I have a table of contents where I input the page number and everything is great. I switch to another layout showing the individual pages. I have the same page number field placed in the footer. In the browse mode the correct page number is shown, but when I switch to the preview mode the page number automaticly changes to page 2. Still correct on the table of contents as page 1 but the individual page shows page 2.

RE College of Fine Arts: I want to print all patrons who have contributed money to Art, Music and Theatre, but I don't want amounts to appear - rather an "x". I always appreciate your help. Maxwell Morlay

I designed an employee database that keeps track of sick days. After the completion of each month, all employees receive an additional 1.25 days. I have a number field called (days available) that contains all of the employees accumulated days. I want to automate this process and add 1.25 days to all of the employees (days available) based on the the P.C.'s internal clock. Can anyone help me with this process? Thank You Steve

I may be the biggest dummy around but... I have more problems getting the set field script to work. Are there some special rules which I am not aware of which aren't listed in the manuals and tutorials? I know I have to have a relation between tables to use it between two tables, but my calculation never ever gets placed in the field it's supposed to set! They are both number fields, no other relations, no other validation. This is driving me crazy!

Hi I have a database of 10,000 records. One of the fields is 'Profession', validated against a Value List of 30 professions. I want to create a field which automatically counts up how many records there are for each profession, and displays the number on each record. So it would show Joe Bloggs as Surveyor and then say '40' if there were 39 other surveyors. I'm a beginner at this, but should I be setting up a calculation field which uses the Count function, and if so, can anyone advise how I should define it, assuming the Profession field is called 'Profession'. Thanks. Philip

Hello all you Filemaker Guru's, (Something I am definetly ... NOT!) Ok, I am hoping someone can shed a little light into my brain here. I am making this database, what I want to do is get the value in the "new Balance" field to automatically be entered into the "balance" field when a new record is created. I have been racking my small brain with this all morning HELP HELP Thanks In advance. Jim

I have set a field to validate by calculation and it does not validate as soon as I tab out, but waits until I create a new record. Is ther a way to set it to validate as soo as you tab out of the field?

I have 168 fields that I have defined for one table that I would like to copy to another table, rather than keying them in again. Is this possible with Filemaker? With the programming language I primarily use, I can copy field definitions to another table, or I can export them to a text file, perform a search and replace, then import the definitions in to another table name. I don't see this functionality (Duplicate only seems to work on the same table). Also, can the same be done for scripts (can I cut and paste part of it into another script and/or do a search and replace on a text string)?

hi gang-have a question here regarding preferred method to do an autocalc in a date field when a new record is made. I have an incident report database for a venue client (stadium). They have 12 events per year. I would like the field "Incident Date" in the db to autocalc to the nearest but not greater than event date. I've tried using a nested if statement but results have been, well, weird. I can post the statement for scrutinizing but before I do that would like to throw this out there in case someone else had done this and used a different tack. The calculation is pretty long, which is probably part of the problem, and I'd like to avoid the eyestrain if possible…

What are the best steps to calculate percentile ranking in FileMaker? Thanks, Thomas

HI I was wondering if it is possible to do the following. I would like the text colour in one field (a text field) to change to a different colour based on the selection from a drop down menu in another field. The colour it changes to needs to be different depending on the selection made in the drop down menu ie, in drop down menu selection made is "A" colour in text field changes to red, "B" colour changes to green. Can this be done? If yes, how?

I was wondering if anyone knows of any resources that can help me code HTML into a FM Pro Calculation field so that I can have Jpeg images appear in my emails sent using FM Pro and an email script. I currently have the email script and calc working but it only sends text. Thanks

For my simplified example, I have a table with 56 fields for each record and another table with 2 fields for each record. The working copy will have other fields related to the volume of work done for each task. And each worker gets a new record each day. In the first table, The first field is the record identifier, like a worker name. All the rest are the data applicable to the identifier, like all their individual tasks. In the second table the first field will be the worker name and the second field will be a single task. Now I want to let the first table have the workers name and all their tasks. Then I want to let the second table to make a record…

How does one automatically do percentiles in FM? I'm dealing with a significant amount of data (up to 750 records and possibly 18 separate percentiles for each record). Also, to make matters more complicated, not every record in the file should be compared for all percentiles. Example: 2 sections of the same class, i want to compare student X's performance in section 1 with the rest of the student's in section 1, but not to any student's in section 2, and vice versa. Is this possible (considering the section constraint)? If not, how do i do it without the constraint?

I need to add an If statement within the following calculation that includes a date field in mm/dd/yyyy format to fall into the range for the final calculation: Currently, the field reads: If(Agency="ABC" and Gender = "Male", 1,0) or If (Agency="CDE" and Gender = "Male", 1,0) I need to add: If(Intake Date=07/01/2004...09/30/2004) in whatever format will work within this calculated field. I cannot process the report with the date criteria as a find script because the report must give date on a Quarter date range and a YTD date range. Or, should I just create a date calculator that assigns a number to each day of the year. And, if this is how I sh…

I figured I would ask the experts for help. I want to know how many months accumulate after a person registered for a particular course. I have two fields; 1) Registration = (date field) and 2) Total = (calculation field). I can make the calculation show the correct amount of days but not the months. I made the calacuation as follows: Status( CurrentDate) - Registration. The calculation result option was set to "number." I would appreciate all the help you could give me. Steve

Is there anyway to import a date from a text file and check and see if that date is greater than 90 days. I have an application and I want a shut off procedure that exits the program if the date text file they have is greater than 90 days. Does anyone have any ideas and the code if possible.

I have a database with 30 separate name fields that I need to combine into one repeating field (with each of the 30 names in a separate repetition). I can get to the point of setting the new repeating field as a calculation field that repeats and I can set each of the 30 separate fields to appear in the repeating field. The problem is that they all appear in the FIRST repetition. I'm obviously missing a calculation step that sends the next step to the next repetition. Or is this even possible? Can someone help?? I'm using FMPro 6 on Mac OSX. Thanks!

This is a real annoyance and one I haven't addressed before though I've wanted to. Am at that stage where I can start cleaning up annoyances. In main db layout, 4 fields can be tabbed to. Second to last one is field that requires somewhat frequent editing. After hitting enter to take in data from its value list, it naturally and properly tabs to next and last field in tabbed sequence. However, what is _not_ nice is how this last field automatically shows the value list; it unfurls downward. This is no good. Any way to stop that from happening? Once input, that last field rarely needs to be entered and, unfortunately, all the navigations buttons get obscured by…

okay, this is driving me nuts, this was working perfectly well previously! i have a field with the calculation last (last sub issue) last sub issue is a repeating field created by a calculation involving another repeating field, which in turn is looked up in another table from a date entered in a third repeating field (for anyone who could follow all that!). the lookup and calculations are all working, it is just the last, simplest bit - with the last function - that isnt. why would this happen, given it worked before? it must be something incredibly simple, but i cant think what it could be. the field with the last calculation is a non-repeating field, with the…

Hello, i have been trying to figure this out for a while now, hopefully someone can help me... I have 2 files, "import"fp5" & "members.fp5". Each file has the following Fields and values: Field Name: Member_Status Values: value list - choices: Active, Inactive, Suspended Field Name: DMA Values: value list - 001 New York, 002 Los Angeles, 003 Chicago, etc... What i am trying to do is create a calculation field in the "import.fp5" file that can tell me how many records in the "members.fp5" file have the same DMA as the current record in the "import.fp5" file BUT ALSO only have a status of "Active". I have built a relationship named "cou…

Hi all, This is probably a dumb question but I have a database that I created to streamline my bid process for video projects. The database is fairly large and I currently have more than 250 fields. This number will soon go up to about 350 separate fields. I have a few quick questions: 1)-- are there any tricks to finding out which fields are not being used at all (so I can toss them out). I have tried making the database report (I have FMPro 5.5 Dev). But that interface is SO horrible that I cant help but hope that there is a better way to find the unused fields. 2)--are there any tricks to better organize or group fields? (In a perfect world, you wou…

Ok. Boss wants list (portal?) of activities assigned to staff. He wants each staff to see their own and he can see them all. I need to combine 'concentrate?" several value lists (I think) into a left multiline thing that will relate only to those Activities. Staff needs to be able to select with checkbox Activity Type (may choose several), Importance (3 options), Status (active or done). I don't know whether to try filtered portal (using calc or global?) or a find and report. They kinda like portals best but I don't know how to create this complex join. Oh. And he wants to have a From and To date and, if the To is blank, it show one day in the From; otherwise show t…

I have a photo database that is a reference only type for the image. During the editing of the photos themselves sometimes the reference numbers are changed and a new photo of the previous number needs to be made. I detect no image records with a flag testing the image field with the isempty function. However when the reference is broken the image field is not empty. I tried testing the text content of the image field and it lists the path with no reference to the lack of the image being found. Does anyone know a way to detect when the referencecannot find the previously defined image? The message in the container field reads "The file cannot be found:xxxxxx.jpg". …

I have following fields in my database : [Price], [Price1], [Price2], [Price3], [Price4] and [Qty]. Here is my problem: If [Qty] is between 1 and 19, [Price] should display value from [Price1]. If [Qty] is between 20 and 40, [Price] should display value from [Price2]...etc. Sounds easy, but my mind is empty after too many attempts. Please help.

I have a field that needs to calculate the age of an employee based on their birth date and the current date. Current date - birth date = age. Is there a way to make a field that contains the current date AND stays current? I feel like I'm missing something. This should be so easy, yet it's puzzling me. Thanks, Tom

I'm a novice at creating formulas. I need to create a field that will calculate and add the largest five values from eight fields in eight separate tables. This value would be stored in a ninth table. Example below: Table 1 Field: Weight Value: 10 Table 2 Field: Weight Value: 8 ... Table 9 Field: Total of the Five Largest Weights from Table 1 thru Table 8 (Need field calcultion formula for this field) Any help would be appreciated, Scooter

many to many to many... (argh!) ? in my database i need to be able to assign multiple values to one field. its a situation where one person can be assigned multiple devices. and one device can be assigned to multiple people. i currently have a users database with a device id and a user database with a user id and both have proper relationships to link old records together. the trouble comes in when i am creating new device records and assigning them to a user. i guess i could make multiple device id fields for each user but the number varies from user to user. some might need 1 some might need 5. and having a bunch of extra fields makes things messy. …

Dumb question I am sure. If you have defined a summary field for use, lets call it Field A, but don't put it in a layout - is it calculated? I had guessed that summaries were only calculated when required for a layout, but I may be wrong... Thanks. -Dave

Hi! Asked before but no luck, so here we go again. Is it possible to calculate a date from the following three field: year, week (fiscal) and day type (1 to 7)? The other way around is no problem so it should work. But how (feeling dumb)? Thanks in advance!!!

I have a field that calculates the price of a product with 30% added on the cost; but I need the price automatically rounded off to the nearest .25 e.g: 4.50+30%=5.85 (i was looking for it to show= $6.00) e.g2: 4.75+30%=6.175 (i was looking for it to show=6.25) What do i put in the calculation to give me that answer? Thank you in advance

I am using modification date and not sure what triggers it. I thought that it would update a record every time the record was modified. It looks like it is updating the whole file and I don't know why. Ivan

I am stuck on validation. I have different values that should be checked by a calculation. For instance the values are: bread butter cheese flower The calc should check if these values are unique. So it should not be possible to add this value twice: bread butter cheese bread Does someone know how to fix this? Thank you so much!

I'm am helping a friend who runs a small "people" database. The admin girl who had experience with it has left , and they have no clue how do make changes to it. They have images of the people 90% of the images are stored in an "images" folder. the other 10 appear to be embedded. The photo appears next to the person information size, eyes e.tc. They would like to create a button which will open outlook mail and attach the displayed photo.(the same way as when you "send to>mail recipient">in windows. Does anyone know if this is possible? Also when they load scanned images in the database they do not resize. They can only see a portion of the image. Should it res…

Hi I am working at an auction. We have a VALUE LIST to indicate all the positions of the possible sales. A1- A200. We have another place where this list is used. A1-A200 - it is all those items registered. We use this now. If there is a check box selected next to the item - it means it is sold. But I need some way on the same field to show those entries which are registered. I wanted to change the color of those that were SOLD to green. (Just the text) But since we don't register to all slots ,I wanted to change the color of the text of those registered to brown. Is this possible? Stann

I am trying to create a field that automatically enter's a date 3 months prior to a field that contains a date. Example - Medication Y expires 12/30/2004, I want a field that automatically enters 9/30/2004.

Is it possible to capture what the last find was? For example, someone does a find in a particular field for the word "book" Is there a way to have another field record that and display the word "book" And can it be dynamic? In other words, it always keeps track of the last find performed. Larry

I want to build calculated field from a user input field that is a text field. Now this calcuated field is later used in a relation and a value list. How can i easily remove all of the word delimeters ( . , ;, etc etc) For example when the user fills in "monkey,car.house garden" i want it to be monkeycarhousegarden. Should i use mutiple subsititue statements. The other question is : where can i find the list of word delimiters ? Thanks Oh yes ; still working wih F 5.5

how do i go about creating a new field (FieldB) to count the number of times FieldA contains the number 5 over a sorted set of 20 of 60 records. basically i am not sure of the field type and the formula/funtions to use. i am sure this can be done, it seems so simple to do in theory but who knows. thanks.

Hi I've created an indexed calculation field which is dependant on (among other things) a date field and the Today function. However when the date changes, the calculation field does not automatically update. I assume this is because Filemaker Help says I have to first stop and restart the server each day for the Today function to update. Is there any way around this ? Thank you (and apologies if this is the wrong forum... this is my first post !)

I use global fields in a network filemaker solution and it turns out that if one user changes the contenet of an global field the change does not apear for other network users. Only if the change is made on the host/server, the change will last and apear for other users. What is wrong? All other fields works great over the network. I use FMP 6.04.

I am having difficulty getting a ValueListItems function to work when used in a Substitute function. With the name of the file I am working in being "billing.fp5" and the value list named "visit_or_procedure", I have tried: Substitute( ValueListItems( "billing",visit_or_procedure ), "

Hi, I get, through ValueListItems function, this result in list format: FP-01209-1629 FP-01209-1630 FP-01209-1631 FP-01209-1632 FP-01209-1633 FP-01209-1634 CE-01209-1632 CE-01209-1636 And I would like to change it to: FP-01209-1629-1630-1631-1632-1633-1634, CE-01209-1632-1636 or: FP-01209-1629,1630,1631,1632,1633,1634 / CE-01209-1632,1636 The structure of each code is as follows 12345678901234 FP-000-000-00 FP-0000-000-00 FP-00000-0000 FP-00000-00000 The FP can be CE, and the 0 are any number. The length is fixed in a record but changes from record to record. For Filemaker 6, please (I'm sure that 6…

Hello I have a value list and I have a question about it's use. It has numbers on it 1, 2,3,4, all the way to 200 If I select a value on it with check boxes. I would like that value to be transferred to another field called "Assignment" - Is that possible to do in any way. Thanks Stann

Is there any way to concatenate/combine the results in the same field in several records into a field in all of them? For instance, if I have three records with "A", "B" and "C" in each of their first text fields, can I set up a script or other mechanism which will put "A B C" in the second field in all three of those records? Thanks. D

In all of the examples I find with the case statement, you have one test and get one result. I need to changed the value of two fields per test. For instance: If the Month field is = "JAN", I want to assign a time that a location opens and closes (two separate fields). I have lots of fields that need to be assigned, so I don't want to break this up into multiple tests.

i have two fields field 1 = image ( this is a container that holds a jpg ) field 2 = imagename ( this is a field that holders the name of the image ) when i insert an image into field 1 i would like it to automatically add the file name into field 2. is this possible? i tried to mess around with Get(fileName) - but i am super new with FMP thanks mix

Hi I have a field named "LANE" and I want text to go in it in a certain format I can certainly do that. But is there any way- when the user clicks on the field by making the field into a button to change the color of the text ---- and if the user clicks back again it changes back to the original text color. So with each click It might go from Click =RED to Click again while it is red and change to GREEN and then next click would bring the text back to red and the next click after that would bring it back to green. etc Is there anyway to do this? Thanks for your answers and thought process ............. Stann

Hi, Is there any way or a plugin that allows to have a container field where the user can do basic drawing (e.g. lines, squares, etc.)? (OS X) My idea is to have that field (transparent) on top of another container field (picture) so the user can draw arrows on top of the picture that is behind ... can this be done with FMP? Thanks a lot in advance!

I hope I can explain this without making it sound more complicated than it really is. I want to set up a set of records with an Airbill number, shipping charges, and the order number that was shipped. My problem is that multiple orders ship in one package and I want to be able to divide the shipping charges by each of those orders. So, I'd like to have these fields: airbill_number order_number total_shipping_charges and some sort of calculation field that divides the total_shipping_charges by the number of order_numbers that share this airbill number. We will also have multiple airbill_numbers for each order_number (each with it's own record) s…

IN FM6 for OSX, does anyone know how to change the background and selection colors for pop-up lists and menus?

I am working on a photo directory. I currently have a database containing a family record (family picture, parent's names, address, phone number...). I am using a portal to enter the children's name to a related database. I want to be able to display the children's name (eldest to youngest if possible) in the master file for previewing and printing. The sub file contains the children's names, birth dates, email... based on . Any ideas on how to accomplish this?

This is kind of a newbie issue, but for some reason it's giving me more trouble than it should. Basically I have a relationship between two databases. For my own purposes, these fields hold a serial-key type number. Each database has the same field, called accession number, both are text fields, and my relationship is based on these two fields. In my master file, I have a serial number 1992.02.0008. I want this to find all records in the related file that BEGIN with those numbers, for instance 1992.02.0008A and 1992.02.0008B. It would seem to me that this would be fairly obvious, and Filemaker would do this without incident. However, it's not finding any related…

I need TixBought field to auto-enter an X if data was entered in Tix2002, Tix2003 and Tix2004. Thanks for your help. Maxwell Morlay

I have a script step that exports the images from a container. Works great. The images go to my folder but then I use Applescript to rename the files. When renaming the files with As I append the extension so other apps can open them. I was appending ",jpg" but then all of the sudden ImageReadya dn preview said the file format was wrong so I did some testing and found they were now PICT files. I do not know why they decided to change the format. The container fields are stored in FMP. Is there a way to tell the format FMP will export?

Hi I would like my user to click on a field and have it change graphics from a look up I have a layout where the graphics reside. If they click again I would like it to change back The field is called "updown" So one click changes it and another click changes it back any suggestions are very appreciated Stan

All, I am making some modifications to an existing database to display images along with database records. There are thousands of images available, so individually dragging and dropping them is not an option. The filemaker database is running on my local machine, and the images are on a network server, located in folders that are keyed by an ID, which I have in the database. For instance, if i have a field "ID" in the database, I can be guaranteed that a network share "Z:" will have a folder with the same number as the ID, but the image may not be available. If i wanted to look at this image in windows explorer, I would view "Z:100-222picture.jpg". So, I am…

Hi. Does anyone know how to calculate the number of the record you are on, without doing a sort? For example, every record I create has an account number and date. So if I create a new record with account #101, for example, I need a counter that says "6", if this is the 6th record with account #101. Similarly, if I create another record, say #102, and that is the 3rd record with account number 102, then the counter should return "3" here. Any idea how I would do that? thanks! -Emery