Calculation Engine (Define Fields)

I have a database containing 25 records. Each record has a numberfield ranging from 1 to 5. I want to create a new field which will be the field 1 contents plus 1. (Easy so far) however when we get to number 5 i want 5+1 to equal goback to 1 rather than six. any ideas?

OK, I've batted this around for a couple of days, with the grand result of a lot of bits-and-pieces ideas, but no idea how to put it all together. Too much of a newbie, I guess. Here's the problem. In File 1, I have a field called "EIN". It contains data such as GKL00361-6, GBV358.101, GDN2345-67. In File 2 there is a field called "ECO", and it has data such as 00361-6, 358-47, and 2344-67. An import from File 2 to File 1 can proceed if the "root" of the number matches in both records. The root consists of the numbers to the left of the hyphen (or dot, in a few cases), excluding any letters. I already have an extensive script that handles the import. It doe…

How can the totals from a summary field when sorted by "x" be set into a global field without doing any sort of an export? For example if the values of my summary field are 15, 40 and 100, I need to be able to do a "Set Field" to my global that will place those three numbers into it. Thanks for any help!!!

I am not sure what I need here for this to work, but I am assuming it is some type of validation criteria. I have two fields in question here, one being dependant on the first Field1 - for the most part will be blank but on some occasions will have info in it (a flag basically) When this flag is set Field2 needs attention. Field2 - will only need info in it IF Field1 has the flag set. Otherwise NEEDS to be empty. The data that gets entered into Field2 comes from a value list. My first attempt was to set filed2 to validate by "member of a value list" but this does not work since there is a good amount of time that this field will need to be empty. So- I…

Hello I have 2 tables " input" and "report" In "input" i have as many records needed to make a report but usually around 50 to 100 records. but in "report" " i have one record with 200 repeating fields . I have done this so I can sort records different ways in "input" since ( i don't know of a way to sort fields in repeating fields) then export them in that sort order to the repeating fields of "report". I am not sure I am doing this the best way. I need to have these records sorted in the first table but in the second " report" table they just need to flow in that order into the repeated fields of one record. Can this be done by lookup or import. and H…

So I'm trying to create a calculation field that will be based on a self relationship. The self relationship is to define all records with the same value in _kf_Cell_Line_ID. The idea is the tally calculation, which I currently call Cell_Line_Rep_Tally, should function in such a fashion in that it will increment by 1 for each new record created that uses the same foreign key _kf_Cell_Line_ID. Obviously it should not change in extant records, only update when the record is newly created. The notion behind this is simple. In our lab, we may use a particular cell line to produce a certain protein multiple times. We call each growth of a particular cell line a batch…

Hi there, Here is the issue. From a 'date' entered by the user, I want another field to calculate the next month. For example 04/30/2007 should be 05/30/2007. This calc works OK: DateToText(Date(Month(date) + 1, 1, Year(date))) The result is 05/01/2007. This calc doesn't work: DateToText (Date (Month ( date ) + 1; DateToText (Date (Day ( date ); Year ( date ))))) The result should be 05/302007 but I ended up with an error message. any help would be great

Hi there. I have a table that (amongst other fields) has two repeating fields of 20 repetitions. This layout is used as a timesheet function where the two fields record a date and a duration respectively. I am trying to setup a button and script that inserts the date into the date field. I have setup a monitoring variable of get(calculationrepetitionnumber) that shows which repeating field I am in and then place the date into that field with that repetition number, but the number always reads 1 regardless of which field repetition number I'm in. Anybody suggest how I can achieve this please? Greg

Hi, this is my problem, any help will be appreciated I have an invoice with lines corresponding to products. On the lines exists a field “results” that is calculated with an exclusive formula for each product. Imagine: Invoice A123 has: Product 1 “Results” Product 2 “Results” Product 3 “Results” The “Results” field for: Product 1 is calculated A + B Product 2 is calculated (A + / D Product 3 is calculated C + G For Product 1 I will introduce (on a different layout) values for A and B For Product 2 I will introduce values for A, B and D For Product 3 I will introduce values for C, G : That’s all folks. A…

I hope someone can point me to a simple way to do this. I'm creating a schedule of production jobs, I want to auto calculate a repeating field to spit out days of the week over 21 days (Mon,Tue,Wed,etc...), with the date starting from a global field. thanks,

I would like to count the months my records span, so if my first record is on 11/02/07 and my second record is 11/05/07 it would return 3. I need it so I can work out the average monthly income by dividing the total income by the number of months that have passed since the first record. So if my records spanned 3 months then it would divide the total income to date by 3 to get the monthly average. But then again, at the end of the year I would need to reset this so it would count the income and the months from the first day of the new year/new tax year. So really it would have to be a month I specify, then it would find the records from that date, count the mont…

I need to import a PDF into a Filemaker Database and have the users view the PDF at a later time. The problem is when the PDF's are more than 1 page, they import fine and when exported have multiple pages again but in the database I can't make it so that they can be viewed all at once. If anyone knows of a plugin that I have missed or an easier way of doing it I would appreciate the help.

Mornin .. I was wondering if anybody knows a way to extract the four digit year from a date-field. Reason I'm doing this is because I have a calculation that creates file references to images that have a file-name that includes that year ... Appreciate the help .. SM

Hello, I am sure this is easy but i just can't think of it... how would i make a dynamic script that could peform a find with the range of 30 days between the current date and today? I can hard code it by going to find mode, but i wanted to make it easy as pressing a button to specify criteria and always do it within that range. v

Whether it is possible to reverse the text in filemaker calculation field. If any one kindly post us the same. Thanks in advance. Hari

I have a field (KEEP) which contains characters. KEEP = "a b c x y z" I have a second field (REMOVE) which contains characters that I want to remove from the first field. REMOVE = "a y z" So the result i would be looking for would be: RESULT = "b c x" How can I do this via a calculation? I need a sort of reverse filter function? Thanks

Hi, Can I reverse this function: If(IsEmpty(field1);"X";"") so that if the field is not empty (has something in it) an X is marked in a corresponding field! Cheers, Dan :)

Hi Guys, I have field which contains thousands of lines of data. I am interested in rearranging one particular field, the name field. The name field seems to be jumbled and what I am trying to do is get the contents of that field in the following order Mr SURNAME, Inital Forename One thing about the data is the surname is always in capitals. Imagine this is the data in field name Mr & Mrs JALZ K Abs BLOGGS Fred Mr Prof Greg I NORMAN I would like to produce the follwing result Mr & Mrs JALZ K Abs Mr BLOGGS Fred Prof Norman I Greg Is this easily possible? Many Thanks as always Jalz

I see some old post (2003) where it was talked about. But in 8, 8.5 can you use a tablet pc and be able to capture a customers signature and store it in the database. I looked at the esign plugin but it appears to be more for using the 3 capture devices that they sell. Thanks in advance for any input you may have. Thom

We have built a multilanguage module using language tables and a lang.key. For the key and all the text fields we use global fields. Making the text fields calculation fields we can switch between several languages in one layout. So far so good! [color:red]The problem is when we go in find mode, then we became a empty layout probably due to the fact that it’s not possible to calculate the global fields anymore Question : Is it possible to show the contents of a related and/or calculating global, field in find mode

Don't waste too much time reading...I figured out the problem! Sorry. ______________________________ For some reason I can hardly ever get these things to work for me. Sometimes they work just as I expect but when they don't I have no idea why. For example, in FM now I have a database called InvoiceItems which you can probably guess stores item information for each invoice in our system. 2 fields that currently exist in there are ItemNumber and Description. Description is configured with Auto-enter calculated value. It pulls the description value from a related Products table (which is related by ItemNumber) and updates it. If I uncheck the Do not replac…

Hi, My database contains information regarding images collected from various microscopes. I have a container field into which a scaled down version of the image is inserted. The inserted file is a 24-bit RGB tiff no larger than 512x512 pixels created with ImageJ. Occassionally, inserting the image gives an error message "This picture cannot be displayed" and an icon with the file name appears in the container. I can't see anything like file format, size or bit depth that might be causing this. Any suggestions? Thanks, Glen

I am using the following: If((Right(NINumber;1) = "B" or Right(NINumber;1) = "A" or Right(NINumber;1) = "C" or Right(NINumber;1) = "D") and Length(i8) = 9;1;0) to determine whether or not the entry in the i8 field is an NI Number. It outputs a 1 for JN473791D but a 0 for SG584332A. Why?

Hi: I have some data extracted from a web page, the data is paragraph delimited in a text field (much more than listed here) I want to populate fields, for example: ItemName, StockNumber, EngineType, Status, Options by parsing the data. I used middleValues function, and that was fine if all the items where in order. But some of the items are missing on some records. Some sample data: record 1 Item Name: Acme Engine Stock Number: 00000000 Engine Type: 8 Status: Pending Options: None record 2 Item Name: Acme Engine Engine Type: 8 Status: Pending Options: None record 3 Item Name: Acme Engine Stock Number: 00000000 Engine …

I need help writing a calculation on how to get the summary of "CURRENT", "OVER 30 DAYS", "OVER 60 DAYS", "OVER 90 DAYS", OVER 120 DAYS", and "TOTAL DUE". This is actually for a Statement i want to mail out to my customer every month. This is what I came up with but it does not work: If (Statement Today Date - Invoice Date ≤ 30; "Current"; If (Statement Today Date - Invoice Date ≤ 60; "Over 30 Days";If (Statement Today Date - Invoice Date ≤ 90; "Over 60 Days";If (Statement Today Date - Invoice Date ≤ 120; "Over 90 Days"; "Over 120 Days"))))

Hello there. My name is Audra and I've just started a new job where my manager uses FileMaker and he wants me to figure out how to make birthdays alert me a few days early so I can send a birthday E-Mail. Only problem is, I've only just learned how to enter basic customer information and that is all. Any help would be greatly appreciated since he wants this done ASAP. Thank you so much!

Hi there! I'm really new in Filemaker and my problem, I hope, should be very easy to resolve I have two multimedia fields where I put a MPG video in one and a VOB (dvd) video in the other. The fact is, when I double-clic on the MPG, it opens externally the player and everything is fine (it's Windows Media Player). When I double-clic on the VOB file, nothing happends, but I've got a player for this (VLC player). The strange thing is, when I clic on the VOB on my desktop, it opens with VLC player. Does anyone have the begining of a clue ? thanks rekam

hi again. need help. i have a database with 2 tables. they are related with a field called year. on table1 i have a field with number values. the least/minimum value is 1500. what i want to do is to create in table 2 a field that will contain the sum of data with 1500 on field 1. thank you. :)

I have two tables and would like the calulated value in a field in Table 1 to appear in a field in Table 2. How do I do this? Is it a match field? Script? thanks :)

Hi, I feel I should be able to work this out but it is not happening for me. We take orders for and manufacture product; we may take orders for 200 units but only manufacture 150. I need to automatically allocate product to a weeks production list. We have an [color:red]Orders file populating an Items file; a record in the [color:red]Items file may show Qty = 20 Model = A Color = Blue. There will be multiple records linked to each Order. We also have a [color:red]Production file with a record for each week and the number of each model can be produced in that week; numbers are normally consistent but some weeks have holidays or scheduled maintenance. …

This might be a bizarre question but I'll try it out nonetheless: I have a layout we print quite a bit. The primary key is the SSN but we've slowly been moving to a new system where it's a 9 digit number but begins with a 9. So, new identifiers look like this 9xx-xxx-xxx. Is there a way when printing the form to control whether or not the SSN prints or not? If the field contains the new identifier (9xx-xxx-xxx) we want it to print but if it doesn't we would prefer it not print at all. thanks.

is it possible to have multiple if on a calculation field? here is what i am trying to achieve: if numfield_01 is less than 100000, result is 1500 if not divide numfield_01 with numfield_03 multiplied by 90% of numfield_04 but if numfield_01 is the maximum/highest value in numfield_01 result must be 10% of numfield_04. I hope this makes any sense. thanks ;)

Hi, I have currently two fields, a start date and an end date. Then I have another field which is an empty field. What I would like to be able to do is run a calculation that goes along the lines of. Does 06/04/07 appear in the range of "date1" and "date2" if so put an X into "empty field" That make sense? Cheers, Dan ;)

It's not funny anymore. I have a projects database that tracks our publishing projects including hours charged to specific jobs. Hours, employee, position and date are recorded in a single line item that is separate table. What I need it to filter the line items by job, employee, position and dates. Meaning total hours for a job, total editing, design, how many hours were spent in March, how many hours has Joe spent on the job, etc. My solution was to create table instances for each position then use global fields "editor" and a calculation to add hours in the new table occurence. Can someone describe a simpler way? thanks

I know there must be an easier way to do this ... I'm working on a database that keeps track of assets in a production environment. I need to be able to track the duration (hh:mm:ss:ff ... frames could probably be dropped) of the videos and to be able to a search for videos of a certain length (30 minutes). I've come up with a less than elegant solution. Users enter hh mm ss frames in separate fields. I have a calculation field to figure out minutes and a search page where a user enters a range in minutes (eg 00..120). does anyone have a sample database/calculations that makes it easier for a user to enter timecode and to do a search for a video of a certain len…

I have a text field which contains contents like "1A+22B-3C" or something like that. I created another number field so that i can get a sum of the text field, which will be "20" for the above example. How can i go about doing that? I tried using the filter function in the number field; Filter((text field);"0123456789+-*/") but could only narrow it down to "1+22-3"

Hi, Before I tear what hair I have left out, I am having difficuly trying to carry a value from one table to another. I hope I dont leave anything crucial out here during my description, but I have a sumamry field which is the total of some entries in another field in the same total. This value needs to be seen in a layout of another table (same database file). I have tried using the Let($$var) function without luck. I am using the DataViewr option of FmPro Advanced and see that the variables are correct whilst viewing a layout "attached"(?) to the first table and the numbers are correct. As soon as I move to the next table the numbers revert to zero. What …

I have a table of LineItems sorted by Invoice_ID, and I need to assign an Transaction Number to each LineItem record, as follows: Inv_ID TXN_No etc... C10001 1 C10001 1 C10001 1 C10002 2 C10003 3 C10003 3 In other words, I want TXN_No to increment every time Inv_ID changes. Seems like it should be an easy calc or summary but I can't spot it. Anyone? Thanks, Chap

I have a database. I want to cofigure one of the fields so that if you (button) click on one of the fields it takes you to a web page. That web page is made unique by the field data. So I start with the main web address and then I want add the data from the field onto the end of the (common part ) of the web address. So that the button is configured to create a unique web address from each record. Just like if you were mapquesting an address. I know it's simple but I can't seem to figure it out. Thanks if you can help.

I've got a table consisting of records which detail values that change occasionally, each change represented by a new record. As the value is extracted from this table to another by script, there isn't much need to have more than two records at any one time. [Record 1 – first value. Record 2 – new value] The script calls either record, by selection, and as it runs, it pastes a date specific to the other table, back into a date field on this table. This date field then triggers an evaluation calc which forms an audit trail. So far, so good – all working fine. 95% of the time the script will run either from a single record [1 of 1] or the most recent, secon…

hi. i do not know if my subject is correct, however this is what i am trying to do. i have a database with two tables. table 1 contains: field1 (text) field2 (number) on field two there are values of 1500. what i want to do is put the some all the values with 1500 and put it on a field on table 2. how fo i do this?

Hello, can't seem to find where I can add a hyperlink to a field or text. Would like to add a link (or a couple) to certain documents (word and pdf). And show these links in a record / field. This Mainly to have easy access to the documents. one click on the hyperlink and the document opens in a new window? Can anybody point me in the right direction? Thanks, Dutchy

Hi. I am trying to achieve something that has been eluding me for hours. I have a database of jobs, and within each job is a portal to a table for timesheets. One of the fields in timesheets is a Yes/No field that records if a time is billable or not. Below this portal I have setup a total that sums all hours in the timesheet for that job. This works fine. What I am trying to do is sum all the VALUES of the timesheet entries marked Yes, and another for No (which would in fact then add up to the total of all hours in the timesheets). I have tried all manner of trying to setup a field that totals all the values in another field in that portal given the …

I have 3 fields: 1. Option-field: Y/N 2. Field1: 3. Field2: If option-field = "N" than write "no" to Field1 and jump to Field2 and wait for input. Which formula could make this "jump" -)?

It used to be very important in previous versions of Filemaker to "Level" your inventory. If you didn't, your system would bog down. Does anyone know what speeds are like in 8.5?

Hi everyone, I have a container field that holds a reference to an excel file. I attached a send event to the field so when the user clicks on the excel icon it opens the excel doc. Sometimes it works and sometimes it doesn't. I am using it on server8 and the excel file is on a separate fileserver. I tried inserting the file rather than a reference but that doesn't seem to help. I must be doing something wrong but I don't know what. Any help would be greatly appreciated. Mike

Hi there, I am trying to set up an ordering database. When the user enters, they click on their name and ID number, and it bounces to the ordering screen. Is there any way to automatically bring the user name and ID # to appear on the order so all they have to do is data entry? If I am not in the correct forum, can you please direct me? Thanks.

I am looking for any exa,ples of how I can display in a field the fastest time in a race. I have searched the forums already and come up with nothing. I am entering times from a race in a db and I want 10 fields to display the 10 fastest times. Is this possible??? FKSSTechGuy

I have 2 fields: Vendor and TicketNbr The rule is: if Vendor is “PBS” the user must enter a TicketNbr, If vendor is not “PBS” a TicketNbr is optional. I tried Case (Vendor = “PBS”; Not IsEmpty(TicketNbr)) but it keeps requiring a TicketNbr regardless of what is entered in Vendor. I tried various combinations with Case( ) and If ( ) etc…but nothing worked.

Ok...two questions here. First: Of what use really is a repeating calculation field? And secondly, can you write a formula that creates different calculations per repetition - and here's the tricky part: can you create different calculations per repetiion within one calculated field?

I have a text field where I want to be able to remove any carriage returns which are at the end of the text (while keeping carriage returns which are in the middle). To get rid of one is easy: case(right(field;1)= "¶" ; left (field;length(field)-1) However, there may be more than one carriage return at the end of the text. It is quite common to have 2 or 3, but on occasions there have been 20+. So, is there a tidy way to remove all these extra carriage returns using a calculation? An example of the text in the field (using ¶ as a carrriage return) "Price Guide: £20¶ double £40¶ suite $80¶ ¶ ¶ ¶" In the above text example I would wan…

For example, say I have a field with the following text. The quick brown fox jumped over the red dog. I need to parse the information in this field into complete words and into 4 separate fields which are not longer than 12 characters. So the result would be: Field1 = The quick (9 characters) Field2 = brown fox (9 characters) Field3 = jumped over (11 characters) Field4 = the red dog. (12 characters) I need assistance with the calculations that I would need for each of the fields to extract this info. The total length of the text will never exceed 48 characters but could be as short as 15 characters. The reason for doing this is…

Hey guys, I am trying to figure out a calculation (which I am not good at) that will tell me whether a person is over 18 or not. We collect birthdates for applications and some of my co-workers have a hard time doing the math of how old they are. Any help would be appreciated. Thanks!

Hi, I currently am working on a database that has a specific date for when work has to be done, the client has requested that this be displayed as Quarters of the financial year. So what I need to do is to take 18/04/07 and assign it to a value of Q1 etc. What is the best way of doing this? -- I'd like to be able to set the date, and then a box to the left of the date, automatically populate with Q1, Q2, Q3, Q4... Your help is always appreciated! Cheers, Dan :)

I'm sure there is a very simple calculation to do this but for some reason i can't see it. best Stuart Let ( [ //a = number from 1 to 5 a = 1 ; //b = number from 1 to 5 b = 5 ] ; Choose ( a ; Choose ( b ; 00 ; 01 ; 02 ; 03 ; 04 ) Choose ( b ; -1 ; 00 ; 01 ; 02 ; 03 ) Choose ( b ; -2 ; -1 ; 00 ; 01 ; 02 ) Choose ( b ; -3 ; -2 ; -1 ; 00 ; 01 ) Choose ( b ; -4 ; -3 ; -2 ; -1 ; 00 ) ) ) ps the 00 are just to make it readable a simple number is all that needs to be returned.

Hi I have multpile scripts stung together in another script that perform multiple finds. Some of the finds return the "MODIFY FIND" "CONTINUE" "CANCEL" dialog box. Is there a way to have FM automatically "CONTINUE" so it will then perform the next find so I don't have to manually click "CONTINUE"? Thanks for any help. (I'm needing this on FM Windows 8.5 if that makes a difference.)

The FilterValues function shows returned-delimted items that are common to both lists in 2 different fields: FieldONE John Sam Gordon FieldTWO John Sam FilterValues(FieldONE; FieldTWO) Returns John Sam [color:green]Question: How do I get the difference: Gordon

Evening all It's just gone midnight and my normally persistent and determined brain is telling me to give this one up and go to bed. This is one for the seriously determined. I'm trying to make a calculation field which works out the number of WORKING DAYS AND HOURS (ie including only weekdays 9:00 - 17:30) a server has been down, with the following inputs: - date and time the server went down - date and time the server came back up (or, if it's still down, the date and time now). I'm **nearly** all the way there. The calculation below will work in all situations except when the period of downtime includes more a continuous span of more than one…

I have one field with [ kilometers ]. Sometimes I make a selection of records. With a scriptbutton, I want to calculate the summery of field "kilometer" from the selected records, the result should be shown in a seperate field. I know this must be done with a calculation -)), but with which one, this is the question for me as beginner...

Does anyone know if its faster to use an auto-entered calculation to enter data into a field from a related table versus using Set Field script step? The only way records get created are through scripts, so having to script "Set Fields" isn't hindering to the process itself. As of now, it's taking a while to create records because of auto-calcs, so I'm wondering if set fields would fix the time lag. Thoughts? Thanks!

Hello, Is there a way to run a script (FMP script) when a field has data entered into it? e.g. A customer is selected (using a KF field related to it's KP field), and when selected a script runs. Thanks Dave

I've got a table for InvoiceItems and another table called Scans. These tables are related by ScanID. The Scans table includes a field called Status that binds to a value list with values of: RMA, Post, Tech, and Sold. What I need to make happen is that as soon as item as added into InvoiceItems (added to an invoice in our system) it sets the status for that item in Scans to Sold based on ScanID. Any information on how I can accomplish this with as little lag as possible (sometimes calc. fields slow me down quite a bit) would be greatly appreciated. Thanks!

Good morning, I'm working on developing a contract for our High School Independent Study instructors. The manager of this unit wants to be able to see all the courses for a given instructor on one line in the contract. Ex. Course 1, Course 2, Course 3 The Courses table is, of course, set up so that there's one course per record with a serial number setup as the primary key. An instructor is selected from a drop down list for each course. The number of courses a given instructor teaches varies from one instructor to the next. I would have no issue doing this in a normal report but to get all of one instructor's courses in a string is not something I'm…

I am working on a database for my babysitting company. I would like a count of each time a sitter sitted for a client. Not the number of jobs a sitter has worked on total, mind you, but the number of jobs for each client. I have included the bare-bones structure I'm working with. Any help would be greatly appreciated. Sitters_test.zip

The problem I am having is when I am trying to get a percentage of a dollar amount, the percentage never rounds up or down. Even when I tell FM not to go more than 2 decimal places it always goes 3, 4, or 5 places. The database I am working with is for figuring out what to pay our sub-agents, but we cannot use the database properly without it multiplying correctly. The agents always get paid more and we cannot have that. Thank you for your help.

I am trying to create a script that will autofill a person's email address based on their user account name. I know I could do an if-then step in the script, but for 40 users that would be a lot. Is there a way to use the Set Field with a calculated result? What I imagined was this: Get Accountname If Accountname=bookkeeper set the field to [email protected] If Accountname=purchasing set the field to [email protected]. Is it possible to do that in one calculated result?

I am trying to create a script that will jump to the first record that has today's date in it. I thought I could use the Go to Record/Request/Page with a calculation, but I can figure out how to calculate for the row number. I think what I want to do is this: Row Number = 1st Record with field DateRequired contains get(currentdate) But I am not sure of the syntax to get this result. Is this even possible?

I am wondering if someone can help me figure out how to accomplish something. I have a table that has only one record, it is a price list and it has 69 fields on it that represent specific pricing tiers based on Qty of Product Ordered and Number of Colors in the product. An abbreviated version of the price table looks Like this: Quantity ..............1C.....2C.....3C........4C.....5C.....6C 6-11.......2.95...3.50...4.00 12-35.....1.75...2.50...2.75 36-71.....1.25...1.55...1.95...2.35...2.75...3.15 I have a second table where a user inputs order information and a price is generated based on the certain properties. In this case, qty of product …

Please forgive what it may be a very basic question, but I figured the best way would be to ask to expert people after I spent a few hours browsing the net and help to find my answer. If I change a formula in a calculation field, the calculation itself it's not updated unless I manually re-enter one of the parameters; is there an automated way (read: a button) to force FM to recalc all the calculations in a given page? Thanks for your time. Mafia.

i have a summary total field, i want it to show a grand total. the field that i am totaling is a calculation field that equal 1 or 0. if all 3 records = 1 then the summary should read 3 on all of them. if 2 of them =1 it should read 2...etc. when one of them change the total doesn't update itself accordingly. what could be wrong...and what could i be missing. other info: its not a report its just a standard record view and i need a count of how many records meet the check requirements

FM8.5 adv, mac, I have four calculation fields that when accessed remotely do not show, however when the actual file is opened on a different machine, the fields are viewable. The field is a calculated summary from another table. Any troubleshooting thoughts? THanks

I'm new to FMP 8, and I'm having trouble with my formulas. For example to Calculate and age: (Year(Status(CurrentDate)) - Year(DOB) - If(Status(CurrentDate) < Date(Month(DOB), Day(DOB), Year(Status(CurrentDate))), 1, 0)) & " Yrs, " & (Mod(Month(Status(CurrentDate)) - Month(DOB) + 12 - If(Day(Status(CurrentDate)) < Day(DOB), 1, 0), 12)) & " Mnths, " & (Today- Date(Month(Status(CurrentDate)) - (Day(DOB) > Day(Status(CurrentDate))), Day(DOB), Year(Today))) & " Dys " This formula is no longer accepted. Can you give me a new formula for this? Thanks

I have a field called UnitNumber and another field called ScanLabelPrinted. ScanLabelPrinted is simply a 1 or a 0. The goal is to highlight the UnitNumber text when ScanLabelPrinted = 1. I originally just used a calc. field and that worked except then we couldn't edit that field. As such, I changed to a normal text field with Auto-Enter calc. and validation calc. both set to: If ( ScanLabelPrinted = 1 ; TextColor(UnitNumber ; RGB(0;98;0)) ; UnitNumber ) Do Not Replace is unchecked in the Auto-Enter section. This works for the most part, but I hae a couple of problems. First, the text in UnitNumber does indeed change to green when ScanLabelPrinted = 1. …

Hello, I have i doubt, probably a very simple one but i couldn't find any post that helped me. I have a global field called sum_min which is supposed to sum the value (minutes) of a field of all records. I'm using this calculation to do this: sum_min = sum_min + minutes. The problem is that whenever i change the value in the minute field, it adds the sum of all the minutes field on the value in the sum_min, so if i have 20 min in the sum_min, and i add 1 minute in the minutes field,the sum_min will now be 41 and not 21. I could fix this by setting sum_min to 0 before the calculation, but i don't know how =/ Can anybody help me? I'd really appreciate it1 Thanks!

I would like to define a new field, that would subtract two different times, and give me the difference. I have field A, the arrival time, and field B, the departure time. I want to have C show how many hours are in between them. All my events last less than a day. The problem I'm having is that Field A and Field B, are in Time format. Field C, is a calculation that has (Field - (Field A). What I want is for field C to give me the difference, but what it's doing is it's giving me a negative number because it's going back a whole day from AM to PM. Can anyone give me a tip on what to change? Thanks.

I have a field: "RecID" The different records would be: abc-1 abc-1 abc-1 abc-2 abc-2 abc-3 I have a field: "CountRecID" I want to be able to show how many of each (summary) there is. So the records would look like this: RecID | CountRecID abc-f | 3 abc-f | 3 abc-f | 3 abc-a | 2 abc-a | 2 abc-v | 1 I can get the CountRecID to return the number "6" because there is six total entries, but I cannot get it to return how many similar entries there are. It seems as if I am messing up the "breakfield" I eventually have a field set up to tell me if CountRecID is greater than some number (using the system to flag entries). …

I have a small PO/Invoice solution and I'm trying to figure out a way to calculate a shipping quote. I just need ballpark estimate here so I don't care what carrier (UPS,FedEx,DHL) that I use for the estimate. The invoice will calculate the total weight for the order and obviously the origin and destination zip codes.

We have changed phone companies. This new company only gives us an Excel spreadsheet with multiple worksheets. It is a mess with multiple rows of header information, detail with headers and blank rows between ... it goes on. I've worked through it all but their Time field is a number as: 130747 211100 Of course this is 24-hour timestamp. Luckily, they have padded minutes and seconds with leading zero. Hour is NOT padded with leading zero. I want it in a time format but nothing I try feels very elegant. I am also concerned because it would break if OS time format is changed (I think). If I change to text, the result in time field (in first example) is: …

I have been trying to figure out a calculation (for use in a script) that will delete the last character in a text field. I've tried various find/replace with "", and other options, but no luck yet. Replacing/deleting the last character is probably all I would normally need, but replacing/deleting the last character IF that character is "x" would be safer. New to this forum. Skills have gotten kind of rusty with FM. Thanks very much for any tips, pointers to other help files, etc. Ed

In order to avoid further hijacking of this thread.

Hi all, This is going to sound really dumb, but I have a few newb type questions that the reference material just does not seem to answer clearly. 1. I'd like to take the contents from 2 text fields in the same table and join them into one string stored in another field in the same table - first name and surname to be precise. 2. I need a button that will open another layout in 'create record mode' and create a new record in another table (I have already created the relationships) and populate it with the existing shared data. Specifically, this is for adding user records to a company database where the company data remains the same for each user. This…

I was trying to be breif, can't. I have a file (Bill of Sales) where sales take place date, cust #, cust name, tranaction#, total of sale, and a post button. When a sale is complete the post button post the information in the (Ledger) file. Payments are made directly into the Ledger file, with date, cust name, cust#, and amount. Sometimes the customer will have a credit or will maintain a balance in his account. I need to do a monthly report, showing any account that had action on it and/or a balance. When I do a find by month and year, I only get occurances during the found month/year. If the deposit was made in the account anytime previously it will not show up in …

I need to change the color of a field called "player" case a field called "captain" is Yes. In the "player" field i'm using this calculation: I guess something is wrong..can anybody help me? =/

Hi, I have a field containing about 20 selection choices via checkboxes. I have another field who's purpose is to display the first 2 characters,(plus a comma) of each checked item. I can't seem to get past "Left" functions. So if there are three checkboxed items, "ACCOUNTING", "PREPRESS", "SHIPPING", I am looking to see returned "AC,PR,SH" Any help would be appreciated. Thanks! MW

I would like to have 3 fields where one is populated with a number in feet and the 2nd is populated with inches. I would then like to concactenate those two fields and convert the Feet and Inches to just inches and populate the 3rd Field with that answer. I can't seem to get anything to work. Thanks

I have 8 text fields in each record and need to count how many times each value shows up in any of these fields across all records. The same value can occur in any of the 8 fields in any record. Any ideas? Thanks, Greg

Hello All, I've got a database that tracks volunteer information and a related table that tracks the hours the volunteers put in. Each record in the related table only tracks the Year, Month, and how many hours they put in for that month (no date fields involved, strictly text and number). I'm trying to get a summary of all the hours they put in every year, except it always calculates all of the years... How can I get a sum of just the hours from 2006? Any ideas would be much appreciated! Thanks, Chris

Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?

I'm working on a solution that uses repeating container fields and calculations to show specific icons related to a record. However, I just learned that if I delete all the records from my DB or make a clone of it, I lose the icons, as the images are stored in container fields in a record. Is there a way to store graphics like this, that are not necessarily part of a record but more like an object that calculations and scripts can have access too?

Is there a way to identify the a calculation field from within itself? I had this idea for a recursive custom function that would concatenate the values from all the indexable fields in a record (in order to search on). I was thinking of using it in a calculation field, but don't want the calc to reference itself (making a circular argument). I'm looking for something like Get(CalculationRepetitionNumber) but for the field ID itself. Thanks

Hey! I want to search by month. I have a field that saves the date of when the record was created, so i tried to create a field with a calculation "Month(date)", but that doesn't seem to save the month of the date. I've seen a lot of posts, but I culdn't find one that helped me. Can somebody please help me? Thanks a lot!

I have a container field that stores references to files of any type. I have three other fields that store the file name, modification date, and file path. Right now I just have users typing in this information, but I'd like to automate it. Is there some way in FileMaker (preferrably not AppleScript) to extract this information and place it in these fields? I'll use an AppleScript if it's the only way, but I'd prefer not to for simplicity of maintaining the system. Thanks in advance!

I have a text field where there are up to 8 values seperated by plus signs (+). Is there a way to seperate out this data and place it into other fields? Example data: R435+L234H+R135+G119+R336H Thanks, Greg

I have a situation that I can't seem to solve. Here is the setup: Task: Create a new record and insert the ID of the record that the script was triggered from. Script steps: Set Field [GlobalTemp::gTempNum; Get(RecordID)] Go to Layout ["Action Items" (Action Items)] New Record/Request Set Field [Action Items::AI_id; GlobalTemp::gTempNum] Commit Records/Requests [No dialog] Go to Field [Action Items::XI_item] Unfortunately, the field AI_id never gets set and the global field gTempNum does not contain the record ID of the record that triggered the script. I did make sure that the table GlobalTemp has at least one record (the only field is the glob…

Hi, I'd like to be able to store a PDF file in a container field, and then somehow issue a print command that will open the file and print it. I can't seem to find a way to issue commands to the object of the container... With the common uses of FM including asset management of images, I'd think this would be possible... Hmmm. Any help you can provide will be appreciated. Thank you. Mac Hammer

I'm having a little problem. I have a field called Color, and what I need is to count everytime its content is "Red", "Blue" and "Green" in all records so I can save how many "Red", "Blue" and "Green" i have. Can anybody please help me? Thanks

Hey! I want to sum the values (number) of a field of all records into a global field. How can I do that? I've only managed to save the last one. Thanks!

Hi all, I am trying to find a post or blog on here or their site, where they posted a sample of a simple calc where the user could type in any field and it would recalc the other two fields. It was a very simple example where it was something like A + B = C, where the user could change any of the fields and it the other two fields would readjust. It is NOT the sample on Mikhael's site. I know that I could write the auto-entry myself but at this point its the point of me not being able to find the darn thing that is driving me nuts. Any ideas where the heck I saw this? Thanks. :hammer:

I'm having trouble figuring out how to have filemaker automatically enter a order number/serial number for each entry. This is the way I'm doing it right now. In database I go to define, create a new name, and select "Number" as type, and under options I select serial number, check "Generate - on creation", and then I want it to start at 2500, and for each entry have it add 1. After I said OK, it doesnt show up and acts like I did nothing to it.

I have a report with subsummaries. I want to count the number of subsummaries. Example Cars 7 " "Green 4 " "Red 1 " "Blue 2 I want to get a count of the different colors, in this case 3 different colors.