Calculation Engine (Define Fields)

This has got to be the most basic thing but... needing to remove filename suffixes I try: "leftwords ( filename.ai ; 1)" expecting it to return "filename"? but get "filename.ai". I am using "Trim (Substitute (filename; ".ai"; "") to achieve the result but it seems a bit flakey; what if the suffix is .psd for instance?. Any ideas?

hello there, just started using fm.. I have to do a database of work contacts and seem to be missing the point slightly... i have one layout which acts as an index with 3 fields and a button assigned to an expand the record. The contacts need to be divided into 7 sections but preferably stored alphabetically in list form, with the buttons colour coded in order to differentiate between the records various records. i have come slightly unstuck because i can only see a way of expanding one database from the index. I tried having seven layouts and seven indexes which mainly just displeases my boss and seems a bit impractical.... hopefully this makes some s…

Ok, I'm looking to track inventory better, this is gonna be a long project....I'm looking to do more and more and ultimately have a complete business management tool.... I want to track inventory. I've looked at the "templates" - they're a great start...Of course, I want to take it further... When we recieve an order, it might be put in by different people, I'd like to add a table where the details can be put in, and of course, the number of items recieved would be put here, and would need to update the part in the inventory section. For example, we may have 10 of a particular part on hand, order in 15, put in that we've gotten 15 through a more concise ta…

My company is going through an upgrade process where we are migrating from Mac to Windows. As part of the process, our database is of course has to be move to Windows. We recently purchased Filemaker Pro 8.0 as an upgrade from the old Filemaker Pro 2.0 (Mac version) Ok! Enough with the history. I was given the task of moving and upgrading to Filemaker Pro 8.0. We have 30 employees and 2 different work areas. Each is assigned with his/her own building number. My objective is simple: I have to develope clock-in layout that can keep track of how many hours an employee works, how much he/she makes in 2 weeks and how much we make in each area. In order to do that. I'…

I'm trying to write an application that captures start-stop times from data that is manually keyed into the database. In order to calculate elapsed time, I need to be able to control how the AM-PM part of the time is appended. FOR EXAMPLE: Is there a way to key in the value 7:15, select AM or PM from a value list and end up with a timestamp result of 7:15AM? My ultimate goal is to be able to subtract 7:15AM from 12:30PM to get the result 5.25 hours. Any ideas? Jarvis

Hi, Trying to get this serialize by category to work but having trouble working out all the calculations etc... I was pointed to this post http://fmforums.com/forum/showtopic.php?tid/180106 and it links to a document that shows you how to do it but just having trouble importing it and making it work for my set of entries. Cheers elliot

I have a layout where someone fills out 6 things CompanyName, Address, City, State, Zip and Phone I filemaker to require these fields to be filled in, so I went to define fields => Validate during data entry + Require Not empty + Desplay custom message. This doesnt work the way I would like. It pops up 6 pop up dialogs if nothings filled it. 1) Is there a way to make it one dialog box instead of 6 that says you must fill in xxxxx + xxxxx (based on a calculation). 2) Is there a way to validate it before it goes to the next field? Thanks

Hey everyone - I have a a whopper of a problem. I am trying to do something in a field way beond my skill level and need help. Here is the problem I need a serial number in a format as follows - MSF40000B606 This is defined as : MSF 40000 B6 06 MSF is constand never changes 40000 is the 'serial number- changes by +1 each new record B6 is date of manufacture - the 'B' is letter for February,March is a 'C', April is a 'D' and so on.. The number after it is the year built-6 is 2006,in 2007 it would be number 7-so summary if it said A5 then it would have been manufactured in January of 2005 The last 2 are the model year 07 means its an 2007 model …

Last post I learned about the replace function. I have also learned about right and left words. But I have data that I can't use Replace on. Maybe left or right word, not sure. So, here it goes. Data Fields>>[color:red]imported_data(text), country_short_name(calculation), country_long_name(calculation) My [color:red]imported_data looks like this. {between words are space, not tabs} [color:green]AFGHANISTAN AF AMERICAN SAMOA AS ANTIGUA AND BARBUDA AG BRITISH INDIAN OCEAN TERRITORY IO To get the country_short_name>>I am using this calculation>>[color:purple]RightWords (Imported_Data ; 1 ) The problem is with the …

I am attempting to create a script that will allow me to search current records that are late on making their payments, IE; 30 days late, 10 days late ETC; any Ideas?

This question is based on a topic explaining Many2Many relationships in FM7 described in the book "Special edition using FMPro 7". Unfortunately the book does not explain a problem that I am having. Could someone help? As told in the book, I created a layout as shown in the picture based on the table occurence (TO) "Shift" and then inserted a portal based on the fields in "ShiftAssignment". Then Formatted the first field of the portal to display a value list generated from theTO "PatrolOfficer". Everything works fine except that I am able to enter duplicate values into the portal. How can I avoid this? Is it possible to populate the value list dynamicall…

I have a database to manage my study notes/Questions. I wanted to modify it to make it store multiple images per record in a table. One record in a table should be able to show multiple media files and the same media file may appear in multiple questions. I made a join table to represent this Many2Many relationship. What kind of field should I make in the layout to add multiple images to a record in the table? Is this the situation where I use a portal?

I created a simple database to track my customers and have all functions working as required--except one. What I have is a payment field and a and a due date field. What I want is when I enter the payment amount the month in the date field is incremented by a number in the calc field. The formula I used was Payment/monthly amount + Month(due date) but with formula I get some strange results in the Payment due date field. Any suggestions.

I have a number field that I want to display as part of a calculated result in a text field. I want to the number to display as a decimal (ie 50.00). I have tried using SetPrecision( number_field ; 2 ) and Truncate( number_field ; 2 ). I have tried different combinations of GetAsText and GetAsNumber. Here's one way I tried: Let ( amount = SetPrecision ( numberField ; 2 ) ; "Date: " date & "; Amount $ " & amount ) No Luck. It seems like these ideas would work, but NO. Any help? Thank you. Quillpro

I use the following calculation: Int((Random * 499) + 1) I would like to know if it is possible to make the random number that appears to be no less than a set number in another field? so for example if the set number is 200 it can be any number between 499 and 200 but not 199 or less. Also when I use that calculation the field for all records gets filled inmediately. Is there a way for the field to be filled only when I pass through each record? Any help is much appreciated. I am a beginner at best and use FM 5.5

I have a database with student names and want to use filemaker to assign a pickup time for each student so I can create a bus route starting from the time the bus leaves the terminal. I would also like it to be able to adjust if a new student moves into the route. Help

Hi - this is a real SOS as it's giving me a real headache to work out! Here is what I am trying to do: Using the import folder action within Filemaker Pro 7.0v3 (Mac OSX) to import brochure adverts that have been exported (from Quark XPress) as individual hi-res pdfs (each has its own unique reference number which can be identified by it's filename - also imported). I am then required to position those pdfs as graphics in an exact area of a printed pre-designed booking form for each customer. PROBLEM: I am having no problem importing the folder of pdfs into the container field or (obviously) positioning them where required on the page, however, when I …

How can I make file maker run a script when a user selects ..Edit or ..Other from a popup list or popup menu. Can I make it so that FM will take the user to a different layout when someone chooses Edit or other form the dropdown list?

I have started to use the audit log function from Nightwing Enterprises as a really easy way to record the changes that occur in a record. It works superbly with one exception. It does not record changes made from a replace field contents command. This seems to be because fmp does not provide the function through Get( ActiveFieldName )with the current information before proceeding with carrying out the remaining steps: It cannot compare the state of the field currently from what was in the field originally, because it doesn't know yet what field is being activated. My question is therefore how does the replace command differ from simply moving out of a field i…

I am trying to create a Contact Database for my customers. Every customer has name, address, and stuff like that. I have 4-5 different types of customers that have additional information for each type. My question is, do I make 4 different layouts for data entry, or do I make one layout with tabs for each customer type? If I do the tabs, I could have my data entry person click on the type of customer tab and input the additional information. Or should I make seperate data bases for the unique information and then link the databases for reporting? What is the best way to do this? I have tired the Business Productivity Kit. Is this a good system to enter the…

can some body give me a formula for calculating the age of a person. Will be entering their birth date in a field and then in a seperate feild want their age to appear, thanks.

I have 2 fields defined for a serial number in my database: "SerialNumber" and "JobNumber". On creation of a record, the SerialNumber automatically is assigned the next available serial number, based on the field definition specified in the Define Database dialog -- SerialNumber is a field which contains incremental, unique numbers. The JobNumber field is currently set up to be a calculation that appends a letter in front of a serial number -- this field is automatically filled in by the calculation. The specific letter appended comes from a Category field in the database. Example: New Record is made Serial number automatically set to 114 Category is…

forgive me if I'm in the wrong place, but I didn't know where to post this, and the Sandbox doesn't have a button for me to post a new topic. Why does an Apple Computer allow you to use a space as the first character of a FileMaker file name, but a PC won't let you do that? It will let me put the space there, but when I click off the file, it jumps back and removes the space. Any suggestions? thanks, Jonathan

I have a field called [color:purple]US County. Problem is the data has the word County in it. I need to remove that. : {Of course I could use a find and replace, but I am inporting data and I wan't to keep the orginal import.} So: In the field: [color:purple]US County data: [color:green]The Big Boy County Riverside County San Diego County Imperial County etc. As you can see my problem I don't see how I can use a Left or Right (Word) when the field contains 2,3 or 4 words. :qwery: Thus, I need a calcualtion that give this result: [color:green]The Big Boy Riverside San Diego Imperial Can't figure out what to funct…

I have a set of fields which I am trying to get totals from. The idea is to add up how many prints are created at a certain size and price and then have a total cost. The size and prices are as follows A4 @ £25 A3 @ £50 A2 @ £75 so if there were 10 * A4 prints I would charge £250 At the moment I have a drop down menu for the size of prints in one field, a total number of prints in the next field and now I just need the total to be calculated based on what's in those fields. i feel that the drop down menu may be causing too many problems but it is the neatest way of displaying the info, I just don't know how to set the different variables in the…

Field A is a number field for Employees ID number like: 1234 Field B is supposed to be a container field for photo. The photos are always going to be located in the folder D:emp_photo and the pictures are always going to be labeed based off the employee ID. D:emp_photo1234.jpg How would you get the container field "B" to automatically store the picture based off the default directory and employee ID...

My database tracks events. There are several different tasks I need to perform based on the current status of the event. I am trying to create a status field to mark records as one of five different categories depending on the records "state". I have been using the calculation below with some success. All of the "states" are working as expected except for the two "open" and "closed" states. I assume that the problem has something to do with how I am working with the dates but I'm kind of lost. This is my current calculation. I've tried to move the order of the cases around and have tried different ways of ordering the "get current date" steps. Nothing seems …

If I enter a new value into a global field does the autoenter modification information change for all the records in a table when the global changes? Thanks, Drew

Just signing on and continuing the development of database after summer responsibilities.Thanks for previous insights re client specific numbers. The views allowed me to look at things in a different light and are now settled. However now I am experiencing a big hiccup. I have set up a report accessed in browse mode allowing the user to modify specific fields, once completed the aim is then to switch the client report to preview mode via a button set up and script. I have also selected fields to be non printable in the report. The script works transferring the report to preview mode , page set up for printing pausing and user continuing onto printing. However the fields…

Has anyone ever experienced this/Is it possible? FMP 6 Dev, Win XP Pro I have 6 files that were developed before my time and were all based on an original master file. ( they have the same basic structure/purpose) I am being asked to make some major changes to 2 of these files I had no problems with the first but when I go to make the changes to the second I got 95% done and then went to update a field definition and the file crashed. I have spent close to 20 hours on this trying to determine why it is happening. I have a couple of theories and questions for anyone who has had more experience with FMP Theory/Questions 1) The file is trul…

Ok, so the other one was too compressed and nobody could open it. basically, I have a file that needs all the work done to it. Why? 1.) because i can't figure it out. 2.) Because it would be a good tool for people to have. I have a zip file with an excel sheet that has the formula for finding a "straight-line, shortest distance" between two zip codes based on latitude and longitude coordinates. It's in the range of yahoo maps and google maps, except they have sophisticated (dont ask me how) driving routes involved in their equations. Essentially, i think this serves as a good tool not for distance between two zipcodes, but zipcodes within a certain radi…

Hello everyone, I know these are silly questions, but I just want to verify the information. Filemaker does not have limitations on text fields, unless programmers set them correct? Also, the What is the longest (number of letters) a record can be named is over 1 million characters, correct? And users can use any type of character in a text field, correct? Thanks! :

i have a calculation that is working fine when i create the record. but when i change the data (a date) the the other field which has a GetAsDate function as the calculation. NOT WORKING [table 1] date_1 [table 2] date_A calc (get date from table 1 date_1 field) the calculation is not stored. if i put the field in the same table it works, so it seems like it maight be a relationship issue. the tables are linked via their Job# being the same which i verified as such. when i make a similar field in table 1 it works, but that's not so helpful. WORKS [table 1] date_1 [table 1] date_2 calc (get date_1 from table 1) i fee…

I upgraded from FM-Pro5 to FM-Pro8 (yay!). I had a field that said "Is this customer in the Customer Database?" an option box "isCustomer", Yes No. Then I had a pull down box that listed the customers. when a customer is selected, the name, address, phone, etc. would fill in. I used the option box to help prevent people from overwriting the filled-in information. The Filled information had "validation" by "If Iscustomer = yes" If customer is yes, do not allow the user to enter information. It worked... in version 5. Now in version 8, it does not allow the lookup (from the pulldown) to change the box. Does anyone know how to fix it? or a better …

Hi, I am making some changes to a system that was originally created by someone else and I need to fix the following problem. He had previously set up a calander structure in FMP6 and wanted the weeks to start on monday so he set a global offset field to take 1 off the day of the week when setting up the screen. The issue is when months (like October 2006) start on a sunday so when you take 1 off DayOfWeek you get 0 instead of going to 7. Here is the line of code that I think he is using to set this, but I can't seem to work out how to fix it?? DayofWeek( gdTempDate ) - gnWeekStartOffset I tried to achieve this by changing this calculation to th…