Calculation Engine (Define Fields)

About the data. I have 1 table that contains current ownership information about real property and the date it was purchased. Each piece of real property has a unique account number. In a second table I have prior ownership information about the real property, if prior ownership records are in existence, then the account number exists and the date the owner bouts the property is recorded with the owners name, address, ect. Some property records have no prior owners, and some have several, in those instances the unique account number from the first table will be present in the second table somewhere between zero and several times. To make sure this is clear table 1 ha…

Can anyone take a look at this and tell me i am on the right track relationships are correct What can i do to improve this? trying to also based product(s) selected ask for different attributes. DOnt really know what to do there yet. thx, -i start_over Copy.fp7.zip

Dear all, I am having an issue about how to count a sub-summary header but yet I forgot how to do it. I attached a small example file. Please take a look at the "Print Layout" layout. In there, I would like to see total customer. Manually, it would be counted as 3 customers, but how to do it in calculation? Thank you for help and suggestion. As usual, if this has been discussed before, please let me know the link and I can read and learn it. Thank you. Test.zip

I have been searching and all I can seem to find is how to calculate someones age from a birth date. What I would like to accomplish is a field that will show the upcoming birth date. Example: We have a D.O.B. field 9/10/1950 on the main layout. I need a field to display the approaching birth date for the current year 9/10/2011 Then next year the field would show 9/10/2012 and so on for each following year. With my minimal knowledge I have tried every calculation I can think of, all to no avail, all I can seem to do is add day to the current birth date. Can someone help with this matter? Thank you, M.Logan

I am currently working with a solution that was developed on a previous version of FMP. Some of the primary key fields in this solution have been set using the Get ( RecordID ) command and I'm trying to think of the best way to fix this. About the only way that I can think of is to capture the original primary key and then generate a new key using either a serial number or a UUID function and then find every related record in every table across the solution and replace the original key with the newly generated one. This seems a laborious task at best. Am I missing something or is this realistically the only way to fix this issue?

Hi everyone, I using summary fields almost exclusively over Sum() calculations for a few reasons: One summary field can be used if placed directly onto any related layout whereas a Sum() calculation is only good for the table it is created in. Aggregate calculations such as Sum() are more resource intensive. I experience less flash with summary fields over Sum(). The only time I use Sum() is if I need to manipulate the values further. Summaries can filter if placed within filtered portal single row - Sum() can't. But I would like to get opinions of the top Developers here as to when they use one or the other and why. Thank you for any input you can pr…

Ive done some searches on copying records across tables but have been unable to do so successfully. Im working on a recipe database that has a few tables that are related: Recipes Recipe_LineItem ProductionRecords Production_LineItem My relationship is as follows: Recipe_LineItem --> Recipe <-- ProductionRecords <-- Production_LineItem A bit of information on the setup: The Recipe layout contains a field for recipe name and a portal to Recipe_LineItem. Each Recipe_LineItem is an ingredient for that recipe. The ProductionRecords database has a drop-down filed that contains a list of all the recipes from the Recipe ta…

I have a part number that needs to be broken down to populate other fields. For instance the part number TE5A needs to broken down where "T" represents the manufacturer, "E" is the row the part is in and "5A" is the bin number. The problem I'm having is when we run into a part number such as TBB15A where "BB" is the row and "15A" is the bin number. Any ideas on how I can break these down?

I have a book database with individual and unique bookIDs for each title. This bookID field is auto-entered by calculation of first two letters of title, author, publisher and price. bookID=Middle(title;1;2) &Middle(author;1;2)&Middle(publisher;1;2)&GetAsNumber(price) This bookID will also be used as a SKU number which prohibits empty spaces. This presents a problem for titles such as "A Day in the Life of Ivan Ivanovich" which yields a bookID of "A SoPe5". I would like to substitute the empty space with an underscore, e.g. "A_SoPe5". Is it possible to achieve this within the auto-entered calculation or will I need to run a script, perhap…

hello everyone. I need some help with a calc. i have a field namefirst in this field it is filled with the name DOE JOHN i need to move the name DOE to namelast field sure this is simple but having a hard time understanding. Thanks RT

I have created a field called Current Semester with the following calculation: If (Get ( CurrentDate ) ≥ Date ( 7 ; 1 ; Year ( Get ( CurrentDate ) )) and Get ( CurrentDate ) ≤ Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) ); "First"; If (Get ( CurrentDate ) ≥ Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) )) and Get ( CurrentDate ) ≤ Date ( 6 ; 30 ; Year ( Get ( CurrentDate ) ) ); "Second";"")) My computer clock is set at 8/28/2011. Of my 519 records, 20 say "First" and the rest say "Second". i do not understand why all the records do not say "First". Thanks for any light!! Rachael

FM 11, Adv. I have a field for dates and I calculate the year for each date with the Year function. To determine the maximum and minimum years in the field I use the Max and Min functions on the year field. I store them both as globals. The Max function works, but the Min function does not. It returns the maximum value. Any suggestions.

I have this conditional formating calc. (ProcessTracking::P10ReviseDate >= ProcessTracking::P10PlanDate &#8211; 7) and (ProcessTracking::P10ReviseDate < ProcessTracking::P10PlanDate) The complaint is with the "P10PlanDate - 7", how do I subtract days from a field. In a previous iteration which was doing the wrong thing but worked was...... (ProcessTracking::P10ReviseDate > Get ( CurrentDate )) and (ProcessTracking::P10ReviseDate &#8804; Get ( CurrentDate ) + 7) Thanks Michael

Hello, Would appreciate anyone's thoughts on the following issue please... I am creating a simple field whereby a user inputs a date into the 'Membership Start' field and then selects either Annual / Monthly / Daily from the 'Membership Type' field. There is then a case function which adds a year, month or day to the 'membership start' date and puts the result into the 'Membership Expiry' field. The calculation is as follows: Case ( Membership Type = "Annual" ; Date(Day(Membership Start) ; Month(Membership Start) ; Year(Membership Start) +1); Membership Type = "Monthly" ; Date(Day(Membership Start) ; Month(Membership Start) +1 ; Year(Me…

How could I strip paragraph(s) of all line breaks? For example, turn: ~ QTY: 1,500 COLOR: Full color front and back SIZE: 8.5" x 11" DEADLINE: ASAP ~ to ~ QTY: 1,500 COLOR: Full color front and back SIZE: 8.5" x 11" DEADLINE: ASAP ~ Thank you for your time. Much appreciated.

Hey everyone, i have a field that acts as a unique identifier (audit lot#) to each record and i know i know just use the auto-enter serial number, but in this case it is not sufficient. Just to clarify so i don't receive the wrath from the filemaker faithful this audit lot # does NOT act in anyway as a primary key, i am using the proper auto-enter calculation for this! The person who the solution is being built for has been using this particular serialization format for 10,000+ years or whatever and doesn't want to change, so who i am to say otherwise! Basically this field is built out of the records name field...being that it takes the first letter out of the firs…

I am attempting to set up a "calculator" / progress tracker into my database. Basically speaking, I will use this for the "Debt Snowball" method. Say I have account A, B, and C A has $100 minimum payment $25 + $25 extra B has $200 minimum payment $25 C has $300 minimum payment $25 1st month - Payments: A = $100 - 50 = $50 B = $200 - 25 = $175 C = $300 - 25 = $275 2nd month - Payments: A = $50 - 50 = Paid B = $175 - 25 = $150 C = $275 - 25 = $250 3rd month - Payments: B = $150 - 25 - 50 = $75 C = $250 - 25 = $225 How can I calculate / track this to see how long it will take, the …

What am I missing? I've tried to break the string down to make sure it's correct but I get the default every time.... If it matters both the referenced fields are calculations. field1 is a date field field2 is a text field Modified for viewing: If ( ( (IsEmpty ( table::field1 )) or (IsEmpty ( table::field2 )) ) ; "X" ; "" ) Thanks......

I have a table with field 1, field 2, field 3. I am trying to figure out a calculation to return either field 1, 2, or 3 based on other field values in another table. This is kind of like picking values out of matrix where the vertical is the records and the horizontal is the field 1, 2, 3 in each record. Does anybody have any experience with this?

Hi all, I have been given a filemaker file that has only first and last name fields. In several hundred records the users put people's middle initials in the last or first name field, sometimes with a period and sometimes without. So they look like this: FirstName: "Frank" LastName: "T. Doe" FirstName: "Frank" LastName: "T Doe" FirstName: "Frank T." LastName: "Doe" FirstName: "Frank T" LastName: "Doe" I am trying to put the middle initial into its own field and remove it from the other name fields, but I am not quite getting it. Thanks in advance for any and all help!

I am concatenating a name in a function and need to include quotes, tried the slash plus chacter following but that does not in Filemaker. What si the proper way to escape characters? Thanks.

HI Any one can help me on this, we have this postal code go like below. We need to count the postal code on 37, 38, 40 and 41. Eg. for 370090 to 370099 total is 8, for 380011 total is 1 and for 408825 to 409286 is 5. The first two number is the postal code. I did create a file for that. Thanks 370090 370092 370092 370093 370093 370093 370093 370099 380011 408825 409042 409042 409044 409286 410102 410104 410108 410109 410110 410111

I have build a database for tracking my customers and leads, however I use it on three different computers. Office, home and on my net book when I am mobile. I have been using a thumb drive to be the mule between the computers and I keep the most updated on the thumb drive which works OK, but sometimes I forget to replace my database with the most recent copy and start updating records. So then I am left starting all over again because of my over site. and I am also scared that one day i am going to reverse an update by mistake. Is there anyway to make the program sync? So that it would only take an update if the info was newer than what it already has? Example: on my wor…

I'm working on a donor/donation tracking application for a K-5 school PTA. I have a donor table and a donation table with a primary key DonorID that is a foreign key to the Donations table (one to many) In the Donations table, I have the fields DonationDate, DonationAmount, and a calculation filed DonationSchoolYear that is defined as DonationSchoolYear = Year ( Donation Date )-(Month ( Donation Date ) <7) In the Donors layout, I have a portal field that displays the related Donations records for the current Donor record. Below the Donations portal, I have 3 calculation fields, CurrentSchoolYearSum, PreviousSchoolYearSum, and TotalDonationSum. T…

hi, I apologize if this has been asked and answered before, I haven't been able to find a solution. I need to concatenated multiple related records into a single text calculation field on the parent table/layout seperated with some delimiter I have a FAMILY table with a primary key FamilyID that joins to the CHILDREN via FamilyID Given a record in the FAMILY table and 3 related records in the CHILDREN table,the calculation field should have the value: Thomas;Matthew;Kathryn Is there a function that I can call to lookup all related records? thanks in advance for your assistance. Sincerely, William

Hello, I gonna need help for the following. I turned it around several times, but cannot get a result. I have two files, one helicopter database, and one registration database linked by a helicopter ID. I would like to regroup all registrations having the same helicopter ID in one single field in the database registration or in the database helicopter (the simplest will be great). The field storing registration is a text field, the helicopter ID is a calculation (concatenate of three other text fields). Writing this I realize it could be used in many other applications. Any help will be very much appreciated, for both the teaching and the so…

Not sure the best way to handle this relationship or repeating field.... A have an assets table, a transactions table and a lineitems table.... An individual can checkout an item or reserve an item. The way I did this is to set a value to lineitems::TransactionStatus to "1" for checkout and "2" for reserve (and "0" for in stock) When an individual attempts to checkout or reserve on a specific date, I use a find request and set the value to: -For checkout: Get(current date) and "1" which will see if it checked out or in stock or -For reserve: ReserveDate and "2" to see if it is reserved for that date - (and they are not allowed to reserve on the curr…

Hello I am a total newby on filemaker. i have a table that is designed to a debits and credits field in a list. I use the summary function to addition all of the credits and another to addition for the debits. I have a 3rd field summary field that gives me the total difference of both fields. Obviously, this running total result is repeated in each table entry. I am struggling to have a running total where each entry progressively adds or subtracts from the sum of all the previous entries. This would give me a result like a bank statement, telling me what the consequences of each entry are on the sum up until that point. I am not sure how clear this is, but in e…

Hi, I've got a problem with some data coming in with a line break I can't remove. When viewed using GetAsCSS it gives the following code & # 8232 ; rather than the expected <br> character of standard line breaks. This is a problem as the record is not parsing in XML so I need a away of removing it in FM. Has anyone come across this problem and do you know a way of removing this from a text string? I've attached a single record which I've copied from a much larger database. This problem is popping up randomly across a number of different fields - and is really difficult to spot when simply viewing the records I can use substitute & # 8…

I'm struggling with formatting the date correctly ... I need the date and time to come up in a calculation with leading zero's in it. I can make it look right in the record via the formatting functions, but when I try and take the date or time from that field and combine it within a calculation, it's dropping the leading zero's. Same thing happens when I use the getdate function. I have a script that strings it all together to form a file name, and I have to keep the zeros. What am I missing? example: I need the timestamp (or a date and time field) to output 08_04_11 for August 4, 2011, not.... 8/4/11. Thanks for any guidance... steve.

Hi all, I'm very new to filemaker. What I'm really struggling with, is that I'd like to set up a server for my database, but I need the data, after its been entered on a client computer, to go through another specified client computer and be checked (by one of my employees for accuracy) before being applied to the database. Is there an easy way to do this? 1 million thanks! Matt

I'm trying to set a logical function using this parameters: Case(Quantity ≤ 99 and Code="CFI-WW";"One"; Quantity > 100 ≤ 199 and Code="CFI-WW"; "Two"; Quantity ≥ 200 and Code="CFI-WW";"Three") It works perfect with the first two but if I enter 200 or more nothing changes. Thanks Gian

Okay, I've wrestled with this niggling problem on and off for a few weeks and admit defeat. I have a Parent-Child set up with a Child-creation system set up from the Parent context. The user fills out a few global fields and then presses a "Create" button that goez to the child table, makes a new record, enters the global values into the appropriate fields, and then returns the user to the parent table and clears the global fields for another go. One of the global fields is for a Child ID#. This number is a classic museum Accession Number of the format YYYY.#### -- so that in any year, the museum can assign 9999 unique numbers 2009.0001 2009.0002 …

HI All friend i am new to this and working on my Database. i have 10 clients and every client got their own value (ie "CO" for Coke), I have one block who got the Drop Down menu for selecting 10 client as Co, NA, AA, etc. beside that i am generating the Unique ID (000001) and Beside that Project Name: I Got One table name "Project" ------------------------------------------------------- | CO | 0000001 | Project Name | ------------------------------------------------------- "First" Field would be drop Down "second" is Automatic and third is type the project Name Question 1: How to create a unique I…

Is there a way of preventing a drop-down list from going to the next tab field without deleting the tab order - I want it to stay in the drop-down field so that I can set a variable to the newly selected value. I cannot use a pop up because I also need to record the current value of the field. If I delete the tabs it works but I would like to be able to tab to the next field as well - sort of have my cake an eat it situation - don't know how I turned on the italics or how to turn them off cheers Roger

Hello, For a few years I've had a great contacts database I made in FileMaker. Contacts where one of several types but the most special type was customers. Customers were assigned a number "Customer Number". Since there were a few types of records, I could not make customer number an auto-entered number, rather I had a Global field with a number in it. When a contact became a customer, I clicked a button which would copy this Global number, paste it into the Customer number field and then increment the global number by one. It worked for years. But now it's broken, and I think I know why. I just opened the FileMaker database up to two other people who work wi…

Hi all, i am not sure whether to post this here or in the Managing Scripts forum. Anyway, I have a Maintenance Database with an Email script set-up that when clicked sends an email out with a request order. In the body of the email is 6-7 fields/data pulled from the Layout. I have the subject line set up as: "Maintenance Request: " & Get (CurrentDate) I added a new field to the table/layout "Priority". This is a Yes/No checkbox that defaults to "No" What I want to do is, if the checkbox is set to "Yes" I want the Subject Line to go from this: Maintenance Request 8/5/2011 To this: Maintenance Reques…

Is it possible to to timestamp when a field was last edited rather then the whole record? Thanks

I know this is simple, but I can not find the answer online. My current date is showing m/dd/yyyy. Need to be mm/dd/yyyy

Hi All, I want to calculate the due date of payment for products received based on the supplier terms. All of the terms are based on a period of calendar months following statement date. so I have the following: Date Received, this is a calculation field based on the product type i.e. if retail then it is the actual date received or if consignment then it is the date sold. Product Terms, this is a lookup from the products table and is in months i.e. 1 or 2 or 3 Due Date which is where I want to calculate the date. what I tried is this Date (Month ( Date_Rec )+Terms;0;Year(Date_Rec)) which is a total ********. I need to return the last day of the month …

How do you count the letter within a field? Also can I do an if statement that changes the color of this field. ie. red. Thanks in advance.

A couple of years ago I found a TextMate* bundle for formatting FileMaker calculations, but now I can't find it. Can anyone point me to it? *TextMate is an excellent text editor for Mac. "Bundles" extend it sort of like plugins for FileMaker.

Hello all, I'm attempting to create a navigation menu that i can use in my layouts for the first time and am having some difficulty which i hope is just an oversight on my part . I found the following article online on how to create a basic menu and have been using it as a reference: http://digitalfusion.co.nz/weetbicks/build-a-navigation-system-part-one--starting-out-simple/37/ I have a table (navigation) with 3 repeating fields: Icons - Container [7] - Global Labels - Text [7] - Global Layouts - Text [7] - Global I've created a new record in this table and placed 7 images into the Icons fields, added a label for each and 7 layout referenc…

I'm playing around with the Time Cards in the Starter Solutions ... which uses the dreaded repeating fields Is there a way to sum just some of the repeating values eg if there are 14 repeating values (1 for each day of a fortnight) but I only want to add up the 1st week ie values 1-7. I've done it with this convoluted calculation Evaluate(Left(Substitute(List(Hours_Leave);"¶";"+");Position(Substitute(List(Hours_Leave);"¶";"+");"+";1;7)-1)) but i thought there should be an easier way ..... as you might tell, this is my first play with repeating fields :-( thanks

Sorry I didn't know where to put this. I have 3,500 records with one field that is used for a purchased date. This person used four numbers for each date such as 0793 represents July 1993 or 0411 equals April 2011. All records have this four number format, first two are month and second two are year. I can't figure out how to convert these four digits into a some sort of date field like 07/1979. I tried 'find and replace' but couldn't get it to work. Any help would be appreciated, I don't want to type in 3,500 dates. I'm converting a friend's baseball card inventory from a 1980's DOS machine to Filemaker Pro.

(This is the closest sub-forum I could find to match my query. I'm asking here, because I'm talking about standard FMPro 11 -- not using it via the web interface.) I'd like to be able to paste number of lines of text into a notes field and then be able to click on urls randomly interspersed within the field and have the links go somewhere live. Is there a key command combination or a plugin that will allow me to do this? So far, the only way I've been able to find for making FMPro link to the web is by creating a button with that function.

I am running a simple Show Dialog to troubleshoot one of my scripts... If I run this calculation: "Case ("10/10/2011" ≤ Month(Get(CurrentDate))+1&"/"&10&"/"&Year(Get(CurrentDate));"True"; )" I get "True" If I run this calculation: "Case ("9/2/2011" ≤ Month(Get(CurrentDate))+1&"/"&10&"/"&Year(Get(CurrentDate));"True"; )" I get "" How does that make sense? I even ran: Month(Get(CurrentDate))+1&"/"&10&"/"&Year(Get(CurrentDate)) And got 9/10/2011 So I know that at least FM is seeing the date it should.... What am I missing here?!

HELP! I DO NOT KNOW HOW TO ALLOCATE PAYMENT PORTIONS TO DIFFERENT AREAS OF REVENUE STREAMS! At our K-8 school, we've got an FMP DB that's been in production for a few years. It has always been a single table DB, and was used primarily as an online registration tool for parents to check over the info we have on file for them in our Student Information System (PowerSchool by Pearson). The reason I used FMP is because it was much easier to set up than to try to make PowerSchool do what we needed it to do. Last year I was asked to track student fees in the DB. No biggie. About 1/2 way through the school year, I was asked to add a payment component. I see wha…

2012so.fp7.zip I'm trying to make a calculator, where I've designated 38 States + DC as being safe for a particular party (all going the same way as 2008, except one EC vote from NE's 2nd CD, which I give back to Republicans), and now I want to be able to enter percentage chances of the Democrat winning each of the 12 remaining states, and have the filemaker database figure out the odds of the Democrat winning the whole election, based on those percentages. I have 12 number fields, to enter the percentage chance of the Democrat winning each of the 12 states in question, and one calculation field, to determine the percentage chance of the Democrat winning the w…

Hi there, I have a checkbox list of items (30 or so), where the user can check multiple items for a record. With each item, there is an associated number with it in the table, (not visible in the checkbox). For example: Item1 4 Item2 12 Item3 24... There is a field above the checkbox that I want to automatically populate with the LARGEST number chosen. For example, if the user checks "Item1" and "Item2", the number "12" would populate in this field. Anyone know what the calculation for this would be? Again, the items and the associated numbers reside in the same table. Thanks

Hi, Does someone know if there is a custom function that can copy a field from a child table to a repeating field? The child table field is a container. I need this because it's not possible to put a portal in a portal... Maybe I could create a recursive custom function using GetNthRecord, but does this function works on containers? Thanks

Hello, I'm trying a calculation field like this : myStyleText = GetASCSS(myText) myText contents is this : ========== Hello this is a test ========== (3 simple lines with left, center and right alignment) my cacultaion field doen't show anything (about align) ========== <SPAN STYLE= "font-family: 'Verdana';" >This<BR>is a<BR>test</SPAN> ========== No align tags in the code. Forcing another style (bold, italic...) in some lines, adds the align tag, but "for me" this is "weird" --- Excuse my english)

Hi All Please help me out from this peculiar thing.... I am having a layout on table ,say, A ,. Let the layout name is "A-Layout" . This layout has calculation fields from table A. But the calculations definition are based on Table B and Table C The relationship are below. A-----------B----------------------C----------------D I am having another layout on table ,say, B ,. Let the layout name is "B-Layout" . This layout has calculation fields from table B. But the calculations definiti…

I'm trying to use the new 2 D bar code PDF417. I've downloaded the font and encoder but I'm unable to get it into my filemaker system so I can choose it. I've put all the 2 D fonts into my font folders. It's just not coming up. Any ideas.

Hi all, I hope this is the correct area for this. I have a database where potential clients can email me for a quote. The emails that are generated from the quote are just raw text and look like this: --- Name:..... Joe Smith Title:..... Managing Director Company:..... Acme Group, LLC Address:..... 1234 Main Street City:..... Los Angeles State:..... CA Zip-Code:..... 90049 Country:..... United States Email:..... [email protected] Phone Number:..... 123-456-7890 Additional Comments: Please call me immediately. --- I usually MANUALLY copy/paste the info from the email into the various fields of my FileMaker database. For example, so…

I need to create a field that is a calculation. I want to determine quarterly data from monthly sales data. Current table has-- rec id Date MonthlySales 1 1/1/2011 20,000 2 2/1/2011 15,000 3 3/1/2011 8,000 4 4/1/2011 10,000 5 5/1/2011 7,000 6 6/1/2011 15,000 7 7/1/2011 8,000 Let say I want Q1 Sales for 2011--I want to create a calculation field that calculates 2011 Q1 results. Example: So, some how I need to look at records 1/1/2011, 2/1/2011, and 3/1/2011 and average those amounts. ie. (20,000 + 15,000 + 8,000)/3 Therefore the resul…

I want to make a column of pop up fields that one could scroll up and down, so only the first few fields are immediately displayed (like a portal). The only scrollable fields I can find with google say to use a edit box, as in writing text in the field/box, but I want separate fields. is this possible? Say I want to log the top 10 times in a track & field race, plugged into 10 separate fields, but i only want the first 3 immediately displayed, then one has to scroll below them to see the next 7.

Posting here tentatively, as the topic may belong in Relationships or Portals, here goes: Two tables joined by SerialID Number. Table One focuses on Employees By Name, Table Two on Tasks (Manager, Shift Supervisor, Shift Employee, etc). Employees and Supervisors change shifts from time to time. Here's the question: In Table One, is there any way to format a field (or portal) that will automatically show who's his/her latest Shift Supervisor? In Table One, every record has a portal with value lists that modifies the records in Table Two, which has a Calc Field that spits out a number according to shift and duties. Let's say in Table Two, due to his shift …

Ok here's the challenge. Let's say I have 3 timecode fields in a record. TCIN TCOUT TCDuration (all this timecode stuff works perfectly thanks to this forum BTW:) I want to be able to have FMP10 automatically copy the TCOUT into the NEXT record for the TCIN. For example: Record 1 TCIN TCOUT TCDuration 01:34:56:15 01:35:56:15 00:01:00:00 Record 2 TCIN TCOUT TCDuration 01:35:56:15 I can get it to where it would copy the SAME field across records but not different fields. …

I'm trying to get a calculation to tell me if a pricedate is over one year old. Reason if a price date is older than one year we have to update the price. Currently we have to look back to our part index everytime. I'm wanting the calcualtion function to get the date and give me a yes or no if the date is older than one year. Can anyone help me on this calculation. I was thinking something like this to start with. If(SubWorkOrder::PRICEDATE1) < (Less than one year here) "NO" ; "YES" )

Im a bit stuck on this one See attached File... I have a portal that show "Alexandria" "Alpine White" etc I want a calculation that returns "Alexandria" = 2 "Alpine White" = 1 "Champagne Pearl" = 2 etc These name "Alexandria" are dynamic Any ideas Thanks Tim Canberra Australia PotalScreenDump.tiff

Apologies, as this is no doubt simple, but I haven't figured out the vocab for an effective search, hence my question: Project Table project serial # Event Table project serial # event date event detail There are multiple Events/Project. I'd like a calc field in Project to string all the related Events as text (event detail1, event detail2, event detail3, etc). What could be easier? It would preferably deal with commas, and would ideally put them in the right order (reverse chrono), but for now I'll take ugly and alpha if it works. Many thanks in advance, /capisco

Hopefully someone can help me with this. I have two tables (Property and Report) related by id number. So one Property has many Reports. Reports have a creation date field On the the Property layout, I want to display the number of reports which fit a date range. I have date_start and date_end global fields on the Property layout/table for this purpose. On the REPORTS table I have the following calculation called MATCH_DATE_RANGE = If ( creation_date ≥ PROPERTY::date_start and creation_date ≤ PROPERTY::date_end ; "1" ; "" ) So if the creation date falls within the dates specified on the PROPERTY table the result is 1. I then…

Hello everyone, Kindly share how to convert next month in Text. Thank you very much thong

how to speed up a report containing a lot of fields having unstored calculation fields and the calculations field contains definition of other calculation fields

Good morning. I am building a sports league results listing with a large number of teams. I am trying to use a variable in 'Set Field By Name' to write another variable into a field. My field is a repeating field i.e. MayGro[1]. I use a routine to calculate the first 6 letters of the field name which I call $homeaway and then append the repetition number. My line looks something like - Set Field By Name [$homeaway & "[1]" ; $r1] (where $r1 is a variable holding the home team's points for this game). It doesn't work. I am a real novice at Filemaker and am hoping that someone will be able to see where I am going wrong. Also why does the 'value' step…

Hi All, In FM11 How can I create a pop box that allows me to duplicate a certain record x amount of times. I put 5 in the pop and it duplicates a certain record 5 times. Thx MG

Is there anyway to get a checkbox fields list values to multiple fields? Field A: One¶ Two¶ Three Field A1: One Field A2: Two Field A3: Three

Greetings; I have a database that has the following information stored * Full Name * Street Address * Surburb * Home Phone Number * Mobile Phone Number * Number of Time Called * Call outcome What i want to do is make it so that up the top it will count the number of records that have the Call outcome of "WARM" for today and also for the week. Sounds simple, but i cant seem to get it working anyone have any ideas ?

Hello, J need to make calculation how much litter born by month in different year(2000-2011). J have table DOB .How do I have to set up this field?

I'm having a heckuva time with this, and am hoping someone can lead me in the right direction. I need to be able to remove everything in parentheses on the first line of an address. For example: A-A ADL Transcription Services, Inc. (East Islip) 3132 Union Boulevard East Islip, NY 11730 should display in another field as A-A ADL Transcription Services, Inc. 3132 Union Boulevard East Islip, NY 11730 The entire business name and address are contained in one field called Service_Address. I can't figure out how to write the calculation. Thanks for any help you can provide. Kevin

I wish to Trim Left leaving whole words only for a field that has a character limit of 62 characters. I don't want to have whole words cut off because of the character limitation, for instance: Dog Cat Horse Du should come up with Dog Cat Horse even though it is less than the character limit, I need the complete word. I am using just the simple Left(field) and it is working fine, it would just be nice to have complete words as incomplete words don't help anyone...

My FM solution has 2 related tables, one that contains Cues and one that contains Composers. The cues have a primary composer and a secondary composer, which is combined and related to the Cues table via a calculation field using List(field) function. Everything is returning fined, but is there an elegant way of sorting these values in the calculation to always the primary composer first and the secondary composer second? Substitute(List(Composer::Fullname); ¶; " / ") Thanks, d

Hi all, I have container fields which are populated via a text field. If the text field contains the value that is against the graphic that graphic is brought up in the field. So i have two container fields and text fields LEFT FITTING and LEFT FITTING ACCESSORY. when the left fitting text field has "TL 426 "The required fitting is inserted to the container field. Now if i go to my left fitting accessory field and select "DUST CAP" the graphic comes up but there is a clash and i see two graphics overlapping! The selection of TL 426 is still there. Is it possible to say if left fitting contains anything but "NONE" clear LEFT FITTING FIELD? then if none …

Hi Folks, this one has me stumped, and was wondering if anyone can offer suggestions on what is missing? Here is the code with comments stating what is happening: # capture selected signtype IDs Set Variable [ $SigntypeIDs; Value: SIGNTYPE::_kg_STKeyHolder] Go to Layout ["quote_QUOTELINEITEM" (quote_QUOTELINEITEM) ] # loop through values and create quote line item records # next step is there just to see values for debugging Show Custom Dialog [sIGNTYPE::_kg_STKeyHolder] # at this point the values are there Loop # next step is there just to see values for debugging Show Custom Dialog [ GetValue ( $Sig…

Hi all I know that the customlist function is a really powerful function, but I need help I have a Table with 62 records and a field called "Rego" that on 6 records are set to 1 the others are set to 0 How can I use the customlist function to tell me how may records have 1 So total records 62 "ergo" = 6 Please help Craig

I have a table for Customers and a table for Jobs (one to many) One layout, "Today" shows any jobs that have today's date and the Summary Field gives me an accurate total of the jobs for the day. Price and SummaryPrice are fields in the Jobs table. Another layout, "Pending" gives me all the jobs that have not been completed (in the future, hopefully) and yet the same Summary field only shows the "total" of one job. As I click down the list, the Summary changes to reflect only the one I click on. I use a script attached to a button to take me to each layout and perform the search. I'll attach images of my scripts and the Summary field itself used in both l…

I have a textfield In a file which, by calculation I would like the background color of the field to become a light green. Only when the field has text added to it. Could someone tell me how to do this. Thank you

Hello All, I just started playing around with custom functions and I found this one for logging every change made. Sorry if this was the wrong place to post this thread. http://www.filemakermagazine.com/videos/super-audit-logging.html First, is there an easier way to do this? Second, everything works as it should, I then use a script to open another file to store all the data and organize it, which all works fine. The problem I have is that I am trying save space in the live database (the one containing the log function). After I export the data I would like to clear the logs in the main file. FileMaker will not allow me to do this, because the fi…

I found this on FileMaker.com forum. I found it interesting and am trying to get it to work correctly. I have been working on it but have not got it to work properly. I am pasting the text below. Will someone with more understanding interpret it and make a sample of it. Thanks in advance. If a holiday (of one or more days) occurs between StartDate and EndDate, and you don't want to count the holiday as a work day, then some changes are required. First, create a new Table, HOLIDAYS, which contains the following fields: Date (Date) Counter (Number) Holiday (Text) - Optional Use the following table to enter the values: Date Counter Holiday 1/1/07…

I need a calculation to autofill a fiscal year field. Our fiscal year begins on April 1 and ends on March 31, and this fiscal year is represented as, for example, 2011-2012. Is there a way to automatically fill the field using a calculation? (Of course there is, but I can't figure it out.) Any help would be appreciated. Thanks, Kevin

I am still in the learning phase of using filemaker. I have developed a database to calculate specific results from a group of variables. One of the fields within the record is 'clinic'. I would like to populate this field from information entered after the user opens the application. Some of the fields I have populated using a script to enter date & time. I would like to use this same script to populate the clinic field. I am unsure what script parameters to use, and if I can use the 'clinic' field, or create another field? I would appreciate any advice on how to handle this situation.

Hi all, been along time since I posted, but I can't seem to get away from FileMaker. The thread title pretty much states the question. The situation I am looking at is a talent agency. Say you have a couple of thousand people signed up with you. For each of those Talents, along with the standard fields for address, contact info, status, etc., are about eight fields that describe the talents' attributes all the way from Physical Attributes to Accents fluently spoken. Some are fields with single value entries like Weight, Eye Color, etc. Others are things like Athletic Abilities which offers a large choice of options of which there may be multiple entries fo…

Hi, I currently have the following calculation for sales tax in my layout: "Round(If ( Tax Flag = "Yes" ; ${Sub-Total} * .0875; 0 );2)" Our tax rate decreased by 1% effective July 1st. I searched through this forum and couldn't find anything that quite answered my question. What I want to do is change the current calculation to specify that any records >= 7/1/11 will reflect the new tax rate of .0775, but I want to keep my old records (< 7/1/11) at the old tax rate. I've tried a Case calculation but couldn't get it to work. Please help and thank you!

Hi" I am trying to prevent wordwrapping in a typed field . I can do this by using the define field and selecting "Length" in the "Specify Calculation ". I then choose a number of characters in the setting up. The problem with this is that unless a constant width type font is used there is no consistency in the character length typed in the field . Is there some way that the validation will occur at the same position in the field based on pixellation count ? Any help will be much appreciated. Thanks.

Hi, I have a database which contains two tables with data. One table contains a companies list and another contains detail transactions data for those companies. The tables are related by company name. The companies table contain a field which rates the companies with a rating of Gold, Silver, and Bronze. Is there a way in which I could produce a report which counts the number of companies in each category and summarizes their spending? Thanks for any help!

Hi guys, can some one help me to solve this issue: How to create a variable that stored many records? actual i have a foundset and i want to copy data of each records to a global field that will display the data of all fields. for example: record1= men record2=ladies record3=kids and the data in the global field should display: "men ladies kids" thanks.

Hi Guys, Actually i'm collecting data from a RFID reader and data shows the time in and out of employees. Normally if an employee works on a shift system the time in will be calculated time/date=X and time out will be time/date=Y that is two different dates. for example shift workers will have time in today at 6:00pm and time out tomorrow at 2:00am. can somebody tell me the calculation to get the number of hours worked for this employee or have a better idea how to proceed. Thanks....... :D

I'm wondering how I should handle tallying a $ amount. I have record for each month out of the year and it's broken down by office. In this record I have 2 fields that add to $ amount and 2 fields that subtract from $ amount. After the adding and subtracting, I need the final $ amount to carry over to the next record based on month and year. Should I break those add and subtract fields into their own records or should I try and figure out a calculation that will pull the amount from one record to the next? Any thoughts? Thanks

I need on a layout a repeating field or something where I can enter a beginning number and it will display on the page that figure and the next 178 numbers in numerical order and I need it to be printable. I'm a newbie and I have no idea where to begin. I would like them to be broke across three columns if possible with 60 numbers in the first and second column and 59 in the last column; all three running vertically. Thanks for your patience in advance. Any help is appreciated.

I noticed some more weird behavior when using "creation time" in Filemaker Pro 11. I currently have a field set up to display creation time. When in browse mode I see a time stamp in the form hh:mm:ss am/pm. First of all the time is wrong - it displays only the wrong hour followed by zeros. Each new record I create, the hour increases. Second of all, when I click inside the field, it displays the correct time but in 24 hour format "hhmmss". Anyone know what may be causing this?

I know there are dozens of threads on this topic, but I have not been able to implement the solutions in this case. I am using Filemaker 10 on Windows 7. I work for a university's international department and am making a database on the students we send abroad and receive from abroad. The basic structure of the database has a student table, university table, semester table, and a line-item-style table connecting semesters to students. Say for example, we sent 3 students (one for 1 semester, and 2 for 2 semesters) to X university in Fall 2009, 2 in Spring 2010 for a semester each. I have a layout where I would like to show both the number of studen…

Hi all, newbie question here. I'm working on a to-do list to keep track of my design jobs. I have created a separate table for contacts with: FIRST NAME, LAST NAME, EXTENSION, DEPARTMENT and a SERIAL ID number. The SERIAL ID is also in the main table, and used to relate that table to the contact table. The last name field is set to auto complete, and I would like to have the other three fields fill in with the correlating information from the same contact record. The contact fields exist as portals on the main input layout. So here are my questions: How do I get The FIRST NAME, DEPARTMENT and EXTENSION fields to populate with information from the r…

I was hoping for some insight into the following issue. I am working with Filemaker 11 Advanced. I have a table with a calculation field using the Sum(field) calculation. The result is set to number and sums values from related number fields. Depending on the related field the result may be a decimal number or nothing (i.e. no related fields so no value). The numerical value from the calculation is correct. However, I have problems when performing searches on that field. For example, I can find all the values that are >0. However, the search fails if I search for all records with no value (=), even though there are many records with no value. I have tr…

I'm using a field for creation time. When I create a new record it puts seconds in the hours position, followed by zeros. Here are the following settings for the field: MANAGE DATABASE Field Type: Time Auto-Enter: Creation Time INSPECTOR Data Formatting: Time, hhmmss, separator ":", 12 hour AM/PM/trailing, leading zero for hours. Also, when I leave layout mode and then return to layout mode, the field has changed itself to "number" in the data formatting tab.

I cannot get a calculation to work. I would like to run a certain report every 4 weeks. So for example if the week number of the current date is 4 or 8 or 12 etc. Needs to be ISO calc to work in the uk so 'WeekOfYearFiscal' How do I do this?

Im sure this is something simple im missing. Im sure this is a common enough got a layout "orders" with a portal "line items". When a serial is entered into the portal the line items should use the serial to LookUp the price from a related inventory table. The LookUp is calculated (needs to be because there is more than one price depending on a parameter). The first item added to the portal leaves the lookup blank all other after work fine. Also works fine if you remove the first portal record and reenter it. help would be appreciated Thanks

Hi , I've got that ******************************************************** Table : valeur idpoints horodatage valeur 3 | 01-07-2010 00:00:00 | 451 3 | 01-07-2010 00:05:00 | 451 3 | 01-07-2010 00:10:00 | 451 ... 3 | 31-07-2010 23:45:00 | 1000 3 | 31-07-2010 23:50:00 | 1000 3 | 31-07-2010 23:55:00 | 1000 ******************************************************* Table : Consoparpoints idpoints mensuelle 3 ******************************************************** The aim is to get the difference between the last value of the month and the first one ( ex : 1000 - 451 ) and to put it in consoparpoints.m…

HI, I've tried to sort this without success, and probably because I'm not clever enough, I wish to extract the number, which may be a one to three digit number, from a field like Albert Street - Segment 2 33 The only thing that is guaranteed is that it is the number directly after the word Segment. In the above I only want the 2. I am sure that there is a simple answer and that I will kick myself later. Thanks for any help Matthew

hey guys i have developed a layout on my database which lists all of the records created in a specific table. i have one calculation on the layout which displays the number of records in the given table with the simple calculation of get(found count) which works perfectly. now i want to go that little bit further and have totals generated depending on some specific values that are in those records. for example: each record has one of the following values: scope, flat, 3d scope, 3d flat, or other. in addition to the total records found calculation, i would like a calculation individually displaying the total records found that are scope, flat, 3d scope, 3d flat,…