Calculation Engine (Define Fields)

Hi, I want my dates to display in following order: day-month-year (28/11/2005) 28th november 2005. Now they are displaying automatically month-day-year (11/28/2005. How shall I do to change that? and how to define a field where the date is changing automatically every time I have done something with my records, changed address etc.

I have a database of 18 courses (i.e. Excel, Word, PowerPoint, etc.)and I have a database of 20 instructors (i.e. Fred, Sam, Bill, Tom, etc.) Some instructors are qualified to teach some of the courses. There is a relationship established between the two databases. In the instructors database I have a "Data Enty" form that has all the information about an instructor. I have a repeating field that is a value list based on the "course name" in the course database. I click in the field, select the courses the instructor is qualified to teach, so on the layout I have a list of the courses an instructor is qualified to teach in the repeating field. I can search for "Excel" …

Hi There When upgrading my FMP5 solution to FMP7, one of the first benefits I noticed was the improved record locking (down to field level). This was especially important to me as a lot of data input is via Portals & previously if the main parent record was in use, the whole portal was locked. Today, a problem has re-surfaced where I have started getting "record in use" messages when 2 users are trying to access different fields in the same parent record. This also knocks on and seems to lock the portal also. Is this normal - or have I changed something thats caused this problem. Any help appreciated. Thanks

Please help!! This is very frustrating. I am creating a rate schedule (a list of prices) we send to our customers. Some fields only apply to certain customers. My boss doesn't want to see any blank spaces, so I need to figure out how to put "N/A" in the blank fields. Should be easy, but I can't figure it out. All fields are in number format. Thanks!

Hi All, just a question about the Define Fields screen. When defining fields for a table that has lots and lots and lots of different fields is it possible to group them into groups? Say for instance I'm working on the supplier table I'd like to group the fields for address details together under one heading then group the fields for banking details under another heading, etc. I could then hide or show a group as required. Cheers Pedro -)

I am needing to set up a field based on this calculation. If "field 1" contains "insert" then "Ins" I know for the most part how to do the If(then) calcs but I am not sure how to make it look for a string of text in field 1. I can't use the "=" operator because field 1 can contain more data than just "Insert". It could say "Insert1", "cd Insert", "BRC Insert" etc. It could also contain data that doesn't have the word "insert" in it at all. Please help.

There is on option for this type of field. How to I get a yes/no field that is linked to a check box? MS Access has this.

Ok, i have script with a copy/paste step... When i paste, i'd like to paste "with style". The field in wich i'm copying it is in 12 size font and i want the paste text to be in 10 size font. I know that scriptmaker lets me paste "without style", but how can i paste "with style"? Help from FMP says that "Paste without style tells FileMaker Pro to ignore all text style and formatting associated with the Clipboard contents." So, how do i change style and formatting associated with the clipboard? Thanks p.s. i'm using fmp7 btw

FileMaker 7 has been a big improvement for us, and it is great to not need to take the databases offline as often as before. One thing I find we still have to take the databases down for, however, is to assign the default value for a global field. Is there a way to assign the default value for a global field in a file that is shared on FMP Server 7 or 8 without taking the file offline for a time? The field in question is a container field, if that makes any difference. Thanks for any help!

I am attempting to use an auto enter replace existing values calculation to make entering data into a time field more efficient. I am trying to be able to enter numbers only without the and without am or pm in military time. I can enter in military time but have to use to and I am trying to skip that. So, I have develolped the following calculation but it doesn't seem to return the correct results. Can anyone find my error? Case ( ApptTimeStart Calc ≥ 959 and ApptTimeStart Calc < 1200 ; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " am" ; ApptTimeStart Calc ≥ 1200 and ApptTimeStart Calc ≤…

Hi To All, I am having a problem with Quick Time being lost from container fields. The Quick Time is 'stored' in the container field and I thought that meant it was permanent as compared to a reference to a related path to the file. I lose the QT when I move the FM File to any different location or onto another machine. I also tried compiling to a Runtime with same results. I read up on storing the files in the Web folder as recommended by FM thinking FM must check there as a standard filepath. But even when I put them here it is not linking. Any help here would be much appreciated. Lance

I have a table that has expiry dates (think of it like video rentals). And of course a client table which it is linked to. What I want to do is to show the effective date (you can say it's the closest due date). If I was to create an calculation field in the expiry table called effective_date, how should the calculation be? Maybe I shouldn't be using a calculation field for this.

I've searched and can't find anything that similar to what I need. In my layout I have a DATE IN, a DATE OUT and a RECORD COMPLETE field. When the record is created, the DATE IN field is auto-entered w/the current date and RECORD COMPLETE is set to NO. When the record is completed the users fills in the DATE OUT. When a date is put in the DATE OUT field it triggers an auto-enter calc that changes RECORD COMPLETE to YES. I also have a CATEGORY field specified as a checkbox set. I need the CATEGORY field to be validated only when the RECORD COMPLETE = YES. It should not allow the CATEGORY field to be empty after the record is complete. It doe…

(Starting new thread here) I'm trying to convert an existing cross-tab type report to the use of repeating fields and have a small problem. Here is the situation: The report summarizes the votes for eight political candidates by precinct in two different election years. I have it arranged so that candidate names are the column headings. These are global fields (gCandidate1, gCandidate2, etc.) which I can change easily to produce a different set of comparisons. The votes themselves come through a set of 8 different TO's (Vote_Cand1, etc.) which are based on relationships between a the global candidate fields (gCandidate1, etc.) and the Candidate field in the…

I have a new record script that provides a set_field value. If the user selects Records > New Records, they will circumvent this important scripted step. Is there a way that this senario can be avoided?

I need some ideas from the Forum ... 1) When customer name is 1st Choice, it needs to appear in portal when F is selected so I need to convert number to alpha (we have hundreds of customers that begin with number) and 2) If Customer name begins with certain words, they need to be ignored and the second word (first letter) entered (considered?) instead. Users and Management have decided to IGNORE numbers and enter their alpha equiv instead, so 11th Street would be E. And they want to ignore "The" etc also. Since I do not see how a calculation alone can cover all possible conversion/exceptions, I plan to use another table to store the 'Rules.' These Rules must b…

Hi everyone, I've been trying to figure this out for a while...but everything seems so complex...and it seems like it sh ould be something very simple. I have a database where students are entered when they need to wait for a course. I have a field called Status where hte user selects from a value list either Idol, Denied, Red-flagged or Granted. Is it possible to total the number of results for each with a calculation field (ex. total of idol, total of denied, total of red-flagged, total of granted). I would like it so that when users load the main screen, they get a list of all the above items without having to do a find. Thanks everybody

ok here is what i want to do i want to take a date that is currentlt in my file IE 06/12/2005 and make it be the 15th of the month for the next month IE. 07/15/2005 so what ever is displayed in the first feild is displayed the 15th of the next month

Hello all, I have a script that sets a container field with a graphic displaying either "Approved" or "Not Approved" This works fine, except when in find mode. The graphics do not display using my current script, although it does work the graphic does not show it is working. I have attached a sample file, please let me know if further explanation is needed. THANKS! 03_icon_check_model.fp7.zip

I am wondering how to use a file reference that is in another field (File Path) to grab and insert a picture from a folder on my desktop into a container field (Image). Suggestions? Any are greatly appreciated! Thanks, -Teo

Stupid question from a newbie… How do I find the customers that owe us so that we can print monthly statements. Master record (client’s table) from table A - All client info and ID field Child records (in portal on master record) from table B - Child records contain fields for payments, charges and ID field, total and running total fields of all historic account activity. Statement layout - has a portal to all child records so that as I scroll through each customer all charges and payments show in portal. I would like to just do a find for any client that owes us by searching the summary field (Total) but that obviously won't work. Than…

I use windows and FM8Adv. I am trying to create multiple areas that slide on a single form. I basically have columns with 2 feilds side by side. If field 1 is empty, I need it to slide to the left. Sounds fine right. Well, since I have multiple columns, everything slides all the way to the left, shredding my columns. How can I use the sliding feature and control it so the items in each column slide, but the columns don't slide? Thanks.

Hello everyone, I'm just starting with Filemaker, and am probably trying something a little too complex for my level, but once I get this down, I'll have my first Filemaker Application down. I'm using Filemaker Pro 7. I have a Field, "FieldC" that I want to calculate based on the text input of InputofFieldA and InputofFieldB. The user inputs InputofFieldA and InputofFieldB using a pulldown menu of a non-modifiable value list (same list for both Fields) with 6 values. So I've defined FieldC as a calculation, and in the calculation declaration space, I built the following: If (InputofFieldA = "Very Low" and InputofFieldB = "Very Low" ; "Medium") …

I'm not sure if this post belongs to Define Fields or in Accounts & Privileges. So I'll just post it here first. I'm currently creating a clients table and one of the features requested was that the field Comments cannot be modifiable after it is created. I created a Comments table since a client will have many comments. The portal for comments works but users can always go back to the previous comment and modify it. This is where I am stuck. I tried using a merge field instead of edit box but then I can't add comments

I have a database where we document 4 specific dates realated to each request that we receive from a contractor. The fields are: Date Received - (this is the date we receive it) Date to Consultant - (this is the date that we send it to the consultant) Date rec'd consultant - (this is the date that the consultant returned the request to us) Date sent - (this is the date that we sent the completed request back to the contractor. Below is my calculation. The problem that is occuring has to do with the line in red. There are times when the person entering the information mistakenly leaves out the "date rec'd consultant" but fills in the "date sent". This …

I don't understand how to define a calculated repeating field. Just to test, I have a calculated (text) field with two repetitions. Right now I'm trying to put text into the repetitions with this calculation: Case(Get(CalculationRepetitionNumber);"V1";"V2") I was thinking that V1 and V2 would show up in the repetitions, but only V1 does. So I'm not understanding something simple. What am I doing wrong? Eventually I'll use Let to define V1 and V2 by calculation.

Hi, sample of serial 0001 0001 0002 0002 0003 0004 0004 and so on can i omit the duplicate number and the field looks like this 0001 0002 0003 0004 and so on i try to make it by my self but fail.

I have a database that has 1060 records. I just realized that I would like for each record to have a number, such as 1, 2, 3 etc. So when I print there is a column that has this ID number. How would I add this field now and have it assign a number to each record? Thank you.

I need some help with a particular calcuation. I'm designing a solution to monitor weight training progress in the gym. Each exercise has a particular routine that requires an increase in weight/resistance after a particular objective is met. When you achieve a certain number of repetitions for a given exercise, you are supposed to increase the weight by approximately 2%. The problem is that the smallest increment of weight that can be increased in the gym is 5 lbs (2.5 lbs for each side of a barbell for example). I need a calcuation that will look at the current weight for an exercise and then increase it by 2% and then determin if it needs to be increased a…

Hello, I think I am trying to something that should be quite easy, but I am just trying to make it difficult. Members need to be trained in particular elements for example 30.1,30.2,30.3 and when they have done all of the elements, they are then qualified to sit the exam comp30. Or if they do 33.1,33.2,33.3,etc they qualified to sit the exam comp33. What I would like to do is show on a report that if the person has completed all of the elements for comp30, a field will show at the bottom of the layout "needs to sit examination" if they have only completed a couple of elements it will show "has not completed all elements" I am using a case calculation field that sh…

Howdy Folks, I am rejoining the world of Filemaker development. It was pretty much my full time job back in the FM5 days and I kept my hands in with little projects for friends over the years. I was even using filemaker when it was owned by Nashoba Systems. Anyway, having talked about my experience level, I am emberassed to ask the following question. How do I simply add some number of days to a date? I have a date field,number field and a calculation field. Just adding the date and number fields together in the calculation field does not do it. I have tried using the function DayOfYear(DateField) and adding it to the number but this does not work. It …

Hi all, I got this incredible calculation from you guys a while ago, to make a text field show numbers with the thousanth separaters. this calc rounds off the decimal. I want it to always show 2 decimals. Can someone help me? I still don't fully understand the calc so I am having trouble changing it. Thanks this is the current calc: Case(Labor_Profit < 0 ; "-") & Choose( Abs( Round( Labor_Profit ; 2 )) < 10^9 ; Right( Abs(Int( Round(Labor_Profit ; 2 ) / 10^9 )) ; 3 ) & "," ) & Choose( Abs( Round( Labor_Profit ; 2 )) < 10^6 ; Right( Abs(Int( Round( Labor_Profit ; 2 ) / 10^6 )) ; 3 ) & "," ) & Choose( Abs( Ro…

Attached is a very simple database with a huge problem. There are 3 tables: Category, Item, & Received Items. 'Items' may be apples, oranges, & pears, whereas 'Category' may be either fruit or vegetable. In 'Items' there's an unstored calc field that sums all related received items. In 'Category' there's an unstored calc field that sums all related items, or at least is suppose to sum them! Just open the database & start adding some numbers in the portal. The qty in the 'Category' section doesn't update. This is too big of a bug to not find more people screaming about this problem. So I'm hoping that it's just me or that others know how to solve…

I've been successful in creating a calcuation field with a basic "If Statement." If this, else that. However, I am now trying to create a calculation field that has several criteria. If this If this If this Else this However, if I code: If... Else If... Else If... Else... As I can in ScriptMaker, I get an error message that the program doesn't recognize the "Else If." So I guess I'm asking if you can have repeated "If" statements in a field definition and, if so, how? TIA

I thought this would be really simple, BUT. I have a membership database in a single file. One of the fields is "Sex," with either a "F" or a "M." I would like to create a field that counts each and displays a running total for various sorts that I make. I've looked through many of the posts here and most provide a somewhat complex solution for what seems very simple. Steve

OK, here's the situation. I've got a database with 2 tables. One is called forms and the other is called clients. In clients I have the fields name, contact1, contact2 and contact3. In forms I have Date, Name, Contact1, Contact2, Contact3 and Remarks. In forms the date is automatically netered. Then Name is entered from a value list from the table clients. What I want is that when I have selected the Forms::Name, that it automatically enters contact1, 2 and 3 from the table clients where clients:name equals the entered forms::name. How do I do that? I hope I'm clear. P.S. I know this looks inefficient as things seem redundant. But Sometimes the cont…

I have a database that I want to use to create forms. I attached an example database. The database has 5 tables. A table for the Employees within my organization. A table for account managers within my organization. A table for companies that we work for. A table with countrycodes. A table for the actual forms. The first 4 contain (semi-)static info that is used as a basis for the forms. When I start a new form, I fill out date and time. In the next field I have to choose the company from a dropdown list (the red field in forms). What I want is that forms automatically enters the green fields based on the company I've chosen. How do I do that? A…

Hi, I use a plugin from newmillenium to export pictures. The one problem I am having is that when a record has an empty container field, it gets filled in with another record's picture. I wrote to newmillenium about it and I am awaiting an answer. That prompted me to want to put a default image in my field that says "picture not available yet". Is there a way to auto enter that? Thanks in advance Luc

Hi, I have two tables Table1: test Fields: A - auto serial number, B - numeric calculation Field (testRel::data + 3) Table2: testRel Fields: ARef - references test::A, data - numeric data field I want to use one layout created for table 'test' and I want to fill in just testRel::data field and to get the calculation on test: which seem pretty simple BUT it doesn't work I'm attaching the database and you can try to create a new record. It shouldn't be a tough thing to do, but obviously I'm missing something. I tried in FileMaker 7 and 8 but it works the same way. Regards ChMisho

Hello everybody, I'm working in an application that is build in filemaker6. My idea is to add a button to open up a network folder where some pdfs are stored, is it possible with Filemaker? Many thanks

I'm new to FileMaker. What is the field calculation for automatic correction of a phone number? For example, if a user enters the phone # 0123456879. I want the field to automatically adjust the numbers with the parentheses around the area code w/ 1 space after the parentheses. Here what I want it to look like (012) 345-6789. I want the field to automatically update entries to look like that. Thanks!

I have a race field in my database, with a checkbox field format with the following races: White, Black, Native American, Asian, Pacific Islander, Other, Unknown When the user selects the race, I need it to split into 5 seperate fields (these fields are being exported to a state report, which is why they all need to be seperate fields). For instance, if the user checked off the following race selections: White, Black, Asian ... I would need it to split that selection into the following fields: CALC_race_code_1 = White CALC_race_code_2 = Black CALC_race_code_3 = Asian CALC_race_code_4 = blank CALC_race_code_5 = blank And actually, to complica…

Hi, I need to make a field that shows the number of working days in the current month. That means if it's January 5th, it counts the number of mondays through fridays in january and subtracts any holidays, if they're weekdays, i.e. jan 1st. Any way to do this? Thanks, Andrew

I'm wanting to add a date range to a booking record which features a start date and end date. When submitted it will check another table for already taken dates and return a result as whether it is avaliable or not. I've done this before with PHP/Mysql but I'm having a mental block on how to do it in Filemaker 7. Can anyone give me a kick start?

I have twenty-five fields defined as Yes/No radio buttons. I want a calculated text field to combine the results so that if buttons 1,3, & 15 = "Yes" then Combined_Text_field = text_1 + text_2 + text_15 and so forth for all possible combinations. Can someone point me in the right direction with this calc? I know one way would be for me to set individual global text fields for each radio button and then combine them all in the combined field. I was just wondering if there was a way to avoid this intermediate step.

So, um...can anyone explain why an indexed field would spontaneously change its indexing language to German? This has happened to me now on several occasions, often to multiple fields at a time (though never to multiple fields from different tables at the same time...at least not yet), and needless to say this is wreaking havoc on my system. Scripted finds and relationships based off of these fields automatically fail if the field is not properly indexed. Most of the afflicted fields are old, and had been indexed properly for quite some time.

I have 7 fields, these fields can have numbers between 1 and 20. all numbers are two characters long (01, 02, 03..ext). What I want, is only the biggest 5 numbers. Is there a way to do this? The only way I can think of is to do something like this. Let([ //Get the biggest number Max = Max ( field1, field2, field3, field4, field5, field6, field7); //Get the second biggest Number Max2 = Case( Max = field1; Max ( field2, field3, field4, field5, field6, field7); Max = field2; Max ( field1, field3, field4, field5, field6, field7); Max = field3; Max ( field1, field2, field4, field5, field6, field7); Max = field4; Max ( field2, field3, field1, fi…

To be totally honest, I just started using Filemaker yesterday. But I am a quick learner. I have taught myself a lot about it already, but I just can't figure this out. Here is what I want to do: I have a field (Rights Due) with radio buttons Yes and No, and I want specific new fields (Agency, Payment, Contact) to appear on the layout when Yes is selected. I REALLY would like to have these fields hidden unless Yes is selected. I have tried scripts in various ways, but nothing is working. Please help me!

Hello all, I have a membership database that i am creating - which has various drop down selection fields. What i would like to be able to do, is have it so that when you click on a drop down selection field, and start typing - the list will jump to the appropriate selection. e.g: On Name/Title - Type in MI and it jumps to MISS This would particularly be useful on fields that only have YES and NO for selection. Any help/advice would be most appreciated. I have attached a copy of the database for reference. Many thanks, Shane. 161105.zip

My database has a field formatted with a checkbox set. There are 8 values in that set. I need to find out how many times (in a found set) each of these values has been selected. There can be more than one value selected for each record. For Example: Found Set = 8512 records Values: CL, IR, CC, WM, DI, CI, VI, CODE CL = 3794 (number of times this value has been checked) IR = 517 CC = 76 WM = 122 DI = 1731 CI = 1187 VI = 301 CODE = 215 Not all records will have values selected at the time the report is run. I have done this calculation with a calculator and it comes out fine. I just can't get it to work in FileMaker. T…

I want to divide this text into two seperate fields. "Schofield Barracks/Schofield Barracks" I've got the first part broken out using: Left ( dept_loc; Position ( dept_loc; "/" ; 1 ; 1 ) -1) If I reverse that, for some reason it doesn't work. Here's what I've got: Right ( dept_loc; Position ( dept_loc; "/" ; 1 ; 1 )) Any help would be appreciated.

I'm having trouble with time fields. Whenever I enter a time into a time field I get the error message "The value of this field must be a valid time ...." The message tells me what the time should look like (presumably taken from my OS X System Preferences). Even if I enter it exactly as it says, I still get the error message. The problem first occurred in FM 7, and now repeats in FM 8. Is it a FM problem or an OS X problem - or perhaps a user problem!? Help will be much appreciated.

Hello all, I hope I'm wrong but I think I've found a bug in the latest version o filemaker.. I've written a script in Fm 6 (then I've converted the file to FM 7) which defines all the repetitions of a multiple field (6 repetitions) with a calculation (the result is calculated evaluating and taking the value from a related database). In FM 6 and 7 it works and all the repetitions are filled up. In FM 8 only the first repetition seems to be definable through a calculation, the other repetitions stay empty. Only defining a global field with the calculation result and setting the repetition with the value of the global field everything works.. I hope the …

Hello All, I have a portal that i use to verify products with another portal. When this order is verified it should automatically update the calculation in the verify table and output verified in the current layout. It does not automatically update. The only way for this update to occur is if I commit the record by clicking outside of the portal. The only thing that drives me nuts about this, is that it works correctly in FM6 by automatically updating the calculation without having to commit the record. Any help with this one would save me from going nuts.

If I have a report that runs lets say 10 pages, how do I get the total of lets say the cost field of those records for each seperate page? If I use a summary field it gives me the total of the cost field for all records.

How do you write a calculation with multiple case function. For example, if field A = 21 then run this group of case functions. If Field A = 25 then run another group of case functions.

I'm trying to figure out a way to add a calculated number of spaces before specified text in a text field. Basically what I have is a calculation field that returns a number result (5 for example). What I need is a calculation/text field that will see the result from the first field and add 5 spaces in front of the text in the field. I'm sure there is a way but I can't figure out a way to tell the computer to add 5 spaces without actually doing " ". Any help you can give will be much appreciated.

Hi. I'm an ultra-beginner with FileMaker and I know only what I've learned by occasionally playing around with it for work. Now I'm expected to do something with it that is beyound my ability, but nobody else can do it either.... I would appreciate any help with this you can offer. We have a database full of products, and each products will be classified with a Category and a SubCategory. For example, a women's jacket would have Clothing as its category and Jackets as its subcategory. Each category has a list of subcategories that subdivide it. What I have on each products page are a dropdown box for Category and to the right of it, one for SubCategory, both…

Any way to reliably subtract one month from a date. whether it's march 29th, january 3rd, or anything else? Thanks, Andrew

All I am trying to find words in a string and copy the words into different fields. The word locations in different records are not always in the same place. There are quite a few records in my database (25000 or so). Any clue?? i.e record 1 The + Quick + Brown + Fox record 2 Quick + The + Fox If the word exist anywhere in the sentence I want to show it in different Record 1 Field 1 The Field 2 Quick Field 3 Brown Field 4 Fox Record 2 Field 1 The Field 2 Quick Field 3 "Null" Field 4 Fox Any clues would help Thanks Steve

I have a strange problem. I have a indexed text field a table. I have made a layout that allows input into this field. For some reason the character ' is being translated into ’ when entering data into the field. Why does this happen and how can I stop this translation?

I have 3 time fields: Time_Start, Time_Finish and Time_Duration. I want to be able to: 1. Automatically return the difference between Time_Start and Time_Finish into Time_Duration. 2. The sum of Time_Duration. Please, can anybody tell me the best way of doing this? Should Time_Duration be a Calculated Field giving a time result or a Time Field with an auto enter calculation? What is the difference between the 2 ways of doing it? Many thanks in advance.

I'm stuck. My calculation field has the following type of calculation (I'm looking for the calculation result to be text) If ( AddressBook::NameField = "John" ; "Send Birthday Card" ; " " ) This calculation works as long as John is the first record in the related table. However, if John is a subsequent record to the first - it doesn't work. result one should = insert the text "Send Birthday Card"; result two should = an empty field. This is just an example. My real field result is much more complicated, and has nothing to do with trying to figure out when to send a birthday card to John.

Ok, another one for today: Is there a trick to using global fields across shared databases? I've never been able to create a global field that stores data across the network for multiple users. I've dealt with this by creating a small database of "globals" that are actually just text fields that I can reference from the other files. I feel like I must be missing something.

I'm trying to create a field that displays contents from multiple related records. Is this possible? This is the specific instance: I currently have a 'song' database. Each song is a record with additional fields for album title, genre, explicit content, composer, etc. In a separate 'album' database, I would like to create a field that lists all the songs from the album (based on a relationship matched on album title). Is this possible? Or am I going about this in the wrong way? I can create a value list that gives such a list, but I don't know how to make such a field.

I'd like to have field contents locked, after they are created, but still be able to add a new record and enter new information into this same field. Is this possible?

I'd like to draw a rectangle with an arbitrary (variable) size & position on top of a image in a container. This seems clearly beyond the ability of native FileMaker but possible with a plug-in. However, my search for the right plug-in has come up empty. -- Ward

To validate the duplicated record , I used SELF relational and serial# to do like this if serial# <> SELF.serial# then DupFlag is TRUE otherwise DupFlag. It works fine in version 5.5 or 6.0, but it seems NOT work properly in version. DupFlag is always TRUE even there is no duplicated record. I just switch to Version 8, still new to it since the architect of 8 is totally diff from its earlier versions. Any help or idea woulf be appreciated very much Thanks guys.

I have just started working with File Maker and only do so in a very basic manner. I use it to keep track of college student book records. We are currently working with anothe company and need to exchange information. When I sent the info to them they said they needed a certain number of positions for the student name, ID number, and account number. For example, currently I have like 11 spaces for the first and last name and I need 15. Is there a way on FM to add a finite number of spaces or positions to a field? Sorry if this is confusing!

Does anyone know how I would insert a record number into a field?

Hi, I have a membership database with several date fields. Does anymore know how to have the dates that i enter automatically change and add the '/' separator. ie: enter 101105 and it automatically changes to 10/11/05 Any help would be most appreciated. I have attached the database for reference. Kindest Regards, Shane. 101105.zip

There is a lookup in "Invoices" (from "Works") that performs fine on many records and not on some. There is a parallel lookup in "Commision Invoices" (from "Works") that performs fine on the problem records. I have recovered the each file with no errors and no improvement. I have duplicated a record in "Works" that does not lookup correctly in "Invoices" without improvement. Is there a way to check for DB corruption or are there alternative methods of clearing this irregularity?

Hi I have a simple Photo Catalog created from the Built-in Photo Gallery template that comes with FileMaker 7 Pro. I've modified it slightly but am having a problem where my container field is showing pictures fine in FileMaker but when viewed on the web thru IWP the pictures are being resized to fit the container. Whereas I've set the containers settings to Reduce, keep proportional and Center which IWP seems to be totally ignoring any ideas on how to stop it stretching / resizing my images? I've tried viewing it in IE and FireFox, both show it the same. Cheers Matt

Hi all, So, here's the story... The users want to be able to have a new line item on a purchase order pull in the last price at which they bought that item. And, they want the "read in" price to be in black on the layout. If, on this occasion, we are purchasing the item for a different price, the user needs to be able to overwrite the price that was provided from the last record; when this happens, the price should change to grey on the layout. Also, if we have never purchased this item before, the unit price field should be blank and the user can enter the price. So, what I've tried to set up is an auto-enter calc which works beautifully AS LONG AS the fie…

Is there any way for a field in a table to be setup for auto-entry based on the "max" value found in a group of records (instead of a repeating field) within another table? I'm trying to find the biggest number in a set of records for a field from Table 1, and then auto-entering that found number plus 1 into a field in Table 2 whenever a new record is created. The MAX function apparently won't work, since it only searches for values within a particular repeated field and not within an entire set of records (using a particular field). A search in forums on this site didn't turn up any info about this yet...

Greetings and salutations - I built a large Case statement to calculate my total task cost. The problem is that if 'Task Unit' is not blank and the Round Priority equals either 'Priority24' or 'Priority72' the result is not calculated. Any clues? All other parts of the statement will calculate correctly. I thought it might have something to do with having a number at the end of the priority, but the calculation will work if it using hours instead of units to calculate. Also, it does seem to matter what order the statment is in. If i move all the task unit * task cost lines to the top then i lose all my other calculations. I was under the impression that if yo…

Sorry if this is a really newbie question - I have a calculation I am working on that requires me to calculate the sum of a field entry for all previous records for a particular company excluding the same field in the current record. How do I get a sum for previous records only? Also, I already have many records in place and I need to implement this from the first record, so I have have to summarize previous records by date since they were created chronologically. Thanks.

Hi, I'm looking for a script technique or plugin that will allow me to do the following: Check a container field to see if an image is embedded or stored as a reference. If it is embedded, export the image to a directory and change the container field to a reference. We want to do this to older, out of use records to reduce file space. Thanks! Andrew

Is it possible, or somewhat easy to calulate a number field into words? example: 100,000.00 would say One Hundred Thousand Dollars Cin

Hi all, I'd like to get opinions on my approach to storing references of images and files in containers in a peer-to-peer, cross platform environment. Here's the problem (at least, as I see it...please correct me if I'm wrong) When you store references to files or images in containers in a peer-to-peer environment, they can only be seen in a container at the machine from which the insertion took place. All other machines in the peer-to-peer network display "The file cannot be found:filename.ext". Here's my idea for a solution: 1) Make a container field for inserting references to images or files, regardless of machine 2) Make a machine-specif…

I am trying to set up a report where the headers change based on the current page number. However, when I create a test field that is an unstored calculated field consisting solely of Get(PageNumber) and place this on my report, I always get 0 when I preview the report. According to FM Help, this result should only occur when I am not in Preview mode, so I do not know what is wrong. Any ideas? David

I'm creating an image catalog using an image-by-reference container. Since I want to be able to move the catalog+images from folder to folder, computer to computer, and platform to platform, I'm storing the actual images in sub-folders of the FileMaker 8 catalog file's parent folder. So I want to store the relative path to each image, not the full path. While experimenting with calculating the relative image path on Mac OS X, I've discovered an apparent FileMaker bug. Get ( FilePath ) reports this path to the FileMaker file: "file:/volname/folder/catalog.fp7" When I import an image into a container, FileMaker provides this "File Path" attribu…

I'm trying to get a repeating auto-enter calculation to work -- but something's going wrong. My solution is a bit more complicated, but to start, I have repeating field of Titles (10 of them) and a repeating field of IDs (also 10). When I enter a Title, I want to auto-enter the Title's ID number (from a relationship in another table). When I enter another Title in the second repetition, I want my second repetition of the ID number to auto-enter that new ID number in the second repetition...and so forth. The problem is that the results are unpredictable. The process works for the first two repetitions, but then when I enter a third Title, the system autoenters the…

Hi I have a database of gene sequences, and it would be useful for me to be able to identify identical sequence strings. Presently, each record in the table "sequences" contains a gene sequence as a text variable, and additional fields with information about the sequence. I thought I had solved my problem by creating a second occurance of the table Sequences with a self-join to the sequence field, then counting the number of matches to this second table with the calculated field "duplicate sequences", defined as "Count(SequencesTable2::Sequence) - 1" However, I am finding that FM only seems to look at the first 109 characters of this field to decide if ther…

Hello All, I have a membership database on which i have amended the field sizes. I have also added 5 additional fields. Since these amendments, the drop-down selections/menus for all the fields no longer give me any selection choices - and i can now only enter data directly. Could someone please advise me where i've gone wrong, so i can get the database up and running again. The additional fields are: Address 5 Ethnic Origin Mobile Telephone Date Paid Amount (Date Paid and Amount are not linked to anything yet - just the fields have been added) The affected layouts are: Current Details Amend User New Member I have …

I am developing a scheduler. Its all pretty complicated and I have a LOT of tables related in various ways. I have normalised the database quite well I think. However I have come up with a knotty problem. I have a table [Project] which can have one or many [People] these people have to do a set of [Tasks] (a person can have many tasks but a task can have only one person) which have a pre-defined schedule. Each time I create a project and assign a person to that project I need to create five tasks which are done in a pre-defined timespan - a regular schedule - however, things sometimes go wrong and additional tasks sometimes have to be added. All no problem. However the …

Hi All, I'm pretty sure this can be done, but this is new to me. When I get my raw data from an Excel spread sheet I have 2 fields for name: First Name Last Name Is there a way in FMP that I can combine the two fields into 1 so the result equals: Field Name = "Full_Name" result = Last_Name, First_Name Thanks for any help! Steve

Hi, I have a global Summary Field displaying a time total that calculates correctly. However, the field displays nothing while I am modifying any of the fields it totals - once I am done, the display shows up again with the modified total. What I would like is for the old total to remain while I am modifying the source fields and have the new total appear once I am finished. I have tried other methods of making this work, but I can't seem to get both the global and the calculation parts correct. Is there a better way to do this, or is there perhaps a way to change the behavior of the summary field? Thanks!

How can I convert RGB to CMYK? I have a table with PMS and RGB numbers. Now I need to put the CMYK info in it. Does anyone know an easy way of doing this? J

Hi everyone.. im have fmp 3 & 7.. but presently im learning to work with fmp 3 first with the tutorials bundled in it.. Problem: Items Quantity Price chicken 2 $1.50 fish 3 $2 Sub Total: 5% Tax: Total: im learning with calculation at the moment, can someone help me with this? how should i do my calculation?? So I can get my final total value.. im in a fix... Help will be very appreciated.. Thanks a lot..

Scenario: A user enters data into a field that has been formatted to show in Title Case, but the user enters all characters in lowercase. Those items are then used as a value list in a pop-up menu. The pop-up displays all items in the pick list in lowercase (although it will show the final choice in Title Case as I have formatted the field to do so). Is there a way to get the entire pick list to show in Title Case? I have specified the text formatting for each field and even added a TextStyleAdd calc for all fields. What am I missing?

Hi all, I am creating a password field that I want to make sure the user enters at least 4 characters. I need to use it in a script something like this: If (Password_Field)< [4 characters] Show Custom Dialog "Your password must contain at least 4 characters What's the best way to do this?

I need to count the number of unique entries in a given field. The field is a FileMaker serial number (alphanumeric). Any suggestions?

Hi, I have a field that stores the creation timestamp of every record. I'd like to run a report that groups records by the date... so is there a way to make a calculated field that only stores the date part of a timestamp? Thanks! Andrew

Hi, everyone, Please help with following: Is there any way to display images from other FM7 database in a container field window? Some kind of portal maybe?

I developed a database and in the database I have sales tax being figured by a field that is either yes or no depending if it is wholesale. If it is no, the calculation figures out the sales tax and puts it in the total. The problem I have though is that it was working great until I imported 1077 records. Now my Sales Tax field that had .0825 as a calculation is gone. So the tax cannot be figured out. The field is showing the standard -654321.987. I cannot get it to take the .0825, it says the field is not modifiable. How did my field format of .0825 go away. I need it back in there so it will figure all the taxes. Hope this is makin sense.

Hi gurus, I am looking for a calculation that will display this result: 10/23/2005...10/29/2005. In fact, last week based on today. The result will change as time goes by. I know it has to do with DateToText(Today.... but I can't figure out the rest.

Hi I have a field for an item UNIT_PRICE. It is set to numeric only. This field is defined in Items.fp5, when I try to enter 10.00 or 10,00 (depending on wich one is set as the decimal seprator in Control PanelRegional and Language Options) it throws an error saying it is decimal only. In fact, that is correct, but when I enter wheter 10.00 or 10,00 in the same field (UNIT_PRICE) of the same record, but on another page (Print.fp5), it accepts "." and ","... Ain't it suppose to throw the same error as in Item.fp5?? That is a detail, but I'd still like to know why... I hope I'm making myself clear, and sorry for my english. Thank you! P.S. I'm using FileMaker Dev …

I have created a database of 90 records. On the top of each record I have a record number symbol. Also on each record I have an ID field. Its options are: indexed, auto-enter serial, required value, unique, numeric only, allow override. When I initially planned the database, these two numbers were synchronized, so that the Id field was the same as the record number. Since then, I've added more records. Now they are no longer the same. Sometimes 2 records have the same ID number, which means that one record will have incorrect information in the portal fields. I think that I may have chosen incorrect options for the ID field, but I'm not sure how to change it so t…

Hi Everyone, I try to do a search before I post this question. Couldn't find any. What I'm trying to accomplish is when user enter a date let's say 11/05/2005 . It will give me result of Saturday in another field. Is it something with dayofweek function? I need some few pointers or to a topic which already describing this. Thanks