Calculation Engine (Define Fields)

I am using the following equation to change background colors: Case (Inc Hrs < 150;GetRepetition ( gColors; 1); Inc Hrs >151;GetRepetition ( gColors; 2); Inc Hrs >301;GetRepetition ( gColors; 3)) 1=green,2=yellow,3=red I've run various figures in the fields to change the value that is used to calculate which repetition to get, seems to work find until it hits a value of 1000 and above, color changes to yellow. Any suggestions.

In FM7 there is this equation: PV ( payment ; interestRate ; periods ) Does anyone know where I can get other PV functions... This one does not seem to have a varable that I need to get my answer. What I need is a Future Value (FV) in this equation. I know there is a FV built in FM7 but that returns a wrong value...I need Present Value... Can anyone shed some light on this?

how can i add hint to buttons.

Is it possible to have a case function that works between two different tables. Seems easy...I have tried the straight forward method... but it does not seem to work between two different tables. Is this even possible? Thanks Brahim

I need to create a text string that will be used as a command to a serial I/O device. Content includes such things as: a command code e.g. Hex 60; a calculated length field,with the 8 least significant bits stored in one byte and the next 8 significant bits stored in another; and a byte that contains the cumulative XOR of all the preceding bytes. I figured out how to do the XOR thanks to a forum entry here, but when I try to build my text string, the numbers are converted to ASCII, e.g. the hex 60 (decimal 96) displays as two bytes with a value of 9 and 6, instead of one byte. Since the length must be calculated each time, I cannot use constants in the bytes. How do I …

I have a bill to address and a ship to address. Currently I have an autoenter calculation that autoenters the bill to address in the ship to address fields. Now I've added a related file for shipping addresses so when the ship to address is different from the bill to address I want to be able choose from the value list (which has values from the shipping file)and then lookup the values for the ship to information. From my understanding you can't have an autoenter calculation and a lookup in the same field, so I'm looking for any workarounds or suggestions. This seems like a simple thing but I can't seem to find a clean solution. Any help is greatly appreciated

I'm creating a cookbook DB for my wife. Easy enough. I told her that any fractional quantities will have to be entered as a decimal number. She didn't like that idea, saying that it's easier and less confusing to enter and see "3/4" rather than .75 Ok, easy enough - or so I thought. I would prefer to have the quantity as an indexable numberic value, so that if I want to double the recipe (for example), the calculations will be easy to deal with, and for other programming reasons. I tried to change the quantity as a text field, and use the texttonum & numtotext in any calculations. That pesky "/" was getting in the way, though. I didn't want to separate out…

It seems FileMaker (maybe because of OS?) always puts blank values at beginning of ascending sort. I often want a sort order that is forwards (1,2,3,a,b,c) but which leaves the blanks for the end. Say the field is numeric "priority" and the blanks are ones for which it's a low priority for me to even assign a priority... or the field holds contacts and I want portals to show records with contacts before records without... I can make a work around by either entering ZZZZZ as a default value (very crude, breaks commonsense principles), or by creating a further field which shows 1 if there's a value at all, and then I can do a complex sort order. But that's a drag…

Hi everybody ! I have troubles with repeating fields. 1. How is it possible to know how many repetitions of a repeating fiels are used ? 2. I would like to insert a value into the Xth repetition of a repeating field. How is that possible ? 3. I also want to know if a specific value is present in the repetitions of a repeating fields. How can I do that ? Thanks a lot !!!

This is what I would like - any ideas on how to achieve it? Three inputs 1. FirstName 2. SurName 3. Company So you fist you enter the firstname and surname and as you tab away from the surname a list in a portal of possible matches in the database already Similiar with the company. And ideas on this and any pitfals using this setup might incur?? Thanks

Hello ev

Is it possible to define separate calculation formulas for a repeating calculation field? e.g. a+b for rep. 1; a-b for rep 2; a*b for rep. 3 etc. (I do not envisage using any scripts like SetField.) csb ps. If this is not possible what is the usefulness of a repeating calculation field?

Hi all, am i correct in thinking i will run into problems if i have a field whose name is "date"? I seem to remember seeing this somewhere, but i can't find a reference here. TIA, Jerry

I am working on something for the woman who takes care of time cards for the Dept. Staff will need to turn in a Time sheet (monthly tally) at the end of the month (new to them). I decided to digitize thier time cards(Time sheet), and I was hoping that I could have certain information transfer from each card, as they filled it out or printed it, to the same are of the time sheet. Then at the end of the month be able to calculate the info on the time steet, and turn it in... I need help in getting the info from the card to the boxes on the sheet. I am very new to this, and plain english would be great:) Thanks very much!!! Phil

Hi, i've had a quick nose around for examples, cant find anything so far so ...: I am new to FM, and I need to validate certain fields to prevent duplicate data and, in this instance, I have a Day table and a Session table, and I need to make sure that no sessions are referenced in more than one day. I also need to validate sessions in terms of tutors who run the sessions, to make sure no tutor is booked for more than one session at a time. Any help much appreciated!! Thanks Adam.

Oh this looks so simple ... I have a field which contains a complete sentence but the very first word is a code ABCDDD (could be text or numbers) then a space then the sentence starts. I want the sentence only. I tried LeftWords(field, 1) + 1. I tried RightWords(field) - LeftWords(field, 1) Good grief. Why is this so difficult for me. I searched LeftWords and got a bunch of examples but none exactly like what I need. I want a calculation that gives just the sentence portion. My mind swims with Position, Pattern Count, MiddleWords, etc and I end up totally blank. I don't like text functions. I decided instead of wasting another five hours just to (aga…

I am searching a concatenated calculation and get an error "This operation could not be completed because you have reached text block limits." I searched for an 'a' in the search field which has 13,000 records. It finds on a calculated result *(global field)*. It was a test - I doubt anyone will search for that because the results would be too large, but 1) What does it mean and 2) Any way to stop that error and instead display something more friendly like 'please filter your search further?' They enter into a global, so possibly I could check via my script that it contains more than one character like Length(field) > 3? How will I know where that ceiling is so …

Is there any way to force a relookup when the value of the looked up field changes? I can't see any way to trigger a relookup from a validation script... If that's not possible maybe I get some advice on how to handle this situation. I have an Invoicing/Inventory system. There's 3 tables in question: Invoices, InvoiceLineItems, and Inventory. InvoiceLineItems are related to the Inventory based on product code and status (order, back order, hold). The status is part of the Invoce, but since I'm relating InvoiceLineItems I need to make it a regualr stored field in LineItems and lookup the value based on InvoiceID. When the status of the Invoice changes I was …

Is there anyway to have a mouse over field - that maybe opens up a text field so all is seen rather than clicking.... Or does anyone know of something similiar?

Sorry if this is a newbie question. As the subject says, I want to be able to reference field values in other records of the same file for a fields calculation. Can someone tell me the notation for this? Also how would I reference a certain record that matches a criteria (based on another field in the record). Thanks.

Hello I have a field called "registered" and I have a field called "graphicalregistered" I would like to know if I have a calculation that determines the number in "Registered" _ is there a way for Filemaker to add that number of "x"s into that field. for example "registered = 15" graphicalregistered = "xxxxxxxxxxxxxxx" or "registered = 28" graphicalregistered = "xxxxxxxxxxxxxxxxxxxxxxxxxxxx" Is there some kind of formula to do this kind of thing? Thanks

I'm having a lot of trouble with calculations involving global containers. For example: If I set up 2 global container fields and paste small graphics into the first. the script: set field ("field2"-2,"GetRepitition(field1; 1)") just returns blank despite the fact field 1 contains a number of graphics in successive repetitions. It all works fine for "field2"-1. But i cant set anything beyond the first repetition of field 2. I dont understand it.

I have a made a text field with a scroll bar in layout mode. When I click on browse and try to type in the text box the text starts in the center of the box instead of the top left. I have checked text formatting. I can get it to start in the top left if I make the scrolling box smaller. But I want it a certain size. What am I doing wrong? Thank you.

If I have a field called "items" that contains for example: Plant Tree Grass Weed I want to have different calc fields, one each for each line of text in "items" that will extract that line. field "calc1" = "Plant" field "calc2" = "Tree" field "calc3" = "Grass" field "calc4" = "Weed" and field "calc5" = "" because there is no line 5 of text in "items." Is something like this even possible? LR

2 cells max / min if only 1 of the 2 is filled in the other should be equal to that: for example 0.25% / ___ should go to 0.25% / 0.25% (and vice versa) but 0.5% / 0.25% should be able to be entered to? How is this done??? Thanks Simon

how can i play a macromedia flash file in my layout that animate when layout visited

Hello Everyone... I have a simple case function that as you can see makes certain fields change depending on the referenced field. Case ( Policy_Active_Inactive = "InActive";"Holding"; Policy_Active_Inactive = "Active";"InHouse Review"; Policy_Active_Inactive = "Closed";"Closed") What I need to do is make a cell on another tbale change... On the first line you can see when Policy_Active_Inactive turns to Inactive the Status Field (thats the field that its on) changes to Holding... What I need is to change the status field on the main table to Holding...How? Can someone help me Please? Thank you...

I'm trying to make the linking of files into container fields as user-friendly as possible, so I'm making an "Add Attachment" button and script. The problem is that I can't seem to get the Insert Object script step to prompt the user to enter the filename. It wants the filename entered into the script in advance. Does anyone know a way to get the script to open up the Insert Object dialog box for the user?

Hi there, i just want to know how can i check the path of a file/picture inside a container field. Just like if i store a picture inside a container field and i just store as reference, now i need to know the file path so that i can open it using send message function. Regards, Henry

Is there a plug-in or a way to make a script so the pictures are automatically inserted as a reference to the file? Thanks in advance! FileMaker Version: 6

I'm trying to validate a date entered into a date field is the last day of the month. In the validate by calculation box I typed: Month (Period Date A + 1) [not equal symbol] Month ( Period Date A) Period Date A is the field I am validating. Would'nt the above statement only be true for any date that is the last day of the month. Does anyone know why this is not working. I could not type the "not equal sysmbol" so I wrote it out above.

Hi I have a calculation for a Cost field I need to do... I need to make sure only the relevant fields are used from other tables, so i need something like this: sum ( Equipment::RatePerDay ) where EquipmentRental::EquipmentID = Equipment::EquipmentID .... the problem is in the WHERE ... whats the keyword in FM for this??? Thanks

I need to have a set of universal, Supervisor-defined values for my database. I want a person with appropriate access to be able to go to a special layout and edit these values. How do I store them? Globals don't seem to be the answer ... but maybe I just don't understand their particulars: How do I store a universal user-defined value? I want one user to edit the value, and that value to be stored ... anyone else accessing the database would now see the new value in any record. My understanding of Globals are that they are a session-and-user specific field in a multi-user context, ie. that they disappear when that user closes the session.

I'm trying to create a new contacts database where there would be 1 record per account in the "accounts" table, then additional records in other tables such as Addresses, Phones, and Contacts. I want to setup an auto-enter calculation that, starting with 001, will number the addresses as they are created from a portal on accounts. I've tried it several ways but can't seem to find a way where it will get both the first entry AND subsequent entries. Do I need to script the creation of addresses or should there be a way to do it with the auto-enter calculation?

Hi I have a currency field which can either display euros, dollars or pounds sterling. So that I could show all these and still use a number field I added a drop down in front of it which lets the user select

We have a container, with a 1 pixel graphic file in it, enlarging unproportionatly to fill the box, basically to create blocks of color in our layouts. Using this so that we can create custom color schemes on layouts very simplay. We just have records in a color file with different color 1 pixel graphics inserted into the container fields. Anyways, works like a champ in OSX, but when we go to Windows the container doesn't show a solid block of color, it shows a gradient. With a 1 pixel source image it shows a perfect gradient. With a 2x2 (4 pixel) graphic it seems to show a box in the upper left hand corner (haven't measured it yet, but probably atleast 16X16) that is sol…

Where do you make a calc field "unstored" TIA

how can i have a log file include what any users do?

we have a filemaker database running on windows 2000 pro with filemaker 6 unlimited. we have 10 mac clients and, since last weekend, 3 windows clients (both running filemaker 5.5). on the server we host a database which has a container field which stores referenced images. these referenced images are stored in a folder on a windows 2000 server, to which both the macs and pc's have access; the macs mount this folder as 'FOTOS', the pc's mount it as drive letter 'T'. i've set the volume label of the 'T' drive to 'FOTO'. however, when i add images on the mac client the container field shows 'cannot display image 'imagename.jpg' on the windows clients. mac clients …

Hi. I'm a newbie. I need your help, folks! I created a database with pictures and descriptions. I want to click on each pic and see the details of it (different picture file) in separate window. It's like assigning different "Open URL" script to each pic, but I don't know how to do this. Please could anyone tell me how! FileMaker Version: 6 Platform: Mac OS X Panther

I am creating a db for a boarding/kennel facility which involves 3 files. The three files are related and share the relationship field of

I am using FM Pro7 and have created a calculation field which dynamicaly changes colour depending on two other fields. This works fine as long as the you set the Field to: Format > Number to Leave data formated as entered? I would like the displayed Number to have 2 fixed decimal digits and a thousand separator ",". Here is a copy of the Calculation field script called FieldC: Case ( FieldA < FieldB ; TextStyleAdd ( TextColor ( FieldB ; RGB ( 255 ; 153 ; 102 ) ) ; Bold ); TextStyleAdd ( TextColor ( FieldB ; RGB ( 51 ; 51 ; 51 ) ) ; Plain )) Also attached is a test file. Any ideas? colour_test.fp7.zip

Hi i want to extract a number before a "_" eg 1_, 2_, 22_ using the left function only gives me the first number not the double digit. where do I go from here thanks?

Im wondering what the trick to making get(layoutnumber) work? it doesnt seem to matter what order they are in, the number stays the same.

well, this qns might seem a bit redundant but i'm just curious and this is the fastest way i can get my answer without all the hassle of reading up and testing out. lets say if 2 users log on at the same time, do they share the same global fields? e.g, if the system assign a value to a global variable for user A and another value to the same field to user B at a later time, will the value assigned to user A be overwritten with the value assigned to B?

Hello. How to replace carriage return in a text with space using calulation field? Thanks.

Hello Everyone... I need to ask you all how to do a equation. I have looked in the built in equations and can not find what I am looking for. I need: PV(Future Value, Interest Rate, Period) PV= Present Value Can anyone help me.. Joseph

Hello everyone... ok here it goes... For this example I have two tables..."Policies" and "Premiums" On the Policies table I have a Fields called "Escrow Amount" and "Escrow Factor" On the Premium table (Viewed and enterd through a portal on the Policies Table) I have row numbers which will be years (1,2,3,4...etc.) and Amounts for each of the years.. What I need is help comming up with an equation that can calculate Escrow Amount: Take the escrow factor (1.25) and multiply it by a Number (will be a field) Lets say the value is 6 so the answer will be 7.5 Now I need an equation that can look up on the premium list that I have entered...Look …

I am trying to get FM to give me the following "dayOfWeek,Month, Day, Year". This was easy in FM6 but they have removed the "Today" function. TIA

Help needed. Sorry if this is a truly newbe problem, but I desparately stuck ... I defined a db for a shop that offers clothing material to schools, defining, school, term (2003-2004), name and articles needed for the school (shirts, trousers, ...) and these clothes have different sizes (S,M,L, XL, ...). My main fields are article (eg art1) and size (eg size art 1). This is done for 30 articles (... art 30 and size art 30). When I sort my articles to calculate/summarize totals per article and per size, I don't get my (sub)summary right. When sorting on art1, size art1, art 2, size art 2, ... using a layout with different subsequent subsummary's (subsummary…

Okay, I've been trying to figure this out for a few years, but I am finally breaking down and asking for help. I work in motion picture film editorial and one of my many duties is to add and subtract film footages. Not so hard doing so in your head, or w/ a Film Calculator, but kinda difficult to create a calculation to do it for you. The rules to adding and subtracting film are as follows: There are 16 frames in a foot of 35 mm motion picture film with the first frame being +00 and the sixteenth frame being +15 (yes, I know that's confusing you count the 00 as 1). Also, when adding footage, subtract 1 from the total, and when subtracting footage add 1 …

I am trying to create a DB to emulate a time card in order to check my paycheck. I need it to track Call, 1st meal in, 1st meal out, 2nd meal in, 2nd meal out and wrap. I can calculate a total hours worked, but I need to break down this total to calculate regular time, 1.5x, 2x and 2.5x. For instance, if I worked 13 hours, the first 8 would be at regular time, the next four would be at 1.5x and the last hour would be at 2x. Any suggestions on how to bread down this total? Thanks!! Bronwyn

I use a fairly simple database the contains donor and donation information. The donation fields are set up as repeating fields: Date, Amount, Check#, Amount and Event. The problem is that I have been requested to set up a report showing all of the people who donated for a particular event. The search in the event field brings up all of the people who donated but I cant get just the specific event info to show up in a report, just the first item in the repeating fields shows up. I forsee requests for more reports, such as everyone who donated in April 2004, etc. Was using repeating fields a huge mistake? Is there a solution? Help! I've been using FMP for years b…

Hello Everyone... Does anyone know how to fix a field from repeating on a report... Details: I have a fields called "Ins_FullName"...It looks like this <<Ins_FullName>> on all of my reports...but on some NOT ALL it doubles the name? Why? I also have currect date "//" on some reports..it also doubles the date why?

Hello People! I am sure this is relatively easy to some of you but I sure could use some help I have two joined fields to indentify a unique record...in my (lineitem-type) file: c_LocItem= ItemID & LocationID How would go about validation (no scripts) so that the next time user enters location ID it would validate: eg. ItemID_______LocationID ABC_________100 ABC_________101 attemmpts to enter the same location ABC_________100 Many thanx!!!

Can anyone throw some light on this? I have the following field, 'Years Since' defined. It's stored and has 'Do not calculate if all fields are empty.' flagged. The YearN Ren fields hold 'R' or are empty. If(Year0 Ren = "R",0, If(Year1 Ren = "R", 1, If(Year2 Ren = "R", 2, If(Year3 Ren = "R", 3, If(Year4 Ren = "R", 4, 100))))) - 1 It just does not work. 'Years Since' is always empty no matter what the values in YearN Ren. If I change it to a Case statement, all the values appear. If I leave it as a nested If but unflag the 'Do not calculate ... empty', all the values appear. So I've solved my application problem, but WHY? The plot…

I need some advice on the best way to lay out the fields and tables for a unusual database I'm designing. I've decided to make a database for my cousins and a game they play called "Heroclix". I looked around and couldn't see any ready-made FM file for it, so I decided to use that to learn a few things about FM. This database would contain the figure's stats and would have at least one table for the figure data itself, plus another for teams and another for power definitions. All these are values taken from the figure itself and not necessarily calculated. You can see here a sample figure entry from the HCRealms figure database. As you can see a single…

I have been trying to create a calculation date fields that excludes weekends and this may sound crazy but the calculation keeps ignoring me. No really I tried a simple case statement using DayofWeek function (Trade Date 5 = DayOfWeek (1); Trade Date Day (6): and it just added the days up as if there were no rule giving me a "settlement day of exactly 5 days from the trade date. Any help would be appriciated - dates always seem to throw me for a loop so to speak.

Is it possible to enter a calculated value based on a relationship? Number field -> Calculated value... If( Min(SelfJoin::Quote#)=Quote# and not IsEmpty(Job#) , 1 , 0) If I define it in a calculation field it returns correctly. If I define it as a number field with the calculated value it will not return 1 when a unique Job# is entered. Thanks.

Is it possible to do something like this in a calculation, If( field1="something", callScript1, callScript2) Thanks

Is it possible to validate the value of two records in a multi-record file? I use the field for a valuelist in other files. The selections in the other files trigger calculations results. The calculations have two of the record values defined predefined in their calculations. I have tried the ValueListItems( ) functions but it seems to calculate after the validation calculations. Thanks.

I am trying to set up an auto-enter date field in a file ACTIONS that gets its initial value from a calculation based on a date in a related file EVENTS and adds the number of days specified in the related file PROCESSES. This field should not update when related fields change. Defining the field as Date and setting Auto-Enter calculated value to EVENTS::date + PROZESSES::nextAction (this is a number field) just does not come up with a proper date The same formula works great when the field is set up as a calculation field. But I do not want this as it should not update. There must be something very basic that I am doing wrong. Please, any help…

Hi I have a calculation that used a related field. I want to Index this field but FM wont let me. Any work around you can think of? thanks

Hi I have two types of timers for client sessions - one with an automatic calc of the lengtth of the session and another where you just type in the day and the time taken. Both have two fields which show firstly the total time for just this client and another which shows all the time for all clients. This is shown in the client (related) file. I have two report layouts - one for each timer (and will do a combination one soon), as not all people want to use the same type of timer. On the one that works (the auto calc one), I have clients with their individual totals in the body part, and then a trailing grand summary with the summary field which calculates the total…

Hi to everyone out there! On looking through some of the templates supplied with filemaker 7 so as to get some ideas about fields and relationships, I have noticed several instances of fields starting with Hilite or Similars, please can someone explain what these mean as I can find no help in the help index at all. Thank you very much Shelley

I am writting a database where each record has a bunch of dates. These dates will change over time (about 10 times) but I would like a history of what the previous dates were. Is there a way to do this with repeating fields? Perhaps a better question would be is if anyone knows where I can find a tutorial on repeating fields as the electronic manual doesn't seem to be much help. Thanks.

I have dragged some added fields up into their proper place. I want my file to keep this order, but when I import (and the new import records have these fields in the correct place), the fields again appear at the bottom. I tried saving a clone once I had my fields in the right order, but that doesn't work either. I even tried exporting one record - thinking it would keep the correct order (as FM file) but it doesn't - it keeps putting them at the end. There must be something simple I'm missing. Any ideas how to get this new field order to stick? Thanks for helping ... Pete

Hi, I have stored all the pictures as references to the files, and now they are going to change the server. Once they move the files to the new server, I guess the links will be lost ... is there any way to avoid this, or a quick fix? Thanks a lot in advance!

Is there a way to have a summary field that bases its value off of *all* records in a table, not just the found set of records? Or some other way to accomplish this task, as part of a field definition? Specifically, I'm wanting to create a "count of" that counts all the records for which a certain other field has a particular value (well, any value really), but have it based on all the records in the whole table, not just the found set. Because I will be viewing it through a portal inside a related table, the found set only consists of the related records, but I want it to calculate it based on all records. It used to work back in FMP 4 or 5, however it no longe…

Hi There How do I create transparent graphics? Why would I want to anyway? Are they safe for cross-platform use? What is a mask? I came across Obegi's Aqua Graphite database which had a mask element in it. When playing with the image size the word "mask" never pixelates. I am really curious if I am missing out on a whole new design possibility. Would I be able to create fading transparent images? (ie: from 0% to 100% transparency within the same image) Thanks - Pete

i have an invoicing scenario with line items. data into the line items is pulled from a supplies file via popup menus. the popup shows an ID and the literal, something like '123 Hourly charge'. so i enter 123 into the ID field, and the record looks up 'hourly charge' and enters the price, say 20. now all i need to enter is the quantity. so far so good. in the supplies file i have specified a discount rate. when i enter a number greater than say 10, i would like the price field to fill with 18 instead of 20. right now i can only do this via a live unstored calc, because the lookup happens before i enter a quantity. obviously, i'd want a lookup instead of a calc so that o…

Hi please excuse a beginner question, but I'm trying to devise a way to track multiple dates that relate to specific payments: when the request for payment 1 was received, when it was approved by Dept A, when it was approved by Dept B, when it was submitted to Accounting and when it was paid. I need to track these dates for up to 24 payments. Our database has separate records for each grant on which these payments are made. Is there a simple way to avoid having to create 5 date fields for each of the 24 payments? I suspect this is a job for relational databases, but I haven't ventured into that world yet. thanks for any help, Chuck

I'm trying to set up a field that will "find" a week ending date (Fridays) that will display. I already have a function showing the CURRENT DATE - with day of the week and date displayed - if the date is required in a calcuation field. Any help, hints, tips would be appreciated. JESSE

Hello Everyone... I have a simple question I hope... Setup: 10 Tables...only need an example for one I can do the rest.. Tables: Main and Policies I would like to make a script that will only print desired records... I have a field called Status...Is there a way to make a script that can ask me or give my choices by either pull down menu or buttons which status I want to print (Active or Inactive) I only wish just to print one...and have the others not show up... Help? Joseph

Hello everyone.. When I try to formate a Number field as a Percentage the number comes out huge? Example: Field 1: Formated as a percentage when I go to type a number like 20 in it comes out 2000% why? I just need 20% Joseph

Question is for a database (v5.5) that is used for insurance calculations. There is one field that is "X" which I enter manually, that ranges from 100-300 in intervals of 10. Another field is the "Y" which I enter manually that is multiplied with the above "X" for a total. (X * Y = total) 210 * 15 = 3150 Now it only gives a result for one calculation as above, what I would like is to be able to put in the "Y" and have it calculate and display all the totals ranging in the 10 increments from 100-300 instead of just one. Thank you in advance.

Hello, I have a series of calculations within a record that will most often result in a number, so I have defined the calc fields to be a number result. But occasionally the result will be a single letter (text). I need to do arithmetical calculations (such as a sum the fields) on the result where it is a number, which would need to ignore any of the results that were a letter. And I would need to do a count of the number of occurences where the result was a letter. Would some kind soul be able to give me a little guidance on how I should deal with this? Thanks very much. (In case it may be suggested, defining any more fields such as 'if/then' …

How do I make and insert a drop down menu? Basically I want to have categories that you can choose from (ie: vendor, client, employee, etc etc) God I love that banana...wait...that didn't come out right

I am trying to create a sales order file where every record is a new item. All items under the same sales order number will have the same shipping and billing information. My problem is that I don't want people to have to re-enter this same information for all the items on a particular sales order number. I have tried lookups, but if the information isn'e entered on the first record it is kind-of pointless.

Hi. I could use some help with setting up a calculated field. My question is: how can I define a calculated field to remove all punctuation? In case it helps to know the context I am using it in: This field is converting a person's email address into a username. The username is defined as everything that comes before the @ sign in the email, must be all lowercase and must have no punctuation. So for example, "[email protected]" would have the user name of "fred22". I've got the first two parts covered, but I can't figure out how to remove the punctuation! So here's what I have so far, which is working okay: (Lower(LeftWords(Email, 1) Thanks so much!…

I have a company master file with 100 companies. Every company has 3 copies of the 200 CDs we produce as their stock. I also have a sales file with sales details file attached via a portal. I want to show the companies stock with the sales subtracted but am unable to think of how to show their consignment stock. Showing each company_cd number to show the results would equal over 60,000 records? how can i slim this down?

Hello everyone.. Can someone help me do this calc. I am not so good at these kind of things... The example: Gross Proceed to Provider / Purchase Price = Percentage If that percentage is < 12 Percent then the number calc is Net proceeds to Provider If the Percentage is > 12 percent then divide by 2 and then multiply by Purchase price = Bonus to funder Help.. Please

Hi, Need help with an inconsistent calculation in Filemaker 5.5. I need to calculate age based upon the year difference between two dates. The calculation created before my time was Case(not IsEmpty(Date of Death) and not IsEmpty(Date of Birth), (Round((Date of Death - Date of Birth)/365.25,1)), "") This sometimes works, sometimes doesn't. Can someone please help me out with a nice, neat reproducable calculation? Thanks

I have a Work Orders file that contains an order_no field and rev_no field. I want to find the number of numbers in the order_no field. For example, I could have: order_no 1234 rev_no 01 order_no 1234 rev_no 02 order_no 1234 rev_no 03 order_no 5678 rev_no 01 order_no 4321 rev_no 01 order_no 4321 rev_no 02 and I would want the result to be 3. So what I want to know is the number of groups of the same number. Sorry if this is confusing but I didn't know quite how to ask the question.

Hello everyone.. I am haveing trouble figuing out how to make a value list (Its for a drop down list) draw its contents from two seperate sources... I have insureds in one table and Sellers in another table... I would like to make a pull down list or drop down list that has both of these in them... Is there anyway? Joseph

In transactions.fp5, I have two unstored calculated number fields (their actual calculation doesn't matter here): A) "posted_debit" : "posted_credit" I also have two Summary fields: C) "running_total_posted_debit" = Total of posted_debit (running) D) "running_total_posted_credit" = Total of posted_credit (running) And one more calc number field: E) "running_balance" Unstored, = running_total_posted_debit - running_total_posted_credit When I view a list of records in transactions.fp5, the field "running_balance" displays a running total of debits - credits, just like expected. However, when I display the same list through a portal (set to show 25 …

I have a calculation that works, but I'm thinking there's probably a more elegant solution: If( myNumber - 1 > 0, myNumber - 1, 0 ) I.e., I want to subtract one, but not go into negative numbers. Is there a clever-er calc for this?

Hello I have a file with a field "rangebegin" and a field "rangeend" I want to have a field called "usednumbers" and a field called "NUMBER" I am in filemaker 7; I would like to have a script that would pick a new number from within the range of "rangebegin & rangeend" make sure that each time it picks a new number. Can someone help me with this one. Thanks very very much Stann

A friend has a file that uses 50+ rows of just one field consisting of 5 radio buttons as shown below. Using fields F0-F4, I am tring to calculate the total number of entries for each radio button underneath the rows. I played around with this for some time using the Count function and various attributes, however, I either got a total of the number of rows or a zero. I could not discriminate between those buttons selected and those left blank. Any help would be greatly appreciated. Database: O0 - O1 - O2 - O3, O4 (O's represent buttons - 50 + rows of these same fields with unique names) ======================= Calculations: F0 - F1 - F2 - F3 - F4 …

Okay I have added a couple of fields - Last Accessed Date and Time which is updating and working fine. However how can I distinguish between last accessed and last modified? As as soon as I add the last accessed date and time the file has been modified? Any ideas? Thanks Simon

When my field, PRICE_1 appears in the text of one of my letters, the currency formatting is not picked up in all records. I have several records where the dollar sign and .00 are not appearing. Most records (text in the letters) are fine. Thanks always for your help. Maxwell Morlay

You can output the "date last modified" of a whole record, but is it possible to output the "date last modified" of just one field.

Hello I have a photo ID database that we use to locate our customer Identification cards. In some cases when a dealer shows up there are as many as 10 different buyers all with the same Buyer ID number. I would like to find a way to display all the photoID pictures when we look up their buyer number and then be able to click on the picture that matches the person and have filemaker correctly enter threir name fromn a lookup. So to summarize a buyer arrives. They give us their "buyerIDnumber" we enter that number and filemaker would look up a person whose picture is in the table " photoID" but I need the others with the same buyerIDnumber - pictures to be dis…

I have a system of Filemaker Pro files of Quotes, Sales Orders and Invoices. These files have been in use since Filemaker 2. Once a quote is created the separate items of the quote are entered into repeating fields. When customer a purchased quote 1021. The quote has several fields (Item #, Unit Cost, Unit Retail, Item, Ext Cost, etc) that are all 18 itereations of a repeating field. When I go from Quote to the Sales order file I enter the quote number and all of the items come from the quote to the sales order. Problem: However when I tried to repeat this with a new product file for the quotations file, only the first field is filled in. I cannot go to relationa…

There must be a very simple way of doing this i.e. 1 should be 01, 2 should be 02, etc? These two sequential digits are the last part of a product code created using global fields. The whole code is dependent on the criteria of the product and so cannot be just one long stream of sequential codes. Any help on this would be greatly appreciated.

Is there a way to enter a tab character in a calulation field? I am using a calculation field to create a line item summary of a bunch of other fields. I would like to be able to use tabs to separate the fields. I swear I have seen other solutions do this, but I can't figure out how. Thanks, Kevin

Here is a strange question, I have a field staff each with 20 pieces of equipment. They only need so many to use for each customer each month. For instance this is Customer / #of pieces of equipment needed for that customer A/ 0 B/ 3 C/ 3 D/ 4 E/ 5 F/ 5 G/ 6 H/ 6 I/ 6 J/ 7 K/ 16 In this example he could take care of almost 90% of his customers with only 7 pieces of equipment, and if need be he could borrow the other 9 from someone else for that last customer. …

Hello I would like to know if there is a way to bypass that dialog that nothing is found in a find and initiate another script upon a "no find" Is that in anyway possible? I would like to actually close a window if the find is not productive. Just wondering here. Thanks

Hi, I work a little with Filemaker Pro but not enough to really know what I'm doing. I am trying to add to my Kid's Church DB the ability to record Memory Verses for VBS and the Reward Points associated with it. The Main DB Records are of children, and if we put this in another Table it might have: Child ID Number (related field), Name, Grade -- then VS Code & Points. For the verses, each verse has a Code Number(related field to Verse DB) and a points designation. I would like to do an input of the code number and look up the Points. These are in another DB. I would like to be able to enter 20 Verse codes & Points for each of 5 days - Monday t…

Hello everyone... Heres the situation: Two Fields One in same table Field One: "Dept" Field Two: "Status" All I want is an if statement that goes in the "Dept" field that says...if "Status" is Inactive then I want the "Dept" field change to "Holding" if "Active" then change to "Inhouse Review" Can anyone help me?