Calculation Engine (Define Fields)

I have a text fierld that has several values all separated by a single space (i.e 2 34 323 4,0 34 432) I need a script to get each value into either a series of individual fields or different segments of a repeating field. But I just am running blank Any help would really appreciated. John

Is there a way to create a calculation field which has a value (1 or X or anything I can use as a flag) only if it is part of the current found set? This way I can trigger a find from another database and have a relationship portal to show the results. I know that I could do a loop to auto populate the fields each time I do a find, but a calculation would be much cleaner.

I am having trouble. Can anyone help me? Simply, I need to take a field that is my supplier style referance and re calcualte it without any spaces or non alpha numeric characters. I mean remove verything that is not from a...Z and 1...0. An example would be changing (a4.32 1 /3) to (A43213) Can I do this some way? I look faorward to your help.

I am experimenting with using the "Status(CurrentUserName)" function to autofill a field in a file. I'd like to do this because I have user passwords defined to only allow record access to users based on that field, and if they exit the record without setting that field correctly, they lose access to the record. I've gone to Edit,Preferences,Application,General, and put a value in the "Custom" box, but the application keeps returning the "System" name. I quit the application and restarted it, but still get the same results. I have NOT tried restarting the computer (I'm using FM6 on Mac 9.1), but that seems a bit extreme. Should I be able set this parameter an…

How can make a phone number with default settings of hyphens only, e.g., 333-222-4444? It would convert a number that uses parens, etc., sort of like how you can choose to have a date field with numbers and slashes only. thanks, Harry

Hi guys I am having trouble loading the "LabelsAUS.flb" file which contains the standard Avery labels for Australia. Does anyone know how to solve this problem. At the moment I can only access the US standard for US Letter page layout. Thanking you in advance wombat

I'm designing a Client database that has a date field of the person's birthday. I also have an age field that I would like to be filled in auto as soon as I enter the client's birth date. I would like the age field to tell me how old they are in years. I know it is a calculation but having trouble configuring it. Help...thanks alot.

Hi, If I insert a Pict image using the Insert>Picture comand for use as a layout background will it not be usable in Windows? I've tried using other formats: tif, pdf, bmp, etc, but pct yeilds the best results when printing. BTW the original document page (which is what I'm inserting) was from a fillable form pdf, which I converted to a tif (in Acrobat) first then to a pct in PhotoShop Elements. I know this has been discussed here plenty(Recent Thread), but I've never found a concensus as to the best way to do this. The pict works for me on my Mac and prints almost as well as the original pdf. All the other formats looked really bad, as in fuzzy lines. Obvi…

I have to validate some field entries and I was given the calculationcode by my boss. He got it from the account we're working for. Anyway, the problem is, its a PHP validation. The guy that made the calc said that it is possible to create the same one in FM too - but I don't even know where to start. The code is: $number % 9 == 9 - (ord($letter) -54) %9 What the user NEEDS to enter is a 12 digit serialnumber and the first character is a LETTER ((ex: P123456789123). the ORD function replaces the letter with a number (ex. a=1, B=2, c-3 ... z=26). $number are the 11 numbers (without the letter)... Sorry if this is confusing or even an unwanted post since i…

I'm trying to create a field, that can have tabbed text in it. I can define the tabs in the field, but when it comes to actually using them in Browse mode, tabbing just moves me through the fields in the Tabbing order. Is there any way to switch off Tabbing order when entering tabbed text, or is there another character to depict a tab in a field ? Thanks.

I hope someone can help me with this one. So here it goes. I have three field values StartDate, EndDate, ShowTitle. These three fields I am exporting from FM as a dBase file, so I can import it into Outlook just so I can print a Calendar, all of this is working great except for one thing. In FM the SatrtDate is Thurs, Dec 5 2002 and the EndDate is Tues Dec 10 2002. What I want to happen is to have two checkboxes one for saturday and one for sunday, so if the boxes are left empty then it would make the StartDate Thurs, Dec 5 2002 and the endDate Fri, Dec 6 2002 and duplicate the record and set the new record StartDate Mon Dec 9 2002 and the EndDate to Tues Dec 10 2002. I…

Actually there are two postal address field areas. If the alternative address fields are used, I want the Find to ignore the regular fields -- to exclude that data when I export -- can I do that? I am doing a find on some records. On an 'add new request' I want to have the 'find' determine if a certain field is populated. If it is I want to have the find ignore the fields that I do not want. How do I mark 'ignore' on the fields (or something similar)? Harry

Hi Everyone! I needed to use Replace Contents (on a stand-alone system) through a set of newly migrated data to set a date field (DateTherapistPaid) with a date which is the last day of the *next* month based upon its ServiceDate, but if the ServiceDate is less than 8/1/2002, set the field with 9/30/2002. I created an unstored calc through field definition to view the results before I proceeded ... and also backed up. I assumed I had to de-construct the date and re-construct it again? I searched Forum and to get the *last day* of a month, I need to find the *first* of the next month and -1? So I jumped 2 months forward. This calc does work. The reason …

Hi all, I have a shared database ( FM 5.5 ) in wich I need to enable users to paste or draw swketches/drawings directly in a Container field. The db is hosted on Mac OS X 10.2.2 and we have 6 clients ( 1 Windows XP , 1 Windows 2000, 1 Mac OS X 10.2.2, 3 Windows 98 ) I have found an easy way of doing this, the clients could draw a sketch in Paint, Photoshop or any other App and then copy/paste the sketch in the FMP database. Pasting a picture in a container field works just fine when done in Mac OS X and all the windows machines can see the pictures. The problem is when the picture is pasted in the database using windows and then viewed by Mac OS …

Novice has question. (Mac OS 9.2, FMPro v.6) I'm using two fields to show height and width dimensions in centimeters. I then use a calculation to combine the two numbers as a descriptive phrase: "45.1 x 33.1 cm". I'm using ROUND to limit the decimal to one place. However, when the decimal rounds to 0 (zero), the 0 is dropped in the calculation result. (e.g., 22.02 shows up as 22, but I need it to show as 22.0). I'm just not getting how to do this. Thanks in advance.

This is driving me round and round in circles. I have a db where a person enters the hours they work in a day ie 0800 - 1800 10 hrs, no problem, on each record there are also 4 other fields that need to calculate the total of hours worked in the previous 3/7/28 and 365 days. This is to ensure the worker does not go over their limitations on working hours. Each day is on its own record. I can provide the data when I use loops in a 'new record' script and pull up using a search the previous 3/7/28 and 365 days and total them together in a global field and add them to the new record. I am sure there is a better way but this worked ok. However when a new record is …

I have a database with 1600 records of client self-entered data (it's basically an electronic directory). Each record contains date entered, date modified, time entered, and time modified fields. All of this is hosted on the web with custom HTML pages and CDML tags. I would like to be able to automatically display, on a web page, the date and time the database was last updated. Is there a way to determine when the most recent record was updated in the database and then display that date modified and time modified information from the most recently updated record? I was thinking this might be possible with a calculation field that "somehow" finds the most …

I have gotten a value list back from a specific field. This will be variable from database to database. How do I 1) Count how many items are in my value list 2) Create a field that repeats the values in the value list and additional text the same amount of times? Example: I have a header that has to instruct my press how to print and pull variable. I have the list of masters needed for the press to pull. I need to create the instructional file for the press that has the header that creates a "carousel" for each master used i.e. (c1) (masterA) then I need to create a corrosponding footer recrod that deletes the carousels used (1 for 1 ratio from headers) fo…

Is there any way to compare the data in a repeating field between 2 records and have the differences reported ? for example, i am designing a manufacturing schedule for a printing company that incorporates up to 10 different colours (repeating field) whenever changing from one job to the next , some,none or all of these colours may change and may or may not appear in the same repetition. I would like to capture the differences ie: 3 same & 7 different. I would then be able to incorporate these numbers into costs and ultimately show scheduling efficiency.

I have a field that pulls a "master" for that record. There can be any combination of "masters" being used. I would like to make a list of the "master" field, but only have it report it once. (i.e. if you have a master 1 (repeats 10 times in the file and a master 4 that repeats 2 times I want a list that reports back master 1 and master 2). This could change on every database I have. Any suggestions?

I want to set up a calculation field that concats text fields together. The fields are name, address, city, state, zip. I can get them to concat without any problem but I want the name to appear on line 1, address on line 2 and city/state/zip on line 3. How can I force a carriage return after the name and address field? Thanks The Mad Jammer And then...there was nothing

Is there a quick and easy way to take a field that uses checkboxes (custom value list) to identify participants in a project, and have it display as comma delimited text? I'm wanting to ultimately merge this with a word document, but when I export the checkbox field to a CSV file for merging through Excel, I get box characters between each value that was checked. I would do a find/replace for the boxes, but I can't replicate the character in the find tool in Excel. Advice?

Hello all of you super smart people.... I have an interesting question.... I have a report that is sorted by month. There are 2 totals in the sub-summary section, total cost and total invoiced for each month. I need to get a profit margin (invoice summary/cost summary) for each month and a separate profit margin for the grand total (trailing grand summary) for all the months. When I create a field (margin summary) and place it inthe sub-summary part, I get the grand total margin not the margin summary for the each month. How can I get the margin summary to "summarize" only the sub-summary total and not the grand total?

I

Does anyone know a good way to get a total of the number that a certain day(ie. Monday) of the week occurs in a given month? In otherwords, how many mondays in the month of September 2002. I can think of several ways to get the result, but they are neither elegant nor efficient and involve several different fields or scripts. There's bound to be a elegant calculation for this. Anyone?

hi I have a DB where users must enter a serialnumber to track. The number used to be numeric but now theres a letter in front of it (P123456). I do not want to redo all links to a new field. What I would like to see is that the user MUST fill in the full serial (including the letter) and the validation chechs the the first character is a letter and the others are numeric... I've been trying (too) hard to find the solution. Anyone any hints? Thx

Basic question. Have a list of taxlot acreages for many cities and counties. Want the top 10 records sorted descending order for all jurisdictions. Can't figure out how to start this. Help.

Hey there, I have created a field definition that tells me too many seperators and i was wondering how many and clauses can you put in a Case. Or am i doing something else wrong.....Here it is: [color:"red"] * Note, if i take out the section in red, it works. But i need it in there help!! If(cLineItemType = "Product", Case(ProductStatus = "Reserved",1, [color:"red"] Left(max(ProductLineInvoice::cInstockCheck,1) = 1 and max(ProductLineInvoice::cInstockCheck) <> cInstockCheck and Products Current Bypass::ProductUpsell = "Yes" and Quantity <= Products::StockSelection and CQuantityTotal <> CQuantityCount,1, Quantity <= Products…

Hiya, I am trying to create a calculated field that will return a Text value from a related record based on the highest quantity. EG I have 3 fields Product, Qty and Price for two records as follows: Cake 1 $10 Sugar 2 $5 If i do max(SelfRelatedbyInvoiceNo::Qty) in my field definition then each record will display a 2 But how would i display the word sugar instead? Any help would be fantastic! Regards, Kerrin

Ya'all helped me establish a validation on this numeric field (CGAS) which must be between 30-65; however, the bugger refuses to allow the User (currently me) to do anything else once accidently tabbed to ... in other words, it won't accept a blank once I land in the field -- irritating to say the least, as many times I dont' know this number for a few weeks. Validation calc is CGAS >= 30 and CGAS<= 65 How can I modify this formula to accept a 'blank', BUT if a number is entered, it must be within this range. I also have checked "strict do not allow user to override." I tried removing it from the tab order, but because there is so much on this screen, it…

I have a numeric data field of 2,000 records. This field was an import from an old DOS program and originally was a text field.This field (CPMS#) contains a 'mixed bag' of numbers, such as: 1981 01983 001876 09835 041922 I need to remove all leading zeros from this set. This is on a stand-alone system and I would like to use REPLACE (calc) to run through the records for stripping. I thought of isolating the various *types* (such as finding 01983) and then using something like Right(CPMS#,4) ... repeating with each found set type; however, I think there's an easier way and *finding* keepings bringing up mixed data. Is there a formula I can use to…

I was setting up a file to act as a pref. file for the rest of my related database files. you know, general company info, company logo, ect that then will get used by the other files. I had read somewhere that if I would set up this pref file as a single record file on the host computer I could use global fields that, if modified by different users, would change the data in the global fields on a permanent basis. I tried this but it does not seem to be the case. If one user makes a change from a client machine to the hosted pref file to a global field, the change does not stay if another user later looks at the same file. I understand this is the nature of global fie…

Have 1 field (name) with the following contest: (this is the short version since the field have between 5 and 250 lines) John Howard James W. Williams Jean-Pierre Maurice J. Robinson Judd & Amy Nicholson Want 1 field (allname) with the following contest: John Howard; James W. Williams; Jean-Pierre Maurice; J. Robinson and Judd & Amy Nicholson. When finished with the calculation, I still want to be able to correct misspelled names in the "name" field, which then automatically are updated in the allname field. I have been looking at the "Array Expander" posted by Ray (http://www.nightwing.com.au/FileMaker) in a previous message, b…

I'm making a simple recipes database which has built-in conversion and display of amounts of ingredients in metric and imperial measures. It also lets you recalculate the amounts in a recipe designed for x people for y number of people. On an entry layout you put in the original recipe with amounts of each ingredient for x people. Against each of 14 ingredient fields is an amount field and a popup list of units (ml, fl oz, pints, litres, gm, oz, lb etc). On a separate layout you can enter the y number of people and the amounts for each ingredient are then calculated and displayed in both metric and imperial. So for each ingredient you have an input amount field …

In the header of one of my print, I want to use a calc field based to "date" and "hour" like done the 23/11/02 at 12:02. I create a calc field "The"&" "& Datefield & "at" &" "& HourField. The result is numeric The 731177 at 43320 in Text, 7,3118E+10 in Num, "?" in Date an Hour... Thank you

Hi, In my serialized database, I have created a delete script that will delete a record only if it is the last record in the database, using Status(CurrentRecordCount). That is all fine and dandy. My problem crops up when I add a new record after deleting the last one. The serial field in new record is now not continuous. i.e. there is a gap for the deleted record. eg: I have 48 records. I now add a new record (#49). I then decide that I don't want to add a new record and delete it. So, I still have 48 records. At a later stage I add a new record. But now the number of the new record is #50 while I still have only 49 records. I tried to incorporate t…

If I define a global and place it on a layout and then I insert a graphic into the global field. Next I remove the global field off the layout. Does the global field still contain the graphic? If I set a field equal to the global field, would it give me the graphic that I inserted into it? I am asking this because I was looking at a sample file and in a script they set a field equal to a container field that contains a graphic. The only thing is is that I cannot find the global field any where on any layout. This led me to believe that I can set set a global field and then remove it and have it still contain the object. Am I way off in my thinking??? I have been w…

I have a number iield which is currently formated to two decimal places. I need it to show a leading zero if the data is less than 10. For example. Suppose the data is 1.45 I need the format to show 01.45. However if the data is greater than 10 then I just want it to show the data - i.e. no additional zeros. Anybody goy a suggestion to what should be an easy formating problem? Thanks

Hi, As a disclaimer, I'm a Geneticist by training and my FM skills are not skills at all. I'm setting up a database in my lab for oligonucleotides (small stretches of DNA that contain A, G, T or C in random sequence). The length of the oligo is usually between 12 and 80 bases (characters) long. One of the key calculations in an oligo database is the melting temperature, which is directly affected by the number of G and C as opposed to A and T. In my database, I have an input text field that hold the sequence of the oligo. From this how do I calculate the number of A, T, G and C in the text string. For eg. a typical sequence is the following AAT…

We use a database to track subscribers to an annual service. Using two fields showing the date started and the date ended, I want to be able to calculate the number of days to the expiry date of the service (showing a minus value if the expiry date has passed). I tried the following, but obviously this fails when the start and end dates span end of year (ie start 4/12/02 end 4/12/03) DayofYear(Ad ended) - DayofYear(Today) Anyone got the solution?

I have created a database with four fields: Paper size, paper type, paper sides and paper color. I need to create a calculation that figures the cost for each type of printing. For example, if paper size is 8.5" x 11", paper type is plain, paper sides is one and paper color is black, I need the cost to be .10 cents. But I need the cost to change on the fly based on each field value. Do I need to create a monster IF/THEN calculation or is there a better way? Thanks for your help.

This is probably very easy to answer, so the first one to get it right gets a hero cookie. I've got two text fields (one of "name" and the second of "surname"). My calculation is the follwing: "name" & "surname" to combine the two in the clac field. Now... how do I insert a space character between the two in the calculation? Thanks guys!

Okay, I posted a question the other day about a script starting automatically when you enter a value. I was told that plugins were required. It's not an option for my situation, so I'll just use a "Begin" type of a button to trigger the script. Thanks for your advice though. Now I need more help with this area. I want the user to choose a grade from a pop-up menu, then a script does a find of all student records that match that grade. I'm not sure how to make a scripted 'find' that is dependent upon the choice from a value list in a pop-up. Can you help? Thanks, Paul

Hi I want to have a user's selection of student grades from a pop-up menu automatically select a script that performs a find. The students are grade 4,5 or 6. (on the value list: SELECTGRADE) and I want to draw only the appropriate grade from the school records based on what grade the user selects. Rather than have a "GO" button scripted to begin the find script, is there a way that as soon as the menu choice is made that the script begins based on the value chosen? Also, should I have a find script for each grade level... not sure how to set this up. Thanks in advance, Paul

I am working on a purchase order database. It's pretty far along and I've just added one feature about which I'm confused. The buyer scrolls through a lengthy list of a vendor's products, entering her order quantity in a field on each line. What she'd really like to see is a running total that updates with every quantity she enters. I've made such a field and placed it in the header of the list layout she's working in. My problem is, it looks like there are two different ways of making this field, and I don't know which is best, or if I am setting myself up for something by using the wrong one. Both seem to work equally on initial testing. 1. Making a Summ…

hi, I have a simple DB with a few normal fields and 2 calc field: Totaalwaarde -> Calc -> Unstored. =count(waarde::waarde) Summary -> Calc -> unstored=(Max(totaalwaarde) Totaalwaarde calcs the number of times the same value is added in the database. Its also searchable (so it can be used in a -find request). But how do I set a field that only selects 1 record instead of all. Let me clearify: 10 records with 'A' as a value in 'Waarde' 5 records with 'B' as a value in 'Waarde' Totaalwaarde results in: 'A'=10 and 'B'=5 ..All 10 records containing 'A' have that mark so if i do a find on the highest 5 (-max=5) it will show all 5 records fr…

I have a problem with a text calculationfield. The field is named 'OrderID' and contains this calculation: CustomerID & " " & Year(today) & " " & OrderID The Year shows 4 digits, but what I would like is that the Year shows 2 digits in the field. Is there a soluton for this?

I have read so must about the similarities and differences of these two funtions that I'm confused again. I don't know if I have ever read the answer to my question or not, but, Which of those calculations will return a date and then NOT update it? I have a calculation that is supposed to return the current date when a number is entered in another field. The date isn't supposed to change after that. If someone can explain this to me along with what storage options should be set, I would be most appreciative. Cheers, Mykol

I have a schedule that has a date popuplist that schedules a piece of equipment. Each job is automatically calculated for time to perform. If all records are listed in a row, is there a way to sort the records by date and have a summary field after date? Maybe this is a script or portal isue... I have no clue...thanks for the help

I have a DB which can be used to record student test results, as well as to display bar graphs of the class results in different areas. On the recording layouts, I have some demographic info to be entered. (e.g. gender, English is Second Language?, etc.) I have a layout with scripted buttons which allow you to filter the info according to the demographic info before proceeding to the graphs layout. (eg. graph the achievement of only girls) There are scripts such as GETGIRLS I wanted the title which appears at the top of the graph layout to be specific to the search results. ie. if I'm only viewing the test achievement of girls, I want the title to rea…

I have a few record found ...and how can I create a field that contains all data from record one to the last record? Thanks

Hi, I need help with a case statement (at least that's what I think I should use). I'm collecting student test results. I want to assign a total mark based on the total of some other assignments. If the total of the assignments falls between a certain range they get one mark, between other ranges then other marks should be assigned.Marks can be 1, 2, 3, 0r 4 Not sure about the syntax though. I want it to say: Term1Score = In the case that: (T1Total is >= 5 and <=13 then assign a mark of 1) or (T1Total is >=14 and <=22 then assign a mark of 2) or (T1Total >=23 and <=29 then assign a mark of 3) or (T1Total >=30 and <=36 then…

Hi, Please tell me if i'm wrong! I have a database (duh) and in that database there is a global field with a graphic thats

Is there a way that I can STOP carriage returns on certain fields? Or at least use Validation (or something else) to provide a message to the user to correct their entry? It is happening on Win system using alpha [ENTER]. This is very annoying

i have an archive database where i'm entering a variety of credits. a pop-up list appears with record ID's from a contacts file and the 'show display values from' option showing the actual name. once the selection is made, i'm looking up the actual name into a separate field. this field is on top of the ID field so that only the name shows. (i'm using the extra field mostly to be backwards compatible with an earlier version). so far so good. because the same names are frequently entered, i have a preferences screen where the user can select default names. now that the relationship is based on ID's rather than names, preferences (which are stored in globals) cannot displ…

I have a situation where I have multiple letter options, in other words, based on a individuals certain medical criteria, they will get a specific letter. Within each letter there are four to five customized paragraphs. For example, one for Cholesterol, one for HDL etc..etc.. I have developed a table of all the possible paragraphs and related them back to the main contact table and created the fields necessary in the main contact table to capture the right paragraphs. HERE'S THE TROUBLE. Within the paragraphs, I need to personalize here and there eg..<<Fname>> or <<datebloodtest>> etc.. This will only show if I paste directly onto layout in…

I have been using ABS(field) to test if field is numeric or text. This works for all text except words that start with the letter T. The abs() of "T" returns a value of 1. For any other letter it is blank. Why is this so??? Is it a special feature in Filemaker 4.1?

I've gotten mixed signals from reading the threads in this forum. One thread said that if you store the image (rather than reference), then it will store a PICT version... hence, that 8KB JPEG might be 60KB in the database. Another thread indicated that setting "store compatible graphics" causes the extra PICT to be stored... turn that off, and it just stores what you give it. Is that so? But why, given a JPEG is far more cross-platform than a PICT, would "store compatible graphics" cause anything more than the JPEG to be stored??? And if you turn off that flag and only store JPEGs, will there be any cross-platform issues to worry about?? T…

I want to have two seperate fields for height -

Sorry if this post has been covered as I'm sure it has, since it seems like a common task, but I've searched and can't find the answer. I'm trying to calculate a reference link for a container field, where I want to have a image appear in my FileMaker Database based on a link that is calculated. The link is a URL, as I want the link to work both for client access in FileMaker and for my CDML. The calculation looks like this "http://website/directory/"&photoname&".jpg" with the result being a container. What is the method for creating a container field based on file path that is calculated in FileMaker? I've tried this as an auto enty calculation a…

someone gave me a DB that had a list of furniture items. Trouble is they are all in one field and separated by "returns". Any nifty ways to separate them into separate records? so can bring them back in as a portal. thanks

I have a reservation system that has reservations for particular days out of the year. But i would like to have a print out of who is staying in what month. Each reservation has a particular start day and finish day, and i would like to have a combo box for the months of the year that once selected you will be able to click a button that runs a script that collects all the reservations for that particular month and put it into a table format for printing.

hi, im having trouble doing the following: i have a simpel site that serves the main page from a simple database. However, anyone can create a new record (by signing up) and add data. What i want in the startpage is a summary of data, like: # of records (wich runs already) but the main problem is that i cannot figure out how to produce a 'top-10' of users that enter data. Since i dont know the names of the users i cannot use it as a flag. So the field has to check for the highest counts of files, grouped to a user. I'm from the netherlands so it might sound more difficult than it really is (languages pffff) Thanks JP

Hello All, I've looked around for a hint on this item but haven't been able to find any info. I'm defining a calculating field based on the data from four other fields. In all cases, the first of these four fields has data, but the other three fields do not necessarily have data for any given record. I want to simply list the items gathered from the four fields in this new field, separated by commas. I can do this by calculating Field 1 & ", " & Field 2 & ", " etc..., but I run into problems when there is only data in the first field or two. I want the combined field to use commas to separate the data when necessary, but I often …

How can I make a button 'play' a custom sound when it has been pressed to give the user some 'feedback' to using a database? I have tried looking at the scripts but have very limited knowledge all I can get is the beep and the computer to speak! but I would much prefer a sutle sound effect. Charles

I have a template calendar that I obtained and am trying to customize it. There is a graphic container field with 2 repetitions. It currently contains two graphics, and I was able to change one of the graphics in it. How do I go about changing the second graphic? Every time I try to put the other graphic in it, it just replaces the first one.

I need to enter cumulative information into a field by way of a script. I want to enter today's date, then, next month, I want to enter that day's date, thus keeping cumulative dates of activity. I have a script written that will do that, but it WRITES OVER the earlier date, thus erasing it. Here's my process: I click on a script that takes me to a thankyou letter. It prints it, then takes me back to my "Data-Entry" layout which contains a "Date_ThankYou_Sent" field. Today's date is entered automatically. Weeks, months or years later, I want to perform the same script for the same record, i.e., send a second or third thankyou letter to the same person. When the s…

What algorithm does FMP follow when you enter a two-digit year? Most programs center a 100-year window at today, give or take a year. FMP seems to assume >90 is 19xx and <90 is 20xx. Except sometimes it uses just xx. Anyway, is there any way to specify this? I would love to allow 2-digit year input... but its useless of 88 is going to go to 2088. Thanks.

Okay, now I know yesterday I said I LOVED formulas, because I had finally understood ONE ... today, I dislike them again Somehow in my data migration, I have 67 Clients whose DOB is incorrectly starting with 20 and should be 19 (2089). I can isolate the records by finding >1/1/03 but, for the life of me, everything I try fails. I've tried Replace, Right, Case, Year(DOB) -1000 ... nothing is working. How do I change them to their correct 2-digit year beginning with 19? I will be using a Replace Calc through the set (stand-alone system) and it's a date field

is there any caveat using Status(CurrentRecordID) as a serial number? seems to me it works just about the same and perhaps you don't have to mess around when importing records. i just added a field that displays Status(CurrentRecordID) in a text field and out came a very high number. could this be the total number since i've created the database, including all records that were ever created and deleted?

I'm currently doing a project for a research client. I'm building databases that require audit trails and have been looking at several options. I started to play with the Waves-in-Motion solution (log modifications) and find that the validation calculation in their example causes an "out of range" statement ("This field is defined to contain only specific values. Allow this value?" I thought that perhaps the OzEv plug-in was not loaded or expired (I'm using the demoware version) so I tested it by an "External ("OzEv-Version#", "") calculation. It reports back 3.06. The only major change to my system was that I upgraded to 10.2.2 before I started looking at…

There seems to be much angst in this forum about inclusion of images increasing file size. Well, clearly a database's performance is highly related to the number of records (one measure of file size). But it need not be so critically tied to the number of bytes in each record, depending upon how the DBS is implemented. QUESTION: Given a database with 25,000 records, how much does FMP performance degrade for these cases: A) "Portrait" is a Text Field with a 40 character short description : "Portrait" is a Text Field with a 40,000 character long description C) "Portrait" is a Container Field with a 40KB Photo image ??

Hi Again, I have been using Brian Dunning's method to create a bar graph in an DB that I'm working on. The bars are basically a specific number of underscores contained in a calculated field with the line spacing set to 1pix. The calculated field retrieves the underscores from a text field "LotsaUnderscores". I placed that field on a layout, switched to browse mode, entered several hundred underscores, switched back to layout mode and yanked the field out of the layout. When I did that, I thought the underscores that I had entered would be stored somewhere (and they did...for a while), but I seem to lose them when I quit out of the applicaion, and then my bar…

Hi, i've got a problem here and i hope someone here can help me. I want to make a validation and i want the field allow the user enter a code consisting of 1 or 2 letters in the beginning of it and then 3 digit number after it. Will it be possible to do that and if yes then can someone tell me please.

Would a calculation field be the route to go with the following? Is it possible in FileMaker Pro to check every word in a text field in one database against single-word entries (records) in another database and identify matches? All words in the original text field that matched would ideally be highlighted or bolded to indicate match. Additonally, I would like to link from each highlighted word to corresponding fields in another database. Thanks. Gordon

I think I've done my first calc, without help! Okay, okay, I think it's a pretty easy one, but it still feels good! But I want to run it by the forum to make sure there's nothing I'm missing ... if I'm wrong, LOTS of billing could be rejected. I have a CGAS score that must be between 30 and 65. So I created field, number, validation by calc: Case( CGAS >= 30 and CGAS<= 65, CGAS), strict do not allow override, index off but turn on if needed. It appears to work. It doesn't allow me to enter outside the range, only allows me to 'revert' the field if I'm wrong, but does accept numeric changes within the range. Is that right?

Just a quick question. In one of my database files I have a pref. layout with some global fields. Basically a place to keep the company name, address, logo, ect that is then used throughout the rest of the database. To make changes to these fields from the server...not a problem. But of course if I make changes to these globals via the hosts button on a client machine...the changes dont actually take permant. Is there a way around this? LR

Hi, I have a student database that has an achievement level for each student. Achievement is either Level:1,2,3,4. I want to create a school summary layout that provides the number of students who recieved Level 1, level 2, etc. I know that you can COUNT the total number of records for a field, but how do you count how many Level 1's are entered, how many level 2's etc.? Or maybe Count has nothing to do with it? Thanks for your help.

I have a form that has a duration field in which we put in times in a mm:ss format. This was originally a text field. It worked for sorting and finds so there was no need to change it. Howver, now we need to do caluclations with that time and I've changed it to a time field and everything's gone to hell. The numbers are still there but all my references and scripts that reffer to those numbers are off. If I do searches on a particular number it returns all kinds of random entrys. I'm not sure what to do to fix this problem. I'd be happy to provide as much info as possible. This is the script that's giving me problems right now. Case( EPL 2::Format = "9/8" and…

I have a scheduling db that allows users to enter start and stop time for the jobs they are working on. The fields for time are a portal to a timesheet db that i use to produce daily time sheets for the employees. i have a script set up where the user enters his name and the date. the script then finds and sorts(based on time) all of the records for that user and for the date I need the time sheet for. In the header of the timesheet db, I need beginning and ending fields to show what time the employee started and ended his day. This is always the first start time and the last end time of the day. I need to have those time appear in the header. I was am trying to create a…

I need to identify all text in a field that begins with OCP For instance, OCP3, OCP14 etc for a replace Case(PGM=OCP ?? how do I specific anything after the OCP?

Hello, Im trying to create a mail merge letter but need to do find on specific data. For example create a mail merge on all Dave's customers on a certain date. there is a way of doing this in Microsoft Access with the mail merge query option. Is there a simillar way of doing this in Filemake Pro 6. Thanks for any advice Chris.

I have a field that receives today's date when I send a thank-you letter, thus a flag that the letter was sent. Now, a few months later, I want to send another thank-you to the same person. I want the new date to be ADDED to the previous date (both dates now appearing) rather than writing over the old one. How do I do it? Thanks in advance. Maxwell Morlay

Dear All, I got a big problem about Regional setting ...since i am in Montreal so I have to deal with English and French ... When I format the field date as YYYY-MM-DD and set regional setting as English (canadian) I got date weird like 20-10-2002 not as 2002-10-20 and the dcimal is point (.) When i set regional setting as French (canadian) I got weird date but the decimal is comma (,) I really don't understand at all ...I think that when we format a field is what we format is what we got but not true ...we see different with what we got For example, when i click at the field date I see as dd-mm-yyyy but when i click out of the field date I see as y…

I need to run REPLACE through a set of newly imported records Field GL# needs to be set according to another field PGM If PGM="Out Patient" set GL# 4000 If PGM="STDT" set GL 4010 etc. Can someone help me? I think I need Case?

Apparently I messed up the validation calc on my State field... it keeps demanding a two-character code even though I am giving it a two-characer code! As a result, I can't do anything but get validation dialogs. How do I break this infinite loop? Is a Force Quit my only option?!?!

I have this interesting problem. Created a layout with text fields that the users of our database can edit themselves. The layout is an A4 page with fields for the weekly promos. However when the fields are updated it is only for the 1st record. Is there a way to duplicate this automatically to all the records for that given layout so that when we send the layout all subsequent records don't end up with an empty page ?

I have a web shop in Filemaker pro 5.5 unlimited. Every time someone enters the shop (even just to browse) it creates a new record - if the visitor leaves without ordering anything the record is left blank. How do I prevent this? Can the empty record be deleted automatically when the visitor leaves the shop?!

In my database I'm trying to define fields from another field's value within the same database. e.g. ITEM : Name of product SF1212 I would like to be able to create a field which can identify if the ITEM's value contains a serial number or not and to work out from the serial number a date. The serial numbers are after the description of the product and are in two formats. e.g. SF1

Hi everyone: Here is the challemge I am facing: I've got titles: Mr and Mrs John Smith Capt and Mrs Bill Jones etc and I want to end up with Mr John Smith , Mrs John Smith Capt Bill Jones, Mrs Bill Jones Appreciate any suggestions. Thanks. -jack

My first post and already a question ! I have a simple db that logs times on a job, each week has a record and a repeating field for each day, with the number of hours worked for that day. I need to display 3 day totals, so for example the 3 day total on the first day of the week (also the first day of the record) would need to include the number of hours from day 6 & 7 of the previous record, if you see what I mean. How's the best way to achieve this without scripting, just using fields, any ideas would be gratefully received. And sorry once again for asking a question on my first post. Thanks seaDog

Hi guys, I downloaded a filemaker database that is quite useful - but have a problem. It has a calculation field: DayName (Appt_Date) which normally would come out with Monday, Tuesday, Wednesday, etc mine now says: Montiag, DunsBensht, Meiteg, Klegahoogan, Crabskull, etc I can't see any reason why this is considering I'm using my User Dictionary and System Settings is on. Help, how do I tell it that I'm over in the UK and to stop calculating in Dutch or whatever it is? Thanks

Dear All, I have checked the REgional setting about the date and decimal ...I set decimal as point (.) and date as 2002-11-27 . And in the filemaker I set it as above too. Since I put on the host...some machines does not accept decimal as point (.) ...they accept virgule (,) ...and the date is screwed up like 27-11-2002 ....Some machine are fine and some are not ... Do you have any idea about it? ...Could you give me a hint how u set it up? Thanks

i have a calendar file with one record per week which calculates the week number like this: WeekofYear(monday), where monday is the date of the monday of the week. as it turns out, the week numbers start at 2 and go through 53. i suppose i could just subtract 1 from that number, but if the first of january happens to fall on a monday, that's probably going to be incorrect then, or is it? is there a more reliable way to do this?

I'm new to Filemaker Pro and have a simple question thats driving me nuts. I'm making a file that consists of 10 printed pages. The last 8 pages need to be simply text, as if created on a typewriter. What I would like to do is keep the text field from expanding, i.e., when the end of one page is reached, automatically tab to the next created text field located on the following page. Is there anyway to do this? Any help would be greatly appreciated.

I need to SET a group of records on field TYPESEQ. Once set, this field TYPESEQ (text) will be an auto-enter (calc) using a global & 2-digit sequential number so new records are auto-assigned and the sequential number portion will increase by 1. But I'm a bit confused on how to indicate +1 through a series of records in this SET script first, to bring my existing records up to speed. What I currently have is: gType & Right("00" & 01,2) > is this how I list it if I want to begin with 01? But then, how do I indicate that I want to increase only the NUMBER portion by 1 for the next record? Use Right again? It looks like I should do this in two ste…

I have a selection list that is modified in a data entry layout and then is locked in a reporting layout. The data is set once and then is not to be modified. The users would like to be able to use this field in their searches from the Report layout, but even in Find Mode the field does not allow "modification". Any easy way to do this other than create anther layout to jump to in a "find" script?

I need help understanding the form and function of global fields. When I look at the field definition box, I see a list of 'fields' which all apply to EACH record - and each will/may have a different value specifically addressing that ONE RECORD. However, a global field (and some calcs) apply to ALL records, right? This is where my vision fuzzes. The question is: How can I use a global field to 'hold' data that only applies to one specific record? I thought any value in a global field would equally apply to ALL records and display the same value for EVERY record in a db??? It makes sense to use a global as a temporary storage area (hold placard) for data, befor…

Hello to all... I need to change the color background in a field of my employ

I have researched this site thorougly for information on multi-key techniques and have seen several posts, but nothing to explain it. Please forgive a beginner. FM help says it's simply a many-to-many. That doesn't appear to be what the forum posts were referring to. What I envisioned was a method of writing more than one Key field (for instance Invoice#) within one field (Service:Invoice#) that allowed each Invoice# to be listed and it's related child looked up. I hope I'm making sense. Seems I remember something about doing this using carriage return. I think I want something similar to Colbat Sky's Rolling Log, EXCEPT, I don't want it to write to individual reco…