Calculation Engine (Define Fields)

Hi. This is probably so easy, but i'm just boggled right now. I have 2 tables, one for daily input and one for totals. the first table have event name, event date, cost per day per department etc... the second table has profit and totals. the department total field in the totals table needs to calculate the sum from cost per day per department when the event name is the same (some events run multiple days so i need to calculate the total per event). what is the easiest way to do this?

I am having a brain blurb- how do I convert a time (x:xx) into a decimal? I have a calc field that shows the time elapsed between two dates/times in hours:minutes. I need to count how many records have a time of less than 1 hour, between 1 and 3 hours, and over 3 hours. Thnx!

Greetings. I cannot find a way how FMP will automatically udates a date at midnight. I guess the Get(CurrentDate) only sets the date when a new record is generated. If anybody knows a way, I would appreciate to learn about it. Many thanks Greg

Hello everyone I am a novice filemaker user, and am putting together a DB that allows me to select a file and place the reference in a container field, then I have a calculation field that tells me the file path, what I need is a way to get the path minus the filename. any ideas? I have got the path formatted almost completed to what I want except for the filename always appearing and since the filename will always change and there is no pattern I don't know how to just have the path to the folder containing the file. Thanks, would greatly appreciate anyones help

Hello there. I've got a bit of a puzzle, maybe somebody has been through this situation and can help me out. Because frankly, I am stumped. I've created a large database in Spanish. Within the database is an intricate sequence of Date Fields and Calculation Fields (for Dates), displayed by Filemaker default in English. Up until now, this little detail has been of little to no consequence. However, I now need to print out some Records, and they have to have the Dates displayed in Spanish. For example, I need a Calculation Field result to display: "Marzo 11, 2005" Instead of: "Marzo 11, 2005" Is there a way to change the language? Thank you!

I've got a large text field that I'm using to enter numbers, like this: 4 5 5 2 6 I'm using a text field because it's the only one that seems to let me enter multiple numbers like this. However, it doesn't seem possible to do a SUM on all the numbers in that single text field. Is there a different field type I should be using for input? Or is there a different function that will add the numbers up for me?

I have a text field which contains a code that is in the format of M followed by 5 numbers, which varies in position in the field and the actual numbers vary as well eg. M80410, M60234 etc. I want to make a calculation that extracts just that code from the rest of the text in that field. I tried using: Middle(text field;Position(text field;"M#####";1;1);6) Trying PatternCount (text field;"M#####") failed as well. I then realised that the the wildcard # for numbers (and wildcards in general) didn't work in calculations. I can't figure out how to tell the middle function to look for an M followed by 5 numbers in the text field. Thanks for any …

Hello, I am pretty new to filemaker and I am trying to create a function that depending on the date a Text Field is formatted with different colors, if the date has not come yet, green, the date is todays date, yellow, or the date has allready passed, red. Is there some way to do this easily?

When viewing mulitple records is it possable to have differnt color fields in separate record?

Hi, I am not sure if calculations is the right post for this, but here goes. I have a drop down field with some selections. I have another field which is a radio button field. You don't always need to make a radio button selection, but when you choose a certain selection from the drop down I want to make it a Requirement that you must not leave the radio field open. Example: Drop down field has Red, Blue, Green, Purple, Yellow, Orange Radio buttons have Florida, Georgia, Mississippi, South Carolina Most of the time you aren't required to choose a state, but if you happen to select Green in the first field, then you have to choose a correspondi…

I'm starting to the an IF statement isn't what I need, but I can't find an answer in the help file. Here's what I'm trying to do: Field1 is a pulldown menu with two values [Yes] and [No]. I want Field2 to pull data from one of two other fields (Field3 and Field4), based on the value of Field1. Here is what I wrote: For Field2, the calculation reads: If ( Field1 = Yes ; Field3 ; If ( Field1 = No ; Field4) ) When I try to save it, it tells me that the field (Yes) and (No) can't be found. So I'm confused. If I had numbers, like 1 and 2, instead of Yes and No, it would work just fine. Is there a better way to do accomplish what I'm trying to do?

Hello, When an user is typing in a text field it automatically displays a carriage return when the user reaches the end of the field. I have a portal that references a field like that. When you are in Filemaker it displays with the same carriage returns, but when veiwed through IWP, the carriage returns are gone, unless you click in the field. Is there a way to format a field through a calculation to parse it out, and insert the carriage returns where applicabale?

I am having a problem with a summary equation that i'm using. Here is the problem. I have a layout page that views all the orders i enter each day. It is in list mode so i can see a summary of each job. In the Footer I have a Summary field that gives me the total cost of the orders. Then i have another field (also in the footer) that allows me to add a volume discount to the orders, such as %2 discount on the total. I then have another field(caculation) that multiplies the total due * the discount. The problem i'm running into is that my final caculation changes according to which record is selected in the body of the layout. So if the first record is highlighted it giv…

Hello everyone.. I've got a text field in a FM 8 file that contains the path to a file, each record has a different filename and the filenames are different lengths an example of one is C:Documents and SettingsJohn DoeDesktopFolder ImagesDCP_3034.jpg I would like to create a new calc field that pulls just the name of the image. Is there an easy way of doing that? Thanks Cory

I setup an index field which get's the values from a field of each records field that I've called "Title". This lets me see the titles of all the records in a handy pull-down menu. What I'd like to do is add some sort of script so that when I select a title in this pull-down menu it takes me to that record. Any thoughts?

...without FileMaker Advanced, so I don't have access to Custom Functions. Is there a way to create a "while" loop in the calculation for fields? What I'm trying to do is this: one field in Table A is the Interface table, showing a portal of related records from Table B, which contains Names. I've figured out how to filter the portal by a pull-down of set values, but I also want to be able to filter the portal based on a text search field, so that users can search by last name, first name, etc. I've gotten it to work when users enter full names (first or last), but I need to now populate the matching field in names with partial strings of either name. For exampl…

Can someone explain the difference between ## and Status(CurrentPageNumber) I figured they'd return the same value but I've been testing things with both and they've been returning different values.

I have a calculation field = X - Y I have checked the box for: "do not evaluate if all reference fields are empty" However the field will still calculate if only one field is entered with a value. How can I stop the calc working if only one field is entered? Ben

Greetings. May I kindly ask somebody to point me into the right direction. I have been trying for hours to get a date calculation right. The situation is: a) my FMSA is located at the East Coast - US my client is in Sydney - Australia c) the time difference is +20 hours for Sydney I need a date calculation which sets the date to Sydney time when a new record is created. Output form must be timestamp. On the server I can use: Get ( CurrentHostTimeStamp ) which results as: 23.01.2007 19:31:13. Now I need to add the 20 hours which is: 24.01.2007 15:31:13. I tried so many different calculations which didn't work correctly. Another questio…

I'm a novice with Filemaker 5.5 on Windows XP Pro. I need to "TRIM" several text fields. I have created duplicate calculation (results in text) fields. The "TRIM" is not trimming. All I've done is make a nice duplicate of the original fields with the same problem, extra spaces to the left. I already have the field formatted to left justify. Most of the records were keyed in correctly but too many were keyed in with 1 or 2 spaces to the left of the field. Thanks in advance. ;)

I _know_ this is a dumb question,but I've spent a couple hours trying to do this, and I just can't figure it out: I have a list of about 38k records. Of these, there are about 200 unique values. How can I cut this list from 38K to ONLY those 200 unique values? I've tried a few different ways--setting up a portal then running a script, creating a "Counter" value, as suggested in the FM help, but it's not working. I am sure there is a simpler way of doing this! Thanks

I have an inventory DB, Tables are "Product","WholesaleProduct", "Invoice","Suppliers" and "Product Item Detail". When I create an invoice on the Invoice portal I have the fields Wholesale Product ID, Product Description and Product ID. The product ID is my number the wholesale product ID is the supplier number. I want to be able to enter either number & have the product description come up. I have created another field called Product Calculated Name to hold the formula Case ( Wholesaler Product ID>1 ;Product Description::Product Description;Product ID >1 ; Product Description::Product Description )The formula works when I enter the Product ID but it does not w…

I have no idea if this is possible but what I have been asked for is to color code the test scores of our students. For example students that score between 1-500 would be red, 501-800 blue, 801-1000 green. I have no idea how to go about this so if it is possible any help would be terrific.

Hi, I'm a beginner with FM7. I'm trying to make a simple printout-able monthly calendar. I don't see how to put 31 records on one layout... so I'm thinking of defining 31 different fields and putting each month on a record. Does anyone have any tips on how to define records so a starting date layed out on the day of the week of my choice (depending on where the 1st of the month is) will generate the rest of the dates for that month? Or is there a better way—there must be. Please keep it fairly simple, as I have only barely looked at scripting once ever. Thanks for any and all help, Doug

In my educational database I have to extract in a teachers point system how many points they earn depending on the years of employment and kind of schools. The mathematical type is: Date of the employment end-Date of the employment begin plus (x)points of the particular school (coeficient z) is like Date(end)-Date(begin)x (z)= The problem is to calculate the days that exist between dates. Then z will be translated easily to numbers and multiply. Any ideas please. I think that is interesting. Pascal

I inherited two interelated relationships from a former developer I can't figure out. For DB:Committees, we have an auxilliary DB:Members, which contains records for both the multiple members of each committee, but also the single chairman (sometimes there are 2 co-chairs). DB:Committees has field com_GetChair, a calculation = com_CommitteeYear & "Chair". DB:Members has mem_FindChair, also a calculation, indexed = mem_CommitteeYear & Right(mem_RoleOnCommittee, 5). (The two CommitteeYear fields are different calculations in each DB. com_CommitteeYear = Left(com_YearRange, 4) & " " & com_CommitteeCode. com_CommitteeCode is a text field wi…

Hello, I have designed some buttons and bars in illustrator, and my question is ... what is the best way to save them so as I can manipulate and use them in FileMaker. Thanks, Tom

Hello, I am working on a membership database and would like to create a field that shows memberships expiring within the next two months (Feb and March). I have an expiration data field formatted as date/yr. How do I make a field that shows the expiration date plus 2 months? Thanks, MT

I have a variety of number fields that are populated as a result of an AUTO ENTRY calculation. The results often times have a decimal somewhere in them. These fields are formatted to read as whole integers. 3.4 displays as 3 5.4 displays as 5 The sum of 3.3 + 5.3 currently displays as 9 I would like it to display as 8. (I would also like to have the mathematical result = 8) [color:red]Is there a way to make the values always round up or down at the half-point & present the result as a true integer? What I would like is: 5.4 = 5 5.6 = 6 5 + 6 = 11 Any ideas? Thanks, Jarvis

I'm doing a study of height & weights - and I'm trying to set up a calculation that compares differences of values in selected fields just among subsets of twins (I have 7 sets of twins in data set of 1100 records so far). I created separate fields for: a) Twin set number; twin set letter (a, : to specify each twin within the twin set, and finally 3) a concatenated field of twin set # &letter (so concant. field would have values like 1a, 1b, 2a, 2b, etc. for each individual twin). How do a set up the syntax for the case or whatever calculation to look for twins in same set - and subtract, for example, the weight fields between 1a & 1b; 2a & 2b, etc. - t…

Is it possible to set fields in such a way that if an entry is made the first word (name) automatically is written with an upper case letter? I am on FMP 6

How do you create a calculation in the parent table that will return you the value from a field in a particular portal row of a child portal. For instance I have record of Contacts and the phone numbers for those records are kept in a related table of Phone numbers. I can manipulate and reorganize the order the phone numbers appear in that table. What I would like to do is have two records in the parent Contact table. One field would be Primary Phone and it would pull via a calculation the Phone number from the first row of the Phone Number portal and Secondary Phone filed would pull the Phone Number from row two of the Phone Number Portal. Kind of the same way the G…

I can't seem to get this to work. A good example is having a conference affiliation automatically assigned to a University based on the date a game is played. Here is a sample of what I have for two schools. Case ( Team = “Univ. of Arkansas” and Date > 8/1/1992; “Southeastern Conference”; Team = “Univ. of Arkansas”; “Southwest Conference”; Team = “Florida International” and Date > 8/1/2005; “Sun Belt Conference”; “Not Division 1A”) Team and Date are the field names. However, the date part of the function doesn't seem to work. Any ideas?

Dear FileMaker Gurus: I have a FileMaker v.6 DB, hosted on v.5.5 Server. I was asked to create a new field, in the form of "Yes""No" Radio Button, default to "Yes." Yet! Users are allowed to check "No." How about the field definition? Calculation? Help! Please! Max NY

Dear FileMaker Guru: I was asked to revise a FileMaker v.6 Report Tracking DB, hosted on v.5.5 Server. On the "Entry" Layout, users can enter "projected" total page number to the "Page Count" Field. The value will be replicated to the "TotalPageNo" Field in the "Tracking" Layout, where all sorts of information of the report are monitored. Now, I have received a request: Create a new "Finalized Page Count" Field for the manager, only, to enter the "Finalized" total page number into. If the "Finalized Page Count" Field is empty, current replication stays. If the manager enters, in this field, an "final" number, which will updates and locks, beyond m…

Good morning, I have a field that returns a value but can not create a report from this field because there is an infinite number of possible returns and the "count of the records" is just of little value. So what I would like to do is in a seperate field use a calculation to state that if a number falls between X and Y then Z. My current case statements is as below. The problem is that it only evaluates the first expression. All records in the DB (if I use replace field contents) receives the value, 0 to -4 after running this calc. Case VAR<0>-4 ;"0 to -4"; VAR<-8>-12;" -8 to -12"; VAR<-12>-16;"-12 to - 16"; VAR<-16>…

Hello, I'm looking to create a calculation field that substitutes for the text style "italic" and inserts HTML code (i.e. text) For example: Substitute( text ; TextStyle(italic) ; "" & text & ") This way, when users decide to italize a word in a text box, the calculation will make it HTML compatible for uploading to a MYSQL database.

Why would this calc not return "the first day of the month that occurred 11 months ago"... Date(Month(CurrentDate)-11;1;Year(CurrentDate-32)) ...and return "2/1/2005" instead? My first guess was that subtracting 32 days from the current date in the "Year" section of the date would allow for an accurate "last year". Was hoping to be able to "slide" dates on an existing report to account for the change of year... *CurrentDate is a global date field set with Get(CurrentDate) upon opening. Thx!

Can someone help me with this calculation : I have defined the following fields : Field VN text (input string of max. 30 characters) Field VN1 text (cal. Field showing one char. of VN on position 6) Field VN2 text (cal. Field showing one char. of VN on position 7) Field VN3 text (cal. Field showing one char. of VN on position 8) / Field VN25 text (cal. Field showing one char. of VN on position 30) Field Nr_options number (count of possible VN numbers) Field Error text (cal. See description below) In field Error in want to show the user a warring of a incorrect input in field VN by using a calculation. For example : If fiel…

I am trying to create a field that will create a flag for a date field when the value is saturday or sunday. Here is my calculation where the date field is "service date". I have also tried this using DayofWeek with 1 or 7 for the weekend days. If (DayName ( Service Date ) = "Sunday" or "Saturday" ; "Y" ; "-") It does successfully flag the first day specified, but not the second, so I am probably not using "or" correctly. I have tried various permutations, but without success I would appreciate some help with this. Thanks

I'm trying to setup what would seem to be a very simple calc that will show the user: 1.) Total Number of Records 2.) Total Number of Active Records 3.) Total Number of Inactive Records 1.) For the total number of records I have a simple "Get ( TotalRecordCount )" calc field setup. (That works fine) So the user can keep old records in the db but keep track of what's current I've added a field that refers to a single value list "active" and set the field as a checkbox. This allows the user to check or uncheck the box to keep track of which records are active. 2.) To setup a count for the total active records I've created a summary field to get coun…

I have a calculation that times how ling someone is in a record. i.e TimeFinish - TimeStart = Actual Time My problem is when a record is created at 23:30 and finishes the next day/morning at 00:30 I have a minus time calculated.... same thing applies if it were 12 hour clock. If not worse as it happens twice a day. How can I over come this one?

Hi, I'm having a problem trying to create calculated field. I want to do a sum and average of the salaries, but all I get are empty fields. Here is a simple database definition. Table: Employees Fields: pkEmployeeID, WageHour Table: Weeks Fields: pkWeekID, NumberOfHours, fkEmployeeID Relation: pkEmployeeID - fkEmployeeID How do I sum the total number of hours in a calculated field in the table employees? I tried Sum(Weeks::NumberOfHours), but all I get is an empty field. Any help would be great. Thanx

I have two tables, A & B with no relation. How can i make a field from table A to auto lookup a global field from B whenever i make changes? Any solution beside using script? Thanks

I have the following formula: Case ( MilesuntilService ≤ 3000 ; "Good"; MilesuntilService ≤ 4500 ; "Service Soon" ; "Schedule for Service" ) I want the text to change color depending on what is in the Service Status field, for example - "Good", text will be green - "Service Soon", Text is yellow, and - "Schedule for Service", text is red. I have placed the TextColor calc in several different spots - sometimes I get too many parameters error, or the field lists a 1 or 0 even through the calc should return Text. I not am getting where the placement of the additional info should be. I swear I took several, hours long stabs at trying to figure this o…

Good Morning, I have a feild hat calculates a value during every import. Is there a way I can refresh the data to perform the calculation over again for the enitre database? Thanks.

I've got a order database with a portal showing all the items included on an order. Part of the items list is a field indicating if goods were received complete, short or in excess. I've put a flag field on the order to indicate if all items were not received complete by using the Case function. However, it only evaluates the first record in the list of related items. How do I get it to evaluate all the related records instead of just the first one? Or do I need to use a different function or method to do this? Here's my calcuation: Case(Items for Order::Goods received ≠ "Rec'd Complete"; TextColor("Receipt Notes" ; RGB (255; 0; 0)); IsEmpty (Items for Ord…

Hi all, Although I have been using Filemaker for almost a year and have some instinctive understanding of the various field types... it seems that on second thought I do not really understand some things in regards to fields on the deeper level. For example: 1. What is the difference between a calculation field being unstored versus a calculation field being stored ? 2. What is the difference between a stored calculation field versus a number-field having a calculated value with the "do not replace existing data" unchecked ? 3. What is the difference between a number-field having a calculated value (and the calculation is simply a reference to anothe…

Hi, I need to remove and replace blank space in an address field. Ex: 100 Main Street becomes 100+Main+Street THank you.

Hi, I am trying to create some kind of a automated formatting for one of the field in my customer database. In this case, I have a field with the expiry date of their credit card. At the moment, this field is a Text field to allow me to enter the expiry date in such way >>> 07/07 or 03/05 , etc... I'd like to find a way for that field in my layout to become red (wether the whole field or only the font) when the expiry date is less than the month and year of the current date... If this is not clear, here is an exemple > We are in January 2007. Customer A has a credit card expiring 05/07 so it's cool. Customer B has a credit card expiring …

I have three text fields one global one account_name and file_name I’m having a hard time figuring out the correct function to do this correctly. Any help would be appreciated Nick

I have a case function that is not working properly. It only picks up the first case. Case field >0, field; field 2 >0, field &","&field2; and so on until I go to six levels it is a bunch if names. that I want to put together with commas, I will pick up the first line but not get any of the others. Thanks in advance Randy

I have a field that I want to populate only if one thing is present. but I want it to populate with the following criteria. If the child's last name is different than the parents then I want the field to be the childs first name and his last name, if it is the same then I want to use the childs first name and then the Last Name field. Now is there is no child first name that is populated then I don't need anything to happen. What I did works except when there is no child first name. It will populate with the last name anyway. The Childs First Name, and if Case (Child 1 Last If Different > 0;Child 1 & " " & Child 1 Last If Different;Child 1 &a…

I am using setfield and its formulas to format a text. I have phrases, sections and paragraphs whose ends are defined with a comma (,) semicolon (: and period (.) respectively. To insert new entries, I use Replace to get the end marker and add the new text with the appropriate new end marker (, or ; or .). This works fine inside the paragraph but if the section is at the end of the paragraph I end up with both a semicolon and period (;.). Is there a non-printing elements that I could use as markers to avoid this problem? Thanks R

Hello, I have a database that tracks advertisment hits by a unique source code per ad...my problem is I can't fiqure out how to summarize and list how many hits per source code....does anyone have any suggestions?? Thank you, T

I have an application where there are two fields on the current layout that are keys to create records in another table. ; style & color. There are quantity fields that are also part of the relationship. My problem is that a user can input the style, color and quantities, then change either the style or the color, and build a whole new relationship, leaving the first set of records intact. So if someone creates a record, inputs the values, an then changes their mind, I will be left with line items that should not exist. Is there a way to prevent modification of a field after it conatians a value ? I have messed around with scripted validations and FM8.5 field validati…

I have a cabinetshop. My customers like to have their specifications in inches. We, however, actually build the cabinets in millimeters. My database has one table for CUSTOMER SPECIFICATIONS and one table for CABINET ENGINEERING. These tables are related with the match field PROJECT NUMBER. Is there a way to start in the engineering table, LOOKUP the customer's preferred countertop height & automatically multiply the Inches X 25.4 millimeters? For example: If CUSTOMER SPECIFICATIONS list countertop height at 36 inches, CABINET ENGINEERING reports this result as 914mm. If possible, I would like to keep this as a simple lookup without add…

I have three tables in a file. Two of the three I have no problems with. But the "Measures" table is getting my goat. Whenever I try to delete a record, all records get deleted. I'm not dealing with a portal. I'm working with the main table. I've tried a recover but to no avail. I usually exaust all of my resources before bothering others with my problems and that's where I'm at now. Any Ideas? Thanks, Mel

If I search the database and the manuals of course I find it but if you know you can tell me in order to spare time. I want to ask: 1. How to validate a field to accept only 15 values and not anything else. I know that we can make it with a list validation. 2. How to validate @ if exists in a field and do not allow the costumer to leave without to put @. in the EMAIL field. Pascal Learning fast I think FM amazinf prog...

Hi, I'm having a tough time tracking down FM functionality that works like a LIKE statement in a calculation. Specifically, I have two fields fieldA and fieldB. FieldA has a list of values associated with it, and the user can choose multiple values. I want fieldB to be populated with specific values based on whether the user selected single or multiple values for fieldA as follows: If fieldA equals "valueX" then fieldB = "result1" If fieldA equals "valueY" then fieldB = "result2" If fieldA contains "valueX" and "valueY" then fieldB = "result3" Of course, setting fieldB based on single values in fieldA is easy. So no worries there. What I'm t…

I'm having a severe "senior moment" that's lasting all day today and may drag on throughout 2007 at this rate. Ugh. So, if you can help me solve the following I'd be immensely grateful. (Refer to the attached file, please.) What I want to do is in the Reports layout/table, select an identifier (ex. PHX) so the field beneath it, City, will autpopulate with "Phoenix, AZ"; it would autopopulate this field from its related City field in the table/layout, Value Lists. Why I can't get it to work, well...I'm down to two brain cells and counting. Thanks in advance for your help! Rich pee ess: This calculation will eventually end up in a run-time soluti…

Previously I saved all scanned documents into a FM containor field as addresses. With FM8 files able to store terabyts of info I am saving scanned documents directly into the containor field. Several problems have arisen since I converted. a) The new application will not recognize the location of previous addresses. I put the the folders with the actual scanned document files on the desk top and still it will not recognise the address. The only thing I did not do is put the document file directly on the desk top as this is not practicle with 20,000 ducuments. since the FM8 application now has older records with documents stored as addresses and newer records with s…

I have a database for a private music teacher and we're trying to have it automatically keep track of lesson charges based on the number of students in each family, the length of the lessons, and the charge per lesson at a rate per half hour. I've been using simple calculations that work fine if each lesson is the same length. Now we're having to deal with lesson lengths that can vary from student to student, either 30, 45, or 60 minutes. I've set up a field for the lesson length formatted as radio buttons with each one of these values and I'm trying to complete a calculation based on these fields: Count - the number of students in the family Lesson Length - 30, 45…

Hello guys! I have some questions. I mean need some help. Where i can read more about this problema? Please, don't derect me to http://google.com i know about it. Please derect me with some links. thanks! UCAKK^^

I know how to create a time/date stamp field which will track changes to a record, but how about a way to track changes to a field? I have a list of "tasks" that need to be accomplished for each person who has a record. Each task is formatted as a simple "yes" only checkbox, and I'd like a stamp to record when that "yes" was checked off. However, sometimes tasks need to be done again (committee chair dies, so a new one needs to be appointed -- happens all the time), so I need the stamp to go blank if the "yes" is unchecked, and then record the new time/date when the task is checked off again. Any ideas? Thanks! Lisa

Here's a weird question, the customer had fm7.... We have a time log for truck fuel fillings. All I want to do is look at the time, and if it's before 6am or after 6pm, flag a warning. I've written all kinds of permutations like: Case (if (time) < 06:00;"Time Warning";if (time) > 18:00;"Time Warning";"" and it doesn't work right, i can't figure out a rhyme or reason why some come up with warnings and some don't the times seem all over the place, oh and (time) is a valid time field.... what obvious stupid thing am i doing wrong? I even tried it with just one comparison, and it is still all over the place.... help -John

I have two related files A & B related by field "ref no" in file A and "reference" in file B I have an unstored calculation field in file B that uses GetSummary to give me a total amount paid per "reference". I have a field in file A that uses lookup to get the unstored calculation from file B. when I run the lookup I am returned a "null" value. There is a value in the field in file B and when I change the focus of the lookup in file A to another field from file B the lookup works correctly. We have just converted the files from v5.0 for Mac OS 9 to 8.0v3 on Win XP. The above situation worked fine on the Mac but does not work on WinXP. Any body ha…

I have a main table (Service Order) in it a portal table (service detail) each time when I add new row in the portal table the portal row's screen starts to scrolls from the first row to the last row. How can fix this problem?

I need to generate a random number between 1 and 28. How do I do this and if it is over 28, how do I make it go back and try again? thanks

I am fairly new to FM. I have a field with a formula containing over 120 IF statements. FM has prompted me that this formula is too long and that I must use two formulae instead. How do I put two formulae into one field? Thanks for your help :)

I have a headache of this. FM can not do this simple calculation because of the construction of the list. See example below. How can we do this simple calculation? TEST.zip

Hi - I need to have a field based on a calculation which is updated but the calculation is multi-step and requires a script. It's pretty simple - just need to do a find and figure out the relative position of the current record in the found set. But as records are added/deleted this will change, so I need this to be updated appropriately. I'm sure this is a common thing - but I can't figure out how to do it. The script is trivial, but how do you tie it to a field or calculation that will update automatically rather than when a script is activated by the user? Thanks! Michael

I have an autogenerated serial number field in a Quote table that I would like to automatically populate in an Invoice table (create a new record and then populate field in Invoice) when the Quote has been accepted (I have a status field I was planning to use as the trigger). I can't figure out how to populate the value without creating a relationship/join - I would like the Quote number to act as the join (and therefore link all of the quote details to the Invoice), but I don't want to manaully enter the quote number. Any ideas on automatically populating the value? (I tried the copy/paste feature from the script but to no avail) Any/all advice would be greatl…

Dumb question. How can i show a comma in a "Show Custom Dialog" option. The calculated field that includes a number, but the result is text. Here is the example. "You have chosen" & QUOTE_amount & " as your final quantity, is this correct?" (Calculation result must be Text) This is what I get: You have chosen 20000 as your final quantity, is this correct? I need to make the 20000 look like 20,000

In version 8, how do we create a new file that collects the totals of certain specified fields? Thanks!!!!

I was wondering if there was a way to write a caculation that was dependent on two fields. Such as If (field one = 2) and If (field 2 =2 then ; "3") thanks

This just has to be simple. Look at the attachment: I need to add up all of the numbers in the 'Price' column. These numbers are the extended price and they are derived by multiplying the 'unit' by the 'qty'. Pretty simple. I have a trailing grand summary. In the TGS, I have a calculation 'Grand Total', which is a summary field and equals the total of the extended price. It is incorrect so I am doing something wrong, oh so wrong. But what? Michael budget_opinion.pdf

I'm using Cases functions to do a few caculations for me and for the most part they work quite well. What happens sometimes is that they decide to not work sometimes. What i'm doing is using them to pull information from another table/field if a field is defined in a certain way any reason that these would not work. Anyhelp here would be great. Thanks, Jonny

Dear FileMaker Gurus: I was required to merge "User Last Name" and "City Name," into a 10-gigit "User ID." I will take the first 5 letters of each. If any one is less than 5, "-" will be filled in, instead. Please help on the Field Definition and Calculation! Appreciate it! Max NY

I would like to have a field in a table called "LastModifiedBy" which stores the account name who last changed the data in any of the fields for a row in the table. That is, if any data in a given row is updated, record who did it. Any ideas?

I have a user who does TONS of data entry for dates in the prior 2 months. Typically in January she would set her system clock back a year so that FileMaker autocompletes the correct year after she enters just the month and day in the date field. This worked great with FM Server 5.5 and Client 6. However, since the 8.5 upgrade, she will lose her connection to the server and be unable to reconnect after she backdates her client marchine (this usually happens not during data entry, but when she tries to make a new record, so she loses 20 entries every time it happens. It was a huge pain to figure out the cause). 1. Is this a known issue? 2. It is unwise t…

Hello! i have a "member" table, there i have "full name" and "picture" field. How can a pictured be added automatically? i will name the picture as the "full name", how can i do that?

hello! i have two tables. one "members" and the other "team". in "members" i have the info about hte member and an "id" in the "team" i only have the "id" and the "team name". I want in the layout of the members, to show the "team name" of that member and all the members that are part of that team. How can i do that?! thanks! and sorry for being such a newbie!

I'm really new at this, so please bear with me as I try to explain in unofficial terms what I am attempting to do. I work in the library which keeps stats of every question the librarians get asked. They would like to know what time of the day is busiest, ergo a count of how many people ask questions between 12:00 and 1:00 pm, etc. I have a field which auto enters the time. Is there any way to extract numerical statistics on this? Thanks!

hello! i have a field called "Subjects" that has a value list called "subjects" too. I want under that field a counter that will show how many "subjects" are clicked, active, or however you want to call it. Can somebody give me the calculation for that?! thanks!

My coworkers and I are having a hard time working this out. Anyway, here is the story: On our invoices we sell items (which you select under the "product id" field)that are taxable or nontaxable. I have found a way to set it up so we only charge sales tax on the taxable items. Well now there is a curveball, because we also will discount certain items (basically anything but memberships)to our high-paying members. There are two problems I am having with this - 1 is that when the discount is applied, it is applied only to the subtotal before tax, so the tax is still being calculated based on the price of the items pre-discount. I would fix this easily, except f…

We have a contacts table with several thousand contacts. Inevitably there are going to be instances where two people have the same name but work for different companies. I would like to know if there is a way to have a window pop up that says, for example..."There is more than one John Smith in our system. Please select which person you would like to use." Somehow I would like to have a way for the person to select from a list of those people and have the individuals contact info fill into the correct fields.

I'm trying to create a summary of invoice totals per week buy can't get it to work. Can anyone help me with the correct formula? All help is greatly appreciated. Thanks, Rick

Please help if you can. I need to format some numbers with a calculation. I want numbers greater than 100 to show as whole numbers, which I can do with the Int or Round function, but I also need numbers less that 100 to display to the hundredths place. It needs to show two and only two places to the right of the decimal regardless of how precisely the number is entered (i.e. 1.006% should be 1.01%; $7 should be $7.00; and $105.67 should be $105.)

I'm unsure of how to make this work. I was using the operator of "" to make the specified field (such as "RECORDS DEPARTMENT" match exactly, however I decided to go to 'global' fields so we don't have to change the code manually (thus the code below where "Configuration:LVMPGRP00_1" is a global field). Now, because I can't use "" with the global fields, I can't make it do an 'exact' match on the contents of that global field and it looks for *anything* in that global (so if I only wanted it to hit on "RECORDS DEPARTMENT" it won't work with the global because any other entry that has "RECORDS" or "DEPARTMENT" will hit. Wow, hope that made sense! Just trying to …

New to the whole FM thing. Finally graduated from Entourage Address book! Still reading the manual but if anyone knows a quick way to do this as I need to send out emails now! I have an email not written in FM but Entourage Mail. I need t send to about 300 plus people. Is there a way I can do this without having to drag each email into the address field on my email? All our emails are done in Entourage. Any help would be appreciated! Thanx......Tina

Hello, i was wondering someone can help me with this. basically i have date calc that count how many days has pass since the student have being withdrawn and when a refund need to mail. i am able to count the days but i am trying to figure out how to stop counting the day after certain date. this is how my calc look for the outstanding days Today- StudentWithDrawDate Since i know date the refund is mail, i was wondering if i can use that to stop the counting. i basically want to know how many days took for the student to get the refund. i am using filemaker pro 6. thank you vic

Hi Guys, I have hit a wall with this calculation. I need to create a text field with 2005-2006, 2006-2007 etc, based on any given date. The changeover date is April 1. Has anyone else done this or can point me in the right direction. If this is not clear I'll try and explain it more clearly. Many thanks. Seasons Greetings Gordon

Is it possible to use a wildcard character to replace all of this: Survery::q2_result = "" or Survery::q2_result_text1="" or Survery::q2_result_text2="" or Survery::q2_result_text3="" or Survery::q2_result_text4="" or Survery::q2_result_text5="" or Survery::q2_result_text6="" or Survery::q2_result_text7="" or Survery::q2_result_text8="" with something like this: Survery::q"*"="" I only want to evaluate those fields included on the layout that I am running the script from. Thanks.

Background: We keep a running history (via a portal to another table) with all the work assignments an employee has and does work at. A big organizational change just happened an I only need to replace the departments of some employees CURRENT assignment (but not replace their old prior assignments in the same table which may have the same department I'm trying to replace). Question: Is there an easy way to change their top level (first record) current assignment? Or because this is in a portal is it too difficult?

When I create a new company in my database I want Filemaker to automatically add the word LIMITED to the end of the field. e.g. I type in Wallwen then Filemaker adds in LIMITED.So the full field shows WALLWEN LIMITED.

Hello Forum I have attached a file that hopefully explains what I am trying to achieve. I want to save PDF, WORD files, etc into my database that show name of file and file type and description. Then when I click on this file it opens to allow me to view the file. In any one database I will have at most 20 different documents or files. Hope someone can give me a little help on this. Thanks in advance. Martin INSERT_FILE.bmp

Hi, I am trying to create a automated email and in the calculation script where I am setting up a template for each email. In the template I want it to print only the current month and year according to today's date. I am having trouble getting that as when I choose Month(Date), it needs to be linked to a field, but I want the current date. Can anyone help? Many Thanks Dean

Hi, I want to print about 200 fields within one data record on a label-layout, which has 78 labels on a letter-papersize. Only fields containing data shall be printed. How can I avoid empty fields to occur on my printout-sheet? thanks a lot Axel, Germany

I have a container field that displays the contents of an image file located on a specific PC directory. The path and filename never change, but the image in the file can be edited/replaced by the user. I haven't found any standard feature to cause FileMaker to refresh the container displayed on a layout when the image changes. Is it possible to run a looping script (with delay) as a "background operation" to handle this? Thanks for any suggestions.