Calculation Engine (Define Fields)

I am attempting to write a script to export pictures in FM7 and have not had luck. Would anyone be willing to write the script steps that would export x number of pictures (found set) to a file and include the data from the additional fields? The help section on Export field contents script is very limited. Thanks, Dave O'Connell [email protected]

I need to track stages of a project. For each step, I have a "completed by" field and a "completed on" field. When a person enters their initials in the "completed by" field I want the date to auto enter in the "completed on" field. I can't figure out the calculation. I searched the archives but didn't find an answer. Thanks in advance for your help!

Hello I have 10 fields called "ago1, ago2,ago3,ago4, ago5, ago6, ago7, ago8, ago9,ago10" I would like the information in each of those fields to be THAT number of records prior's information. In other words- if I have 11 records and the content of those records sequentially was T45,A88, D11, J10, J9, A44, B22, B16, C43, E55, A12 Then Record 11 would contain A12 and on that record there would be a column of fields and they would be as follows ago1 = E55 ago2 = C43 ago3 = B16 ago4 = B22 ago5 = A44 ago6 = J9 ago7 = J10 ago8 = D11 ago9 = A88 ago10 = T45 Could some of you give me ideas on how to do this efficiently. I would like to be a…

I don't know why this is eluding me, but right now I have two fields field1 = number and field2 = number Is there any easy way, for every new record, to have field1 set to the value for field2 from the previous record?

Take text in one field, modify it by removing spaces or adding characters and then pasting results in another scrollable field on a new line. I have tried scripting and calc. without success.

I'm pulling dates out of the headers of e-mail's and unfortunately they're not all formatted the same. I have two fields, date received and time received and I need to parse each of these dates and times into those fields in a format that FM likes. Any ideas on the best way to do this. As you can see, they're all somewhat consistent, except for that second one. Also, i need all the times set to Pacific time (-0700) Sat, 04 Sep 2004 01:49:38 -0400 4 Sep 2004 05:48:39 -0000 Sat, 04 Sep 2004 01:38:42 -0400 Fri, 03 Sep 2004 10:15:17 -0400 Mon, 30 Aug 2004 03:05:56 -0400 Thu, 04 Mar 2004 02:08:52 -0500 Thanks

I was wondering if it would be possible to set a global to what criteria you have searched for. In the script, I put set field function but I have no idea how to connect what was entered in the field, due to it being in find mode, to stick around long enough to get it passed into a global. Any ideas? I have heard of some kind of store search criteria somewhere, I don't know where... but sounds somewhere in that area. What I have is a script that starts a search function, goes to a layout in pause, lets the user pick what they need, then go on to, show ommited, because we don't actually want to see what we searched for, but who doesn't match that criteria, then perform a c…

The price of an item varies based on the Date it was purchased. Field DateEntered = the date the record was created (purchase date) cSetPrice is designed to establish the price. I have tried lots of things, but this would seem to be what should work: Case ( Date Entered < 9/1/2002; 9.50; Date Entered > 9/1/2004; 11.50; 10.50) My guess is that the date is the probelm, but a search for < or > works fine on the date field. But the formula is not working. I am always getting the default. Apparently the evaluation is not working. The result should be a number. Thanks for the help.

I'm new to filemaker and trying to get a handle on it. When inserting a digital photo into a record, as a reference, a thumbnail is automatically generated and displays in the forms and list. I'd like to know where this thumbnail comes from. Is the thumbnail embedded in the .jpg file or is filemaker generating it when the image is imported? Further, if the original .jpg file is deleted or moved, the thumbnail persists in the database, leading me to assume it is stored in the database. I can't find any properties of the displayed thumbnail to determine it's size in pixels, or file size in Kb. I want my database to be efficient, so I need to control the th…

I have 4 fields, Date sent, Time sent, Date Received, Time Received. How can I find out the difference (duration) from Received and Sent? Thanks.

I have a field with a number value. I want to calculate those values into a percentage equivalent based on the highest number in the range. So I have these numbers: 117, 94, 55, 103 in the field "value." I want 117, which is the highest to be calculated as 95%. Everything below that would be calculated as percentages based off that startign point. 94 would be 76% and so on. How can I make this happen? Thanks for any help.

I have a jpg image that shows up as a negative when I print to pdf format (Mac OSX). Here's what's complicated: There are other jpgs in the database that make it to pdf just fine. They show up on screen in browse and preview mode as expected. They are 300 dpi resolution, however, I resaved the jpgs at a lower resolution and they still do the same thing. Has anyone else run across this?

I am trying to write a calculation to display text "This number has already been used" following a find. The recordfound count has to be 2 or greater but less than the total record count to display that. I have a formula If (get(Foundrecordcount) >1 < get(totalrecordcount) ; "This number has already been used" , "") and it is not working. Could someone please help clear this up? Thanks STan

I am putting together a simple database for my school to use to keep football stats. Is there any way to take a field (for instance - GainLoss of Yds - and get a sum total of that field for all records? I can set the functions to do sums based on a condition, but I simply want the total for all records that have a value in that field.

I am working on the invoicing section of my Order Entry/Scheduling/Estimating/Invoicing system. The way I was setting it up was to have: a quantity_billed field with 20 reps a description_billed field with 20 reps and a value list a unit_price_billed calculation field with 20 reps a price_billed calculation field with 20 reps The unit price field is set up as: If (description_billed = "product1" ; price_list::product1_price ; price_list::product2_price) The price list is in another table with all global fields. My problem is that it will not calculate the unit price beyond the first rep. I have tried putting the unit price fields in the same tab…

I have developed a database for our new employees to track their initial 3 years developmental assignments. The assignments are to be limited to 9. To track dates, I created 2 fields Layout.pdf Layout.pdf

I noticed that using LeftWords and RightWords cuts off certain characters such as punctuation. Is there a way to not have it do this? """ 1-" & LeftWords(IN1A, 14) & """", "") Larry

If I copy information from one field in file A and paste it in another field in field B I get a number. Copy "Purple" paste 10064897. Any ideas what I can do to fix this? Thanks

I'm new! Thanks for any help anyone can provide on my problem (hopefully not everyone is at DevCon!!) I have a calculation that involves both a number and a period of time. It's more or less this: Miles (number field) / miles per hour (number field) + time (time field) I need the result to be in time format. For example: 2500 miles / 500 miles per hour + 00:15 (15 minutes) = 5:15:00 I've been fooling around with TextToTime, etc. and not getting any where. Again, any help would be appreciated.

I'm having a probem with my Invoice/LineItems database. I'm setting the LineItem's date and status via a lookup into Invoices. The problem is that unless I click outside fields on the Invoice layout (to commit the record) the lookup doesn't work. This has got to be a bug, but I need to find a work-around. Some way to commit the Invoice before any LineItems are created. Is anyone else running into this problem, or have an idea on how I can fix it? Thanks

How can I freeze or lock the scroll position of a text field so that I can exit it and return the same position. By default it jumps to the top of the field and I have to scroll down to where I left off.] thanks

With the following calculation Case ( Type of Information = "Subhead" ; TextStyleAdd ( Ingrediant Instruction Subhead ; Bold ) ; Type of Information = "Ingrediant" ; If ( NDB No Serial > 1 ; Lookup ( Ingrediant Instruction Subhead ) ) ; Type of Information = "Instruction" ; TextStyleAdd ( Ingrediant Instruction Subhead ; Italic)) The type if information in the field is dependant on Type of Information. The ingrediant is looked up dependant on NDB No Serial but only if the field is not empty. The lookup statement is the closest to what I need to achieve but I also know it is the wrong thing to do. Stumped.

I normally avoid repeating fields, but they can be handy in certain situations. Is it possible to assign (in Specify Calculation) each element of a repeating field (of calculation type) to a different calculation? For example, field_ru[1] = 1, field_ru[2] = 5, etc.

Hi guys, Im using FileMaker Pro 6, is there a way I can calculate whether we are in British Summer Time or not (result should be Y or N)? British Summer time starts on the last Sunday of March and ends on the last sunday of October. I'm racking my brains and I can't seen to figure out how to do it with the functions in FM Pro 6. Cheers Jalz

The web page process is as follows. A student logs in with a username and password (all this is happening within a frame) and then the code uses a "target="_top"" command next to the link so that the student will break out of the frame onto a new page. During the process of breaking out of a frame the database connection is lost. How can I keep the database connection open when it seems like opening a new window closes the connection? Any suggestions? Thanks for your help!

I can't figure out how to insert a carriage return/paragraph mark in Find/Replace. I want to replace tagged text with a carriage return. Copy and pasting the Paragraph Return symbol doesn't work and I can't figure out the keyboard shortcut to insert the character either. Can this be done, or do I have to have a script? John

Hello, Newbie - how would I go about adding a unique id or number to an existing database of names and addresses? I think I need this in order to finally make a field to check for duplicates etc. Many thanks!

Each time I reopen a file the global fields are cleared (shared file). Is there somewhere I can get the global to remember its previous setting?

Is there a way to limit a field to being only X characters in length? Thanks for your help!

Perhaps someone has a good idea on how I can create a calculation for the time clock system our contractor uses. When they figure out our employees time cards, they base it on a decimal hour conversion table. I need to see if I can create a database that uses their system to determine their hours. The table is as follows: Mins. | Hrs 57-02 | 0.0 03-08 | 0.1 09-14 | 0.2 15-20 | 0.3 21-26 | 0.4 27-32 | 0.5 33-38 | 0.6 39-44 | 0.7 45-50 | 0.8 51-56 | 0.9 Now what all that means is another thing. Here is an example: Clock In: 9:45 Clock Out: 13:33 Now using the decimal hour conversion table, the times come out to: Clock In: 9.80 h…

I would like my shipping person to be able to enter into the shipping database FedEx tracking numbers WITH SPACES for readability, but then calculate the tracking number without spaces so we can also calculate a tracking URL for the customer. How can I create a calculation field that uses a text field as an input and removes any spaces?

Is it possible to create a calculation that will substitute some characters in a field and place the result in another field? Example: Field 1 contains "larsson" I would like to change occurences of "a" to "e" and "s" to "t", resulting in field 2= "lertton" Get the idea?

Hi everyone, I'm guessing this is a simple one to solve, but its stumped me so far! I need to create a calculation which returns D:directory so I entered "D:directory" in the calc definition. Used to work fine in FP6 but FP7 takes the backslash character to mean the quotation mark is for display. So I get an error message "This text constant does not end with a quotation mark" Any help? Thanks... Sean!

hi there-- I think this should be a fairly easy question, but just can't seem to figure it out.......... I am working with one of the templates that came with filemaker 7. It is the 'Time Cards' template. When I am modifying the template, everything is working well except the far left columns that hold the 'Day and Date'. Above the columns, when I enter the 'Week Begin Date', it automatically puts in the right day and date on the very first day, but on the rest of the 6 days, it has questions marks on them no matter what I do or try to redefine the fields. Can someone please help me?? The template is found in the "Business-Finance" folder if you are …

Hello Just trying to find a way to script a change of the background color of a field. Is this possible? Thanks Stan

I am hoping that the subject got your attention. Can someone please give a definitive explanation on how to pring pdf docs into the solution? I swear I've tried everything here that everyone else seems to have success with but all I get is an acrobat icon staring me in the face.

Ok, I'm going nuts here. I've got a field called DayName that is a calculation. The calc is like this: DayName(Status(Current Date)) For some odd reason, it never shows the right day. The field is global and I am not storing the result. But for some stupid reason it shows "Tuesday". (Its currently Thursday.) I thought I needed to close it and reopen it but that changed nothing. I need this thing to updated daily so that when the dayname is "Monday" (12am monday morning) the database will execute a different script that the one it normally executes every 3 minutes. Ideas?

FileMaker 7 only how to calculate the value in a field from a 'related' field in another table when the relationship depends on the calculation fieldname ? I have a no records table <<Settings>> containing a global field <Language> with 3 possible values : 'DU', 'FR' and 'EN'. I have a no records table <<Labels>> containing the global fields <CtctName>, <CtctFirstName> and <CtctZip>. I have a table <<Translations>> with a textfield for each language and containing a record for each field in <<Labels>> : .....record...<LabelName>.......<Label_DU>........<Label_FR>.........…

jpg file inserted into container field lost all image background. This is ideal for viewing these particular images but, what is going on here? The attached screen shot shows the FM view. The original file has a varied background.

Hi, I am toggling a container field within a portal which changes from a 'tick' to a 'cross'. This consists of 2 jpg images of 10.7K in size. The script works perfectly on the host computer but shows "Ran out of memory while trying to translate the file". This occurs on ALL guest computers! TIA Paul The script is as follows: Toggle Tick If [ Upper(Job Items::Valid Symbol) = "Cross" ] Go to Field [ Job Items::In Stock Tick ] Insert Picture [ Filename: "Tick.jpg" ] Set Field [ Job Items::Valid Symbol, "Tick" ] Set Field [ Job Items::Sort, "0" ] Exit Record/Request Else If [ Upper(Job Items::Valid Symbol) = "Tick" ] Go to Field [ Job Items::I…

I have a portal of task records, containing Done, Description, Date to be done, Time to be done. They are sorted by Done, Date, Time, Description. OUTSIDE of the portal I want to have text on the layout that says something like: "There are 4 tasks due today" "There are 5 tasks past due" "There are 7 incomplete tasks" <-- I have this one using Summary and Calc fields. I don't know how to count the records in the portal that are past a certain date and due today. Any help would be appreciated. I am new at this and would like you thank you for all the stuff I already have found here. Regards, Kevin

hi anyone I have field which stores floating point Numbers. For example, after calculations this field stores the value 25.20 like 25.2 I want to store like 25.20 is there any way I can do it thanks mskichu www.crazytips.com

Simple question... is there a word wrap feature for long text entries? Vandy

Hi - I'm sure I remember from somewhere that this can be done - how do you indent text within a calculation field? Is there a function, or special operator?

I have three fields in a table, letterText, letterTitle and cLetterTitle. letterText is the body of a written letter. letterTitle is a single line description of the letter. cLetterTitle is a calculation that is equal to letterTitle unless letterTitle is blank. If letterTitle is blank, cLetterTitle is the first 50 characters of letterText. The problem is with carriage returns which I want to filter out. If the first line is "Hi", then nothing else is displayed in cLetterTitle because they have been 'carriage returned' to the next line which is out of view. Here is the solution I would like: If ( IsEmpty ( Letter Name ) ; Substitute ( Left ( Letter Text; 50 )…

HI, I am running FMP 7 Dev Windows XP. I posted this question before under subject: "Show Message", but I don't think I made myself clear, so here I am again. Sorry I am trying to build a simple Tennis Registration DB for a non-profit tennis center here where I live. I have three files: Student, Class, and Registration. Student.FP7: for Student information such as: Name, address, etc. Class.FP7: list all current tennis classes information such as: classID, ClassName, Day, and Time and coachName Registration.FP7: Serial#, StudentID, StudentName, ClassID, ClassName, etc. Registration file related to Student by StudentID to get StudentName …

I have a calculation field that is field 1 * field 2. Field 1 always has data, but field 2 does not. I want the calculation to not occur if either field is blank. I have the option "Do not evaluate if all referenced fields are empty," but since field 1 is never empty it always returns a 0. I want to use this data in a graph, so I would like it to not calculate any data so it won't mess up my graph. Any advice on how keep the calculation from running?

Hi - New member here and novice Filemaker user. I'm using version 5.5, and I don't know how to solve my calculation problem. I hope someone here can point me in the right direction. My first file has basic data relating to inventory additions. There are multiple entries per inventory item. The Item ID is my match field. For each addition, I have a Quantity, and a code for the Type of addition (among other info). My second file is meant to summarize the data. For each item ID, I want a total Quantity added, IF the code for the addition matches the Type of addition I want to summarize. (I am simplifying quite a bit.) I'm not able to get the quanti…

I am connecting remotely to a multiuser FileMaker Pro 7 database hosted on a Mac OS X machine with container fields where I want to store large images files. Problem is, even navigating to a record with a large file in a container field takes a long time to just display the file's icon: minutes for a 100 MB file!!! (I'm not talking about importing/exporting the file from the field, just navigating to a record with such a file previously imported). Reading FileMaker's impressive claims that v7 can support up to a 8TB database made me upgrade, but if FM insists on loading the entire field contents each time a user navigates to a record just to display …

I have a container field in one of our databases which stores low-res images At the moment there's about 200 in there but the database size is 18MB already. In the document properties I have the 'store compatible graphics' option ticked. We have mac and PC users, but all the images uploaded into the file are all either gif or jpg. Do I need that option ticked? Even though I'm using in theory cross-platform graphic file formats (jpg and gif) Any other measures I can take to reduce the file size? What about the 'store only a reference to the file' - that will reduce file size obviously. But will both Mac and PC users still be able to view the image from…

Looking for a solution / way ( scripts probably) to have 10 buttons related directly to 10 container fields in a table. When each button is pushed, the file content in each container containing movie (.mov) and (AVI) files will be displayed in one single disply area on the screen. So I have one viewing area (a temp container) that will show content of each of the other 10 container files when the relative button is pushed. Much like the function you would see in XP explorer mode... that is by clicking on a file you can view a thumbnail (picture) of the content of the file highlighted. Only one view box that can show contents of mulitple files.. How do you …

Hello All, I am realively new to Filemaker and have inherited a database that has containers with embedded images. What I need to do is use ASp or ASP.net to make search results vieable on a web page. I have been able to connect and set up queries in asp, but the images come back as a question mark (?) in the resilt set. How can i get the actual image to be displayed?? Thanks Mike

I am using a button to perform the "Send Mail" script. Under options to specify a field value, I would like to specify values of multiple fields after concatenating them i.e after joining them together. Is there any way to do this? ANy help will be highly appreciated.

For some reason the merge fields listed below won't merge when there's no data in the first name 2 and last name 2 line. This is what the layout has: <<First Name>> <<Last Name>> <<First Name 2>> <<Last Name 2>> <<Business Name>> <<Street Address>> <<City>>, <<State>> <<Zip>> I went through and if I take out either the <<first name 2>> field or the <<last name 2>> field then when blank it will correctly squish the Company up to the top name line. But with both in there it will give me a space. We also went in and made su…

I'm sure this has probably been addressed, but I couldn't find it in the myriad of posts regarding the term "duplicates" I am creating a very simple mailing list database (it has to be simple, given the person who will be entering the data). It contains fields for first name, last name, address, city, state, zip, and then some various category-type fields that we need for identification purposes. I would like to be able to check a new record against existing records so that she won't enter the same name twice. I'm only concerned about checking first name and last name (I created a concatented field called full_name for this purpose). I *thought* if I cre…

Hi We have a database with 200 records in 5 tables labeled A Lane, B Lane, C lane, E Lane, and J Lane. The records within those five tables have been somewhat populated. I have a new field called "Dealerfind" and the user will type in a dealer ID number and I want to write a script that will take them to the first found instance of that Dealer. The problem is - that as the search is in progress , It says "NO Matches" for each table where there is no match. Is there a way to bypass that and just get to the first found set in any of those five tables? THanks Stann

I have a "status field" (with a value list) and a "status date change" field. I'm trying to get the "date" field to paste the current date (m,d,yyyy) whenever the "status" field is changed. I don't want it to change if the record is modified in any other field. Can't find a calculation that works. Thanks

Hi! I have several lookup fields in a db. Salary and adress are two of them. Salary is the reason why i use lookup, so that it does

Is there a way to create a new table in a database by importing a (for example) tab-delimited file, and have it create the field names based on the 1st record in the file? Alternately: I have not been able to figure out how to copy a table from one filemaker 7 database to another without redefining the table in the target database manually. I just want a way to automate field definitions because I don't find Filemaker's define fields dialog to be very keyboard friendly. Thank you very much for any help you can provide. This seems like a basic database function to me, and I don't see anyone asking about it in the forum, so I suspect I'm missing something r…

I have a database that has many projects, and each project has many issues associated with it. (Two tables, Project and Issue). In the issue table I have a field "ReferenceNumber." My boss wants it to be job specific. So, I added a field to the Project table called "IssueCount" that is an unstored calculation: Count (Issue::_kIssueID). This gives me a total of the number of issues per project. Then, I defined the field "ReferenceNumber" as a text field with an auto-enter calculation: (Project::IssueCount + 1) & "-" & Issue::ProjectNumber. This gives me a reference number such as 1-W4012F, which creates a per project sequential count. My pro…

Hi I am running Window XP FM Developer 7 I did set up a validation for a field to check if there is a duplicated record. If it is duplicated, then It gives me a customized message (the validation box message) that it is a duplicated record, I just the click the Revert button. That was FMP version 6 I converted this FMP 6 file to version 7, the validation is remained the same, nothing is changed. However when a duplicated record occurs, it is not only show the customized message to ask to Revert the record, but it also show another Filemaker message:

Hello I am trying to make a field calculation to show if any of 4 fields are empty the amount of another field should be placed in a field called "Amount Owed" I had IsEmpty( AFC, CASH, CHECK, AU):"BUYERSCOST"; "0" But that is not the way to write it. Can someone help me with this the fields that need to show if they are empty are AFC, CASH, CHECK, AU Thanks in Advance STAN

my mind's running in circles on designing a database that keeps track of what each employee is assigned to doing every week. i wrote a few weeks back about putting every week's date as values into a repeating field (General Discussions>Filemaker Pro 7>dynamically limiting repeating fields). so now i have got the weeks to show up correctly. but what i'm ultimately trying to implement is where each employee has a list of data(tasks) that correspond to each date. so far i've been playing around with repeating fields for this, making a repeating field for each employee record. see layout "Limited Reps" in my attachment. i can figure out how to have the cor…

I want to make the text in a field red if another field has a '1' in it. The second field would indicate that a product is out of stock, and when that is the case, I'd like the name of the product in the first field to be displayed in red (or possibly 'strike through' so that I can immediately see that the product is redundant. Anyone know how I can do this. Apologies if it's a really basic question, but I'm pretty much a beginner. Thanks.

Oh. I think I've been misunderstanding 7. And i want to change a link. Invoices is connected to Customers on CustID. But I want to change it and link invoices directly with Contacts, CustID. They are assigned a unique CustID when they order (easier for customers to refer to). Contacts also has unique ContactID - long computer calc one that isn't displayed (customers and prospects are now together). I want to ditch the Customer table. It is was stupid and redundant. But I have many calculations and scripts which use this existing Customer table (CustID to CustID). If I unlink invoices and immediately link to Contacts before exiting the diagram, will FM know to correc…

The database I have should display field labels in different languages (3). As I don't want to work with different layouts (one per language) I'm looking for a (calculated?) solution. Probably I will need a global that defines which language should be displayed. But then I'm a bit stuck. I've seen a database that had calculations as labels but I don't remember how it worked. Have you got a solution? Thank you for reading and eventually answering this question.

How can I create a Modifier Name field that auto enters the name of the user that made the change to a record without using the Modifier Name option in the auto-enter tab.

Hi I understand how the key information gets passed when tables are populated through a relationship based portal. However, I would like to use the key field from the user table to populate a key field in another related table. Our web based solution allows logged on users to create recipes. I believe that I need to assign a script attached to button "Create Recipe" that gets the users key and populates the corresponding field in the Recipe table. So it would take the form of: Check if user loged on If not go to log on layout Get key field Go to Recipe layout New Record Incert user key field information Help with the script would be greatly appreciate…

Hi I have to sort numbers that are like a1, a2, a3 , a4 etc. Always a letter before a number but I can't find a way to get it to sort. If I sort I get A1, A11 , a2, A 20. etc. I am not sure how to go about getting this in a sorting order Any help is greatly needed and appreciated Thanks STAN

Post deleted by scm

Hello there, I am building a web-store and I want to manage my "default" page images from the database without "search". It works fine with "-key", if I only could find what key-value is related to individual records. For example: <img src="FMPro?-DB=xxxx.fp3&key=32779&-img">is displayed ok, but how to find that key-value when working with database only? <img src="FMPro?-DB=xxxx.fp3&-RecID=565656&images&-Img"> is not working? -why not? Urgent help needed. Kind Regards Juha

I would like to make a pdf file available for viewing from a layout. In as much as there is no documentation on doing this, suggestions are needed. 1. How to store pdf file. 2. Where to store pdf file. 3. How to establish path to pdf. 4. Clickable icon to open pdf file from browse. Thanks in advance.

first off I'll explain what I am trying to achieve with filemaker. I am currently creating an online contest that grabs information from a form (via CDML) and adds the information to a filemaker Pro Database. This has been created with few problems. Contests will be held once a month or so. People must enter the contest only once (check e-mail address if it is unique) but if there is a new contest they may enter again. I would like to keep the information in a central database. (ie. not have a new database for every contest) This is my attempt at a solution. I am trying to create a field to concatenate the Contest name and the e-mail address together and then see if…

How is this possible with filemaker 6? Thanks

I am attempting to create a formula to automatically obtain a person's age from their date of birth. I have three fields: Date:(today's date), D.O.B., and Age:. I need the age to be automatically calculated after the user types in the patient's date of birth (D.O.B.). I know this can be done, I am just not sure of how to go about setting it up. Can someone out there help? I have attached a copy of my db if anyone cares to take a look. Dave EKGSTRESSTEST-6Copy.zip

I have three credit card expirtion fields all number called ExpMo, ExpDay and ExpYear. Year is 4 digits. I am trying to validate credit card expiration dates but have something wrong. The following appears to work but when i look closer, it says a card with 1 in ExpMo and 2004 in ExpYear displays as valid. Could you help me figure what I have wrong? Calculation is text unstored as: If(not IsEmpty(ExpMo) or not IsEmpty(ExpDay) or not IsEmpty(ExpYear) and Date(Month(ExpMo); Day(ExpDay); Year(ExpYear)) ; Get(CurrentDate); "Valid Card"; "Invalid Card") The other thing I'm trying to do is add auto-enter to the year field so it must be 2004. I do…

Just curious. After calculations are completed, I dont' clear the "used" number fields (maybe I should). If I use a global fields they reset themselves for each calculation, obviously. I'm guessing using global fields uses "less" memory as you only enter a value once and each record has a "tag" that accesses that value. Am I correct?

Hello Everyone We have a car auction here and we have three types of clients who pay differently. We need to give them a check but we have to take out there service charges. We have a field called paycode which simply has an entry of A , B or C in it. The Clients with "A" paycode Pay all there fees out of the first check ( most people have 2 or more checks for the number of cars they sell) - the Clients with the paycode B pay the service charges from each check and the Clients with the paycode C have nothing taken out because they need to be separately invoiced. The fields here are Client AmountofCheck Paycode So there are three types. Can this …

I am trying to incorporate the results of a calculation field into a company letter using the formulae <<field_name>>. I need this to show as currency to two decimal places. The problem is that if the result is only one decimal, then it shows

I'm trying to set-up a database to enter a date an employee starts work at a location and then will give me a notification when they have been there for 45 days. Also I would like it to count only Monday through Friday. Is this possible??

ok... i have a calculation field with this definition. Case( not IsEmpty(PJCompleteDate), "Complete", PJStatus = "Stand By", "Stand By", PJRequiredDate < Status(CurrentDate) and IsEmpty( PJCompleteDate ), "Overdue", "Pending") now this has always worked perfectly, displaying the correct info. until today.. today all work order that should come up as "Overdue" just come up as "Pending". Now if you do something like change the PJRequiredDate, PJStatus, or the PJCompleteDate, then the field will update back to the correct thing. So I can fix it, but I'm just wondering why it would suddenly just stop working like that. Thanks for the help, Rick

I need to round a number other than the standard .5 increment. example... 4.2 = 4 4.3 = 4.5 4.6 = 4.5 4.8 = 5 Is there a way to do this?

I wonder if someone knows a simple calculation to calculate timcode difference TC_Hour - TC_Min - TC_Sec - TC_Frame {Maybe switch between (30fps, 24, 25)} Subtract - TC_Hour - TC_Min - TC_Sec - TC_Frame ------------------------------------------------------- Result TC_Hour - TC_Min - TC_Sec - TC_Frame If anyone could help! Thanks Thomas

Does FileMaker 7 offer a way to timestamp each field of your choosing to keep track of when changes were last made to that field? I am attempting to build a small synchronization system to perform data replication and I would only like to transfer data that has changed. Thanks, Eric

This may have been answered previously but I'm still new to FM and I'm not sure exactly how I need to word my search... I've got a database with things like appointment times, gender, treatment phase, etc. Let's say I want to run a query for all women who have appointments within the next 2 weeks. I've designed an interface for the find, but I want to format the found results to say: ________ Found xx records with your criteria Jane Doe Janis Joplin ... ________ Anyone have an idea how I can do this?

Hi I looking for a tip that could solve my problem. In my Invoicing file, I use a portal to deplete my line items when I sell an item. This portal is printed out on the invoice output. I want to number the items sold from '1 to x' on the invoice output. Any help would be great! Bikeman17 - The road belongs to me

Hello, would love to RTFM (and have Nolan Hester's beginners book as well as Cynthia Baron/Daniel Peck Advanced) to find my answer but apparently the words are getting in the way. My Senior Engineer refers to this problem/solution as using Jump Tables but I can't find anything like this. Point me in the right direction please (Windows users): Field A provides test type. Field B provides the associated report type. Is there an easier way (other than If-Then-Else) to trigger the correct report type based on the test type selection? Both fields are in the same db. It appears that it would be simple if the fields were in different databases. Much obliged! …

Hello Everyone, I am having some trouble with a very simple thing ... Returning the Current Date in to a field. I need to use it in an equation. I am using Get( CurrentDate ) But this return the wrong date? Also, If anyone knows the qeuation to add 45 days to the current date I also would be greatful Thank you

Tried to setup a copy all records procedure for saving found sets. Works fine if logged in as admin but as a user where I have added some restrictions like layout, scripts, export etc it errors on the "copy all records" errors saying the file is not modifiable? why is this? Can anyone spread some light on this? ---->edit It appears that I have solved it again. I need to let the users export records to be able to achieve this.....hmmmmm thanks if you looked! Thanks

can the enter key or return key be entered into a calculation to allow the data to exit a field once entered by a scanning device?

Hi I have a field in my contacts file which is a container for placing a mug shot of the individual. Not all of the contact in the the database have photos but what I would like to do is this? If the title is Mr then a black silhouette of a man is shown in the field but a new photo can be added (and vice versa if Ms, Miss or Mrs is selected). So basically it shows a silhouette if blank and depending on the title which one but the field can still have a photo added? Any ideas on how this is possible? Thanks

How do I check that data in a field has not already been entered in the same field in other records. And then prompt the user that the data already exists. Dave

Hello, I'm sort of new to FileMaker and are now evaluting what it can do for me. So far it looks good but now I have a problem. I want to do a summary. But the summary is depending on a category in a third field: Category Amount Summarized amounts A 10 30 B 5 20 C 15 60 C 30 60 B 15 20 A 10 30 A 10 30 C 15 60 The Summarized amounts field should calculate the amounts for all A:s, B:s and so on separatly and display the results in all …

I have a field called "title". i have a different field called "volNumber". i have to combine the fields so title and the volume number are together. so, i created a field called title_volume. i defined the field as calculation and text. here is the calculation. Case( IsEmpty(title) and IsEmpty(volNumber), IsEmpty(title), Trim(volNumber), Trim(title) & " " & Trim(volNumber) ) when i finished the calcualtion and inserted the field, it combined titles and volume numbers for me. good. however, titles w/out a volume number did not show up. i need them to show up. is there something i can add or modify to this calcualtion that will place t…

Hi, I have been using FM 6 for a while with relatively simple stuff, but am convinced that one of my ways of doing things is ham-fisted! I am using FM as a database for clinical data collected during a trial. We are collecting the same data on different days for each person. Up till now I have been using multiple different fields (e.g data1_time1, data1_time2 etc.). I am sure that within FM (using relationships? or repeating fields?) I could set this up more easily - especially as I have c. 30 data items over 17 time points. This means creating way too many fields! Importantly, I will want to export the data for analysis so that each item of data is in …

I currently have the calculation field: Total Balance Remaining Calculation = Case ( Total Balance Remaining > 0 ; TextColor ( Total Balance Remaining ; RGB ( 250 ; 0 ; 0 ) ) ; Total Balance Remaining = 0 ; TextColor( Total Balance Remaining ; RGB ( 0 ; 0 ; 0 ) ) ) Where the Field Total Balance Remaining is a Calculation Field with the formula: Total Amount Owed - Total Amount Paid what am I doing wrong to make the text change colour?

I have a 50,000+ record file with links to multi-page .tif images. I view the images with a scripted button that opens the file in an external MS image viewer (with the "Open URL" command). The individual .tif files are stored on a network drive in 6 different folders. I am trying to find a solution to my need to print multiple image files, i.e., images for all retrieved records, without going individually to each file through the external viewer. Imbedding the actual images into a container field is not practical because this would make the dbase too unwieldly and wouldn't work anyway because the images are mult-page .tifs. Scripting doesn't seem to work because it …

I

Hi there, first question. FileMaker 6 on Mac OS X. I've got one database (Line Items) in there is a field "Number Sold" which is a number and another one titled "Picked Up". It's a checkbox, value 1 if it's checked. In another database (Sales) I've got a field which uses a calculation to SUM the Number Sold field from the portal rows. This works fine. What I would like - is only have it sum the portal rows where "Picked Up" is checked ( = to 1). Any way to do that? Thanks in advance.

Hi everyone, I've run into quite a dilemha! (As per usual ^^) and I was wondering if anyone here had an answer (or even knew which forum this should go in ;-P) Okay, basically, i have a database with a bunch of invoices. Each invoice is associated to multiple payments. Each payment has a payment date on it. In the main database, there is a calculation which calculates a balance. Basically, it takes the invoice amount, and subtracts the sum of all the associated payments. Now here is the kicker! I want to take a sum from only a specific date range in the payment database! And i want the user to be able these constraints every time they do a search. Firstl…