Calculation Engine (Define Fields)

Hi, I was trying to slove this problem using IF, but I couldn't get it to work. I've found a solution using CASE, but I'd really like to know why the IF statment wouldn't work. I've 4 fields, test 1, value test 1, Test 2 and Value test 2. If either test 1 or value test 1 are empty I want to show graphic 2, otherwise graphic 1. BUT if test 1 is either fail or fail (rust) then test 2 needs to be carried out. So if test 2 and value test 2 are empty then graphic 2 should appear, otherwise graphic 1. I hope this makes sense. Here the CASE that works: Case ( IsEmpty ( ${Summary Test1}) or IsEmpty ( ${Value Test1}) ; Graphic 2 ; ((${…

I have a field that I would like to concatenate two numbers. Both numbers are spend levels. I have them looking like this $21000, how do I get the comma in ($21,000)? Thanks for any help.

Howdy: I'm learning filemaker, and as an excercise I am creating a database to handle customers, products, and orders. I have 4 tables: customers (customer_id, customer_name, customer_address) products (product_id, product_name, price) orders (order_id, customer_id) order_items (order_item_id, product_id, order_id) So I'm trying to design a form to enter orders, and can't figure out how to set things up to allow me to enter multiple order items, without knowing how many order items there will be ahead of time. Is there a way to dynamically create additional fields in a form as items are added to an order? I'm an absolute beginner, so if anyone …

Is there a way to make filemaker not share globals between different windows? The only thing I can think of is have example : Window #1 look at line 1 of a global repeated field and have window #2 look and repeated global field line 2. It just seems a little buggy to me because if you close window 2 and open it back up, then you have the old globals from the previous window 2. Any sugguestions? Thanks

Hi. Id like to have an image container. In a way that I have 2 buttons: one is for browsing & selecting an image for that container and second is for view (open the image file) my question is how to do it?

OK. I have been up too many hours and am trying to do something that is really easy and can't get it to work. I want the current number of the record in the found set. I have used the Get (RecordNumber) but it keeps giving me the wrong record number (not in order). Thanks for any help...

hey all, and thanks for any help: here is the issue: i am trying to create an invoice where the description of the purchase appears (field B- currently a calculation field with choose as the function) on the basis of what value is chosen in another field (field A). that field (A) is a value list with four values. all are about 4 words of text. i have tried with field A formatted as both radio buttons and a drop down list, and it didn't work with radio buttons and it (: will only choose the first option in the choose calculation when the other field is formatted as a drop down. any ideas? thanks!

I am trying to get Filemaker 8 to perform field validation (a plug-in that executes a script) when exiting a field rather than when the record is committed (by clicking outside the field or going to another record). It seems this is only possible with a Global field but not a text, number, or date field. The Filemaker Knowledge Base says that I should "use the new auto-enter calculation overwrite feature to trigger this plug-in at the same time [as exiting a field]" but that doesn't seem to accomplish what I want either. Any suggestions?

What is the symbol for a "tab" I know the paragraph symbol is "¶" Is there one for a "TAB"?? What I am attempting to do is create a calculation field that combines a number of other fields for a generated description. The reason I am doing this is to save space on the print layout, sense some fields will be empty. I want to format the information so it looks kinda like this: LABLE: Field information/description here, and so on Field information/description here, and so on LABEL: Field information/description here, and so on

Hi, I have a product table, there's an "Amount" field calculated by Quantity * Price. I want to add a custom message if the amount is over $1000.-. Not sure how I can do that. Do I need to write a script or there's easier way. Thank you very much for any help. -- MTG --

Hello Everyone, I am working on an image database for work-rather I was thrown into this. This is my first time using filemaker and it has been a blast until now. Here is my delima: I have been importing massive quantities of images into a container fields-they are stored as a reference. I have the container set-up to get url-so when I click on the image it open in photoshop. What I need to do is have the image open in photoshop and then save in a specified folder. Another catch-there is a field that allows the user to rename the image if desired-or I will run a script in filemaker to get the first 15 characters of the original file name if the rename field is empty. An…

I was running a script to export this container field to modify the picture and then put it back in the container field when all of a sudden FM tells me that I cannot export a container field?: Any ideas?

Hello everyone I have a Custom Value List checkbox with numbers. I am producing a number range according to which values are checked so the range will always produce 1..5 (sorted). This will be used in global variable for searching number ranges (in find script) and not (necessarily) as a field calc. And it may be used for things I haven't even thought of yet. But I wonder if I have over-complicated the calculation or approach? I doubt that I've thought of all possibilities and potential problems with it and would appreciate your ideas. It is a very small file with only one simple calc and checkboxes. Oh. I realize it will break if my VL contained d…

I have two tables: Cause and Disbursements. In Disbursments I have a primary ID. In Cause table I have a Foreign key field that I want to reference the primary ID in Disbursements. I was hoping to create a relationship between these two tables based on Primary ID(disbursements) and Foreign ID(Cause). The foreign key does not seem to be populating with primary key data. What is the best way to get that to happen or to create a relationship between these two tables.

I was wondering if there was any way to create a button on a click (within a picture) like google maps or something. I'm working on a solution for a bodyshop and I'm trying to make something so when they check a car in, they're able to click on specific area of a overhead car picture where the damage is and have a pop-up to enter more information and have a spot to click later to get the information they've entered.

I am working on automating contract revisions…. And have a button to duplicate the contract (except for a few fields- including cn_pk and salary or other fields that are known to change on revisions) “Revision” script is looking like: Duplicate Record/Request Set Next Serial Value (contract::cn_pk) Set Field [contract: cn_memodate; “”] Set Field [contract:: cn_salary_fall; “”] Set Field [contract:: cn_salary_spring; “”] Also, I have a calculation showing if the contract is active or not, based on the start & end dates of the contract period Field is c_display_cn_active --- calculation is If(cn_pk="";""; Case(Appt::appt_end_date ≥…

Does anyone know of an easy way to copy field definitions (not the data) from one table into another table in the same file....without just re-creating them??? . Using FMP 8.5 or FMP 8 Advanced.

I'm trying to get a calculation that switches two container graphics. User enters a text and the checkmark switches from black to red. I saw a solution like this before but could not find a post of it. Any Help? Thanks Graphic_Calc.fp7.zip

Hi, I posted for someone to help several months back and I received the following formula it worked until Aug1.... AND Now Aug 1 thru December birthdays come up with the CORRECT current age BUT Jan.-July 31 birthdays comes up with One Year Added.......Please I need help altering this formula: I need a person's current age as of Aug. 1 2006!!! ONLY Year(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)) )) )) - Year(birthdate) - (Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)))) ) < Date(Month(birthdate), Day(birthdate), Year(Date( 8, 1, Year(S…

Hi all, Overall my App have 10 screens layout, the 1st is "MainMenu" already set as the 1st top in "Set Layout Orders" but when I execute the always go to the 2nd layout. What's wrong here...please HELP Thanks in advance

I was trying to do a calculation that is a minimum of all values that are not zero of a numerical field of a related table, but the Min() function only takes pure field names, so I can't do something like min(othertable:field > 0) as it generates an error Can I do this solely with a calculation, or do I need a script to do something like this. I was trying to figure out if I could use the lookup function, but this only works for fields that are invalid it seems. What I really need is something like: min(findRecords(othertable:field>0)) Thanks for any help in advance.

I have just started using FM. I am currently developing a database which requires a Internal Rate of Return (IRR)calculation. I have searched high and low and cannot seem to find a plug-in or solution that may provide this calculation. Can anyone help point me in the right direction? Thanks

Is there a way to get fileMaker to recalculate everything based on a changed value? For example, i have a sales report I just put together. I have used data from a db that already existed but did not have salepeople listed. I have since created a Salesperson field. the report should show a list of all of our jobs including customer and sales person. All of the records that existed prior to the addition of the salesperson do not show the sales person. I have to manually slect the name. It works for all new work.

I have two database that are related. I have the title of database A being derived from a calculation from B (looks like Title A = Title B ) The caluclation works and the title is transfered and all is good. However now I want to turn the Title field back into a text field and not a calculation. How do I do that and save the text as well? I try telling it to store the calculation but it says "The Calculation "title," cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with a global storage." Please help, thank you.

I hope that some of you can point me in to a direction to get this to work. I have a booking system made in fm5 and it keeps track of rooms in a hotel and I would like to make a new version in Fm8. I have tried to import the old files to Fm8 but the result was not very good and it didn�t work. With all the new functions in Fm8 do I believe that it can be done in a mush easier way but the question is where to start. I found this at a very good site about filemaker http://www.nightwing.com.au/FileMaker/demos7/demo705.html that file will do the trick for the bookings but how to do a graph with different colours for different customers? Anybody Max

I am creating a ranking system that I want the user to enter a number and when that number is entered I want a bar to appear representing that number. Is there a way to fill a field with a color using a calculation? I want to avoid using a relation situation. Let me know if there is a better way, if not thanks for any help.

Can someone guide me in the right direction. I have here a small sample of date time rate calculation I need help with. I assume to convert the date into hours and the hours into seconds and then calculate the rate. I'm really lost, how should I start approaching this? Thanks TMAS TimeStamp.fp7.zip

Hi All, hopefully this one isn't going to be as hard as I think it is. I want to record my working time for the day, I start at 8:00am and finish at 4:30pm with 30mins for lunch. I've worked out daily total in minutes (480 usually) but I would like to display this as hour and minutes. For instance if I start at 8:10am my total for the day would be 470 minute and I would like to display as 7:50. This last part I can't work out - Is it possible? Thanks Pedro -)

I can't test this right now so I was hoping some of you know ... I use a Modification Timestamp (auto-enter called ModifyTS) but not all clients have the exact same time. I want to switch to a host-based idea. Since we can't use an auto-enter (HOST Modification TimeStamp), would the following new calc (auto-enter, Replace) work? Let ( trigger = ModifyTS ; Get ( CurrentHostTimeStamp ) ) The auto-enter modifications is the only thing that I know of which will fire when ANY field within a record changes. But I don't want THAT time ... I want to capture the host's time. If I'm over-complicating, just bonk me! UPDATE: I realize it works in stand-alone.…

Is there a way I can duplicate (copy & paste ??) the contents of a specific field for all the records in a table? So far, I can't seem to use the 'select all" feature to highlight the field for all records; it just works for a single record. There are no unique fields in the table that I can use for a lookup on a new field. My objective: I have a table with about 1,600 records. One text field has one or more numbers (separated by commas; there's no need to sort the field). Due to a last minute update, all the numbers have to be changed -- usually by making them one digit higher. Before I do a "find and replace" operation across the entire table, I…

I have a DB that requires barcode fonts @ 10 or 12 pt to fit in a line item layout .... using Intelliscanner hardware (which does work fine). I have downloaded "Free 3 of 9" and added them through OSX's Font Book but they are unavailable in FM for some reason. Also, apparently, some barcode fonts also have "stop and start" features. Any information on where to get the right one would be greatly appreciated.

I want to create a serial number field, starting at 0001 for each new job ie associate number with job number. Any suggestions -thanks

... Could someone please explain to me how the heck you use these things, how you access data in particular repetitions, how calculations in different repetitions of a field are evaluated, if you enter different calcs into different reps of a field... just plain old confused - i mean, there's something in FM i don't know how to use at all - even if it is outdated in most cases - i'm sure it still has some uses. Cheers, ~Genx

Is it possible to having text flashing ... Thanks much

I have a calculation field defined as: If( not IsEmpty(x),If( IsValid(x), 1, 0),1) Field x is defined to be "strcict data type" numeric only. However, when field x = "15/yr" or "10-15" the calc field is resulting in 1. Shouldn't IsValid return false in that case? Thanks in advance! Courtney