Calculation Engine (Define Fields)

I have 2 databases The first is a client base (Names, addresses etc) The second is postal code base (Town, State, Postal Code) I have set a relationship between DB1 and DB2 so that the town field in DB1 allows me to select a town and the State and Postal code automatically updates from DB2 into DB 1. The problem is that when there is several towns with the same name (but in different states) it simply gives the first name on the list. I have used a value list for the town field in DB1 to show me the town names in DB2 and I modified this so that it also shows me the State when I drop down the list to search for a town in DB1. However, in the drop down list …

Hi, I have created a calculation repeating field which calculates the content of two repeating fields data entries .eg. Repeating field User Field Bingo ------- Password Field 1234 User Field Banjo ------- Password Field 5555 User Field JohnJo ------- Password Field 4444 ------- RepeatingBothCalculationField = "User: " & User Field & " " & "Password: " & Password Field returns User: Bingo Password: 1234 User: Banjo Password: 5555 User: JohnJo Password: 4444 ------- Then I want to then create a field that compiles the text for the ACCOUNT. eg. Calculation Field = "Hi," &…

Hi all: I've got to create a quote numbering system based on an old (unmodifiable) paper system. I understand the logic, but the syntax of the calculation is eluding me. The format of the quote number is as follows: "Q-4-1-701" Where: "Q" is constantly the letter "Q" "4" is the last digit of the year (i.e. 2004) "1" is the month (i.e., January) "701" is a sequential number for that year (i.e., the 701st quote of 2004) The customer wants to have the sequential number strictly sequential, meaning no skips. He's got several different numbering schemes like this, but this is the worst, as it is dealing with Date information, and I'm just wandering…

I have a file with a field called Active Status that tests the status of the person represented in each record. This field is defined as: Case(Status of Participant = "Deceased", "Deceased", (Status(CurrentDate)-(Attendance Records::Date of Event) <183), "Active (6 Mo.)", Status(CurrentDate)-(Attendance Records::Date of Event) <365, "Active (12 Mo.)", Status(CurrentDate)-(Attendance Records::Date of Event) <548, "Active (18 Mo.)", Status(CurrentDate)-(Attendance Records::Date of Event) <730, "Active (24 Mo.)", "Inactive") The result will not show. It is not hidden behind anything, and it is defined as a standard field. So I created a new fie…

I have inherited a database and need to be able to calculate a student's current age. I wanted to just do a simple calc: (Today-DOB)/365. However, there is no DOB field. Instead, there is MonthofBirth, DayofBirth, and YearofBirth, all three of them text fields. I tried to write a calc: MonthofBirth &"/"& DayofBirth &"/"& YearofBirth, but it doesn't work. What is the best way to get Current Age out of this? Thanks, Susan

I would appreciate help with this problem. We had one data entry person who put spaces between the city and state like Sacramento, (8 spaces) CA. Major bummer. It looks terrible. She was trying to line the state up with the words STATE right above it. She has been stopped but I want to correct the mistakes. How can I remove all those extra spaces and just leave one between the comma after the city and the state? I also tried changing field validation so it only allows 1 space by using PatternCount but I can't get that to work based upon where the comma is. I can't even get out of the box at all. Something about parenthsees wrong. oh. And our new program will ha…

Hi All, I have a fairly trivial aged debtors database whereby I work out how old a clients debt (0-30, 31-60, 61-90 & 90 or older) is. I have everything working as it should except(I feel so close yet so far): The method that I have adopted to work out how old the debt is in each client record is to use a calculation field called debt_age that uses a current_date field with the calculation Status(CurrentDate). I should mention at this point that the debt_age calculation works fine. The problem I have is the current_date field presents the date fine on the record initially, but if I change the date on my system (testing the effects of a new day), the d…

I have a solution that is sending out email with attachments and I am using the following to determine the path to the bd. Substitute(Substitute(Substitute(Substitute(Middle(Status(CurrentFilePath), 8, 64000), Status(CurrentFileName), "pdf/"),"/Programs",""), "/", Case(Abs(Status(CurrentPlatform))=1, ":", ""))&""&Substitute(RightWords(P2:_DisplayName, 1)," ","")&Left(P2::_DisplayName,1)&invoivenumber&"_"&send_type&".pdf", ",","") But when I use the solution in a network are the path not recognized. In Mac os X are the path *,filename.pdf. and not the full path to the file on the network. On a PC did we solve the problem by making a sh…

Hello, I am creating a one-field database which will be a list of authors that will be related to a main database. The records in the one-field database will be where new authors are added, edited or deleted and then these records will be the value list in the main database. But I am having a devil of a time with a problem I just don't understand, even before I go relational. Whenever I choose in a pop up list an author to delete I end up deleting a different author! Attached is a very simplified database with 7 records in it. The records are: A1 B2 C5 D3 E7 G6 Z4 I created them in the order of the numbers, but they appear alphabetical…

Is there any way (short of moving to a new layout) to have fields become active (they are grey beforehand), once a field is chosen or a condition met ?

I am working on a database to manage a cross-country ski race. I need to calculate team scores in several ways. I have the Racer ID field, the team field, and the time field. I need a calculation field for each team that will calculate the team's average time. I also need a calculation field for each team that will calculate its score - the sum of the rankings of the team's four racers with the lowest times.

This might be a dumb question, but I thought I would ask it anyway. Is there a way to increase the size of fonts in the DEFINE FIELDS dialog box? Does anybody know how to zoom this screen to a more readable size? Thanks. Jarvis

Hi all, I have had a look through the posts and cannot seem to find a solution to this problem: I am using two date fields within an accounting database. The first field is an autofill defined field, which enters the creation date when a new record is created. The second field is a calculation field that simply generates the date today. I have another field called "days_old" which uses a Case() calculation to work out how many days it has been since the creation date (or my invoice date). This all works fine. The problem I have is I would like to define an additional field that displays a result if the value of field "days_old" is greater or equal to 31 but…

ok. I'm tired of messin with this stuff. I don't understand when I can inside calculatons, replace a 'field surrounded by a different function' for a field requirement. please help me understand how it works. Ive been trying to understand this one for three days. It's the last thing I need to do to split some data and I just don't understand it. It seems so simple. I have a field (FIELD) text which looks like: LSSHMAILING11212002 I need to remove the first four letters from the left and just leave the rest of the field okay. The first four letters will all be different. I thought ok start from position 5 from the left and take everything to the right o…

Hi, Regarding images on the web and in the database itself,I prefer to use direct references to an images rather than import image i.e.(/images/abc123.jpg) rather than import images into FMp then us the cdml tag ([fmp-image:picture] for eg) I cant find a way to display this image in fmp just using a reference to an image held in a field. Is this possible or do I have to hold both a link and import the image as well?.

I am working on a database that tracks documents. The document will go through up to five offices. For a certain layout I have three repeating fields: Sent From, Sent To and Date Sent. These fields have 5 repetitions. I want to have a field that contains the last value entered for the Sent to field, Which tells where the document is currently located. I have five new calculated fields (Rep1-5), each one captures the value of each repeating Sent To field. Then I made a last calculated field, with the following calculation: If( TRep5 <> "", "This form is currently located at " & TRep5 & ".", If( TRep4 <> "", "This form is currently located a…

I want to allow/prohibit entry into a field based on data in a related Permissions database. For instance, if the Permissions field says "Allow" I want the user to be able to modify the field. If the Permissions field says "Read-Only" I don't want the user to be able to modify the field. (If possible, is there a way to hide what's in the field if the Permissions field says "Deny"?)

What am I doing wrong? I can't make lookups work. I have a field called JournalName that is a calculation based on related fields. I need to use it in a relationship, and so need it to be indexable. Seems like a good place for a lookup. So I create a text field called JournalNameLookup, set to lookup JournalName based on the 'Self' relationship, which is a self join where the record's unique ID number is related to itself. Correct me if I'm wrong, but shouldn't JournalNameLookup then be a text field with the value of JournalName once I perform the lookup? When I put the cursor on JournalName and select Relookup Contents, I get an error message that 'The…

I created a calculation field to track annual vacation and sick leave (previous yr balance + earned leave - used leave = new balance) and it is working just fine. However, for vacation time, we are only allowed to carryover a maximum of 48 days. What do I add to the calc to get a result no > 48?

Hi there, now i have created a simple cashbook for testing. It only have 5 field, date, description, debit, credit and balance. The balance is based on previous balance plus debit - credit. I can do this with a script. Now just asking is that any way to do this by using calculation field. So it can calculate automatically without running a script. Regards, Henry

I'm working on a Database of all my CDs that I own and can't figure out how to put a small graphic of the cover of each CD on each record - what kind of field do I need or how can I get them in there? Thanks everyone! Mike

Averaging by number is a no-brainer. I've also figured out how to average letter grades. My dilemma is how to use the same fields for both solutions (some schools use letter grades, others use number grades)

Hi, I've been asked on a PM how this could be done. I had a few ideas but not the exact one, and reported the poster to add his querry to the boards instead. As he didn't, and I'm still curious about how FM can handle this, here it is : How to convert .5 to 1/2, .33 to 1/3 , 3.8 to 3 4/5 ..... The PM was in fact : "I need to use a table where I have to capture lots of data but I need to capture it and present it after calculation in inches, (ex, 1/2, 3 1/7, not .5 ) do you have any idea for handling this? Thanks a lot "

newbie here .. setting up a test file .. I have setup some calculation fields in a form .. in FM Pro browser mode these calculated fields change instantly when any fields referenced in calculation formulae are changed but .. in web publish mode in localhost .. calculation fields only update when "submit" is clicked. I would like the calculated fields to update before pressing "submit" (as they do in FM Pro browser mode) Is there some button (or other) function I can place in the record layout to instantly update these calculated fields when other fields are changed on web site .. e.g. like F9 in Excel for manual calculation? dtl

I'm working on a database with products file and order file - trying to make scriptmaker take me from one article line in products file to the next line in repeating field on order file. "Go to" commands takes you back to the first line or field - anyone know how to get to the next blank for automatic pasting? ???

I need to produce a result, based on the last occurance of the same result. I have a calulation that based on different criteria, dispalys different results. One of those results needs to display a different result based on what occured the last time that it occurred was. So if it was result "a" than the next time it occurs, it needs to be "b". To further explain the calculation looks something like this - If(fieldvalue = "X" and fieldvalueB = "X", "AA", If(fieldvalueA= "X" and fieldvalueC ="X", "B" etc.. The last condition needs to show "C" the first time, and "D" the next time it occurs. I think i need to have a related DB hold the result, and have it chec…

Can I create a calculation that will give me a running count of the number of records in a self-join relationship? For example, I have a db with 10 records, and a field called TxnNum. The first four records have a TxnNum of 1. The next 4 have a TxnNum of 2. The last 2 have a TxnNum of 3. I'd like to get a running count so that the records would be enumerated within the TxnNum = TxnNum relationship. The TxnNum, RunningCount pairs would be: 1 , 1 1 , 2 1 , 3 1 , 4 2 , 1 2 , 2 2 , 3 2 , 4 3 , 1 3 , 2 Can I do this? Thanks, Dan

Problem: Need a formula to find previous lowest odometer reading for a list of records of randomly entered odometer readings so I can calculate MPG. Example. Previous record readings were 41789,43582, 47135, 46902. New reading is 44234. I need the calculation to find 43582, the previous lowest reading. Each reading is a new record.

One more question... at least for today. Is there a way to set up a FM layout so that data entry folks can tab from the last data entry field directly to a "Create New Record" button and then hit enter and get a new record?

I would like to force data entry in a specific field - not any specific data (this is a field for contract numbers that do not follow any specific alpha/numeric pattern - i.e., could be 58-3TC139-F-I or 03-323454 or 03A76, etc.). However, I don't want to allow the field to be left blank. Also, the data entry folks are having trouble "seeing" which field is active for input (flashing cursor not highly visible), is there a way to have field highlight when the cursor is "there" or some other type of fix/help? Thanks in advance for helping this in-over-head-newbie. PS Would it be considered bad form to attach the file for review and critique?

Currently I have a script which walks through container fields and I check on error 100 to see if the file referenced in the container field still exists. Any ideas on how to do this with a calculation? If you check on IsEmpty or IsValid don't work, cause FM 6 puts a nice "Could not draw this file" picture in the container, so it isn't empty or valid.

The formula of my indexed calculation field contain a Status(CurrentDate) function. The field must be indexed and I don't want to use the Today() function. When a new record is created the field is calculated correctly. It is recalculated when any of the referenced field is modified (even if they don't influence the result). [it is also possible to recalculate it when ANY field gets modified, with a non-influent reference to a time field with modification time auto enter option on] Are there any other conditions that make the field recalculate? How do you deal with indexed calculations that depend on the current date ? Thanks, Paolo.

Hello, I am building a retail solution for our small store and I want to create a solution so that when the user makes an invoice she will be able to to lock the invoice when finished. I think it would logiically be when the customer pays for the invoice.. This will safen the system so that people cannot go back into the system and change the old invoices. Thank you for your help!

Hello, Is it possible to have a moving .gif on the FM layout? I have tried various wyas - direct paste, within container, etc, but all I get is a static picture.

I have a simple layout that calculates for example Total price by multiplying unit price*quantity. There is a related database that uses the unit price to calculate some other things. My question is that for example in countries with high inflation where prices change almost every month, every time I change a price it recalculates the older prices with the latest one!!. How could I have the oldest prices untouched and recalculate only according to the latest price. Thank you Pablomac

Hi Guys, Need your assistance again. I have two time fields, start_time and end_time. I have a container field called graphic, which contains a coloured block. Im trying to define a field that does the following. If (9:00 within the range start_time and end_time, display grapic, "") Is this possible? Any help would be much appreciated, all ym attempts have come to nothing so far. Kindest regards Jalz

Hello If I have repeated sentences in my field "sentence" Like Jeremy uses the 4 stage solution. Phil and Brenda decided to make use of the 7 stage procedure. David and Joe always use the 3 stage plan. I am trying to figure out how to text calculate removing everything before the digit "stage" in each sentence. ( each sentence will always have a digit and stage in it. ) and placing that text only in a field called "opening" In the above examples the text I am speaking about is in bold and I would like to have a formula to automate putting that bold text in a field called "opening" I need help with this one. and thanks to you. Much appreciat…

This problem is a bit tricky and I can't figure it out myself.... ... anybody....? I need to sum up the total amount of estemated persons in a certain period of days. This is the situation: - for every day of the week there is a calc field (MonNr, TueNr, WedNr, ThurNr, FriNr, SatNr, SunNr) that will show the amount of people for each day. - there's a global 'start' datefield and a global 'end' datefield (a 'DayNr' calcfield will show the amount of days from the start to the end date). What I need to know is: - the total amount of people -in one calcfield- when the 'DayNr' > 1 or even > 7 (the calculation needs to sum up more then 1 -for example- …

I am trying to make a renewal database. I need to put in a date that the original form was signed and then have it teh renewal field automatically calculate 4 years less 1 month from that date so if the date was 12/5/2003 the renewal date needs to be 12/4/2007 I can't seem to find a way to do this. I can do it separately by having the month and year in two different Renewal date fields as numbers but not as one field as a date. Then I am trying to write a calculation that says if renewal date is less then or equal to today's date then Renewal "Yes" else blank. I have tried it with the separate fields but I can't get seem to get the calculation right to give me the "…

Hello all, This is another newbie question, though an easy one. I am having trouble creating reports that summarize my data. I was wondering where i could go (books, online resources -free if possible) to learn ALL about how to create summary fields and reports appropriately. *My specific problems is: I have an attendance database and attendance is recorded in the field "AttendanceStatus". Three values are allowed as input to this field: Present; Absent; and Homestay. I would like to be able to display the total count of presence and absence for a given month for a given student, but every attempt i have made results in either the averages or the totals…

OK, so about 2 days ago I stated somewhere here in the forum that there was almost never a good reason to use repeating fields. Well, as luck would have it, I've gotten myself into a situation in which they might actually be a good idea. I have 2 questions that I can't find in the documentation. First, is it possible with a script step, or better yet a calculation function, to set a particular repetition of a field? Something like SetField [Field1, valueX, rep 1] SetField [Field1, valueY, rep 2] So repetition 1 would be X and repetition 2 would be Y. Second, is it possible to have a field on a layout so that only its used repetitions are displayed…

I have inherited a database for invoicing which I am trying to clean up a bit. At present there are a number of repeating fields and, by the sound of previous threads, maybe I need to change things. I haven't had any experience with any other invoicing systems so I have no idea whether this is the usual approach. In the existing solution, a record is created as an invoice for a customer, and when they pay, these payments go into the same record (I have a suspicion that it may be usual to have invoices and payments in separate records or even separate dbs). It is very common for payments to be made in 2 parts eg a cheque from an insurance company, with the resultin…

Hello, I have really been racking my brain on this one. Have used Filemaker for quite some time but my use of text functions have been limited. Anyway, I have some data I am importing into a field in my FM database from a shopping cart data base that looks like this: Field 1: CUSTOM,Priority Mail,6.95,0 Field 2: CUSTOM,Federal Express,11,0 Field 3: CUSTOM,First Class Mail,4.6,0 I am only interested in extracting the data between the commas to grab "Priority Mail", "Federal Express" and "First Class Mail" to place in one field in FM and the data between commas "6.95", "11" and "4.6" to place into another field in FM. I have tried different combina…

I'm having some trouble with a relookup (the lookup works fine when I make a new record). The lookup source field is a calculation field, and the lookup destination field is a text field. When I try to perform a relookup, I place the cursor in the field that I want to relookup (Field1), perform a relookup from the records menu, and then get the following alert in a dialog box: There are no fields that look up values based on the field "Field1". Any suggestions? Thanks.

Here is a question that has me stumped... I am generating a database that replicates a paper form. The form has several main text blocks on the first page, and continuation blocks on the following pages. I would like to allow the user to enter all the text into one field in an "entry" layout, and intelligently "split" the text into the main and continuation fields on the printable form. I've tried combinations of character-counting and linebreak counting, but can't figure it out. Is this even possible?

I don't think I really understand the "subsummary" function, so this may be an easy solution, and I just don't have the basic tools. If so, can someone refer me to a resource that explains subsummaries in better detail than the FileMaker User's guide.... I know I could do this by doing multiple searches with different criteria, but that seems archaic compared to what I am sure FileMaker can do. For every study in our office, we record Year (We record the exact date of submission, but I've converted it to a 4 digit number for the year) Type (behavioral or biomedical)(Text) Review Level (expedited, full board, or exempt)(Text) Participant (student or facu…

Have you noticed that "Allow vertical scrollbar" is ignored if entry into field is not allowed? Because you can't select the field and the scrollbar appears only when the field is selected. Off course this can be workarounded with field validation... Allowing entry into field and setting the validation calculation to 0. Merry Christmas and happy holydays to everybody!

Hi, I'm sure if this question belongs to this topic....but here it goes. My database is ultra slow after I changed it to a multi user database. I have a total of 20 fields in the database. 10 of those fields are the "original" fields and the other ten are a calculation version of the "original" fields. I do this to prevent people to be able to edit the data but can still be able to search. Would anyone know is the slowness from the calculation fields or from the multi user being selected. Thanks in advance.

I want to use a global field, repeating with a list of items I want to see with all records. If I type list on main file everything is great and works the way I want but if I change anything or add items from a remote computer it only shows up on the computer that I type it on. Then after disconnecting and reconnecting to "host" everything is gone. If there a way around this problem?

I want to define a field with an automatically generated serial number, each one greater than that for the previous record. This seems easy (Define Fields>enter field name (type is text)>click Options>choose Serial number and enter a starting value (e.g. 1)...but nothing appears in the field thus created! I'm doing something bone-headed, but don't see what the problem is. Thanks...

Hi there, now i'm creating a task related function. The sample file i attatch have 6 field (Duration, DurationType, StartDate, StartTime, FinishDate, FinishTime). The FinishDate and FinishTime is calculation field. The DurationType contains a value list (Minute(s), Hour(s), Day(s), Week(s), Month(s), Year(s)). User will fill in the first 4 field and then the system will calculate the Finish date and time. For example if duration is 1 Day(s) and the start date is 12/25/03, then the finish date will be 12/26/03. The time calculation is based on minute and hour. If user fill in Startdate 12/25/03, time 8:00PM and duration is 7 Hour(s). By right the result would be 12…

Hi, I was wondering if there is a way to have a scroll-able field that lists all the records in the database. even better would there be a way to pull up that record by clicking its "name"? thanks for any help chris

I am looking for a function (or some other way) that will automatically create a new field in the FMP database on the first day of the new Month.

Hi there, the picture is a part of interface design created by Ugo. I just use it as sample. Now want to ask what tools are you all using to create this kind of icon, i'm using pc, so if possible please recommend the tools that suiltable for pc. This all button look loke having transparent background and look sharp even on notebook LCD display with 800x600 resolution. Now i having problem with creating the icon that can have transparent background and also made it look sharp on notebook LCD. Regards, Henry

I have a mileage field that has to have at least 6 digits. If the mileage shows 58,457 then it has to be 058,457. Is there any way to make the field do this?

I'm working with Developer 6 in OSX Panther and when I'm in the defining Fields Box and when I choose to delete a Field(s) it takes 4 to 5 min for this to happen. Anyone else having this problem and can it be fix. This is slowing me down working with fileMaker.

Hello I have a situation where I scanned a great deal of ocr files which were inaccurate and had to be corrected extensively in a word processor. It comes down to this. If I can drag text blocks into a field in filemaker I can execute scripts that will separate and move text to the right fields. The catch is that it is different when there are more than three paragraphs in the text block. If it is just the three lines then I have a script which takes the first line and puts it in a field and the second line in a field and the third line in a third field. BUT When there is more than 3 lines (4 Lines) I need to do the same thing except the 4th li…

I am using FM6 as a call center application, and have one particular "screen" that calculates a lead type. I normally do this through conditional calculations i.e. If(some field = "X", "A",etc). What I am trying to do now is based on the calculation display a different result, depending on what the last record of equal value displayed. So if Record A equal "this", record F equals "that". To further explain, the client has directed us to refer those who purchase less than 20 items, should be referred to the clients preferred reseller, of which there are 2, alternating between them. There could be a gap between the "Reseller" leads.

HI I have to paste in a bunch of text from an ocr file into a field called " sentence" I always have to manually remove the last two words (place the first of the last two words in a field called "code" and the last of the last 2 words in a field called " price" and copy the remaining part of the sentence to another field called "description". The remaining words that go into the field "description" vary in number of words from 3 to 7 words. That is why I can't quite figure out how to do this. Any help would be greatly apprectiated Thanks Dave

I'm trying to conditionally enter the content of a field ("Sample") from another file ("Specimen"), based on the presence of values in other fields ("Row", "Column") in the other ("Specimen") file. This is my current attempt in the auto-enter calc dialog box: IF(Specimen::Row = "A" and Specimen::Column = "1", GetField(Specimen::Sample), 0) but it's not finding the entry in the Sample field... Any help would be appreciated.

I'm trying to learn how to parse text from a field that looks like this: Customer:Subcustomer:Job or MTV Networks:Betty Jones:Real World Episode 1 How can I get each piece of this string into its own field? Thanks for any pointers!

Hello all I am new and I need help. I have a field with 3 lines in it that is an address. Joe Smith 123 Main Street New York, New York 10019 Is there a way for me to extract the first line and send it to a field called "name" the second line to a field called "address" and the third line to a field called "City" I think this can be done but not sure how. Thank you K

I have a solution that I'm working on, using FMP 6.04 on MacOSX. Eventually it will end up as a runtime on a workstation that is part of a WinNT network, with various users logging on to use the machine and the solution there. Can someone tell me what the Status(CurrentUser) field will return in this scenario. The FMP manual says it will return the name of the user set in the application preferences, however I feel sure that this wouldn't be the case for a runtime solution. I am expecting that it will give the name of the logged on user (WinNT user name) - at least I hope it will as this will make my life a lot easier. Cheers, Murray

Hi all, I need to make a report, in following format: Item........Quantity........Price........Total Item........Quantity........Price........Total The data columns have to be alligned The problem is that I need to show only those fields in the report that are filled out, i.e. I have fields for Item, and if Quantity is 0 don't show the item at all. I couldn't do it with setting the layout because as I understand once I put the label or text field on the layout, I cannot remove it. Then I decided to make a calculation field that produces a text and I had if..else for each item, but now I cannot allign the columns of text, plus some item nam…

We use our FM 5.5 to create form letters regularly. To facilitate this we have scanned in several common signatures as TIF files and have insterted them below "Sincerely". Everything LOOKS aligned perfectly but when they are printed the image is shifted down nearly 2". This happens with EVERY printer we have Inkjet, Laser, HP or Xerox and even if it is printed to "Adobe Acrobat". How can we lock those images in place??

I am a school teacher using fm to figure class grades. I keep a gradebook in fm and I use the grades in my report card which is also written in fm. When it inserts the homework average into the report card the number is represented as 95.876543, but I want it to be 96. 95.876543 looks terrible. How do I adjust this? Please help, i have to turn in my reports tomorrow!

I try to count the exact amount of days that are listed in a timesheet portal. For example: in the portal are working hours listed from a person; the person can create multiple records on one day. The portal can contain more than -for example- one 12/12/2003. My question is: Is it possible to show in a calculation field the exact amount of days that are listed in the portal?

I want to create a field that is a checkbox that when I put an x into it, a graphic I have of a ? replace it. I assume the graphic has to be in a container, but I spent hours trying to make a calculation that if field mark is valid then container shows graphic. Haven't been able to figure it out. Thanks. I hope this makes sense.

I hope someone can help me with this! Usually, I can find answers to my FileMaker dilemmas by doing searches of previous posts, but today I don't have the time! Anyway, is it possible have a user "attach" a Word document and then have another user be able to retrieve that file (database is shared on a WAN server). Is this done with a container? I have never used containers before. I tried creating a container, but was only able to pull in a graphic. Can someone steer me in the right direction? Thanks in advance, Kate

I'd like to have a contract number field that has "03-" already present so the data entry folks don't have to type it over and over again - we have about 90,000 records to enter all based on contract numbers that start with 03- Is there a way to do this? Or an easier way I'm not thinking of being I'm a pretty novice user? Please and thanks.

I have two files, one contains main topics, the second contains subtopics. I want to have a way to "check" them off when they are done, so I created a check field with one option, then made it so when that check field was checked an icon of a much prettier check is displayed (for printing purposes). Anyways I got it to work on the first file, then I wanted to do the exact some thing in the other file.... did it.... doesn't work!?!? First file calulation(container) field formula: Case(checkBox = " X", GetRepetition(gCheck, 1), GetRepetition(gCheck, 2)) Second file calulation(container) field formula: Case(checkBox = " X", GetRepetition(gCheckTwo, 1…

I need to have a field display whether a record is expired or not (i.e. Y or N). I have a field that shows the expiration date. I want the expiration field to display "N" if todays date is before or the same as the expiration date. When todays date is after the expiration date I want the expiration field to display "Y". I am new to FM and databases in general. Appreciate any help.

I've been trying to re-arrange the data from a large database so that the data can be imported into a statistical software package. I've created a new database file and the defined fields based on a relationship (and logical calculation) with the original. It seems to work...partially. Some of the data is correctly extracted and re-arranged, but some is inexplicably (to me) ignored. Can anyone tell me what I'm doing wrong? I've provided a set-by-step description of what I did (and am trying to do) below, though the actual files are very large and rather more complicated (many more fields). Thanks! Pete objective: re-arrange the data in one file to conform with the se…

Hey there, I work for a non-profit and we wanted to show progress toward annual fund-raising goals with a thermometer-type graph. I'm attaching what I came up with. You can type a number in the field below the thermometer, or use the - and + buttons. The thing you'll want to take out of here is the repeating container field. It took forever to set up and no one should have to do it again, so I thought I'd post it. It can be used in any application where you want a progress bar. Be sure that in you calculation field you round or truncate your result so that you are evaluating a whole number. Cheers, Dan Thermometer.zip

I host a timetables db on my client machine on a Novell/Windows NT network. (Filemaker 4.x) We're stuck with that and do our best. I am about to go on holidays. Others won't be going and their access to the database poses a problem: Every monday I have to close down the database and then re-start it or else the date calc fields show the same values as last week. All users' machines show the wrong dates. I have always put this down to a network problem, but I'm looking for help just in case there's hope in some form of hack which will force a date-lookup. Take the Calc Monday field for example: Case( DayName(Today) = "Sunday", Today+1, DayName(Tod…

Hi, do you know of any ways to change the colour of a field, and the font attributes (colour, font type etc) through scriptings, calculation or alike? best giles

Hi Everyone ! I have a file with 500 products. I want to sequentially number each product. Had I been thinking, I would have created a field with incremented serial numbers before entering data. But I didn't do that. Now I have added that field but it seems serial numbers are only created when creating a new record. What can I do at this point ? Will expoting all the info into a new file work ? Is there a better way ? Thanks for the help. ~jack

Brand new to this Forum and very new at FM (Pro 5.0v3). I have an existing FM inventory for plan sets relating to highway construction. Contract numbers are unique. Records are based on contract numbers. I'm having problems with folks adding new records (and information) for contracts that already have an existing record. How do I stop this?

I added a global date field to hold CurrentDate. I have FM 5.5 running on multi-user platform and there's a script that sets the Global CurrentDate field to today. On one user platform where I run this script regularly, it works fine, but that script does not affect the CurrentDate field on other users with the same database open. To get the CurrentDate set, you have to run the script from the machine on which you are working every time. Did I miss something about the global field set up? Why is this not updating the field on the server side for all users?

I have a calculation: DepTotReq / PurchasePrice * 100 which gives me a percent of the deposit to the purchase price. What I now what to do is create a message to appear where the deposit is greater than 10% of the purchase price. If(PercentFlag > "10", "This will be an instalment contract because the deposit exceeds 10% of the price. Notify client of effect before returning contract to client", "") Question 1 - this calc is not working, it's putting it all of the time where percentflag does not equal to 10. I have also tried putting the 10 as a field but it still wouldn't work. Question 2 - Is there a way of showing a message? So far th…

Hi All, I have a small question about global date field. The files are on server so we share data together. What I want to do is when i create a global date field. Let's say : 2003-11-03 and everyone can see the same date as I set it ... the date is not changed until i use the script ..setfield to change the date. How can I do it? ... I did what people say ... put the file off the server and create global date field .. but everyone has it own global date field ... I want everyone can see it the same and when need to be changed ... we use script setfield? ... Am I correct or do I miss something? Any ideas experts? Anh Tran

Hi I have a database that stores image paths and filenames. When I put the path and filename together, I get the path to the image (ie c:ImagesImage33.jpg). Can I display the image that the path points to on a filemaker layout? I don't have any container fields, and would like to keep it like that if I can. Thanks!

HELLO TO ALL OUT THERE

I have defined a global field (as numeric). I want to validate the input to that field (via custom dialog) results in a numeric value or displays a dialog box. I've tried: NumToText(TextToNum(g_field)) <> g_field -> It won't catch non-numeric values. This is crazy Any ideas?

My task: This bibliographic database has many self-join relations: A&B share author; A includes B; B includes A; A&B are included in the same anthology C, etc. I would like portal hotlinks from each record to others related in *any* of these ways. But if I were to create four separate portals, they'd waste space: each of the four would need to allow for 20 rows, even though in most cases related records would pile into only one of those portals. So I've been aiming for a "disjunctive relation" to enable an inclusive 25-row portal from A to Bs of all these related kinds. What I did: For each relation I made a Value List of related ID#s, and then with one calc…

Seems like this should be simple, but I'm stumped. I have the Week of Year (44), and the Year (2003), and I would like to calculate the date of the Sunday of that week (10/26/03). Possible? Many thanks in advance.

Hi there, just want to know can i insert icon to fm layout? I had try insert picture or insert object, but cannot. Because now i need to use some icon as button, i saw some fm application also use that kind of icon, either xp compatible or mac compatible icon. Another question is can somebody recommend some website/company which provide the icon design services, i only know one of them is Icon Factory. And finally, what kind of tools you all use to design the mac look button? I'm using windows, so please let me know about the windows tools. Thank you Regards, Henry

I am at a loss on how to do this: I have a related field that I need to calculate the total charged amount of orders in the main database. Each client's orders are stored in a related database (billing::amount). I would like to be able to total the amounts of one found field (amount) in the main database. Thanks in advance

Simple problem but i can't figure it out. i have some fields with a date-format, but i need them to be automatically filled with the text "N/A" if an option is checked in another field. I tried calculations but the outcome needs to be a date and cannot be text, so N/A changes into "?" because text is not accepted I can switch the format of the datefield to text but that's not really a good option. How do i get a text outcome in a date-restricted field? thanks

Fields One, Two and Three can be put to either Yes or No. Create a valuelist to do that. It makes no sense, however, if all three are set to Yes, so I would like the user to be warned when he does this. So far, I have come up with a field called checkfield that calculates: If(One="Yes" and Two="Yes" and Three="Yes";"This can't be right!!";"OK") I was thinking about it giving a result of either 0 or 1, then creating yet another field (called validationfield with a selfrelationship and looked-up value to the checkfield, and have the result validated (or not: if not, validation gives me a nice pop-up, which is what I'm looking for). But no matter what I try,…

howdy all. i'll try to be as clear as possible with this one. applicants fill out a form online. this is returned to us via an email with the data they've entered. the data comes back like this: First name: josh Last name: brown Phone number:303-555-1212 street address: 1234 any street, apt b 6 references: mickey mouse, 720-555-1212 donald duck, 520-555-1212 spong bob squarepants: 213-555-1212 etc... now, what i'd like to do is extract the important data (ie, the data itself, "josh" "brown" "1234 any street, apt b 6" and not the field labels like "first name, last name, address".) and parse it out to it's field in my db. i have gott…

I have a layout with lots of field that has to be locked to prevent guests editing them. But is there a way to keep them locked and still be able to search the field?

Keep getting this error that the date and time of the associated file dont match up to the computer... I dont quite get it. The time and date on the computer are accurate. it also seems to be the same with the database file. What causes this? Keeps messing up some automation scripts I run for launching my database. when it encounters this message...the whole automatic process stops becuase FileMaker is waiting for user interaction with this warning. Since I have multiple users accessing the database over the local network, would this be caused by if one of their machines is drastically off on the time or date? LR

I use 5.5 v1 with Panther 10.3.1. Now when trying to define fields with a duplicate of another, I can't copy & paste say a long calculation into another field. I have to retype everything. Copy & Paste in FMP doesn't work at all. Otherwise it does in all other applications. Anyone know why? Thanks

Does anyone know if it is possible to change to color of a font or what image is placed based on a condition that is evaluated in a script or in a field calculation. Say if the particular calculation = 1 then the font is red or red picture is placed, 2 the font is blue or bluepicture is placed, etc. If this isn't possible within FMPro maybe a plug in. Thanks.

When I run this test I always get 1.3 as the result which is incorect as in some instances it should yield 1.2 or 999: what is wrong? TEST(# SERIE mod

Hi, I created a field that uses the Today function. The problem is that for this field to automatically update, I have to close and reopen the database everyday. Now this database serves as a host and others connect to it via TCP/IP. Is there any way of it recalculating the Today field without restarting the host database? or for the guests to recalculate with closing the host? Any replies would be very much appreciated.

Here is another one for you guys. I couldn't find a really appropriate forum to post it in so here it is...I have your basic summary report that has a header, sub-summary, and footer. In the sub-summary is a text field called Product and a summary field called Count that just shows a total count for each product in the subsummary for the found set. Of course the records have to be sorted by Product in order for this report to work. That's FileMaker 101. WHat I can't figure out how to do is display the summary report not sorted by Product, but by Count. In otherwords, I want to have the Product with the largest Count at the top and the smallest count at the …

Hi All - Here is an interesting one that has me scratching my head...I have a field called Specimen_ID. It is a TEXT field that uses Auto-enter:Calculated Result. The calculation for the auto-enter uses a field(Count) that is defined as Count(Specimens::RecordID). That's all well and good. Here is the quandry, when I bring up the Field Definitions box and look at the Specimen_ID field, it says it is Indexed which I would expect since it is a text field. However, when I try to use the Specimen_ID field in a calculation field, I can't Index the calculation field even though Specimen_ID is showing Indexed. Normally, I would just concede that an Auto-Ent…

Hi I have created an accounts receivable aging report with five categories (30,60,90,120,More than 120) and I am sorting for sub summary by account number and AR Category. My problem is that I want to total the AR Categories across all the accounts at the bottom of the report (total of all the 30 day accounts, 60 day accounts, etc.). Can anyone help with this one? Thank you. G