Calculation Engine (Define Fields)

I need help figuring out how to do individual student reports. For instance, a "judge" could want a report on a child. (this is a foster care db)..They may want to generate a report on only one youth.. so they would check: his/her current school, grade placement, credits earned to date, schools attended since the beginning of school year, educational needs. I have all these fields created by the way... I want to generate this report and have them either email or print (no problem on that part).. but what if i have a "judge" that does not want educational needs - so they don't check that box to have that in the report. This report needs to happen only for one youth at a ti…

Is there a way to create a value list that always shows the current date and the last 7 days? I need a short popup menu that users can select from to filter portal results for the current date and the past 7 days.

Hello. I want to make a scheduler in Filemaker. I have Filemaker 9. I work in a little office and we have to schedule appointments. What i would like is for example to write that Mr. Smith is coming next friday the 15th. And i want that on Thursday the 14th a pop up to appear reminding me about the appointments for that day and for the next day. How can i do that? thank you. If you need any extra details let me know.

I am trying to parse the last name out of a full name field. I am using Right(FullName; Length(FullName) - Position(FullName; " "; 1; 1)) It mostly works but here is my trouble. I have names such as John Smith John W. Smith John Smith-Jones John W. Smith-Jones I seem to be able to account for some of the combinations but not all of them. The calculation in the DB returns W. Smith-Jones So I tried making the " " to "." but that only works if there is a Middle initial and it leaves a space before the last name. Any help would be greatly appreciated. Cmack

This is a tricky one, at least for me, and not very easy to describe. I’m using FMP 9 server, linked to an Oracle database via ODBC and accessing the data via FMP 9 client. I haven’t had any problems interacting with most of the Oracle-derived tables once they’re in FMP, but one of the tables is giving me real difficulty. The table in question has three fields. One of the fields, called “column name” has a series of values which repeats every 4 records. A second field (column value) has the corresponding value for the “column name” in the same record. The remaining field repeats and only changes every 4 records. This is, of course, quite crazy and I need to fig…

I know you can create a field that shows the Modification date of a record. My question is, in FM 5 can you create a field that shows the modification date of a specific field. IF not does any other versions have this function. Thanks in advance.

Hi There, I am attempting to define a field so that it will not accept a value if it matches either of two other fields. I have tried to calc it in the field settings, I have also tried to insert it in the script that assists in creating new records. My attempt was (≠ "Field A" or "Field B"). The script at least puts up the error message, but it still accepts the value. I'm a little rusty, so if you can assist, please be specific. Thanks! Celie.

Very much a newbie, thanks for any help you might be able to give. I'm building DB in Filemaker 9 for a youth athletic league. 2000 kids, and I want to automatically determine what age division (7-8=pee wee, 9-10=bantam, 11-12=intermediate, 13-14=senior) they play in by referencing their dob and display it in their record. I designed another table with starting date, ending date, and division name, and tried to have the "division" field do a lookup to see which date range their dob fell into and return that division name to their division field in their record. Alas, I'm a moron, and this seemingly simple calculation evades me. Maybe a script would be easier? I fi…

Ok, so i have a time clock working great, i have the ip address connected to stations in the building so you can tell what station the employee clocked in at. Now i have map of all the stations and i want to display who clocked in where on the map. Ive am thinking portals, with some relationships will do the trick. What do u guys think? Thanks

After studying the forum discussions I have been unable to find a solution to my particular problem. Any help would be appreciated. My movie library database includes 678 QT movie trailers. The QT trailers were being presented in a Container field. I recently bought a new computer and after consolidating two hard drives, my QT trailers were moved and now FM no longer sees them and the container field is presenting me with a message stating: 'The file cannot be found:' I have begun relinking the container and the source files manually and I'm wondering if there is a better way to do this? The manuals do not offer a solution and after going through a c…

Does anyone know of an easy script that will toggle maximize and minimize? I would like User to be able to click a single button to maximize or miimize the window. For example, if window state is maximized then script would minimize and visa versa. Thank you all for your intrest and help!

Let me preface this with saying I am using FM9.0v3 on a brand new iMac 24". I started to create a solution to help me with my mortgage. After having created some fields I went into browse mode to test some of what I had already done. I immediately noticed a question mark (?) in some of the calculated fields even though I did not add a record. I then added data into my global fields to calculate the payment that would be used by records in the database. As soon as I did that I noticed values being displayed in the calculated fields even though I haven't added a record yet. I've been using FM for a whole bunch of years, albeit on PC'S, but don't recall ever …

I have a database where I need to navigate between layouts without the Status Area. A set of buttons do that nicely. Each button has the Navigation script attached, with the left word of the target layout name as ScriptParameter. I have two questions, one about sort order, the other about displaying the number of records in the current layout: 1.) Some of the layouts share one table, and are based on a filtered TO. I.e. the common table is called Designs. One set of layouts (Form and List views) are based on a TO occurrence that shows only records with Status=proposed, the other set of layouts is Status=approved. In order to filter out the non-relevant …

I'm trying to create a budget table that is related to a number of other tables representing purchases and payments. In the budget table one record represents one year with 12 individual fields representing the twelve months of the year. A corresponding calculation field representing a total amount for a given month derived from the related purchase and payment amount fields in the purchase and payment tables . I'm basically trying to bring the purchase and payment totals from a given month and bring it over into the corresponding budget table totals so it can be compared to a budget amount and then calculate the difference in another field. I tried the following cal…

I have about ten fields for delivery dates in FM. We have come up with a formula in Excel where if you enter the first date in the first cell, the remaining 9 cells will automatically fill in with correct dates etc. E.g. Field 2 would be Field 1 + 3 Days Field 3 would be Field 2 + 2 Days Field 4 would be Field 3 + 4 Days Is this possible in FM? Thanks, Sully

I'm sure this is an easy thing to do, but I can't figure it out on my own. When I set up a checkbox field, the box defaults to the left of the text. I want the box on the right of the text. How can this be accomplished? Thanks in advance.

I would like to make a script to copy the contents of the webviewer and automate dropping it into a container field. Can someone help me with this one,. Thanks

I am trying to get a calcuation to display in custom menu and I think I need to use the Get Summary function but I have never used it before. I have a field called "commission due" and a field called "Total commission Due" which is a summary field. I have set up a script to find any outstanding commission due based on a field called "Commission invoice number" being empty. this works fine. I am currently working on some custom menus for my database and would like the to total commission oustanding amount to display next to the menu. This is what I have in my head menu name "Commission Due " & GetSummary (Total commission due ; commission invoice n…

I swear it didn't used to be like this. I have a DB with an invoice table that when a customer ID is entered into the customer ID field, the customer's address and other data is looked up from the customer table. I've noticed recently, maybe after one of the 9.0 point releases that this lookup happens even when I duplicate a record. This didn't used to happen. I used to be able to modify the Invoice record to be whatever I wanted that wasn't in the customer table (maybe another name other than the standard purchaser) then later want another invoice just like it and I'd duplicate the invoice and all my customizations would copy. Now when I copy the Invoice…

Ok, the following seemed odd to me, but it may not be for you experienced users. I just started sharing my first solution with two users using Filemaker Pro 9.0. It seems that I cannot change the date in one of my global fields when two people are logged in to the solution. Every time I change the date in this field, then the date would revert to the previous entry when I logged off and logged back in. This pattern held true even when I made sure the changed record was committed by switching to another record. I also made certain that the other user was not changing back this particular date. Is this the way it is supposed to work? Or might the culprit be a cor…

I have a parent table, call it Orders that has related records in lineItems. LineItems contains records for many orders, related to Orders by order_ID. I want a calculated field in Orders that is a running total of all related records in lineItems. I don't know how to do this sort of filtered calculation. thnks

Don't know if this the right section to post so please forgive me if it is. I am currently reading data from SQL tables and inputting data back to SQL from my FM Frontend Database. I have come across perhaps a simple issue (maybe not) that i would like to achieve. In SQl, i have a table full of Vendors. In my FM Frontend, i am reading another SQL Table Full of Products for example. I also have three fields in here available to fill in Vendors information (Vendor; Vendor Address; Vendor Telephone). I would like to perform a lookup on the existing SQL Vendor Table to accomplish this (i.e if i lookup a Vendor Name from the existing SQL Table, it will fill…

I would like to create Customer folders on the users C drive based on what record the user is viewing. Thus a send event of: "cmd.exe /c MD C:Customers" & CustomerName I receive an error message at then end of the Customers line stating I need a closing quotation mark. The calc engine will accept this string if the last isnt there. Could someone help guide me with the correct string?

You'll have to forgive me because this is my first foray with FileMaker and I've been asked to create a database for a film library. I've tried searching for similar topics but unfortunately my total newness to FileMaker is preventing me from really even knowing what to look for. So this is the situation: I have a Categories field with 9 options, and I need help with my Call Number field, and adding serial numbers. I would like to assign each category to a prefix # and then auto generate a serial number suffix. For example, a video in Category A will have the prefix 1xxx, Category B 2xxx, etc. I want to have the prefix generated when I select a category, and …

I don't understand why it works only for the first repetition. Any hint would be greatly appreciated. Tnx.

I'm sure there is a very simple way to execute this bt I am just having a brain fart. I have a database that keeps customer records including credit cards. When I type in a CC number I would like to have a field automatically tell me what type of CC it is, for example if the number starts with 6 it is discover etc. etc. Can anyone help? As of right now I have some very convaluted calculation that works intermittently and is not really 100% accurate -) Thanks

Greetings I am in the process of adding final touches to my Scorecard: a system which marks and measures sales performance. Before Scorecard was implemented, we incentivised sales consultants based on sales targets hit AND margin made every month. With the addition of Scorecard, I now have to add a new criteria to the calculation which calculates the incentive value that a consultant has earned. The below statement works perfectly until I add a line (indicated here in red) which specifies that Scorecard points earned have to be higher than or equal to "First Scorecard Value" (in this case it is 60 points) If( GetAsNumber(StartDate) ≥ 73304…

I have a self-joined relationship: key_copyright = copyright holder so that I can filter records according to what shows in copyright holder field. In List view, i've created a drop down with a "show" button next to it to filter my records according to what's displaying in the drop down. Eg. selecting "public domain" from dropdown then clicking "show" shows all records that have public domain in the self-joined field. This works fine. I have a value list 1=values from copyright holder for the copyright holder field, and this works and updates pretty immediately. I have a calc field = evaluate(valuelistitems from valuelist 1 + "all copyright holders" + Publi…

The original programmer used a Number Field with a serial number, incremented by 1, to assign sales order numbers. Everything was working fine in version 5.0. but now in version 8, there are times where a sales number would be missing. I believe that the user is not "committing" the record to the database. However I'm not sure how that is happening. How can a user not commit a record? What can I do to make the user commit the record (therefore saving it to database!). Thanks in advance.

Is that any way to run any script using a calculation field. example if the field = Not paid script 'XXX' automaticly run.

Not sure if this is the right place to post . . . I have two tables, City and Clients. Clients table indicates language spoken by client. I want to add a field to City table called Spanish that provides a number count of clients per city that speak Spanish. Bascially searching for City=New York and Client Language=Spanish, etc.

On Mac, when we drag and drop an image from a web page into a container field in FM it puts it in there as Untitled.pct. I have a PHP script that pulls the image from the container field and FTP's it to our web server. The problem is it doesn't work for .pct files. If we actually save the file from the web site to the disk and then right click on the container and add (speaking of which, is there a script step that will allow me to just click on the container field to add an image?) then it works fine because it saves the image as the actual file format. On windows it works fine too because when you drag and drop it saves as .bmp which then works fine when I re…

Hi, i can't figure it out how to this: Part 1= Working ok Check Box Set has 6 options (.com, .net, .com.mx, net.mx) If i check .com in the domain kind: shows the provider, which is calculated by "case" formula. This part it's working good. Under this field (Provider) i have a field named "Domain Cost", if i select for example in the Check box ".com" the provider name = "GoDaddy", so depends on the privider has a cost. The cost's are in another table, the relations it's by the field "Exchange Rate" in both tables. So i'm using this formula to get the price depending on the typeof domain: Case (Domain Proveedor="GoDaddy";COSTOS::Precio Domain GoDaddy pesos;D…

I have two tables "COACHES" and "GAMES" In "COACHES" I have the following fields Name, Year_Start, Year_End In "GAMES" I have numerous fields including Game, Coach, Year_Season When I create a new record in "GAMES" I want the coach field to be calculated based on the season. In other words, lookup the name based on comparing the Year_Season with the Year_Start and Year_Finish fields. Hopefully I'll be able to pull a summary of games won and lost back into the "COACHES" table. Thanks in advance!

I have a db that has a logo container field. Each repetition has a customers logo and based on the customer name, the logo is picked up and put into a logo field. I can't seem to keep the logos in the main container. I copy and paste them in and they work on my machine, but when I go to another machine, they have disappeared. Any ideas?

I have a field where there are two values allowed: "Active" & "Canceled". How do I create a calculation field to count the number of records where the field = "Active". In programming I'd do something like: set record_count = 0 if ( $reg_type = "Active" ) then @ record_count++ endif How do you do it in FileMaker? Be gentle... I'm learning. M6

Hi there. Could someone help me with a 'simple' math problem (never my strung suit)... I want to determine the best way to express the ratio between two ever-changing values A & B. Sometimes A >B and sometimes A I'd like to work it so that the lesser of the two values is shown as "1" in the ratio, thus: A>B becomes A:1 A A=B becomes 1:1 Grateful for any help -)

Searched first but no luck ... I import a text field which is a concatenation of other fields. It is used as a primary key to incoming SQL data. The text key looks like this: 20070327_14:04:19_001133731A_1. This field must match us exactly because that's what ties us to the SQL source. I also import the fields which make up this key. They are (in order of their concatenation) CrDate: A creation timestamp field which I import into a timestamp field and, unformatted at layout level, displays as: 3/27/2007 02:04:19 PM PO_num: A purchase order number (number) Line_num: A PO lineitem number (number) I had to pull in some data without a primary key and…

Hi all, Hope someone can shed some light on this, it's being doing my mind in trying to work out how to approach it... I've built a full production tool for the business, job database, estimating, invoicing, all the normal bells and whistles. I've now got to the forcasting stage of the job, and am stumped how to begin. I've looked/viewed lots of calandars out there, but still seem a bit fuzzy. I've attached a PDF of the current forecasting tool the manager puts together in Excel to check when jobs are booked in for etc... I obviously have all the Job details etc... that I can link in. It's setting out the forcasting tool so it acts like a gant chart that's got m…

Greetings I am in the process of creating a subsummary report which specifically looks at our sales team's pipeline deals. While our sales consultants might quote clients on various options (all listed in one quote), it is imperative that we only take into account those items or options on the quote which we know are an almost guaranteed sale. Each quote has children which can be flagged as a pipeline item or not. I have then added these flagged items up to get a total per quote. In the sub-summary report, I then want to show a total per category (as we have various categories which range from "Good to Best") and then a total per Sales Consultant. I a…

Hi, how can i show Today's Date when i open my FM file without entering a new record, something like current date and time from the computer. Because i used Get ( CurrentDate )but if i changed the computer time two days after (feb 2nd), when i opened the file doesn0t change the date. Thanks Gian

Hi there. I'm completely new to FM, so I want to start off with a simple database of my clients and later build on this, to achieve a full business solution. The first challenge I have come across is how to get FM to generate unique client reference numbers using the first letter of the client name and a 3 digit serial, i.e. A001, A002, B001, B002 etc. I have been playing with the Auto-Enter calculation option and can get the first letter using the Left ( text ; numberOfCharacters ) calculation but I cant figure out what to use to complete the code. Could any of you point me in the direction of a solution. Cheers in advance.

Hello all, i have a Text-field which contains multiple lines of Text, for some reason, i often find records where the first line of the text-field contains nothing, i assume it is entered as a carriage return. Is there a simple way to strip this 1 extra carriage return from the beginning of the text-fields content? Thanks, Overrider

I have a number field with 20 repetitions. I need to have a display field for all repetitions that is based on a billing flag of "1". In my display calc I'm using is this: case(billing flag = 1, billed hours) It works for the first repetition but not the other 19. Any thoughts???

hi, I'm not sure how to best describe this, so if there is a thread with this question answered it isn't that I'm not too lazy to search. the problem is this. I have three tables: people, invites, and events. each event and each person have a unique key that are related to each invite entry. invites can only have one person and one event - but each person and event can have many invites. the invite table is essentially glue between the other two. I have a field in events that gets a sum of all the people who have reserved a spot in the invites table. in the invites table I also have a field (which I set up with some help from here) that has three valu…

I'm sure there is a really good reason why sub-summary fields only work in preview mode but I need that functionality in browse mode so that I can manipulate the data and easily see the record I choose in form mode. It will be a working list. I have many businesses and would like to list them by category and then alphabetically. In preview mode I can not only do this but also have a heading before a group of advertisers listing what category they are in and a count field that tells me how many businesses are in that category. Perfect! In browse mode I can also organize the list by grouping the businesses by category simply by sorting by the category field first,…

I have a support database hosted on our filemaker server (8.0.3) which has container fields for adding file or picture attachments. Under my administrator 'full access' account I can add and export field contents of these container fields. My restricted access 'Users' group cannot access these fields. When they right click they do not even get the menu of options?! The access privileges for the 'Users' group is set to modifiable for these fields. Is there anything else I'm missing? Thanks for your help

I have a set of calcs & variables that are confounding me. I have a report that creates a new set of page numbers when sorted by the field "Type". I would like to have a header at the top of each page that shows page 1 of say 20 for "Type"=A, page 1 of 13 for "Type"=B, etc. Do I use variables in my print script to set the Total Number of Pages by Type? Do I create some loops in my Print script to print each "Type" seperately? Any ideas? :)

HI all I am trying to write a summary of my company welding procedures but I hit a snag. The criteria is as follows: 3/4" to less than 1 1/2" and 2t when t< 3/4" 3/4" to less than 1 1/2" and 2T when t> 3/4" What I need to find is a calculation that would give the range beginning with 3/4" up to 1 1/2". I tried the following Case( thickness =.750 or thickness <= 1.5 and weld < .750,2*thickness; thickness = .750 or thickness <= 1.5 and weld > .750, 2* metalthickness) little t is the weld metal deposit thickness Larger T is the metal thickness. At first glance that seems to work but further investigation prove …

If you add more text than will fit in a field it is hidden unless you click in that field. I was wondering if there is anyway to determine if a text field has too much text to be visible. If so I could add a calc field that says "click me to view more" so the field then shows all the text. I know can put a scroll bar on side.

Does anyone know how I might be able to get a count of the number of sub-summaries in a report? Fox example if I have a list of 100 records that are grouped into 20 different sub-summaries, I need to be able to extract the number 20. Thanks!

Hello everyone...I have a budget database with a bud_acct table and an expense table. I have a field org_bud_amt (expense table) that is a lookup. I also created a summary report that is summarized by fiscal year, department and budget account. The totals on the report are correct but I am trying to summarize only the unique values from the original budget amount field instead of each occurrence. Any help is appreciated.

I need to be able to take a found set of records that have a date field and a number field. From this, I need to create from the number field a "three-week" average field of the number field. The calculation I would have to take the current date and go back three weeks to average out the number. Anyone have any ideas?

hi, I'm a few weeks into FM9 and I have a background as a PHP/MySQL developer and I'm finding the code a bit odd. what I want to do in this context is have a field with three possible outcomes - if it is null one string, 0 another string, and anything >= 1 a final string. the code I'm (unsuccessfully) using is below. right now the only condition that doesn't work is 'Pending'. thanks for any advice/help! ~~~ Case ( AttendNUM = 0 ; "Decline" ; AttendNUM ≥ 1 ; "Accept" ; "Pending")

Hi, is there anyway by calculation to assign in a field "REGISTRATION No" the first two letters from the field "Name" + 3rd and 4th letter from the field "Last Name" + last 2 digits from the field "dathe of birth" ?? THANKS GIAN

Hello, I am wondering if someone can help me out with this. first, i am running FM. 6. What i am trying to do is figure a away to find past due day of student who has no made any payment. i have two DB, one is call Students and the other Ledger. In the Students DB, I create a portal which input the data to Ledgers. So i need to figure out how many days has past since someone made a payment. Here are the fields i have created in the Ledgers DB. Posted Date, Charges, Amount, Category. i am wondering if the issue has to do that we use the posted date field for both the charges and Amount. There is a relationship on both DB base on studendID field. any hel…

If (Created < 1/1/2008 ; Work Days in Month * 5 ; "" ); Greetings I am going around in circles and feel like a puppy chasing her tail. . . Our sales consultants had to do 5 CRM calls per day. As of 21/01/2008, the MD upped that total to 10 CRM per day. We are tracking each sales consultant's progress with the aid of a ScoreCard. However, I now have to take into account that the "total required CRM to date" up until 21/01/2008 was "No. of work days past x 5". Thereafter, the calculation changes to ("No. of work days past x 10") + 65 (which is the number of CRM that was to be achieved up until that date). I will admit I am stuck. I have the logic in…

The attached file is Edoshin’s crosstab demo that I have modified to suit my needs as follows: I have added a Parent table (Category) with 2 fields: Category Name, Amount (Calc Repeat field with 12 reps) and linked it to Expenses by category I set Amount = to Sum( ) of Expenses::Month field (which is a repeat field) with the hope that repet1 in parent would store the total of repet1 in child, repet2 in parent store the total of repet2 in child etc.... The results are telling me that I am doing something wrong. Could someone please take a look a the file an tell me how to store in each repetition in parent the sum of the equivalent repetition number from chil…

Working in FMP 9 adv: Attempting to set up Networking for Multiple users in same file. I have set up a layout for the admin to take a look at the settings at a quick glance using many of the "GET" parameters. (user count, system, protocol...etc) My next task was to let the admin see WHO was connected to this file. Calling the Get(AccountName) works on the individual machine, but I was hoping to figure out a way so grab all the machines account names and list in one field. Again, this is to show 'who is on', not a list of privileges and possible account names. Thought?

I want to share a database using fmnet, and allow the user to insert a reference to a jpeg image stored on the server, using the "insert picture" command. How can I format the image reference to make this work? I've tried the local version image:path/filename.jpg and the full version image:/HD/path/filename.jpg both work on the local machine, but when I log in remotely they fail. Many thanks!

:) I know it's Friday and you want to go home: I'm new to this Forum, but have used FM a little in the past. I have three problems I am try to solve: 1. I designed FM on my pc linking image containers using a text field, then added a calculation to link the path using; "imagewin:/"& $$id &"/"& Image_ID &".jpg". (image_Id is the text field). I also set up a global script path for each $$ folder 'id', 'logo', etc. Finished the beta version which works fine when I import new records, add or amend an exiting record. I have also used to same technique to report the 'image' file name when inserted through the container. I then moved the r…

Is there a way to calculate with iteration like in Excel? I have an excel spreadsheet that I would like to convert to FIlemaker Pro, but it contains a circular reference: Total= subtotal + (x% * Total). In excel this is a circular reference, but can be done by changing the calculation preferences to iterate a max of 100 times with 0.001 max change. Thanks

I'm having a tough time figuring this one out. I have a table with three fields; two global calculated fields and one regular text. The table has only one record. The calculated fields are simply the literal strings "Yes" and "No". The regular field is only there to give the table one record. I should also mention that the file is hosted by Filemaker Server. When I connect remotely to the open file I expect to see the value that I entered into the regular text field along with the values of "Yes" and "No" in the globals. The value in the regular field is present but the globals don't populate. However if I create a new record the globals populate immed…

Hey gang: I currently have a database that I'm working on. I'm looking to be able to enter the creation date for a record and then use the current date to get the number of days that have elapsed since the record was entered. example date created 01/23/08 current date 01/24/08 leaves a field which shows 1 day. Any help is greatly appreciated. Thank you

Well I've never noticed this before ... Maybe it's because I've been working in SQL and they use UPPER quite a bit (for their functions) but I've started doing it in FM as well. I thought it was kinda cool because they stood out from regular text easily. So I started typing my calcs like: Case ( thisField = "this" OR thisField = "that" I began to capitalize OR. And AND. But FileMaker changes them back to all small letters! It is a small thing ... or should I say a 'lower' thing but it struck me as peculiar. It should work either way. Is FileMaker being fussy? If so, they've been around me too much. Please tell me it happens for othe…

I am at a lost on how to take the row number that is displayed for interface purposes and use this number in a calculation. Somehow I need to create a field that first holds that row number. Any help or ideas would greatly be appreciated. Thanks, -Shari

I am re-writing a jewelry wholesale database solution, and need a replacement for Troi Grabber. Basically, I need to be able to take a photo with an attached camera and place it into a field, from within Filemaker. I would also like the same ability for a flatbed scanner. Press a button, scan into a container.

Clients in my business pay at the end of service, thus for most of time they are active, their account should show zero payments. How can I get a calc field to display zero when there are no entries for the fields that are being calculated, in this case payments? I see in the "format number" area about zeros, but this seems to have no effect. Thanks all.

I have a couple of solutions where the users are linking pdf via a container field, they are supposed to be linking not embedding. However, one file has grown to the 2 gig size - there are only 18K records in the database, only one container field per record and only approx 4000 records should have a linked pdf. Is it possible that file size would bloat to 2 gig if users are only LINKING pdfs? UPDATE: We have removed an embedded pdf that is 41KB in size and have seen a 3MB size decrease in the actual FMP file. Linked documents seem to be taking 17KB of space (seen by file size increase after linking) Any thoughts on this??? Has anyone seen this before. I can't…

I am having a problem finding the correct way to calculate a simple average. Here is my situation... I have a report that has a Sub-summary break on Year and a Sub-Summary break on Month. I am able to correctly show by month and year the following data: New Sales Units Used Sales Units Total Units % new % used What I can not seem to do is get the average New Sales Units or Average Used Sales Units if the report is run for multiple years of data (2006, 2007, 2008). Report is sorted by Year of Sale and Month of Sale. Example: Year 2006 has 6 months of data If new sales =72 then average monthly new sales should be 72/6=12 I could n…

Looking for the best way to make sure that the user is pasting an image as a jpg, and not some other format. Was looking at creating a validation calculation and parsing out GetAsText (YourContainerField), but was seeing if there was an easier solution.

Hi all Can anyone help me out on this one: A danish social security numbers first 6 digits are a short version of a persons birthday (Ex: 060768 = 6. of June, 1968) Can anyone help me with a calculation (or does it have to be a lookup??) that change the digits into a date and year? i.e 06-07-1968 Regards Lasse

Hi, I am trying to emulate a till and be able to produce a report that shows the complete breakdown for a days activity. Any time something gets purchased or a service gets done an entry gets put in the line items table and the type field gets updated with either Product or service. I want to show how many products and services we sold and what was the price for each. I have created a how many products calc field with a case function "Case ( Product Type = "Product";1 )" and then have a summary show the total, which works. The next step is to show how much was taken for products. Can anybody help. Thanking you all in advance, Best Roy

I have 3 container fields per database record, each holding photographs of the item in the record. Is there a way to show one [1] field on the layout that will automatically cycle through the three [3] photos?

Greetings I have generated a sub-summary report which looks at each employees sales per month. I want to be able to calculate the percentage increase or decrease in sales from month to month, and from year to year. This is easily achieved in Excel. How would one perform this calculation in FM?

I have two fields in same table: field1 and field2. Field1 has auto enter calculation: if(mark_field2="field1", field2, if(mark_field1="field3", field3, "")) Field 2 has auto enter calculation: if(mark_field1="field2", field1, if(mark_field2="field3", field3, "")) In browse mode, when I set mark_field1 to "field2" and mark_field2 to "field3", then enter something into field 3, both field1 and field2 autoenter as field3. When I set mark_field1 to "field3" and mark_field2 to "field1", then enter something into field 3, only field1 autoenters as field3 and field2 remains empty. Why the different behavior? Someone tells me this may have to do with the creati…

What's the best approach to this problem: I want to make the following summary, updated whenever a new order has been made: Sales Guy 1: total order net today / total order net this month Sales Guy 2: Total order net today / total order net this month etc etc The table i collect the information from contains sales guy name, order net total, and date. What is the best approach here?

Hi all, sorry about this but I am still new to using Filemaker, basically I have a table and in that table I have a column which is populated with a series of codes, some of these codes are the same, and what I need to do is calculate how many of each code there are and display these results as a figure on the page. could anybody help point me in the right direction for doing this?? many thanks

Hi I have a table named "Information" I have another table named "Quote" I would like to bring in a random quote from the other table (Quote) into a field called "today" in the table "INformation" I am always adding to the quotes so the number of records changes. I would like to make a script to do this. The problem is how to get this random from an unrelated table into the original table. Just trying to find the best way to do this. Thanks dave

Hi everyone, hope someone can help. currently i got 3 tables: 1. Bills: have the expenses, field: partnumber. 2. JobXactions. job hours, (also has partnumber) 3.Customers i got the relationships: bills::Partnumber -- Jobxactions::partnumber. my problem is when i try to create a report and join the results of both tables, my summary of one of the tables does not appear, what i want is, order by customer: partnumber totalexpenses totalhours but only appears the summary of the totalexpenses or the summary of totalhours, but i cant figure out how to have both in the sub-summary.

In FM6, I have a database file that has two global variables. I set these two to 1 when two different types of invoices are printed. Later when a user wants to move to next billing period, the script checks to make sure that the invoices are printed (checks if these two globals are set to 1) and then moves to the next billing period and sets the two globals to 1. However, when the user prints the invoices on one day and then tries to move to next billing period on the next day, the script finds that invoice has not been printed (since the global values are lost). Is there any workaround to retain the global value like copy this value to another database when the file…

Not sure if this is the right place to post this but..... I have a "yearly summary report" in which I would like to have an average of averages. Each month I have a rounded stat. I created in my yearly report a summar field which is a year average of those monthly averages (if that makes sense). Here's the problem...how do I round that number? I don't see any way to create a rounding equation for a summary field. Thanks for your help

I'm trying to make a calculation for a field, Head of Household Work Phone. I want it be that If it is empty, as in there is no work phone, then it will display the message "None". I'm close, but can't quite get it right. But also, I want it more complex. I have a Spouse Work Phone field as well. I want that to do the same. However, some obviously do not have a spouse. So I would like to make that conditional upon the Spouse First Name field being filled. Because obviously if it is empty, there is no spouse and I don't need the message "None" in work phone Thanks for your help finishing these off.

Greetings Me a.g.a.i.n! I need to identify the incentive value for sales consultants but each test has three parameters - a date range, sales total and GP percentage total. I have tried to do an "and" to bind these three tests as one but the calculation fails! Any help would be greatly appreciated! Mucho gracias in advance! The code is as follows: Case ( // for incentives paid between August and October on Silver Price List // for targets of 550000 at 14 15 16 Start Date ≥ 1/8/2007 and End Date ≤ 31/10/2007 and Nett Sales Less Support ≥ 550000 and Nett Sales Less Support < 750000 and Total GP Sales Percentage ≥ 14 …

I would like to conditionally fill a dropdown field from two different value lists based on a selection in another field. The first selection would be between a family member or "other type" who attended a meeting. The list would then be filled with either a list of related family members or other possible participants. Anyone done this before? Thank you.

I have a layout that uses three checkboxes in response to a request to rate a text statement. I need a way to allow the user to check only one box. The two attachments provide a picture of what I am talking about. The fields to the left of the check boxes are individual fields, each using it's own value list containing one "Custom Value" (i.e. "Positive," "Negative," or "Undecided" that displays in the field when the checkbox to the left is checked. As you see, I instruct the user to "choose one", but realize that the instruction will likely be insufficient to protect the data base from unintended errors. I need a script or calculation (or something) t…

Is it true that the evaluate function does not work inside a custom function?

I KNOW this is a simple thing, but I need help with it. I want to round a calculation to the nearest nickle(.05). All of the functions I have tried are based on the number of decimal places returned or on rounding to an integer. I feel as if this is so basic, there must be a function I have missed or need a new brand of coffee.

I have a separate table in my system containing 5 variables. Invoice number, cash order number, packing slip number etc. This number is retrieved via the set field function, and the new incremented number is set (back) via set field; invoice number = invoice number + 1 etc etc. However, I've noticed now that for some reason, these 5 variables has recently been reset back a day, ie, i've suddenly ran into duplicate invoice numbers. I've found no fault in my code, and it works perfectly when trying it over and over again. Can some client accidently set these variables back? Lets say you don't use a client for a couple of hours, then suddenly something happens…

Hello In a new record calculation where the field is empty and filemaker does a calculation during the making of the new record, I would like it to place the Random of something from a value list named "Streets" So in the value list it has this as an example AVE ST BLVD CIRCLE WAY LANE ROAD I would like the calculation to enter a random from that value list if that is a possibility. Thanks

ok this seems easy - but can't figure it out... I have a button with a script set up to email - what i want is when the user clicks on the button - to have another field enter in the date of when that person clicked on the button.. so we know immediately when the email was sent.. seems easy... can't figure it out! argh. :

Hopefully this has an easy answer. I would like to make the wrong answer show up in Red. I have 2 fields Answer1 which has the student's answer in it. The answer is a letter (A-E) The second field CorrAns has a Y or and N indicating if the answer1 is correct or not. So if CorrAns = "N" I want Answer1 to be colored red otherwise it will be the default text color for the field. Hopefully I made this clear. I am not sure if I use case or if for the calculation and not sure how to complete it. Thank you for your time. CMACK

Greetings I am trying to format the text colour in the following function so that "1st Target" = Orange, "2nd Target" = Blue, "3rd Target" = Purple and "No Target" = Red. Case ( Nett Sales Less Support ≥ 550000 and Nett Sales Less Support < 750000 ; "1st Target"; Nett Sales Less Support ≥ 750000 and Nett Sales Less Support < 1000000 ; "2nd Target" ; Nett Sales Less Support ≥ 1000000 ; "3rd Target" ; "No Target Hit" ) Please could someone help me!

I know this is a basic calculation, but I am brain dead today... Is there a way to have a field count the current records. If you have 10 records in a layout, the field says "10" like on the sidebar, but in a field... Thanks

I am creating a catalog of sorts with data from Filemaker in conjunction with a container field that points to an image on a local network drive. The container is based on a calculation that points to a field (INV IMAGE NAME) that holds the actual filename of the picture. "imagemac:/Pics/" & INV IMAGE NAME I don't have pictures for all of the items. If there is no picture, Filemaker displays "The file cannot be found". I would like to figure out a way to have some alternate text there, possibly "No Image", or perhaps, a stock photo. Can I do this via a calculation with IF statements? I am kind of a novice in that regard. Thanks

Ok, I have 2 "modules" or databases. Linked. If Tommy is a member (Members DB). He is involved in an investigation (Investigations DB2). I have him listed in Investigations if he is a member. Now...I have 2 fields, one in each db. Case Number in members, and members in Investigations. They both are check boxes. If you check "Tommy's" box in Investigations, I want it to "automatically check the box in case numbers to this case." I hope I get this across.... If you check a box in one, then it will check it in another db automatically... Thanks.. This has me bugged;)

I have x2 tables Table A (Parent) and Table B (Children) with a relationship that uses a Constant field (=1)in Table A. I want to be able to set up a validation on a Boolean field (1/0)"Valid" in Table A so that if changed - either to 1 or 0 - it checks for existing child records and displays a message to the user if records exist (e.g. Valid = 1 in Table B ) In the file supplied I've used the Count function but this doesn't seem to work. Any advice? Validation.zip

Hello, If I do this in a calculation field with 12 repetitions: GetNthRecord ( Extend( Analysis::Month Total ) ; 13 - Get ( CalculationRepetitionNumber ) ) it works. I get my 12 repetitions with values. As soon as I add any logic to the calculation as here: Case ( Source = "West" ; GetNthRecord ( Extend( Analysis::Month Total ) ; 13 - Get ( CalculationRepetitionNumber ) ) ) only the first repetition has a value in it. Is there any way round this? Thanks for any help possible, Norman

Hello, Is is possible to populate a repeating calculation field with either the List function or getNthrecord function?

I need to develop a report on a database based on several fields. Program field has six options (A – F), Grade field has 12 options (1 – 12), Hours is a number field, and there is basic demographic data – name, etc. Individual records are based on Name. What I need to end up with is a table with Program in the first column and Grades 1 – 12 as headings for rows 2 – 13. In each “cell” I need to determine the Count of students (based on Name) and Sum of Hours for each matching category, e.g. Where Program = A and Grade = 1: Count of students and Sum of Hours, Where Program = A and Grade = 2: Count of students and Sum of Hours…..through Where Program = F and Grade = 12: Co…