Calculation Engine (Define Fields)

Hello! I have a calc field that determines a discount based on a global field that represents the registration fee of a "league type" and the actual fee paid. It is unstored, and in a table called "financials" I have a "players" layout with a portal for financials. Now here's what's driving me bonkers.. The calc works fine when I open the app and use it on a windows machine. However, on a Mac it will not work. If I go directly to a financial layout(not to the portal) and enter data, it works just fine(on the mac)but not on the players layout. Can someone make a suggestion as to what might be the problem, or where to begin trouble shooting. Thanks.

Hi, Hope you can point me in the right direction.... I want to display in my line items file the commission % based on the criteria of - Employee and Type. I have setup the types (Product 10%, Services 15%) on the employees table. At present it displays on the line items table the employees name and the type (Both via Calcs from the appointments table) - what i need to do (I think) is build up a case statement.... But how would that work if you add a new employee??? If i can get the % number in a field in the line items table, it should be easy to calc a employees commissions based on what they have sold? (Is this the best way to go about this?) Thanks…

Hello! im stuck again, having problems with some parts of a status layout im making. There is one member layout, and in that layout i write in a radio button if the member is a new member or not, and with other radio button if is an active member or not. I want to do a status layout showing how many member we have, how many new members, how many active and how many non active members. Can somebody help me with that?1 thanks!

Hi, I've got a calculation field that is running the following calculation: If ( field one = "x" ; field two) This achieves the desired results. But, I also want to check field one for "y" and return a different result. I assumed I could add another "If" statement or an "else if" or "else" but can't seem to get this to work. Is there another way to get this done? Thanks!! -Wing

I have a calculation field which is a SUM of several other fields (all numbers). I would like to compare this calculation field to another number field, with the result of either GREEN or RED number, depending on whether or not this field has a higher numerical value. In other words, if field A is smaller then field B, I want the field A be in RED, etc. How would you write such a calculation and how can it be added to the existing calculation ? Many thanks !

I have a field that is either a yes or no. If someone selects yes, it creates a record into another related Table and that part works fine. But what I want to do is that if they had selected yes and created the record and then go back and select no that the related record is deleted automically without dialog. Stumped yet again... Thanks

I have a requirement for three seperate parts of a database to reside in four locations, one in Bulawayo, one in Houston, one in Illinois and the master In South Africa. The date formats for input will then be UK format in Bulawayo and South Africa and American in the other two. As the whole database is mastered in South Africa is there a way to set the input format correctly for the various sites and then have the date converted automatically when the input from America is imported

I have a telephone number field in many of my layouts. I would like the phone number autoformatted to (xxx) xxx-xxxx after its entered. Preferably in whatever way its entered to have the numbers formatted as above. Sorry if this is simple and I'm missing it. I'm new to FM.

Hi I want to create a basic finance entry database for income & Expenditure. I was going to create 5 tables for 5 years and then each table layout having 12 tabs for each month. Each tab would have 5 columns for the 5 weeks of the month. Anyone know if its possible to not have to create the same fields dozens of times for weeks 1 to 5, months 1 to 12 and years 1 to 5! Much appreciated! Trevor

I have records in a table and one of the fields is a date. I want to be able to count the number of days for the records that I have selected. For example, in the 6 records below there are 3 days. Is there a calculation that will determine this or do I have to loop through all the records to figure this out. As simple as it seems I cannot come up with a solution. Thanks for your help! 1/12/07 1/12/07 1/12/07 1/15/07 1/16/07 1/16/07

I have multiple records that contain a field "status" with values such as "Status 1", "Status 2", "Status 3", etc and also contain a date field. The primary key for the database is a concatintion between of "Item ID" and "Status". I want to calculate the number of days it took for a particular item to chang from Status 1 to Status 2 and I'm oping to do this in a field definition rather than a script, any ideas?

Hello! im having a problem. Im making a file of invitations. For example. In my layout i have to write who invited me, and down to be displayed every person that i have invited. The problem is that one person can be invited by one or more persons, how can i do that? please, somebody help me.

Hi, Im completely new here and struggling with what should be a simple thing. I have a database with 2 layouts - 1 info 2 financial. When I tick an Invoiced check box (in layout 2) I want to display a graphic on layout 1 which says invoiced in big red letters - any Ideas?

I'm trying to get multiple modification boxes stating the name of the person who modified it, the date, time, and reason. I've got the name and the reason figured out, but I can't figure out how to make multiple modification boxes. I know filemaker can create one easily but I must need a function to make more. What I need basically is a modified by 1, with name date time and reason, then a modified by 2 with name date time and reason, a modified by 3 and a modified by 4 with the same information. Is there any easy functions to do this? I'm a beginner and really don't know a whole lot about this. I was thinking I could just have it check to see if modified one had any…

I'm a fairly novice FMP user. I'm trying to create a field that will display all the entries from another field within a found set. Can someone enlighten me? i.e. this is for emails. To search for a set of email contacts and then have a cut & paste field in which I can copy them all at once. Thanks!

Hi - I'm having a problem I've seen posted elsewhere but none of the solutions suggested seem to do it for me. I have a list view with summary fields in a trailing grand summary (Simple Total of type summaries). They start out correctly. However, after a script goes through and makes changes to the records in the list, the summary fields do not update. A calculated field which is on this layout but comes from a different table and is the same as one of the summary fields DOES update after the script runs. Changing modes does not help. (ie preview and back). Clicking on background of layout does not help. Adding "commit record" steps in script after each…

Greetings, its been months since i have been on here, but i have a new task and need to clean up an old database. The first and foremost thing i need to do is to delete old records but i cant think of a good way to do it. My Scenario: I have about 30,000 records and only 10,000 are useful (therefore it would be tedious to go in one by one and delete the unused ones). My criteria for deleting the records is that if they dont have a call history of any kind i may as well delete them. The call history is actually a portal "Contact Calls" which is related to the "business info" table. I want to delete all records that have zero information in the "contact …

Hello, I am trying to create a field that will sum data from another related table. I have 5 tables, one for event info, one for daily individual costs by event and date, one for daily totals by event and date, one for event totals by event, one for accounting totals by event. The daily individual costs have a department field and various other financial information. In the Daily totals table I would like the department field to calculate the total of the individual costs broken down by department. (for ex: all operations expenses for the specific date would total in the daily operations field in the daily totals table) I am not sure how to do this an…

Hi Guys, This belongs either here or under scripts, I'm not fussed as to the solution but would probably prefer calc based. What I essentially want to do is have values (percentages and dollar values) removed or added to / from an initial value to produce an end result -- Given that percentages are used, order matters here and I can't quite wrap my head around this. The deduction set is user specified. Custom Functions for this would also probably be useful. I've attached a simple sample because my wordiness usually lacks sense To add an entry to the deduction set just go to the deductions layout, I've just used a Cartesian here sooo.. Any help is ap…

I cant seem to get this to work. i have 3 seperate calculations. one being current date - date of birth = age and date field + 2 weeks = projected date field and date field + 45 days = projected date field. i know it probably simple as hell but cant figure out the parameters. Thanks in adavnce.

I have a field with three possible entries: U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT. Is this possible? I am using both FMP4 and FMP6. Thanks in advance for your help.

Hello, I'm creating a database for a laboratory that I work in to keep track of our chemical inventory. Each year we have to print reports of our hazardous chemicals and an approximate amount of what we have in stock. My problem deals with the different number of units that we use. Mostly its grams, milligrams, or kilograms. (or liters or milliliters for liquids) Is there anyway to have a clause in the calculation to look at the units and multiply it by a factor? Since we only use metric units we should be able to just multiply by a power of 10. I've attached what I've come up with so far. I would appreciate any help into this problem thanks …

I have a table "Payments" that is displayed in a portal and set to have records created via the relationship to the parent table. I need to validate all of the payments (records in the "Payments" table) made but they don't validate when the record is first created but they are validated when the record is updated. I am trying to figure out why this is happening and if there is a way around it. Is it possible the problem is because the validation refrences a related field? It also looks like if a payment is deleted an unstored calculation using Sum() still counts it as well as a summary field. Is there any way around this? Running FMP 8.5 Advanced on Windows …

If someone clicks on a button to go to a specific layout, I want a Dialog to open and redirect them back to the original layout if a specific field is populated. Thanks, Stumped

Hello I have a two table file. I would like to write a script that would pull the data from a field called "url" in the table "backgrounds" and place the text in a field called "web". The part I am having difficulty with is getting it to go to the next record the next time I acctivate the script and doing so with each click of the script by a button until it has copied and pasted each bit of data from the field "url" so that the related table will perform a lookup. Can someone help me. I simply want to click on a button and have the data from the next record copy and paste into the table "Customer" field "web" coming from the data in the table "Backgrounds" field "url…

I am stuck on a calculation and need some help. I have created a calculation on a date being show 4 weeks before a certain date field. eg: ="Date Due" - "Call Date" But what I want is a calculation showing that if, the call date is past the current date, then the formula equals = "Current Date"+4 I am not sure how to do it via the "if" function. Thanks In Advance

I have a repeating field that have created a calculation for. The calculation basically says Case(Incident type = "Theft"; 1;"") this would return a value of 1 should the incident type be theft. I then have a summary field that totals the entries for the incident type that = "theft" However this is a repeating field. Reason being that in addition to theft the incident may also include burglary for example. Is it possible somehow to have this field report both events to the summary field or is it as I assume... that only the 1st entry in the repeating field is going to show in the summary. if thats the case I'd be happy to hear any suggestions to remedy my dilemma. Tha…

I have two fields: Networks and Servers. There can be many Servers which all belong to the same Network. But no Servers belong to more than one Network. Each record I have looks something like this: Network Server A a A b B a B b B c C a So what I'm trying to find is -- using a Calc field if possible so the data can remain constant, i.e., not dependent on summary layouts -- how many Servers does each Network have? (In this case, A=2, B=3, C=1).

Greetings, I need to get the values on the left and right side of a decimal. I have the left side figured out via the truncate function, however, how do I get the value on the right side of the decimal? Left Side Calc=Truncate(TOTAL_COST, 0) Ride Side Calc= Any help would be greatly appreicated. Thanks in advance!

I have instances where I would like to use an alternate name for a field. My plan is to set up a calculated field that simply lists the primary field as the "calculation". Is there is a downside to doing this? Is FileMaker smart enough to recognize that it's a simple equivalence? Is there a better way? Thanks in advance for any advice.

Hi, I'm stuck with a ormula and although I can get it to work using loads of if statements I'm hoping there is a easier way. Basically as a practice project I want to make a program that can work out the best poker hand from data entered. I've got all my fields set up (flop1, flop2, river, etc) and I have used the case statement and lots of AND and OR's to get it to pick up pairs, trips, etc but I'm thinking there must be a easier way than listing all possible combinations? Also I can't think of how I would use this method to pick up the straights, etc. So far I have not included suits. just numbers. Any ideas?

Hi all, this is my first time posting here, and Id like to say hi to everyone as this seems like a really friendly group, and im thankful this site exists. First the background...Ive been using filemaker for a bit and have used it to run simple sports stats without problem (wins, losses, points. etc..) Now I have been asked to create a database for work that tracks staff stats (I work in a callcenter) I have built a database that tracks all the stats individually for each week, which all pools into a layout for the quarter, everything works fine if you want to see what a certain tech support agent has done for the week, month or quarter.. but where Im lost is ho…

Hi, I am a complete novice with Filemaker, so please forgive me for asking a question that is probably very simple to answer. I am trying to set up a database for a research project. Basically, we will be entering a record for each time a behavior of an animal is observed. There will be several hundred animals, for each of which there will be many observation sessions. In one observation session, there could be 200 total occurences, each of which could be one of a 10 different behaviors. My inclination was to have one record for each individual tied to records for each observation session, in which I would define several repeating fields (time, behavior, et…

A customer decides what items they want. From a customer database a new job ticket is created and all of the items this customer wants are entered via a portal. As the items are entered, fields in the portal are populated with information from another database about the item such as price, color, size and category. The category may be wood, metal, plastic, glass, or paper. The order that the items are entered is critical for assembly at a later date. None of the categories are really important except for the paper one. What I need is a (auto entry) counter so that everytime paper is the category a (field named paperpostion) would populate with it's position (starting with…

Hi, I have a calculation set up to show the state of a checkbox (True or False) if a container is populated. Now I need to alter this slightly, I need the checkbox to show False (off) if; has been pasted into the container and True if; C:windowsdatafilesassetsxyzfoto.png has been used instead. How do I reference these external files correctly? My current script is; If (IsEmpty(Foto) ;"F";"T") ...which works as normal. Thanks!

Hi, I would like to create a script that upon opening the application the following occurs... 1) If the date from a "Est. Completion Date Field" is more than 60 days old, then the field named "Project Status" is changed to read "outstanding". I'm new to FMP so any help would be great... trying my best to learn on the job. Cheers, Dan :

Sirs, how would I do a calculation for the time difference between two entered fields, such as Start Time, End Time? I have tried to make such a calculation, by making the start and end time values TIME, but the result makes no sense. It thinks the time value, for the 24 hour clock, is minutes. It will not display the time normally, but puts the : mark after the minutes and then adds seconds, thus 1630 is displayed as 1630:00, which must have something to do with the calculation. I cannot enter the times as numbers since the calc will be totally wrong. I do not want to use the 12 hour clock, but will if this is the only way to do it. And if the two times are on diff…

I see a lot of great posts here, but none that address my issue. The main "problem" is that I am new to FileMaker (and databases in general) and I have to tackle the reservation, invoicing, etc project created by a former employee. They did not complete the project but it is usable with some limitations/errors. The first issue: We have a 'booking number' field that is calculated using the 'arrival date' and first 3 of 'customer's last name'. The 'arrival date' is entered via calendar. Problem is that if the month and/or day is a single digit, the 'booking number' field will have slashes inserted in place of the number. If I setup the calendar to insert lea…

I require a field that always shows the current date - I have tried a field with an auto enter calculation of Get(CurrentDate) and set to always validate but this is not working. Can anybody show me where I am going wrong. many thanks

Hi All, is it possible to calculate the average price from the last three purchase orders for a stock item? I'm just not sure how to obtain and evaluate just the last three prices. Additionally some low use items may only have one price recorded for that item which makes it a bit harder. Thanks Peter :-)

Our company makes vitamins. We have lots of powders and keep track of the batches used in production. The idea is that the mixing in charge scans the barcodes of the batches into a field. Each barcode is always a length of 8 characters. If he scans 3 barcodes, the field will be 24 characters long. I am trying to create a function that will reformat the text like so from: xxxxxxxxxxxxxxxxxxxxxxxx to xxxxxxxx, xxxxxxxx, xxxxxxxx I cannot get the function to work. it would be a text field with a calculation to reformat the text. Any help is appreciated.

I have been struggling for over a week to solve this problem and I am hoping somebody can see my problem. I am trying to get a beginning balance calculation to work. I have a doantions table, disbursement table and a cause table. The cause table keeps tracks of what a donation was given towards. I need to get a calculations that will show me the beginning balance for each Cause. This would be Donations minus Distributions for each Cause Code (ProjectID). I have created a calculation that shows me the beginning balance for donations in one field BegBal_R. This is based on what reporting month the user selects. So if they want the beginning balance for January 200…

Here is an interesting "thing" I ran into. I have two related tables. Some of the fields in table two, upon record creation, are to be given the existing value from fields in the related table one. The fields to use are in the calculations for the fields in the database info. This works great if adding the new record for table two through a portal on a layout assigned to table one. However, if adding a new record to table two on a list layout assigned to table two none of the fields are given a value. I have to use a script to enter the values before commiting the record. Can't find anything about this in the manuals or outside books, seems there are a lot…

I have a timestamp in Table1, call it SomeTime and I have another field in Table1, call it Temperature In Table2, I have a timestamp called WeatherTime and a field called WeatherTemperature. It is highly unlikely that I can use an exact = relationship between SomeTime in Table1 and WeatherTime in Table2. So I 'know' that my weathertime(s) come ever hour. I created another timestamp field in Table1 called SomeTimePlusHour. I'm banging my head against a wall trying to use a spiffy relationship to Table2, like ">" SomeTime, but "<" SomeTimePlusHour. So It isn't working for me. Does anyone have advice for looking up tabulated values using a 'close…

This should be simple - but it's mystifying me. field:t_DeptChair? If record is for a Department Chair, the user clicks off "Yes" in this field (Yes is the only choice -- it is left blank if not valid). field:t_calc_Active - this calculation looks at the end date of the record and returns "yes" if that end date is AFTER today's date, meaning that Title is currently active. If the end date has already passed today, the calculation returns a "no" value. field: t_calc_CurrentDeptChair = If ( t_DeptChair? = "Yes" and t_calcActive = "Yes"; "Yes"; "No" ) On the Titles layout, the calculation works fine. However, when I place that field in another, related …

I need to put into a claculation field the contents of two other fields; Field1: NUTS Field2: BOLTS CalcField:= NUTS BOLTS At present, my calc field, which is obviously invalid, returns 0. Many thanks! Frank.

I've got a working solution that allows users to record information for a project (header file) and then record specific tasks with the associated start and end times in the related detail file using a portal. What I would like is for the start time for the next entry to default to the end time of the previous entry. For example, user creates a header record, then puts the first line of detail in the portal such as: Travel, 9:00 AM, 10:30 AM, and any comments. They then tab to the next line and enter Support, at this point I want the system to automatically enter in 10:30 AM as the start time (based on 10:30 AM being the end time of the last task. I've tried us…

For a linguistic study, we will making voice recordings (must be uncompressed .wav files) and would like to use FM Pro 8.5 (for OS X), to store the files and related data. My question: In FM Pro, can we store a .wav file in one field and related text documentation in other fields of the same record? (In other words, the .wav file and it's assorted text documentation would live in different fields of the same data record.)

Hello everyone, Is it possible to define the results of a calculation field to be unique without transferring the results of the calculation to a different field? For Example FullName= FirstName & " " & LastName Result not allowed if not unique. I don't see how to add a valdiation without taking the result and trasnferring it to another field that allows for validation. Am I missing something basic that I should know about, perhaps in the functions? This might seem like an odd request as I think about it, but it is import to the DB I am working on. Steve PS It is not about names...but that was easy to …

Need Help : I lose the value of the global variables when I quit FileMaker!!! All global variables are prefixed with $$… I try in FileMaker 8.0 and FileMaker 8.5 and the result is the same. Why? Tks ================================== In FileMaker Help says: "A global variable can be used in a calculation or script anywhere in a file, for example, other scripts or file paths. [color:red]The value of a global variable is not cleared until the file is closed. [color:blue]Prefix global variables with $$. "

I hope this is the proper place for this post. I have an old solution that includes some repeating fields (i know i know its on my list for redesign but for now i need a work around), I need to allow my users the ability to at least "insert" a blank repetition. The user would define where this blank would be inserted. and in a perfect world the users would be able to rearrange the data within a repeating field. I know im asking for a lot but this is a BIG file (and heavily used) and it would take a long time to really fix it right. If i can provide this functionality it would be a huge benefit to the users. If anyone has dabbled with this sort of problem pl…

I have a basic filemaker template for timecards for employees. wonder how to modify a box that say it is not modifiable. Have tried every trick I know using the layout feature. Anyone know how to do this :

I have a calculation field "deleteButton" that always returns the value "delete". When it's okay to delete a record (according to a set of rules) the value appears in the color assigned to the field. But when it's not okay to delete a record, the value appears in a "grayed out" color. How can I have my Delete script check the color of the value in that field?

I need to make a simple set up of a statement ie X + Y = Z. I would like to just have three blank fields for X,Y and Z. If the user enters any of the two, it solves for the third. The only way I can think to do this is to run an action to detect which fields are not blank and then, calculate the result of the third. Is there an easier way to do this. (I would like to use 6 variables and it gets a bit messy) Thanks

Hi, Here is my problem. I have a checkbox with 5 options. Call them check1,2,3,4,5. and the field itself checkbox_Checklist. Now depending on which checkbox is selected I want to display a second field. So say check1 is selected I want Check1field to display and also want the check1field to display the number 1. So would this be IF (checkbox_Checklist = "check1";"1";"")? Because I have tried that and it didnt work. Any help is appreciated. Thank You, Eric G.

Hi - How do I link a container field (containing a QT Movie Link) to a checkbox field (Has QTMov: T;F)? Many thanks! Frank.

Greetings Fellow FileMakers - I have a field, call it Field1, it's a Container Field (albeit, the same thing happens with a text or any other type field...). When I turn that field into a button, and attach a script to it to look at itself - it doesn't see the data (I run a Show Dialogue after Get(ActiveFileContents) it shows nothing) (or I Set some other field to it and nothing shows up...). I subsequently noticed that there are two tab numbers attached to each buttion field in the layout.... hmmmmm. Side point: If I make one of the two (the first) buttons active from a tab perspective, it seems to get the field contents. When I make both, neither or the second tab …

I'm trying to get FileMaker to print checks. Example: Amount of check: $1,359.37 For the purpose of printing the check, how do I get the amount of the check to also appear as: One Thousand Three Hundred Fifty-nine and 37/100 Is this possible?

I have a database which produces students end-of-term report cards. I have an Overall Comment field which is made by concatenating a Course Outline from a related table and a teacher's comment, which is individual to each student. I also have a Year field, which records which year each report was created. The Course Outline is common to all students following a course in a particular academic year, but will change from year to year. I want to be able to find last year's report cards and see them as they were - Course Outline and all - even if I've changed the Course Outline to suit the updated course this year. However, because the concatenated Overall Comment field…

I have the feeling I am missing something obvious. I am trying to get a field that will have an assortment of letters in it, based on other fields. Sample outputs - None F I P S T D F T ....and so forth My attempt - If( Frog="Yes", "F" , If( Iguana="Yes", "I" , If( Puppy="Yes", "P" , If( Skunk="Yes", "S" , If( Tiger="Yes", "T" , If( Dog="Yes", "D" , "None")))))) I have the feeling I am missing something obvious...anyone point me in the right direction?

I have a database that is held in 2 locations and data is entered in the same table. Following data entry the information is then exported as Excel, emailed and imported in a third location. As this table is then related to a recipients table by a unique ID I have defined three field for ID purposes. The first is an auto enter number field, the second is an alpha field which gives a single letter determined by the user name and the third is supposed to be the ID field by combining the information from the two other fields. The problem I am having is that the ID field is just showing 0 when the Alpha field is showing I and the number field is showing 0006. I have define…

I give an example file below: FM calculates two consequently years two days less... In real time a year begin 12 a.m in 1/1/xxxx and end 12 a.m 12/31/xxxx. No I did not post this thread two times. Pascal test_dates.zip

I know this should be very simple to do , but I can't make it work right. I don' want 9.99 showing up in the "Total Buy with Comm" field when I'm using "Sold" field & likewise I don't want 9.99 showing up in the "Total Sold with Comm" field when using the "Buy" field. Please tell me what I'm missing. See attached file Stocks_.zip

I wonder if we can transform calculation fields into regural edit fields by a button or anything else. This will help the users to by-pass automatic processes and complete the fields of their own. It is very usfull in cases that user or client already know time or expenses and does not want to complete fields in order to get a known result. Pascal

I have an Inventory table. In the main view I have a QOH_store that is a calculation of Count and Sold. When I make a new layout that displays the QOH_store and the Sold Fields, the QOH_store field isnt updating automatically. I have to click in both fields to update the info. HOWEVER, just clicking one of those fields doesnt update both of them. I thought maybe using the Relookup would help but it says that there are no fields that lookup values based on the Sold field, which is not true...

I have a calculation field that returns text. This text being simply "Yes" or "No". I wish to find all the records with "Yes".... but when pressing a button that enters find mode and enterering Yes into that field. The find will not perform... this happens for all my calulation fields.... How can I overcome this?

Dear experts, I have to put a problem again although I will try to give solutions of my own. I make this because I always seek for my huge I confess educational database to run smoothly and without problems. THE PROBLEM. Let us supppose that a teacher taught to five different schools from a DateStart to a DateEnd per year in last five years. We want to calculate the total number of years, months and days that the teacher taught to the schools in the last five years. But also we want the total number are not only in days but have the format xyears, vmonths, zdays. I hope you understand if you do not I will give an example but I think it is relatively easy…

I am trying to find the difference between the creation timestamp and the current timestamp, then if the difference is more then 20 days to set that record to inactive. Timediff :[color:blue]Calc, unstored = Let ([ time = Get ( CurrentTimeStamp ) - Timefirstshark ; days = Div ( time ; 24 * 60 * 60 ); time = Mod (time; 24 * 60 * 60 ) ]; days & ":" & Hour ( time ) & ":" & Minute ( time ) & ":" & Seconds ( time )) Active:[color:blue] Calc, unstored = Case (Timediff > "20:0:0:0" ; "No" ; "Yes" ) It seems to work at first, but then for some reason it thinks 10:0:0:0 is less then, but 4:0:0:0 is greater?

does anyone know where I can get a filemaker 8 tutorial video that is explained in the windows format and not the apple. It would be much appreciated......

I have a client who wants one field on their data base to be required only if another field is populated with certain information. Is this possible? I know this syntax is incorrect but, Basically: If (Field_X = "Condition_A") Then Field_Y ; IsRequired) Else Field_Y ; Not_Required) If anyone can help I would greatly appreciate it. Thanks, Steve

Hi I want to add Bold & Underline buttons beside a text box. Anyone know how? Thanks Trevor

I know this is very simple but I can't seem to figure it out today. A system that I'm working on has an orders table and a commissions table. Commisions are related to orders by an order ID and a single order can have multiple commissions attached. Each commisions record also shows a SalesRepID. From the orders table I need to show the SalesRepID from the Sales rep that has the highest commission on that order. Any suggestions would be apprecaited.

Each of my layouts are designed to be printed, but is there anyway I can create a non-printing custom navigation bar along the left-hand side of the screen? I currently have all my buttons along the right, off the printed page, but I have two different types of buttons I'd like to categorize -- navigation (between table data) on the left, and action items (ex.: launch script) on the right. For each layout the items on the left would remain the same, but the items on the right would change depending upon the actions particular to that data. I could swear I've seen others DBs like this, but don't have an example ready for me to see how it was done. Thanks! Lisa

Ok here is my problem. I have a field that when the record is created displays the date and time. It does this using the Auto-Enter/Creation/Timestamp/(Date and Time) setting. Now I have a second field called "Due Date" I want this field to display the date 14 days after the creation date of the record. I have tried "Due Date = Creation Date + 14" but that displays just a jumble of numbers. Is there something I am missing? A calculation command or Field format? Or am I just taking the wrong approach to this? Thank You, Eric G.

Okay, I've got a database (table?) with almost 1000 contacts that I have been accumulating over the years. Now after reading the "White Paper for FMP Novices" I see the value in having an ID Field as described therein. I want to write a script that will accomplish this after the fact and another script that will perpetuate the autoentry in the future. Am I being clear, I hope? I have called my new ID Field ContactID. I want the serial number to begin with 1001 and each record to have its own unique number. Also I am curious why we cannot just create a field that will reflect each record's record number that FMP seems to generate anyway? Wait, I think I know the ans…

Hello can i create a summary by 2 search dates. Let me explain jobs are entered every 2 weeks from the 1st to the 14th and from the 15th to the 31st, an invoice is then created for both these ranges but on the last period 15th ---31 the invoice is created on the 1st. here is where i have the problem. i am breaking a summary by the month, via the invoice date but i am always a job period behind so for example i have Jan 200 feb 400 march 410 april 415 etc........ but if i do a manual search by invoice date lets say 5th of jan to 5th of February the result is correct. but now i cannot list the summery as Jan Feb March etc........ …

AddressList.fp5 includes a multi-value field with BookIDs in it. People in the AddressList may have 0, 1 or multiple BookIDs. BookList.fp5 has a multi-value field listing the PersonIDs of everyone in AddressList.fp5 who has that BookID listed. The multi-value field in BookList.fp5 will apparently only read in the first value it finds in any multi-value field in AddressList.fp5. Any way to accomplish this? Thanks.

Need to know the most efficent way of doing something close to this: If table::field is in the records of 2nd table::field then etc. would work just as well if not member of... We are inputing websites into a database and doing a whois data capture on the base domain. So URL table one has all the websites and Whois Table has all the domain info. The URL table can have multibles of the same domain, but with different websites. So, was looking for way to flag the user that that URL while may be new has a domain that has been catured already so the user does not have to spend time doing a search on the second table.

I've got two databases, projects (PRJ) and employee names and email addresses (EMP). I'm trying to compare a last-name field in PRJ with a last-name field in EMP and, if EQUAL or even SIMILAR, put that employee's email address in a new field. I tried: If (PROJMGR = Employee Table::Emp. Last Name; Employee Table::email;0) But the comparison between the two text fields doesn't work. Thanks for any help! Steve

I have a container field in my layout where our users can drop files, pictures, etc...the problem I'm having is that the container data is automatically downloaded when user is seeing that particular record . Is it possible to have the container not downloading until the user actually chooses to download/save the file? Thanks

I'm trying to set up a calculation field that counts the number of a certain type of related record in another table. For example: employee table is linked to the Absence table I want a field in the employee table called "Count Sick" to count the number of related absences in the Absence table that were coded as sick for each employee. (I have a reason code field in the Absence table where I select the reason code from a value list. Here's a psudocode example of what I'm trying to do. Count (Absence::Employee ID) WHERE Absence::Reason Code = "Sick" Any help is appreciated, thanks.

I need to sum values from a field (A) based on the value of another field in a different table (X). I can do this by "finding" X=1, sum A but I want this in a calculation. In fact I need to show three values in one place if X=1, Sum A if X=2, sum A if X=3, sum A can someone show me a calculation that will do this?

Hello! I just created a database for our HR department showing CURRENT information. But I need to be able to keep a track on the changes that I have been made in the previous months. Especially for salary, I need to be able to print salary reports of the previous months. Can someone help me with an easy solution?? My idea (quite complicated!!) is to transfer automatically at the end of each month the info into the next month. Is this the right way? Thanks for your help!

Hi Can anyone help me. I am new to this forum - but I am confident someone maybe able to help. I am running a modified version of the Business Productivity Kit and I want to generate a report that will give a break down of how many of each product (from the inventory) is sold each month. I can do a total, using a calulation sum(), but I can't slpit the data into months. Can anyone help? Thanks

Hi In one field there is a pop up calander where a date is entered. What I want to do is when this date is exceeded by 3 months some kind of wanring is displayed in a field. Anyone know how? Thanks Trevor

Does somebody know how I could parse a 12 digit number that starts 16 digits in and ends 4 digits before the end? For example the string of numbers 9761243631002561 724686727627 2019, the numbers that are in the middle are the ones that need to be parsed from the entire string. How would I specify that in a calculation? Thanks for the help.

Hello fmp community! This is my first post--have been trying to figure this calculation out. It seems like it should be very simple, but can not find a post that deals with same issue. I have a field that calculates TOTAL RECORDS in entire db. I need another field now that calculates Total Records since Jan. 1, 2007 (YTD). I have a "Date Initiated" field to pull date from. Can anyone give me any guidance? Thanks!

I use calculation fields to dynamically display content from 2 different fields depending on the scenerio. I would like to be able to preserve the formatting from the original fields so that they still display with their original formatting in the calculation field. Is there a way to do this? or am I stuck with the fact that my calc field will strip formatting no matter what?

Greetings Is there a way to import VCards directly in to FMP 6? If not direct how does one import them most conviniently? Thanks

I have a table within my database where the user will create a record and a field called "record number". For other calculations and relationships to work within the database it has to be a two digit number. If possible I'd like to have it setup so that when the user creates the records it starts with auto-entering 01 then moves to 02, 03, 04 etc... I'd also like to make it modifiable by the user but make it so that it has to be two characters if they choose to change the auto-enter number. Ideally the auto-enter number would look at the previous record number and always go to the next sequential number even if the user created a record and then delete…

I need to put restricted data in a field using an If() statement in a script. Basically it comes down to those 4 steps, and it is working well: if value in numberField1 = 400 and value in numberfield2 is higher than zero set field numberField 3 to numberField2 if value in numberField1 = 400 and value in numberfield2 is lower than zero set field numberField4 to numberField2 if value in numberField1 = 440 and value in numberfield2 is higher than zero set field numberField 3 to numberField2 if value in numberField1 = 440 and value in numberfield2 is lower than zero set field numberField4 to numberField2 Now I have to add an additional …

Greetings Fellow FileMakers - What is the best way to calculate FICA for payroll, taking into consideration the FICA Maximum ceiling? Thanks for the help... Royce

I've got a field with a character that repeats itself throughout "%". I want to pull data from between these occurances into separate fields. So "field l" would be all data up to the first occurance of "%". "Field 2" would be data from the first occurance to the second "%", and so on...

Hello, wondering if someone can help me with this. i am running FM 6 pro on a mac. here is my problem, i am trying to find the total of hours a student has done for each subject. There are break down T for Technique, A for Anatomy . This is where it gets complicate a little bit because the subjects go from T1 through T25. Each Subject get assign specific amount of hours. So i want to know what the total hours are for all T (Techiniques) and Anatomy. i thought of doing a case to fine all T and A. i am not sure where to start. any help would be appreciate it thank you vic

Greetings FMers: Is FM8.5 the first version to VIEW PDFs? Thanks, Royce

I am trying to figure out how to get the number of characters that are in a specific field. I would like to do this in a calculation to use with a case function. I could not find anyway of simply getting a count of characters in a field. Any help would be appreciated. thanks.

Hi, this may be easy but I cannot figure this out. I have a field that will contain a Fedex tracking number that will be entered by scanning the barcode on the FedEx label. The barcode contains 22 digits of which the last 15 are the tracking number that needs to be parsed. How would I setup a calculation to throw out the first 7 digits and keep the last 15 in the field? I would appreciate the help, thanks.

Hi. I'm running on a filemaker pro "Business productivity Solution" Template. It runs fine but I'm Having trouble auto updating my inventory quantity field using the quantity entered in the Sales order. Exemple: Original Inventory Qty = 10 Sales order Qty = 2 New Inventory Qty should be 8, but remains 10. Thanks for your help.

Hello, I have a database that tracks donations by donor and by the cause they donated to. I need to create a report that will show a specified month's total donations in one column and the summary of all prior donations in another column. Eventually I will have total balance column which would add those two fields together. I have created two global fields; ReportMonth and ReportYear that allows the user to select the month and year to print. I have created a calc field called RptMtDonations. It has this calculation:If(Year(Donation_Date) = ReportYear and MonthName(Donation_Date) = ReportMonth;Amount;" ")This returns the donations for specified month a…

Hi, I'm importing text via XML (through a hack, not through the regular FMP methods) in a way that can preserve the xml tags. My question--and this would apply to importing HTML, tags intact--is whether there's a way to change these tags into formatting information that FMP would recognize. So that italics would be italics. Bold would be bold, etc... The idea is that text that appears inside my text here could appear in italics. Thanks for any help. lmaury