Calculation Engine (Define Fields)

Hi everyone... long time listener first time caller I'm positive this is an easy answer one but I can't wrap my tired little brain around it. Working on a donations database that I inherited, and normally I would've just destroyed this POS and started from scratch, but that would've meant over 1000 records to re-do. And guess who would've had to do it. Anyway. Two databases, relationship is the Donor ID field. One database is the pretty front-end, the other is the line item listing of each individual donation. On the line item database, there is a field that correctly summarizes the total amount of $$$ donated by this one donor ID. On the pretty database, I can…

This is a new area in FM for me even if it is, I believe, one of the most basic in db. I try to make total field that only gives the total based upon present year, so when the next year come the total shows only total based upon invoices from that new year. I have seen db examples in the FM extras folder where you make reports with scripts to give totals. That is not an option. What I'm thinking about is if it was possible to use the formulas to achieve this? Thanks!

I have a solution that up till now, customers pay an annual fee based on the current year. We now want to have the option of having customers pay their annual fee based on the financial year (ie July - June). Our password has been linked to the current year, so that any previous password codes don't work when the year rolls over. How do I do this for the Financial Year? I need a calc field that checks the system date and decides which financial year it is presently in. I then need to build this into the password checker field so that it can run both types of passwords similtane ously. Regrds Edutrack

I was just wondering what those function could be used for! Regards, ___Paolo

We have been trying to make graph like grading on a school report. Basically we were using letters (l) to create a line graph in a text field - it didn't print the same way as it appeared on screen. We then tried a repeating container field with shaded boxes so that according to a chosen number, this image would appear in the box - this works fine and prints accurately, except that we are trying to align the images to the left hand side of the page. The calculation gets the correct picture, but I can't align the image to the left - it only centers the image. Can anyone help or suggest a better solution (I also tried a relationship to the images, but the alignmen…

Hi there, Now i have a customer which need a system that help keep tract of sales data including a picture, the system need to store a lot of picture in the database (about 500 picture per day). The system is run on PC, after i finish the system, i set a container to let them insert picture, but i found that sometime the picture does not come out or cannot be insert, especially BMP picture. The customer normally using BMP or JPEG picture, so got any way to solve this problem. Another question is due to the system will store a lot of data with picture, i scare the system will become slow, got any solution? Regars, Henry

I have placed this in a couple of different topics and haven't heard back. I know I shouldn't do this and I won't in the future but I am kinda worried because I need to find a solution fast. Can someone offer me some insight on this? I have an 'Artist" database that I have included in this post. There are 2 layouts, "Artists". and "Artist Report". When you enter data in the "Artists" layout it then displays the spins in a column on the "Artist Report" layout as well as the week ending data in the header for that Artist. As we enter new records we date them exactly 7 days apart. What I would like to do is to get the "Artist Report" to display not only the current we…

Hi, I'm strugglig with this for a while. I'm just looking for a way to identify mispelling when the user enters a customer name. It could be also used to check dupes while entering a new record from globals. The best I could get at the moment is an extremely long calc of type : Case(Length(TrimName) >= 8,Replace(TrimName, 8,1,Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ", 1, 1)) & "

Hi there, i found that every time i create a field on a layout and then type some word in the field, if i keep on type enter, the field will become enlarge. Can i fix or lock the size of the field so that they only can entry in a fixed size field, just like if i set the field with two line, then they only can type on this two line, even type enter still cannot jump into the other line. I know i can set the max number of the charactor, i found that that one still not very good enough to fix this problem, so is there got any way to solve the problem. Regards Henry

I was wondering if someone could help me with a few currency fields i have in my run time solution. This is something that never really crossed my mind until a problem came up. I have a runtime solution with 2 or 3 number fields and they are used for currency fields. But what i noticed is when the users international settings are set to like United Kingdom or Europe the currency information is diplayed in US currency. Is there anything i can do to correct this in the future? Thanks for any suggestions you can give me. Take care. Filemaker 6 Developer Windows OS

Howdy all. I'm trying to setup a Calculation field that will get the number of records, with a specific field marked, in a related table by a date range. We'll call them Table A and Table B. Table A contains a field called "cust_id", a "start_date" field, an "end_date" field, and a field called "no_incidents" to hold the calculation. Table B has a field called "cust_id", a field called "create_date", and a field called "incident". The two tables are related by the "cust_id" fields. Using Count() in Table A.no_incidents I can easily calculate the number of Table B.incident records related on "cust_id". My calculation is as follows: Count(cust_id::incident) …

Basically I have two calculation fields 1) ANNIVERSARY DATE which = Date(Month(Date of Hire), Day(Date of Hire), Year(Today's Date)). The problem here is that sometimes the YEAR of the anniversary date is not 2003 but 2002 (like if they started in Dec.) So, this doesn't quite work. So, I created another field ANDATE2 that is the same formula but with the YEAR as Today's Date-1. Both of these fields work fine but I had used the ANNIVERSARY DATE in another calculation field: 2) WEEKS = Case( IsEmpty(Today's Date) or IsEmpty(Anniversary Date), TextToNum(""), Round( ((Today's Date - Anniversary Date)) / 7 ,0) ) So, I have to change…

This should be a fairly simple question.. every student in my database has a numerical field with a test score in it. How do I find the average test score of all my students combined? Thanks, Corey Martin

hi, is there a post earlier about speeding up calculating time? i have developed a database that manages and analizes projects, staff, costs and times for use in architect's office. problem is it takes a little while to calculate results on some layouts since some of these layouts have litterally 50 - 100 calculation fields. the calculation time is of course varied depending on the speed of the machine and the network setting but any idea if this can be improved? cheers, danny

Following my last 2 posts from another thread ( CaptKurt Unique_ID , I wondered if there was an issue for this. I want a record to be auto-entered using a global field in the calc string. I found that the method profuced unexpected results, except if the global was referenced from a relationship. 1. Is this a known problem ? 2. Is there a problem to involve such a method?

Hi Forum, this is probably dumb but here goes ... when I paste a graphic into a containr field, it's too small. I enlarge the container but then the graphic gets funky. It loses it's clarity. I've tried changing the graphics options, using a calc container to display the image, preview mode ... nothing seems to help. My secretary has to be able to see these images clearly so she can select the right one but she cant see em very well. Is there anything I can do? I search on containers and graphics but can't find any discussion about this. I'd appreciate any suggustions given Pete

hi all, i'm having some problems with a calculation field being an invoice number field. scenario: my ideal invoice number would be a series of numbers where the first 5 digits are my actual project number, the next 2 digits are just month of current year and the last 3 digits should tell me how many invoices i have created for the project so far. everything was simple until i tried to put some calculations to generate the last 3 digits. i can't tell FM to identify the difference between projects. for instance, i have 3 projects 01001, 01005 and 02011 which i want to create invoices for. 01001 has 3 previous invoices, 01005 has 2 previous invoices and 02011 has…

G'day All, I'm new to the idea of multikeys and have read all the threads here but still need some help. I have a database for booking rooms which uses a multikey based on these fields: Date & room_id & time In the time field I am using check boxes for each timeslot. I want to use this multikey to show the bookings in a portal in another database. The problem is I can't create a calculation that gives me the multikey for room bookings Eg date - room - time 20030621 - 01 - 7 20030621 - 01 - 8 20030621 - 01 - 9 I have tried this: [color:"red"] Substitute(time & " ", " ", date & room_id & time & " " ) But I …

I am building a cross section drawing of a kitchen cabinet. I have created the drawing in another application and have pasted it onto a layout. The dimension for various parts depend on calculations. These calculations in turn reference different cabinet styles. Each cabinet will always have a top rail but the dimension of that rail will vary depending on what kind cabinet you select. In some occasions a dimension will equal zero. In these instances I would like the numeral zero to disappear. Is there a way to affect the visibility of a value based upon mathematical criteria? Thanks.

Hi, I have an import from a ODBC link, the data in this import contains a date field, but it is formatted "20012003", if i change the date format on the field to "20/01/2003" it still imports as "20012003" any ideas? Thanks, Dave.

Auto Fill Fields I am not sure if "Auto Fill Feilds" is the correct term, but what I am trying to do is: I am an absolute rookie at databases. I have modified the Student Records database that comes in the FileMaker Pro6 to use as a records for horses. My problem is that I have created fields for the horses bloodlines and I would like to be able to enter a horses name, and if that name is already in the database, the Sire and Dam (parents) and what ever other generations that are already in the database, would auto-fill. SSSire SiresSire SSDam Sire SDSire SiresDam…

I have a summary field type called "group_total" which is the total of all the responses for each item in each event. I need to find out the percentage of the each of the item from the group total of the current event. I defined a field called item_percentage be a calculation of (item_count / group_total) * 100 i.e. event 1 item_type item_count item A - 2 item B - 3 item C - 9 item D - 0 group_total -14 event 2 item_type item_count item A - 3 item B - 0 item C - 7 item D - 4 group_total -14 For some reason I am not getting the correct percentage. In fact when my data…

I have a solution that I have been managing at a distance for quite some time, and I have consistently run into the following problem: My client informs me of a glitch in the system. I test it out on my copy of the database and fix it. I send out a clone of the database to the client, which they use to load in their data. However, because I am using an old version of the same file, my serial number is lower than the last number used by the client. When they start adding new records, Filemaker happily reuses the serial numbers ***EVEN THOUGH I HAVE DEFINED THE FIELD AS REQUIRING UNIQUE NUMBERS***. Given that I am trying to use FM's purported relational capabiliti…

Hi, Being an authentic end-user, my question is quite simple...(but I have not found any answer in the archives yet) How can I enter more than one entry in a field refeering to a value list (only these values are valid)? Field : "language" Value list: fre eng spa ital ger jap .... How to get : fre; eng; spa or fre eng spa When I select a second value it overwrites the first selected. I use FileMaker 4.0 french version (in case there would be an other french speaking on-line..) Thank you Sophie

Hi, I work on a PC but I was told to build a database and have PDF files embedded in the database. I've been doing this by having container fields and inserting the PDF files that way. But the problem is when I go to my boss who works on OSX, the container fields show a windows icon and when he double clicks on the icon it doesn't open the PDF file. Any ideas? Thanks, Kermy

Hi, I work on a PC but I was told to build a database and have PDF files embedded in the database. I've been doing this by having container fields and inserting the PDF files that way. But the problem is when I go to my boss who works on OSX, the container fields show a windows icon and when he double clicks on the icon it doesn't open the PDF file. Any ideas? Thanks, Kermy

Hello People! I was just wondering if anyone would like to comment/share their experience and knowledge on Lookup fields vs. AutoEnter Calculations (of the same field in question). Which is better or more stable way to go about pulling the associated data? Thank you!

hi, I am having trouble with a global container field i have created I am using via a server. I keep entering a paint obecjt into it for color but when I close the database and reopen i lose this value, do I need to do this locally in order to retain this value???

I currently have a field in a purchase order that looks at the previous order and increments that number by 1, unless the purchase order has multiple pages (which are actually multiple records). In that case it simply copies the existing order number without incrementing it. It occured to me that instead of looking at the previous order number and incrementing that number, it would be better to use the serial number calculation. (I welcome your thoughts on that. ) I would like to use a calculation that says: if page field = "more", increment serial number by zero, otherwise increment by 1. (or visa versa) But I can't get FMP to accept my calculation. …

Here's any easy one, but I just can't get it to work. I want the current date to be displayed (and printed) in the Header. I've created a date field and have tried using "Today" plus most of the other "date" functions, but nothing shows up on the screen. Thanks. ~ jack

I'm creating a contact log for multiple projects. Some of the correspondence put in the log has a hard copy that goes into the project specific hard file. To connect the hardcopy to the contact log we need a record specific serial number I.e (Record ID-(record specific numerical serial). Is there any way to have an autoupdating serial number for each correspondence attached to each record in a database? Does that make any sense?

I have to change the sales tax rate in two different databases. The sales tax in NY went up .25%. One company only does business in a single county and I changed the tax rate field from a number (I.E .07) to a computation that said: "If(invoice date <6/1//2003, .07, .0725"). This seems to work and nes invoices are taxed at 7.25% and the old ones relain at 7%. But the second company is more complicated and they do business in numerous counties that have different tax rates, so if the tax was 7% it becomes 7.25%, and if the county tax was 8% it has changed to 8.25%. So, for each customer I entered an old and new tax rate, and created a computation field for the "…

I am building a database for kitchen cabinets that uses a lot of conditional statements. I have 40 cabinets in this database. I am trying to figure out how many cabinet doors I have to build based upon which cabinets I have selected from my library (global - repeating field). I do this right now with a CASE calculation. In the Case that style of cabinet = B21...Quantity of Doors = 2 I reference 40 possible styles of cabinet with this CASE calculation. Would this type of calculation be more efficient with a SET FIELD script or the CASE calculation? Thanks a lot for your help. I've learned a bunch of stuff from this website!

I have an automatic numbering field that uses the serial number option. I would like the user to be able to reset this serial number to (1) without having to access the DEFINE FIELDS dialog box. Is there a script I can produce to do this? Thanks!

Hello People! Sorry for another post about looksup but I am really confused here... I have never seen this and perhaps some of you have and can help me. Here is a little intro on related files: ITEMS.fp5---------------------------------------------- WS_ID - auto enter serial ItemID - text (eg. cx-1001) relationship: ITEMS_LINEITEMS WS_ID= ::WS_ID ITEMS ________________________________________________________ LINEITEMS.fp5------------------------------------------ ItemID - lookup relationship: LINEITEMS_ITEMS WS_ID= ::WS_ID LINEITEM _______________________________________________________ soo...all this is great and working...the portals a…

The significant other file in my database holds all significant others for a client, like mother, father, siblings, etc. There are multiple fields for address information in this file. Another field in the file is "household member", a yes or no value. I want the address information to be updated accordingly to the value of this field. If it's 'Yes', then I want the fields to be auto-entered with the address that is currently assigned to the client (a record in 'address-history', keeps each address for the client, the relationship uses a descending-sort to keep the newest address at the top). So far I've gotten it to work with scripts and two buttons instea…

We are currently having problems with importing .jpeg files into our FMP IS database. I have read previous threads and some deal with this problem, but not quite. We currently run FMP Server V5.0v2 and FMP v6.0v4 on all client machines, the system runs on G4 macs running on a OS 9.1 ethernet network. The problem occurs when images are located on a seperate Mac (i.e not on the FMP server machine), images are imported using the folders.. import facility and stored in a container field, thumbnails are also utilised. When imported the images show on the client machine in both a thumbnail and large version, but once client quits and re-opens both images (thumbnails…

Hi I have 4 number fields "cost of repair 1, cost of repair2 , cost of repair 3 and cost of repair 4". I also have 4 text fields "type of repair cost 1, type of repair cost 2, type of repair cost 3, type of repair cost 4" I want to add the values of all the cost of repair for which there is a value "other accessories" entered into any of the text fields named above. Is it possible to do these conditionnal additions in filemaker?

Hi, I've tried this for about 3 hours and gave up in frustation-I have a 12 figure number (example is 112233445566)-I want to use FP to insert a space after every second number so I end up with 11 22 33 44 55 66. This has to be done in the field so when I import the text file with the original info, the conversion is done automatically-other wise I have to do it in Excel-anybody got any ideas? Sandy

I hope Im just missing a really simple idea, but here's my question. Ive got some containers on a page and a button below each. If you click the button below the container, it sets the field to that certain container and opens the "insert picture" step, thus displaying the picture you selected in the container. Now, here's my question. I want FMPro to handle the picture, not just a link to a referenced picture, but I want it to be displayed, preferably in the user's default web application (i.e. Internet Explorer) Ive figured out in my head how to do it from a referenced picture, but unsure, if even possible, how to do it from one which is NOT referenced. Again, any help …

Hi all, I created a calc field to display the current record number of a found set. I would like to use it on a layout to tell users what record they are browsing thru (kinda like the status area in FM). Works just fine except when i sort in a different order or perform a find. Then it display things like: Record 64 of 7 found or the numbers are not in sequence. I could be looking at record 4 then next record would display as 7 then 5 etc. What am i doing wrong?? Thanks for your help. --Dan

Hi All, I would like to know why suddently in the define field, the box of prohibited modication value is grayed out. I would like to change it but can not click it. Do you people know how to make it as modification value? Thanks Anh Tran

I'm trying to create a calculation field using FM5.5 that will return one of two values based on the value of another field. The art department requests ink samples from the ink lab and assigns the ink a temporary formula name of "TBD1234". Once the ink lab formulates the ink, the formula name is updated and the "TBD" portion is removed. I'm trying to create a calc field like so: If(Formula Field = "TBD"*, "FORMULATE", "COMPLETED") Unfortunately the asterisk character doesn't return anything. Is this possible?

Why would a file that is 325kb increase to 1,832kb when i insert a 24kb Jpeg image?? That's almost 20% increase in file size for 1 image. What am i doing wrong? i just want to use the image as a background but the size could turn out to be a worry and a slowdown! Should i be using a different file format? Thanks --Dan

Is there an way to add aqua elements to layouts? Maybe through a third party? Primarily buttons. Or do I need to do a screen capture of an aqua button, put it on a layout and then create an invisible button on top of it?

I have a simple database that we track deductions. Each of the deductions that we log in to the database has a unique transaction ID that we get from our customers (we key this number in manually). Sometimes they send us the same deductions (sometimes months later). Now to my question. Is there some way to know when we put the transaction number in that a message or something will tell us that the transaction was already put in. Thanks for your help

I have this calculation which is a little sloppy and I was wondering if anyone can help me. (If( tc1_xp_vcd = "Marginal", 1, 0)+If( tc2_xp_vcd = "Marginal", 1, 0)+If( tc3_xp_vcd = "Marginal", 1, 0)+If( tc4_xp_vcd = "Marginal", 1, 0)+If( tc5_xp_vcd = "Marginal", 1, 0)+If( tc6_xp_vcd = "Marginal", 1, 0)+If( tc7_xp_vcd = "Marginal", 1, 0)+If( tc8_xp_vcd = "Marginal", 1, 0)+If( tc9_xp_vcd = "Marginal", 1, 0)+If( tc10_xp_vcd = "Marginal", 1, 0)+If( tc11_xp_vcd = "Marginal", 1, 0)+If( tc12_xp_vcd = "Marginal", 1, 0)+If( tc13_xp_vcd = "Marginal", 1, 0)+If( tc14_xp_vcd = "Marginal", 1, 0)+If( tc15_xp_vcd = "Marginal", 1, 0)+If( tc16_xp_vcd = "Marginal", 1, 0)+If( t…

Hi, I'm very new to Filemaker and more used to another database program so I'm having a difficult time making things work how I want it to. The user enters in information through a form layout that had been previously created. I have created a layout/report which did work how I wanted it to. It listed an employee and a count of records related to that employee. It worked fine. My problem is that when I go into the entry form layout and perform a find, when I go to the report that I had created, it doesn't work anymore (whether it is showing only the found set or all records). Only the grand total shows up. The subtotals for the subsummaries (groupe…

I have a form that has a drop down box with 7 different brands in it. I want to do a report that will give me a count of how many of each brand comes up in the forms from a specified date. Can someone out there help me.

I have a database that calculates team scores in a cross country running event. Main fields: Name, Team Name, Place, Points (calc), Points Total (summary). I can get a report that lists the team names and their Points Totals in order from highest to lowest (sorting by Team Name and Points Total). My problem... simple as it sounds.. how do I show the finishing position for each Team in the summary? eg 1 Team C 1234 2 Team A 1123 3 Team C 1012 ie how do I get the 1, 2, 3 etc to list?

Hi all, I'm importing an Excel file and need to create a summary of a field that is text and not a number. I'm guessing this is possible but I just can't figure it out. I can get a summary of a number in a field but not text. IE: if the text in the field is 'GBP' or 'Euro' I need the DB to count how many of each there is. Thanks in advance for any help. Killer Boo.

The user inserts a reference to a .jpg image file into a container on the pc platform. The "store compatible graphics" check box is checked. However, when another user opens it on a Mac, the image is not visable. Also, a OPEN URL script step will not open the file, although a correct file:// url has been pasted into the file path text field. Both viewing & opening works fine for other PC users. Any suggestions? thanks!!

Hi Everyone! PROBLEM: I have a database that has several duplicate names of equipment. GOAL: I would like to create a calculation field that tracks the number of duplicates in a FOUND SET. HISTORY: I've tried using: Count(Num of Equipment::Equipment Name) and this works, accept it gives me the Total duplicates in the ENTIRE database AND the wording is not exact. example: "Incubator" & "Incubator light" are included in the calculation above. I need to get the total number in the current found set using the "EXACT" spelling as is. Any suggestions!? Thanks!

I have 4 files: Donors, Donations, Orders, Letters I have a date on each of these: Donors - Creation date Donations - Date of Donation (Auto enter, creation date) Orders - Date of Order (Auto enter, creation date) Letters - Date of Letter (Auto enter, creation date) On the Donor file, I would like to create a field showing the date of the most recent donation, one showing the date of the most recent order, and one showing the date of the most recent letter. (I have all the relationships set up.) Then I would like to compare the 4 dates and if all of them are 2 years or older, I want to be able to archive them. Thanks so much for your help, …

In my database each client has several records. Each record has a calculation field named "TtlPaid". I have created a layout with a portal listing all the records for a particular client and the "TtlPaid" field for each record. I need to create a calculation field that will summarize all the "TtlPaid" fields. I have already created a summary calc field of "TtlPaid" with running total. The results I get are either a summary of a single record (if the field is placed in the Body of the layout) or a summary of all records in the database (if the field is placed in the footer.) My head is spinning! [color:"red"] Thanks to everyone who has replied to my pos…

To start I am a beginner. But what I need to do is make a database of scanned documents. Is there a way to scan documents, put them in a database and then (link or attach I'm not sure of the proper word) so that I can pull them all up when needed. This is a database for a medium size company that gets all types of documents in daily. It is very time consuming to go to the filing cabinet and many times different filing cabinets to find all the related documents. Does anyone have experience with this or can you suggest somewhere to look.

I am producing a summary report. In the report I have 8 columns which are: Name------constant-----Price-------Comm----Expense----net----deduct----total USA Motors---1------2000.00-------200.00---35.00-----1765.00----0------1765.00 USA Motors---1------1500.00-------150.00---35.00-----1715.00----0------1715.00 USA Motors---1------5000.00-------250.00---35.00-----4715.00----0------4715.00 ------------------------------------------------------------------------------- USA Motors---3------8500.00-------600.00---105.00---7795.00-5000=2295.00 ------------------------------------------------Summary Net-Deduct=Summary Total Deduct 5000.00 = Bought two vehicles …

I have a calculation I can not work out. I am designing a expenses and income database for a small non profit organisation. I have - Due Date: this is the date the invoice is due for payment. - Date Paid: Date the invoice is paid. - Amount Paid: Amount paid on the invoice. - Paid: This field shows "PAID" once the Date paid field is Valid, else "NOT PAID" - Status - Calculation that determines if the invoice for payment is "Over Due", "Due Today" or "Not Due" (I had help form this forum with this cal .... many thanks :-) ): Case(Due Date<Status(CurrentDate), "Overdue", Due Date = Status(CurrentDate), "Due Today", Due Date>Status(CurrentDate)…

hi all, I am new to multikey but I find that very helpful. I have 3 fields , field one is Name_One, field two is Name_two, field 3 is checking Record one : Name_One , Name_Two abc , abc abd, so when I check name_one and name_two, they must be equal right? because name_one is in list of name_two ...am I correct? One more small question ...if field 1, field 2 record 1 : abc , abc record 2: abc, aaa and so on ...bbb how can i make the cal so that the result is : abc aaa bbb I want it automatically not ....manually typing ... Thanks Anh Tran

Greetings I hope this is an easy questions. I've looked through the forums and didn't find what I was looking for - but I may have missed it. I also like you top know that I am fairly new to FP. I have created a database. In it are the URL's of clients. I would like to be able to click on the field that contains the 'WWW.xxxxxx.com' information relating to the clients unique URL and have it open the browser and go to the site. Any suggestions? Thanks

Hi, I am sytuggling to instert a picture in FM database. As a part of the database I am developing, I want user to choose picture file and it should reside in FM Database. Any help... Thanks in advance Aditya

I have a text field that contains one of four possible values: A, B, C, or D Based on those values, I would like to create a field that would assign a result of either Yes or No to those values. A value of A or D would return a result of No, a value of B or C would return a value of Yes. I think I need to calculate it using a Case Function, but I don't know how the formula/syntax should read. Thanks in advance for any help! I'm new to these caluculation functions.

I'm new to this filemaker and I would like some simple calculations on how to calculate fields. If anyone can help me with the script or ways to do this calculation I would be very greatful. Can I calculate Repeating fields? I have a field where I would like to do an if statement which contains Pass, Fail, N/A. I would like it to calculate all the Pass which each pass would represent 1. and I would like it to cacluation all the repeating fields. If the repeating fields have 10 then it should calculate all 10 Columns to verify which box has Pass. Thanks,

Hi all, Does anyone know of a way to add a set number of

I created a global filed and made it a container. I then placed the field on a layout and inserted an image into it. It works great until I quit Filemaker then it looses the image. What am I doing wrong?

Hi All, Does anyone know of any method that will enable setting the font size in a script - I believe there are plug-ins that will do this, but am trying to keep away from plug-ins. I am using the WordCount and then will set the font size accordingly. Many thanks, Benzie

I am trying to make a multi key from to dates. I have 3 drop down menus to select start date and 3 to select end date. I have a calculation field like this: TextToDate(Case(month_search="january", 1, month_search="February", 2, month_search="March", 3, month_search="April", 4, month_search="May", 5, month_search="June", 6, month_search="July", 7, month_search="August", 8, month_search="September", 9, month_search="October", 10, month_search="November", 11, month_search="December", 12)&"/"&day_search&"/"&year_search) & "" &TextToDate(Case(month_search="january", 1, month_search="February", 2, month_search="March", 3, month_search="Apr…

Hi Im new on here, I didnt know this forum existed. Its brilliant, If i knew it was here it wouyld have saved me so much time. Anyway, I wondered if any of you could help with this: I have 3 dates date1 = date new job recieved date2 = date job started date3 = date job finished I want to be able to perform a calculation that, finds the later date out of date1 and date2 then with that date find the number of WORKING days between that and date3. Im not bothered about bank holidays I just want the calculation to miss out Saturdays and Sundays. Any help will be much appreciated, Im quite new to filemaker and at the moment I keep getting asked to do t…

I have 4 fields. COMPUTER, DATE and TIME(checkboxes) are textfields. I have also one fields that I want to become a multikey field (calculation field). For example: If I chose COMPUTER=A1, DATE=2003-05-17 and TIME=08, 09 an 10 I want the multikey field to show this: A1 - 2003-05-17 - 08 A1 - 2003-05-17 - 09 A1 - 2003-05-17 - 10 How? Do I need more fields? How does the calculation field look like? Please help me!

I'm very new at working with filemaker and I am wanting to know if I must list all the fields from the other files into the main database file? For ex. my main database is where I have the grower information. My next file-called production- has different fields, I want to build a relationship between the 2 of these. But am wondering if I have to list all the fields from production file into the grower database, under the define fields!!??

What is the synthax to access elements of repeating fields other than the first in formulas? Do I understand corretly that field name alone of the repeating field returns the first element? How od I access the other ones? Thank you. -ilya

I want to limited the number of words in a text field to 100. Can this be done?

Wouldn't it be nice to get an internal coordinates (x, y) of a clicked pixel into a container field (in Browse Mode)?

I have a field with a purchase date and a field with a lease term in months. How can I make a field that adds the months [for example, the No 36 (3 yrs)] to the purchase date to ive me the lease end date? Thank you so much in advance

I am a beginner and have a simple application that has ten catagories that need to be ranked. How would I go about ranking these catagories from 1 to 10.

Hi - I need to show users how many days a job has been opened in our system, based simply on the "Date Opened" field. Can FM subtract the number of weekends, or do I have to have another file for it to refer to? THANKS!

As a novice I am constantly "taking apart" sample forms to see how they "did it". Of course the problem is that I can never get them back together and it seems like they are de-sembled for good. Is there a way to restore it back to what is was when I first opened it? There's gotta be a gutton somewhere. Jonathan

this problem involves: client db-each client= one record. job db- each job has one record. one client may have multiple jobs in a day or month. also, there is a calculated field that concantates the client's number with the date, for another solution. this field may come in handy... i want to have a field that auto fills/calculates the number of jobs worked for the current client in the current month. ie. we worked 4 jobs for mr jones in april, 3 in may, and 6 in june. if i'm looking at jones's jobs, i want this new field to say 4 if the job i'm looking at takes place in april, 8 if in may, and 6 if in june. ideally i would have 2 different …

Dear all, My database which I am developing for my school is growing and growing. Teachers are now seeing its potential and are asking if it can do more and more. My question is that I need to know if it possible to activate a layout only if a certain criteria is met within another layout. eg. If a child receives support from an ESL (English as a Second Language) teacher a checkbox would be selected by their teacher and information about their progress can be noted. I need to know if when that checkbox is selected can I generate another report which does not come up if the checkbox is unselected. (I am totally confused ~ lol) I hope I am clear about …

I was preparing my system for final beta testing today, when I discovered a problem with using calculation fields... I cleared all my working records for timecards, jobs, invoices, etc... They all have 0 records. Now these files have relationships based on calculation fields...BUT with NO records, the calculation fields don't exist. Some of them were as simple as =1 or =0. As soon as I add a record, the calulation fields exist, and the relationships work. Am I wrong to use calculation fields in the left side of relationships? or do I need to have a dummy entry in each file? Would this also hold true for globals, and what do you guys do in cases like this? …

Hi all, I have 2 globals dates field , field_1 and field_2 are 2 globals date field, I set field_1 = field_2 and field_1 changes as i use script setfield. I put field_1 in the header, but each time I open the file, the field_1 keep the old date, not the new date that I assign to field_2. Somebody have this problem before? Thanks Anh Tran

In Filemaker, I have date fields set as "leave Date formatted as entered" which gives me data of mm//dd/yyyy no matter what format I view it in Filemaker. However, recently, when I try to export and view in Excel, some of these dates are coming out as dd/mm/yy, so what is 06/21/2003 in filemaker appears as 21/06/20 in Excel. I've read several helpful posts on veryifying system formats on client machines accessing this from FM Server. What's weird is that I have checked this, and re-entered dates manually in correct format but they are still exporting incorrectly. They look normal in Filemaker even when I do a raw table view. Help!!

I am creating a donor database in which there will be repeating fields holding a donation date, a donation type, and a donation amount. Later I will need to create reports on what type of donation was given when and how much it was. How do I get these to "stick" to one another? Example: how do I get the information from the third repetition based on a find looking for a specific date? Is this even possible?

Can any one help me with way this is not working right ?? If(i_colour_set_text_contact = "White",GetRepetition(i_colour_left_tab_global,1) , GetRepetition(i_colour_center_tab_global,"")) Thanks Craig

It would be great to calculate the number from a Name. I came across this calculation from ISO Productions: Left( Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "1", 1), "1", 1) / 3) & Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "2", 1), "1", 1) / 3) & Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "3", 1), "1", 1) / 3) & Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "4", 1), "1", 1) / 3) & Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "5", 1), "1", 1) / 3) & Int(Position("qz---abcdefghijklmnoprstuvwxy", Middle(Name, "6", 1), "1", 1) / 3) & Int(Position("qz---abcd…

I am having a very strange issue with a text calculation, here is the scenario: 1. I have a text field that gets set with a script 2. I have two other fields that each grab a portion of that text field after it gets set. (I am emulating a multi-column layout on a page by splitting a field with two calculations) It is working well, with one exception: It removes the punctuation from the end of each calculated field! Pretty strange to me... Is there something I can do in my calculation that will preserve the punctuation at the end of the text? Or is there another way to do this that would preserve it. I am using "LeftWords(field,number) for the firs…

Hi, I hope I'm posting this to the right area. I'm developing a database for my new veterinary practice. Many of the visits will have .pdf files of scanned documents embedded in a container field. Is it wise of me to include the pdf in the database as a part of it, or have it there only as a link? I'm worried that after a couple of thousand pdfs, it will make the database very large. Or does Filemaker have some tricks in handling this and is this not a problem. Thank you all, Caroline

Forgive me if this is a simple question but I am brand new to File Maker Pro. How do I calculate either early, on-time or late, time (in hms) based on 4 fields. 2 are date fields labeled "Proof Due Date" and "Proof Delivered Date", the other 2 are time fields labeled "proof Due Time" and "Proof Delivered Time". The results in the calculation filed are based on the following: Int((Proof Delivered Date - Proof Due Date)/7) * 5 + (Proof Delivered Time - Proof Due Time) + If(DayofWeek(Proof Delivered Date) < DayofWeek(Proof Due Date), Min(5, DayofWeek(Proof Delivered Date) - 1) + Max(0, 6-DayofWeek(Proof Due Date)), If(DayofWeek(Proof Due Date) < 7, Mi…

I there any way to have FM calculate the length of a number field that will also count any leading zero digits? Examples of what I'd like results to look like: Number field data: 0012345 w/ length = 7 Number field data: 012345 w/ length = 6 What comes out instead: Number field data: 0012345 w/ length = 5 Number field data: 012345 w/ length = 5 I've tried Length(NumToText(number_field)) and various permutations but can't seem to do this. Even exporting the data to a text (comma delimited, e.g.) file didn't work, as FM stripped the zeros during the export. I suspect this can't be done, but thought I'd check w/ y'all before giving up. -Mik…

Hey all, This has got to be simple but I just can't figure it out. I've got a forecasting database that projects the total number of hours for the coming week. Basically I have a calculation that takes today's date and gives me the Monday of the next week. (My company forecasts from Monday - Sunday). So I can find the Week of Year for that Monday. I then want to find the Monday and Sunday of that week, the start and end date of that week. I was thinking this should work off the week number as this would take into consideration when the start of a new year starts in the middle of the week. Here is an example of what I'd like it to do: Today: …

I'm really new to this stuff. The way I learn is to read a thread and then create a temporary database to experiment on. Every now and then I create some defined fields that I would like to be able to lift off of one define fields dialog box and transfer to another one. Can anybody tell me how to copy specific fields (and calculations etc) from one database to another. Thanks in advance.

Hello Peoople! I am hopeing some one can help out....perhaps a script guru would see a short way out of this. I have 700+ records that need a serial number generated and updated accordingly. I have a field "SerialNo" defined as serial auto-enter and increment in format ABC0001 increment by 1. This works great for the new records created but I need this field to be updated for all the records each record would reflect: eg. record1 SerialNo:abc0001 record2 SerialNo:abc0002 ...... Any thoughts? Thank you for the help!

Case(Width="750" and thickness="2" and Type="COLD" and Site="OnSite" and NormalorOT="ot", "7") With the above NUMBER CAL. depending on the chosen values for the [Width], [thickness], [type], [site] and [normalorot] FIELDS it returns a NUMBER Value. BUT what i want to do is IF that NUMBER is OVER "2",{IN THIS CASE IT IS 7} then i want the amount >(greater) than "2" {5}to be input into another field. Can i have 2 x STRINGS within this CALCULATION Field?, or how do i go about having the amount over "2", to be input into another field?? IS IT A if(FIELD) OR : Any help would be appreciated. Regards Corey...

Hi, I was justing wondering where in FM Pro, do they keep some of there pics that they use in their templates, for example for the find, new, and delete buttons, for some of there templates, have little icon size pictures. I'm wondering if they have other pics as well, maybe a printer icon for a button to print reports and other little pictures I could use for other things like maybe edit or something. Or do I have to find my own and put them in my database. Thanks

Given a number... like 86 for example, I need a calculation field to work out what needs to be added to that number to make it divisible by 10. In the case of 86 it would be 4. I tried this... Truncate (TheNumber, -1) + 10 - TheNumber But that doesn't work if the number is already divisible by 10 (because it returns 10 when I want 0) Do I have to add in an if statement to check for this or am I missing something simple?

Dear all, My database has a field in it with the child's birthdate in it which is used to work out their chronolgical age. What I am after is a field which works out a child's age group according to their age. Here's the kicker............ If a child is (for example) 10 now or will turn 10 before 31/12/03 (s)he would be in the 10 yr old age group. It doesn't matter when they turn 10 (for example) they are in that age group the year they turn their age. Is there a way of creating a field which would do it and update it every year. Many thanx in advance Poida

I am having a hell of a time with global fields in multi-user mode! Just when I think I understand how they work... My custom authentication scheme relies on a global variable in each file (gUserId) to be set to the username from my custom login layout in the main menu file. I have a file whose only purpose is to store this global username and the current logged-in status. If someone tries to close this file, the entire system is closed. I have all files set to check this value using a constant 1=1 relationship upon opening and then re-sync the global userid. In my menu launcher, I had to explicitly put in Open("Filename") statements, because I needed to make s…

Hi, I was wondering what could be the difference from these 2 Case Statement structures. Is one more efficient that the other ? Why ? Case(Value = "A", "Result 1", Value = "B", "Result 2", Value = "C", "Result 3") Case(Value = "A", "Result 1", Case(Value = "B", "Result 2", "Result 3")) Just curious about it

I have a feature request to put into my solution. I know that I can set a field to be unique. But I have a situation where invoices are coming in in an inconsistant format. I have talked to the suppliers about this problem but there is nothing that they can do at the moment. The problem is a stock reference might come in, in two different formats. While both are similar when we enter the stock we have found duplications in stock references. is there any way to be able to find validate a field perhaps by 6 charachters within it, please note that these 6 charachters can be anywhere within it at the start of the string the middle or the end? EG one reference is j…

I am new to FM and any help is appreciated. I am importing csv data. One of the fields (CPT CODE) imported is a 5 digit medical code ie. 71010, 70450,70360 etc. I have a separate file with about 500 codes(PROCEDURE DESC) that describes the procedure for each code. The records contain the code and description as follows: "70450 Catscan of Head" "71010 Xray of chest" etc. When new records are imported, only the 5 digit code is entered into the (CPT Code) field. What I want is to have FM do a lookup of each 5 digit CPT Code and have it match the appropriate description for that code and enter the result into a field (PROCEDURE DESC). How do I do this? …