The Left Brain

I manage a single (flat) database. I track the dates of patients documentation due by the clinical staff in calculated feilds. So bascially i enter the admit date of a patient and based in that input the different dates of various documents that need to be generated for that client are automatically displayed in their respective feilds. I used to manage this database on Excel, but would like to now use filemaker 8. So I imported these records into their fields. I would now like to write a script to turn the fonts to red if they are not already changed from black to gray. I change the fonts from black to gray when the documentation for that particular patient is recd. So b…

Hi, I need to have to calculate a key that's quite long if I simply concat the values. Moreover That key will be twice as long since I need to add another long key. The length of the key is unknown. Each element of the key are numbers. Key 1 :12 52 56 89 56 566 565 144 12 533 Key 2 56 98 654 23 7896 52 12 562 4566 I'd like to convert to transform Key1 and key2 in kind of checksum : one unique number. So I'd have Cheksum key 1 : 4665665 Cheksume key 2 : 895965 Moreover, I want the "Cheksum" key to be equal regardless of the order of the elements Key 1 :12 52 56 89 56 566 565 144 12 533 Cksum = 4665665 Key 1 :12 533 56 566 56 …

Is it possible a sort of summary in text fields

Hi. I have an address field that often contains more than 1 line. I wish to split it into 3 separate fields (as no record has more than 3 lines). I have managed to get the first line out (see below for calculation - prob. v. clumsy) but can not work out how to do the other 2. Any ideas? Thanks If(Position(Home Address 1, "¶", 1, 1)=0, Home Address 1, Left(Home Address 1, Position(Home Address 1, "¶", 1, 1)))

Is there any way to retrieve the computer name in filemaker? I'm speaking of Windows but maybe some mac ideas would work too..

hello! I have import from a text file A name list Jaspar, Bobby, & Henri Renaud Houston, Whitney, & George Michael Basie, Count, and His Orchestra Rietman, Jan, Band Commodores, The Harrison, George, And Friends Primal Scream Culture Beat Ram Jam Getz, Stan, & His Quartet Burton, Gary, Quartet, The as you can see I have move words so Burton, Gary, Quartet, The be Gary Burton The Quartet I have import the list in Excel using comma sep text and then I import the names in a fm file then I use not a very clever way to change the order of words... See the file.... is there a more clever way to do that? External_co…

I have two tables Project ----- Tasks On the project layout I have a portal listing all the tasks task completed date What I want to do is have a calc field in the project table that looks at all of the tasks for this project, and if they are all completed, finds the most recent date, then plugs it in that field. How can I do this? Thanks Dave

I have a portal that tells me when a task is scheduled - ::Date of task/::Time of Task/::Alarm/::Reminder Time. ::ReminderTime is a calc field see JPEG above: The calc gets data from the Alarm field see JPEG above: Which is a value list. Problem: As long as I am choosing 5 minutes to 12 hours everything works fine. If I want to set the reminder to 1 + days/weeks before it does not calculate. I have figured out that I need a calc that will set the ReminderTime to a day before at the same time, but, I can not figure out how to set up the calculation. Help Please!! Thanks, Al If anyone has any suggestions as to h…

How do I create the following: I have a start date for my students their midterm is 75 days from the startdate their final is 75 days from the midterm or 150 days from the startdate. However, summer holidays cannot be counted. Summer holiday is from June 29 until September 3rd. So, I need a script that will calculate the midterm from the startdate and the final from the startdate. This has got me stumped so any help would be appreciated. D. Cannell :P

Can someone tell me how to enter fractions in a text field so that they look like actual fractions? I have address data (e.g. 1234 1/2 1st St.) that looks awkward that way - it would be much better if the numerrator were superscript and the denominator were subscript. Is there a way to do this? TIA, John Chamberlain

I'm trying to check if a filename in a portal of attachments contains one of a few words, and then have it auto-enter "yes" into a text field if so... it's entering nothing into the text field even when the strings I'm searching for exist in the related value list.. what am I doing wrong ? Let ( [values = ValueListItems(Get(FileName); "attachments")]; Case( ( (PatternCount( values; "CV") >0) or (PatternCount (values ; "resume") >0) or (PatternCount(values ; "app") >0) ); "yes"; "") ) thanks :

I am getting results I do not understand from a relational - calculation situation and I need some help... I have TO #1 that has a text field with properties: autoenter - data - "Yes", (Actually in quotes) prohibit mod flag checked, validata only during entry set, repetition = 1, allow user override unchecked, and autocreate indexes. This TO is equijoined (equals sign in relationship) to TO #2 via a related field in TO #2 with properties: calculation type = "Yes", calculation result is text, Do not eval flag is checked, 1 repetition, global storage, and evaluated from the context of TO #2. The edit relationship dialog has TO #2 on the …

Is it possible to link directly to a record? something like fmnet:/server/filename/table/record I am not using any sort of FileMaker webhosting. I would like to send an email with a link to a specific FileMaker record.

Has anyone ever seen and/or heard about a calulation or script enabling you to edit the relationship graph in browse mode?

I am brand new to Filemaker. I am having trouble calculating a weekly totals report. I am trying to take 10 groups (a,b,c,d...) and get weekly totals for how many people are classified as a, b, c, etc. at the end of each week. I hope someone can point me in the right direction. Thanks.

I am trying to replicate the XIRR function from Excel in FMP. Basically, I have a database that has different cash flow entries for a given security, and the cash flows do not occur at regular intervals. I need to know what the internal rate of return is for this series of cash flows. So, for example, one record might indicate that I paid $20 for 2 shares of IBM on Jan 1, the next that I got a $1 dividend on May 30, the next that I sold 1 share for $12 on October 14 and the last that I sold the other share for $8 on December 12. What was the internal rate of return for these cash flows? In Excel, it's derived with the XIRR function. Is there a way to do thi…

I have a client - a museum - who has a text field in one of the files of the FMP6 solution I made for him over the years (100 files 20 users FMS55 WinXP), in which he made 'enrichments' by hand (bold, color, underline, etc.) on thousands of records (without telling me...). He wants now to make a book out of these records. So he asked me 1) to export in Word while keeping the enrichments this I think I found a way in making him buy FM8, move his file into FM8, going through the records, then exporting as html, renaming it .doc. It will be done a few times but not every day. 2) to allow creation and withdrawal of 'Notes' like in Word. This has to be done every day …

If you have a portal displaying records and you are sorting by a field, let us say, by State, is there a way to have a line break between the groups of records based on that field? Don Ca Dave Ca Fred Ca Lisa Ct Doug Ct and so on? I wouldn't think that this is possible, but I have seen people on here do things daily that defy the realm of possibility. Thanks Dave

Hello everyone, I'm trying to model a savings account. Two tables, Accounts and their related transactions. The sum of the transaction amounts give the account balance. Simple enough.. But how to calculate a compounded interest? My thought was to add an interest transaction each time something changed either the interest rate or the addition of a transaction. But I can't find a formula for calculating compunded interest. I have Interest rate The startting balance The amount of time All the functions I see have you putting in payments. This is just one lump sum over time. Many thanks in advance! -jim lee

I'm needing a way to see if I've gone over the limit on devloper. I've got these fileds right now. ================================================ gplate_maxsqft (Gobal filed, this # is the # that tells me when we need to change the devloper) PlateCount.tb (table =============== Plate_Date (When it was plated) Plate_count_sq (Total sq used) Logs.tb (table) =============== History_Date (Date) History_Devloperchange (Yes or No option) ================================================ So what I need is a way to get the Total sq used since the last time the History_Devloperchange says yes. I think once I've got that # I can then use …

hey guys, I'm totaly new to FM so this is whats up- I have a Contact managment database going, and I have a field with the calculation nameFull =nameFirst & " " & nameLast in table "contact" and I have the field "name" in table projectAssinment. what I need to happen is, when I add a new record to contact I need the result of the nameFull calculation to be added to projectAssinment as a new record in the "name" field. thanx for your advice guys.

I've need some direction! I need to find the sq footage used. I've got three fields. Plate_type(Value List) and Plate_Count (number filed) Total_sqft (calulation) The Value list is popup list that allows the users to select the plate used. each plate type has a known sqft. but I need away to instert into the calculation the sqft # for the used plate type. 237=7 840=8 If Plate_type was 237 the calc would be. 7xPlate_count if the Plate_type was 840 8xPlate_count Thanks Devin

I have this calc Case ( Sup Crew = "1" or "8" or "15" or "22" or "29" or "36"; "Sat/Sun"; Sup Crew = "2" or "9" or "16" or "23" or "30" or "37"; "Sun/Mon"; Sup Crew = "3" or "10" or "17" or "24" or "31" or "38" ; "Mon/Tue"; Sup Crew = "4" or "11" or "18" or "25" or "32" or "39"; "Tue/Wed"; Sup Crew = "5" or "12" or "19" or "26" or "33" or "40"; "Wed/Thu"; Sup Crew = "6" or "13" or "20" or "27" or "34" or "41"; "Thu/Fri"; Sup Crew = "7" or "14" or "21" or "28" or "35" or "42"; "Fri/Sat"; "unknown" ) No matter what number is in the field (Sup Crew), the result comes out "Sat/Sun" I don't get it, it should work. Thanks Da…

How do you use tickbox entries in calculations? For instance, Say I have a tick box with 5 values, (Eg. A, B, C, D,E) and I want to use an "if" statement with them. I want the result of the statement to be true if A is selected, but any of the other values can be selected with A, it still stays true. So far I used If(TickboxField ="A"; blah blah), It works If A is the only option selected. How do I make it work so that any other options can be selected with A?

I see that a lot of you are good at date calcs, this one is an interesting one. I have a field for birthday, last medical, and next medical due. Here is the problem. Currently I am using this for next medical due Case ( Age < 40 ; Date ( Month ( Last Medical) ; Day ( Last Medical ) ; Year ( Last Medical ) + 2) ; Age ≥ 40; Date ( Month ( Last Medical) ; Day ( Last Medical ) ; Year ( Last Medical ) + 1) ; "" ) It works, but not exactly like I need. 1) I only want it to return the month and year the medical is due. 2) If a person has their last medical while still being 39 years old on the day of the medical …

Hi all, Hoping someone would help me I am submiting an enter enter calculation that killed my sleep for last few nights. I have an invoice db. In invetries I have "quatity available" as auto-enter here is the calcuation Case ( Quatity Available ≤ Reorder Quatity ; TextStyleAdd ( TextColor (Quatity Available ; RGB ( 255 ; 0 ; 0 ) ) ; Bold ) ; TextStyleAdd ( TextColor ( Quatity Available ; RGB ( 119 ; 119 ; 119 ) ) ; Bold ) ) this calcuation gives me the expected result The problem i am facing I want to add the "purchase quaity" to ""quatity available" and minus "Quality sold" any kind of help would be apreciated

I currently have a solution where tables are linked as such: Area Manager (belongs to an area) 6 Areas Supervisor (belongs to an manager) Employee (belongs to a supervisor) Certain files belong to an employee, such as notes and evaluations. The same thing is true for supervisors Now the problem. Lets say the Chief goes to the Managers and says, I want supervisor Doug to work in Area B now instead of Area F. Well thats easy enough, I go to Dougs record on the supervisor layout and select area B. All of Dougs files should go with him. Thats not going to work. Unfortunately the way I have it set up, the employees under Doug are going to go w…

is there a way to navigate to a field based on a calculation?

I'm somewhat of a new user and have a problem that I can use some help with. I have a number field that has a value (marketing cost). This value is specific to a Sales person and added on a monthly basis (the amount changes from month to month). I would like to equally divide this value by the number of jobs (orders) that this person has closed in the particular month. What is the best way to accomplish this task? Thanks!

Hi Everyone. I am hoping someone can answer this question for me. I was given a responsibility to register class attendees and provide enrollment lists to the teachers. The database is in FM 5.0. I have never used FM before 3 months ago. I was able to make the database work except one piece. Problem: I can't create the enrollment sheets. I have a table containg class information (number, teacher name, etc) and I have a table containing student information (name, address, classes being taken, etc) Then I have a layout in the class database with the enrollment information and a portal set up to list all the students in each class. IF a student signs up …

Any ideas for this would be great... I am building a dynamic label printing database... Developers Custom functions have been a dream come true and i have achieved everything i desired and it all looks elegant... Until this. OK trying to avoid my clients getting layout access They now have customisation of font name, style, style (per line), color, vertical and horizontal alignment. Only thing is some will want to indent the text... OK i thought they choose the indent number my calc says... Choose ( indent_number ; "" ; "_" ; "__" ; "___" ; "____" ; "_____" ; "______"... (spaces get wider can't see in post so used underscore) sweet ... until …

These all came about when we upgraded to v.8.... We have a list of groups which people are a part of. They are called "Happening #55, #56, etc." It won't allow us to search by these groups. I know it's because of the number sign. Is there a way to fix this without losing all the data? Your help would be great! Thanks. Bethany

hello how can I multi formmatting a text field? Lets say that i want to formmatting a text field field A; RGB ( 200; 30 ; 20 ) TextStyleAdd ( Album Name;Bold+Italic ) and TextSize ( field A ; 12 ) is that possible? George :qwery:

Hello all, The client I am developing for uses a Stock ID number for each individual piece he sells. Each piece is unique and has a unique number. Part of this number is the six digit date (MMDDYY) the item was received. Is there a way to convert an auto-enter date (MM/DD/YYYY) that is made with each new record to just MMDDYY so I can use it in a calculation to help automatically created the stock ID number? Thanks Drew

I would like to limit the number of characters in a field to a specific amount. But when it reaches that amount before the commit the record, i would like it to stop give a message and not let them input any more... like "You have reached the limit on number of characters, no more"

Hi there, In order to delay a function, I would like to know how I can display a small dialog box for 5 seconds where you see a short message and a countdown. There must be trick for that. Any help? bikeman

HELLO I have a list of songs It looks like ..... Masquerade Is Over (Magidson/Wrubel) Make It With You (Gates) Echo My Heart (Kurasch/Weiss/Wood) Stay Right Here (Bailey/Booker) How Can I remove the composers from the line and the list look like Masquerade Is Over Make It With You Echo My Heart Stay Right Here Every song is a defferent record. Can anyone help me? George Athens Greece

I’ve just run into a bizarre problem. The result of a Boolean calculation in Data Viewer is different from the result of the same calculation in my Layout. Here is the calculation: IsEmpty (Address::Street) I place the calculation in Data Viewer and in a Field on my Layout. IN DATA VIEWER, this calculation evaluates “True” when the field contains no data, and it evaluates “False” when the field contains data. IN THE LAYOUT, this calculation always evaluates “True”, whether or not there is data in the field! I get the same results when I use IsValid(). Is there something obvious I’m missing here?

I would like to perform a calculation such as time multiplied by hours worked. Time is entered as 02:45:00 for 2 hours and 45 minutes. I want to multiply this by $30 an hour for 2.75 * $30. How can I convert time to a number so I can use it in such a calculation?

I thought I could search for an age calc, but no luck. I tried this, which is close, but /365 isn't going to work out perfect. Floor ( (Get ( CurrentDate ) - (birthdate) )/ 365 ) What is the best way to do an age calc? Thanks Dave

Hi I Have been playing around with filemaker and wondered if you ever came across a solution that would allow you to have a history. Made an invoicing solution that generates serial numbers on new record. But I want to append the serial number with A,B,C every time an amendment is made to the quote and be able to see every version of the quote. ie INV0001_A,INV0001_B,INV001_C would be 3 versions of the same quote. Hope someone can help. Hope you can help point me in the right direction.

What's the best way to separate the date and time from the server's time stamp? I'd like to upgrade an employee timeclock by using the network clock instead of each seat. Thanks in advance, Stephen Ray

I have a need to validate repeating fields. I know that in a regular field you can validate by unique value. Well, I want to do the same with repeating fields except I want them to validate with the other repeating fields within that record. Here's the example... I have a repeating field used for items shipped or returned. To avoid human error, I would like the repeating field to notice if I've already scanned in an item into that repeating field already.

Filemaker is telling me that it cannot change a record because it is not modifiable. I have checked every option I can think of to make sure that it is modifiable. I am not allowed to change only when the record is new, and in a portal. The portal will show the empty row to add a new one in, but I am not allowed to edit it. Does anybody know why this would happen?

Here is my problem: I have 3 tables, Supervisors, employees, evals many employees for each sup, and many evals for each employee each employee has five types of evals on the employee layout you see a portal listing all of their evals above the portal are fields to show when the next due date for each type of eval is. The next due date for a PSC eval should be six months from the last entered PSC eval. etc. etc. The six month calc works fine, but I need a way to have the calc, look at all the eval records, match the type eval for that particular calc, then apply the six month calc, giving me the result. Look at employee Jeff for an example If all th…

I am working in a script and want to find a record whose field equals a certain value. How can I view the results of this search and determine if there were results at all from within a script? Would I have to enter find mode, etc.?

I have a database where I can identify particular categories of records based on an entry in a text field and an entry in a value list. I would like to sort the database first by the text field, then by which particlar value is selected in the value list. I would then like FileMaker to display a summary of a separate value list with 50 possible choices, and tell how many of the records have each of the 50 possible choices selected after sorting. Is this possible and any suggestions on how to do it (particularly the summary of a value list field across multiple records showing how many records have each box in the value list selected)? Thanks much!

I hope this is right place for such a wierd question. I have a layout with a text field using a pop-menu with a value list. What I want to do is run a script after the pop-menu, similar to using the field as a button. Right now, the only way I know to do this is to have the button separate from the field. Does anyone know of a way to combine them? Thanks, Bill

Since this discussion last year: http://www.fmforums.com/forum/showtopic.php?tid/151574/ I've been under the impression that Position() is faster than PatternCount() for determining the presence of a string within a larger source text field. And intuitively this makes it makes sense that PatternCount() would need to check the entire source text field while Position() only needs to find one. But when I tried setting up a test of this, I was unable to notice a difference between them. In both FM6 and FM8, my test show equally fast evaluations of a Set Field[] that populates the Position or PatternCount of the search string within the text field. In…

I'm working on a filter feature which goes by week. It currently indexes by the week number (1-52), but visually, I want it to show the date of the week's sunday, as in "Week of Sunday 8/13/05" I had made a calculation field that found today's date, then finds the day of the month. Then it subtracts the difference between the current day of the week and sunday (1). The problem is that if today is Friday the 2nd, the Sunday of this week would be in the previous month. That would mean having to distinguish between leap years and non leap years, and how many days each month has. Is there any easier way to do this?

For some time now I've been developing an inventory tracking database specific to our company's needs. I have had a hard time with a specific portion of the database. I'm hoping somebody can point me in the right direction. Specifically right now I have two different tables, one for shipping and one for receiving. (Every week we ship out equipment...laptops, cases, switches, printers. These all have specific asset tags which are scanned into FM with a barcode scanner when shipped or received) Shipments are tied to a deal number as well as received equipment. I need a way to compare what was shipped with what was received for a particular deal. Here is th…

1 stone = 14 pounds i am trying to work out the average of some english weight measurements i have two fields stones pounds example 10 - 13 10 - 13 10 - 13 easy right, the average is 10 - 13 but now try this 11 - 7 11 - 1 10 - 12 10 - 13 i am really struggling with this one all the answers i get for similar problems to this are metric ie 10.92 i cant get the result to go past .10 to .11 .12 .13 any ideas

What would be the easiest way to have a date calc that adds six months to a date? 3/4/06 would result 9/4/06 Since the months have different lengths, a math one such as 6*30 is not working exactly right. Thanks Dave

Our company has a need to have a map of the office. This map would include all of the offices, cubicles, and other areas that are occupied by an employee or piece of equipment. These areas have certain data tied to them such as a user, PC, network ports, monitors, ect. For example: Office 220 has: User Network/Phone Ports PC Monitors All of the data I have stored into FileMaker. I'm wondering if there is a way to make a map out of my data. Attached is a simple example of what my map would look like. Thanks Office_Map_Example.bmp

I am designing a solution for mortgage broker.The main client table contains the client information for both husband and wife as well as birth dates. What I'm tryiing to accomplish is to find the records of all client names that have a birthdate due in the next 30 days. I will send them out a birthday greeting. I have tried a script If (Get (CurrentDate) ≤ Date(Month(Client::DOB_H);Day(Client::DOB_H) ;Year(Get(CurrentDate) + 30)) and Get(CurrentDate) + 30 ≥ Date(Month(Client::DOB_H) ;Day(Client::DOB_H) ;Year(Get(CurrentDate))) to select the information, but I don't know how to display the information that it selects. I'm also not sure if I should be displaying b…

I have been working on "days overdue" warnings for a layout. I think I have it operating now, but a customer has asked if he could set up an email or other warning to himself if the days overdue reading (which is a negative number when there are days to go and a positive number when it is actually overdue) reached a certain value (say, -30 days). I am not having much luck with the script or setup for such a function and would appreciate help. I do not have much knowledge of Filemaker and request that the steps be explained to me. Thanks for the help..

Is there a way to compare two tables of information in FileMaker and have it report any differences? Example: I have two tables of asset tags for inventory purposes (shipping & receiving). I want what is received to be compared somehow with what was shipped. Any ideas? View this post to see a more detailed explanation. Inventory Tracking Database

Could someone PLEASE help me work this out, it is driving me mad; In the address book I have a field where you choose the profession of the person you are adding (producer, director, casting director etc). On the PROJECT layout I have The fields where you need to fill in the name of the producer, director, agent etc. I would like it to be a dropdown list of all the names of producers in the address book when you fill it in. In other words I think I need to group people in the address book in order to make this work. If the person is not already in the address book I would like a dialog box which asks you if you want to add this person to the address book. Is thi…

I was grateful for the explanation earlier of the GetRepetition function and I have used this. However, I'm also looking for a way for the user to copy the data from a particular repetition to a non-repeating field. For example, Repeating field A B C D If the user clicks on D, I want the data to copy over to a non-repeating field. If I make a script to copy and paste it just copies the first repetition. Is there a way I can get it to copy the repetition that has the focus? Thanks. duckster

I'm having a brain fart that I can't get past over how to have a button made available on any given record(s) in a list view based on a particular field's value. Specifically, in the list, any record with field being empty I want a button to appear on that record. Solutions appreciated. Thanks for the mindshare...

I've encountered a legacy solution which uses calculations that look up fields from other files and the calc uses SYSTEM::fieldName. I'm not familiar with such a function. Can anyone elaborate? The solution is hosted via FMP 6 server, but getting ready for version 8. TIA, Stephen RAy

Hi, Not sure what I'm doing wrong ... I defined a calculation field as follows: GetNextSerialValue ( Get(FileName); "_kp_field" ) ... where "_kp_field" is defined as an auto-enter serial number. The calculation doesn't show any result (empty) (the data viewer doesn't show any result for this calculation either) I'm sure I'm missing something but I'm lost right now ... any help would be very much appreciated! Thanks in advance.

I recently upgraded this database from FMP6 to FM8 and am having the calculation not work as it did originally in FMP6. 1. I have a summary field Record_Count in table ECal that gives the total of records in the Found Set. Record_Count appears in the footer of the layout in list view. 2. I am trying to get the value of this field from another table Schedule to see how many records I need to manipulate in total. 3. I have a relationship between the two being ECal::Serial_Number = Schedule::Serial_Number_Temp and the relationship is named ECal_Serial I use the calculation: GetSummary( ECal_Serial::Record_Count; ECal_Serial::Record_Count ). It used t…

Hello all.... I have a portal with lots of records. How would I go about displaying how many records in my portal? Advice appreciated... I am near completion on my project, you have all been so helpful, I have learned so much in such little time. Many Thanks! Mike

If a product costs $1.00 if you buy 1-100, but costs $0.85 if you buy 101-250 and so fourth.... what calculation would I use here. Any help or advice appreciated! Thanks, Mike

I have a database with a non-trivial number of records which are non-identical duplicates, but should be combined or cleaned up in some way. For example, a record for "John Johnson 11110043" and "John Q Johnson 11120043" that turn out, upon further examination, to be the same person, mistakenly entered twice with an error in their primary ID # and a missing middle name. My question is, are there any "tried & true" ways of dealing with this. I've thought about some different ways: Combine the relevant data from record A and record B into a new record C, with a new ID number. Mark A and B as "obsolete" or "unused". Combine the relevant data from recor…

Assuming that I have a record with a portal. In the portal are values from 5 users -- their names and their scores (which means, 5 record in the join table). Is there a way to have the values RANKED - i.e., I'd like to have another field; calculation, I assume, that would 'rank' the values in descending order. I know I can pull out a MAX and a MIN value, but I'm looking for something similar to the "LARGE" function in Excel (where I can 'rank' the values from 1-5, with 1 being the largest and 5 being the smallest). Is there a way to do this without scripting (or, with a fairly easy, quick-running script -- I guess I wouldn't be opposed to entering the data and t…

Hi All, I need to figure out a way to limit the number of characters used in a field. Once again a pretty easy script I'd think but Im having a rather difficult time.

Has anyone experienced odd behaviors with 8.5 Advanced. I have a calc that has been through versions 3 to 8.0v3 and it has always worked right, now with 8.5 I get an incorrect result. If I open the same database with 8.0v3 I get the correct result. Here is the calc: Round(Round(Round(KENTUCKY FUEL USE BY TRK;0) * TAX RATES::KY TAX RATE;2) * CONTRACTOR DED RATE;2) + Round(Round(Round(KENTUCKY FUEL USE BY TRK;0) * TAX RATES::KY SUR CHG RATE;2) * CONTRACTOR DED RATE;2) + Round(Round(Round(GetSummary(TOTAL KENTUCKY MILES;TRUCK);0) * TAX RATES::KY MILE TAX RATE;2) * CONTRACTOR DED RATE;2) - Round(Round(GetSummary(TOTAL KENTUCKY FUEL;TRUCK);0)* TAX …

OK, I have another question. Is there a way to validate the data in a field as unique, but based on a set of related records in a table? For example, in my Contacts database, I have a separate related table for "Addresses", so that I can store multiple addresses for each contact. The records in the Addresses table are related to the Contact record by a "Client ID" number. Now, for each address record in the Addresses table, I also have a "Type" field to label each address (e.g. Home, Business, etc.). What I am trying to do is make sure that the values in that "Type" field are unique to that particular Client ID. So, Client "A" might have a "Home" and a "Business…

I have a contacts database that includes a separate table for addresses. This allows me to have multiple addresses per client. The addresses are all related by the contact's unique ID#. I have also included a simple "flag" checkbox to mark which address is the contact's preferred "default" address. However, I want that "default address" flag to be a unique value to all related records for that contact. So, they would only be able to have one address flagged at any one time. The validation options for making the flag "unique" apply to the whole table, not just the related records for that contact. So, if I use unique validation on the default flag, only one re…

Can some one give me a quick break down on the View As feature under window in script maker? Hoping to get a quick breakdown of this new function and its purpose. Thanks in advance.

FMP 6.0 question. I've got a repeating field of 20 repetitions. How can I take information from a certain repetition and move the data into a seaparate non-repeating field. I know I can copy and paste but I would like this to occur without the user having to do this. Any assistance would be appreciated. Thanks.

The setting: FMS 5.5 on Windows FMP 5, 5.5, 6 clients for 5-10 users on Windows Server and all clients appear to have adequate memory; network performance is strong. The problem: Sometimes, when a user views a layout that includes a portal showing join records in a file with a large number of records, FileMaker pops a "Sorting..." progress dialog, that counts down from a number in the thousands, then goes away. This is not surprising in some cases, since the portal shows records in a particular sort order, and there are a lot of join records, and over a network these things can take time. Here's the mystery: It doesn't happen all the time or for all u…

So, I have this really really big concatenated list of composer + songs here, sorted by composer. Some composers are tremendously prolific (a few of them have several thousand songs) and some are one-hit-wonders. I want to return the value number of the first and last songs of a certain composer, and I want them the fastest way possible in a calc. I can also see all the composers songs through a relationship, but there are duplicates in this set (lets say due to them being on multiple albums or something), none in the list. I can deal with workarounds, but they must be faster than dealing with the list which I already have on hand. I can not use a valuelist for …

Hi, I need to put the same dates (from a field) on two reports - one report is in English, one is in German. The English format should be "December 24, 2006", the German format should be "24. Dezember 2006". Any ideas how to solve that? Thank you Berny

Does anyone know how to get rid of the 'no found records' dialogue box? I hate the fact that my employees can (and do) press cancel when they need to be continuing the script that is running. thanks

Hi there. I am new to FileMaker and I had a quick question. I have a program that I'm modifying. I have a set of results and need to go through them one by one, and use two of the fields to determine if it is within a range. Particularly, I'm using coordinates to determine whether a point is within a given wedge (the wedge has a direction and an angle of inclusion). I have the math to do it, but I need to know how to iterate through the results and grab two of the fields. Let me know if you can help. Thank you Eamon

Hi... I was wondering where to begin with a few date equations which leads to 2 questions. First, I will post my question.... I have an employee database with start dates, etc. I would like to include how long an employee has been with the company.. either by number of days.. weeks and or years. I have a global date field of today to do the math against the start date, but not sure where to begin. Any advice is appreciated. Part 2... I searched the forum before I made the post...and I researched all Date functions as I was trying not to bother all you geniuses here. I realized.. I ask a lot of questions. Sorry... I am not trying tobe a pest... anyway, …

I come from a php programming background. I'm trying to do something in filemaker where the script would check if something exists, and if it does not, then carry out certain procedures. In php, it's a simple if statement like this: if(!$variable){ then do this; } Let me know if you can tell me how to do this, I appreciate it. Curt

This doesn't fall into the "complex calculations" category, but I didn't see a forum for "easy calculations." Here goes... We have an item which is sold in sets of 25 only. I want to validate the quantity field to allow entry only in those multiples. It's probably something like If(Mod (order_quantity, 25)≠X,1,0). With X being anything but a whole number. It's expressing that correctly that has me stuck. Thanks!

Your help would be appreciated to make the email function work. Using Scriptmaker I have an email button to send a copy of certain fields of a record to the recipient, but it will not work. I I tried telling it to make a copy using PDF and put it on the desktop, then email it from there, but it still does not work. Can someone show me a formula that works please?

What is the best way to remove a decimal...such as 8.5 return "85" or 17.75 returns "1775." I started using "Left" and "Right" and "Patterncount" and such, but do not have the best knack for this stuff. So if anyone has a few minutes.... much appreciated. Mike

I thought I had this working but no... I want to display the days left for an action, using fields to enter the Due Date for an action, so that the Days Overdue will be displayed. The calculation I am using does this for only the day of entry, whereas I need it to update daily and show a continuous readout of the remaining days before the action is completed. I would also want it to stop calculating from the current date and firm up on a third entry field, Date Completed, so I have a record of the days overdue when it is finally done. So the calculation is not updating automatically each day, but freezing on the date that I entered the initial value, and it is not r…

Hi, Can anyone help get me started here...I have a small business importing and selling goods. I have got FMP pro 8 and would like to create a database to record purchases from my supplier, auto add to inventory, record sales to customers and auto subtract from inventory. Not much else really...sounds simple? I have looked in the documentation and cannot find out how to update inventory. The Business Tracker is nearlly there apart from no Purchase module & does not update inventory...pretty basic omissions i thought.

Are value lists web compatible? I think they are, but would like to be 100% on the subject before I begin use in a layout. Otherwise, I guess I make separate databases.

I have table 1 field 1 formated as text and the source of the value is imported via script from a .csv file and "n" quantity of records where "n" > 0. The only two possible formats for values in field 1 are... xxx, xxx xxx, vvv or xxx, xxx xxx (xxx), vvv where x equals any alphabetic text value, vvv equals any positive integer, and the spaces are exactly as written. I have to reduce field 1 values from their current format to: A. In the first case, remove everything after and including the second "," B. In the second case remove everything after and including the first "(". I know i can.... go to correct layout go to first record start loop…

I have an address book, with two related tables. In each of the related tables, I have a value list populated by a calculated field in the AB table. Is there a way to have the drop-down list populated in the related tables, but then allow editing of the value list with a new value if entered by the user?

Hi all, I have been staring at this too long and can not quite figure out if it works or not yet. An outside view would be very handy. Problem: I want to combine multiple sets of a multiple number of elements such that each new set will always contain at least one element from each of the old sets, and each element from an old set will have at least one instance in a new set where it is the only element present from the old set. Ok, how about a (semi)practical context: I want to be able to return multiple multi-criteria sets in a portal at the same time. Say, all Female customers from New Haven and all Web customers from New York. However, I do not k…

I am debating with my IT department on final Database Setups... we disagree on setting up multiple table in one file or making multiple databases. The databases are to organize a print company with everything from Job Tickets, Invoicing, Quotes, Contact, Purchase Orders, Etc. I am opting for multiple tables... primarily beacause of ease of programming. I just wanted to collect as much oppinion on the matter to help make a final decision. Many Thanks! Mike

My dilema is this: I am using a value list to put my records into categories. The trouble is that some records fit into two or more categories and I'd like to be able to set them as that. It has to be in a format that will allow me to modify the categories (value list) and freely assign them. Unfortunately this categories are constantly being updated. Any thoughts on how this could be achieved?

I am struggling with a simple calculation. Dealing with standard Invoice Stuff.. QTY x UNIT = EXT Here is my EXT formula now... If ( UNIT = "" ; "" ; QTY * UNIT ) This make it so that I do not NEED a unit price.... I also want the reverse... if there is no QTY; EXT = UNIT Something like that. The reasoning... if someone orders a product and it is specially discounted, I want the list the QTY and Description and return no cost value or unit cost. On the Next line... we'd usually put "AS ESTIMATED" without a QTY and add the unit price. Therefore, UNIT SHOULD = EXTENDED PRICE when there is no QTY. I hope that makes Sense.... I am attac…

I have a calc that uses the Evaluate() function but I am unsure as to why the syntax is the way it is... [color:brown]Evaluate ( "Get ( AccountName ) & " " & Get ( CurrentTimeStamp ) & " " & ...etc Why is it not [color:green]Evaluate ( Get ( AccountName ) & " " & Get ( CurrentTimeStamp ) & " " & I was told to use the former syntax but I am confused as to why there are the slashes there.

OK... I have a contact database and a job database, their relationship is the contact id #. If I am in my contact database and hit the magic button to make a new job... I jump to my job database and all necessary records are in place. Suppose I am at my job database and and want to change the client. Since the relationship is based on the contact id... yes, I can change that field and alter the clients info, but, that would require going to back to the contact database, finding the contact I want, memorizing or copying their id, jumping back to the job ticket and chaning the number.... a lot of steps... I am wondering if their is an easier way. I am playing with…

Hi All, Ok so im not sure if im just having a non-brain working day!!...but i have a number field where users enter the number of items they require. I want to then below this show the number in text fromat. E.g. Number field the users enters 10000 I would like the text calculation field to show 'Ten Thousand'...is this possible?... Thanks.

I stumbled accross something curious the other day while reading god knows what documentation already regarding filemaker. The point is, calculations that utilize the GetNthRecord( field ; rec# ) can be stored calculations. The only issue is making it refresh the value, perhaps by using the evaluate function on a local field (tried on a foreign field, calc goes unstored). But if someone can work out a way to exploit this in calc's let us all know - it could mean being able to go backwards over relationships where otherwise not possible. Cheers, ~Genx

What I have is a value list that I use to categorize records. Each of these records also has a length of time in minutes:seconds associated with it. What I'd like to do is to have the DB add up the total of the times for all the records in each category. ie; Category A = 03:02 Category B = 01:22 and so on... I know this should be easy, but my brain is stuck at the moment. Thanks in advance for your help.

I have a database where a user can enter an amount of time (mm:ss) for each record. Within that record I have a value list that shows up in the form of a check box. The value lists obviously only has one value. It functions as a check box the user can use when completing a certain phase. If it's checked that phase is done. What I'd like to do is to make some sort of calculation so that the user can observe the total time (mm:ss) remaing amongst all the records. So as the user checks off a phase for a record they would be able to see how much time is remaining amongst all the records. I'm guessing it would start as an if function, but I'm not sure. An…

Sorry if this post is in the wrong place.. Anyways is there anyway to have a Hyphen ("-") as a value in a value list? In the dialoge box, to the right, it says that adding a hyphen on a line by itself will add a line to a menu. Is there anyway to make the hyphen a value itself? I know in java is a special character and if you want to print out "" you have to code "". Is there any such trick that filemaker can understand?

OK, I'm trying to right a script that needs to check several things. But I'm not sure where to put the end loop or at least that's the error I get. If[ Pattern count (warehouse Main::Plated for;"236")] exit script Here is where I get lost. I now need to check another field called Main::Plated_Location[4] It needs to check and see if has 629 or 840 if 629 do one thing if 840 do another. If[ Pattern count (warehouse Main::Plated_Location[4];"629")] Cut warehouse Main::Plated_Location[4] Past warehouse Main::Plated_Location_629 exit script If[ Pattern count (warehouse Main::Plated_Location[4];"840")] Cut warehouse Main::Plated_L…