Calculation Engine (Define Fields)

I want to display a custom message box with custom buttons if one field in my database is not filled in. I'm having trouble setting this up. Can anyone assist me? Thank you

I am new to developing FM db at work, and have a project I am currently working on that I can not figure out how to make something work. One field will be record number, and be unique to the record. Another two fields will have the (1) building code or (2) location code entered. Depending on the building or location code, the record number should contain the code and a sequential number after it. For example, BLDG0001 then BLD0002 then HOUSE0001 BLDG0003 I know how to concatenate two fields (code and number) but I do not know how to make the number field work so that each code has a 0001, 0002, .... As of now I have the number field set to auto enter b…

Hello ! I am trying to open pdfs from a database and I managed to do it thanks to this forum (cf. openurl ) I have at the start of the database a field named "path to folder" where I enter the path to a folder containing the pdfs (e.g. /Users/myuser/pdfs). This field is also defined as "Auto-Enter" with "Value from previous record". This will allow me to easily use the database on different computers/users, by just changing this path. For each database entry I have the possibility to add 20 pdfs. I made a field for each named "name of pdf1", "name of pdf2" etc.. where I enter the exact name with extension of each pdf to open. For each pdf I have also a …

Is there a way to return a find to a one of two layouts based on the quantity of records found? In other words, if a find returns only one record, then you go to layout 1. If two or more records are found, you go to layout 2. Here's the real world problem. I'm developing a medical database in Salt Lake City, Utah, where lots of people share the same last name (i.e., "Smith"). So if I search for John Smith at a certain zip code, I may get more than one result. What I would like is the following: If there's only one John Smith at zip code 84132, then you go to Layout 1 that displays all his biographic information (and then confirm that you have the correct John S…

Does anyone know how to make a new repeating field that holds all the values of another repeating field plus the content of another text field? Thanks

I have created a formula under

I would like to create a calculation field referencing another field that uses 7 check box options (items #1-7). I want the calculation field value to be 1 if item #1 in the other field is checked and 0 if it is not, regardless if other items are checked. I would appreciate any help you can provide.

I have made a report for attendance. It is sorted first, by day, then time then class_id. My problem is that it is breaking the body when the page finishes and continues on the next page. Is there a way to not let it break or if it is going to break, to let it move it to the next page? so if the body doesn't fit it will continue it on the next page? I know there is the part function that page beaks after each occurrence but that isn't what I need. If I did that, then I would have 20 pages for a single day. A little too many sheets for my books. Any advice would be helpful. Thanks for everything.

I have a database with records containing date information (a 'date' field). I want to define a calculation field that determines the amount of time (days elapsed) between the date in one record and the date in the prior record. No doubt this is ridiculously easy, but I don't see how to do it! Thanks for your help...Pete

I found a way to get the week of the month from a date field. I first thought it would be easy but found out that FMP doesn't have a week of month function... Enjoy... code: Case( (Day(Date) - DayofWeek(Date)) < 1, 1, (Day(Date) - DayofWeek(Date)) < 8, 2, (Day(Date) - DayofWeek(Date)) < 15, 3, (Day(Date) - DayofWeek(Date)) < 22, 4, (Day(Date) - DayofWeek(Date)) < 31, 5,"")

Hello: Anyone know where I can get cool buttons for FMP 6? I'm running it on a PC. I'm looking for buttons to match the ones in the filemaker sample databases like the new and find buttons with the graphics. Thanks Mike

I created a report that summarizes students on different buses. (It's for a school attendance.) I find that no matter how I define a calculation I am still stuck with the same result---the same result I get when I add @@ to the layout, just numbers that go up that don't restart. I want to see a running total of each student on the bus. When the page breaks for the next occurence I want to have the numbers reset. I have searched the web as well as this forum for an answer. For the record I don't think it's an easy one.

i though i posted this yesterday, but seem to have been nuked. anyway, i have and inventory database. in the inventory there is a field (we will call "b") that is either blank or "yes". this is an auto entered field determined by another module called descriptions. so when something is entered in field "a" in descriptions, the field 'b' [in inventory modudle] is changed to "yes" in inventory. here is the problem. i put in a modification date field in inventory. any changes to the data of that particular item and the date changes. but when descrtiptions updates the inventory as described above, the modification date does not change. i am confused. shouldn't t…

Hello, Does anybody know whether it is possible to construct a fieldname in a scriptstep? What I would like to do is to make a loop. In this loop there must be a scriptstep that pastes a result in a field. The name of this field varies all the time, for example the first time the field is 'result1', the second time 'result2' and so on. In order to do this, I would like to change the name of the field with some formula, e.g. 'result+a' in which 'a' becomes higher all the time. Well, sorry for my lovely English, but I hope somebody understands. Any help is appreciated! Martin

Dear All I am struggling with a smallish problem that I know is probably quite easy but my brain is not funtioning. I have a persons name that has an ' in the middle of it i.e. O'Shea but I need to remove the '. Is there any easy way using a calculation Any help would be appreciated.

I am fairly new. I am trying to test if data, text or blank; IF field is text set newfield equal to it; if data, set new field as sum of this field plus another. Here is what I tried If(IsValid(S)=0 or S="", S ,T+ S ) assume S is a number fields If I have an E in Field S it prints out nothing; why? I guess because the E is not valid so it won't print it out If I had made S a text field it would be valid, but that does not help if I edit this to read If(IsValid(S)=0 or S="", "S" ,T+ S ) then it prints out S where relevant; that is because "S" is valid while the field S is not. But that does not help me as I need to print out the text in S …

When pasting text into a FM field from the Finder (as in copying a filename) or when pasting text from another application (Text Edit, for instance), the FileMaker field takes the text and maintains the format of the text as it was formatted in the source document. Is there any way to prevent this? Can you set a field to take any text pasting and convert it to the format settings for that field? Thanks for any help (using FM 5.5 BTW). John McDaniel

I need help with date validation calculation. I have fields itemID, start date and end date. ItemID can be duplicated. I need to make sure current start date and end date range do not crash with preious item's I have another set of dates start date and end date form a relationships, the check need to validate with this a well.

Hi, I have a requirement for calculating interest from averdue accounts such that if (Date) <30, 0 if (Date) >30 and <60, (ammount) *x if (Date) >60 and <90, (ammount) *x etc Can somebody give me an elegant solution please

i'm not sure if this is the best way to do this, but here's what i want to do: i have 2 files. file 1 is for employees, each employee gets one record. each employee/record gets its own serial number. file 2 is for references. every reference gets it's own record. employees may have up to 4 references. in file 2, users enter an employee number, and the name is calculated based on that. i want there to be a field that tells me how many records in the references file there are, so as to be able to tell from looking at a field in the employee file how many of their references have been contacted. any ideas? i've tried using the count function, but this…

Hello, I am having trouble in getting FM5.5 to count the individual words in a field for a number of records, ie: If I have a field called colours and the first four records looked like this.... Red, Blue, Green, Grey Red Red Purple, Green, Brown Now if I use the "Index" function I get a list of all the individual words and I can get a field count for each record but what I need is how many times each word appears even separated by a comma. Therefore, I would like to do is count each of the words that appear so that I get something that looks like this: Red 3 Blue 1 Green 2 Grey 1 Purple 1 Brown 1 Any help wo…

When I attempt to insert a picture of my company logo in to FM the RBG values shift from the original. The logo consists of only one color RGB (0,75,141) but when it comes into FM, it shows as RGB (0,25,196). I've tried several file formats and different colors; they all shift dramatically unless I do something like (255,0,0) which only shifts slightly to (255,2,0). Any Ideas? Thanks...

In FMP 6 on OS X, I drug/dropped some jpgs off of a gov't web site into a container field in a database. All is well in OS X. Then I gave the database to a friend using FMP 6 on Windows XP. He can't see the images. He has downloaded Quicktime, but this hasn't seemed to help. I don't think he's done anything beyond downloading QT...are there any special proceedures he had to do to make QT display the images in FMP? Any other suggestions? Thank you.

Hi there, I'm relatively new to filemaker so I hope this doesnt sound stupid... I've got a database right now for invoices set up, but I want to be able to print a report of invoice numbers and the corresponding subtotal for that invoice... easy enough. However, in the footer, I would like to be able to print a total of ALL the subtotals mentioned in the report... does anyone know what calculation I would use for that? Also, if anyone could direct me towards a great learning source for calculations that would be great. Thanks!

I am trying to create a database that will help me keep track of the miles that i drive and fuel used as well as fuel efficiency. I have a field labeled 'Current Mileage' and another labeled 'Previous Mileage'. What I would like to have happen is: Each new record created, the 'previous mileage' would automatically populate with the number that was in the 'current mileage' field in the previous record. Is this possible? thanks darron

Hi all This is probably very simple to do but I just cant seem to get it to work. I have a field that has in it a value that children have to pay for an excursion. I have another field which is how much they have paid already. I want a third field to display how much they are owing on the excursion ie Amount to be paid - Amount paid. Have tried but as yet have been unsuccessful Many thanx Poida

Im trying to display the field name that im selected on into a seperate field, it works if I select from recored to record, but when I select a different field on the same record, the display stays the same.

Hello, To solve this I need a couple of hours to learn. I know there are guys out there that write this down in a minute. That's why I ask: I need my serial in a format with always the same amount of digits. Now it is ID1, ID2, ID3 etc. I need ID0001, ID0002, ID0003 How do I setup the validation to get this result? Thanks 4ur time John

I have a question that might not be doable.... I have a student list, class list, student line item and some others... on the student list, each kid can be assigned up to 2 classes (entering the "class id" that relates to the class list file). I made a column layout that I want to use for an attendance sheet. it is sorted by 1. day 2. class time 3. class id 4. student id's and Name's. I had to do it this way since we have more than one class at the same time. Now our max amount of kids in a class is 7. The classes that have less than seven, are able to handle "make-ups", that is, if one kid is absent one day, to make up the class he/she can come to another class for that …

We have existng files that we than assign numbers to as they become active. I can not figure out how to have the field pull in the next available number when we activate the file. Could someone please advise me if its possible and how

Ok I need a little help to figure out how I would set this calc

i want to specify a field "emailsubject" to always have this looked up text. "Regarding your order # " and ordernumber and "with BookWormAnnex" i set the field to text with a calculated value and i just get is 0 as the result i have the result set to text.... if i remove the and all i get as the result is the order number.

In this example, there are 10 fields. If data is entered into any one of the ten fields, the other nine fields are "locked" and data cannot be entered into any of them. Is there a way to accomplish this? This would solve a huge problem I'm experiencing. Thanks in advance!

I have this problem in two different Dbs now. I have a simple time calculation - finish time - start time. How can I make it NOT calculate until both fields are entered? Currently, I get some huge figure as a result when there is no data in the finish time field. If I add a check on the finish field (IsEmpty or IsValid or <=0, I get 00:00:00. What I want is for the calculation not to happen until there is a valid finish time entered. Is this possible? Thank you! Martie

Hello everyone, I have a cointainer field with a MP3 file attached to play via quicktime. I'm creating a promotion cd for a friends band. I have 1 minor problem. I would like the user to be able to move around the different pages while the song is playing. I have the name of the song set as a button that selects the container field which allows the user to click play on the quicktime bar. But if the user clicks anywhere on the layout or moves to another page the song quits. Is there a way to allow the user to move through the pages and keep the song playing? I tried adding the container field to all layouts this does not work. Any Ideas? Thanks, Michael

Hi all Does anyone know how to round a figure up or down to for example 2 decimal places. I understand the function: Round (number, precision)but what I need is to be able to round a figure like 1.2876 down to 1.28 I hope that makes sense to someone. Many thanks

Hi I have a problem I use a database at work where I have to create job records and input information some of it I have and some I have supplied by my customers. The problem is that the information I receive from my customer is being duplicated by him. Is there away I can set up filemaker to stop me inputing the same number as a previous record. The field in question is a number field. Regards Lucky

Hello. I am new to filemaker and have very little experience so please bare with me. I have learned a little just from reading through the threads. I need to create a calculated field that will give me "age" based on two other criteria besides birth date. If one's gender is "M" I need to calculate their age as of August 1 of the current year. If one's gender is "F" i need to calculate as of January 1 of the current year. Can anyone lead me in the right direction? Thanks.

I have a field that inserts the current user and time so I know who makes a new record and when. Works fine except for when a record is duplicated. It is copying the old information. Is there a way to enter new user/time information into the field when duplicating the record? Thanks, Mark Durgee

Is there a calculation that can be used that will red flag a record when a date has been reached? I have start date and a due date. When the due date is reached I would like it to red flag automatically. Thanks for your ideas.

Hi there, I have a number of related files creating a stock control system: stock goes in, stock goes out and what's left in the warehouse. There are two warehouses, stock is counted in cases, but also in units as a total of both warehouses. My problem is that some of the calculations that use results from other calculations don't show up properly. They show minus figures, when I refresh the screen the figures are correct, but they revert back to the minus figures when printed or viewed in preview mode. These are the calculation fields that show up correctly: SumCasesRecPhoe Unstored Calculation =Sum(CasesOut::CasesReceivedPhoe) SumCasesShipPhoe Unstored Ca…

This question may have been addressed before, and I think I may have read it some time ago. If so, I am sorry. But here I go: I am trying to think of a way to not show in-active records, ie. I have created a file for my students. One of the fields is a "status" field with a drop down list of "Active, Absent Short term, Absent long term, stopped." What I would like to do is omit all the "stopped" records. I know I have to make a script and apply it to the "open" script that is run when the document is opened. But I don't know excatly how to layout that part of the script. If someone could give me a hand, that would be great. Thanks for everything everyone has don…

When you insert a file like a Quicktime Movie or jpeg into a container field, where does it store the data? Does the file size of the file.fp5 increase as you add quicktime movies to the database? Or does it store info about the file somewhere else and accesses it? If so where does it store that file? Thanks, Paul

Folks For some time I've been advocating the use of Status(CurrentDate) as replacement of the Today function. At the back of my mind I've been wondering why FMI would leave the Today function in FMP at all, other than for legacy backwards-compatiblity. After all it causes more throuble that it's worth. Well, I worked out why it's still there last night. I have a database where each record has a date field. This database is basically used as a value-list generator for another database, where I want a list of available dates to be displayed through a value list. All was working well until I realised that in a few months the list o…

Hello, I have two different fields, Store QCM and Store RTS. They both contain store numbers from different files. I need to combine the fields or make on field that has both values so I can report the data. Like Store QCM or Store RTS = new field.I cannot figure out the calculation. Please help. Thanks, Shari

I am trying to set up a simple inventory control list using a barcode reader. I can

Hello, I'm new to this programming stuff and need some assistance. I want to have an Error message Pop-up window display or grey out a date from a drop down menu when certain criteria is not met. I have defined the message and it displays under the field when the incorrect information is entered. However, I would like to only see the message as a new window pop-up when the error occurs. Also, I would like invalid data to be greyed out so it cannot be selected from a valuelist drop down menu. Example: I have training dates in a value list for a year(Jan- Dec). I want to grey out past dates so the user can not select dates in the past. How can this be ac…

Maybe I'm tired, but I cannot find a solution : I have a database, let's say DB1, with records. For each record, the creation date is automatically introduced, and the year+month of creation calculated. I another database, DB2, I create some record, 1 for each month of each year. A link year+month links the two DB togheter. It's easy to calculate the number of records for each month from DB1 in DB2, by NUMBER(dataDB1), for instance. Let's call this field numberDB1. Now, I would like to calculate a cumulative field (call cum), wich should show, for each month, the total of record in DB1 up to the concerned month. Example : suppose that I have 10 records in DB1 for the 1…

Does anyone know how I can get my phone number field to automatically insert a "-" in the appropriate places? I want to enter the ten digits and have the number format as xxx-xxx-xxxx when I exit the field. Any suggestions?

Currently every time I create a record, I have a serial number increment by 1. What I want is every time I create a record, the serial number finds the max. value and increments that by 1. Also, I don't want the serial number to be modifiable. I know I could use the "Set Next Serial" script, but that only works on 5.5+ (correct me if I am wrong) and I can't use a script for what I am doing. I know you can do this in Access. Help?

I am putting working out a locker database for our school. The locker inventory, student name etc... I can figure out, however, each locker has 5 possible combinations that can be assigned. It seems like a radio button field would be the choice, however that would be a lot of value lists. Additionally, I don't think they would show up in a columnar solution. Could use some guidance on this. Thanks for your help in Advance Norm

Is there a way i can display the current time on the screen in real time? i tried a calculated field with status(currenttime) but it is like a clock with no battery. hehe and ideas? i want to use it to display something in real time based on the current time.

Hi, I'm new to this forum, and my first moment here I got a major problem answered and fixed (duplicating records with portals- THANKS!) My other problem is this: Within the portal I have a text field via a value list pop-up. The value list is coming from a field of File B. I want to display multiple lines of the field within the portal. Extending the portal field vertically out of the bounds of the portal row allows me to view overflow text fine. Carriage returns I place in the original File B records are ignored; I only get the text up to the return. However, if I manually put in carriage returns within the overflow text thru the portal, it displays properly. …

I have toiled but I keep getting cornered. So... Is there a way to conditionally validate, say, field A, so that if field B is blank, then A must be blank as well; and if A is not blank, then also B must contain some data? Conversely, suppose A and B contain some data already, as per validation rules. Then if I delete A, B must warn me that it must now be empty, too! Any help most welcome and thanks in advance.

Is there a way to allow users to enter information into a record only on the day that the record was created? That way users could navigate through previous records without my worring about them getting lost and then making changes in a old record (while assuming that they are working on the current record). Also, if I could implement such a restriction, I would like to be able to over-ride it via a password. Thanks in advance! Jason

I have a strange thing happening with a field that I have formatted as radio buttons. The outline of the radio button itself doesn't show up. The radio button shows up as a white dot instead of the same color as the text in the field tag. This just happened. I suppose I inadvertantly changed a setting but I don't know which one. The checkboxes are not showing up either. Help, please. Thanks The Mad Jammer

I'm evaluating the technical issues involved in the development of a digital(ized) document archive with Filemaker. The simple idea is to make a database of scanned documents. Each page is stored in a container field on a record. I want the document browsing (zoom in-out, scroll,...) to be the most quick&comfortable possible for the user. Zooming and scrolling trought the FM interface is too slow (require too many mouse movements and clicks...) The solution I've found is to present the user the full page. When the user clicks somewhere on the page then FM zoom into the selected area. Zoom is performed like this: there are two layouts: ful…

How do i write the calculation dependant on the fact that 1 field is with in a certain number range and a second field is a selected value ie smog ok or no smog and what the equation is based on the combintation of those values. ie if lot number is 500...599 or 700...899 and is smog ok field +$40 if lot number is 600...699 and is smog ok or no smog filed =$0

How do i protect the intregrety of a customers address at the time of the sale, and be able to update my mailing system. I am running 5.5 and have the customer db seperate from the main db. Sales are entered in the main db at time of purchase on a look up and then updated as needed.

Hi, I am trying to force my lookup fields not to relookup for certain records. My setup: I have a Customers.fp5 file and a Invoice.fp5 file. The Invoice file has a CustomeID field to relate all invoices with a customer. So when an invoice is created and the CustomerID field is filled, certain lookup fields are populated with the data from the customer record. Such as: address, phone numbers, discounts, etc. Now the real problem. Sometimes some employees make mistakes and create more than one customer file for the same customer. These duplicate customer files are not realized until many invoices have been created for both customer records. So I a…

I am currently having a problem trying to write a formula that will calculation the monthly payments that are required to produce 50,000 savings at an interest rate of 6% in 20 years..thank you for your help in advance. nick

Hi I have a specific enddate and endtime. what I would like to do is show the time remaining in one field. For example if there are 2 days left is will say 2, however if there is less that 1 day left it should show the hours and minutes left. I can do this as separate calculations, but can't figure out a way to show this in the same field, since they result in different calculation types (date or time). Is there a way of doing this. or is it impossible due to the different calculation result formats? Thanks

I need to create a slide show that will scroll text, almost like a Power Point presentation, but with several hundred names. These names would represent different levels of customers, so I would like to color code the display based on the data field. I'm using FM 5.5 on Windows XP; anyone ever done this?

I have create a monthly report and would like to include a total of the manhours for the month. The current reports we use, the time is based on a 24 hour clock. My question is, we have people who work the late shift (past 12:00 midnight), how can I get the summary for an indiviual lets say the works from (9:00 pm) 21:00 hrs. to (2:00am) 02:00 hrs. Which should indicate a total time of 5 hrs. Any suggestions?

I'm trying to create a field that displays the count of listed items in a Sub summary report in preview mode. Example: If I have 10 records, 3 with the name "Joe", 2 with the name "Bill" and 5 with the name "Sue" and I create a preview report listing a summary of names, I would get a list of 3 names... Joe Bill Sue I'm in trying to create a field that states "3" for the number of items listed. I tried creating a self join of the "names" field and then created a counter field to identify unique names, but that only works if you do a report on the whole db not the found set. I've attached a example pdf of the report. I hope this make some…

I've looked thru the entire book I have and tried everything I can think of, so now I will ask the wizards here. How do verify data integrity prior to storing it in a db? One of my biggest headaches right now is that this application will accept any date from year 0001 to 3000. BUT I want to limit it to say 1 year with no later than today. I see how to make a time frame but not a ROLLING time frame.

I'm not sure how to ask this question. I have a form where I muliply hours by employee rate. My rate field is in a separate database. The rates change each year. How do I prevent the current year's information from changing? Cin

Greetings All, I have a TimeCard Layout which includes a summary field. This summary field calculates the total of the users time entered for the current week. This is being used company wide for 30-40 users. Some of our users complain that every time they add a new time entry, the "Summarizing..." dialog appears and has to go through all the records, and they have to wait. For most users, this "Summarizing..." dialog only appears the first time the layout is display, but not thereafter. Why would this occur on some computers and not others. They are all running the same version of FileMaker (v6), and OS (Win2K). The only difference appears to be the p…

I need to create simple drawings within filemaker, to be stored in a field. These would be almost stick figure like in simplicity, so the tools could be quite basic. Is this possible? Thanks!

I wish to calculate the number of days that have transpired between two dates. My calculation field is LaterDate - EarlierDate. Unfortunately the LaterDate is not always available and the calculation yields a huge negative number. How can I resolve this dilemma? I also want to calculate the average number of days for all the records. I suppose I will have to exclude records without both these dates? Thanks The Mad Jammer And then...there was nothing.

How would I do the following (if possible): I have a text field foo with a string of numbers that are implicitly grouped in chunks of 12 characters. I would like to construct a multi-line key field from this data. For example: --- 123456789012123456789012... --- becomes --- 123456789012 123456789012 ... --- Can I do this with a calc field? If so, how? I'm stumped..

In order to "Replace" on the records, one should press " Ctrl + = " How can I open Replace window with or without using Shift key? :confused:

Hello, New to Filemaker. Making a db that has a layout with several buttons. These buttons each point to a seperate layout. Each layout is identical and each one has the same fields as the others. When entering data on the first layout, the same data appears in the same fields on the other layouts. For example, if I put an Invoice Total on the first layout, click the button to go to the next layout, the Invoice Total has been populated with the same data as on the first layout. How can I make the same field across each layout allow its own seperate data to be input? I can do this by duplicating fields, but this seems a long way around it. Any help appreciat…

I am importing data from a database that has the date and time together in one field like this: 9/3/2003 1:31:49 PM since there is no combined date and time field definition in filemaker pro, how can I search through this field when the date and time is combined? or separate the date and time into separate fields automatically? thanks for any help!

I would be very grateful for some help from an experienced user. I'm a graphic designer and I use Filemaker for client invoices. I am trying to figure out a way to create a calculation for a field that will add up all outstanding invoices. I have a "Year to Date" calculation that tells me everything that has been invoiced. When an invoice is paid, I enter the date in a "Date Paid" field. So what I need to figure out is a calculation that will add up all the invoices that have an EMPTY "Date Paid" field, and subtract them from the "Year to Date" summary field. I've now spent three days trying to do that, and I feel like a total idiot. Thanks very much for any help you can …

I have a very long html form with many loops in it. I'm trying to keep track of how many times a user hits a specific web page while they are filling out the form. To do this, I have a "ctr" field and some CDML code on the page I'm trying to track that should add 1 to the current value of the counter each time the user hit's the submit button. The code looks like this: <input type="hidden" name="ctr" value="[FMP-Field:ctr] + 1"> Unfortunately, when the information is written to the database, it doesn't calculate the math. The field ctr will contain the value "0+1" or "0+1+1" and not the value "1" or "2". Any ideas? Thanks! Kei…

Hello, I have a text field that holds a code like so "03-0528-1". The field is a standard text field so that I can allow the dashes. How can I increment the last number so that it becomes "03-0528-2" using insert calculated result(script)?

have a file containing invoices segregated by "A" for Active and "C" for Complete.

My company recently upgraded from FM4 to 6 at at the same time crossed over to PCs. The transition was relatively painless but I'm still having one problem. It seems that FM4 defined the message in the subject line to mean that no calculation will take place until all field contain a value, while FM6 defines it as the value isn't calculated until one of the referenced fields contains a value. We have 3 fields for this calculation (number) and as soon as one field is referenced the calculation runs and gives a result of zero. If anyone who has come across this can offer any assistance or a suggestion it would be great. Thanks

I cannot figure out this, I have a layout with one drop-down menu and a button and a script

This is my problem : I have to printout a document several times but with the content of one field changed for every copy. Like saying 'Original', 'Copy', 'Archive', etc. The field contents are stored in a value list. What I have to do now is change by hand and then print every copy. Tedious job .... Can anyone help with this ? Thnnks in advance

This must have been an issue before, but can't find the solution. I have a calculation field (working hours x price/hour) but want to have the ability to overrule the outcome for this field. So actually I want to set new data in this calc. field. But as you may know, this is not possible with calc. fields. How can I make a solution for this. Tried lookup-fields, but don't think this is gonna work. [email protected]

I have a pretty tough project here. One of my FM files has about 500 defined fields. As you can imagine finding a field in the Define Fields window is a nightmare, which is why it is important to me to keep things sort of grouped. Unfortunately whenever you have to duplicate a bunch of fields, they always get added to the very bottom. Two questions: a) Is there a way to duplicate one or multiple fields in such a way, they the dups appear right below the originals (instead of the bottom)? : Is there a way to hilite several fields and move them at once? Rearrange fields one by one and having to scroll through hundreds of other fields really drive me nuts!!! …

I am attempting to create a layout/report where a record color is different based on the value of another field. For example, I want "Last Name" to be RED if the value of Field "Voted" is Y and BLUE if the value of Field "Voted" is "N". Is it possible? Need help ASAP. Thanks

Post deleted by Kristen

I'm having difficulty with a situation where when I exit from an newly added record (via script), without filling information in all the required fields, I get 3-4 "requires a value" errors for the same field, then a question about continuing with the script, and then one more "requires a value" error. The number of errors are independent from how many required fields are empty. Any ideas what might be causing it? My database has a three file grandfather --> parent --> child relationship. One presses a "Done" (or Cancel) button at the bottom of an entry screen to commit the record (by exiting the form) and return to the parent record. When the required fie…

I'm looking for a solution where I can reset manualy the Auto Enter Serial in a Field. Is there any way of resiting the Serial?? Thanks

I have a portal which contains a field from a related file. The portal is set to display multiple rows (thus displaying the field of interest from multiple records from the related file). I would like to make a label, presumably by using a calculation field, which 'adds together' the related fields in the portal rows, thus creating a single field containing the field of interest from all the records in the related file. I hope this makes sense. Does anyone have any suggestions? Thanks!!

Hello I am pretty new to FileMaker and do not know how to make a sum field. This is what I have and want to do. I created a Employee database with fields like name, last name position ect... What I want is a field that is called TOTAL Employees. How can I get that field to output the total employees that are entered in the database? Remember I am really new to FM so I don't know much about Calc fields. Hope this is clear enough. Thanks, Jay

My request is very simple. I have developed a simple db to calculate the %markup on the digital cameras we sell in our store. The db will be spread around the company so that we can esily remain competitive. I need it to be as idiot proof as possible. I have a field that displays the date that the price has been changed. I need that to be automatic rather than typed in by the user. The record also has a % column in which the operator can enter the markup, therefore a simple 'last modified' button is useless. So my question is... How can I get the date field to change to the current date when only the price field is modified? I suspect the answer is really simple b…

I am working on a database that takes data from a student info database (Apple's PowerSchool) and uses it in FileMaker for busing information. My problem is PowerSchool lists a student's address as "123 Street Rd" (one field), but I need each piece of the address in FileMaker to be in separate fields so it can be sorted by street, etc. I can write a calculation to separate "123 Street Rd" into "123" and "Street Rd," but sometimes there will be a N, S, E, or W in front of the road, or there will be a POBox after the entire street address, or there will be an apartment or floor in the address. Each of these needs to be a separate field. Has anyone deal…

How to do I go from [text string] "Eng_question_q501" to [text string] "Eng_question_a501]? I know how to use Substitute as a basic step, but how do I tell the calculation to only change the "q" if it is found within the final 5 characters? Thanks! Allegheny

In my contacts file I have fields called

Hi All, First time poster in desperate need of help. I have a simple DB tracking actors at a talent agency. Each actor is assigned a Division via a value list: infants, kids, young adults, seniors. Each actor also has an Agent Status of a simple yes, no. How do I get a running percentage of each Division's Agent Status? 50 kids total, 20 have agents = 40%. I've gotten it to work, but only via a trailing grand summary on a dedicated layout for each Division. How do I get the percentage fields for each division to display correctly and update automatically and globally at the top of my main layout? I know this is a lot to ask from a new member but any…

I might have asked this question already so If I have asked it, I am sorry. Anyway here is the current calc. I have ID number for each record:"Right(Year( Date ),2)&Right( DayofYear( Date ), 4) & Right( "0" & Status(CurrentRecordID), 6)". It comes out looking like this 03246019. At the beginging of the new month I want the last 3 numbers to reset back to zero. How can I do this?

How can i have a calculation field thats result will be a container check 15 records in a related db and if one of them has a bitmap in it then the calculation field will then contain that bit map otherwise leave the field alone? did i say that right? hehe basicly i say 15 because thats what i expect to be the max number of related records in any given day. then i want to check the related field in the related record to se if its empty. if so check the next related record and so on till i either have no more related records or i find one with a bitmap in it. i need to have it in a calculation field because i intend to have another db look at the results through a portal. …

hello there, i need some help doing the following: i have setup a progress dB with data being collected by means of radio buttons. eg. Level of trust 00000 (radio buttons with levels 1-5) Performed Well 00000 etc.. each radio button in each row is given the same field name (eg. "a1" for row 1, and "a2" for row 2). i create multiple records for the same person and would like a summary of the averages a person rates for each entry. could i get some help, or if more clarification is needed, please ask. thank you all so very much.

This is really strange. I have an English School in Japan and we have report cards for our students. Each report card has a bar indicator for each item they learn in that level. So the bars run vertically down the page, like: ABC's OOOOOO Verbs OOOOOO Nouns OOOOOO ect.. What I was wondering if there was some kind of way for a radio button or check box that the teacher could quickly just check and it would print on the report? I tried using the standard check box list values, but they are too wide. Then I started to create a field for each box, total of 6 fields for each item. But that came to 84 fields just for that one report. The space I am w…

Hello everybody! I have a database with a hundred records (so far). I have a field that calculates everyone's age in years only. I would like to create a statistical layout with several similar fields: #1 would display the total of people between the ages of 15 and 20. #2 would display the total between 21 and 25. #3 would display between 26 and 30. And so on. Seems pretty straightforward, but I just can't figure this one out with either a summary or calc field in one single, simple step. I guess I could do it by creating several intermediate processes, but this seems both inelegant and unnecessary. Can anybody help? Thank you. I love th…

Sorry about this because I am sure that it is probably easy for all of you but I need to validate a field and I can't figure out the right way to make it work. I need to validate it by a calculation that will only let the user input "10" or "20 or "30" or "40" and so on up to "100". Can someone please help me out with this? Ron