Calculation Engine (Define Fields)

I know it's possible to insert a field from a previous record. Is it possible to insert a field from the next record?

Hi All I would like to know an Auto-calculation field can be changed? It means that a field (auto-enter calculation) take value from other field at the first time. But when The other field changes the value the field (auto-enter calculation) does not change ...it remains still ... I want that auto-entet field changes also not using calculation field ... Is there a way to achieve it? Thanks Anh Tran

I am trying to do a report with a sub-summary part that would summarize the totals. I have the report sorting by id number with summary fields in the sub summary layout, but everytime I go to the preview screen to see the results, it's blank. Can someone help me out and tell me why the report would be blank when I have several records in there?

There will be times when a seller may also buy products, but the seller and buyer would have two different id #'s. For instance seller: John Doe sold 3 cars and bought 5 cars: John Doe seller_id = 05; John Doe buyer_id = 101 Sold: 1997 Ford Escort: $5000 1995 Chev Cavalier: $6000 1998 Buick LeSabre: $10,000 Total:$21,000 Bought: 1985 Mazda B2000: $400 1986 VW Passat: $1000 1995 Ford F250: $2000 1990 Chev Corsica:$2500 1989 Honda Accord:$1500 Total:$7400 Now I would need to be able to add the three items sold together, then add the five items bou…

Hi, Is there a way to split up text from a textfield that has normal carriagereturns? Example: text now is (in one field): Bananas Yellow or green grow on trees I need those three lines in separate fields since i'm having trouble exporting files with those vertical tabs FM produces. The users of this solution import the exportfile directly into Quark Xpress and will get a huge amount of pages because those VT's create a new page for each occurence. Or is there an easier way to export the above data? To clearify some more, the data shown above (banana's etc) reside in a lineitems DB and the main DB calculates the exportfield. Since CR's are not…

I know how to get the number of the currently selected record using a script. The question is, if there's also a way to figure out the number of the SELECTED record with just a calculation and NO script. None of the Status(CurrentRecord...) functions provides this info as it seems. However if you take a look at the image below, you might understand why I'm asking. Or does anybody know either how to prevent the empty space below the list from being clicked or how to make the empty space act like a button, so that it stills can trigger a script?

I have two fields, serial_no and vehicle_id and I want to say if the serial_no is empty then the vehicle_id has to be 17 characters long, but if there is something in the serial_no then don't worry about the vehicle_id. I wrote: case(serial_no = " ", length(vehicle_id)=17) but it doesn't work because whether or not there is something in serial_no it still comes up saying I need something in the vehicle_id. How would I fix this?

Hi all, I am trying to format a calculated field to only show 1 decimal point, and can't do it. I tried the regular Format->Number->Show fixed num of decimal digits, doesn't work. The field is a simple arithmatic calc: RelationA::F1 * LocalF1 / 1000 & " " & "kg" It is unstored number field (since it's based on related RelationA::F1 field). Anyone had this problem before? Thanks in advance for tips/pointers.

I have created a report which shows the members of a value field. My problem is that if their are no records for a particular field (ie noone meets the set criteria) then that criteria is left out of the report. Is there a way to get it to appear but simply have no memebrs? Many thanx Poida

How can i do it, paritcurarly within a script. Thanks -j

Is there anyway to setup a field so that the default is a certain state like "CA", so that when you come to the field it is already populated with the state of "CA" and yet have the ability to change the default to any other state if needed and that state then would be the default. Example: Default state "CA" change default to "NY" now default will be NY until changed again.

HI, I am trying to creat a Sub-summary field for sale tax, so the list has to be sorted by counties. I used the counties as a break field in Sub-summary layout, but i couldn't get it to work. Can a break field be a "pop up list"? That's the only thing I can think of. Thanks.

Could you explain what this symbol (

Is there a way to setup a field so that whenever data is put into the field and you have to do a search on this field that it is already setup to be (==)exact and nothing else but that number will come up? example: If the field is "customer #" and the number is "10" and I do a search on this field I only want the "10" to come up and not 101, 1001, 100 and so on.

I Have a system that registers every person that makes a phone call complaining about a department in the Company . I would like to be able to make a report with the top 10 departments with more complaints. Does someone know how to do this ?

hi, i was wondering how i could disable a field by having the user select a radio button option. For example, i'd like to have a group name field and individual name fields. There is a radio button group with the options being either group or individual. If the user selects the group radio button then the individual name fields are disabled and vice versa. Thanks Brian

Hi ....... I have a survey form with about 30 questions (Yes/No). I need to count the total of "Yes" on all the serveys. Simple .................... for some ;-) Trevor

I have to perform searches on a text field that may contain a lot of words. Should I turn indexing off ? FM help says that filemaker indexes only the first 20 chars of each word up to 60 chars. I tried to test it: I put a lot of words (far more than 60 chars) in a text field (indexed) on some records. FM is still able to find a record even if the word searched is the last one in the field. Why? When indexing is on, FM have to update the index each time a record is edited, deleted, created. May this affect performance? Thanks in advance... Paolo

Hi, Is there a reason why I can't get a calculation field to remove apostrophes from names to create logins? Substitute seems to remove everything else for me but not apostrophes. Sample included: Substitute(firstnameimport, "'", "") I have created nested substitutes to try and remove any extra characters that authentication on various servers may not like. Thanks David

I can't get this to work ; I made an invoice db (invoice.fp5) with orderinformation from different relationships, for example: worked hours come from 'timesheets.fp5', used materials come from 'material.fp5'. In the timesheet db, people can add their working hours by specific hourcodes. All these codes belong to a certain category, for example: codes DES1, DES2 and DES3 belong to category DESIGNHOURS and codes COP1, COP2 belong to category COPYWRITEHOURS. What I would like to make is -in the invoice.fp5 database- an invoicelayout (report), with a subresume part that will only list the categorynames (like: DESIGNHOURS or COPYWRITEHOURS) from the 'timesheet.f…

I'm setting a Letter Body field with auto-entry of a calculated value: some text, then a currency figure from a related field, then more text: ---- FOR SERVICES RENDERED IN ARRANGING " & Upper(type_of_loan) & " LOAN IN THE AMOUNT OF $" & amount_of_mortgage & " ON THE ABOVE REFERENCED PROPERTY WITH " & Upper(Company_Name) &"." ---- I would like the currency to appear formatted, with the "$" and commas in the appropriate places. (ie. $900,000 ) But in a text calculation, only the text (900000) comes out. Does anyone know a handy calculation to parse out the numbers and get the commas in the right place? Many thanks!

Dear All, I would like to know if we have a way to know what date is the latest date for each project. For example Project Date 1 2003-01-01 2 2003-10-01 1 2003-12-01 2 2003-11-01 So For Project 1, latest date is 2003-12-01 and for project 2, latest date is 2003-11-01. IS there a way to achieve this? Thanks All Anh Tran

There is no quick way to explain this problem, so please bear with me. I ran into a bit of an odd problem the other day. I have two files- Prospects and Sources. Sources is a db of different advertising publications (like the Reader, monster.com, etc.). Prospects is related to this file because each source has generated a number of prospects. In the prospect file, there are fields that hold a value of 1 if certain things are true. There are fields in the Sources file that count the amount of records that have 1 s per source. These figures can be seen in a list layout. So far, everything works great. I have made fields that total the figures in the count…

I'm new to this so please bear with me, I have used the search and did not find and answer. In the photo catalog template, when I enter lot's of keywords the info gets hidden behind the field. Looking at the photo catalog database (not keyword database) I have looked into making it a scrollable field etc.(no can do). Is there any way I can make it so that all the keywords can be viewable (over 1000 keywords). Or I thought about making a duplicate of the layout and for each image the keywords are selected and when finished have a button script to take you to the original layout with only the selected keywords visible (max 10 keywords to each image). or is this …

Dear FileMaker friends. I have a number field, that contains 13 digits. Now I should splitt those 13 digits in 13 new number fields. In other words, the first new number field should show the first digit of the original number field. The second new number field should contain the second digit of the original number field. The third new number should contain the third digit of the original number field, and so on. Is this possible? Please help. Many regards from South Africa

Please Help! The URNs in my database have started to duplicate themselves. This is causing havoc with the related databases. How can I stop the URNs from repeating themselves?

I would like to place a carriage return (chr(13)) in a field. I am exporting data and need to have several blank lines between the data I am sending out. The paragraph mark seems to put a linefeed (chr(10)) in. In Word, this is not a paragraph return. Is there a way to do this?

Hi. I am a 'very new' user of this forum (as from 31-MAR-203) as well as being in a 'learning curve' with Filemaker and am hopeful that someone can help me with the following problem. I apologise in advance if this Posted question goes on a bit! Also I wasn't sure if it should go in DEFINE FIELDS or VALUE LISTS forum - but I'm sure someone will 'put me straight later'. I am transferring staff records from several excel workbooks into a Filemaker 4.0 database so more powerful searches and reports can be done. I have got the main layouts looking OK and have imported some data for test purposes but I have run into trouble with trying to duplicate a 'Calculation Ta…

I am looking for a way to create a simple calendar that generates dates automatically. I've seen some very intricate examples, and don't think I need to be so complicated. It would be used to post training dates/other events. Any help would be greatly appreciated. Elizabeth Burns

is it possible to nest the substitute function? i'd like to do something like this: textinputfield: "Please substitute aaa for bbb." textoutputcalc: "Please substitute apples for oranges." i could do this with two calc fields like this: textoutput1 = Substitute(textinput, "aaa", "apples") textoutput2 = Substitute(textoutput1, "bbb", "oranges") but that seems not particularly elegant, especially since each additional substitution would require an additional calc field.

i have a file with records each record needs to have one (rather large) picture (so it should be included) but the way you insert (or attach) an image shoul be dummy proof. for now I have a container, but each time you insert an image you need to be sure you check if it is only including a link. also you need to select the container first can i script a button? should i make a seperate file for the images? and the project will be a runtime solution

Hello, I have a text field that contains check boxes. On another layout, I have those check boxes that are selected represented as plain text. However, the when the checked items are represented as plain text, they appear as one giant vertical column. IE 111111 222222 333333 444444 555555 How can i get them to display in seperate columns. IE 111111 222222 333333 444444 555555 666666 777777 Thanks

I need to print a report showing a list of all the seller's and totaling their sales, expenses and so on. How would I do this?

Is there any way to make a field display the current year only Many thanx Poida

i need calculation field with a date as endresult and the new date should be the date in another field + 1 year example date1: 12/01/2003 result: 12/01/2004

Probably been covered before, but I've found a nice way to go from an email address to a clickable web address... "www." & RightWords( Substitute( Email, "@" , " " ) , 1 ) Replaces the '@' sign with a space, then does a rightword 1 on what's left... Works for me

Hi! I have a db for my traffic department. One user has all creation and editing rights (not scripts and layouts). When she clicks the "Create New Job" button, my script adds a new job into the system and creates a new job number. Once that job number is created, I don't want the user to be able to accidentally modify this field. If I give her 'read only' rights for that field, the script to add the new job number doesn't work (field is not modifiable). If I uncheck "allow entry in field" and approach it that way, she cannot do a search on job numbers, which is the most common search needed in her dept. Is there a way to tell the system to allow modific…

Help...I am developing a database which is used to input text which in turn will feed Quark Xpress. Formatting for Quark takes place in the filemaker side. I have a field where the text is input and have used the wordcount function to display amazingly the word count! However part of the coding involves "<b>" for bold etc. even though there are no spaces between this code and the word.....the word count counts this as a word e.g. <b>The totals 2 words and not one.....as I do not know how many of these commands will repeat in any given record is there anyway around it???

I inherited this fp5 program. Rather simple but for the life of me I can't figure out why I can't edit the fields " White Bottle Number" and "Amber Bottle Number". I can't find any calculations that restrict. Field format has "Allow entry" selected, and I can enter into other fields like Bottle name, etc. Anybody have any ideas. please find file enclosed packoff.zip

I am trying to create a report that displays the field "First Name" when a child meets a certain criteria in another field. I want to list all the names of the children who meet specific criteria. Eg if a child is chosen as Blue from a value list (Blue, Green, Yellow, Red) I want a report to list all the children who are Blue, all the children who are Green, all the children who are Yellow and all the children who are Red. Is it possible Many thanx Poida

I want to use a field twice (actualy like 15 times) on a page, however, I want to be able to enter a different value in each field. Can this be done or do I have to define a new field for each value entry? Thanks Dave

I'm trying to create shipping labels that would return a running count. The user would enter number of boxes, then the labels would return a count for each label. i.e.: 10 boxes would return a "1 of 10", "2 of 10", etc. etc. for each label. I'm a bit of a novice, so any help is GREATLY appreciated. thanks, Michael

So I have a layout with a bunch of fields, and I want to change the text format in them. No problem -- except for the Date field. When I click in that field, all the text formatting is greyed out. Why is FMP trying to ruin my life?

I am BESIDE MYSELF with this one! I have tried to adapt the time billing template but there are too many differences in procedure. We currently use Excel: 1 file for ea. employee, broken out by day and in .5 hour increments from 07:30 to 20:00 for each day. There is a macro in place that fills out the new dates and blanks the data for each new week. I have tried so many different ways to write a db to replace this. I don't know how to: 1) have it fill out the current week's days and dates automatically each Monday so the employees only need to fill in their job numbers and tasks; 2) after verifying job numbers (can do a script easily for that) dump the info i…

Is there a way to make a field (i.e. "Names") to be stationary in a table while the other fields scroll horizontally?

Can anyone tell me if it is possible to have a field that tells me the current age of a person in Years and Months from a Date of Birth Field?? Many thanx in antici.............. pation Poida

I'm having a problem with a calculation. I have a Grand Total which consists of Total Price + Sales Tax + Buyer Fees + Credit Card Surcharges and a Total Paid which consists of a Summary of the Total Payment. Total Payment consists of Payment to Surcharges. So it would look like this: [color:"green"] Grand Total = Total Price + Sales Tax + Buyer Fees + [color:"blue"] Credit Card Surcharges [color:"purple"] Total Payment = [color:"brown"] Payment + [color:"blue"] Credit Card Surcharges (line items) [color:"orange"] Total Paid = Summary of [color:"purple"] Total Payment [color:"red"] Balance = [color:"green"] Grand Total - [color:"orange…

Does anyone know a trick how to add comments to formulas? I have some pretty complicated and long formulas which I would love to comment here and there, just in case I have re-adjust them at any later time. [color:"#666666"](Please don't recommend to use sub-formulas - this databases already has 180 fields and I don't want to create even more)

Hi, I have a field called Order_ID that is a primary key, using auto increment. (i.e - serial number, next value, increment by blah blah). But instead, for added flexability, I want to use lookup field, the Max(Order_ID) + 1, but that causes an circulatory error. Is there any way to get around this? Thanxs, Steve Griff

I am learning how to create a tabbed interface and am following the instructions from a FileMaker Advisor magazine article. I am brain dead though on how to get a global field to equal text. What it is telling me to do is name the tabs throuhg global fields. I am assuming I need to do this through a script but then where do I place the script and what should it say? This article has been great and I have been able to do everything except this one part. Thanks for all the help you have given me on past and future items. This Forum is a GREAT resource. I do not get to work on FM on a daily basis - only as time permits so I forget a lot in between. This has taught me lo…

what is the best way to have boolean fields. for example: gender: man/woman or yes/no fields

Inserting a picture as a reference is the best way having pictures in FM. The problem is to know how FM manage these references If I insert a picture from a folder on my desktop, it makes the link from there. I can move this DB to another location, it will always find the picture. Now if I move this picture to another folder, it won't find the picture and FM displays a message instead of the picture. BUT if I put this image in the folder where the database is located, it will display the picture again!!!!!! How can FM knows that the picture is now on the same folder as the DB?: The other point is if I store the picture on a folder, but located on a serv…

I am trying to do a report and I can't seem to get a total at the bottom of the report for the [related number field] inventory_item_price. Is there a way to calculate or summarize a field that is related for a grand total.

I was wondering if there are any suggestions out there for capturing the file name of an ole object inserted from a file?

Hi, I'm having trouble with the Status(CurrentLayoutName) and Status(CurrentLayoutNumber) Functions. I've created calculating fields that are simply currentLayoutName = Status(CurrentLayoutName) and currentLayoutNumber = Status(CurrentLayoutNumber) But this isn't working. The fields never change when the layouts change. They just keep the value that they had when the field was created. What am I doing wrong? Thanks, Dan

I am real trouble here. My lookups are not responding as they should. when I create a record in a portal the values in lookup fields (there are several) are not looking up. If I put it in a second time It does lookup where am I going wrong!

Hi everyone, I'm looking for a way to block the 'return' key into a field. Is there something we can do to block specific caracters from being entered into a field? Ex.: I have a field NoPiece than contains this value: 12345. But if the person who write the value press the 'enter' key before leaving the field, it will result on a value like: 12345 (with a return after the number) I don't want that field containing 'return' cause it mix up the links that are using it as a key. Thank's a lot!

I am new to FM (FMP 6, OSX) and I've spent a couple days searching for answers to my questions on this forum. Thanks to all those who have taken the time to answer posts, you've been very helpful! I have a couple questions of my own... Question 1: How do I preserve text formatting (such as superscripts/symbols) in a text calculation field that combines one or more text fields? Question 2: If I have a text calculation field that combines a text field and a date field, how do I format the date part of the calculation to display 01/01/03 instead of 1/1/2003 (For example: ProdID = TextField1 & Month(Date1) & "/" & Day(Date1) & "/" & Year(Da…

I have found an oddity when working with my value lists. When entering data everyting is working fine. but when I am in find mode one of my lists is not working at all?!? Can this be explained? I can see no reason why this is happening.

I tried to download the sample files from that section of the forums, but all i get are garbles text files on my mac. So apologies in advance for asking silly questions that i'm sure have been covered over and over agian. I got a date field called "DATE". I want to add 5 to the year so i can show the ammortization date in field "AMDATE". So if DATE = 2/2/2002 then AMDATE = 2/2/2007. I know this must be simple, but i cant get it. Thanks, Steve

Hi Geeks I want to install a quicktime file (sound) within a script. I checked some posts and one of them tells to create a container field, use "Go to field" and check "Select/Perform". I did that but it doesn't seem to work. I guess the problem is related to the field itself. After creating the container field, what are the next steps? How do I connect, paste the sound file to it? Bikeman 17

Hey there, If I wanted to find the highest value within a relationship I'd use max(relationship::field) How do I find the 2nd highest value? Thanks, Dan

Hi, I'new to FM so forgive me if this is a dumb question. I have a database for my customers in which every customer is a different record which contains its basic information and a list of the products they sell and the price of them. This data is stored in two repeating fields, one for the product code and one for the price of it. I also have a database of the products in which every product is a different record that contains detailed product information and a portal that shows what customers are selling that product and the price of it. The problem is that the price is wrong, it keeps showing the price of the first product in the repeating field of my Customers databa…

What is the best way to find paths to pictures that have been inserted before? I took over a database with almost 6,000 pictures. They have been attached using Insert Piture[ ] script step. Is there a way to get those locations (its all over a network in our company)?

I want to give the user the ability to "attach" a file (say a PDF) to a record. I know how to launch a file using Send Message and even if I have the name of the file in a field. But how do I give the user the ability (through a prompt)to call up a Windows browser window, search for a file, select it and that file name (and path, i guess) copied to a field. With the intent that another user can then click on a button to open that file. I hope I made myself clear. Thanks... Curtis

Does anyone know of a way to store more than 64000 characters in a text field? There is the obvious solution of splitting the data into several fields, but I am looking for something more elegant.

I want to extract the initials from John Smith. I've been able to get the J by doing this: Left(Name,1). But I am having difficulties to get the S. Any help would be nice! Bikeman

If I change the name on an existing field in the database, will all references to that field be updated as well? What about search selections in scripts? Anything else I need to think of? Thanks,

I have noticed a strange effect when I use a text field displayed using Monaco. Each space becomes elongated (to about 20+ character widths) on certain machines. I have only noticed it in OS9. I need to use a none proportionally spaced 10pt font andMonaco is by far the clearest of the 'standard' set. Has anybody else had the same problem?

Is it possible to go to a field have it highlighted so that you can either accept the text that is in it already or type over it and enter your own and then activate a script within the field by hitting the enter key?

i have file that contains transaction records: record number,record date, Material type, transaction type, transaction quantity. in another file I want to total the transaction quantity for all transactions that occurred on a particular date, have the material code "X" and are transaction type "Ship" the result is that i want the current days shipments for a particular material to total and auto enter based on this calculation when i create a new record, but i want it to ignore other transaction types such as "xfer" help please Oliver

Please Help! I spent the morning trying to make a field that automatically creates html for my eBay postings. I already have a database with all the fields of information & have the html template in GoLive. I was hoping that I could some how create a some sort of mail merge field that would replace <<Headline 1>> with the text from the Headline 1 field. I want to be able to just copy and paste this information into my eBay posting (right now I open a Golive template, fill it , copy the source information, & paste it into eBay... and I want to be able to have FileMaker to do this for me, so I don't even have to have Golive open.) It seems so s…

I am having a problem with the current found count function. When I use it on a from it does not give me the correct number what am I doning wrong. Basically if I have 10 records found it will tell me 18 when looking at the first record then 12 when looking at the next. This is very confusting.

I am confused as to how to find the running total of a field. I have a DB called BPriceList which has the fields of price, quantity and cost. How do I keep a running total without having to create a script go through a loop of 600+ records and adding all the cost in each record. When I created a layout for summary printing of items bought, the layout setup asked me to create summary fields, one summary field for the category, another summary field for the type and a summary field the overall cost called total_cost. (the category summary field is just the sum of the types in each category and the total_cost is just the overall sum - of all cost. But when I view …

HELP! I have a calc field PrintKey(number) = Case(Location = "A" and IsEmpty(PrintDate),ForiegnKey,"") I want to use this in a relationship so it has to be stored and indexed. FM allows me to set it as such, but then when I leave DEFINE FIELDS window and come back to it, it has been changed to UNSTORED and I cannot use it on the right side of my relationship. Fields Location and PrintDate are both local to the file. The ForiegnKey is a lookup, but that shouldn't matter should it? PLUS, FM allows it while I'm defining it. Why is this happening? Thanks- Courtney

Hi I wish to define a field that calculates a date taken from two drop down lists - one containg numbers, the other containing periods (e.g. day/s, week/s, month/s). For example, if today's date is 17/3/3 and a user selects 2 weeks, the calculated field returns 31/3/3. Any idea on how this might be achieved? Thanks in advance.

When choosing a Time seperator ":", This does NOT automatically enter between HH and MM-- Only between MM and SS... I would like this to occur between HH and MM without manually entering ":"... Can this be done? [color:"#666666"]

Hi, On my calendar solution users can put in the starttime of a session and the duration of that session. The endtime is easily calculated from that. What I need is : when a new appointment is added for a user (multiuser solution), it should verify that the appoinment is not made while that user is in a session. If teh starttime is 12:00:00 and the duration is 01:00:00 the user should not be able to make a new appointment prior to 13:01:00 (that minute I'll calc away later). Is there a way to verify a field using a timerange? I could use a find request in the lineitem but that would not speed things up, and i rather see it happening on the fly. Any hints on…

Hi, It is my understanding that if you include a field with auto-enter creation or modification dates, the data will be stored. The effect will be applied to all subsequent entries. My question is this: Is there a way to determine when files were created or modified if they don't have these options originally specified? That is to say, can I determine when files were created or modified last if the creation/modification field is not defined? Thanks for your time, john

I have now a database of persons (who will go on our skitrip) Now i need to group those persons in appartments of 4,5,6 each type of apparment is limited, and i don't have any spear beds.. This is going to be a big puzzle (because friends want to sleep together,...) has anyone an id how to tackle this? I think i need a database with records that contain 6 fields, each one with a dropdown to choose a name from the person database. The problem is, I don't want to be able to select the same person twice and I want to be sure i've placed everybody. finaly i have to take into account my number of appartments of each type. I hope this is understan…

I have a JobStatus (Text, Pop-up list) and a StartDate (Text, Auto-Enter, Calculation) fields, so that e.g. StartDate=Case(JobStatus = "Running"; Status(CurrentDate); "") On a test layout everything is OK, but then I implant it in a FileMaker Solution Framework (by Matt Petrowsky) the StartDate calculation returns 3/12/2003 in place of 12/03/2003 irrespecive of "Date Format" settings and "Use System Format" checked. Have someone an idea ?

I have 2 databases (people type a and people type :, but i need them to have a unique alias. the databases are seperate, because they have to many different fields and calculations. can i look up if the alias is unique in the other database?

Just had an interesting problem. I had the need to find the "max" of an alphabet character, one per record, related to its associated part number. Background... this new customer uses letters for Revision levels of his drawings. A is first B second, and so on. We need to know the current release of any drawing (highest letter in alphabetic order), so we need to find essentially the "max" of the rev level field in alphabetic sequence and have that available to all part numbers in the file... Now having said that I accomplished it already by using a huge case file converting the letter to number then using the obvious methods, max number, etc to get to the solution, …

I use calculation fields and the substitute function for harmonizing the appearance of certain text fields like addresses, for example for changing

My problem: I can't find the total number of unique IDs when I do a find.... Some background: I have a db tracking students. I have a portal to a related db tracking each student's total hours of tutoring each week. Not all students were tutored. Each tutoring subject is designated with a code. For example, english tutoring is 01, math is 02. Now I need to calculate the average number of hours students received tutoring per each subject (code). I thought I was doing well when I set up my related db to find the number of unique IDs of students that actually received tutoring. Since each student had multiple entries in the portal, I set up a Calc field…

Can anyone tell me why, When I copy from one field (using scripts) and paste into another field(and another DB) the font of the copy grows to an 18 after the paste?

I have a FM file shared with FM Server. The file has a global field. When the file is opened remotely, what is the initial content of the global field (or what the content depends on) ? thank you

If I go to add a record with a unique ID number and there is already a record in the database with this ID number, is there a way to have the existing record popup on the screen with all its information?

I have a lot of fields which I want a total of in a separate field (of course). I have made a very backward definition, I believe, which I would like to be better. But this is the best I can come up with. The main fields are WeightlossDay, WeightlossDay Copy, WeightlossDay Copy2, WeightlossDay Copy3, ... From the weightloss per day, the total weightloss should appear from an addition calculationfield that has added the subtraction calculationfields I have made for these mainfields. SubtractDay = WeightlossDay - WeightlossDay Copy SubtractDay Copy = WeightlossDayCopy - WeightlossDay Copy2 SubtractDay Copy2 = WeightlossDayCopy2 - WeightlossDay Copy3 …

can i define a field so it generates an random code of 8 caracters?

I have an invoice, but I believe I have it setup all wrong. First part - Header: I have the header reading company information. Second part - Body: I have a portal (2 lines) showing info from the payment screen. Third part - Footer: I have totals and a paragraph explaining the invoice rules. Problem I am having is when there are more than 2 items purchased, only the two items show up on the invoice and the others drop off. I'm sure that this invoice is not done correctly, but I don't know a better way to set it up. Could someone please explain to me a better way if they know it? Thank you.

Here's the goal... I want to be able to place a repeating field in a record multiple times, with each iteration of the repeating field showing a separate repetion of that field. Make sense? Let's say I have a repeating field with five repetitions and it's named Field_A. On my layout I place 5 copies of Field_A. Is there a way to make each copy of the field show a different repetition instead of showing just the first repetition? I also need to be able to enter data into each specific repetition. Basically I need a repeating field that displays 1 repetition, but I need to be able to specify which repetition is displayed. I know that I can make this work with a relat…

I pretty sure this can be done. I would like to create one field that will total up the amount of each record found. In other words field "a" has a diffenrent total for each record. however I would like to have a global field that will show a total of all records added together or records found. waht would be the easiest way to create this? Thanks RET

Hi everyone, I have a big problem: I need to have a calculation field that would be different for each record of a file... Ex.: I have a file 'PiecesSpecifications' and a file 'Doors'. In 'PiecesSpecifications' there is a calculation field 'Formula' that count how many pieces we need in a specific door according to its width. But that calculation field must be different for each pieces (ie. each record). For example the calculation of Piece #1 could be (DoorWidth * 3) and for Piece #2 (DoorWidth * 2). Is it possible? Thank'a a lot!

I am inserting pdf 's as references into container fields and wonder, how can I view pages 2+ of a multipage pdf in this setup?

I am trying to make a field that will make the name of a student possessive so their name can be used in a possessive form automatically. Is there a way to make a formula/function that will look at the name of a student, see if the last letter of their name is

I have a problem ( I believe associated with the MacOS X (10.2.4) upgrade we just completed) with some graphics stored in a global container field. The graphics will not display. I have a calculation field that toggles beween a small graphic in a repeating global container fields based on some If logic that was working fine before the upgrade. It still works on all the PC's just not on the Mac OS X machines. Older Mac OS works. Thanks!

I have a date calculation as follows: Case(DateInstruction <= TextToDate("30/6/2001") , DateInstruction +30, DateInstruction >= TextToDate("01/07/2001"), DateInstruction+14) I need to amend this so that instead of adding 30 days to the dateinstruction, it adds 1 calendar month. i.e if the date is 10/03/2000 the returned date is 09/04/2000 when it should in fact be 10/04/2000. Problem this causes is if you put something in on say 31/01/2000 the result of 31/02/2000 is obviously incorrect because there's no such date and should therefore become 01 or 02/02/2000. (govt legislators have no idea about logical calculations!) Understandbly I have a h…

Hi all, One of the people using my filemaker system has come accross a problem that I have to solve... maybe it's easy, maybe it ain't. One of the products in the database costs

Someone posted a way to modify a calculated field once, but I don't remember who. I tried to use the [Number Field] Option - Auto Enter - Calculated Value - but this didn't calculate the field. It just stayed the same. So when I go and use the (Calculation Field], the calculation works, but then I can't go back and modify the field if I want to. Is there something I'm missing or is this possible at all?