Calculation Engine (Define Fields)

I have a problem with dollar amounts when using calculations. I have an order total field which is a calculation to total up items on an order, shipping and sales tax. Then I have an amount paid field. And finally I have a total outstanding field that subtracts the amount paid from the order total. I have found though that because the order total is formatted down to two decimal places depending on the math I might end up showing a -$0.01 total outstanding even though the order total and amount paid are equal. So I want to find a way to round to two decimals, not just format a field to only show 2 decimals. Does that question make sense? Thanks in advance.

My setup is a mixture of Mac & PC FileMaker Pro 7 Clients accessing a database stored on FileMaker Server 7 (Mac OS X Panther Server). I have set up an IT Helpdesk Call Logging database and I am requiring a solution for the calculation of call logging and response times taking in to account the night hours between close of business and the following morning, weekends and bank holidays. For example, we currently have fields called: - Call Log Time

Has anyone worked out how (if) you can use scribble fields from a Pocket PC device captured using Visual CE. I note that Syware say that container fields are not supported but I was wondering if there was a way around it. I like the idea of using Visual CE, but if I cannot capture signatures from the device then I cannot use it.

Hi, I'm stuck on what I think should be something simple. I have several numeric fields (Number1, Number2, Number3, etc). I need another field (MinNumber) to calculate the smallest nonzero value from the set of numeric fields. I tried using the Minimum function but that won't find the smallest nonzero value (it only returns zero because one of the numeric fields invariably contains 0). Nested If/Then statements doesn't seem appropriate since there are a few dozen numeric fields to check. TIA.

Hi I want to store portaldata into ONE calcfield. I have 2 db's, filtering on a countryname. DB#1 holds the info of the person inquiering, #2 holds companies that provide the needed info. If in DB#1 a field is populated with 'USA', it'll show up in the portal (in DB#1). The DB#2 companie has one textfield where numerous countries are entered, so theres the relationship and it does work ok - what i need now is to cunstruct a calculated textfield of which the result i can use for emailing. So far this is all blurry... I'll try to explain: DB#1 : input is 'USA' DB#2 ; company offers 'USA' DB#1 : shows names of offering companies in a portal. The portal also hol…

Hi, I would like to create this situation: If FieldA is not blank, then auto-enter "," into FieldB Is this possible in Filemaker 6? Thank you so much for your help, Karen

I have a field that requires not empty and must be filled with one of two values from a pop up. It is one database that houses two companies. I have a message that pops up saying "Please choose a company" My problem the validation message is popping up on another field when tabbed to. The message is coming up on a date field that I use to set my appointments. I have checked the date field and no validation is set. With the date field I am using Brian Dunnings Calsnap, which is a script button that pops up a little calendar and auto enters the date chosen, which is pretty cool I may add. I checked the script and can not see anything that would cause the validation messag…

Hello, I'm using Filemaker Pro 7, trying to migrate to MySQL 4.1 using the FmPro Migrator. I have JPEG images in a container field, not using file references. I import the JPEG images myself and they are stored in the database. For some reason, when I try to migrate the images to MySQL, it seems that FileMaker is just storing a filename referencing the JPEG files, not the actual data. My size of my images are about 60KB, but when I migrate it, it becomes 28B. When I import these pictures files, the there's a check box in the import options to import only as a reference to each picture file, and I'm sure that check box is unchecked. So how can Filema…

I'm trying to convince my boss to switch over to a FM7 billing/invoice system of my creation, but I can't figure out how to age outstanding invoices. I've gotten as far as converting the creation date into a number which I thought I could use to calculate vs. a current date. Now I see when the year turns it goes back to 1. Please help...

Hey all, Ok, I'm a newbie to Filemaker and am having an issue with a project at work. Here's the situation - I created a sweet address database. However, information in one of the fields only appears in Find or Browse Modes (not in Preview or printed copies). Does anyone have advice regarding this issue? I realize it's a stupid question, but I'm really stuck in trying to figure it out. Any help is greatly appreciated. Cheers, Larry W. [email protected]

Ok its been along time since I have been on this forum. I have three fields: InFile (Yes/No), Who (Pull Down Menu 4 Items) & Date Field (Date Format) I can not figure out how to do a data validation on theses three fields... I would love something like this: When Infile="NO" & Who=Empty & Date=Empty then no error is given When Infile="Yes & Who=Filled & Date=Filled then no error is given When Infile="NO" & Who=Filled & Date=Empty then Error When Infile="NO" & Who=Filled & Date=Filled then Error I think i should use the case function but I do not how to do 3 fields What about the if function? Should I…

I need to set a field as calculation field. If condition1, result 1; else if condition2, result 2; else condition 3,4,5..., result 3. I am not sure if I can use If function, since it can only set two results. How do I do this?

I have a standard date field. Some of the dates I am enetering are complete ie. dd/mm/yyy and will display fine. Some of the dates I have are year only. I cannot enter year onlt without getting an error. I'm sure there is an easy way to do this :-) Cheers

I have just upgraded from Dev7.0v2 to Dev7.0v3 and all my containers are behaving differently. I have used Containers extensively to allow users to set tab colors etc. The problem I am having is previously I had the image in container going right to the edge, with line set to zero (except it did require field borders to be on) - this ensured the image went directly to the field extremities. Now (in 7.0v3) the field border is always 1 pixel. I need my containers to go edge to edge. Does anyone have any idea of what I can do? Am I missing something? I think it has something to do with the fix FileMaker made when buttons were behaving badly in 7.0v2. Thanks …

I have created a database that I want to allow me to quickly lookup information in regards to Photoshop and FileMaker. I am finding QuickTime Movies and PDFs that I am adding to my database. Yes, I know, importing files will make my database larger but I do not want to deal with the hassle of keeping an external location for reference files. My problem is that every time I import either movies or PDFs, they are not added to the database but only referenced. I have tried Inserting, Importing and pasting and in each case I have a reference not the actual file in my database. When using Importing, I have deselected "Import only a reference .....". Yes I have t…

One of my biggest troubles with FileMaker is working around unindexable calculations. I often need to base a relationship on this information, and I'm continually trying to find the best workaround. My latest idea was to take advantage of the new auto-enter calculation feature where you can specify that the calculation should replace the existing value of the field, but this doesn't seem to work when the calculation is based on related data. So my next workaraound attempt was to create two fields. One is the unindexed calc based on related data, and the other was a regular field with auto-enter calc that is simply the first field and the "Do not replace existing…

Greetings and Happy Holidays. I'm having a, hopefully, small and easily correctable problem. I have two databases. One that i used for one project, the second created for another project. I created the second database by making a duplicate of the first and then making the needed changes. After a couple uses of the 2nd database, i opened the file and it all the fields read <missing table>. I haven't changed the location of the files on my hard drive. I haven't messed with relationships either. When going to "layout", I tried double clicking a field, and applying the select field command. Once the new window opened, i had to select the table and then the …

I thought I would ask the pro's this question relating to a month calculation. I have an employee attendance database and I want to automatically add 1.25 days to each employee

Hello, i'm a filemaker newbie. I'm building a purchase order system for my company and the standard Purchase Order template does not fit my needs. I've got most of the fields and layout figured out but am stumped on certain calculations. I have attached pic of the P.O. layout for your reference. Here goes: I am building a P.O. for clothing so when we do our orders there are always multiple colors with different qtys. I have given each category 18 repeating values (so each style has 6 repeating values for to cover all the information) However my problem is that when i want to subtotal each style (6 repeating values) I don't know how to specify that the sum be of…

How can I compare 2 fields that are the same, except for case, and have them come up as not equal? Example: Field-1="ABC", Field-2="abc". When comparing in an If statement (If field-1 <> field-2), it fails the test and identifies the fields as equal. I tried using Proper(Text) but it still doesn't work. Thanks.

I'd like to write a calculation that uses the field name (that the calculation is in) as part of the expression. For example, if a have the field "Count Code 30" and I'd like to have the "30" usable inside the calculation, can that be done? I tried using get(ActiveFieldName), but that doesn't seem to do anything (it seems to be blank no matter what I do). Here's what I tried: Case ( Cat1 = GetAsNumber(Right (Get ( ActiveFieldName ); 2)) ; 1 ; 0) + Case ( Cat2 = GetAsNumber(Right (Get ( ActiveFieldName ); 2)) ; 1 ; 0) + Case ( Cat3 = GetAsNumber(Right (Get ( ActiveFieldName ); 2)) ; 1 ; 0 ) Ideally, this would check each of the 3 fields (Cat1, Cat2, Cat3) f…

I did a quick search for this and didn't find an answer. But here's my question. I am creating a database that will be updated daily the main function is to keep count of certain fields (example, how many calls made that day? how many recruiting call? marketing calls? interviews shceduled? ect) so what i need to know is how do I add all those fields. for instance I want the total field to state 40(in field 1)+40(in field2) = 80 not 2 as it says now. can you help?

well, all my employees are screaming again... they want me to design a way for them to show the students in a schedule type. I have created a list, which is great for roll calls and things, but they need something that shows a more graphical way, something like what the relationship tables on FMP7. Colums with the classes seperated by time, ie, column 1, 3:00 class, students in that class, 3:30 class, students in that one, and the columns would be the days of the week. Column 1, Monday, Column 2 Tuesday, ect... I know how to use portals but I can't see how this would work. I thought of a seperate field with a setfield command but as the classes are not the same, I can't s…

New to FP7. Would someone more knowledgeable than I tell me how to make a calculation field that allows me to display an average (as a percentage) of the number of times a "YES" radio button (or check box) has been set compared to the "NO" box? A "Not Applicable" choice or no choice at all should not count. In case that is possible, what about calculating a percentage based on three or more buttons? ("low" to "Medium" ot "High" for instance). Thanks in advance...

Newbie question. I am trying to use the case function to select data from one field if before a certain date, and another after the date. I have used the following, but it behaves as though its not interpreting the date correctly. When I try the same with If, a similar thing happens. I am using an old database in fp5 for this. case(visit date > 6/30/2004, related field 1, visit date <= 6/30/2004, related field 2) thanks for the help. dcs

Could I get some help with the following rounding calculation: I need to round up [up only] to nearest Integer: i.e.: .999999 = 1.0 and 1.000001 + 2.0. Thanks, Russ

Files that are on a different comptuer in my network and whose references I've stored in a container field do not open when I control+click the file path and select "open file." The Details: I am using a FileMaker 7 database on Mac OS X Panther. My computer is part of a network of computers, all Macintosh computers running OS X Panther. I host a FileMaker database that is shared with our little internal workgroup. I'm not using FileMaker Server. I am setting up a database for our photo library. Our photo library is stored on a different computer from mine. I have figured out how to easily import the file reference (I certainly don't want to store the jpegs, pdfs,…

I have filemaker 5 and I am trying to use extend for a simple function. I have a start number of 245, from that I am trying to subtract values in a repeating field and have the result displayed in a repeating field. It is set up as remaining(result) = extend(start number)- repeating field (any value) For the first row it works for the second and third rows I get a negative number. It doesn't seem to be using the 245 for each calculation. Am I missing something??

I know in HTML i can create a script that when a user selects a drop down list, it takes that user to a certain page. Well, is it possible in Filemaker for a user to have a list of options in a value list assigned to a field, i.e. New Record, Delete Record, Duplicate Record... so that when a user selects that option, it performs that script? I am trying to minimize buttons and that seemed to be the best thing to do.

I need a calculation that I can use within a set field script step that will look at the current date and from that determine what the date on the Monday of that week is/was. Similarly I'll need calcs for each or the remaining four business days, but I'm assuming if someone can point me in the right direction for the Monday calculation, I can alter it to get the calcs for the rest of business week. I'm pretty sure that I've seen this calc before but I can't seem to locate it anywhere. Any help would be much appreciated. Thanks

I receive a txt file with date information formatted as: 20040726 (no delimiters) Is there a magic (read: straightforward calculation) way in FMP7 to convert this to a date formatted as 7/26/2004? Just thought I'd ask before I go "old school" and create too many extra fields to extract, sort and re-combine the info. I've been off FMP for a while and on Excel far too long.

I have a number of large text fields that take up the right half of the screen. To permit access to all the fields and at the same time allow the user to see the full text, I stacked the fields and have buttons just to the left that are scripted to go to the appropriate field. However, this alone can allow the user to forget what field he/she had entered. I planned to have each of the "go to field" buttons to be calc fields that become bold when the corresponding field is entered, and plain if not. Calculation as follows (for the button to navigate into the TextReason field) Case( Get(active field name), "TextReason"; TextStyleAdd( "Reason", bold); TextStyleAdd( "…

I

Could you please help me with this calculation: I need to round UP [up only] to nearest .05. i.e. 6.63 to 6.65 0r 6.66 to 6.70. Thanks. Russ PS sorry if there is double post on this topic.

I want to use the contents of a field to be used as a parameter in a function. Field 1: back_current_fields calculation: FieldNames ( Get (filename) ; Get (layoutname) ) Result = list of field names in the current file on the current layout separated by carriage returns. This is the field I want to use in a function parameter... Field 2: audit_trigger caclulation: Case(company_name; key_company_ID;key_company_ID) This is a modified Case statement without an

I store PDF file references in containers and I would like to have the PDF file open automatically without having to double click the container field itself. Is there a way to do this? Thanks, Jarvis

My database is used for student demographics and other needed data collection for reports. At the beginning of the school year I was able to get help regarding the AGE field from this forum. The formula that was given to me to automatically calculate the age when the DOB was input was grateful [color:"brown"] . Now I have run into the issue of keeping that AGE updated. Is there a way I can do this? The formula I used is: Year(Status(CurrentDate)) - Year(Date of Birth) - (Status(CurrentDate) < Date(Month(Date of Birth), Day(Date of Birth), Year(Status(CurrentDate)))) I would surely appreciate any suggestions!!!

I have cash file with fields: Date Input Output Rest For any date i may have few records. I want for every record in Rest field see the rest of money for current record.Can i do it? I want that Rest field be calculation field for dinamic work. All this i want to do in v6. Thanks!

Hi, Can someone tell me if the following is possible. I have an application that once filled out will generate a completed form. there are fields for a doctors name and there address, phone and lic#. Is there a way that when the drs name is selected, it will automatically fill in the address phone and lic#. if so please tell me, thanks in advance, Rob

I could sure use some of you guys expertise here. I know this is possible but just don't have the skills or knowledge yet to pull it off. Trying to set this up for my daughter's daycare. Here is the situation... Several of the children have daycare paid by a government program and we need an accurate way to track billable days. Payment is made on a FullTime or PartTime basis. Non School Age children are always FullTime. SchoolAge children are PartTime on school days and FullTime on days they are out of school or Holdiays. Each child has a RATE depending on their classification, i.e. Toddler, PreSchool, PreK, SchoolAge FullTime, SchoolAge PartTime. Absences are paid for so…

I've created a calculation which returns a date. However one of the conditions should return the date field as blank. however if i enter it as "" or 0 the field shows a question mark '?'. what do i have to set it to to be blank?

I am trying to work out how to change part of a text string without changing the entire field Basically I generate a text string by a calculation combining data from up to 14 fields adding required syntax between fields to create a text string. Case (IsEmpty(FROM)=1;""; (IsEmpty ( RFROMa ) =1) or (IsEmpty ( RTOa )=1) or (IsEmpty ( INC )=1);"_V(" & FROM & ")-[" & AL & " " & CL & "]-V(" & TO & ")" ; IsEmpty ( RTOb )=1;"_V(" & FROM & ")-[" & AL & " " & CL & INC & "<"&RFROMa & RTOa & "]-V(" & TO & ")"; IsEmpty ( RTOc)=1;"_V(" & FROM & ")-[" & AL & " "…

I want a way to either gray out or be able to control access to related fields based on what the client selects for the primary field's answer. For example, if the client selects "Yes" from a pop up menu for the Primary field for "Was A CT Scan Done?" then they can access the remaining related fields.... "CTScan Date", "CT Scan Location", etc. But.... if they select any other value from the value list other than "Yes", I want to be able to either restrict their ability to enter in any values in the related fields (as noted above) or to have a mandatory warning pop up that won't let them. I can't seem to find a correct "IF" or "CASE" function statement that I can …

I have two files Company and employees .Employees are related to comapanies by a lookup code. In employees I need to create a field that totals all employees that meet a certain criteria. I am having no luck. Is this possible?

I have a counting database. There are 3 datafiles. Articles, positions and bills. I want to create a field in the article file which shows the sum of an item per year. So not only for the current year. It should show the total of each item sold for 2004 in one field, for 2005 in another field etc. I am grateful for any idea.

Hi ! Sorry, if this question has been here already... I converted a FM6 database to FM7. Now date-field doesn't work how they should. I want to enter dates in dd.mm.yyyy -format. In FM6 this was allraight, but in FM7 it returns 0.0.0000. If I enter dates in dd/mm/yyyy -format it works fine. What did I do wrong this time ? : Arttu

I have a couple of fields that must have data entered in a perticular format and would like to find a way of validating the data. basicall the data must be entered as groups of 3 letters with a space separation between groups eg LAX NYC MIA There can be no spaces at the start of the field, there must be only one space between each group and the groups must consist of 3 letters, or a specific symbol (@ or / followed by two letters). The number or groups entered in one field can be anything from 1 to 40. I can subdivide the field into 40 data entry fields but since 95% of the time there are less than 5 groups entered it seems a waste of space . …

I am trying to subtract 1 year from a field that already has a date within it into a new field i.e 1/1/2001 shows in 1 filed i would need the next field to show 1/1/2000 How can i do this? Thanks, Jerrad

What's the best way of producing stats of my data Data: 10000 records changing daily 10 different users Important to get immediate update of the stats 1. Statistic summary field in db1 - showing on layout with db2 through user relationship 2. Calculation in db2 - sum(db1::time)

I've noticed that occasionally when I open up a FM 7 database the contents of some global text fields are getting erased. This isn't a by-product of a script or a user - I've seen this occur in two totally different databases. Has anyone else seen this? Known bug? It appears to be totally random to me. Anyone have any ideas?

How do I get a summary from one table into another?

Hope this is the correct place to post... In Excel I can set up a database that allows me to ask questions, getting a YES or NO answer for each, and calculating the responses (number of YES compared to NO, expressed as a percentage etc). I wanted to set up a template for such a function to use for a series of questions in FP7, allowing the user to answer each by checkboxes or radio buttons, and to add comments to each page before going on to the next question (next page, same template). I tried putting the basic data into the Header part and only the questions in the Body, but when I try to change the question in the next page, it changes the question in all of the…

I haven't been able to find an easy answer for this problem: If I have 1000 records that contain info for 33 markets and when I have a layout that includes summary functions and I want to know how many markets a certain brand has how do I get it to show 33 rather than the actual number of records, like 345? Thanks

If you change the position of fields in the Define Fields window, will it change the order in which calcs are processed? I used to use Symantec's Q&A. In it you could decide the order. I'm asking because I wonder, if the order were more logical relative to the algorithm, instead of being in a simple chronological order (when created), if the process might run faster. Appreciate any help.

Ok... this may be a totally boneheaded question, but I'm new to Filemaker, so bear with me... I have a filemaker database which lists repaired units by serial number. I'm simply trying to calculate the number of instances a particular serial number is represented within the database in a tabular view. That's the first hurdle. Secondly, I'll need to generate a count of the number of units repaired once, twice, three times, etc. Anyone have any ideas? Thanks in advance for your help!

Hi, I need to print a field with the text that is typed into it exatcly as typed. Is this possible? and if so how do i do it? Thanks in advance, Rob

I import many records from a text file on a regular basis. One of the fields has a book call number such as QA76.9.D3M445 1993 I need to recalculate that field so that it looks like QA 76.9 D3 M445 1993 So, in this example I need to add a space after the "A" , remove the second "." and replace with a space, and add a space after the "D3" All of the values of this field are consistant in that they all need a space after the first two letters, replace the second "." with a space and add a space before the second letter after the removed "." I hope this makes sense. If anyone can help me I would appreciate it greatly!! Thank you.

has anyone developed a calculation to convert a number field to Roman Numerals? Any help is appreciated. Thank you!

This is annoying enough

Hi everyone, I am making a simple time sheet solution and I an trying to make a field display a Date or "Vacation" or "Sick". I have separate fields for each day of the week. For example I have "IN_MON", "OUT_MON" and "HRS_MON". I have 2 text fields called "DATES_VAC and "DATES_SICK".Right now "HRS_MON" looks like this: Case( PatternCount (DATES_VACA ;Date_MON ); "Vacation"; PatternCount (DATES_ SICK ;Date_MON ); "Sick"; If(OUT_MON - IN_MON>8; "8"; OUT_MON-IN_MON ) ) What I want to be able to do is let the user enter single dates as well as date ranges. For example if a user enters the following in the "VACATION" fi…

I'm new to Filemaker, trying to make a 30 day evaluation. I have many records each day, with Date, Subject, and Amount. For each date, I want to extract just the Highest Amount record of each subject for a report. So each subject with have one line for each day, which is the record where Amount is the Maximum on that date for that subject. I can see how Filemaker does simple things, but the logic of how to do this escapes me. Any help or references to learn more would be appreciated.

Hello, I think I am trying to be a bit too ambitious here but if any one can help I really would appreciate it. This is what I have been trying to do: I have one file for storing invoices and generating a confirmation of an order form and on the form is an area which shows what products have been selected by the customer to purchase. This area has repeating fields in it so multiple order items are shown. i.e. file1::ProductID || file1::ProductDescription || file1::ProductIDInstance || file1::ProductStatus Now the the difficult part for me is that the customer wants to be able to fill out this form dynamically by two means. First they wa…

I am trying to work on making my address book database a little friendlier. So when I print labels (like for my Xmas cards that havent been sent yet- hurry!) I am trying to set up a calculation field for the name of the recipient. My database has a First Name field and Last Name field and also a Value List Field called Send To Family? that can be checked yes or no. So, for example, if I have it checked "No", then I would like the calculation result to read <First Name> <Last Name>. but if "Yes", I would like it to read "The" <Last Name> "Family". How do I write this?? I have tried an If, but I cant get it to work by adding field contents into the re…

I have a field that contains the following: 80 12 6 I want to do a calc that returns "Yes" if the field adds up to between 95 and 105 Is this possible? Larry

How can I limit the number of characters in a Global Field?

This is my initial post as a Novice. I'm using a FM (7.0) database of parsed server access logs to study visitor usage patterns to my site (www.the-intuitive-self.org). I've used FM on a modest scale for simple off-line databases. Now I'm tackling ScriptMaker for the first time. I've got my first script up and running (after many false starts) with one exception. I'm trying to calculate an elapsed visit time (DT Visit) using TimeStamp variables to represent the date and time of the most recent request (DT Request) and the first request (DT First) in a visitor session, e.g.; DT Visit = DT Request - DT First where all variables are defined as TimeStamp and st…

Hi All, When I add a number to a text field, only the number part is retained. Is there a way to make the result include the other characters? For example, when I add XYZ100 + 1, I get 101, but I would like to get XYZ101. Thanks in advance! Butch M

I am working on a employee evaluation database. The Employee file contains one record per employee. The Evaluations file contains many evalautions filled out for each employee. The files link on the employee ID no. My question is this, let's say an employee, John Doe, has 7 evaluations. Each evaluation has 9 performance factors (PF). Each PF has a numeric rating and comments. I can average the ratings and give a average per PF, but I would like to combine the comments for each PF into it's own PF total comments field. Right now the comments are sitting in a portal with no hope of sliding. Can someone give me a pointer to which direction I could go? Looping s…

Hello there, please help. I have two text fields: text1= 5 14 15 text2= 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 I need to get the result, text3 = 1 2 3 4 6 7 8 9 10 11 12 13 I use wordcount, loop, middleword and substitute, but not getting the answer I require. Please can someone help? Many thanks.

Somehow I volunteered to build a contact list and integrated production order database for my company...wise idea... I've managed to build and integrate almost everything, from existing templates included with FMP 6, but have one problem. In the contact database, I have two fields that I would like to work together. When someone enters a company name for a contact, I would like that company name if not yet entered into the database to recieve a customer number in the form of a 3 digit serial #, such as 001, 002, 003, and so on. But for instance if a contact is entered, and the company has already been entered for a previous contact, I would like that company's…

Hi, fresh user here... Just wanted to know if it't possible to have a lookup "looking" at 2 different things... I have an invoice table and a budget table (and a products table)... I want to be able to use a yes or no field to select if i want to populate the "QT", "Description", "Value", etc. fields with data from the budget or fresh new one form the prducts table, this way creating a new invoice without a budget... I used lookups fields and they work with the budget, but now i can't find a way to move form budget to products table... Budget table aslo acesses the products table. Thank you all...

I'm trying to display a field that tells the user if a piece of Kit is on hire, or in stock. I have a kit table and a hires table. At the moment a script checks to see if there is an entry in the hires table for the piece of kit. It then checks all found hires to see if one doesn't have a return date (each hire has a start and return date). If it doesn't have a return date it must be on hire, if it does, it is in stock. Currently the user has to click an update button for each piece of kit, to check it's availability. Is there any way to put all the script action into a single field, so it updates on it's own?

I have 2 Date Calculations I need to figure out, and I figured I'd ask them here first before driving myself crazy trying to get it right. Duration Between two times would be time2-time1? How do i get it be a duration and not an AM or PM? How about if time2 goes into the next day? And here's the hard one. The result of that duration needs to be multipled with a percentage, I.E. a 6 second duration times 10% equals 1 second. How would I do that? What I'm trying to achieve is this ... I have a bunch of lenghty functions, I will know the average duration of them (caluclation #1). With that average, i will then use it to let the user know approximatly …

I'm trying to make a calculation field that is the total of several fields that pick value from a pop-up meny value list. In the value list the user can pick seconds and minutes. So, when next whole number is after 59, how do you make that calculation so the total show right amount of minutes and seconds?

Is there a way to create a trim function that will trim ALL non-printing characters? The built-in Trim function only takes care of leading/trailing spaces. Barring that, maybe I can set an "In range" limit on the field? But how would I do that if I wanted to include everything except non-printing characters? There are a number of odder characters (punctuation, foreign chars, etc.) I'd like to keep.

Hi, Is there a solution on how to make the white background of an imported eps file dissapear? In FM 6 the imported eps didn't show an additional background. When importing the same image in FM7, FM7 adds a background. I want my transparancy back Help Greetings Arie

Hi I'm working on a FileMaker based content management system. Users post their updates into the system and they appear on the web. I'm trying to make a field so that it shows the first 90 or so words of an update, so that I can do a PHP include to it on the front page. When users make an update, certain users can post HTML in theirs. In my synopsis field, I've tried the LeftWords function and the MiddleWords function and both seem to produce the desired effect. Apart from... Where a user has put html in the opening line of their update For example <img src="http://imagelocation" alt="" border="0" align="right" />rest of …

I'm pretty new to FileMaker and very new to building expressions... I'm trying to build an expression that will compare 2 fields and not let me create 2 records where field A contains a value and field B contains a value. For example, I want to make it impossible for the following to happen: Record 1: Field A=1; Field B=100 Record 2: Field A=1; Field B=100 In this table, it is possible for Field A to have duplicate values amongst many records, and for Field B to have duplicate values amongst many records, but there cannot be any duplicates as I specified above. I just don't know which expression parameters will allow me to achieve this. For example, …

I've got a few fields in my solution that don't update their values unless I physically put the cursor in them and click...sometimes. I can't figure out why some fields do this. It makes no difference whether the field is in the layout as a field or as a merge field. Also is there any way to ensure that ALL fields in a layout are updated to the "current" values? thanks...Sandy

What could go wrong in this simple calc? Get(Recordnumber) & " of " & Get(foundrecords) Had to translate the recordnumber and foundrecords from swedish... The first one should give me the recordnumber of the active record, the second one the number of records in the found set. Instead I get the recordID and the total number of records. WHY?

I've been given a DB which contains images that are embedded in container fields. I now want to change this so that the images are referenced instead of embedded, so need to export and then re-import the images. I could go through them one by one, but as there are over 1600 images, I was wondering if there was an easier way i.e. a way to do a batch export of container field contents? Also, I need to publish this DB on the web, so I just want to check if there are any differences between doing this with the images embedded or referenced? Any advice would be appreciated.

i have a file with customer orders. so the same customer id will appear once for each order the customer has placed. i am trying to find some way to serialize each occurence. so for customer 500, i would be able to see that this is order #1, order #2, order #3, etc... any ideas?

Hi -------- FileMaker 5.5/6 -------- I'm working on a FileMaker based content management system for our website. I have a field called TEXT which is the body text for the news item. People type the update in there, along with some basic HTML formatting tags like bold, italic, underline, font size, alignments. As well as image tags and in certain cases, tables. I have a calculation field in the database which does a substitute on the contents of TEXT replacing each line break (the backwards P thing) with "<br />

I am using a "Case" calculation function to populate a calculated field. I have one field that is populated with data that is imported from an external file. Lets call it Type and it can have similar values like Item 1 (v1.0), Item 1 (v1.1), Item 2 (v2.0) Item 2 (v2.2), Item 2 (v2.5) etc... I want to simplify my Case statement so I don't have to express each possible value. Right now I would have a statement like; Case ( Type= "Item 1 (v1.0)" ; "Item 1"; Type= Item 1 (v1.1) ; "Item 1"; Type= "Item 2 (v2.0)" ; Item 2 ; Type= Item 2 (v2.2) ; Type = Item 2 (v2.5); Item 2 ; " ") Simplified I want it to look more like this. Case ( Type= "Item 1 *" ; "…

Can someone explain this to me. I have many solutions that utilize pop up lists. Sometimes when I click on a value from that list it automatically tabs to the next field and sometimes it just enters the value and stays in the field. How can I control which it will do?

Hello, I am new to Filemaker Pro (7) and I am trying to figure out how to calculate a date based on another date. For example, if a "Last Payment" field contains 12/10/2004 how do I automatically fill the "Next Payment" field with 1/10/2005 or 3/10/2005? In other words, how do I add a specified amount of days to the "Last Payment" date value and have FMPro generate a date? I have looked in several texts and have not found any examples like this. Is there a way to do this in Filemaker Pro or is it not possible? TIA, rlbryant

I'm currently having a problem with the speed at which records are listing in one of my layouts. The problem is due to two complex calc fields that take time to recalculate but that have to be shown and that the system forces me to leave unstored. I'm wondering if there's a way I could put something at the end of the calculation so that they set a noncalc field to the value they calculated? That way in the listing I could show the non-calculated fields instead.

Oh I'm back. You all helped me with this but I had to change it because they changed what they needed. Inserting percentage. They want buttons with 10-15-20 etc. AND NOW they also want to enter the percentage in the field directly. And then click Apply and change a dollar field or still click a number button like before. I have buttons with script parameter of 10, 15, 20 etc. attached directly to the Apply Discount script. apply script would look at gDiscount (global text) and if it's empty, just use script parameter instead but if it has a value, use it instead. Make sense? Modifying a prior calculation given me, I've come up with this. Oh please don't…

I have a solution where I would like to track the number of hours, minutes, etc. that a user is in my system. I have the following fields that are trapped at solution entry and exit: Logfile_Action_Start_Time Logfile_Action_End_Time Can anyone point me in the right direction of creating a caclulated field to do this job. Many thanks!

What is the correct function to put in a calculation field(Field2) that will extract the first letter from each of two words in a name field (Field1) that has a first and last names separated by a space? Example Field1 = John Doe; Field2= JD. Help please

I've been playing with ideas to find customer names that are similar. This is because we have many duplicates. Pattern Count doesn't work, ! doesn't work. I need something that finds similar ones that someone can then find to manually compare. I've been playing with using Filter. It seems to me that if two fields are compared and contain the same letters (most of them) that they might be the same. I attached my play file. Am I on the right track here? Can anyone see what my thinking is, and would something like this work? Or maybe I should include their address also, although someone could have moved. Any ideas to help me find similar names would be wonderful…

I have a need to take a Age Calculation and convert it to a School Grade Calculation. For Example 5 years old would show 0 for Kindergarten 6 years old would show 1 for First Grade 7 years old would show 2 for Second Grade. I tried to copy and paste my age calucation into a text field that had a case function tied to it that would convert the numbers to the grade level...but my age calculation doens't have whole numbers.. it shows for example 5.888111119. I have looked at the round function trying to get it to round up but that doesn't really round the number up it only displays it as rounded. This is my age calculati…

Hello all. I am trying to get our staff members to consistently enter data into a particular field (tentatively titled a "NOTES" field). They have been less than compliant in doing so. What I would like to do is make this field mandatory - like in an HTML form. Is is possible to not let the user exit a record until completion of a field? Or at the very least can some sort of an alert button be activated instructing the user to complete that particular field? I am relatively new to Filemaker and would be very grateful for the necessary steps to make this happen. Thank you.

Post deleted by mfsmall13

I have two tables, Matches and Goals, with a MatchID relating the two. One of the match layouts needs to display the match details (locations, teams etc.) which is easy, but is also required to display the score. The Goals table holds details of the MatchID, TeamID, Player who scored and the time. I'm assuming I can place a calculation field into the Match table to tell me the number of related records from Goals, but I don't know where to start. Also there is the added complication of Teams. The Match table includes the TeamIDs of the two teams playing, so the calculation needs to know which team scored the goal. Can anyone help? Thanks

I have a simple database with students. They each have a unique ID number. They each have a Country of Citizenship. On my layout I have Total Students as a Trailing Grand Summary. How do I also list Total Countries at the end of the report, so it will list total distinct countries? It should be about 87, and the total number of students 1173. Please try to reply in basic English, since I'm learning as I go and I'm self-taught. THANKS! ~Erin [color:"green"]

Hi, I know I've previously posted a time formatting question, but for the life of me I can't get it to work the way I want to. In Access I was able to format the time so the user would time four digits (####), and the time would format ##:##. I can't get that to work in FM Pro (so far, that's been the only thing I can't get it to do vs. access). I've tried everything, I thought it would be as simple as choosing the format (military time), and the separater ":". Right now when the user types in "1515" it will format as "1515:00". I really, really want to stay away from having to manually type in the colon as it's a annoying and time consuming keystroke (the u…

Okay I have File1, File2 and File3. File1 and File2 are used to record two different but similar types of data. Depending on inputs on File1 and File2, users maybe required to reenter data into File3 for reports that combine File1 and File2 Pertinent Data. Not all of File1 or File2 Data is required to be entered into File3. Obviously my users ask, "Why cant the pertinent Data be auto copied to File3?" I have a script where if the Data in a particular field of File1/File2 is the required data for File3, then File3 opens and the user is required to enter the info from File1/File2. My users want that when File3 is opened that pertinent data which they just ente…

I have 2 fields, test and test2. Test2 is a text field I use for input (or a number field, it makes no difference to my problem) Test is a calculation that returns a number with the formula TextToNum(test2). I want to see if test2 contains a numeric, if not I expected test to be blank. It works as expected except when test2 contains no numerics and starts with the letter f, n, t or y. Upper/lower case makes no difference. If test2 starts with f or n, then test=0. If test2 starts with t or ty, then test=1 I can figure out a work-around, but this bugs me. Can anybody explain what's happening? Please? Pretty-please? Thanks

I have the following fields: name, street, city, state, zip I have a relationship tied to a customer file with the customer name in both databases as the relationship. I also have a relationship to a zip database. Is there any way I can have the fields autofill if the customer numbers match but if there is no customer number or match, be able to have the zip code relationship fill in the city & state? I know I'm trying to have the city & state fields have 2 relationships. Not possible?