Calculation Engine (Define Fields)

Really weird, the case function gives me error messages (even when I try to use the filemaker example). Case calculations it accepted before also get an error message (when inserting "" as a result it says 'an operator is expected here' ex: Case(field=1,"",3) when I insert a number instead of "" it says 'This number can't be evaluated. What can possibly be wrong, I have the same problem with fmp5 and fmp6, I even reinstalled fmp5. Any answers?

letter base functions, Purpose to store form letters and dynamically fill in data where needed Problem; how to allow end user to modify the layout and the content without entering the layout mode. So they can design their own form letters at anytime. And to modify existing form letter content on a per letter bases.?!?! All I have figured out so far is the need to have these relations within these 3 files memberID (members file)>LetterLI( letterbase line items file > LetterbaseID ( letterbase file with the form letters) What I'm stuck on is what kinds of fields & additional relations I need to allow for the above desired effect.TIA

I have 5 fields per record = unique code relating to [category] [category]= Text field with Value List attached (19 options) [cost]= Number field [price]= Number field [margin]= Calc field to display margin (%) between [cost] & [price] I want to create a CALCULATION field to add the [cost] results together, BUT only according to what [code] was selected. EG. if [code]=1 then [category]="labour" Then i want the CALC field to add the [cost] value from ONLY the record that [category]="labour". I can't seem to get an 'IF' CALC to work. Is a 'CHOOSE' or 'CASE' the way to go ? The total needs to ADD ALL records that have the same Category …

All, Can you please help: http://www.fmforums.com/threads/showflat.php?Cat=&Number=77332&page=0&view=collapsed&sb=5&o=186&fpart=1 Thanks Chris

I have a field that is formatted to display as currency. I need to be able to, on rare occasion, enter a word. Is there any way to be able to do both?

I have this weird problem with Status(CurrentFilePath), the calculation ends up with this "file://C:/Program Files/dre/PROGRAMS/doorway.fp5" Note how PROGRAMS are in uppercase and the folders name is Programs in lower case. I am using Troi file plug-in and it cannot find the folder when it is in uppercase. I have tried to delete the folder and make a new one, at first it was correct and then back to uppercase. Anybody know what going on here?

I have a list view of all sales... i want to make a summary box that always shows up and tells me the total sales of all records in the found set... when i do sum(units) i get 1 and when i do Count(units) i get 2... why cant it just add all sales from ALL the records showing??

Can I derive 2 values from the stated range: Expected_S-T [0.085-0.250]? When I use the text functions in separate calc fields, the Right(text, number) gives me problems...please see below.... Here's the problem: Left(Expected_S-T, 5) gives me the value .0850 which is acceptable, However.... Right(Exptected_S-T, 5) gives me the value WITHOUT the decimal point...(85025) and picks up the last 2 digits from the first value. How can I get the value 0.085 in one field and 0.250 in another field--both originating from a single field? Anything would be very helpful! I can upload the file upon request. Thanks, Jon

hey folks, so this is my first time having to use a calculation-field... maybe someone can help me out or point me to a post that has already answered this. I have a database that holds records/invoices from a bunch of companies. each of these records has a field called Amount which is the sum/total billed to that company for that particular invoice. what i'd like to do is create a report (Report1) that will basically take the Amount-field from each record in this database and add them together. however, i'd like filemaker to add up only the fields that are found in the invoices that have been billed for the first half of the month (from the 1st to th…

Hello I have a calculation field with 2 repetitions and a tag field with two radio buttons (1 & 2). If the 1 is checked i would like a value placed in the first repetition and if 2 is checked I would like a value placed in the second repetition. Is this possible to do with out a script by defining the calculation field? David

In the example file attached i need to be able to do a search and get totals for each of the [sc] fields. EG. i want a layout to have each OPTION in field [sc] TOTALLED. I have SUMMARIES for them but it does not categorize them according to the [sc] field. in the example file: aaa--->ts= $8000 add's the total of ALL (aaa) categories. then i ned the same for [tc] and [ma]. Regards Corey.... aa.zip

Ok Lets see if I can explain this problem. I have three fields in my database, One is the

I have a vey straight forward calc in a parent file (or so I thought). Case(Related Record 1::text field 1 = "" and Related Record 1::date field 1 > 01/01/1998,"X", Related Record 2::text field 2 = "" and Related Record 2::date field 2 > 01/01/1998,"X", Related Record 3::text field 3 = "" and Related Record 3::date field 3 > 01/01/1998,"X", Related Record 4::text field 4 = "" and Related Record 4::date field 4 > 01/01/1998,"X","") I have set this up on OS X (10.2.6) & Win XP (Home Edition) the field defines properly (no circular definition) msg, but when I go back to browse mode I get a spinning circle in OSX or an hour glass in Windows After 10…

Hi there, is that any way to translate a price value to text just like, if the value in field A is '2500.00', then the other field B will display the text 'two thousand and five hundred'. Regards, Henry

I have several databases that I would like to link up with a central interface, before I put them all onto our filemaker server. But I do not have anyone who knows what I am talking about. Can you help???

This may be a dumb question but I'm totally curious. Is there a difference Between defining a field as a calculation using the radio button "calculation" opposed to defining the field as a number and defining the calculation using the option button and selecting auto enter as calculation?

I thought I posted this before, but seem to have lost it in transit, so please forgive me if I'm re-posting. Is there any way to reference fields in the previous record for Calc purposes? This is the previous record in the found set, so it will not necessarily have an adjacent record number or adjacent field value [i can't, for example, refer to (date - 1) or (ID.Number - 1) ]. I wish the Status(CurrentRecordNumber) function would do this, but it seems to calculate a value when the record is created, and never change it after that. It would work if it were always active, so that when I re-sorted the list, that value changed. My goal right now is to be able to…

Hi All, I want to see the date with 0 before ...like 03/01/2003 ...can print it ...but it seems like to be appeared 3/1/2003 ...I use datetotext but it does not work. Someone has an idea? Thanks Anh Tran

Hi there, just want to ask some question about the data format, now i found that if i key in the date with 2 digit year, like 93, if i let the field show it into 4 digit year, it will become 2093 and not 1993. If that any way to fix it? Regards Henry

Hi, I'm trying to either export or print to file the field definitions for my FM database. In Filemaker Developer 6, I've tried going to the Print menu and choosing the Print To File option, but after asking me to name the file, FM says that it has logged an error and is quitting. Any ideas as to how I can accomplish this? Thanks!

How do I change a global field which is a container? Every time I change it, it reverts back to the way it was before.

Any suggestions on how to format a field so that the spaces and dashes are automatically entered? i.e. (800) 123-4567

Is there an easier way to enter a date without having to type in the forward slash? I have used the same technique as used with phone numbers and everything works fine except in order to find the correct date the find has to be done in the calculation field because some users may type the date values differently. For example I have a text field named "date" and a calculation field named "c_date". Just like the phone number format technique. Lets say USER A types in the following value in the date text field: 07082003 The c_date calculation will output 07-08-2003. This is fine and dandy if all the users entered the dates the same way but lets say USER …

does anyone know where i can download some nice sounds which i can use on my start up script ? ex. window xp opening sound, etc... or does anyone know how i can retrive window opening wav. sound file from my system. so that i may copy it and put it into filemaker container field ? regards, kyle

Can anyone tell me what is wrong with this calcuation: If(Date?8/1/2003,(Case(Name="Lori", 165, Name="Julie", 99, Name="Carl", 110, Name="Christina", 59, 79)*Hours), (Case(Name="Lori", 165, Name="Julie", 99, Name="Carl", 110, Name="Christina", 59, Name="Jesse", 89, 79)*Hours)) Date, Name and Hours are all names of fields. What we want to acheive is to change someones rate for time going forward, but not mess up the calculations on time going past. I thought this might work, but I end up with the same rate regardless of the datedate.

I making an outline with text fields where users can fill in the text fields. Their are many text fields in this outline. If I only allow a certain amount of space for writing in each field, is it possible for filemaker to show more space or less space if not a lot is written. That way their is not a huge gap between fields. Is this possible? Scott Example: I. Summary ------------------------------------- _ TEXT FIELD _ _____________________________________

I am having trouble writing this if statement. dont know the correct syntax in filemaker when balance is 50,000 i get nothing as result If(balance ? 2500, "a","") or If(balance ? 5000, "b","") or If(balance ? 50000, "e","")

I have a date field. I have a calculation field that says, If (date > "7/15/2002", "Y", "N") For some reason, all dates in the date field evaluate to Y. If I change the calc to If (date = 7/15/2002, "Y", "N"), everything evaluates to N, even if I enter 7/15/2002 Is this not a valid calculation? Thanks. M.

If I have 6 fields that contains a number from 1 to 10. Is there a calc or summary that will look at the current record and report back what the highest number was that was entered in those fields? In other words, five of the fields have the number 5 in them, one has the number 6. Then the returned number would be 6. And inversely, is there one that will show what the lowest number that was used? LR

I need a calculation for 5% simple interest annually. (my previous post was for compound interest) The FM Financial calculation scripts don't seem to work for what I need, which is an increase of "x" per year, which is the same amount added every year based on 5% of the original amount. For example, if I have a starting "amount" 2000, "interest" 5% (.05), and "term" year. And should get this: Start 2000 x .05 = 100 Year 1* 2100 Year 2* 2200 Year 3* 2300 Year 4* 2400 ... Year 9* 2900 etc... *would actually be the anniversary of year 1, 2, ... Your help, yet again, is greatly appreciated.

i am in the process of conditioanlly changing the color of the fields on alayout based on the value of one field. (ie clients from one state=yellow, clients from another state=blue) and i am trying to match up the fields on the conditional layout with the ones on the old layout, but the container fields are giving me trouble. i have the calcs working fine, but there seems to be a small (hairline?) border around them, and i can't seem to line them up with other (regular) fields on other layouts. i suppose this problem will go away when i get all the layouts duped and "containered", cos then they'll all have the same issue, so they'll sync up. am i missing something re:…

Is there a variation on the IF statement that can be used to check for a match for the last word in a field? LR

If I have a calculation that returns a number containing a decimal...for example here is my calc: Round(ImpQ1 / MaxAllQ, 2) The results is a number that originally would be 0.87526 but gets displayed as 0.87 Is there a way to add something to the calc that would round the number up or down after the decimal? For example 0.87526 would get rounded to 0.9 0.842 would get rounded to 0.8 I dont want it to round all the way up to 1.0 LR

Maybe somebody has this calculation somewhere? I need to calculate the amount of days from a particular year (gYear = 2003) Anybody?

I am new to FM and any help is appreciated. I have two files, one is the main (PRA FILE) and a second file (CODE DESCRIPTION FILE). A field in PRA is

I'm trying to get this working for a while but I get stuck on one thing: I run a loop script that sets numbers in a global field: gGlobal = 5 + 8 + 10 +1.5 + 6 (those "+" are optional) How can I sum up these numbers in a calculation? (In this case this would be 30.5)

we have an electronic application on our website. we receive submissions as a list of the fields and their answers. (this application is not filemaker based, it's made and sent to us by the website host) he way i receive the answers is it will be a list like this: first name: josh last name: brown street address: 1234 main st city: boulder state: CO with the lines being return seperated, and each line being the name of the field before the colon, and their answer after it. so far, we've been doing the data entry by hand, either copy and pasting one field at a time, or retyping it from one window to another. i can't get the website company to retu…

Hi there, I'm back with yet another question How can I search across the whole database and not just within the field I entered the query in? After that all matching entries should show up and not only the first one found, maybe in a list... Any suggestions? Greetings Dirk

Hi, I'm new to all this, I would appreciate any help to my two questions. I have a DB with many files. One of the files has a tabbed interface to different layouts. Once the user chooses ONE of the layouts and enters data there, I want to prevent entry into fields in the other layouts. I thought of using a validation by calculation in the fields. That is: when entering data, calculation (IsEmpty?) checks whether specific fields in other layouts are empty. How do I write that calculation? Second, possibly related question: One field in each layout (depending on which layout is chosen) is obligatory. When info is entered there, it does th…

hi, can anyone lecture me on get field function ? is there any special reason why we need get field function ? what would be the best usage case of the get field function ? when do i need to use this function ? thanks, kyle

I'm looking for a paperclip graphic to use in a portal to indicate whether an email has an attachment. So it has to be small, say 16 px or so, and transparent would be lovely. Anyone have such an item?

Hi, say I have a text field contains a formula (formula are make up of fields from the layout), I want to place this formula onto a calculated field type. Does anyone know how to take the content of the text field and place it into the calculated field? In other word is there a way to extract the variables and operands from the string and place it into the calculate field? Thanks for any help you can give. I am using FM Pro 6 on Windows.

Hi there, I could need your help with this... I have a single file FM6 Database which I use for keeping track of my cacti, seeds and seedlings each one with different layouts and fieldnames to keep them apart. The problem I encountered is the following: I would like to be able to export/copy several fields from the seedling layout to a newly created layout in the cacti database. Prerferably I'd like to have a button with a script to do this job for me. Dirk

Hello everyone, I'm going crazy tying to get this to work and I'm sure it's soooo simple. I have a number field that is the invoice number. I would like to have a button that when selected will insert the next number(highest +1). I have tried the max function but it does not work. When I click the buttton it gives me 1 instead 1001. It appears to not be seeing the highest number in the database. What am I missing here. Thanks for the help.

I have inserted a date field into a calculation field and I'm losing a year. The date field is inserted as part of a text string (i.e. "Your "&birthdate&" is..."). In the browse and preview modes the date is displayed as a year less. What's going on here?

This is spooky action for sure. I've defined a calculation field which works in one layout and not another. When I go to the second layout where the calculation doesn't work and go to the Define Fields list, there is my calculation. When the calculation didn't work, I almost expected to have to redefine the field. But Nooo, there was the calculation just as I had defined it in the previous layout. I thought I was pretty clear that a field's action applies from layout to layout, even if they don't show; nevertheless, this field shows in both layouts and only returns the result in one. Should I have defined the field in the layout I wanted to show the world? This …

I need to use the number of records in a calculation to calculate a percentage. ie..."field value" / "no. of records" * 100 I don't know how to get the number of records into my calculation. How do I do this?

I've just created a report using summary part. The report results in several line items, some of which have negative subtotals. I have created a Summary field that is a Total of the subtotal field mentioned before. However, it totals the absolute value and ignores the negative values. Very Frustrated, Anyone have any idea's?

Hi All, Is there a way to control the field validation message?? I would like to be able to have both French & English messages based on a global (selected language) field. I could always type short bilingual message in the box but I am hoping for a better way!!?? Thanks --Dan

I'm lost in the help files...can't find the right function (or method)... How do I do i get All the values of a field from an external file without a relationship?. I wanna do stuff like finding the next value in external_field that is bigger than value x. /Tobias

I have 6 different fields that ea. will hold a number between 1 and 10. Is there a type of calc that can be used that would look at the six fields, and if any 2 or 3 or 4 fileds have the same matching number, the calc returns a value of "True", otherwise "False." LR

I believe this is a calculation problem. The data looks like this; Each record has three fields <State> <Miles> <Gallons> We process fuel taxes for truckers and must create a report that totals the amount of miles traveled and gallons of fuel purchased in each state. We will enter Data that looks like; <AZ> <151> <200> <CA> <132> < > <NV> <115> < > <AZ> <100> < > <NM> <200> <150> etc... I need a field that will total miles by state, and another field that will total the gallons purchased by state. Any one have any suggestions?

Hi All, I want to know if I perform a find the calculation field can get the maximum of whole record ...not just the maximum in find performance. In script we can use show all, but in the calculation field, it can not understand show all ... someone knows the trick??? Anh Tran

If this possible to have filemaker set filedtype text in red each time it check if a due date field is smaller or equal rhan today. Kind of: If [duedate] than Today set the fieldtype to red ??

Hi all! I'm looking for a way to import an actual image into Filemaker with an applescript, NOT just a reference. The problem is, I need to store a preview of an image and a path to an image, and I need a simple way for my users to add pictures, from a mac, BUT, I need them to be able to see the same pictures on a PC, and they have to be stored in a volume that maps differently on the Macs then the PC's. It won't be LOTS of pictures, so I have no problem with storuing the image inside FMPro, and I have an applescript that works great, if I want to import a reference, but I just want to import the file itself! And, no, my company will not pay for Troi File. I already …

I am just getting back into Filemaker Pro and need help. I am using the MAC platform. How do you link unique files to specific records? Thanks

Here's my situation. I have an unstored calculation field that's based on two conditionals. I also have an unstored Get Field calculation that grabs the other calc's data. Now, I want to have a third field (that I can index) lookup the information from the Get Field field. The problem is that one of the conditionals is based on a field from another file. And I can't figure out how to auto-force the lookup when the related field changes. In plain English, whenever the Billing Month changes on the master file, I have a sort value change in the pre-invoices file, based on whether a single charge's Billing Month matches the one from the master file: '1' if it doesn'…

Is there any script step that allows you to open the contents of a container field? Thanks Mark

When ever I try to embed a word document into a container field I get the following error message. "FileMaker Pro cannot complete the operation becasue of an OLE (0x80004002) error." Does anyone have an idea why this happens? I can embed pics, excel and pdf files without any drama. Thanks Mark

i am trying to create predetermined reports so a user can click on an icon a lauch the pre determined report. i am using the find layout with the symbols, but when i close out fp and open again it does not keep the find a performed. any help is appreciated thanks for the help in advance

Hi all I do a search on three db for a four db. I have a field in the three db that I do a search on that capture the status(currentfoundcount) number. This is where I do not understand why one db will display the number of records in that db when "show all records" is chosen after the find is completed while the other two db displays the status of the find even after "show all records" is chosen. The fields are defined as calculation. example s_count = Status(currentfoundcount) I though maybe the db became corrupt but after running recovery on this db, the results are the same. Any ideas. Thanks in advance Lionel

Hi, This should be fairly simple. RED BLUE YELLOW Assuming I only know the Position of the string I want to substitute, what is the calculation to determine the Lenght of the text entered from the Position Number and the next Carriage Return ? REPLACE(Text, some position, Lenght ?, texttosubstitute) I'm sure Middle(Position) is the way to go but I'm brain dead today.... Thanks.

I need to be able to make a field flash if that field has the word " [color:"red"] ALERT " in it. So if a user comes into a particular record and the record has the word " [color:"red"] ALERT " in the alert field then the word " [color:"red"] ALERT " would flash. How do I make this happen?

I'm looking to switch over my "Modified by _______" and "Created by _________" Calcs to use my global gateway user names instead of Status(CurrentUser). I've set up a method that seems to work but I wanted to run it by you guys. I really don't want the calc to change with different users (i.e Jeff makes a record and it says Created by Jeff. John logs in and all of the sudden it says Created by John. I'm using an auto-enter calc into a text field right now to insert the Global name field. Do I have to worry about it recalculating? Is there a better way to do it?

ok, dumb question but I can't stand it. Some times when entering a formula, I forget to space. It takes it but I keep trying to put spaces, thinking itmight not sometimes and cause a problem. I'm always wondering if its okay to leave them out or whether its a problem with some of them. okay, I can't give a good example now, but it's always happening and I keep making sure spaces are between everything but ive seem some formulas without spaces and I don't know if it's okay or not. Did this sound as dumb to you as it does to me? But it's driving me nuts, always going back and adding spaces even though it excepts the formula. If it excepts it, does that mean that it…

in a nutshell: i'm looking for a way to serialize records with numbers, and having the numbers start over from 1 at the beginning of each month. does anyone know of a way to do this? out of the nutshell: we have several files related to this problem: 1. clients: client info...duh. 2. employees: employee info. 2. jobs: job info like date, which client and which employee worked it. i would like, in the job file, to have a "count field" that's a running total of the jobs worked for that client in the job month. so if a client had 12 jobs in one month, this "count field" for the first record of the month would state "1 of 12", and the 4th "4 o…

I have a contact database with a defined "email" field. Basically I'm trying to set up a button to collect all the email addresses from a specific search, format them into a field, separate each of them with the required "; " and perform a copy command so that someone can then paste the addresses into their mail program and send mail. The script for the button is not an issue, the calculation field to assemble the addresses is where I need assistance. Thanks for your help. ses

Is it possible to create a container calculation and set its formula to display an image ? I think that a properly formatted string as the formula of a calculation container would result in displaying an image. I think it is possible, I'm sure it is... The only problem is that how to format the string is not documented! Any comment?

Hi, I want to have a field in database A (placement) that says Yes or No depending on some criterias. If a record with the status="yes" in database B matching the clientname from the database A is found, the placement field should be Yes. Anyone? Thanks, Martin

I would like to know if there is a way to insert a pdf picture into a layout. Thanks.

Hi, Is it possible (if so how ?) to have a calculation field result in the concatenation of the text contained in one field of every portal row ? Just to make sure I am being clear I will give you an example: I have an office DB (containing all of the company's offices) and a related employee DB (containing all the employees of all the offices). In the office DB there is a portal showing the employees of each specific office. I am looking for a text calculation within the office DB that will result in a list of all the employees of this office with a carriage return in between each employee. I know how to do this with a script and I know I can a…

I read an earlier post on a similar issue and tried to implement it for an email field. It returns the email address, except that instead of a period, it puts a comma. Anny idea why or an alternate solution? RightWords(Left(From, Position(From, "@", 1, 1)), 1) &"@" & LeftWords(Right(From, Length(From)- Position(From, "@", 1, 1)), 1)

I have several fields stacked on top of each other like this: c_transportscr c_smartspotscr c_smogfeescr the field "c_transportscr" = Case(s_totaltransportfee <> 0,("TRANSPORTATION FEE") & " = " & " " & s_totaltransportfee &".00"," ") answer: Transportation Fee = 25.00 The Field "c_smartspotscr" = Case(c_totalss <> 0, ("SMART SPOT FEE" & " = " & " " & c_totalss &".00"), " ") answer: Smart Spot Fee = 35.00 The Field "c_smogfeescr" = Case(c_totalsmog <> 0,("SMOG FEE" & " = " & " " & c_totalsmog &".00"), ") Answer: Smog Fee = 25.00 so then the fields would look like thi…

Ok, I just don't get this stuff. I have a date field - Inactive Date I want to create a calculation field (Deletion Date) that will add 30 years to Inactive Date. I can then use the Deletion Date in a start up script that will let me know when there are records that can be deleted. The only way I know how to do this is to add 365*30 to the Inactive Date, but that doesn't include Leap Years. I tried to just add 30 to the date, but it returns days that way and not years. Someone please end my torture. Thanks.

I have a global field gEvergentAccountInfoText containing a text block with multiple lines like the following: account.number: 9999 account.name: Smith Bakers address.streetNum: 15 address.streetName: Adams address.streetSuffix: RD address.city: Fairfield address.state: IA address.zipCode: 50219 phoneNumber.npa: phoneNumber.callingNumber: I am trying to parse the individual elements using the position function. I am getting confusing results. For example: Position ( "account.name", gEvergentAccountInfoText , 1, 1) returns 0 Position ( "address.streetNum", gE…

Dear All, I got field number and calculate maximum of it and I take maximum plus 1 ..let's say maxium = 100 and nextmax is 101. if at the same time, my friend open that file and he click the button he get maximum is 100 and nextmax is 101 also. It can not be like that ...he is supposed to se nexmax is 102. Since the file is on server. it should calculate automatic ...am I right? ..but i don't get it right. Someone has an idea? Thanks Anh Phu

Hi All, I have a calculation field that I use as a key for a relationship. It is made up of the concatenation of three other fields. I would like it to be unique but am not sure how to go about it ... Is there any way of validating a calculation field as unique? Any suggestions appreciated, I've tried a number of different ways but all have failed TIA Darrel

Hello, I have an excel spreadsheet that queries a FM database and it would be very useful if I could have it only query records that are part of the found set. If I could tag the records that are in the current set it would be easy. So, is it possible to create a calculation that will = 1 if the record is a member of the current found set and 0 otherwise? It seems like a status function would be a great way to do this, but there isn't one for this purpose, at least as far as I can tell. So is there a calculation for this? If not, any other strategies for doing what I'd like to do? Will I have to resort to a script? Thanks, Dan

I am having difficulty with the auto-enter calc text field. The field is calculated before all referenced fields are complete, thus an incomplete value is entered and the user basically has to formulate the calculation themself. The scenario: I am trying to make a unique "Account ID" based upon the following 4 pieces of information: -Client Name Parse (a 3 letter code culled from the Client Name - i.e. Michelle Moulton Badger would be MMB, etc.) -Month of Program Start Date in 2 digits ("07") -Year of Program Start Date in 2 digits ("03" -In some cases, all will be preceded by a 3 letter hotel code ("HPC") I can get the calculation to work correctly a…

I'm having some difficulties trying to create a report. I have a fundraising DB - several related DBes - one of which is called a "Gift Record" in which all the individual gifts are recorded. I'd like to run a report that shows the activity of a month, year, or several years. I can print out a report and sort the information by the field "Recorded Date" [date field] which is an auto-fill, giving the current date that the money was recorded into the DB. However, I'd like to split that up with Sub-Summaries. I'd like the report to look like this: JANUARY 2003 --------------- all the January gifts made in 2003 to follow FEBRUARY 2003 ---------------- …

I'm trying to create a field that takes text from five different fields and strings them all together. It's the same approach as having a separate field for "first name" and "last name" and then a third field that would display the two halves of the name together. Only, I'm using 5 different text fields which, together, end up creating a catalog number. Does this make sense? If so, is a summary field the right way to go? Or does a summary field only deal with number fields? Any help would be appreciated.

Okay, so recently I was handed a copy of FileMaker pro at work and received absolutely no training (they assume because I'm a young CIS intern I should know it all.) Anyhow, I was assigned to create a database for one of the after school programs to help keep track of the students enrolled in the program, their home numbers, emergency numbers, teacher, grade, and the activities they enrolled in. Well, I created a day field for each of the three days that the program runs (Tues, wed, Thurs.) Each activity has a maximum number of students that can be enrolled, for example the karate class has maximum of 20 students allowed and the arts class has a maximum of 10 allowed et…

Can somebody tell me anything about the limitation of files sizes? I'm limping along here trying to construct a database to use at my cabinetshop. I'm also working real hard to make sure that this database doesn't start to become more interesting than my cabinetshop. For this reason I am reconciled to my lack of finese. I'm sure that someone who knew more than me could do what I am doing much more succinctly than I am doing it. One of my databases has about 120 fields. This database calls out all of the parts of a cabinet and references an X-Y & Z dimension for each part. Some of the math originates from related files but I try to keep as much pos…

Hi, Can anyone tell me how can I make a font size 6.5 or 7.75? Thank you

i would like to have the field highlighted or indicated somehow when the user is completing a form. there are times when you cannot determine where you are in the database. Maybe the field could become darkened or made bright anyone have any ideas thanks in advance dharkin

I'm not sure where to post this question, so I thought I would put it here. I am building a database for constructing kitchen cabinets. I have fields that call out dimensions in Imperial Inches and additional fields that convert these inches to metric equivalencies. In order to produce a document that is useful, I am rounding the metric number to whole numbers. For example: The dimension (5.99) is displayed as (6) and the dimension (5.49) is displayed as 5. Right now the summation of these numbers equals (11.48). I would like, however, for the summation of these numbers to result in an even (11) . MS Excel has an option that calculates …

I have separated an old flat file into several relational files but am left with numerous fields that are no longer needed. Is there a quick way of determining which fields are no longer used in a layout so that I can delete them? Thanks.

Ok I'm terrible at explaining my question, here's what I want to do? I have a button that says complete. When the user clicks complete I want the word complete to dissapear and the current date to show up. I could easily do an if statement. But, I need to do a date calculation, so if its a text field the date calc won't work, and if its a date field, the word "complete" won't show. So my question is: can I have a button in front that says "complete", and a field behind. When complete is clicked, the field with the current date covers the complete button permanently? Thanks

Hi everyone, Custom Dialog does not validate dates. It will accept text or any garbage even if the Input field is date format. In addition, when entering into standard date fields, many Users were raised entering different date formats (using dashes or periods) or entering 2-digit years. Wouldn't it be nice if a User could enter any date format they are comfortable with ... whether in Custom Dialog or within regular date fields - and that data be automatically validated, interpreted and instantly converted? And in the case of data-entry in standard date fields, no scripts - no pause/resume - no plug-ins - instant validation & conversion! Now you c…

I have a business that runs on memberships. In my FM DB, I have two fields; one says "Date of Enrollment", and the other says "Length of enrollment". How can I calculate the length of enrollment from the date of enrollment? The result should be a numeric value, (i.e. 6, as opposed to "six") Please type slowly, I'm not very adept at this. Thanks, Mr_Dog [email protected]

Can you make a script for bring field to front if this? Instead of in layout form

I have a OCR invoice which needs to separate the decimal slightly to the right. Now, I use two equal fields of the value and paste and patch to cover the whole numbers and separator so only the decimals show in the right field. This doesn't feel very professional, but I'm willing to learn??? Snekkis

I want to have a field that show the last related record from a relationship: The mysterious field [:] must contains [facture::no.facture] wich is the related field that containt serial number like F-128 I search but found not any kind of "show last related record" function

I have a field called Invoice Number that needs to increment. FM is able to do a basic increment, but I need something a little more advanced. Each record is assigned a Grant ID by the user, a number which is either 593 or 597. Invoice numbers combine with grant IDs to create record identifiers: 593.1, 597.1, etc. If someone inserted an invoice for the first time in to the system, the record identifier would be a combination of the Grant ID, a period, and 1 (ex. 597.1). If someone else went in and inserted an invoice with a Grant ID of 593, the record identifier should be 593.1 because it is the first invoice being filed under the 593 Grant ID. If I made the Inv…

I have a multi-user database and would like to force-format styles for some fields, like title case for names. Is there any way to do this at the server level? I tried formatting the case in layouts, but that only works for the display in that particular layout, the main data is unaffected. In effect, that's made the situation worse since everyone *thinks* they are entering data correctly when it all ends up lower case. Any better solutions?

Hi, I am a new filemaker user and just learning the ropes. I have made an image database for the school that I work at. Everything is working great assuming I stay all Mac or all PC. However we use both here at the school. So here is the issue: In this Photo database we are going to have at least 5,000 high res photos. This means that we are going to need to store the photos as references. This works fine whether I am on all mac or all pc, by just mounting the image server. But due to the fact that this solution needs to be cross platform, I need it to work on both. So I thought that I would give the troi plugin a try. For the life of me I can not figure out how…

I've been reading a lot in this forum regarding repeating fields and I'm trying to understand what exactly they are and in what context/example they are commonly used in. I realize that this is quite an open question and could extend into several lengthy postings. I just need some basic idea as sometimes I feel lost when I read some of the post here on this board regarding repeating fields. thanks.

Hi All, This will be probably be an easy one for all you FMP experts!! I have a database with quite a number of one off values and I am using global fields for storing this data. Is there a limit to the number of Global fields you can have in FMP ? .... In fact is there a limit to the number of fields in one record? Cheers Darrel

Hello People! Again one of those post about lookup...sorry but I am confused on how to approach this so if u can help it would be great! goal: updating record and passing the info to a related file current scenario: -2 related files Items -- LineItem - in Items I have 2 date fields 'StartDate' and 'EndDate' and StartDate is just auto-entere current date while the EndDate is just a date field. the problem: -in LineItem file I have both of the mention fields(Start/EndDate) where StartDate is a lookup and gets passed-lookedup just fine - since it is auto entered at the original file (along with some Rel_ID) -The problem is the EndDate that is entered (manu…

Lets see if I can describe exactly what I'm Trying to do. I have number amount entered in a field, this could be different from record to record. Example: John owes $50 in the second month. It would pull the total from field: Amt2 but Sue owes $60 in the 5 month. That would be in field: Amt5 The month number is already created automatically for each record; I have a standard report that will list all records that owe money. Anything over a zero balance. But I need to copy the amount only from the month they owe. Example: both John and sue need top be on the report. I think the best way to do this is to collect the total balance form each record base on what month each …