Calculation Engine (Define Fields)

I have set up an invoicing table where we have to enter the invoice number based on a complext numbering system. Because of this I don't think I can use the AutoNumber feature. What I would like to do is have another field that will dislplay the invoice number of the previous record as a reference. This would make things a lot easier for us. How do I go about doing that? Thanks.

I'm using this code in my HTML file: [FMP-Field:EditorDesignerName,Break] to produce a list of names (derived from the EditorDesignerName field), formatted with checkboxes and appearing in 5 rows and 5 columns. Right now, the names are appearing alphabetically and are listed by row: alpha bravo charlie delta echo foxtrot golf hotel india juliet I'd rather have the list be alphabetized and formatted by column: alpha foxtrot bravo golf charlie hotel delta india echo juliet (I've lost the formatting on this, but there should be at least two columns.) Is there an easy way to do …

Trolling the forum today I found some helpful things regarding Birthday Calculations. I thought I would post the fruit sof my labors. Here is a calculation field that will return a 1 if today matches the month and day in the DOB field. If today does not match then it returns a zero. Note: that I use the Status(CurrentDate) for the Month(date) and Day(Date) funtions. If((Month(DOB) &"/"& Day(DOB))=(Month(Status(CurrentDate)) &"/"& Day(Status(CurrentDate))),1,0) I am going to use this calculation field in a daily script that will run using Oazium Events that will look for all people who have a birthday today and send them an email…

i have the ean converstion working fine. the thing have to export it to a particular application that does not see the field. i created a filemaker script. very simple one to do the job. below is the script. Go to Field ['AMZean"] Perform Script [sub-scripts, "eanconvert""] Go to Record/Request/Page [Next] Perform Script [sub-script, "eanconvert"] Pause/Resume Script ["AMZean"] i was hoping that this would touch all 31113 records, but it only touches the displayed record. i have to active the script to get the data from the ean field into the AZMean field. how can i have this convert to all the records so i don't have to visit all 31113 files in t…

Hi Stephen, I went to your forum this morning to join... its a matter of "life or death", as in -- the death of my job! I hope this is the right area but something tells me its not... HOWEVER - at the risk of being flamed and lambasted to a nice charcoal black.. here goes... I need to convert filemaker 5 pro records of domains into a html output that puts the domains on the webpage as links, but also keeping them as simple listings in the db file. Like so: THISDOMAIN.COM - (this is the way the domain field text is entered and listed in the database - it has to be viewable in this format) I need it to be outputted into another field for expor…

Hello I am looking for a simple solution to tell me if I have used a number before in a global field called "gNumbers." The Gnumbers field is global and collects all the numbers of the fields I have have used as I use them. I just want to find a way to quickly probe that growing field and tell me if I have used the number before. Thanks Stan

Hi, I have a FM7 DB that is simulating inbound mobile phone call transactions coming from various wireless carriers. I need a script or calculation field that can automatically populate a field at the time of record creation named CARRIER_NAME. The catch is I need to do it randomly yet over time I need to adjust it for relative market share percentage of each wireless carrier. I have 2 tables:CARRIERS & TRANSACTIONS. The CARRIERS table has just 7 records listing the names of the top 7 US wireless carriers in the NAME field and market share in the SHARE field. The TRANSACTIONS table has a TIMESTAMP field indicating the time of the simulated call and the…

newbie. i have a large library. over the years, i manually entered all isbns in to a field called, "isbn". i need to convert them to the original "EAN" bar code numbers. example: the isbn for my japanese dictionary is 438510347X. the bar code that is in EAN 9784385103471 under a bunch of lines. i want to make a field that is called "EAN" and have a script that would automatically convert the numbers in the isbn field to EAN number. can anyone help? i also have a publisher date formatted as follows: MM/DD/YY (01/01/2004) i want to make a field to convert it to: YYYYMMDD (20040101) can i do this and how? for the conversion from isbn to ean, i …

When printing a group of records I sometimes get a record which overflows to a second page. Is there any way I can get a calculation or a script to recognise it is the second page of a particular record? ( so i can put "

Oh, please tell me there is a way to do this. I need to convert decimal degrees to Degrees, Minutes, Seconds. If I have a number 34.54846 I need a calculation that outputs 343254.5 with is 34deg 32' 54.5". I am not sure how to really do this, but it looks like the formula would be- Line A-Take the 34 from before the decimal Line B-Take the .54846 * 60 = 32.9076 Line C-Take the .9076{from the above line} * 60=54.456 Now take 34 from Line A take the 32 which is before the decimal from Line B and last take the 54.456 and round to 1 decimal fro Line C Combine A,B,C and you get 343254.5 I think this is how it would be done Than…

I'm wondering if there's anyway to export or print a list of all my fields along with their definitions so I can send them to someone - either on paper, or to an excel file or something.... is this possible? Thanks! Please email me at [email protected] if you can help Thanks!

Is there a reliable way to make a calculation field that tells dynamically when a person enters and "x" into a field. So if there are 240 records but 112 have an "x" it would constantly total the number of x's/ That is what I need to do somehow . If you can help with this please do so. Thanks very much. STAN

Anyone care to take a swing at this: What is the difference between a Text Field which has a specified Auto-Enter Calculation and a Calculation Field with a specified text calculation? When would one or the other be of better use? Ps. No there is no punch line.

I have a field that when I enter a number such as $100,000.00 it enters the number and does the calculation, but shows a ?. How can fix this and why does this happen?

It's late and I still need to do a lot of dev work..... and my brain starts leaving me... who can relay to that sometimes.... I can't figure out this calculation.... I have two global number fields, say _gnr1 = 3500 and _gnr2 = 3450. Now I need to know how much percentage _gnr2 is from _gnr1. I use this in a progress function, so I loop the _gnr2 down to 1. This means that I need to start with 1% and end with 100%. Who can help me out?

How do I write this script. I want to count the number of records that contain in a field a certain word from a phrase. For instance if the record for the field "Medication" is "patient received heparin and coumadin" I would like to count number of patients that received heparin. If (Medication contains "heparin";1) this does not work and neither does If (Medication = "heparin";1) Any thoughts Thanks

Hello, I have a text field in my database which stores the date in the format dd/mm/yyyy I want to convert this to date format because it should have been in date format anyway. When I try, the standard warning pops up saying "anything after the first 255 characters will be deleted". I just wanted confirmation that by changing the format, my data will be preserved - eg the dates are still dates, but now stored in date format. Will my data still be ok? It's been a while since I had to do this, and I just wanted confirmation.

I have a field which contains a number."Number" I have a global in which I would like to translate that number into the number of times I display the letter x. So if the number field contains "7" I would like the global field to calculate this "xxxxxxx" So if the number field contains "13" I would like the global field to calculate this "xxxxxxxxxxxxx" Thanks Dave

I am currently designing a database where I have one table with classes and one table with students, I need to know how to get the Cost of the classes from classes and do a total owed amount on the student, any help would be aprricated.

Hello I have table called "lane" and it has a field called "Lane NUMBER" I need to make a button that probes another table "REG" and specifically a field called "Lane "AssignmentREG" to allow that number to be registered ONLY if it has NOT already been used. Any suggestions are very helpful . I can understand I have to do some kind of find. But I want to automate this and ALLOW my old script to work UNLESS the number is already in a record on the other table. HELP

I'm converting from Appleworks' very limited DB to Filemaker 7. I'm impressed with the everything so far--except that I find I can't add pictures or files to container fields by dragging them in from the finder. Was "drag and drop" never enabled for Filemaker? It's really tedious to enter hundreds of images by going through a series of menu commands: Insert - Picture, navigate to the file through a dialog box, etc.

I have a cell that is a drop down Y / N once this is entered I want it to auto enter the current date in a date field (but I also want to be able to edit the cell if need be) I had the date field set up so that it was an auto enter calculation If(Selection1 = "Y", Status(CurrentDate), "") But when I click to add a new contact it simple adds in a "?" - which I assume is a formatting thing? How should I tackle this? S

Hi My previous Filemaker person had the company put names in a field with the first name on one line and the lastname after a paragraph return. I would like to automate removing that paragraph return so the full name could be on one line. Can someone tell me how to set that field. Thanks Stan

Please please please help. I have been developing in FMP for a long time, and always get stuck on this type of stuff. Here is the problem. Need to work out what number WORK DAY it currently is. Using Start Date (1st of the month) and End Date (today) and allow for varying number of work days (ie open Mon-Fri or Mon-Sat or 7 days). Here's what I have and it DOES ACTUALLY WORK. However not for every date. If I put in 1/8/2004 thru to 6/8/2004 with working days I get 5 days and I am happy, if I put in the 8/8/2004 I get 5, still happy, if I put in 7/8/2004 I get 6 now I'm pissed. The Saturdays seems to stuff it up. I got the calc from one of the 5.5 t…

I have a calculation which is the sum of the number of contacts withing a company using that relationship I want to be able to flag the contact number of total number of contacts I tried status(currentportalrow) & " / " & total_number_Of_Contacts_in_Company but that is only working if I click on a portal row.... Any ideas?? Thanks

I want a field to look up two values a first and last name and have a full name value with a space between the two I know this is possible with a merge field in the layout, but that won't let me do a proper layout, is there any way to do this?

Quick question.... I am trying to make a time subtraction. Sept 26, 2004 Midnight - Current Time of the Current Day. So the answer would be both x many days left (which I have all ready got), and Y many hours, z many min, s many secs ( I can't get this one) Any ideas? Salesman

I am trying to write a calculation that adds a carriage return so that lines of text will not exceed a fixed number of characters. I got a calculation to start with from the Nightwing website (thank you Nightwing!) But the calculation (below) does not seem to recognize when there already is a carriage return in the field being parsed. So, for example, what happens is: LineBreakBefore (the global to set number of characters) = 20 Original Field: Jane Johnson(carriage return) 10 University Plaza Park Northwest(carriage return) Should Become: Jane Johnson(original carriage return) 10 University Plaza(new carriage return) Park Northwest(…

If anyone could help me with this validation problem, I'd be hugely grateful. Basically, my validate calculation isn't kicking in when it should... Here's the setup: 1. A field "FullName", a calculation that just combines fields First Name and Last Name, set to turn on indexing when necessary 2. A Self join relationship based on the field FullName 3. cFullNameDups: an unstored calculation: Count(Selfjoin Name::Full Name) 4. The script: When cFullNameDups > 1, it should give an error message. This script is part of the process when a user is entering a new person's info. This same exact procedure works fine in another context, for a ma…

I have a number of fields which are not always filled in and I have noticed my display looks a bit alcking when they haven't been filled in. What would be the best way to have empty fields entered as showing "Not filed in" Thanks

I work for a national radiostation that has some programs that are broadcasted 'over' and after midnight. In our schedules, these programmes still belong to the past day, but of course FM will correctly change the date after midnight. Is there a way to tell FM to change the date and day of the week at 06:00 AM??! Any help is very very welcome, since this is a big brainer for all involved and can cause all kinds of misunderstandings.

We have a database of images that are stored using the store a reference to the file option. We need to rearrange our folders & create new ones because we have too many items in one folder and we are getting error messages. We created new folders to organize the images, and that works fine on the workstation that has the database resident. On the other workstation it can't draw the pictures because of the new locations. Is there anyway to remap the file references on Filemaker 6? Any suggestions would be greatly appreciated. thank you!

hello, I have the following problem: each record of my database ITEMS.fp7 (synonym) can have many related items (records) in same database, input via portal to another database related_ITEMS.fp7 for example: separate records in ITEMS with name: colors kleuren rainbow prisma RGB... The meanings are

May seem simple but I could do with some clarification. 1. What precisely is "Always Validate" as opposed to "During data entry" 2. If I use a range given by: From "a" To "s" for example - how does this apply itself to given text input? I understand how the range would work with numerals and dates , but text - how does this work?? thanks in advance

I've seen this topic discussed numerous times in the past, but now that I need it again, I'm having trouble finding it... I have a client that absolutely hates entering delimiters when entering a date. That is, she wants to enter four digits or six digits, with no separator, and have the db interpret this as a valid date. It seems that I need to attach a calculation to the date field that parses the numbers entered using, say, the Left function and/or the Middle function and derive a valid date from the numeric-only entry. I would need to attach such a calculation to every occurrence of a Date field. Does this sound like a correct way to do this?

Is there a way to store relative reference-paths to images in a container field rather than absolute paths (same as with web sites)? My database and the files are all in the same folder, I have to use references as the files are extremely large...however, if I have to switch platforms between mac/pc, or rename the main folder, or publish it on a CD- the images are no longer displayed as it is still searching for file://D:/Archive/image.jpg or file://Macintosh HD/desktop/image.jpg.... please help...thanx!

I would like to start building a graph layout (using chart builder from briandunning.com) that displays historical payment data. I would like to calculate subtotals in two-week increments then store each result in a field that will be used by the graphing engine. I suppose I need a calculation field that does a Sum calculation on my payment field, but I can't figure out how the calculation would only use the records that fall into the date range I set.

Is it possible to distribute an image database on CD (Mac and PC) with container fields referenced to a file of pictures that will remain on the CD?

I can't get this calc to display results. The field "size" is calculated as: If(gender = "women" & product = "longsleeve" , "sm, md, lg", "" or If(gender = "women" & product = "shortsleeve" , "xs, sm, md, lg, xl", "")) Its Calculation result is "text", not calculated if empty, not stored. Gender and Product are popup fields supported by a value list. But when I enter a selectioin in them, there are no data in the size field. I must be doing somethng very simple that is wrong. Advice please?

Using a simple script, (go to field (container field), insert quicktime()) FMP Dev 6 crashes when attempting to insert a *.wav file. It's not a particular wav file, it is a problem with any one that I have tried. Works okay on Windows 2000. Anyone else have this problem? Any work arounds?

Perhaps someone can save me some grunt-work in figuring this out. Background: Library of Congress catalog call numbers alternate back and forth between letters and numbers, like this: "E185.97.L79P48" or "BJ1012.E8957" or simply "B2558" (And some folks append the copyright year at the end). There is little about the lengths that can be trusted. If there is a letter after the initial aphanumeric pairing, there's a period before it, *but* the first period may also serve as a decimal in the first numeric string. Task: My current field (with one-line string as above) needs to have a calc variant for book spine labels that inserts carriage returns like this: …

I have two date fields and I am needing to calculate how many days have passed between them (ie., end date minus start date = elapsed number of days). Example: 1/15/04 - 1/10/03 = 370 I have searced high and low and am unable to find what I would think is an easy solution. Your help would be greatly appreciated.

Hi, Why won't we cease our war against repeating fields for a while and build some constructive discussion about what feature we're loosing in not using them. I'd think the best way would be to explain with some lines of text, or sampler, how you specifically adressed an issue involving repeating fields. What do you think ?

So, I'm having some problems with autoenter serials that are supposed to be unique I've tried setting them to include index and i've set strict with do not allow over-rides and turn on indexing. The problem is i'm getting duplicate keys. I'll blank the database of records, reset all the serials to start at 1, then import a users records to the updated database. But it'll start making new records with duplicate keys that are supposed to be unique? Is this a known issue or am i barking up the wrong tree here. Thanks for any information you can provide!

Hello, It's me, Vandy the MS Access transfer student again. I have a question about repeating fields. I have a purchase order where you can list multiple items from different suppliers, easy enough. In Access I would make a subform related to the parent form, but here I see you can set a field to 'repeat'. This is totally cool and cuts down a lot of work. But the problem I'm running in to is that I want to make an additional layout where I can find a vendor and list all the items from different dates... I can't figure how to do this. I tried to go to the Find and put in "Walmart" or some company, but it returns all the items in the repeated field from that …

This must easy given how common it is, I just don't see how. One of the most important things in a database is ensuring that the entered data is in the correct format. For example: I have two fields, IP address and MAC address. IP must be in the format of; [1-3 digits].[1-3 digits].[1-3 digits].[1-3 digits], like this 111.25.69.87 The "." must be a period, nothing else. MAC address must be [2 hex digits]:[2 hex digits]:[2 hex digits]:[2 hex digits]:[2 hex digits]:[2 hex digits], Like this 23:0a:8d:00:23:bc The seperator must be a colon and the alpha hex characters must be lowercase. Where does a template or whatever exist to enforce t…

Hi, I have a sales file with fields for company, month, year, invoice number, total items sold, price and invoice total. The further details of each sale are stored in a separate sales details file. I want to make a page or layout where I can compare sales in a grid of month and year but so far have been unable to do this. I was thinking a grid of calculation fields might do this but not sure how to make a field only show the total items sold in Jan 2003 or March 2004 for example. Can I somehow use 'finds' within calculation fields? Does anyone have any suggestions for how I could do this? Andy

Hello, I'm new to this forum, as I am to FileMaker, and I need a little help, because I'm not really specialised in databases. What I'm asking is undoubtedly very simple, but I just can't seem to find a way to do it. What I need is for a field to automatically calculate somebody's age, based on the current date (obtained in one field by the Get (CurrentDate) function) and the person's date of birth, which is entered into another field. Can some kind soul please help me with this ? Thanks a lot, Rob

Hi, hope somone can help. I have a one-to-many relationship set up between 2 files (CONTACTS and EVENTS). i.e. each event has one Contact but each contact can have many events. ContactID appears as a primary key in CONTACTS and a foreign key in EVENTS. I want to be able to enter the name of a contact in EVENTS and have the related fields (email, telephone number etc.) appear in EVENTS (possibly in a portal). My problem is that I do not know which fields in EVENTS should be lookup fields and which should be calculation fields, if any! Contact names in CONTACTS are in two fields (Forename and Surname) but I want to enter the full name into one field i…

I am trying to understand how to take advantage of global calculation repetitions. If I have a global text field with 5 reps and it contains data; and I want to use a global calculation with 5 repetitions; and I want to control whether the calc's repetitions display the matching data in the corresponding global text rep, can this be done? Example: Global text contains: Rep1 - Contact Buyer Rep2 - Prepare Quote Rep3 - Schedule Interview I want the global calculation reps to display this data, depending upon a calculation, such as: If NoContact = "Yes", calc's Rep1 should display Contact Buyer (global Rep1) If Permission = "Yes", calc's Rep2…

I am currently trying to make a report that looks to see if a checkbox is checked or not, but am having trouble everywhere I turn, including even making the checkbox value, I understand how to do it logistically, just not in practice... if anyone could help me and wishes to try and discuss the details over email please email me at [email protected] if you would rather type the reply here that is fine as well. Thank you in advance

I am trying to write a Case function to translate a text string to a code. The text string is a language name, and there are about 165 of them I have to translate. The first few lines of the calculation look like this: Case( Language = "Chinese, Mandarin", "0300", Language = "Chinese, Yue (Cantonese)", "0320", Language = "Hmong", "0640", Language = "Laotian", "0870", Language = "Romanian", "1190", Language = "Russian", "1200", Language = "Serbo-Croatian", "1270", Language = "Spanish", "1380", Language = "Ukrainian", "1520", Language = "Vietnamese", "1560", When I paste the list into the Specify Calculation window, I get an error message say…

Hello I have a database which has a specific date attached to it. At the end of the week we close the database and create a new one ( no records ) and start the process again. The file is opened with a script but when I move to the new week I have to open the file with another script. Is there a way to script which file gets executed on startup of the file without having to go i n and manually enter it? Thanks Stan

Using WinXP and FMP 6.0v4, a learning novice: I will explain the best I can. I have 200 people in my FMP. I created a field called "placed finished in race". Data entered is: 1st place, 2nd place, 3rd place, 4th place, 5th place, 6th place, 7th place, 8th place, 9th place, 10th place, 11 place, 12th place, "Not Finish" and " " are all entered into this field. I think what I am asking help for is to count how mant times 1st place thorugh 12th place have been entered. This will give me a count of how many kids finished a race when it is run... FYI: I do not want to count the "Not Finished" or " "-blank fields.. any help in creating a cal field for this.…

I want the calculation to show data from a field between two chacters. An example might be more clear-- ************************************** Field---PaymentData, text cc First Nmame = Bob cc Last Name = Smith cc Type = MASTERCARD cc Expired = 10-2006 cc Number = 123456789123456789 cc CVS code = 12345 ******************************************** What I need is 6 calculations fields that only show the true data. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Thus Calculation 1--Let call it paymentfirstname, calculation, text I only want this calculation result to show me [color:"red"]Bob Thus the Calculation must find data…

Anyone know how I can do this? I have a core table called "clients". I have a related table called "state id's". I have reports that are generated from dated in other related tables as well. I have a table called "report steps". Now I have a "status" window based on the "report steps" table. This windows shows the status of each "clients" report. For some of these clients they have related "state id's". For each "clients" "report steps" I want to display the "state id's" that require this report. Today, each "clients" "report steps" record has a small portal window displaying the "state id's" for each client. The problem is that I don't want a) a portal win…

Hi I would like to know if there is any way to tab from one field in One layout to another duplicate field and another layout. Is this possible. Thanks STANN

Hi Everyone, First, I should say that this problem exists in both v7.02 for Windows and MacOS X. The problem did not exist in version 7.01. To replicate the problem, define the following three fields: A Text B Text C Text Auto-enter Calculation = A & "-" & B For field C, un-check "Do not modify existing value..." and "Prohibit modification of value during data entry.". Under the validation tab, check "Not Empty" and "Unique". Then, set Validate to "Always" and un-check "Allow user to override...". Create a new record with the values "A" for field A and "B" for field B. Field C automatically evaluates as expected. Create a second …

First post so if this doesn't make sense, please go easy! I use FP v6 to run golf tournaments. Players give their exact handicap to one decimal point which is entered in a field. A second calculation field using the round function then converts this to their playing handicap. The problem is with the plus handicap players which I have to enter as minus figures e.g plus 1.3 is entered as -1.3 for other calculations to be correct. However, golf is peculiar in that it rounds plus handicaps (entered as minus) the opposite way to FP. This is only the case if the exact handicap is plus 0.5, 1.5 or 2.5. FP rounds these up to -1, -2 and -3 respectively but the rules of…

I was wondering if anyone has written a calculation for shortening organization names & addresses. I want users to enter the full names and addresses of organizations and keep the data accurate (otherwise various problems were cropping up), but when it comes time to print labels, that can mean the info doesn't all fit. So I need a calculation that checks the length of each line, and, if it is too long, uses common address abbreviations to shorten it. And if that doesn't work, I guess just trim off the end and hope it still makes sense? And if there are too many address lines, it would also have to combine and then shortens them. I'm sure smarter minds than …

Hi, I want a drop down menu to affect the content of another field. For instance, if I choose 'option a' in the field another field will automatically fill with a '$400'. And 'option b' changes it to '$300' and so on. Sorry if this is simple but I'm basically new to FM. Thanks in advance Chris

Hi all, I was hoping someone could help with the following problem I have encountered, I have 4 text fields that I have concatenated into a 5th calculated text field- all the fields have the text formatted to title case. On some of the records the calc field is displaying correctly with all the text in title case and on some records the first half of the calc field is displaying ok but the second half is displaying in lower case. any suggestion please. I am using FM7 and WinXP Pro many thanks RayC

Hi forum, I'm kind of a newbie, so bare with me.... The problem I'm having is that I need to underline a field value (between 0 and 9) whenever a certain condition occures. The closest I came (I think) to the solution was to create a dummy table, with 10 fields, with values from 0 to 9, which I underlined "manualy". They store fine, whenever I browse that table, the values are still underlined. But when I, within a script, use the Set Field function to paste the underlined value from the dummy table into the main table, the program does in fact execute the past, but the underline is gone...... Any clues ?

I hope someone can help me with this issue. I designed a database that includes a "date field" and a "calculation field." I named the date field (registration date) and the calculation field (total days). I want to know the number of days that pass between the current date and the date entered in the date field. I set the calculation field as the following-("Today-registration date"). This seemed to work fine but you need to exit the database and open it up again for this to work when the date changes. This option would not work on a network setting. I want the correct number of days to automatically update when my pc's clock changes. I would appreciate any help …

I have a field "Total Cost" which is a calculation from 2 other fields Photo Cost + Copy Cost. I now need to perform a calculation if a radio button from a field "Discount" is checked. If this radio button is checked then I need the "Total Cost" field to be reduced by 50%. Thanks in advance Dave

Using FMP6 WIn XP Is there an easy calulation that will take a field that contains a persons full name (George Bush) and pull the first word out (GEORGE). Then I could do the same with the last word (BUSH)? Thus splitting the full name? When I am done I would have 3 fields: FULL NAME, FIRST NAME, LAST NAME

Hey guys, I'm pretty new at File Maker (I just started a new job and they just sort of handed me the manuals, heh) and I've got a question. I'm working on a rather large number of data entry fields (About 475 as of now), but it only shows about 450 of them on the table itself. Any after that show up as defined, but don't appear on the table for entry or modification. Any help would be well appreciated! Thanks, Scott

I have a field that contains text like 1.11/1.55, 1.66/.66, .66/.22, etc.. I need to put everything after the "/" in another field. Is there a way to do that? It's in a FM4.x db but I could put it in FM5.x if necessary. Thanks

I have over 200 people that did push ups 5 different times. Each time they did puch ups the score are recorded into FMP (PU#1, PU#2, PU#3, PU#4, PU#5). What I would like to do now is create a field calulation that will show the percentage of times "BOBBY" did more than 5 push ups? Is there an easy formula for this? It is now 2:00am where I am at and I can not figure it out. "Novice" using FMP 6/0v4 WIN XP.. Any help would be thankful.. Thanks

Hi I have been trying to make a database solution for my medical practice and I am stuck with something. The database contains two main tables Patients with the usual patient details, history etc and Visits where the patients' visits are stored. The two are related via the Pt_ID so that each patient can have many visits. In the patient's table I want to have a field where I can store the date of his last visit. At the moment I have a layout with a portal where all the visits are displayed for the selected patient and by clicking on a button I initiate a script whereby the portal is sorted by date and then filemaker is instructed to go the last row and g…

I am wondering why this is happening- The field works fine within FM, hold Jpegs, I've tried it with refrences but also with the files stored directly at filemaker...the rest of the db works fine. Any advice would be greatly appriciated!

My databse has a container field that displays a TIFF image. This field works fine when i'm editing the database directly but the images don't appear at all when i use IWP. The images are stored directly in the DB and not by a reference. I suspect I need to use JPGs to see these images in a web browser. Does anyone know of a reasonably inexpensive plug in that will convert the TIFFs to JPG/JPEG for viewing on the web? Any advice would be great thanks, Colleen

Hi I have a spreadsheet where presently if the customer owes something it becomes a negative number in the field "service". I would like to have a calculation or a script that sends that number to another field called "owed" only when there is a negative number in the "service" field. So if the service field says -$220 then the negative sign somehow signals that the number should be placed in the "owed" field for $220 . that is what I am trying to do but I just don't know how to do it. Thanks Stan

Hello, this is my first post so please bear with me... I am a new user of FMP7. In the database that I've created, i have a Table of Samples related to a table of Labs. Each sample is collected in one of 6 container types that I have listed in a container field with a value list. The containers are supplied by the Labs. I would like to sum how many containers of each type I have in my sample table and have that value reported on my Labs table. In other words, Lab X needs to send me Y 1-gallon jugs. I could not find an easy calculation to do this. Is there a way to do a conditional sum of non-numeric data? Thanks for your help.

I am having trouble with a phone number format. Initally I had it working fine Let( P=Filter (Phone2;"0123456789") ; Case( Length (P)=11;Left(P;1)&" ("&Middle(P;2;3)&") "&Middle(P;5;3)&"-"&Middle(p;8;4); Length (P)<10;P&TextColor("not enough digits";RGB(255;0;0)); Length (P)>11;P; "("&Left(P;3)&") "&Middle(P;4;3)&"-"&Middle(p;7;4) )) This worked great for normal numbers and basicly left the internationals alone (which is what I wanted). Well this solution runs into a problem when importing data from our accounting package (were the master data is kept) In the account sof…

Is there any way to get a line count from a text field? Let me explain: I have set up a text field box to 2.5 inches wide set the font to "Times New Roman PS Italic" and the point size to 10. The above info is important because when I select that text field it is placed into a text box (2.5 inches wide) in a desktop publishing program (QuarkXpress) and styled with font and size info as above. The count of lines is important because that will determine the depth of the box in QuarkXpress. Thanks in advance Dave

Hello all, I am trying to create a log of changes to a field using John Osbournes technique from his sample file "Change Log". It tracks who, when, what field, and what data was changed into a log field. I have no problems creating the log when the data entry is done in the same file (not through a file reference) as the data. But when I do data entry to the exact same Table Occurrence through a file reference, the changes are not logged. Anyone have an inkling why? or what to do about it? Below I have attached the code, which is set to auto enter with the do not replace existing value unchecked, for the log field (it is in the same table as the field modi…

I just bought 6.0 and recieved it today. I am trying to set up an inventory tracking/database for an internet site I am in the process of starting up. The help files are pretty scant. When I called to enquire whether the product would support what I need to do, the tech told me, "absolutely," but I can't figure out how! I would like to enter my items and have an alpha-numeric serial number assigned in sequential and alphabetical order. I make jewelry, so I would need the inventory, for instance, to read like this so that I can place the serial number into a web shopping cart later on: Item 1: AmyGF 1001 (Amethyst Gold-filled number 1001) - Serial #AMYGF1001 It…

How do I go about Rounding the result of a calculation? Here is my calculation: (weight / (height * height))* 703 I know to use the Round Function but I am not sure where in my calculation it goes? Thx

I need to strip/remove the last comma from thousands of records in our database. We need to leave the middle comma in place and we only need to remove the last comma: As an example the existing records read like this: ENGINE HARNESS, with gauges, FORWARD LAMP HARNESS, with gauges, The new records need to read like this: ENGINE HARNESS, with gauges FORWARD LAMP HARNESS, with gauges I've tried creating a new calculation field and utilizing some of the different functions (right, replace, substitute etc.), but just can't seem to solve this one. Seems simple, but this one has me stumped. Any suggestions? Thanks.

I am probably overlooking something but for the life of me I cannot figure out how to put an If statement into a calculation...here is my calculation so far: 655 + (9.6 * (weight / 2.2)) + (1.7 * (height * 2.54)) - (4.7 * age) Now I have another field that is a value list called Activity Level. I need the choices in the list to equal a numerical value. So Sedentary=1.2 Light=1.375 Moderate=1.55 Very=1.725 Extra=1.9 I need the result of the above calculation to be multiplied by the activity level. First how do I make the value list choices equal a numerical value and then how do I finish my calculation with the If statement (if that's what I should be using?…

Quick question: I have a calculation field set to calculate age: (TODAY - Current Date)/365.25 This works, but the field either rounds the age up or returns 32.99 years old or 18.24 years old, etc. How can I make this calculation field always round DOWN to the nearest full integer (no decimals or rounding up)? Shane

I have a solution using very long case statements which works but is quite slow. I

Greetings! I have built a small utility that uses a complex formula to calculate the distance in meters between two points based on their respective Latitude, Longitude and Altitudes as reported by a GPS tracking unit. The utility appears to work but the values that it returns are way off. The reason that I know they are way off is that I have runt the same numbers/formulas, etc. through excel and know what the correct answers should be. I set up the formulas in Calculation fields and copied the formulas directly from Excel. My guess is that there is something going on with the conversion of Radians/Degrees that is done differently between FileMaker and Exce…

I have a time database that people enter times every day into. It's tedious (I need a barcode solution, it's coming), so it would be nice if instead of formatting time, one could just enter 0600 and FMP would know that you're referring to 6:00am, or 1300 --> 1:00pm, etc. etc. Is there any way to do this by calculation, or am I stuck trying to find a plugin?

Hello I would like to export a bunch of Vin numbers ( now in different records in a field called "vin") to one field with paragraph returns ( called "vinNumbers" . How is this done? I appreciate your help with this. Thanks STan

Greetings all! I have a problem that I hope someone could guide me to a better solution. I have created a from where users can enter measurements and based on these entries (which includes type of material, weight of material

Hey gang, I was wondering if there was someway I could create a script in FM to create a field in a table. Ideally I would like it to take a value from another field, where the user has entered a text value, and create the field using that value at the name. Thanks!

Can I extract text based on any given line in a text field? For example Name (line 1) Address (line 2) City, ST, Zip (line 3) Thank you. First timer.

I would like to create a report that summarizes the date field. I would like the date field to be in monthly increments. Can a Date field be summarized with a calculation or script so that sub-summary reports are run for weekly, bimonthly, monthly, and quarterly sub-summaries?

We have photography studio which photograph students in schools. I have made a database which has a photo shoot date and every service we give to schools such as Rolodex cards and yearbook CD have a due date that must be back to schools on those dates. I need a report that can create a Due date and Overdue date so my staff can get on it right a way. when I made a report layout it asked me for the field I need and I pointed to (School name, YB CD and Rolodex Cards and so on) But when the reports were generated they have all the schools and all the services, I need an action or script that will bring only the Overdue schools and their Overdue items. How can I create such re…

I am trying to work the kinks out of my running sum in a report. It is behaving erratically and trying to find out why. My report is set up as follows FieldW FieldX FieldY FieldZ RunSumZ. FieldZ is a calculation field (FieldW + FieldX - FieldY) The running sum will go along and run then start over when it should not. To run I have a a serial # and a previous serial #. I have a relationship linking the previous serial # to serial#. My running sum is to start over when a new account# is reached. (its supposed to run for account# 100 then start over for 102 etc..) I have a script that finds my data set and sorts and then replaces serial#. When…

Hi all, I've done some reports in filemaker that rely heavily on Summary and Calculation fields. So much in fact that all the time now I get the "Summarizing field foobar..." all the time and it takes forever to calculate the fields. Are there any way of minimising the amount of time it calculates these fields? Is there an option to calculate once and only when something is updated? Thanks, Steve Griff

I'm working with a nutritionist to prototype an FMP database that will be used to evaluate patient lab test results. It has a large number of rules, which are applied to the lab results that are imported into the database. The kicker is that the rules are often changing - hence a primary design issue is

I do development with both Japanese and English versions of Filemaker. I have noticed that in the English version the delimiter for a "word" can be any non-alphanumeric character. This is causing a problem because some time my data contains hyphens and other punctuation. This means that if the data in some_fields is "s-1-5-21 some more data) the text function leftwords(some_field, 1, 1) will return "s" instead of "s-1-5-21". In Japanese, the function will return the proper string but not in English. Is there a way around this? Regards, shirokuma

(I apologize if this is a naive question or inappropriate for this particular forum. Additionally I apologize if my terminology is off--that's been a big problem for me finding how to do this, I think. -)) I have two fields representing computers, manufacturer and model. Appropriate values for the field manufacturer are members of a value list of the same name. Appropriate values for model would ideally come from a number of value lists, the choice of which would depend on the manufacturer. I suppose I would want to represent that something like if value(manufacturer) == X, then value-list(model) = value-list-x where I would be writing such a con…

I would like to know how to filter specific text from an area, specifically, I want to filter the @webaddress.com from an email address but still show the sombody part of [email protected] if anyone could help me it would be a big help

Hello! I saw a movie file on filemaker from filemakerforums.com. In the movie, he has a field which shows 'Enter your name' And when he starts to enter his name into the field, the sentence disappears and field gets ready to receive input. I want the same thing, but there isn't any information about this simple thing in the movie. He was trying to teach a more difficult one without explaining how to make easy one, but I don't know how to make the simple one either. How can I make this? My field is a text field. Should I make the field a calculation field? I'm a very newbie and get no idea of making this. plz help me . Thanks~

Hi everyone I want to find a solution about the calculation of dates. Where I work is applied a "special price" based on the years workers have been working for this company. Let's say, if they have 1 year they get 5% plus, two years 10%, three years 15% after which it stops. That's the most they can get (15%). So I Have setup a field like this: Get ( current date ) - datestarted Where the datestarted is a field which contains the date they have start working. If I want the result to be a number, it gives the right difference of days that have been passed, but if I want the result to be a date, it gives it to me the wrong difference. Let's take this example …

I currently have a popup list and a go button... A user selects a city out of the list and hits the go button and the fields to the right are populated. (i.e. percentage of males, females, percentage of age ranges, etc.) The database already has a gender field and an age field which is populated with "M" or "F" and the actual age repsectively. I simply created a calc field that states "if Gender="M", 1,""). I then do a summaryfield that counts the number of "M", then I do a calc field that shows summaryfield/total_city_pop. This gives me the percentage of Males as a total of a certain city population this works, but is obviously a longhand and screwed-up approach. Ev…