Calculation Engine (Define Fields)

Hi all, I dont know if this is the right forum for this question but here goes. I have a text field on a layout which contains a merge file of a field. Next to the text box will be the value chosen by the user. So here's my question ~ is it possible to fill the rest of the text box with dots to the end so it will lead the reader to see this :- Behaves in the playground......................Usually Takes care of personal items...................Always Etc............................................Sometimes Blah Blah......................................Usually I hope I am making sense and the above has turned out the way I want it to.(The always, s…

Hi I am having trouble with the following. I want to have an equation in a global text field which the user can edit if they wish. I then need to insert this global text field (which has fieldnames in the formula) into a Calculation field. When I try to do this, all I see is the formula text show up in the Calculation field. Is there a special way I need to insert this? Basically here is what I'm doing. I have a global text field called gCalc. In the Calculation field (called Calc), I have Calc=gCalc. This is not working as I described above, so I am obviously doing something wrong. I'm pretty new to all this, so any help would be appreciated.

I can't figure this one out. I have an invoicing system where I want to be able to show, if possible on the same page, a report that shows total sales for last year, divided by months, this year's sales, divided by months, and the percentage difference between these 2 years and the percentage difference between each months. In case my English is not good enough, need a summary field showing on the first column last year and the total sales for last year. Under that, I want to see each month of the year with total sales for each the months. Next columns is the same, except it will represent the current year. Next to the year field I need to see the total sale for that yea…

Ok didn't know exactly where to post this one, so let's go here since it involves a field (at least). Need to track two things: -last date and time a layout was viewed in browse mode in a particular record -last date and time data in a layout were edited in a particular record As to the former, I have a solution whose navigation in fully script-controlled and a Set Field works fine to track any displaying of particular layouts. Though, I would ask if there's any way to do it on the fly in a file whose navigation is free. As to the latter... no idea. I remember doing this in Hypercard years (decades?) ago with two clicks, though I don't know how anymor…

I have 2 separate Date fields. I would like a calculation that displays which date is the latest. Thanks, I'm having a brain freeze! Date Field 1: 9/11/03 Date Field 2: 9/13/03 Calc result: 9/13/03

Hi all I am trying to insert the ASCII symbol of the up and down arrow in a FM field. The field is format as text field. The ASCII character for the up arrow is alt. 24 and alt.25 for the down arrow. Put in FM the question mark "?" appears instead of the arrows. Inserted the arrows in MS Word and importing them into FM but the question mark (?) appears. Does FM accepts the up and down arrows and what ASCII charaters are they. Thanks inadvance Lionel

Is there anyway to set up a transaction log, that will show changes made, who made them, and what date they were made? Thank you.

Hi all Is it possible to change the format of one field from ANSI to Unicode in FM. FM format must be in ANSI. That is why the arrows symbols display as question marks. Thanks Lionel

Hi, I want summary + subsummary fields on a report. Because this are totals from thousands of calculated fields, it will take hours to make them. Is there another way to make this summary + subsummary fields. Ex. First make a script that put the calculated field in a number field and then make summaries of this fields ?? Is this faster ? thanks, Bruno

It may be a reallllllllllly long shot ... but is there any way to import created fields from one database to another???

Hi all, Maybe this is a straight forward question...but I just can't find the solution to my problem:( I have a possibility to search invoices by date range. So when a customer wants to search for invoices that are created between 8/6/2003 and 15/6/2003 he should get al list of all the invoices that are created between these dates. But how do I need to script the search? I know when searching manual, you just add "..." between the two dates. But when the scripts sets the field I get a "?" in the search field. Does anyone know how to solve this? thnx allready and greetz, jeffer

having jumped right into developing my files, and now learning the importance (after the fact) of documentation, and keeping things clearly labeled, i figured out a fairly easy way to find those fields which were at one time created, but never found their way to a layout, or never had any data entered into them. here's what i did: create a new layout, and put on it any fields you think may be extraneous, along with a field label, which will tell you the name of the field. then doa find by the fields one at a time, entering "=" into them for the find request. if the number of records found=the number of records in the file, then you know that no record has any d…

I know there is a way to do this but I'm not sure which text functions does it. I have a VIN (vehicle Identification Number) field which is 17 characters long. The 10th Digit is the year of the vehicle. VIN: 1FAFP71X4YBN23456 (Y)Year is 2000 Codes: A=1980 B=1981 C=1982 and so on. How do I setup this field (VIN) to find the year by the tenth digit using a text function?

Hi, I am trying to send serial inforamtion using Troi Serial PlugIn to a device which requires a calculated CRC for error correction. I beleive that the calc must count all the characters in the text block being sent and then send that along with the ASCII CRC code in order for the recieving device to accomplish the same and come up with the same number for validation. Does anyone know how to accomplish this task? And which ASCII character is the coded CRC? Any help would be greatly appreciated! GW

I am trying to write an If statement saying that if the year of the vehicle is less than 10 years from the current year date, then show exempt. This is what I have: If Year(n_year) < status (currentdate),-10, "EXEMPT". But for some reason I can't figure out how to say less than 10 years. In other words if the year is 2003 and the year of the car is 1992, then show Exempt. Could someone help me with this?

Does someone know how I can make a time calculation field not count during saturday and sunday ? I have a system for a callcenter that registers the time the client calls, the reason and when the attendants answer the client

Is there a way to assign F keys to fields? Example I want the user to be able to hit the F4 key and it automaticlly puts the current time into a field I designated for time.

I have created a report that breaks down my training topics according to to topic numbers. I would like a a subsummary of each topic. The subsummary field is shown in the layout mode. I am really stumped as this worked in testing but now that I have over 1,000 records added I can not get the subsummary field to show a total. Now on the other hand, I do get a trailing summary at the end of the report. Any suggestions.

I have a database that tracks service contracts. There is a start date, end date and duration in months. I want to change end date to a calc field and use start date plus duration to end up with the end date. If I add x to start date it is in days. As months have a different number of days, I can't just add monthsx30. Any thoughts outside of a messy date to text to date thing???

I have a container field with an inserted object (bmp picture) that the user activates and edits with Microsoft Paint (draws on the inserted object). Because of the larger size of bmp files, I would like to use gif or jpeg images. (Inserted file references will not due for my project) This seems to work fine too with one exception. When the gif or jpeg object is activated, Microsoft Photo Editor opens instead of Microsoft Paint. I'm running Windows XP, and I have change the file associations on the system--so, when I open gifs or jpegs on the system I get Microsoft Paint. Regardless of the changed associations on the system, Filemaker still opens the gif or jp…

Anyone have any insights on this? Have a file with 17,000 records, it's 12.5mb. Created 4 calc fields that consist of a literal which is 4 different url's then the value in a field so they look something like this: http://www.widgets.com/1234=5678 where http://www.widgets.com/1234= is the literal and 5678 is the field value. Works fine. However... The size of the database grew from 12mb to 18.4mb! I've redone it, saved the db as csv and deleted all records then imported them... still same size. Thoughts? Thanks, r

Hello, Could someone please tell me whether I can do the following with File Maker 6? I have spent countless hours trying to do this with no success. I have a database with three fields: PRODUCT ID (e.g. product X, product Y, etc.) PRICE PER PRODUCT TOTAL (which is Summary of the PRICE PER PRODUCT field, gives me the total $ sold by product) The report I use the most includes two fields (PRODUCT ID and TOTAL) looks like this (the subsummary in the report is sorted by Product ID) --- PRODUCT X $100 PRODUCT Y $300 PRODUCT Z $200 yes, since the subsummary is sorted by Product ID, the order is alphabetical. --- Is th…

Can someone assist me with following please. Investment value fields showing investment, % increase to date, projected % increase PA, etc. I need the calculated projected % increase PA to be limited to - 100 % if the investment decreases in value. For example if 1000 dollars becomes 500 after 3 months, it projects as - 200 % PA but I want this to show - 100 % as the investment cannot, of course, lose more than 100 %. At the same time, growth percentages must be not be limited. Thanks.

sorry, but i don't know what to call what i'm trying to do. i have a text field, into which go notes, updates, etc, that change from time to time. i would like to keep a record of the change, but i don't want to have to scroll down to the bottom of the box every time i enter something. right now, the field is formatted as text, and data entry goes something like this: first entry 9/1/03: available fridays and saturdays second entry 9/5/03: will be out of town from 9/6/03-10/6/03 third entry 10/7/03: back in town, available tuesdays and wednesdays. i would like the final field to look like this: back in town, available tuesdays and we…

Hey there: Great forum! This is my first post: I've created a database using U.S. date formats and now want to enable users to enter data using an international date format. I've modified the custom date format, which allows the date to be VIEWED in an int'l format, but that apparently doesn't allow ENTRY in int'l format. I'm using Windows XP and Filemaker Developer. I know that I can go to Control Panel:Regional and Language Options and set this to, say, a local European country, but does this mean I must now recreate my database from scratch using the localized setting or is there an easier way to convert? Thanks for whatever insight you can provide. …

Need some help with some calculations: If I have a recreation league that has 15 sports, each of which is a field. Determining which of those sports has been rebooked for this year, the entry for each of those those fields (sports) is either Yes, No, or N/A. If I have rebooked 6 sports( 6 fields containing Yes), have 8 sports to rebook (8 fields containing No) and one sport not participating (1 field marked N/A), what fields do I need to create to show the percentage of sports which have been rebooked for that particular league. In the example 6 of 14 have been rebooked for a percentage of 43% rebooked. I guess the basic question is how do I calculate the number of

Is there a way to permanently format fields so that even when I copy and paste some text from another program/document/e-mail it keeps the font/size I have defined instead of carrying the formatting over from the other application? I recall this being possible but I cannot find where to define it. thanks for any help...

I am wondering if I am missing a step somewhere. I have a field that looks up the first and last name from a different file and inserts it into the field. I made a calculation to concactonate the two fields as follows: firstName & " " & lastName. I also uncheck the box to disregard empty fields, so that it would always add the info from the other database, in case there was a last name but no first name. Yet it does not work everytime.

Hi-- I have gotten this far in trying to extract an email address wherever it may be found in a text field: If(PatternCount(Answer, "@") (does not equal char.) 0, Middle(Answer,Position(Answer, "@", 1,1), Position(Answer, " ", (Position(Answer, "@", 1,1)) ,1) -(Position(Answer, "@", 1,1))) , "") This gets everything from the @ to the next space in the text...but I can't figure out how to get the first part of the address. Thanks! All My Best, Jeffrey

I have a DB for change orders and am trying to define fields so that the completion date of the project will always be automatically updated. In each record I have two date fields(CurrentCompletionDate) and (AdjustedCompletionDate) and a field in which I manually enter the number of days added to the contract for that particular change order. I have the correct calculation to auto-calculate the adjusted completion date from the current completion date, but my problem arises when I go to create a new record. I need the CurrentCompletionDate field on the new record to auto-enter the value from the AdjustedCompletionDate field from the previous record. I think it's an el…

I have two Value lists I want to use in a caliculation field. Both fields are text. The first has 3 statements and the second has 3 statements and the combination of any two will give a third statement result. Let's say the first value list is called "Planning" with values of "ready", "set", "go", and the second value list is called "Performance" with values of "Unsatifactory", "Developing", and "Proficient" ... and every combination of those will produce a certain comment. For example the coment fields are, "KOC_U", "KOC_D", "KOC_P". There are 9 Possible combinations. How would I write the calculation?

I a newbie to Filemaker (and databases in general) and I have been having excellent luck in working with Filemaker. My problem is as follows: I have field set up in an report (Customer Name) and I would like to have additional customer information (ie; Phone , Address, Postal code, etc.) show up in the report.

Let's say I'm working with lots of dates, and for various reasons, I need to use lots of different manipulations of those dates: Week, Month, Next Week, Last Week, etc. I have two choices: This_Week = WeekofYear(Date) Next_Week = (WeekofYear(Date) + 1) or Next_Week = (This_Week + 1) In other words, referring to existing calcs or starting fresh. For a big database with lots of files, which is the more efficient approach to take?

I have a database that, among other things, tracks referral of students to special education by 24 individual schools - 1 record per school. Up to now, we're tracked gross numbers by grade (preK, K, 1 - 12). I could pull out that Uptown Elementary referred 14 students in third grade, while Downtown Elementary only referred 5 students in third grade. Now I need to break that out further. For each of the 14 grades, a referral can be made in one of 15 categories (01 - 15). Is there an easier way than making 210 separate fields (preK01, preK01...g1215) to generate data for a report that could say that "Uptown Elementary referred 14 students in third grade, 5 code 04, 8 …

Hello, I'm new to Filemaker, and I'm trying to get a total calculation of every record. Let me explain. In my Layout, I have a "Paid" field. Positive numbers will be black, and negative numbers, red. Below the "Paid" field, I have a "Total" field. What I'd like to do is create a "New" record for every new job I receive, and input the amount paid, but I'd like the "Total" whether positive or negative amount to show in the "Total" field, in every record. Is this possible? How do I calculate this? Have I confused everyone Any help would be appreciated. Thanks Dean

We have a few mature databases that have complimentary and redundant data. I'd like to combine 3 of them into a single database. Is there a way to copy the field definitions (there are some similar fields and some disimilar fields), value lists etc from each to a new database where all of the data can be restored? Or is there another alternative?

hi, is it possible to "import" some fields from another dbase

Hi, I'm making a OCR customer control number and the Bank has given the way to calculate it. Based on a couple of fields, I get a value of 10 number. In all, it should be 11, where the last is a control number based upon the value of the 10 numbers. I don't mean that someone should figure it all out. I pretty much understand the basic, except for the function I need help for. And that is to separate all the 10 numbers individually, because they need to be added together. I tried to use the Right(field,1), Right(field,2), Right(field.3), Right(field,4)... formula, but that gave all the numbers from 1 and upwards. How can I separate the numbers individua…

I have a calculation field that should count the time between a creation date and a close date. This calculation field shouldn

Dear All I am trying to extract text from a file containing a lot of text. I have a start value let

Hi, I have a text field witch is populated with the following text: Macintosh HD:Users:Admin:Pictures:Adressbook:picture.jpg Now I only want to extract the last word. In this case it would be "picture.jpg". The calculation would be rightwords(textfield,2). But the problem is that the file could have a compleet different filename. Does somebody know how to search for the last ":" character and filter the filename out? thnx & greetz, Jeffer

It seems that to use a field in calculation in a layout, that field has to be physically present in that layout (in this case the field content is a related lookup from a separate file). Is this true? If so, can I have the field present in the layout, but somehow hide it? Thanks in advance!

This is probably a basic question, but how do I convert a birthdate to a current age? The age should be calculated at the time the record is created, and then not change if the record is reopened. Thanks in advance.

I have a database with a calculation field. The calculation asks for data to be brough in from a related DB. After the data is brought in (text) is there a way for a user to add more text to the field. I do not want the data to change the related field, but to only add additional data to the users comments. The calculation reads:Comment= Case(CPP_1_3="Unsatisfactory",Domains::KOC_U,CPP_1_3="DEVELOPING", Domains::KOC_D,CPP_1_3="PROFICIENT",Domains::KOC_P,CPP_1_3="DISTINGUIST", Domains::KOC_DI) When one of the four words (Unsatisfactory, developing, Etc.) is chosen, text is placed into the field "Comment" I want the user to be able to add more information to …

I trying to make a db for stock tracking. I want to have a text field display "sell" when I hit a loss if it's 10% of my purchase. I have defined shares bought, price bought, todays going price, what it's worth now. I can't see to figure out percentages. I do worth now times .010. but I can't figure out how to do the if statement to figure out to display a message that I'm at my 10% threshold to sell. Hope this makes sense. Thanks

Hi All, I put together a Text to date calc field, with Date as output. Regional settings on both local and host machines are set to Autralia, ie. dd/mm/yyyy. However, the date returned from the calculation is in mm/dd/yyyy format. Anyone got some thoughts on how to rectify this?

Hope this is in the right fourm. I need to know how to make the first letter of a persons last name Capitalized along with there Middle Inital, and there first name. I have 3 sperate fields for the name "last name", "MI", "first name". Aslo if the have the cap locks on I only want to first inital capitalized and the rest of there name in lower case. Hope this isn't to complicated, and I hope i haven't babbled to much. Thanks

I know I can't see the forest for the trees, but I can't seem to find anywhere where someone has addressed the exact day, year to year, calculation. Part of our work is generating license badges that are supposed to expire on the same day, year to year. We caused much chaos in the d/b because we did the ol' date plus 365 and then changed the calculation to 366 to make up for the leap year. Computer records were then different from license badges already issued. If someone could email me at [email protected], it would be greatly appreciated. I will be too busy hiding in my cubicle to log back into the forum....thanks in advance!!!!

Can I set a field so the curser does not return down to the next line, or have the submit button be activated by a return? This is part of a login. Thanks in advance. norm

The outline I'm doing is 20 pages long. Each field is a page a piece. When I slide/printing it in its own print layout it leaves a large space. Is their a way to get the space smaller. "I tried pulling the body up as closed to the bottom field as possible."

This is a very simple question. How do I make a dotted line (----) in filemaker? There are a lot of fancy possibilities but no such thing as a simple dotted line (using text to type it which I thought of as an alternative takes up to much width in my layout). I tried the little dots, but they end up in two lines when printing. Anybody got a solution? Thank you for reading and eventually answering this question.

I have a database with one field called area and one field called number. both are text fields. I would like to add contents of area to number in front of number and then delete area field. like so.... area --- number ----- number 904 --- 555-1212 --- 904-555-1212 Is there an easy way to do this? Thanks in advance. Larry

This is probably an easy question. I've created a address label calculation field. When in browse mode, the field contains "1.1552E+15" until I click in the field, at which point the address label looks perfect. Is this an error message? What is the problem? Thanks!

once a test in a case statement is true, will filemaker do the result and quit trying the other cases, or do I have to worry about having multiple true cases?

Hopefully someone can help me! I'm creating a Business Plan. It's an outline setup that can be filled in the fields. I put each part of the outline in a different layout. To print I put the fields all together in one layout and used slide/printing to get rid of spaces. (Because aparently there is no other way) When I preview what the printing will look like, the space is to big between fields. Is their a way to choose how big the spaces between are. Or does someone know another way to do this?

Hi, I have two related DBs A and B, with 1:m relationship. I created a auto-enter serial # in A as primary key, and set up relationship using this field. Now I need to provent user creating duplicate record in B. In B, a record can be identified by 3 fields (serial#, OTA code, and date). What I did now is create a text field, auto-enter calculate value(which hold the 3 fields), and I check the unique radio box in validation. But it doesn't work. Can someone please tell me how to do this? Thank in advance!

In the Attached file (fmp3) i have a list layout, and a Summary layout. The summary layout has FINALLY been set up to TOTAL the Values according to the Selection of the Sales Code. Now i have been told that the SUMMARY needs to ONLY display the Values for any given MONTH/YEAR. Hence, i ADDED a date field to diaply the MONTH and YEAR. But problem is, how can i get the result i am now after? I tried to add an IF()DATE calc. to the existing CALC, with NO LUCK. Layout 4 is where i got up to, can anyone help with this. Just needs to show the Calculated values of the Summary Layout, BUT According to the MONTH requested. Thnx in advance. Corey…

Ok Perhaps this might be simple, but what I am trying to do is when I do a Find using a date range. I would like to capture the first date in one field and the end date range in another. When I think about it mabe this can be done but fetching the date from the first field and the date from the last field. But that might not be it. can anyone help? RET

I have a Db for work-orders and have a field for serial numbers that goes IE2345, IE2346 and so on. It is a number field, Indexed, with Autu enter serial, not modyable auto, strict, required value and unique. If mistakenly I change the "next value" field in options to a lower value than the next in line it gives me a double serial number.. Is taht normal? How can I avoid this.... Thanks a lot in advance....

I have a tow dbfile 1.is Order. 2.Technacian. In order datebase,if make a new order we have 3 services time provide to our customer. The problem is, I want to make a monthly report,to sum our Technician working time. A Fields is (Total Time)repetition 12time B Fields is (Technician No)repetition 12time The case will,in one order maybe have 3 different Technician No: I don't know how to make a report to sum the Techician Working time!!! Like This Can someone help me?? Sorry that my english not very good!!!

It seems like it should be quite simple, but I can't figure out how to define a text field so that it will auto-enter the contents of a global text field. I need the field to allow the user the ability to modify the auto-entered value. I would greatly appreciate a solution.

Here is what i am looking for ... I have a field "Field A" that auto enters the Creation Date. Another field "Field B" that i need to have the current date in (today the field would have 8/19/03 and tomorrow 8/20/03 so on so forth). I need a field "Field C" to subtract the Creation Date "Field A" from the Current Date "Field B" to give me the number of days that the record has been the database ... Please help ...

When entering a city name I am trying to be able to show if other cities with the same name (different state) or part of the name) exist when they enter. I have a master file and a related city file. So, when someone enters Portland, for example, a field / portal would show Portland,OR and Portland,ME. Northport, etc. Is this the right approach? How could I do this?

I have a summary field that keeps a total of another field ... I need it to give me the summary of all records in the database not just the current found set ... any ideas?

I have a database solution that is running on FileMaker Server 5. At night, I have it run some scripts to update invoice information. I have Created By and Mod By fields, however I do not want the "Server" to show up as the person that last mod'ed the records. Is there a way to do this? Thanks Shawn

Does anyone know an effective way to turn a text field into intials? Just the first letter of each word; names, for instance. I'm sure I could cobble together something clumsy with PatternCount and Left, but if anyone has an elegant solution, I would be delighted to hear it.

Is there a way to run a pattern count on a field from a related file ... here is what i am trying - PatternCount(DEV_Cadyware::Info_Package,"J") - and its not working any ideas would be appreciated

I have field MF=Case() where case is: Case(SNF =1 and FNF = 0 and TF = 0 ,1,SNF = 0 and FNF=0 and TF = 1,2,SNF = 1 and FNF = 1 and TF = 0,3) This case returns 1 and 2 as it should, but where it should return 3, MF is blank. All fields are number and fields SNF, FNF, and TF all have either a 1 or 0. None of those three fields are blank. Thanks for your help.

I have a question. I have been trying to see the total of all fields for the found record sets. What I have is like an ivoice DB. so each record contains one customer and all the items he/she has bought. Then I have an ivoice total for each record. Now when I view all of them in a list, I can see each customer name, invoice total and when they paid. What I want to do is make a field in the header that will display all the money collected for that list. I made a field that contains the sum of the field "invoice total" and put it on the list. But nothing. I know I am missing stuff but I just can't figure it out.

I have a database with several thousand records in it. While there are many fields in the database, I need to build a report on just two of the fields. One field is catagory. Each record is assigned to one of 5 categories. The second field is zip code. I need a report that shows how many of each category there are in each zip code. The database covers the entire US. I know that there must be a way to do this. example of what I need: Zipcode - Category 1 - Category 2 - Category 3 - Category 4 - Category 5 - Totals 10000 4 0 3 3 5 …

OK, i have 2 databases. one is a database with a bunch of records wich hold information on parts ( partsfile ) and the other is a database that holds jobs. what i am trying to do is have it so when i type in a part number in on repeating field that it looks up the part name and cost for that part number in ( partsfile ) now i got it to work making a relationship with partsfile and partnumber but if i change the cost in partsfile it won't update in my jobfile. so what i did was try and use calculation fields and it works fine for the first rep. but will not lookup or display the rest. i have partnumber, partname , and partcost set to 15 reps and made sure it is setup t…

I have serveral product lines (ex: shoes, shirts, and pants). Each product line has its own product number series, shoes are the 1000 series (with id numbers being 1001, 1002, 1003...), shirts are the 3000 series (with id numbers being 3001, 3002, 3003...) and the other product lines follow suit. When I create a new record I want FileMaker to automagically generate the next product id that is applicable when I select the product type from a drop down box. In the backgound FileMaker should be doing something that I guess it would look like this: Look at the PRODTYPE field and see that it is "Shoes" Find the highest PRODTID where the PRODTYPE is also "Shoes…

I just had a user ask why he couldn't change the color of the date in a date field, but he can change the color of text in a text field (both in browse mode)... Does FM not allow these changes to date fields??

I have a database that tracks activities that households participate. Each time an activity is attended it is entered in the Activities database. I am creating a summary of the data in the Activity database and am able to get the total number of attendants for a particular series of activities, however I want to get the total number of unique households that attend. Some households attend multiple times, so I want that household to only be counted one time. Any ideas of how to go about creating this so that I can summarize the number of attendants with the number of unique households in the same subsummary?

I have a question that probably wouldn't be necessary if I'd designed this db better from the start, but now I'm curious if there's a way around it, so here goes. Maybe someone out there has an answer. I have a FMP 4.0 db with 250+ fields which receive one of three data entries (0, 1, or 2) via CDML tags over the Internet. I would like to sort & perform various calculation functions on their contents, but need a way to separate the 250+ fields into 6 different categories. (The fields represent different learning activities at different grade levels, but each is associated with one of six different learning strands....I want to calculate by strand, etc.) So i…

Hello. Here is a strange FP5.5 feature I'd like to fix with the help of you all. I have a calculation looking like this: Case(Statut_patient = "GR" and Type_patient = "Ambulatoire",Code_GR,Statut_patient = "GR" and Type_patient = "Hospitalis

Hello-- I've got a layout with a date field into which is entered the date when a group member pays his/her dues. I need to set up a calculation in another field that determines the number of days before the member's dues have to be paid again. I'm brand new to calculations in Filemaker & would appreciate any advice you might have for me. Thanks. dolphy

Is there a way to take the found count from one search (example "50"), perform another search and then take the found count from that search (example "100"), take the two found count numbers ("50" and "100") and divide them to get the result ".5"?

I have a score field for 800 people. I take that score and average it on a summary sheet. I need to show the average score and convert that score to another field score on the summary sheet. For example let's say the average of all 800 scores is 227.521 and when I get that number it has to be converted to 56. If the average was 278.220 the number to convert to is 57. I tried using a case statement but the average comes in with a number and decimal number. Is there a way to write a statement or statements that will cover a various number of scores such as: 227 result 56 228 result 57 229 result 59 etc. The problem arises with the decimal. Can I use grea…

Hi there, I have a question about auto-fill funtion!! I have two fields 1.(Order NO:) 2.(Services Date:) I want to auto-fill the number buy date. The problem is i want to auto-fill is by Services Date, not creation date!! Exp:Today is 2003/08/18 I add a new order, the services date is 2003/08/30. So the Order No will be 20030830-001 ,and then i add another record,the services date is 2003/08/30 again , so the Order No will be 20030830-002. And then I add a new record again the services date is 2003/09/28, so the Order No is 20030928-001. When I next day to add a record, the services date is 2003/08/30, i want the Order No: is 20030830-003 (because…

Hello, Is it possible to define three different calculations for the three repetitions of a repeating (calculation) field? csb

I have a db with classes of competitors (comps pulled from another db). One layout allows the user to enter the rawscore earned by each competitor in a particular class. Another field calculates the percentage from the rawscore (determined by the max points of the test done in the class - pulled from another db). I need a field to determine placings - the highest percentage gets 1, next highest 2, and so on to 6th place. No placing after 6th. If the rawscore is entered as 'SC', 'HC', 'NS' or 'E' those letters should appear in the placings field. I can't figure a calculation to do this - help? TIA, Martie

I have fields "Title," "Last Name," "First Name," "Spouse Name." All records have a "Last Name." In various combinations, some records also have a "Title," "First Name," and "Spouse Name." I want to concantinate to produce calculated fields such as: Doe, John Doe, Mrs. John Doe, John and Jane Doe. How can I do that and eliminate unnecesssary spaces?

Hi guys, for the life of me I can't get the above error message appearing each time you need to open my database. It originated from USA so naturally the system formatting was mm/dd/yyyy - not compatible with my system. I am SICK to death of this message appearing when I open up the database (and so are my users) asking whether to use system formats or current etc etc. so far to try and fix the problem i have: removed all date fields (i didn't need them anyway) in my opening script - [set user system formats] = "ON" Format, Use system formats and I am STILL getting the message... any ideas?

Hi, In a database I have among others 15+15 global fields that determine the format a record will have in a (Preview) calculation field. ExpItem 1 - ExpItem Divider 1, ExpItem 2 - ExpItem Divider 2, .... ExpItem 15 - ExpItem Divider 15. With the help of GetField I determine what the result in the Preview calc. field will be. GetField(ExpItem 1) & (ExpItem Divider 1) & GetField(ExpItem 2) & (ExpItem Divider 2).... The problem is that the insertion of the value of (ExpItem Divider) is dependent on whether one (!) PREVIOUS and ALL (!) the subsequent fields are empty. So I need ExpItem Divider 4 only if GetField(ExpItem 4) is not empty, and neither is ExpItem…

My network has PC

Ok, so I'm completely confused. Being that I'm a relatively new User of FM. I just can't seem to figure out how to define or use arrays. There are no mention of them in any books I have or the Help screens. I'm sure I'm missing something there must be another name for them in FM. Can anyone point me in the right direction? Thank you.

Hello, I have a field which is formatted as value list (strict, do not allow modification). Some of the values also contain a question mark (among other characters). When I want to perform a find and I select an item from the value list, which contains such a question mark I get the message that the field value I've choosen as a find criteria is invalid (accept this value does not work). Why is that, and how can I avoid it? Thanks. csb

Hi-- I've got a bunch of text which already has sets of Standard Double-Quotes Charcters, the same as FMP uses in it's calculations. I beleive there is a way to replace these, but I don't remeber how...Is there? All My Best, Jeffrey

Hi, I need to define a field called it as DUP to indicate if there is a duplicated record. I used SELF relational such as if serial# = SELF Serial# then DUP = Uniqued DUP = Duplicated. Otherword: Dup = Serial# = SELF Serial# It works fine , but it cannot use DUP as a key because it cannot be indexed Is there any way to make DUP to be indexed without scripting. Thank you very much in advance

I need to extend all repeating fields to 15 repetions. Can this be done ?

I'm new in FMP Software, hold every one can help me! Thank! My problem is I create two FMP files, call fileA/fileB. When I create a new records in fileA, put the name and date. How i relation the date to fileB date? and hold that the fileB date is always follow the latest of the FileA date even I create a new records will the same name but diffent date, the FileB much follow the latest date to my FileB. Any Idea! Thank!!!!

Hello, I just started learning filemaker yesterday and its really fun. I downloaded this great db from filemaker.com and i try to inegrate its auto-serial options on my current work. Now i wonder, i created a new data the serials makes it #1 and new data #2 and so on. But when i deleted the data it still increments and doesnt use the vacant serial #, can i make filemaker to look for that vacant # and use it, before moving on and incrementing #'s again. thanks, Louie

i'm pretty new to filemaker and i have a question i need answered. i've made a datebase of all the possible questions to have for ordering supplies for a cabinet making company. one of my fields is "days since last order". i have a "current date" field and a "day of last order" field and i need a calculation so that it will subtract the "current date" from the "date of last order" and show up in the field "days since last order" as a plain number, such as 5. i've tried various calculations and they don't seem to work. to my knowledge nothing like this has been posted and Filemaker Help isn't doing me much good at this point. thanks in advance.

Hi All, I just want to know if there is a possible Field A Calculated Field B 2 20 2 It means that the first record show calculated result , the second duplicate or many duplicate does now show anything. I am trying to use count but does not work. Anh Tran

I have a file that the customer wants to view in table form. It has so many fields that it is 2 1/2 viewable screens wide. What is the best way to add a copy of the very first field somewhere later in the record so that the customer can still identify the record? I tried to duplicate the field, but it didn't show up in the table. I currently have the 2nd field set as a calculation field that is set to equal the first field, but it doesn't update if the first field is changed. any ideas?

Fields: client

Hi all, probably a dumb question... Two records and results fields in footer. I need to be able to subtract the values of record two's fields from the same fields in record 1 and show the results in the fields in the footer. There are about 15 fields that will be compared and the results for each will either be a negative number, 0, or a positive number.

Hi all, I am dumfounded as to why it is so difficult to subtract the value of one field from the same field in a different record. I have posted this question in many FM forums and have gotten a wide variety of responses, all of them frightfully complicated. There must be a simple answer for this because it is NOT an unusual request. I have a flat file (no relationships, portals, etc). There are only two records visible. I need to be able to subtract the values of record 2's fields from the same fields in record 1 and show the results in the third in the footer. There are about 15 fields that will be compared and the results for each will either be a negative…

Hi folks, Some major egg on my face, but I have to ask. I've created a calculated field called Service Fees (code below) If(Total Payments <= Document Total,If(High Risk = "High Risk" and Amount Issued >= 500 , (Amount Issued - 100) * Interest Amount High, If(Amount Issued < 500 and High Risk = "High Risk", Amount Issued * Interest Amount High, If(High Risk="" and Amount Issued >= 500, (Amount Issued - 100) * Interest Amount Low, Amount Issued * Interest Amount Low))), 1 * some magical field = to Service Fees) It's not pretty but hopefully will become functional. What I'm trying to do is when a certain criteria is reached it will stop c…