Calculation Engine (Define Fields)

Ok, I'm sure this is simple, but I am having a hard time coming up with the proper calculation to add feet & inches. Any help would be great.

How can I define the number of text characters that can be entered into a defined area?

Okay, I'm really frustrated.... I want to auto-enter the current semester into a field, given semesters whose dates are defined in an If statement. For example, if today is between 8/13/01 and 12/20/01 then the semester is "Fall 2001." This is my code: If(Today>08/13/2001 and Today<=12/20/2001,"Fall 2001", If(Today>12/20/2001 and Today<=05/15/2002,"Spring 2002", If(Today>05/15/2002 and Today<=08/12/2002,"Summer 2002", If(Today>08/12/2002 and Today<=12/18/2002,"Fall 2002", If(Today>12/18/2002 and Today<=05/14/2003,"Spring 2003", If(Today>05/14/2003 and Today<=08/11/2003,"Summer 2003", If(Today>08/11/2003 and Today<=12/…

Yes, it's another newbie question to find some similar Access function in FM!!! 1) Is there such a thing as "tool tips", you know it's the text info that you get when you leave your pointer over a button for a period of time and this little text box appears. 2) Is there a way to attach scripts to events, like when you enter or exit a field, when you change data in a field, etc. Thanks for your advice --Dan

Can a PDF file be placed by reference into a container field? I'd like to use Filemaker to catalog and access images of documents. Since PDF files are consistently smaller than BMP, GIF, JPG, or TIF images, it would be ideal to be able to stash PDFs by reference into a FM database so that users of the database could click on the field and have the PDF document display.

Hi, I'm sure someone has answered this query before, but I have FM5.0 and I would like to run a script that either removes the first word of a text stream or conversely, adds a (the first) word into an entire column. Thanks for the help. Rick

My principal address book in FM 5 for Windows started as a db in FM v 1.0 for Mac. I have a Barcode field which worked with free Postnet barcode font for the Mac years ago. I now want to get this going again on a W2K machine. I downloaded a sample Postnet barcode font pack, and when I use it, I get a "thin vertical box" at the end of each printed barcode. The following is the calculation formula which I had left over from days of old for HoBarCode field: If(Length(HoZip)=5,"I"&Left(HoZip,5) & HoCorrectionDigit & "I","I" & Left(HoZip,5) & Right(HoZip,4) & HoCorrectionDigit & "I") The formula for HoCorrectionDigit is: Right(100-(Middle(HoZ…

Here's a problem I'd like to solve with FM. Imagine you have two databases. One contains a list of, say, zodiac signs. Each record would contain a sign like capricorn and the dates that define that sign. Another database contains a list of people and their birthdays. I'd like to write a script that goes through the database of people, and adds to each record what sign each person belongs to. Can anyone think of a way to do this?

Hey, I am the administrator of an FM database that keeps track of photo assignments for a newspaper. One of the fields is "Film Type" which records the type of film that the assignment was taken on. If we receive photos from an outside source, the field is "Courtesy Photo." If we run a photo from a previously shot assignment, the Film Type is "File Photo." I want to make the field that usually records the photographer's name (called Photographer) that needs to return "File Photo" or "Courtesy Photo" depending on the data entered into "Film Type" I can get as far as entering the film type into the Photographer field. However, there is a twist... It also needs to a…

Hi, I'm trying to figure out how to calculate a date by adding a certain number of days. For example I have the fields: ship date (date field) terms (number field) - user would put "30" for net 30 payment due date (date field) I've set up the payment due date field as a date field which auto enters a calculated result. I want the calculated result to be the ship date plus the terms. e.g. if ship date is "3/1/2001", and terms is "30", the payment due date would auto-enter "3/31/2001". The payment due date could be overridden if other terms apply or if the "terms" field is left blank. I have not been able to figure out how to do this, as I've never real…

I have a database that has over 300 fields (U.S. Census data). I need to start querying this data, but in table view it only shows about 75 fields. Is there a limit to this? It will show them all in other views, but not the most important table views. Does this make sense? Also, if you can give me a couple pointers on how to query this data, that would be great! Thanks, Don Madill

I want the find the number of days between two date fields (start date and completed date). I use DateDif in excel, what is the FileMaker equivalent?

i hope this is not a "Dumb" Question. I have 3 files Contact, Pricelist and PO In contact I have a fields name, ref, address, etc In Pricelist I have Product Name = Text PartNo = Num ACustUSD = Num (price) ACustSGD = Num (price) BCustUSD = Num (price) BCustSGD = Num (price) In PO, i have Currency = value list "USD","SGD" CustomerName = Name in Contact PartNo = PartNo in Pricelist Value = Num here is the question. I will choose the Currency. eg. USD Follow By the CustomerName. eg. CustA Then The PartNo. Eg. Gear I need to show the price of the product for that customer in that currency. Value = ACustUSD in pricelist How do i go abo…

I have a defined values list of numbers 0-130 and I don't want to scroll through it to find a number,(The field is currently formated as a pop-up menu) I want the entire menu to show on the screen when I select the field. How do I do this ? I have the identical program on two different computers, one scrolls and the other shows the menu. Please help Thanks Phil [email protected] [ October 12, 2001: Message edited by: Phil Minnella ] [ October 15, 2001: Message edited by: Phil Minnella ] [ October 15, 2001: Message edited by: Phil Minnella ]

I don't really like using the LeftWords and MiddleWords functions, but they might do the trick in this case. The proviso is that the word you want to eliminate is always at the beginning of the text FormattedBandName = Case( LeftWords(BandName,1)="The", MiddleWords(BandName,2,200)&", The", LeftWords(BandName,1)="A", MiddleWords(BandName,2,200)&", A", LeftWords(BandName,1)="An", MiddleWords(BandName,2,200)&", An", BandName)

I want to build a Calculation field which will look at another text field and extract (ie return) all upper case words of more than one character length found in the text field, and present the returned words as comma-separated. Eg: AKYAB, CANARA, COMORIN, INDIA Can anyone help? I am really stuck on writing the script for finding upper case words John

OK, I know this a really easy answer, but I'm having a hard time figuring it out. I have a numeric field and am using a calculation to return the first 7 numbers of another field (using: NumToText( Left(Record Number,7 ))), I would ALSO like to add two random or increasing serial numbers to this field. How would I do this, is there a function for it? Thanks!

Is there something similar to the Access "input mask" in FM?? I have a date field, and would like to display dd/mm/yyyy while the field is null or empty but enable the user to type a date without the need to type the " - " or the " / ". Microsoft Access has something called input mask(to control how data is entered and stored)which is different then field format(to control how data is displayed), is there such a thing in FM Thanks for the help --Dan

i'm trying to calculate the value of a field in a new record from the value of a *different* field in the previous record. essentially, i'm trying to track something from day to day, and my calculations of one field involve the change from previous day's value of another field. and i'm trying to do it automagically when the new record is created. so Field1 = yesterday's Field2 - today's Field2 i can't get my head around the relationship/portal thing in this case, or figure out a script that would do it in an auto-enter... any ideas?

Help..I have tried but failed. I have a database for a videotape library using Version 5.0 on PC As well as client,title, duration etc it has two key fields. "Master Number" and "Reel Number" These fields are defined as numbers. There maybe an entry in "master" but not "reel", vice versa or no entry in either. When I add a new record to the database, I want to find the highest value in each field, add 1 and create a new record placing the calculated values in the appropriate fields. I cannot figure out how to store and retain the value of each find. Can anyone help. Regards, David Barrett Melbourne, Australia.

I'm trying to find a way to set some status fields, in particular CurrentNetworkChoice. I want to have a particular network protocol (TCP/IP) verified. If it is not TCP/IP. I want to set it to that and then have my script pop a message saying you will need to restart the application. That part is easy, as is the checking the protocol. But short of popping open the Application preferences, I don't know how or if I can script the network choice change. Any ideas???

Hello..... I'm new to filemaker pro. Using it for about 2 weeks now. just upgraded to FMP 5.5. I need to auto-serial a PO number Field. The Field have to look like XX##/YY/ZZ where XX = Cust Ref (Related by Custmer Name in Contacts File) ## = Year in 01,02,03 format YY = Supplier Ref (Related by Supplier Name in Contacts File) ZZ = Auto generated no. (+1) I can actually do this using 4 different fields instead of 1. But I believe there is a calca or Formula of some sort to achieve the same result. Pls Help me Thank you very Much

Hey kids. I need a calculation that will look at a date and return the Monday of that week. e.g. If date = 8/18/2001, WeekOf_c = 8/15/2001 I know that I can do this with a long Case statement, testing for which day of the week it is, then subtracting the appropriate number: Case(DayName(date) = Tuesday, date - 1, DayName(date) = Wednesday, date - 2, ... and so on but is there any other way. I like to keep my calculations as short as possible. Thanks, eh. Paul

I am very new to Filemaker...and have the 5.5 version. How could I calculate the current age of a person using the date of birth and current date? Is there any way to compare MMDD of DOB to see if it is >= to current MMDD, and then subtract the DOB YYYY from the current YYYY to get the current age? If the MMDD comparison is < could I take current YYYY minus 1 and subtract DOB YYYY? Or, is this impossible? Pam

The standard solution for global fields that apply to all users of a shared database seems to be to put the data in those fields into a related single-record database. However, retrieving this information seems to be hit or miss. When I Set Field (Global Field, Relationship::Regular Field), sometimes the global field in the main database is correctly changed to match the info in the related database, and sometimes it remains blank. I suspect that the related single-record database is in use simultaneously by another user; is this the likely problem, and if so, how do you avoid it? Thanks for any thoughts.

I have data that looks like this in FM: Name Number Bob 1 Bob 2 Mary 3 Mary 4 Mary 5 And I want to create a report that looks like this: Bob 1,2 Mary 3,4,5 Any ideas how I do this?

I'm a self taught FMP user. I'm using the Case calculation and my last entry told me "This formula is too long to be calculated. Break it up into two formulas". I don't know how to do that and if it will affect my data. Any help on this would be greatly appreciated.

I have a problem. I made a database to generate random passwords. The password field is a calculation adding eight letters picked by the calculation--Round(Random* 26, 0), this then is used to select a letter from the text string consisting of a...z. Just to check, I searched for duplicates and found two, but they aren't duplicates (qdgnnfkh, jrvqjrki), they aren't even close. Does anybody have a clue as to what is going on here? This is also posted in the security issues. (Since we don't allow duplicate posts, I'm closing this thread. Please respond in Security Issues. -bd) [ October 01, 2001: Message edited by: LiveOak ]

I've created a solution for a customer, but won't be able to spend any time with the users. I'd like to create a tutorial to walk them through the database and to show them all the neat nooks and crannies I created. We'd like to use video (i.e., a camera facing my screen as I navigate the file and supply commentary and tips), but between the limitations of the camera and the limitations of the computer's screen we get a disheartening line across the video we shot. Some other thoughts: 1) create a script to move among the fields and layouts, limiting interaction to a click of a "continue" button when done reading each page; 2) take snapshots of appropriate layouts to p…

I have two fields, Entry Date and Pay Period. When a date is entered in the Entry Date, I want it to look at a specific range of dates in a value list and decide which Pay Period it belongs in. (Is using a value list the best way?) Here is an example Entry Date: 1/20/2001 Here is an example of the value list: 1/1/2001 1/14/2001 1/27/2001 Here is the result I expect to see in the Pay Period field: 1/14/2001 I'm using FMP 5 server for both Windows and Macintosh users. Thanks for any help......

I don

I'm too new to know the correct terms, so I will try this in plain English. I'm doing a rather large project, I've kept it simple, but have ran into a stumbling block. Each store has inventory, each store has it own file However from time to time someone will run out of an item, and need to do a quick search to see who else may have a particular item. How can I do this? They way I have it roughed in now is: A Main file that is more a less a menu that links to all other files One file that has part numbers with descriptions of the item Each location has an inventory, that pulls it's descriptions from the first file I think it's called a "key" the field that t…

I have a list of teams, each with points gained from a competition. Is there a way to calculate a ranking field, when the teams are sorted by points? Important: Two teams with the same points should be on the same ranking. Example: team A has 220 points, team B and team C have 180 points, team D has 170 points. So team A is on place 1, team B and team C are both on 2, team D is on 4. Thanks for Your help Gerd

How do I provide the handle for x button on the show message box,it tends to execute the option 2 if no handle is provided for it.Its suppose to close the message box. Thank You

My goal with this calculation is simple: shipping charges are accrued based upon the subtotal of the purchase. Unfortunately I've spent too much time working on this one to be able to see my mistake. Here are two ways I tried: If(One Subtotal <= 40, "6", If(One Subtotal > 40 and One Subtotal <= 75, "8.50", If(One Subtotal > 75 and One Subtotal <= 100, "10.50", If(One Subtotal > 100 and One Subtotal <= 150, "13",If(One Subtotal > 150 and One Subtotal <= 200, "15",If(One Subtotal > 200 and One Subtotal <= 10000, "17", "200")))))) Case(One Subtotal >= 40, "6", One Subtotal >= 41 >= 75, "8.5", One Subtotal >= 76 >= 10…

We have recently upgraded from Filemaker 2.1 to Filemakerpro 5 using Macs. I am trying to convert old databases to make use of some the functions of the upgraded programmes. In particular I have been struggling without success to 'create values dynamically from a subset of values in another field'. Has anyone come across a fully worked example of how to do this? One of those with screengrabs of the screens that you need to work through? I have tried following the instructions in the Users Guide and the help files but get stuck each time. I have looked at some of the postings here but can't find one that works for me What I am trying to do is: I have a field called…

I have to specify a lot of message on the show message box,is there any way to set the size of that box as it resets to the default size. Thank You

i'd like my file to have a field for a running total (i guess it's called "running"?) of all the records in the file. so if i have currently 50 records then every record will have a feild showing the number "50". and if i create a new record that feild will auto increment by 1. how do i do this? FMP 5.5 OS X thanks in advance.

I am new at this!! I am trying to create a database where if I type a code into one field, a statement appears in another field. Example: if I type BE3 in one field, the statement "Is very well behaved!" will automatically appear in another field. I don't know where to begin with this. Can anyone help me?

I have a text field that has over 10 lines of data. It is a list of activities. Is there any way to format this field to display in two columns.

In creating a new database I have a field "item number" that is related to the data database. The data database has individual records that include the item number and the item color. In the new database I would like to have it drop down a value list of the colors of the particular item number entered. I can get it to reference all the colors in the item color field as a value list but those colors are applicable to all item numbers. I'm wondering if it's possible to only pull up the colors that are the colors of the item number. Thanks in advanced. This place is rapidly becoming my favorite place on the web. Kukuberra

Hopefully there is a simple solution to this one! I have set up a scientific database which is relatively complex in that from 15 locations, 3 plant species were studied. For each 3 plant species, 10 samples were taken. On each sample a number of different organisms were identified. The organisms were often repeated on each sample. The location name, plant species name and sample number were all combined to provide a unique name. I now want to be able to view a list of what organisms were found on what plants, but can not get the data to another file without getting repeated data where the same organisms have occurred on the same plant types in the same locations. …

I am working with a quote database where the particular quote could have special instructions if the item being shipped is extremely heavy, tall or wide (it's for a trucking co that hauls huge pieces of cargo). I have created a field that includes 3 choices as checkboxes (heavy, tall and wide) and if the particular item is heavy and tall, I am trying to get a paragraph of text instructions to print out at the bottom of the quote. One paragraph would be for heavy item instructions and the other would be for the tall item. Problem is that when I check both boxes, heavy and tall neither paragraph prints.

Hi folks, I'm brand new to FM. In fact, I'm justing using the trial version now to see if it can do all that I need it to. I'm making a element library, which has 3 fields. Field 1 contains the project number, which is entered manually. The same number will be entered into this field on several records, depending on how many elements there are for each project. Field 2 contains the element number, which I'm using the serial number function to generate a unique number for each individual element in the database. The 3rd field is the one I'm not sure how to do. What I'm looking for is a field that will count the number of records relating back to that records pro…

This is a rather specific, yet fundamental question. I am creating a diagnostic photograph CD using FM 5.0 on a Windows platform. What is the best (i.e. file size, speed, etc.) way to go from viewing thumbnails, to viewing full-size photos? Currently, I have a Thumbnails layout and a Full-size layout composed of a global "LargeGraphic" container field. I have scripted the thumbnails so that its full-size counterpart will be pasted into the global "LargeGraphic" field and they will view it in the Full-size layout. The problem is when I burn my CD, the global "LargeGraphic" field can not be rewrited to, therefore, the photos don't change. Is there anyway I can solve this pr…

I have updated to version 5.5 from version 5. Some Calculated Fields do not seem to work the same way. In version 5 with the Option "Do not evaluate if all referenced fields are empty" SELECTED, the result is DIFFERENT to what happens when I use version 5.5 on the SAME file. Has any body else experienced this problem? I have found that the same problem occurs on both Mac and PC

I have a file of orders. I have a second file of ordered items. The ordered items records have a orderID which is matched to ID key in the orders file. I need to display a count of the number of items in a given order. So if you order 3 pieces, and if I am looking at one of the pieces you ordered, I need a field to tell me how many other pieces you requested with the item I am viewing. Basically this just involves counting the number of other ordered items with the same orderID and to put that into a calculated field. I can't think of how I would do that... Thanks. I hope this isn't totally dumb. -wald

I've set up a database that embodies a tree structure and I want to propagate a value in a field called "Enables" down the tree through a calculated field that I've called "Owner." I set up a relationship called "Parent" from the database to itself that matches each record with its parent in the tree. I try the following recursive definition for Owner. if(Enables > 0, Enables, Parent::Owner) Filemaker Pro tells me that this definition is circular, but it's not. What gives?

I am an exteme novice at FMP and have a problem. I tried to correct a layout issue and instead I seemed to have "deleted" the second address for our 1800 member mailing list. Is is possible to get this info back? I changed the layout and need to add new field parts and can't seem to do this in the body. I'm lost, any suggestions? Thanks so much. Heidi

Could someone help me with the method to restrict individual records from a user with a certain password in FM 5.5. How does the calculation look? thanks much

Hello, All! I have a field which has a pop up list, that contains 3 items: AB CA GA I want the field background color to change according to each item, whenever I choose it. Is this possible? Should I make a script? Tks!

Hello, I have some fields which set cannot be empty, strict do not allow user override validation. Because they are very important. But, during user enter record, they sometimes need to go to other database and find data. My validation rule make them so inconvinience because somehow they cannot go elsewhere unless they fill out the required field or delete the record. Please help. Damon

Hello: I am putting a run-time db on a CD. I want to have references to pics and include the images on the CD. I need some suggestions on how to place the images with the CD's path. Is there some place that stores the path info that I can get out and change? Currently, I am using an applescript to import the references, and I don't want to import the actual pics into the db. Here's what I tried: I created a CD that has the same path as what the image path would be on the final cd. Then when I made the run-time app, I included the images from the CD as the same path on the new CD. This seemed to make the Mac play nice, but not the PC version. Any suggestions? Th…

Is it possible to create fields in FM 5.5 that when I transfer them to my Palm, just by tapping them increases the value of a variable assigned to this field? Thanks in advance Pablor (This is a duplicate post, which we don't allow. I'm closing this thread, please answer in the FM Mobile forum -bd) [ September 15, 2001: Message edited by: LiveOak ]

Is there a way to mask the data being entered into a field? The best example is when Filemaker asks for a password on a file startup and masks the password being entered. I imagine that you would create a calculated field and place it on top of the field you want to mask. I am not sure what the calculation would be for this field... Any help would be greatly appreciated!!!

Hello, I'm just getting started in Filemaker. In Field X I'd like to capture the date that Field Y first takes on a particular value. I thought I could do this with a calculation, using this IF function IF (IsEmpty(Field X) and Field Y="particular value", Today, Field X) But I'm not allowed to do this because the function references itself (circular reference). I'd sure appreciate any help or pointers. This seems like it should be easy but I can't seem to get it right. Thanks in advance, Marc

Does anyone know a way to import a folder of images into container fields faster than entering them one at a time? I can't figure out any way to add an image to a container except by import Picture dialog box. It would be great If I could just have it load the image according to the image name in the image name field. Any solutions that anyone is aware of?

I've done a search, and have done what I can, but seem not to be able to figure this one out myself, so here goes... I need to convert a date input into the two digit fiscal year... So if I input 9/13/01, a calculation is done... greater than or equal to 7/1/01 and less than or equal to 6/30/02 then the field gets "02" as the fiscal year. Can anyone help me? I'm just not getting the calculation at all. Thank you!

I need to set up a calculation in my AppleWorks Database that is the equivalent of the following formula in FileMaker: If(IsEmpty(Man's First Name),Woman's First Name, Man's First Name & Case(not IsEmpty(Woman's First Name), " & " & Woman's First Name)) Any help? Steve

When I move the quite large "Define Fields" dialog box in order to see the fields beneath it (which I need to look at so that I can use them in a complex calculation formula), the screen doesn't repaint the screen with the fields that were there before I opened the dialog box. Just a big, empty white box remains where the dialog box was. I can't simply reposition things so as not to have the dialog box get in the way because I've got to have a couple of browser windows open at the same time. Very inconvenient. Can anything be done about this other than to modify the app code (which definitely needs to be done!)? Thanks.

Q1:Thanks, BD, for your advise about storing scanned data, now the question is how to convert the data already in scanned to a file that could be referenced. Do I have to rescan allll those pages or is there an way to take the data in the containors and convert them into images that could be placed into a non FP file that could be referrenced by the FP continor files. Q2: I got lost regarding your description of the location of the reference file on the server. You suggested getting a second server for the image files alone. Is not my current G4 hosting FMP-server adequate if the hard drive and ram are maxed out, with the guests being other machines (I mac, G3, G3 pow…

i have a client ID field that i want to automatically increment by 1 for each new record... i believe i filled out the options in define field just fine. here's a what i don't get: i manually typed in the first ID (001) in the first record... then i expected to be able to flip through the remaining records and find oo2, 003, 004, etc., but they were blank. how do i "make it so"? thank you. theaxis

A1: There is a HUGE advantage in storing just a referenced and not the whole image. If you store the whole image, your file will grow by the image size with each image you store. If you store just a reference, the file will grow very little with each image as only the path to the image is being stored. The image is converted and rendered on your screen "on the fly" and "as needed". To use this approach, the images must be stored on a network volume accessable to all of the 10-20 FM machines. The volume must be mounted on these machines and all must have privileges that allow access to the volume. This is easiest if you have an additional file server running say, Windows N…

Like many rookies, I've let my mocking bird mouth over load my humming bird rear! My better half has a Excel spread sheet that should be a DB (12.5 meg file) After giving him a "hard time" about it, I now have the job of making the DB. Now here is the problem ... NORMINV this is an Excel function, any idea how I can do it in FM?

I'm such a newbie, I don't even know if I'm posting this question in the right forum. I scoured the documentation and the web for a solution, and have dissected every file I could get my hands, but to no avail. I conducted a survey (in meatspace, on paper) and have made a Filemaker file with a record for each respondent. I need to summarize responses to multiple-choice questions, e.g. the number of respondents who chose "B" in a given question, and what percentage of all the responses that represents. This is easy to do if you want to get an average for a numerical value, but how do I do this with non-numerical values? Here's a real specific example. This was a surv…

I have a problem with reverting a field fill color back to "none". Once a field color has been set to a particular value there appears no way to reset it to none. I have even tried deleting the field and adding it back to the layout but FM appears to have defaulted fill color for all new fields to the previously selected color. Anyone have a way around this. I'm using FM Pro 5.0 Thanks

I am using a calculation with a field mask to display a SSN properly formatted. I have found that SSN begining with zero do not format properly and a number is added in (ex.012346789 displays as 123-46-6789) What am I doing wrong here? SSN field is formated as text SSN Mask field is formated as a Calculation with calculation result being text (this is the only way I didn't get some funky formula while tabbing through the record), and the calculation is. Left(Abs(SSN), 3) & "-" & Middle(Abs(SSN), 4, 2) & "-" & Right(Abs(SSN), 4) Thanks in advance!!

Hello--I am new to FileMaker (from Excel) and am trying to set up a function (I believe) that will tell me someone if a member. For example: I have a membrship database where under "Member Type" I have set up 5 radio buttons with our different types of membership. On a differnet layout I want to track those members (and others) who attend our annual conference. On the 2nd layout I want to put a field that will look at the "Membership Type" field and return a "yes" if one of the radio butoons is clicked or a "no" if none of them are clicked. What is the best way to do this? Much thanks, in advance!

We have this date field which is a calculation. If the reference value is earlier or equal to a certain date I want the field to be blank (like if I manually deleted the data from the field). How is this done?

I am not a programmer and don't know if this is possible but presume it is. Can someone tell me how I can take the alphanumeric contents of a field (let's say the word, "possible") and create a new field with the spelling reversed, i.e. "elbissop". I don't know enough about Filemaker to do this but I know a little about the program. Thanks.

You can check the day of the week using a case statement. You could script this and insert this calculation upon submission or use it as a calculation. seven_bus_days_later= Case(dayof week(date_submitted) = 1, date_submitted +9, dayof week(date_submitted) = 2, date_submitted +9, dayof week(date_submitted) = 3, date_submitted +9, dayof week(date_submitted) = 4, date_submitted +11, dayof week(date_submitted) = 5, date_submitted +11, dayof week(date_submitted) = 6, date_submitted +11, dayof week(date_submitted) = 7, date_submitted +10, "" ) Does that help?

i have created files for suppliers, products and supplier_products. in the supplier_products file i want to restrict the data to only 1 instance of supplier and product. ie i want to create a combined primary key of the foreign keys supplier_code and product_code. eg supplier_a,prod_a supplier_a,prod_b supplier_b,prod_a if the user enters supplier_a,prod_a again i want an error to occurr due to file validation. if that makes any sense to you i would appreciate your help.

Is there a method for revealing the IP address of a web browser client and enter that data into a "IP Address Last Modified" field data when a record is edited through a web browser?

I have a field which includes websites and url's -- some of these url's are very long. Without a space somewhere in it, FM sees it as one long word. When I export the database to a table format, I end up with one very wide field, trying to accomoodate this long "word". Is there any way to force this to wrap or something? With 4,000 records, I shudder to think of visually going through one by one and adding a space in the middle of each url! I tried html width tags, but it doesn't care....

Not sure if this is the correct place for this - apologies if not. Could someone please help with following problem – I am new to Filemaker & attempting to put together a database. If I sell 3 different items to X today, I have details in my database. I want to create an invoice, sum them up & add postage – how do I do it? This is a run of the mill type query / report in other databases I have used but I cannot get it to happen correctly in FMP5.5. I do Find for X in the customer field & today’s date in the date field, which pulls out the 3 requested records but my problem is that I cannot place them together in the body of the record – what I am getting …

This must be a very easy one but I just can't seem to figure it out. I only want the field to be calculated if it's empty, so if there is a result already it should not calculate again If (field1=field2;result 1;don't change current field value) Thankyou so much for helping me out

A reply to any of the following questions or a No this isn't possible would be equally as valuable as no replys ----- I am developing a letters and faxes database and have hit three fundamental problems with text formatting, can anyone help with them or one of them? 1. I am using the merge field option on my labels format in the address book. The labels look fantastic until somebody changes the font size in the originating field. This causes all of the text to be formatted as it was entered and not in my default merge field text font. Is there any way of disabling the font type and size? I have been unable to do this with access privilages. 2. I have a calculatio…

I want to automate my past-due invoice notification system. It seems to me that when I give a record an invoice date, I could also perform a function that would define, in 4 other fields, when 30, 60, 90, and 120 days have elapsed. Problem is, I don't know how to calculate "30 days in the future from June 30, 2001."

I am using the Open URL to open Outlook / Entourage and have the email already complete and ready to send. The question i have hard returns. In my email, i will need something to appear on one line then have returns and stuff appear down here The body is a calc field made up of various other fields, and when i open the URL the "

Hello, a question for user of Foreign language FMP (in fact, mine is in French). I use the MONTHNAME() function (NOMMOIS() in French) and get the result in English dispite my version is French. Anybody has an idea how to get the correct response ? THX Y. Savonet

Count (Jobs by Company::iOne) The count of the Jobs by Company relationship will return the nunber of jobs for the company. You can then either add 1 to that number (if the new job record has not yet been created. However I strongly suggest that you do not use this kind of scheme for generating a job number. As soon as somebody deletes a job, you are screwed. You could store a seperate Job Counter field in the company database and simply increment this number each time a job is entered, this way you know how many job have ever been entered and will not run into a problem if someone deletes a job record.

Hi, I set up fields through which local (non-FM) files can be activated with the contextual menue (FM4). Although it works fine on Macs, my colleague cannot activate files (located on his own disk) the same way on his PC (Win 98). Strangely enough, when the PC file path entered in FM is copied in a Word document, files can be accessed from Word on the PC. The url.dll file is present. By the way, is there a simple way to have files accessible remotely from both PCs and Macs despite the fact that file paths are written differently in the two platforms ? (whithout making a web server). Any solution ? What is missing ? Thanks for any advice. NB: I posted this questi…

I have an application that has a text field called Narrative where we enter a block of information. For some reason the cursor starts in the middle of the input field. I have deleted/ renamed inserted another field with a different name. Each time I have the same problem. Another text field previous to the narrative field works ok the text start at the top of the field.

Hello All, I have been wroking on one problem for a few days now and don't know where else to look so I am hoping you guys can help me figure this out. I have a pop up menu called Priorty it has a valuse list of 1-5 What I am trying to do is get each one of these numbers in the field or the background of the field to be a differnt color to denote the importance of the issue i.e. 1=red 2=orange 3=yellow 4=blue 5=green Thxs in advance Dave

I have had a database created for me for my jewellery design company and I am trying to add another function to it. You will have to bare with me as I know very little of this program especially when it comes to writing calculations. I'm a designer not a wizz kid!! Basically alot of our jewellery goes out on Sale or return basis, and is very important for us to keep an update of our different stockists stock levels. Our filemaker pro database is set up as Line Items / product lines / invoices / delivery notes and customer database. For any one stockist we send delivery notes and raise invoices on items they have sold at the end of that month. In line items I have …

I have not used FM yet but am considering a purchase. Can anyone enlighten or persuade me to do so? I am a teacher and need to hold IT records for a few hundred pupils. I typically collect a class of 30 digital photos at a time and rename them using Thumbs Plus. I would like to combine the pictures of the pupils with test data and IT records which are currently kept in Excel spreadsheets. Is FileMaker an easy product to set a DB of this type? I have struggled with linking photos and DB files before. I suppose that I'm looking for a DB that is extremely easy to setup to import Excel data and Jpegs. Does this exist and,if so, is FileMaker the product?

Can I perform a calculation with the result being a different text format? Example: if a test score < 70 can the result be, format the text in Red, and all values equal to or greater than 70 be displayed in Black. Help! and Thanks in advance for your answers!

I am doing a calculation field that combines the fields Name, Address & Phone with a tab between the address & phone. Is there a way to retain the styles of the individual fields in the calculation field. Example: The Name is 7 pt. Bold, the address is 6 pt. and the phone is 6.5 pt. bold. Thank You.

Hi all, I am the administrator for a newly created database being used to track photo assignments for a newspaper. To this point, i've used the auto-enter unique serial number function to generate a unique, issue-specific number to identify each assignment. The serial number was the volume number, the issue number, and the assignment number (being the next logical number (.01, .02, .03, etc)) all separated by a period. when editors would need to start making requests for the next issue, i would modify the serial number in the field options to reflect the new issue number and reset the assignment number at .01. My system has now reached a flaw. If a section editor ente…

When I write this simple subtraction 128.28 - 128.27 The result is not 0.01 But 0.0100000000000051 I can indeed round the result to 2 decimals, but I don't understood why FileMaker give this wrong (strange) result. Has somebody read something about this ?

I am new at filemaker so I hope I explain my problem correctly. I have one database with multiple layouts - I have a time billing layout in which to book the employee, hours, activities, I know the calculation to set it up so that depending on what activity is chosen the cost is calculated. My problem is I am not sure what field to attach the calculation to. I need the result to to be in a generic field on the time billing layout but also depending on what activity is chosen I need the result to appear on the production layout in the appropriate activity costing. So for example Employee A worked 2 hours writing on a specific docket (all the layouts are linked by Docket…

Hello folks, I have a complex calculated field that works on Mac's and doesn't works on PC The calculation is: If(CT_SP = "" or #Opera

I ran into a problem that I am not sure what is causing it. I have a global field that has a popup list attached to it. Once a user makes a selection from the popup list there is a button/script they click to process the selection. This works great in Browse Mode The problem comes with going into "Find Mode". The global field will not drop the popup list down when clicked on. Is this normal behavior for global fields? TIA Craig

Im not sure if this can be done but here it goes. I have a field that has a pop up menu. What I want to do is have this field lock after someone has selected one of the items in that menu. I dont want users to be able to alter the field after the record has been created. Any help would be greatly appreciated. Thanks, in advance.

I have a field called “Diagnosis” The field is check boxes so users can choose all that apply for a given consumer, e.g. “Cerebral Palsy” “Retardation” “Traumatic Brain Injury” etc… I would like to create a calculation field that will list all checked box values for a record separated by commas to save space on a data sheet layout. “Cerebral Palsy, Retardation, Traumatic Brain Injury” Thank you.

I am currenty using the open URL script to bring up a movie but of course it opens up internet explorer then either puts a plugin in windows or a seperate window on a mac. Is there a way to tell Filemaker to do an open URL in Quicktime Player. Of course Cross platform

First of all sorry about the long post but here goes. I have a customers DB and a Tasks DB. Customers DB has two portals "past tasks" and "future tasks" I used the "smart ranges" technique (http://www.onegasoft.com/articles/smartranges/index.shtml) and it works fine. But I would like to see only the past/future tasks regarding the current record (customer). In order to do so I need to add customer ID to the already complex multikey. That's exactly where I need help. My customerID is in this form (CuID1,CuID2...) Here's the calculation field for future dates portal in the mainDB: Substitute(Middle(" 0 1 2 3 4 5 6 7 8 9"; (Int(Mod(Date; 10^1)/10^0) + 1) * 2 - 1; 20); " ";…

I have a mid size db that I have been using for about 6 years. A while ago I realize that some old records start to loose some info inside fields that werent blocked. Could these be caused by unproper shutdowns?:. If you dont think that, what else could it be? Thanks

HELP!! I had used FM for 2 years before I stumbled across this little time-saver, now I can't find it again. I want to click on the title of my field and have the column auto-sort. This MUST be an easy, basic task, but I've spent the last 2 hours with the FM book in my lap, and the onscreen help open......I gotta tell you -- it's NO help. Jane

I am really a trained graphic artist, and not a filemaker expert, but have been charged with a simple move from paper to computer generated invoicing. Inventory files, etc. are obviously infilemaker 5.0. What I WANT to do is use a pdf or jpeg copy of the paper documents as a background to layouts, and place the fields on top of the proper spaces. The users are not comfortable with using computers, so we'd like to make this as close to their paper experience as possible. Firstly, I cannot even insert a picture, because I get an error 2804 re: Claris xtnd system -- and when searching for tech docs, I only find references to this in 3.0. Can I get to what I want, or do …