Calculation Engine (Define Fields)

Hi all , I just make the [color:blue]Goods Receiving to my client, what I want to do is when they key in the [color:red]Cost or [color:red]Selling Price in GR, can I automatically update into my [color:blue]Stock Keeper Record field [color:red]Cost and [color:red]Selling Price? Hope your understand, Thank for help! test.zip

Created a portal with contacts in it. Created a button within each row of the portal record assigning the script 'Delete portal row' to the button. When I click on the button to delete the selected row it deletes all of the rows of the record.

Is there a way in Filemaker Pro to have it retrieve system information (operating system, hardware components,etc.) and auto fill the information into fields?

Hi, can I get a field to display the last date a record was modified without any user interaction, i.e they do not have to press a button to say the record has been modified

I know the total number of records is listed to the left in the tool palette. But is there a field I could use to show the total record count? Basically something that displays the total number of customers in the database? Thanks.

Hi there, I have a database where I have a field for Gender. The field can be entered by selecting "Male", "Female" or "Unspecified" from a pop-up menu. I am importing data from an existing database (excel file) where the fields were only entered as M, F and U. How do I tell Filemaker to automatically change the letters to words? (Eg. "M" becomes "Male"). I am sure a simple calculation should do the trick, I tried using a Case-statement, but it didnt work, maybe my implementation was wrong. Help would be greatly appreciated. Thanks! :

I have a child file of contact names usually there are less than 6 entries, sometimes 0. On reports I often throw a small portal to show up to three values. I'd like to create a calculated field in the parent that is a text summary of just the names from all the related contact records, and then the reports can just show the summary. Could anyone help with a recommendation on how to do this? Thank you.

I have a field that is populated from the web off a form using GetLayoutObjectAttribute... This field is then included in a meeting request for use in Outlook, basically an .ical file. This is what I'm importing: Case Summary: cust unable to browse* Description:*SAT:hzn* *TRANS:11 K *Software Version: *SERIAL_NUMBER: etc..... I have used the "*" to illustrate where my problem lies, in filemaker it shows up as a "square", I'm assuming this is some sort of unicode character. I thought it was a carriage return, but using the substitute function am unable to get rid of it. In ultra edit this shows up as a carriage return, not sure why the substitute isn't…

I've tried searching the forums but am not finding anything that sounds exactly like my situation - I'm not greatly skilled with FM, so if I am missing an obviously better approach to this, please let me know. I have a multi-table relational db set up to track artists' hours on various tasks as they build assets for the cg film we are working on. I have one table, asset_tasks, that holds every task (modeling, rigging, etc.) for every asset. So a sampling of the records looks like this: asset - task - actual hours box - modeling - 10 box - rigging - 12 house - modeling - 5 house - rigging - 3 The asset list and the task list are both populated from th…

I have a table that contains several different classes of images. I need to mix various images into one record in another table - It is a product catalogue that shows interchangable parts of a finished product. Am I best to separate the various classes of parts (images) into individual tables and relate these to the completed product table or is there a way to collect the required images from one table into a single product record in another table? I have it working the first way but would like to simplify the structure and updating process.

Based on a user's answers of 2 questions on (n) Records, I need (ValueList)summary results to be displayed on a fixed grid. I have downloaded the "Checkbox Summary" example and searched the forum, but not found enough information to help me get over the hump. I am attaching a base file and left out any relationship definitions in hopes that someone can get me going in the right direction. I have simplified my overall need to a 3x3 grid. Thank you very much, Robb Summary_Grid.fp7.zip

Is there a way to format a numerical field in browse mode so that clickling a little up or down arrow key increments the value of the field by one integer? This happens automatically for the year value in the pop-up calendar facility in FMP8.0 and I am hoping there may be a way of doing this on other number fields without having to create and define script buttons. Many thanks for any suggestions, George

Hello, I have been searching all over for an answer to this question. I am working on a membership database. There are three membership types: individuals, companies, families. I can't figure out how to set up the families layout when I have a couple who have different last names at the same address (John Doe, Jane Smith). I would like to be able to be able to find both names when I run a find so putting both names in a last name field would not work in a find. I'm pretty new to Filemaker but I know this has to be possible. Does someone have a sample layout? I am working off the contact template that was included with FM 6. Thanks, MT

I found the lower()and upper() function. I also know I could filter the data. What I want to do is replace the data permently. Current data [color:red]UNITED STATE OF AMERICA ===>United State Of America Any idea on function because I couldn't find it? Thanks Chuck

I have a script that I'm trying to setup to remind me that a backup of my data is due. The attachment shows my main script which is called up by another one. It is all based on 3 fields: [color:orange]SelectBackupDays - which is available to the user on a Preference layout that allows the user to select days via a value list: 5,20,30,60 or 90. This is set number of days that must be equal to or past before the user is prompted. [color:orange]LastBackupReminderDate - This is a date field that is updated with the current date ONCE the user prompted with a reminder. [color:orange]BackUpDatePreference - is a calc field with a number result based on (…

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…

I am trying to understand whether to use the filter function in a calculation. Here's the scenario: I have one table called AllModules. This field contains four text fields: ModuleName, ModuleType, ModuleBody and ModuleID. The latter is concatenated from ModuleType and Module Name (ie, Module Name might be "Weekly" and ModuleType might be "Cleaning", so ModuleID would be "CleaningWeekly"). ModuleBody contains text that describes the ModuleName (ie, "This is a weekly cleaning module . . . ") One a separate related table (related via ModuleID) I have a text field called CheckboxField that is set up as a checkbox. This field automatically reflects the value list of…

How can I write a script that when a user tabs or clicks in a field, it selects the entire content of that field? Is it possible to make FMPro 7 run a script when a user clicks into a field?

Hello, I have a field called "contact id#" that is the link between two related tables I have. How do I make this field unique so that it is impossible to imput a contact id # in one record that is already being used in another? TIA!

I have a report that is run on a database called "events" which has a relationship with another database called "acts" via the actID. In the events database I am running a report to show total income for events by Act and one of the fields shown for each returned act is Target Gigs which is stored on the Act record in the Act DB. It is showing fine in the main part of the report but I have a summary at the bottom that I want to display the totals for the returned records and it is calculating fine for every column except Target Gigs which is showing the total of all target gigs for all acts, not just those returned by the find request.

I thought I had a good start on this then my brain fizzled out. What I want to do is have a user, in a runtime solution, enter a password so that other users can't accidentally delete records; the password would be required before each record is deleted. (Yeah, I know I could make it a one-shot deal through an account privlege set-up, but trust me...the users need this kind of set-up.) So, the problems I'd like to solve are... 1) How can the primary user enter a password (and be able to change it later, if he or she wanted to) without having to "hard code" it into a script...which a runtime user can't do. 2) I tried to enlarge the text in the user-defi…

I'm trying to use FMP to track class/student attendance. I've got my classes and students setup and what I'd like to do is be able to enter in who attendend what class and then run a report saying average attendance is...I'd also like to run a simiilar report sayind "john smith attendended an average of ..." make sense? Anyone know how to do this? I'm trying to use a check box for a simple check meaning "yes" and unchecked for "no" on attendance. Thanks for all the help!

I'm trying to get a weekly report with the following things: Artist's name (We have a few) Thier totals for the last week (How many images they got done and put into Production) Everything I've tried I can't seem to get working. I don't get proper totals. Please I'm begging help!

Hi, I have a huge and complicated problem. I'm new to FMPro8, I'm working for a new company that created there DB in 1994 by the boss who is not a computer professionnal. They've been adding fields and tables since then... not normalized!! :s So think about that 12 years of development without normalization. My task is to create a new DB in parallele, but I also have to patch the original DB. The problem is that I have a 1800+ fields in a single table. When refreshing data, the speed for refreshing textual data is Ok, but when there's some picture that they fetch on a NetDrive, it is way too slow (I'm talking about 5+ minutes to refresh a single layout). …

The subject sais it all... How do I do this please? I'm sure it has been answered before but I cannot find it... Thanks, Lukas

Hello guru's! I am trying to find a way to display the field names from a table similar to the "LayoutNames ( Get ( FileName ) )" Function. I have looked everywhere and cannot find it!

I'm trying to connect to FM via ODBC. This normally works great, but I've run into an issue where one of the fields I need returned is a calculated field. As such, it cannot be indexed, and that calculation causes a very slow response when working with this particular data selection. Qty_Available is the field I need returned. It calculates the value based on Qty_Received - Qty_Sold. If create a Qty_Available2 field that is not a calculation field is there a way to have it automatically always have the value that Qty_Available has? This way I could use the second field in my SQL and since it's not a calculation field it will hopefully be fast. I need it to …

Hey all, Have patience, I am teaching myself filemaker. Ok, at this point I have a Customers table and a Contacts table. They are related via CustomerID. There can be many contacts for one customer. I have a field in the Contacts table called "Same Address". If the value of this field is yes, I want "address, city, province, postal code etc..." to be copied from the Customers table into this Contacts record. Any help is appreciated. Thanks! p.s. have tried to make Contacts::Address a calculated field using: If(Contacts::Same Address="yes";Contacts::Address=Customers::Address;"") - but it doesn't seem to work - if it says yes, there address …

i am using a calculation to set a field with text. i use the match of this text to another relational database (this is all in fm pro 6, unfortunately) to create a relational value list. up until now, the relation has been based on text. now i need it to calculate a text field as well as if it is after a certain date. and i am not getting the right results. here it is: If(Left(Customer ID, 5) = "Enron","Enron", If(Customer ID = "TS&S Employee","Employee", If(Customer ID = "TS&S General","General", If(Customer ID = "Tower Automotive","Tower", If(Customer ID = "Saint Vincents","St. Vincents", If(Customer ID = "Delphi Corporation" and Slip Da…

1) I currently upgraded from FM 5 to 8. Previously I scanned documents and stored the document file in a container as address to a "scan server" (actualy a old G3) Now with FM8 files able to store a terabyte of info, I can store the scanned documents inside the container field as a file rather than an address. The question is: will a file of 40-100 gigabytes or so cause the solution or the FM file itself to run noticably slower on the network then if these documents were stored as addresses? Also, any other issues I should worry about with saving (thousands of pages) as a file directly into the container field in FM8? 2) If the answer to the above is "save as ad…

Hi, I've been maintaining a database that had a repeating global container field with 5 repetitions. I recently added a sixth, and when I paste the correct image into the sixth repetition, it is no longer there the next time I launch FM. I tried both inserting and pasting with no luck, in addition to trying multiple image formats. I've also made sure that it doesn't store a reference to the file. It's a very small image simply comprised of a solid color. Have any suggestions as to why the container won't retain the image? Thanks!

Hi, I want to be able to put the recordid of the displayed record (in form view) in a global field automatically without script. Doing Get(RecorID) in a global calculation returns the last record id of the whole database. I tried a self relationship based on record id in a global calc, without much success either. I've thought of FM 8.5's get object layout, but my solution has to work on 8. Any help ?

Two problems I would really appreciate help with: I have lots of date fields, some are before today, some after. I want to have a field that will calculate and display the next date after today, and another field that will calculate and display the last date in the list prior to today. The two closest dates to today's date in two separate fields. A second problem is that I have two start dates for a project. I have a calculation that looks at these dates and works out a Due Date 90 days ahead for each of them. I only display the later date. The problem is that if those start dates have not been entered (the fields are empty) the calculation is still done and the …

This should be easy for someone. I have a checkbox field with 9 options run off a custom value list. I am running a report of how many times each option is checked throughout the entire db. There might be an easier way, but here is what I have. I have a calculation field for each option of the check box field. So I have 9 calculation fields. Each field will calculate a "1" if the option is checked. For example: If(T_strategies= "Presentation";"1";"") The problem is that if I have more than 1 tiem checked, the value of T_strategies is something else like: "Email Presentation" instead of just Presentation. How do I tell the calculation that if T-strategies h…

Does anyone know of an option or script setting that will automatically use a field's data as the document name for the PDF when using "Save Record as PDF"? Seems like it should be a natural feature but I must be overlooking it. Any help is greatly appreciated. Thanks.

Well this is probably simple and I am overlooking how to do it so I hope someone can please assist me. I have a studentid field that has a number in it. The leading zero is missing on all the numbers in this field because the excel file was formatted incorrectly and it lost the leading zero for every student id. What I need to do is insert a 0 (zero) in front of each number in the field. I can't figure it out all I manage to do is replace it. :-( Any help would be greatly appreciated.

I have created a main customer database with cust number, and I have also created a purchase order database to be able to track purchase orders for each client. I have setup a relation with the purchase order database, and have used a portal within the customer database to display/add/modify the data from the purchase order database. Here's the problem. on each purchase order I have a place for unit cost, then the tax on unit cost in another field. I also have a field right before unit cost that says TAXED? and options on 0 or the current tax rate. if left to 0 the tax isnt displayed in the unit tax field, but if current tax rate is selected it will show tax o…

Hi. I have a layout that has a portal for comments. I set a validation on the comments so that only records that were created by the logged in user can be edited or deleted [Get (AccountName) = REC_CREATE_ID] where REC_CREATE_ID is Auto-enter account name. This works but there is a problem. If the user edits any of the information on the main layout then tries to edit a record in a portal that they did not create, they are presented with an error message and option to Revert Record. If they revert, all the changes to the main layout are reverted as well. Is there a way so that ONLY the changes in the portal are reverted, and the changes to the main layout are no…

hi — sorry i know this may seem like a dumb question, but i am very new to filemaker and need some assistance. i have a database with over 400 records. in each record there is a 'word count' field in which a number is entered, such as "250" or "500" or "1500" depending on the number of words in a relevant item. i wish to create a field that appears in the header and which will give me a total number of words across the total records: ie a total word count for the project. i've tried some formats and simple equations but can't seem to get an accurate result. can anyone please let me know an easy way to create and format a field and an equation to get t…

I need to limit the number of characters that can be entered in some of my text fields in a table (ex: ClientCode: 10 char, ClientName: 50 char, ZipCode: 6 characters, etc). I just don't seem to find the place where I can do this in FM. Coming from a MS Access/classic DB development environment, I find it really strange that nowhere you define the length of your text fields when setting up a table in FM. Or am I not looking properly ? Thanks

Hi when do stored calculations recalculate? Can you force it with a script step? How about global calculations. How do they work and recalcuate?

How can I set up a field size to its content. I have a text field containing as for length very different texts. When creating a report in preview mode I would need the field to be changeble and be able to fit to content. I tried to make the field as big as largest recort and use "slide" options but this makes empty pages at the end in preview mode as my fields goes across to many page breaks in browse mode

How do you get a list of values in one field. I know can use the List function. But list function list out all in that field. Let say i got a table with 2 fields. Product ID and Serial Number. Taking note that the product id is not unique but the serial number is. I want to create another field which can list all the serial numbers from the particular product id in another table.

Hello Everyone, Im so very lost. I read the books, I've asked FileMaker but I can not figure this out. I created a database for our writers in our publication. I have to list the following for each writer: Article Name |_______________| Issue Contributed |_______________| Payment Amount |_______________| Note: Issue Contributed is a drop down menu A writer may have written in 1 , 2, 6 , etc issues. Here are the questions, 1. How can I add another section in each writers account when needed to add the above information? 2. How c…

I know I'm doing something wrong. I want a repeating calc field (30 repetitions) to calculate dates 30 days beyond the selected date. SelectedDate = date field where you select the date calcDates[30] = repetition1 = SelectedDate + 1, repetition2 = SelectedDate + 2, etc I originally had 30 fields calculating the previous field + 1 but that was cumbersome! There's got to be an easier way. I've tried a number of things: Let( [ repetition=Get(ActiveRepetititonNumber); lastrepetition=repetition-1]; If( lastrepetition=0; SelectedDate; SelectedDate + lastrepetition ) ) -----something to that effect; anyhow, it didn't work The most obvious: SelectedDa…

I read in one of FM books that FM can be setup to prevent the creation of a new db by the user. I went through FM Options, Preferences, etc.. and could not find an option to disable “New Database…” under File in the menu. Thanks for any suggestion on how to configure FM to only open files and run DBs and prevent users from creating new databases.

I'm looking for a calculation that will take the "fieldname" and it's "value" and put it together. For instance. I have the following: FIELD NAMES: filmtitle runtime rating THEIR VALUES: Great New Wonderful 25 minutes Rated R I wish for them to appear in a SINGLE (text) calculation field like this: CALCFIELD(result is text)= `filmtitle` = "Great New Wonderful", `runtime` = "25 minutes, `rating` = "Rated R" --------- You can see where I'm going with this... I've looked in the function "Fieldnames" and it does return the names of the fields, but I can't seem to figure out how to return the value along with the fieldnam…

I want to create a logic field which should be easy enough. But I need it to check if a folder exists. : eg [color:green]Field Name DoesFolderExist Y/N [color:green]If folder chuck exists set {DoesFolderExist} field to Yes else No Any help on this one would be very helpful. Not sure how to check for a folder. A calculation is probably the starting place. :qwery:

I have an object I've named RXREQ, it is a grouped object comprised of a pink rectangle, a dozen fields and some text. If I copy it in layout mode, go to browse mode, click into a container field (RxContainer)and hit paste, I get a nice image in my container field. Which is exactly what I want. Well not quite, I just looked, I get an image from Layout Mode - no data, just the image you see in Layout Mode. What I want is the object as seen in Browse mode But try to automate it and I get garbage, and odd garbage at that, text from all over the page.

Hi everyone, I am a beginner to Filemaker. I am creating a database for writers that contribute to our magazine. For example we currently have published 8 issues. And a writer may have contributed to 1, 3 or all 8. For each Issue I need to include the following info: 1. Issue Number 2. Article Name 3. Payment Amount How can I have multiple listings for each writer in the database? So that its list all of his/her informationlisted above for every issue they contribute to on their page. And after I have created the listings. How can I search for example for all writers who may have written in Issue 1, 2, 8, solely, etc. I really appr…

This Auto-Enter Calcluation does not seem to work. Result = Case(height<.75;"Restrict"; height>1.25;"Restrict";width>3;"Restrict";" ") Fields = Height Width Result This does work: Result = Case(height<.75;"Restrict";width>3;"Restrict";" ") But I need the full calculation to restrict if the first measurement is shorter than .75 and taller than 1.25. Any help would be greatly appreciated. thanks, Steve

I have a table with contact information for customers And i have a table for open service tickets. The fields are related by company. I have a button to send an email internally to announce the new ticket. I want the ticket to include the email addresses of all related contacts (related by company) Now I could use Count ( Contacts::EmailAddress) for an If statement, to determine if there are more than one contact records for that customer And i could use GetNthRecord ( Contacts::EmailAddress; 2) But what i want to know, is there any way to do a For Loop? Like For( TempVar; Start at 1; end at Count ( Contacts::EmailAddres…

Hi, I have a filemaker 8 database - recently upgraded from filemaker 6. The database contains a large number of calculations - 1 of which is no longer working. Comparing the old files to the new files there is no difference and i have made no changes - i just upgraded. however the FM6 files displays the result of the calculation and the FM8 files display a ?. The calculation is very large and complex and involves a lot of fields - not all of these fields will contain data, it depends on the job that the client needs to quote - is there any reason why upgrading to FM8 will prevent previously working calculations to no longer display results?

How do I pad a number to ensure that it is always atleast 4 digits? The original DOCID is in the format of 0000. There is a field NumPages. So if on record 1, the DOCID = 0005, and the Numpages is 6, i have a script which basically runs and creates records with 0005 - 1 0006 - 2 0007 - 3 0008 - 4 0009 - 5 0010 - 6 but in reality it creates it as 0005 - 1 6 - 2 7 - 3 8 - 4 9 - 5 10 - 6 See the attached for a better explanation. I was thinking of using the count characters but I think I'm going about that the wrong way. login and password are both "admin" TIA example.zip

I am sure this goes to show how new I am, but I can't find the answer in any of the FM books I have or even on the web. I just need to know that when I have a phone number field I want the data entered to be seperated from the area code and a dash entered. Could someone help me with this. Thank you in advance.

I am trying to develop a job costing program that summarizes hours spent working on different projects. A worker may clock in for one client several times or he may work for several clients just once. The input might look like this: Smith Project: 1 hour Jones Project: 2 hours Jones Project: 2 hours Camp Project: 3 hours I would like the summary report to query all records and generate something that looks like this: Smith Project: 1 hour Jones Project: 4 hours Camp Project: 3 hours I would like the summary field to keep track of whenever a new client has been added, find all i…

Hello, here screams a novice in FM for help. My problem is simple( not for me) In database I have two fields, and when I enter one value (number) to the first, the second should show one particulal value(number)The second value is not by some calculation (*, + etc.)but with both fields, I have earlier decided what the second would show when enterin some value to the first.Confused? So, for example if I enter "30" in the firs field, I want the other to show "50", IF i enter in the first field "40" I want the second show "60", etc. I figure it is Logigal Function "case" I should used? Is it?

Hallo, I've been trying this for four days now with no luck! Is there a way to add a new set of records in a record? What I want to achieve is to have a set of different projects. Every project is a record. What I want to do is to add the emails(with descriptions of users etc) related to each project. Each e mail must have a different record since there are many emails related to each project. I hope I'm making my self clear here. Please help me with this, any tip could be useful! Thank you in advance, Lukas

This seems like it should be easy and I feel like I'm missing the obvious answer but I'm coming up empty. I've done a quick search here but I don't see any obvious posts on this topic. I know that FM 8.5 Advanced can import table schema from one FM database to another but can it import the schema from something like an Excel file? The world seems to revolve around XLS files and I have a very large spreadsheet I need to do some work on. I'd like to bring it into FM but I don't want to manually create the dozens and dozens of fields (XLS columns) it will take. Can FM import an XLS file and assume the first row is the field names. I'm assuming the fields will a…

I am not sure if there is a function that would be able to do this but I figured I might have just missed it. I want to do the following: Adress Field: Company Name Address City, State, Zip Change it to individual fields per line: AddrLine1: CompanyName AddrLine2: Address AddrLine3: City, State, Zip Thanks for any help!

I've recently built a database in FileMaker 6 and I wanted to know if there is way to lock a field after data has been entered into it. I would like to prevent someone from changeing the data in that field.

[color:green]Hello all I have a field called Coordinate with this value: [color:red]N40° 1.694', W121° 30.999' [color:green]I want to do a calculation, two field and put N40° 1.694' in Latitude Field and W121° 30.999' in Longitude field. The below kinda works, but there must be a better idea out there. For the Longitude I used this Calculation: Middle( Coordinate; Position( Coordinate; ","; 0; 1 ) + 1; Position(Coordinate & "¶"; "¶"; Position( Coordinate; ","; 0; 1 ); 1 ) - Position( Coordinate; ","; 0; 1 ) - 1 ) {I used the Comma as the dividing place. Probably not the best idea because what if somehow there was another comma} [color:g…

I have a ex VAT Field that I need to add VAT onto. How do I make my inc VAT field calculate 17.5% onto the price? Also can I make bot fields dynamic so if I enter info into one field it recalculates the other field? i.e if i enter the ex_vat price, the inc_vat field auto calculates or vice versa if enter the inc_vat price, the ex_vat will auto calculate?

I created a file called Drawing Requests where users login and fill out their requests. I set up a table that contains user profiles (name, email, title, etc..). When users login they are greeted with their name at the top of the page. I want to setup a field that shows the names of the users who are currently logged in. I am having trouble getting this to work. Surely this is the place to find an answer.... ....Would be greatly appreciated. Sifter.

Hi, I've a calculation field that creates a code from 5 other fields. What I want to do a build a check to ensure that I've all the parts to the code. The code looks like this "H01-02-01-X ######" H01 - Part 1 02 - Part 2 01 - Part 3 X - Part 4 ###### - Serial No (length varies) I thought that this would do it; If(Identity Number Calculation ="h0#-##-##-@ *"; Graphic 2 ; Graphic 1 ) Do I need to get more complex and check each individual part that this code is created from? Thanks in advance, Skip

I realize the nature of a global field is temporary or session-based, but I've seen some uses that I can't replicate. Is there a [non-scripted] way to preserve the values of a multi-repetition global field such that the field is not cleared when the file is opened? Asking because Brian Dunning's Chartmaker app does something along these lines, but I don't see how any script is refilling or bypassing the field in question.