Calculation Engine (Define Fields)

I am trying to layout that would display information from selected record only. Is there a way to do this if the records information is not related?

Hi All I am at this time able to do want I need by using a script to preform this task but would like to do it with a calcualtion field which I have not been to successful doing and need help . A welder is required to weld every six month with the welding processes that he was qualified for. So each welder will have a least two records per welding process for each year that he worked for us. I would like to insert in the old record the word "Update" in a field called update when a new continuity record is created. So in the newest record the field update would be empty for each welding process. Example Welder one has 4 records for the FCAW welding process, the…

Hi I try to make a calulation on my record to show the input data is been key in on "Day Shift" or "Night Shift" Our Day Shift start on 0800hrs to 2000hrs and Night Shift start on 2000hrs to 0700hrs. I set my calculation as Case(08:0020:00 ; Day Shift : 20:0008:00 ; Night Shift) But not working How should i do it, Can anyone help. Thanks Thanks gregory

Hello, Is there a way to have a field automatically timestamp itself when another field in the same table is modified? Something like: Field1 <- user modifies the value in this field Field1ModDate <- automatically stamps itself to track when Field1 was last updated. Thanks

I have a container field that allows users to paste anything from clipboard. Is there a way to know the type of file pasted into the container filed? Text, Picture, Movie, sound or a file? The reason I ask is that I want to export the file into a folder. I need to know the type of file so that I can add extension to the filename.

I don't know if this is a calculations or function related question or what. I have a portal that allows me to create line items of services ordered by a client. I would like to have a popup menu that allows selection of a service type (lodging, transport, etc) then a second popup that is filtered by the first type menu. So for example if I selected "Lodging" from the first menu then the second menu would only contain lodging options. thanks for any help or advice GF

Hi, I'm having some problems with a Membership database that I'm trying to create. The table includes a Date field, with a "Days Attended" input field. I need to be able to save this information each week for any selected member and for that information to be stored for later retrieval. Secondly, I have a "From" Date feild and a "To" Date field. I need the table to be able to calculate the "Days Attended" from my selection of the Date in the "From" and "To" fields. This action needs to be spanned across multiple records. How would I go about doing this? Thanks, Sam.

Dear All, Cf. my attached file. I am trying to do something who seems quiet simple: I have a field called Total. I would like that when: 1/ Input a number in the field Add to Quantity it do the addition of this number into the Total Quantity field. 2/ Input a number in the field Remove of Quantity it subtract this number into the Total Quantity field. How could i do this ? Thanks a lot for your help ! Cheers

I have a cabinet shop. We build our cabinets in millimeters but need to communicate in inches & fractions. A lot of times a customer wants to know if a particular pot will fit inside a drawer box. I would like to develop a solution that answers this question. I need to be able to start with a drawer face dimension in millimeters, subtract drawer bottom thickness and inform the customer how much useable height they have in inches & fractions. I am using the following formula in my calculation: Let ( [ fraction = Mod ( decimal ; 1 ) ; sixteenths = Round ( fraction * 16 ; 0 ) ] ; Case ( Int ( decimal ) ; Int ( decimal) ) & …

I am creating a database for a personal training business. I have a "Trainer Worksheet" table. The records for that table look something like this: Contract# Total Sessions Rate Per Session A1(field) B1 (field) C1 (field) A2(field) B2 (field) C2 (field) The "Trainer Worksheet" table is related to a "Contracts" table through a "Trainers Code" field. When the Trainers Code is entered into the "Trainers Worksheet" record, a value list is created in A1 with a list of contracts that are assigned to that trainer (via Trainer Code). What I need to have happen is that when a con…

Hi there, I need some general advice of how to set up a sorted list in Filemaker 1. I have a list of hotel names that has to be sorted by certain criteria (for example ommit certain prepositions like "The" as in "The Berlin Hotel") 2. These criterias should be configurable and overrideable. 3. Output in a sort_field that is used in another application to create the desired order. OR Have the whole list sorted by hand, but still I would ask what kind of field to use and what numbering conventions... Maybe you can lead me in the right direction... Thank you for your help Cheers Lars

Hi everybody i am having serious trouble. I have a total cost field that i am trying to have round up or down to the nearest .05 Round ( (Cost + Sales Tax) ; .05 ) i have tried that but it almost always gives me a whole amount EX. $4.47 = $4.00 What i would like is for $4.47 to equal $4.45 so please any help would be greatly appreciated

I am writing a estimating table and want to have an option to round "up" the total to the nearest dollar, ten dollars, hundred dollars etc. The problem is the round function rounds up or down depending on the cutoff, not always up. I know about the "ceiling" and "floor" functions but need to round 'Up' past the decimal point.I don't want the total to be $12,400 where the round function will make it $12,000. I want to go up to $13,000. Has anyone solved this before? Thanks in advance.

Hi, What I'm looking for help this time around is how to generate a report showing the clients that have not been to for a while. I have a seperate table in my database for this and in it are, PtId (a lookup value from another table), CurrentDate (Auto enter calculation) LastVisit (a lookup value from a another table (which is displayed within my database within a portal) I guess the way I'd like it to work is that when the button is pressed a script is called into action that will get todays date, look at the last visit dates and return the result of all the records that fall within that criteria in the form of a report.

Hello, I'm an artist, and would ask your patience with me in regard to programming....I am attempting to use what I thought would be a simple If, IfElse statement, but I keep getting an error message "The specified field can not be found'. The fields do indeed exist, and I have tried every permutation of quotation marks and brackets, as well as in text and calculation formats for the field in question...I want the field I'm programming to look at another field, "Calculation Field 1", and if it is filled with the word 'Five" to input text from another field, "Printer 1". If "Printer 1" is empty, then I want it to fill in anything in the field "empty". I think this is …

Hi all, I searched around but couldn't really find a calculation that helped. I have a database for membership to a shooting range. There are three date fields I need to work with, (date_first_joined, date_renewed, date_membership_expired). when a new record is created the expiration date needs to be the date joined +365 days, simple. when i enter a date into the date renewed field, I need the expiration date to look at that date and calculate a year past the date renewed and add the remaining days in the year to it to give me a new expiration date. Been trying for a while but just cant get it. Thank you in advance for the help.....

Im about a 4 day old user. Im trying to create an entry form using a "Job Number" and basic info abou that job. The next form I created is about defects of that specific job by using a drop down and finding that Specific "Job Number" and having some of the basic fields auto compiled from the basic job info page for example Size of job and date completed. I cant get the Job size field to pull the info from the related Job entry page and be able to change the job id and get it to post the job size based on the "Job Number" I specify in the drop down box. So info from Page one I need to show on page two when I select the "Job Number" from the drop down of previous…

I have a field that has some non english characters in some of the records, eg: V�stervik Café StraÌ°åÄe Månzfa Sérgio ZÌ’rich Fürstenfeld What I need to do is if the record has a non-english character in it to do a calculation that finds all those records, so I can manually replace the non english "é", with "e". My original idea was to make a list of all the non english characters and do a pattern match but there are too many non english characters and no real way to know them all. Does anyone know how to do a pattern match or some other way to find all the non english character in this field? Thanks for your help

Hallo all! I have 13 tables with different dates and i will have a last one table some checks up the last date of the 13 tables plz help! like: 2010-12-12 2015-10-10 2011-02-05 2012-05-05 2009-01-01 2013-04-09 Last date: 2009-01-01

Hello I have a layout that have 75 fields. The client should only fill in one of 75 fields per record. I have read all I can but I am a real neophyte. I am unable to find a way to select all the fields that should be grouped in the layout and have an error message come up if more than one of the fields is filled in. I am sure it is something obvious but I just can't see it. Many thanks

Hey everyone. Seeking help on the below. I have an summary field of 'amount' field. Works fine. Now my boss wants additional summary field that shows total of only the records in found set that have "NO" in a particular field (in this case - 'client paid'). I have no idea. I was thinking of having it first do a search on the found set, along with the NO, then put then summary amount in the field as a global, then do the regular search without the NO. Any advice would be greatly appreciated. Thanks!! -adam the new guy

Hi, I have 3 calculation field called a, b and c. Is it possible to set, for example, the b field to '2' and the c field to '3' IF the a field worth '1' ? I'd like to do it without a script. Thx

If I am importing jpeg images, how would I do to import them without the extension type(for example .jpeg)

On My "Sales Order" layout I decided to put the number of orders that had not been printed so that the people who were taking orders remembered to print them. I did this by creating a new TO based on the "Sales Orders" Table called "Pending Orders" joined by a universal (X) Relationship. I then have two fields PrintStatus = If ( IsEmpty ( SalesOrders PrintLog::Sales Order ID); "Not Printed"; "") // sets the print status to "Not Printed" if there are no entries for that order in the print log and CountNotPrinted = Count(Pending Orders::Print Status) This works fine except the database performance has taken a big hit. I tried to make CountNotPrinted a global fie…

Hello, I need help with what would appear to be a basic calculation, but it's not working and I haven't been able to determine why not. My calculation is written as follows: TimeElapsed = Table1::TimeEnded - Table1::TimeBegin with the result a Time. TimeBegin is auto-entered; TimeEnded is a scripted button entry. Both entry fields have good data, properly formatted. I want the result to appear as a time and formatted: hh:mm:ss Problem: The result field is blank. Can an amount of time be calculated this way? Or is it more involved? Thanks

Hello, In my database I have four fields; FW, PW and PD, displaying different width measurements, and Result, displaying a value depending on a calculation of FW, PW and PD. The following alternatives should determine the value in Result: If FW≤1/3PW, Result = A If 1/3FW≤PW≤2/3FW, Result = B If 1/3FW≤PW≤2/3FW; PD>1/2PB, Result = C If PW≥2/3FW, Result = D If PW≥2/3FW;PD>1/2PB, Result = E Any suggestions of how I formulate this in a calculation?

Hello, Is there a way to either validate a field or write a script that removes spaces in FM7? I know the TrimAll feature would normally do this but it doesn't seem to be available in FM7. Is there a way to do this? Thanks.

I am creating a database for a Landscape contractor business. ( my brother's ) I have Job table with a "date_start_job" field, a "date_end_job" field, and also a "duration_job" calculation field which is ( "date_start_job" - "date_end_job" ) . There is also a number field called "estimate_duration_job". What I want to do is have a message appear that shows all jobs which are overdue. Overdue jobs are jobs where the "date_end job" is bigger than the ("date_start_job" + "estimate_duration_job") but also where the current date is bigger than ("date_start_job" + "estimate_duration_job") I created the following calc. but unfortunately it doesn…

Hi all I am having a problem having the max function work with a sql table in filemaker. I have the Sql table in filemaker and i created an extra field in filemaker named it Constant and has always Value 1, i created a new table with 2 fields , Constant , MaxID. I create a relationship to the two tables through constant and created the calculation Max ( ID ) in the MaxID field, but this never return me the maximum id number from the sql field. Sql Table___________________Filemaker Table Constant(FM Field)_---------_Constant ID__________________________MaxID (Max Function) If anyone got any solution thank you

i what to make a serial number but not for all the lines only if i have a conditional term . how do i do it?

I format some text in a calculation field like this: If ( not IsEmpty ( Line1 ) ; TextStyleAdd ( "On Line 1 we have " ; Bold ) & Line1 & ¶ ) You see the TextSyle only if you click on the field. Do you know a solution to show the format without clicking on the field? thank you!

Is there a way for a calculation to determine if a particular field contains a reference to file or the actual file it self? I'm putting together a script that will do one action if it is a reference (i.e., open the file) or another if it was a stored image in the container (i.e., export that image for opening)?

newbie question here: How do I count unique values of a field in a subset of entries? To be specific, I work at a homeless shelter (you might guess that we don't have any money for IT help). My database tracks admissions. Currently I have a single table with the characteristics of an admission, including client ID, SSN, dates of admission and discharge, etc. Clients are often admitted multiple times in a given date range, so multiple admissions may reference the same client. I may need to break it into two tables- one for clients, one for admissions. Whether or not I do that, I can't figure how to solve my problem. I want to ask how many unique cl…

Hi: I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated. So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. I posted on an excel forum and a nice member was kind enough to provide the following function: =Sumproduct(($A$2:$A2=$A2)*($B$2:$B2=$B2)) It worked, but the file would not save for whatever reason. Tried twice, so, I've converted the file to FMPro and was looking for help with an equivalent calculation in FMPro I nee…

Hi all, I have been trying to utilise the following (see below) to auto format phone numbers for Australia. Also a dumb question.... where do I attach the calculation... to the feild I want formatted and if so do I change it from a text field to a calculation field or do I use validate by calculation? Thanks in advance Milton. [color:blue]//Restrict input to digits-only Let ( ( num = Filter ( number ; "0123456789" ) ; Phone = /* Vary occurrence of spaces, depending if the phone number features 10 digits... */ Case ( Left ( num; 1 ) = "0" or Left ( num; 4 ) = "1800" or Left ( num; 4 ) = "1300"; Left ( num ; 4 ) &a…

Hi there, See the attached file. Before performing an entry in the General Ledger, I want to make sure there are no duplicates of the data I am about to transfer there. Please check the Search Duplicates script in the General Ledger file and see what's wrong. To figure out how the data transfer works, it all starts with the Entry General Ledger script in the Accounts Payable file. See the Blue Book icon on the left-hand side in the same file. Thanks Accounting.zip

I have developed a filemaker Database to keep track of my companies Inventory. It ranges anything from details of that Inventory item, Descriptions, Images... .etc. It also keeps track of Shipping. I have provided a very reduced version of my database to address the tracking issue I have come up with. There are 3 Main Tables for my database. 1. Inventory Information - this is where all the main information is kept for our inventory items. Each Item is assigned an inventory Number that is unique. On this screen is a portal relaying information from another table... 2. Transmittal Details - This keeps track of which inventory items are on whic…

I have a global storage container field, which I store a picture in, which is just the same for all records. I can put a picture in the global field, and all is well until I quit filemaker. Upon reloading filemaker, the global field is empty and the picture gone. Any ideas?

Hey all, I'm up against the proverbial 'wall'. I have a variable that has a list of values. Some values have data, some do not. For example ¶ ¶ Apt 2C ¶ Apt 4D Apt 8H ¶ etc. etc. How can I effectively filter out all of the empty lines from this list, including those at the top and the bottom? I feel like this is really simple, but perhaps it isn't. It certainly has me going around in circles. Thanks in advance for any help, all! Michael

Hi all I have a record id field that is formatted as text. The information that is in this field is a combination of numbers and text. Example 3700 FCAW -s 773211 The last number is a date converted to numbers I am trying to find the maximum record ID using the Max function. But only that is displayed is the numbers Example: 3700773211 I will assume that the Max function in this case cannot displayed text and number together and is there a other function to achive what I would like to do. Thanks Lionel

I want to create a field that keeps a "history" of the values entered in another field from the same table. Basically, when the user changes the value in Field A, I want that new value to be added to a list in Field B, without forcing the user to press a button. I've tried playing around with calc fields but no luck so far. Is this possible to do in FM9? Thanks for the help.

I apologise if this is not the topic my post belongs too, but I couldn't find a specific location for my question. I am about to purchase Filemaker as a solution to my small business. I'm not a great computer person (love my computer, just don't have in depht knowledge). I'm trying to setup a database for customer database, where I will schedule services, generate work orders and billing. Since I provide services, the same customer may have multiple locations where the work is done, specific scheduling and so on. At the end of the day I should be able to close the invoice by filling which products I used, concentration rate, areas applied, etc. This is an area…

Will $ or $$ variables called by a calculation ever interfere with each other? I thinking about a custom function that uses a $ variable as a counter, but I'm wondering if that can backfire. If a $ variable is defined by more than one calc at a time (in a Let() statement), how does that resolve?

Is there a way for the Auto-enter data in a field be overridden by the data that was entered when the record was duplicated? For example field "A" has "n/a" as being auto-entered upon creation, I change field "A" to say "b/a", I then duplicate the record, but in the new record, field "A" reverts back to "n/a" instead of staying as "b/a".

Am I using the right calculation for this senario...It won't work Case( Hourly Rate < 65;"15";Hourly Rate ≥ 65 and Hourly Rate < 80;"16" ; Hourly Rate ≥ 80 and Hourly Rate < 100;"17" ; Hourly Rate ≥ 100 and Hourly Rate < 125;"20")

Hi all, I have a problem. How do I make the following calculation update? If((TaxCode="GST")Invoice/11;0) If the Tax Code previously was set for FRE as an example and then changed to GST at a later date, I would like the calculation to automically occur. It only calculates on new invoices not existing ones. CIA Milton.

Hello, How to sum a subset of records in a portal? Each student has a record with a child portal for grades with a date, grade, and a category (assignments, quizzes, and tests). How could I sum for each individual student, for example, the grades only for tests? Thanks.

This is my first post. I am trying to set up a field that will calculate a date for me automatically by subtracting days from another field. I have a field for "Availability Date" and the field I need to have the date created for is "Final Files Due". I need Final Files Due to be 14 days (just a random number) before the "Availability Date. I have tried using calculations in the field controls but all I get is a "?" Any help would be greatly appreciated! Thanks!

Hi It is a long time since I have posted, but am in need of help. I have a built a database which I use to calculate the cost of a picture frame. This is split with separate tables of 'Calculator', 'Moulding', 'Mountboard' etc. The calculator works out the cost by various calculations based on the length and width of the frame and cost of the moulding etc. What I am trying to do is to input an amount for the starting stock of moulding length, then I would like each record in the 'Calculator table' - (a sold picture which has been framed) to subtract from the stock level the length of moulding used. I cannot work out which table to put this on or how to go about t…

Hello! I am trying to change a calculation field that used to have "Get (UserName)" function into "Get (AccountName)". But when I did that it changed the whole database records to the current AccountName that I am logged into which is not good. Is there a way to change this calculation field without overwriting the previous data? Thanks so much! nese

Hi, I haven't been able to track this one down so appreciate any thoughts that you may have. I have a basic customer table and a systems table. In the customer form i want to click "add system" which brings open its own window to create a system in the system table. I want to have the customer ID in the system table auto fill bassed on the ID of the customer im looking at when i click add system. I have attached a copy of the file for a more clear picture. Once in the customer layout, click on the systems tab and a button will show and allow you to add a system. Any pointers would be greatly appreciated. AFPS2.zip

I'm working on a database that has an "On / Off" field displayed as radio buttons. Is there any way that if I turn 1 record to "On" all of the other records would be "Off". I can only have 1 record On at any one time.

Hi there Pls help on this. Going crazy. Im trying to develop an inventory system for our local shop. Im posting my application so that you can scrutinized it well and see if there's something I messed up. My problem is this, Have 2 tables REQUISITION and ISSUANCE. After the user has entered all data in REQUISITION TABLE, it will be passed on to the ISSUANCE LAYOUT to be issued by an ISSUANCE NO. Once the REQUISITION TABLE has already an ISSUANCE No. data cant no longer be entered for that particular record/instance. Pls help me on how to implement this. The username and password of my application is: pele Main.zip

I feel like I've seen this on here recently, but can't find it. Can anyone provide a way to filter out null values from a list of values? "¶¶ABC¶123¶123¶¶¶EFG¶" should return "ABC¶123¶123¶EFG" Thanks

In my cabinetshop I do a lot of calcuations that involve conversion from inches to millimeters. 1 inch, for example, equals 25.4 millimeters. I would like the calculation to delete all values to the right of the decimal. I know I can change how it is displayed with formatting but I'm trying to make it change in calculating. For example: 25.4 + 25.4 = 50.8 should read 25 + 25 = 50. MS Excel does this with a function that converts values to equal "precision as displayed". How would I do something like this in filemaker? (For what it is worth we were going to maul the door on the edgesander anyway so the loss of .4 millimeter accuracy was mo…

I am having some problems figuring out how to automate payroll calculations. The workers record their hours each day on a timeclock. They punch start & stop times before lunch and start & stop times after lunch. There are two starts & two stops each day. The data from these time cards is presently entered into an MS Excel spreadsheet. A typical card would look like: 08:15 12:10 01:08 05:14 The problem is that excel needs to know whether the time is AM or PM to make the calculations work. I enter the times as digits only but then have to look at each entry to surmise whether or not it is AM or PM. Is there a way to make fi…

I have a problem where I need to calculate to the next date of a particular weekday. Let say: Start_Date = Monday, 8th December 2008 Period= 4 Weeks Calc_End_Date = Must be the weekday of the Start_Date in a Period of 4 weeks (=5th of January '09) If I use the Date Function, Day (Start_date + 28), it doesn't work always because it calculates the day not the weekday. How do I calculate the weekdays if I want to use the Date function? Thanks

I have 2 data sets - customers and line item. The customer field has dates - start date and end date for the interaction. There is generally one to four items purchased per day. The invoices are generated at the end date of the interaction. I want to enter the customer data with start and end dates and have the portal to line item populated with dates so that each purchase can have a date associated with it. is this possible?

In my renewal process I track when clients renew to best decide next year when to atempt the same renewal. This field is based on a range of dates. From November to Dec 15 / Dec 16 - Jan 15 / Jan 16 - Feb 15 / Feb 16 - Mar 15 I've been using get(currentdate) but I'm not sure how to search a range in a script. 1/1/2009...1/2/2009 (example) doesn't work like in a find. Maybe this has to be done in steps. Any help would be greatly appreciated. Regards, Mike.

Hi Guys, I have two fields, field 1 contains the data New York however field 2 contains the data London Milan New York New York2 Madrid What formula can I use in a calculation to say if the content/value of Field 1 is in field 2, than display a True, Else display false. The values in field two are seperated by a carriage return. Many Thanks for your help Jalz

Hello, I'm trying to accomplish something that looks quite simple to me (at least on SQL world) but I'm stuck. Basically, I would like to define a field (version) that calculates the number of records having the same "trace number" of the record + 1. I have found this function that could help me http://www.briandunning.com/cf/894 but I'm not sure how I can use it. Can anyone help me out : THANK YOU

using the file attached, how could I loan out several books at once to a single person ? instead of one by one ? thank you. Lending_Library.zip

Hello, my question is, how can I enter several records at once, like i would for a repeating field but create a separate record for each one? could I use a repeating field to enter the data, lets say 10 lines, and then use a script to actually generate the records ? and what would that scrip be like ? thank you.

I am developing an application that calculates required shipping carton dimensions for shoe boxes. The application is specifically for cartons containing a mixed selection of shoe boxes. In addition to calculating the required dimensions, I have also been asked to determine the optimal placement of the shoe boxes within the carton. Optimization means calculating the smallest shipping carton size, while placing the four longest boxes in the corners (this adds strength to the shipping carton). There are 12 shoe boxes in a carton, 3 rows and 4 columns. (actually there are also 9 and 18 packs but 12 will do for the example) What I have to do is find the configurati…

Hi Everyone, I have the following situation I cant get my head around. I have a table "Customers" and a portal to a table "Machine Line Items". Each record in this second table has a "machine type" field. My problem is that on the report for each engineer's route, I need to display how many of each type of machine there is, in one field! For example: Lets say there are 3x DC, 1x MV and 2x NP. Each one of these would be a seperate record in the "machines lineitems" table - a total of 6 records. I would need a field to display on this report to say that there would be: 3xDC, 1xMV, 2xNP... Is there anyway to achieve this via a calculation field…

I am trying to sum a value field dependent on a related value in another field. The related value is in another table, but I can put it in the same table as the value field. I want to set up a Balance sheet, and I need to sum the "assets" and "liabilities" and then subtract the "liability sum" from the "asset sum" to calculate retained earnings.

Hi everyone. I have been messing around with this for hours and it just won't work!! I'm starting to think I'm missing something incredibly obvious. To simplify things, I have a field called 'status' in a table called 'serviceEvents'. I then have another field called 'routeDate' in a table called 'Routes'. Essentially, UNLESS the job in 'serviceEvents' is currently on a Route, and hence in the 'Routes' table, I want it to only allow the status field to have the value of "incomplete". Otherwise, I want it to allow "Incomplete" or "Complete" (thinking about the problem logically, it wouldn't make sense to mark a job as complete that has never been on a route - and…

Hi. I'd like to know if it's possible to carry a balance to a new invoice for the same customer. Currently when I make up a new invoice it doesn't show the balance due from the previous invoice. Any help with this would be greatly appreciated.

Good morning, How would I go about making a calulated field that would automatically fill in an amount due if an invoice has not been paid in 30 days or has been partially paid. I have my date field, Amount due field, amount paid field and Balance due field. Thank you for the help.

I am wondering if there is a calc or way to play MIDI files in Both platforms of Filemaker. Thanks Dave

I have been working on a client and inventory database for an art gallery. The woman who we hired to set up filemaker has put everything in a mess for us. Right now the clients info are not connected to the invoices. So when something is sold the sales rep has to put in all of the info again..and that doesnt make sense at all. We bought Filemaker to make life easier...not harder! So I would like to know if we can connect the client database to the inventory/invoicing database. They are seperate entities and I hope we can connect the address/email/phone number/shipping address..etc.. The woman who set up our filemaker said that since we have about 4,000 clie…

I am new to Filemaker. I am trying to calculate the date that something is due based upon the date entered from another filed. This would be simple, except the calculation needs to exclude weekends (and holidays for that matter, but I will keep it simple for right now). I just simply cannot figure out how to write the calculation. Could someone please help me? Thank you. Here is what I have: date_response_is_due=date served I have been just simply using: date_response_is_due=date_served + 14 I don't think that this works for some dates. Thanks for your help.

I have read the info on finding duplicates with a self join and numbering them via Count() function, but my situation is slightly different I think. I have a Table of students who attend my school and I often email their Parents. I get my found set usually by go to related record from a class they are in or a course they are taking. When two or more siblings are in my found set, the parent gets the same email for each of them, which is not a major problem, but I'd prefer to send only one email per family. Eliminating the second family member from the found set before sending doesn't work because sometimes only the second family member (by the self join) is in the …

Hi. I was wondering if someone could help with a question I have. I'm trying to do a calculation that needs to find a range of dates. If the date is between 1-1-2009 and 3-31-2009 then it needs to return a statement like "1-1-2009 through 3-31-2009" and then the if statement has to continue and do the same for April -Jun, Jul-Sept, and October-December. I've tried it, but everyting I try always ends up returning everything after 1-1-2009. Any help would be greatly appreciated.

Hi All I have a program in FM8.5 that keeps track of our welders qualification. The welders are required to weld at least once in a six month peroid for specification reasons so we have a continunity log for each welder. Once a month someone from the Quality Control department prints a report of welders that need to be update. The problem is that sometimes one person might update the log without that telling anyone and then went someone else updates the log a couple days later than we have two updated records within a couple of days from each other and I would like to not have this occurence in the DB. The simplest way would be once the record has been upddate then is…

So I have been trying to clean up a mess on Filemaker that someone set us up wrong... The invoice is for a gallery. For our invoice, we have to have a Retail Price and a Sale Price (since we discount a lot) for every piece of art... Firstly, I would like the "retail price" to go into the "sale price" even if it is not on sale..because the below desired calculation needs to be a sum of the sale price. On the bottom of the invoice I have lined down.. "Total Sale Price" (pull from each item on invoice) "Tax" "Shipping Cost" (only once) Other (In this field I would like to show any Shipping Discounts, so maybe negative sometimes) "Total Invoice Cost"…

Hi. I am looking to store shortcuts of a file (and it's path) in a field. I need to be able to drag a shortcut (or something like that) into a field to store that info - NOT the file itself as the files are very big. The purpose it be able then click on a button alongside that field and use that text to then copy that file to another location - specifically a shared printer. Problem is that we get OLE errors when trying to creat a shortcut directly into the container field. Can somebody suggest an easy way to get a file and path (text) stored into a field other than the traditional cut-and-paste method. Greg

Hi I have a repetition field. Let say i have 12 rows in one field. Is it any way to stop the user or warn them to stop scanning or submitt data when users reached rows no 12. tq

I am trying to figure out validation on a field. I have a drop down list with the option of selecting "other". I then have a field next to it that I want the user to enter what the other is. I don't want the user to be able to enter data in the field unless "other" is selected. (I want to force the field to be blank unless the dropdown on the other field is set to "other")Do you have any suggestions or can send me to another thread that I can find the info? Thanks! Cin

I have a notes field that I keep track of my relationships with prospective clients. I set up a short script that every time I click on my notes field (large field with 20 lines) that the date and time populate the field with a script. Then I enter the bulk of the conversation as I talk on the phone so I have a good record of it all. The problem I am having is that I want the cursor to start in the upper left hand part of my notes field, insert 2 lines, THEN put the date and time, then add 2 spaces, then leave the cursor right there for me to type. Pretty simple actually. This way I can always see my latest conversations on top and the less recent ones below…

I have a fairly large Filemaker solution built on FMP 5.5. I would like to upgrade it to at least FMP 8 to be able to run it on an OS X Server 10.5. I am specifically interested in how I should proceed with replacing all the deprecated 'Today' functions (which are used heavily in my database). As far as I understand, this function is obsolete and should be replaced by 'Get(CurrentDate)'. Is this true? Can I just replace the function 1:1? Is there a simple way to go through all the scripts to do this? I am also interested in other tips and tricks related to upgrading. So, please do share or point me to a source.

As my database has grown in size so has the time it takes to delete a field in a table. Everything else seems to work fairly quickly. Any ideas?

I added a 'days elapsed' calculation and it appeared my transition speed between records (using a script that employs NextRecord, PrevRecord, etc ...) suffered about a 50% increase. I removed the calc and things are 'normal' again. Is this to be expected with Calc fields? This one is nothing fancy - just one date subtracted from another. The data is not stored, as the dates are in two seperate tables. Might the slowdown be attributed to the data in different tables? Thanks in advance - just hoping to see what others have experienced to gage what goes on over here. Since posting this originally, I experimented adding the field to the other table, …

Hi, It's been awhile since I've done any programming and that was on filemaker 6... so, I need some retuning. I have two fields, "First Name" and "Nickname" on a contact layout. I have a separate Letter layout. If there is a Nickname, on my Letter layout, I want the Nickname to override the First Name. So, I'm guessing I would need an override field with a calculation that if the Nickname field is notempty, then display it, else show First Name. I can't remember how to do that! Any help would be appreciated. Thanks!

I am trying to figure out how to create a list of dates between 2 fields. I have a start date and an end date, is there a way to show in another field all of the dates between these two fields?

I'm trying to reference audio files and play them in a FileMaker solution. I need a calculation that will take the file path from one field and dynamically feed a container field in order to bring up a particular sound file for auditioning in FileMaker - at least that's the way I perceive it to happen in my brain. If there's a better, more practical way to do it - I'm certainly open to suggestions. The only stipulations are that the files are on a remote drive and can only be referenced - they should not be imported into the FileMaker solution for playback. Thanks to all, - Jay

I have a field that I want to be filled in as "Archived" if another field (with a calculation specified to equal a field on another table, as referencing the other table did not work either) is not blank; otherwise, I want the first field to be editable, preferably via something like a drop down list of other choices ("Discarded", "Repurified", Edit...). I know that calculated fields can not be edited nor have drop down lists, so I actually set up the field type as text with an auto-enter calculation. All I really want is a particular entry to auto-enter for one condition and a choice of entries if that condition is not met. I was able to do this for another pair o…

Hello. [color:blue]My business works in rolls of paper. So [color:blue]everything we do is in lineal feet. We are trying to figure out a way to add up all of the footage we've sent out and show how far around the world we've went. For rolls....I have a summary field of all of the final footage we've sent out for each customer. For sheets...I have a calculation field that brings the total sheets sent out into total lineal feet sent out. And a summary field to add all of them together. My problem is adding up all of the total roll feet and sheet feet for all customers. I have 2 summary fields and I'm not sure there is a way to add those together. Any…

Hi everyone, I have a database that keeps track of imported documents, their title, and the date they were created. I'm creating a report and want to include a field for the title of the most recent document created. However, I'm not sure how to do this. I can use the max function to return the date of the most recent document, but I want to return the *title* of the document associated with it. Does anyone know how I can write a calculation to return this text? Thanks!

Need to Calculate the number of classrooms needed: I need to calculate the number of classes that take place in given time slots and I don't know where to even start. Any advise would be much appreciated. Classes are scheduled at 00, 15 , 30 ,45 past the hour We need to analyse our room needs Thanks in advance

how can I calculate how many days have transpired from a particular date. in one field I have an automatic date/timestamp, so I want to be able to take that data and calculate how many days have past from that day. thank you.

I have 3 fields 2 text and 1 number, I want to combin the 3 fields to create a unique field to deter duplicate entries.

My database collects information about medication use in a hospital. In Table 1 every medication that every patient is on is entered daily. Each medication for each patient on each day is an individual record. There are about 5000 records daily added to this table. The fields include medication name, dose, patient number, location of patient, date etc. In Table 2 I have a list of medications that I want analyzed using data from Table 1. Each record is a different medication of interest and only occurs once. Table 1 and Table 2 are related via the name of the medication. In table 2 I use the Count function to show how many times that particular medication occurs in…

I'm creating a school attendance database. Each student has their own record which includes student ID, first name and last name. Each record also has fields for date, time in and time out, which are duplicated 100x (for each potential time they could be marked "present" during a semester). I'm trying to create scripts/buttons that will auto enter date, time in and time out, but it auto fills all the fields when I execute it. Is there a way to get it to auto-fill for just one field at a time? Or am I going about this wrong?

Hi, I'm trying to TRIM (I think) a "first name field" so that only the first letter of that first name shows up. Is that possible? If it is how do I do that? Or should I use another function? Thanks much Amy

Hi everyone... I am trying to get around the following problem: I have a table "Customers" and a table called "Service Events". Office staff are able to create a service event via a portal in the customers table, and log the service by adding a description, service type and service date. (This is later processed by another department). My problem is that I have been asked to make the system such, that if there is not future jobs logged for the customer, one automatically gets logged based on the recommended service interval (which is calculated based on previous visits, or alternatively set by the logistics department). I can't think of a way to automatic…

I have many clients, and often new clients are within the same area, perhaps the same street. I'm making a script that will duplicate & replace the digits of the street, but leave the rest. I'm using Set Variable $Leftword and insert calculated result. For the moment it works just fine... but there are times when Digits might not be the first item in the address field and its obviously removing the leftword. Is it possible to evaluate the global variable? Maybe my logic is off but ≥ 1 isn't working. ( I think it is just counting the items in the global variable ) Still new to filemaker. Regards, Mike.

Hi, Simple request from a noobie (I hope). I have a layout which lists Invoices and I'd like to be able to get a calculation which gives me a total value of invoices sent. So I have a Field called 'Total' and a Radio Button Set called 'Status' which lists values 'Sent, Not Sent, Paid'. I would like to create a summary field which calculates the 'Total' of 'Sent' invoices. Thanks.

I am very new here. Please forgive me if this is not the right place to post this. I have a mailing list database in Filemaker 7. I have had it for some time and now I need to make one change and I am hoping there is a simple way to do it. In this database I have one field for "First Name" and one field for "Last Name" In the "First Name" field I have always just put the title in there as well. Like Mr. or Mrs. or Rev. etc. Well I want to set up some letters to use mail merge and the way my database is now if I select the "First Name" field to begin a letter it would put Dear Mr. Bob instead of Dear Bob. I need to create a new "Title" field and separate the titles fr…

Greetings, I am not sure where else to post this, so I'm posting on this subforum. It's dealing with fields, but also seems to be dealing with networking. I have a ten seat system where a database works fine on all but two machines. I have uninstalled and reinstalled filemaker pro 9, and dumped all filemaker user preferences to no avail. All users are using FMP9.0v3. I installed FMP9 Advanced on one of the problem machines. The script runs fine when you step through, but when you don't have debugging on, it still gives the same warning error. I'm using an adapted templated filemaker solution "ClientTracker" from iSolutions that came straight out of th…