Calculation Engine (Define Fields)

I’m trying to calculate percentage of sales by city in a summary report using the get summary function. Below is the formula (I thought would work). Percentage Value = GetSummary (Total Sales, City) / GetSummary (Total Sales, Total Sales) Total Sales is the summary field. City is the sort field (break field). The Total Sales value displays fine in the subsummary part but the percentage value returns 0.00% Can someone please help me out on this?

How do I have the "date" field convert to a text output? So if the date is March 2, 2006, the result is "2006-March"? I tried this but the March shows up as "2" GetAsText (Year(Trip Date) ) & GetAsText ( Month(Trip Date)) Thanks.

hello, i would like to have a globale calculated A field that contains all of B field's contents in current found set in this format: A=B1 B2 B3 B4 ... A and B are in a same table, how can i do it?

How do I validate by two fields? I want to be able to have a warning when a new record is entered with the same first and last name as one already in the db.

I'm setting out to design a billing system that will show me a list of related "open" invoices for a particular client. I'm having trouble visualizing a payment system where I can enter a single payment amount, and still controll how that payment is distributed to various invoices. For instance, if someone makes a partial payment how do I record that so that the payment is applied, but does not show up in the future as a credit. I just want the balance to be adjusted. Any suggestions?

I have a field that calcuates a sum, but I need to validate that the sum is unique. The calculation is based on four other fields. It is: (FIELD1*100000000)+(FIELD2*100000)+(FIELD3*1000)+FIELD4 It generates a "unique" 11-digit ID based on the four separate fields, but as a regular calculation, it is possible to have duplicates, which I can't allow. Even if I had to add a field that performed a logical test like "Is FIELD6 unique?" with a YES/NO as the answer displayed in a field next to the "unique" ID field. Any suggestions? Thanks, Thomas

I have a one-to-many relationship from TableA (the one) and TableB (the many), matched on fields "teacherName" and "reportDate". A portal displays the correct set of records. I want to include a set of calculated fields in TableA that contains the number of records from TableB in the relationship that contain a specific value in field "classPeriod". I can easily count all records with the formula: Count ( TableB::teacherName ) But I can't figure out how to count how many of the records in TableB in the current relationship have field classPeriod = "1". You advice will be appreciated. bkg

A little background: I work for a real estate company. Sometimes a large piece of property is composed of several smaller sales, or sometimes it's already one big chunk. I'm trying to create a layout that, if the property is comprised of multiple sales, it will total up all the different site sizes and prices, and place that number into a field (say, Total Price and Total Size). If that calculation is greater than 0 (i.e., multiple sales have been entered) then I want to use that number for fields called Price and Size. However, if no data has been entered there, then the site would be one big chunk, and I'd like to be able to hard key the fields Price an…

I want to be able to edit the data that is aut-entered into a related field without editing the matching relationship, is this possible? Right now, when i edit the field, it also edits the related field, I don't want to do that. Can and how can this be avoided? Thanks!

Ok trying to Explain as best i can... I have a data base consisting of 4 fields, Data Link, CSI number, Trade name, and Com number. Each is a repeating field with 30 repetitions. In a related Table I have the four fields copied with the same repetitions. I have the com number set as a drop down list with the Value list being the trade name and com number. When I try to populate the related repetitions based on which com number and trade I do, it automatically fills all repetitions. Is there a reason why this occurring or is there a trick to using related fields in this manner? In our solution we need to be able to choose a variety of trades to import; the com and cs…

Is there any way to draw lines & circles on a form? I'm not talking about layouts, but actually in browse mode. What I need to do is to be able to draw an arrow or circle to a specific spot on a photo that I inserted into my form. Many databases and form software packages do this, some even offer photo editing, but I can't figure out how to do it in FMP. Plug-ins, add-ons or any other items are welcome. Thanks!

Hello! I have three phone number fields for each contact entry, but I need the phone numbers as they get entered to search all three fields for a same number. I understand how to search in the same field, but I cannot figure out how to search the other fields. Thanks.

Please help if you know a way to do this. In a newspaper publication file I have a number field for the issue number - 125, 126, 127 etc. I need a calculation to convert these numbers into the issue month and year. Issue 125 = Feb 06, Issue 126 = Mar 06 Issue 127 = Apr 06 etc. As new issues are added the calculation will need to continue on into future years. The further catch is that there are only 11 issues per year. They don't publish in July. Thanks for any ideas.

I am new to filemaker and have a most likely easy problem to solve. Although I cannot solve it. I have a check box field. If the checkbox is selected I want a differnt text field in the layout to display a message. If the box is not checked I do not want a display. I understand that the display would be default text insert in the text field. ie. I have a slip that is being used for sick time and other events. When the sick time check box is checked on the form I want a text box on the footer of the form to have SICK TIME entered in it. Should this be a script or a calculation with a text result? How would I do it. Any help would be greatly appre…

I have a script that prints one layout, current record to two differnt printers. The only problem is that I get 2 copies of the same page at each printer. Below it the scripts -------------------------------- Print This One Printer 1 Go to Layout [ “Print this one” ] Commit Records/Requests Print [ Current record; Pages: 1 to 1; Orientation: Portrait; Paper size: 8.5" x 11" ] [ Restore; No dialog ] Go to Layout [ “Main” ] Perform Script [ “Print this one Printer 2” ] ---------------------------------------- Print this one Printer 2 Go to Layout [ “Print this one” ] Commit Records/Requests [ No dialog ] Print [ Current record; Pages: 1 …

Hello Could I change a path container to display quicktime files in one part of my database?. I did a GetAsText "size:432,324 movie:base de datos PLACIDO/BASE DATOS-PLACIDO /EDIT STYLE/08 Telefonica Movistar.mov moviemac:/Macintosh HD/Users/jescorredera/Documents/base de datos PLACIDO/BASE DATOS-PLACIDO /EDIT STYLE/08 Telefonica Movistar" I´d like delete "base de datos PLACIDO" Apologize about my english If you could help me I´ll be very thankful meanwhile I´m going to continue trying.

I have a database that was first built in FM 5 or earlier. At that time, each database was it's own file with relationships that keep breaking etc... Now FM 7 and up can have all those tables in one file. Is there any ways I can bring all my files together in one and re-link them or do I have to re-build everything from scratch?

Hello together, I am pretty new to filemaker, however, it seems to be a convenient program. For my database, I have a question: Can I show different drop down menus in a field, based on what was entered in the previous field? An example -) Field1: Main dish Field2: Topping (Both fields are drop down menus). If I choose "Pizza" in Field1, Field2 should show the values "Cheese" and "Peperoni" for selection. If I choose "Pasta" in Field1, Field2 should allow to select either "Bolognese" or "Arrabiata". Can this be accomplished in a simple approach, or is it very complicated? I plan the have 4 fields in row, each connected to the previous one (…

I'm starting to think about ways I can build a building occupancy tracking system. Basically, I have 3 tables: People Floors Leases On each floor record, I have a field that indicates the number of lab modules on that floor. Each lease record is a join between people and floors.. so it has the following fields: person_id floor_id start_date end_date number_modules I have 2 questions.. How can I make it so that the system will prevent the user from creating a lease that utilizes more modules than exist on that floor ? Eventually, I will create a crude calendar layout that displays all the leases for each floor at…

Hi. How can be sure that the record number (defined field) matches the record number under the flip book on the upper left hand column? Have tried for 8 hours, but no luck. Thanks!

I would like to know how to write a script or calculation that will enter the tax amount depending on either of two radio buttons. i.e. I have two radio buttons - 'T0' and 'T1'. If T0 is selected then I want the tax amount to be 0, otherwise I want the result to be the net amount x 1.175. Thanks for the help Lyndon

I have an expense report I need to show this: ------------------------ 1st Quarter "State" "State Totals" LA $345.98 MT $ 54.78 2nd Quarter "State" "State Totals" ------------------------ and so on. So for each quarter, the state and it's totals are listed on one line. I got it to do a sort by state and date, but for LA, it shows 2 listings for that same quarter. I need it to total into 1 listing for the state and quarter. Any advice?

I am trying to make a simple estimate sheet with a price list. I would think this should be pretty easy in FMP or even excel but I cannot find or create a practical solution. I had a FMP db that was almost there but every entry in the price list is a different record and that really screws things up for me. I would like to have a different record for each job. All I need is for the unit cost to autofil if the description on the estamate layout matches any description on the price list layout. Not all of the items will be in the price list so I need to be able overwrite the field. Most software solutions are really junkie and needlessly complicated. I am really lost and co…

I have a simple question If I have a price per item if people select it in a value list with radio buttons I want to assign a price to it to be placed in a calc field for example If the field fruit says "orange" then place $.75 in field price but If the field fruit says "apple" then place $.50 in field price How can I do this the best way. thanks Dave

Hi, I am having a hardtime with filemaker. Here is my problem lets see if someone sees it I am farmer who wants to record the activities (for example : irrigation, plantation, etc ) performed in the farm. I have sectioned or divided the farm in 5 sections and subsections. Therefore, i will have section 1 with 2 subsections = 1-1 and 1-2. Section 2, subsections 2-1, 2-2. Each sections has a number of acres and each subsection has a fraction of the section. So, for example section 1 will have in total 5 acres but divided in 1-1 with 2 acres, and subsection 1-2 with 3 acres. In the end i will want to record the activities performed daily and be able to summar…

Hi, I have made a simple data base for my recipes and would like to create a shopping list for 1 week. I have the recipes and would like to add selected recipes to a Menu and out of the menu create a shopping list. I have absolutely no idea how to do this and are hoping someone can help. Thanks in advance!

This is kind of a complicated issue and I'm new to all of this, so hopefully it fits this forum. Invoices are created and are related to contact information by a Contact ID. Each contact can have a credit limit that is stored in the contacts database. If the sum of the balance due for every invoice for that contact is > the credit limit, we want to halt the creation of a new invoice. The calculation is as follows: Credit Limit Calc = If(Sum(Invoices::Balance Due) >Credit Limit , "No New Invoices!", "") The problem I have occurs when trying to create a new invoice for a dealer that has a large number of older invoices. The calculation of the balance …

I am modifying a to do list template to become a call log sheet. It is coming along nicely but there are a few things that I need help with. 1- How do I define what field the cursor appears in when a new record is created? It goes to the 2nd field which is the phone number and I'd like it to go to the name field instead. 2- How do I get the auto complete function to work on fields that are for numbers (telephone numbers) Do i simply set it to be text instead with the auto complete box checked? 3- I created a sort button to sort the records with newest at the top- is there a way to automatically sort the records so the newest are at the top of the list? 4- I'd l…

Hello FMForumers, Got another (not-so?)tricky question for you: Have a simple Category/Sub-category situation. Sub-category has a SortPosition field that I'd like to auto-enter. It seems simple enough, but I've run into some FM gotcha apparently. The fields are basic: Category: ID Name SubCategory: ID CategoryID Name SortPosition I'm trying to auto-enter the SortPosition with a calc like this: Max (SubCategories 2::SortPosition) + 1 where SubCategories is a self related table on CategoryID The user interface is a Category layout with a portal for SubCategories. The problem that you experts have probably already…

.. heres the story... i need a calculation that will evauluate quickly... the calculation only has to evaluate to 1 or 0... i have two global fields... we will call them field A and field B both in the same table... now... if all the values in field A are in field B (where field b can have the values in field A plus others) then it evaluates to 1.. otherwise it evaluates to 0... ive tried a custom function referred to me by soren called zapvalues using variables that are set equal to fields a and b: If ( IsEmpty ( ListA ); ""; LeftValues(ListA; IsEmpty(FilterValues(LeftValues(ListA; 1); ListB))) & ZapValues(RightValues(ListA; ValueCount(ListA) - 1); L…

Hello, I have a comment field in my database. My problem is that some users made up canned comments in a text editor or word processing program to make their input easier. Their text is a different size (much larger) and the font they use is different. Is their a way to reformat the font automatically after they paste it into the field or can is their another solution in order to avoid this problem. Because when a report is printed the font destroys my format. Thanks for your help in advance DH

I have an application which was converted from FM6 to FM7. This application had two related tables (table1, table2) which have a one to many relationship. Table1 has a calculation field (sum1) which calculates the sum of a field in related records in Table2. This calculated field is displayed on a layout along with fields from table1 and table2 (in a portal.) Sum1 only seems to get calculated when the first row is added to table2's portal if one is tabbing from field to field. I understand that this is due to a change in behaviour between the two versions. Is this correct?

Hi, I once saw a little file that allows you to insert an image in a global container without shutting down the server. I can't find it anywhere now... I'm beginning to think it was a dream. Anyone know about this? Thanks, Andrew

Hi, Sorry if this is a silly question. I'm fairly new and i thought a repeating field could help, but it's not working for me.... I have a database of cabs for four states. Some of those cabs are part of a fleet. Which means that in One record there may be multiple cab numbers. How can i show that? I tried a repeating field, but it's not even showing up in browse mode for me to click on and enter the different cab numbers. So at the moment for all of those fleets that have multiple cab numbers, i have them in one field, all together. I need them to show up as a list too, but i'll ask that later....

Hi, I've got a database containing about 400 staff in my organisation. I'd like to have the facility to select a name from a pull-down menu, and have a picture of the person appear (I expect in a container field) on the layout. The solution must work on Mac and Windows. An obvious answer is to store the images within the database. But with 400 images of about 10KB each, this makes the db 4MB bigger than it needs to be. I'd like to avoid this if possible. Storing the images as a reference seems to be the answer, then. But this has the problem that Mac paths won't work on Windows, and vice versa. To get around this, I thought of creating separate Mac and…

Just a few days ago I finally started using Filemaker 8. And I'm pretty satisfied. But I do have a little problem. 2 tables: jobs customers I have a dropdown list on my foreign key field 'fkcustomers' in the table jobs to choose the customer (value list with hidden customer id). To be able to see what choice I made and not an id number (because unfortunately the id doesn't stay hidden after closing the dropdown) I have a related field that displays the customers name. Here's the problem. After making my choice in the dropdown, nothing happens in my related field until I click outside of the record. Only than the customer name appears. I mu…

Hi, Could someone help me with a calc, I would like to get a true/false result when: Field 1 and Field 2 (both empty) = 1 Field 1 and Field 2 (both not empty) = 1 Field 1 and Field 2 (either not empty) = 0 Thanks Ian

Hi I am have some trouble with data spilting in Pop-up Menu. The is data from an Define value list. (second screen dump show source ). If I enter the text in the source field and put return at the end text line and start a new line it spilt the data in the Pop-up menu but if there is no return in the field and text just Continues on and there is no spilt of the text on the pop-up menu. I hope some one can help me with this regards hacky -]

How can I add images in a filemaker database? thanks _________________________ Los Angeles Digital Businesscard Printing

Is it possible to lock entry into a field based on the contents of another field? For example: I have an "expense type" field. If this field has the word "kilometers" in it I don't want users to be able to enter data in another field.

How does one initialize a global field? I originally had an auto-enter calculation which assigned a text value to a global field. But this does not appear to work (if it ever did.) I have tried a number of approaches in the database definition for the field but eventually gave up and created a script to initialize the value. Is there a better way to do it?

Something I have occasionally wondered is, is there a way for record data to affect its layout properties? As an example: in a portal that shows invoices owing, could it be set up so that any that are overdue stand out? So that the company name would go bold, or the portal row's background colour would go red? As an alternative to sorting them to go at the top or having a message appear, I mean. Anything like that? Thanks for any input!

anyone can help? Creation Date Field is (6)mm/(2)dd/(2006)yyyy and I need convert to (06)mm/(02)dd/(06)yy... any idea?? Thank!

I use the date format yyyy.mm.dd for all date fields (in all my data applications). My system date is set to that format. I've defined all my layout date fields as that format and have checked the content of my tables to ensure that dates appear as yyyy.mm.dd. Yet, whenever I run a script to produce a report (layout), with a find field and a popup menu to select a range of dates (e.g. 2005.01.01...2005.12.31 or 2004.01.01...2004.12.31, and so on) I always get the message "Value of the field my be a valid date in the range of years from 1 to 4000 and should look like 12/25/2003". And my only choices are "OK" (which gets me no where) or "Revert" which ignores my date s…

I have a db containing three tables: User account, Time Cards, and Line items. The Time cards layout contains a portal to Line items in which users enter project hours and vacation time which is then summed to a calculation field (Time cards::Total PTO Vacation Hours) in Time cards for each user (Time cards::ID). User account layout needs to calculate or sum the total vacation time (Time cards::Total PTO Vacation Hours) used for the current year (User account::PTO used this year_days) for each user (User account::ID). The tables are related only by the ID fields. So everyone sees and edits there own data only. User account:Time cards is one to many and Time cards:L…

OK, one for you calculation geniuses. I have developed a solution for a client. They want to key in dates like this: 010106 and have them change into 01/01/06 (or 1/1/2006, etc. ...any real date) Right now I am doing this with a text field I call something like DateKeyin. A calc does a conversion then a real date field grabs the result. There must be a better way. What's worse is that it punishes people who enter dates as dates. That is, I've got it smart enough to allow 01/01/06 but it won't take 1/1/06 or 1/1/2006. Here's my calc for what it's worth: If(IsEmpty(DateKeyIn);Right(0&Month(Get(CurrentDate));2)&"/"&Right(0&Day(Get…

hi all, I don't this software can done this idea of not. my idea is like below: 1=N,2=L,3=K,4=P,5=R,6=O,7=D,8=U,9=C,0=T Now I want to convert my price field to text field. How I relationship all this think? When the price field is 20.00 mean 2=L,0=T,0=T,0=T, so the text field show me LTTT any idea? hope your all understand my issue....thank for reply!

Hello - I'm trying to create a feature in my database that will allow me to: 1)insert a graphic for each record 2)make that graphic open up into an enlarged version when you click on it, in a new window without text and just a close button at the top. Like on websites that offer a 'click on picture for larger image' option. So is this something I can do in Filemaker, and if so, how? I can't figure out if it is through a portal or a button or a pop-up menu or.....argh!

OK, I have spent months and am going in a circular pattern. I need to achieve the following. Total Hours Needed should = XXX hours. The fields available to create this CALCULATED number of hours is Event Start (time). Event Length (number), Setup Time (time), Pick Up Time (time). To get total hours needed I am taking Event Start plus Event Length and assuming it can add 4 hours to 12:00PM and come up with 4:00PM, is that a safe assumption? Then how do I get the calculation to add the Pick Up Time, lets say for example 10:30 AM. My total should be 6.5 hours but I cannot get this to work. I must be an idiot. Now don't all agree at once OK?

Hi, Does anyone know if it's possible to show a preview of a PDF file in a container field? I'm using Mac X, which shows a preview (first page) in the finder information. Thanks in advance, Skip

Just diving in here, please excuse if this is an obvious mistake... I've created 3 tables; 1 event info, 1 occurance of event, 1 contacts. I have 2 portals on the event layout. One displays related occurances of the event, and one displays related contacts for the event, pulling records from the appropriate table. I have the portals set to "allow creation of record" on the corresponding table. What I want is to enter the data from these portals and have it stored in the related table. This works fine for the occurances of events, because there is only 1 event for every occurance of the event. But for contacts there can be 1 contact for many events, and also many…

Hi I am doing a domain registry list, it will shows all the expired domains. My expired dates are categorise by months using 'sub summary'. I wish to count how many domains are there in this month (it will be show at the bottom to inform the user the number of domains expiring this month). Only this month number will be shown but not every month. For my field I was thinking something like exact(expired date; month(//) count(expired date) Can someone help me with this..? Thanks a lot Kelvin

... theres a few calcs in my database that are being an absolute pain... one of them that tries to count the number of related records in a related TO will not stop returning a result of ? when another that does almost the same thing gives me a number like i want... there is more than enough room for the content to display... yet still a question mark... there is no formatting on the field... still a question mark... help pretty pretty please? Cheers, genx

Hi - Another question from a beginner: I'm trying to wrap my brain around reporting. I have a DB that I'd like to sort by RMA number. Within each RMA, there can be multiple records (and for each records, multiple related records). So...how exactly does the summary field work, anyway? Do I need one for each record I'm reporting on? Or should I create it as a global? Does it generally go in the table that you're reporting on? Thanks for any clarification... mz

can fm compare 2 picture together? if can, how can i do that in find mode?

Hi. How can I be sure that the record number (defined field) matches the record number under the flip book on the upper left hand column? Have tried for 8 hours, but no luck. Seems when I delete or duplicate, the numbers change and don't match. Tried indexing, and all the usual. Thanks! Terri

hello all. New FM user, perplexed by this problem: I have an online store which exports csv's for our online orders. The order number is in column A, and the item ordered is in, say, column D. Here's where it gets tricky: if the customer has ordered more than one item, it lists the order in multiple rows, with the same order number in the A column for every line (for every item ordered). example: A | B | C | D 23 | John | Smith | ITEM X 23 | John | Smith | ITEM Y 23 | John | Smith | ITEM Z when importing into FM to make packing slips for the outgoing orders, i get multiple pages/slips for orders that have multiple items, each slip containing one ite…

I have a problem when I hit tab after the last field in the record of any portal, it would bring me to the next line and creates an empty record when I leave. I also have a button that uses the Delete current record in the portal (each line has a button). The button does not remove the record. I end up always seeing an empty record with the del button that doesn't del the empty record. I've attached a picture of it, as soon as I enter the date for the first line, the 2nd appears and never goes away.

I have a school assessment database that has all the students and their grades and their teacher's name for one school year. How do I set it up to add previous year's assesments and previous year's teacher info, as well as future years so that a student's history of assessments can be displayed on one page? New to FileMaker and our school district does not have the funding to upgrade to version 8.0.

Hi, Can anyone give me some suggestions on setting up an input mask so that when I enter date or time I don't have to type in the / or : seperators and can just type in the numbers instead? Thanks.

.. my serial number is stored in a number field, however its actually got an element of text in it i.e. a prefix of the letter "A" ... it seems to work fine, but am i likely to face any repurcussions? cheers, genx

Hi Everyone, Does anyone know why Filemaker won't print out my gifs in the container fields? I've got a picture of a map in the background of the layout, and I'd like to have my gifs with transparency show up on top of the map. It looks perfect in browse and preview mode, but when I print it out, the container with the gif just shows up as a white block. I've tried it on Xerox printers, HP, & Brother using PCL and PostScript. Filemaker seems to print jpegs correctly... Does anybody know of a way to get these gifs printing correctly? Thanks, Chris

I was under the impression that an auto enter would re-evaluate whenever the fields it refers to are changed... (if the do not replace existing content box was unchecked..).. i have tried setting the auto enter to both a related field... aswell as a local calculation with no luck for either... the field just remains blank... any suggestions anyone? Cheers, genx

I have one more question, then I'll give it a rest for a while... I promise. I have three fields that could contain the information I am looking for, but don't want to have to search each individually... how might I create a new field to search the three? As always, advance thanks for any help! JW

A newbiee question... I need to set up a container with an image that will change depending of choice from a script/calculation... The images are logotypes for flightcompanies and it should be used for printing out electronic tickets where I want to be able to choose the flightcoompany name from a list and depending on that choice I want a corresponding logotype to be inserted in a field on a ticket template layout. There will be a numerous amount of flight companies why it doesn't feel so good to make a separate ticket template for each and one of them since there then will be hundreds of templates. Is there any easy way to do this?

Hey everybody, I'm trying to set up an autofill calculation to generate a unique ID for each records upon creation. I don't want to use FMP's serial function because it doesn't get reliably updated when you import data into your solution (I mean it doesn't get updated at all an the workaround is cumbersome). I thought I might not use FileMaker's Serial function at all and instead rely on a calculation: [color:blue]SerialIncrement(GetNthRecord ( Tâche_ID ; Get(TotalRecordCount) -1 );1) That of course works beautifully in a simple setup and it has the advantage of relying only on the data that is in the solution (assuming the "Get last record" works…

Field data I already have: 03-1A3B5C7 Field data I need: 1A3B5C7 Is there a way to strip the "03-" from data that begins specifically with "03-" (some won't have an 03- or may have 03 with no dash as part of number, which I'd want to leave alone) to get the field data I need? Any shove in the right direction would be appreciated. JW

Hi there, I am trying to summarize repetitions of content in a field ... how much times the same data occurs in the same field in the record set. Anyone can help me? X

I have a utility table where I store icons and preferences in non-global fields. For each of these non-global fields there is a global field. I use the globals so that I can use the data in the fields from any table or file without creating a relationship to the utility table. Until recently, each of the global fields was set up as an Auto-enter calc and the calculation was just the non-global field that the global was associated with. I would populate the globals by putting each of the non-global fields on a layout and running a script that looped through each field setting it to itself. That works just fine. I thought of a more efficient way of popu…

I've got a database of about 400 staff in my organisation. This runs on an Xserve/FM8 server. The database is very simple, with just contact names and a photos. I wrote the database on a Mac, and asked one of our admin staff to add the staff photos. They're stored in container fields as a reference, not added to the database. Although this works fine on the Mac, all the references are broken on Windows. I suspect that this is because the path is different. My question is: 1) Is there an easy way to fix the existing file to work on Windows? 2) If not, can I at least get the path out of the container fields somehow, so I can create a calculation field fr…

Is there a way in MF to auto advance to the next field once data has been entered. I'm am working on an inventory app and we use barcode scanners to inventory the parts on our trucks. I have 2 fields in the count table. Part number and qty. When I scan a part number the scanner includes a to advance to the qty field. I want the qty field to default to 1 and move to the next part number field (next record). This way we can just go thru the truck scanning everything and not have to worry about stopping and entering a qty. I can then run a summary report for the qty of each part. Thanks Jason

I've set up a database for calculating a student's grade for a class. What I want to be able to do is to calculate the student's average for a date range. How do I do this?

Hello all: I don't know if this is possible but I have a text box on layout with a scroll bar. The field is set to be non-enterable because its strictly for display purposes ONLY. I would, however if possible, like to allow the user to scroll and see all the contents of the field BUT without the ability to modify it. Any way to do this? Dom

I've set up a global container field on the Mac, into which I've imported a JPEG. I did this by clicking into the field in Browse mode and choosing Insert/Picture... then navigating to the file. I made sure that "Store only a reference" was turned off. This works fine on Macs on the network, but on Windows machines the global field contains the error "The file cannot be found: ", instead of rendering the JPEG as I expected. What's happening? It looks as if it's a problem due to the path changing on Windows. But since I inserted the photo directly into FileMaker (rather than storing as a reference) it should already be stored in the database itself, and therefore…

Hi everyone. As a FM newbie, I have a few questions related to a project I'm working on. Working at a camera rental house, I am making a product register. The challenge is how to... A rental item is in reality several unike products put together to one "master", giving me the product name. What I don't manage to figure out, is how to register all these unike products in a table, and link them up to a master product name. In earlier access databases, I have solved this matter wit one table for each master product. Hopefully I can solve this easier in FM.. Any advices here? What is the common opinion on using value lists, compared to related tables for loo…

I would like to auto-enter 30 to 40 lines of data into a field. This data would include field definitions from the same file (table) that the field is located in. I do not know how to do this or if it is possible. Thanks in advance for any thoughts.........Ray

I need to have a field automatically fill in a date that is 3 months past the date entered into another field. I have a calculation that does this for week days, making the date appear to be 4 days ahead of the date entered in another field (or more if the weekend gets in the way as it is not included. how do I modify the calculation to do this? Case( DayofWeek(Enquiry Date + 5) = 1, Enquiry Date + 5 + 1, DayofWeek(Enquiry Date + 5) = 7, Enquiry Date + 5 + 2, Enquiry Date + 5) Thanks for any help Craig

In v6 of FMP I was able to use: external(Web-toHTML; "field") or something very similar to create a text calculation field that would convert another text field to HTML text on the fly (converting things like ™ into ® or whatever the ascii code is). I believe this was because the web conversion for FMP was all external. Now that FMP 7 is more advanced and has more web publishing built-in (I think), I can't find this external command any more. Is there a way to do a similar calculation in v7?

Hi. I'm new to the forum, hi! I searched through and couldn't find an answer to the following question, so any help would be greatly appreciated (I've just finished reading the O'Reily book, and still couldn't figure this out). I have a table called Employees. It uses fields from another table called Companies to enter their address. This is useful for when we need to mail multiple employees from the same company - we don't need to type there address in over and over. However some employees have different addresses, say an employee that works from home. I have created another set of fields to enter in their addresses, but I can not figure out a way to make a b…

Q1: How to validate the MAC Address in the format: ####:##:##:##:## Q2: How to convert the wrong format to the right format. For example, convert from ##-##-##-##-##-## to ##:##:##:##:##:## I have search the web, and there is function look like : (^([0-9a-fA-F][0-9a-fA-F]){5}([0-9a-fA-F][0-9a-fA-F])). Can FM Pro7 do such function?

I'm still learning the FM calculation syntax...it just hasn't clicked yet. I have a simple problem that needs a simple solution (to anyone but me). I have a calculation field in one table that needs to return a total COUNT of records from another related table If the records in the other table are = "enter text here." I've been messing around with a few different functions, but I can't get it right. Help is much appreciated!

We are using FM 6. Is it possible to put a PDF form in FileMaker, instead of just showing an icon? Thanks

Hey all. I'm having a problem figuring out how to calculate a percentage. Here's the senario. I have a database that I am doing summary based on Vendor and I need to figure out what percentage the Vendor total is of the grand total. Can anyone offer some advise on how to do this? Thanks. Sarah

I've looked at many posts regarding the use of [color:red]GetAsText to return the path of files stored in a container field, but I've yet to see one that explains my problem. We have a database hosted on Server 7 that has Excel spreadsheets inserted as an object from file (link, display as icon) in a container field. The Excel files were initially stored locally but, of course, we want to move them to a server where everyone can access them. I want to use GetAsText to return the file name, then use another calculation to generate the new path to the file on the server. However, when I created a field using GetAsText (mycontainer), Filemaker 8 returns only "?".…

My problem is I have data imported in from an xml feed which is formatted for ex. 20060118T103737 I need to convert this into a mm/dd/yyyy format and drop off the data from the "T" over to the right which is the time of the posting. Thanks for any help!

Just getting to grips with FM8 and then I come accross this wee little bug(gger!) >Define Database> Fields I am unable to locate the Copy/Paste buttons! On the VTC traing CD it explians how you can copy and paste Fields but the buttons are hidden. The VTC trainging CD used Mac and I use XP as my platform and I have Pro and they use Pro Advanced. Please could someone shed some light on the issue. Many thanks in advance, VD

hi everyone, I inherited a database that has a foreign key field with a pop up value list. the value list is set to "use values from field", "use values from first field (primary key of the related file), "Also display values from second field" (description of item), "Include all values", "Show values only from second field", the pop up list shows only the description of the item, and the field itself only displays the description. I tried to re create this in another database but can only get the key field to display. It almost looks like there are two fields there. but they are somehow connected. Does that make any sense and can someone tell me how I can do this? …

Hi - This is a question from a rank amateur. I'm trying to implement a script that, among other things, performs a find request. The find criteria are based upon fields in a record from another table. The problem I'm having is that once I execute the perform find step, I seem to lose the ability to reference the record from the previous table. I base this assertion on the results of inserting a custom dialog to display the contents, before and after the search. After the search, the prior table's fields come up empty. I hope I'm explaining this clearly; I don't know how else to put it. But the question seems to be: how to go about assigning field value…

Hi This has cropped up again and I couldn't get it to work before. Whilst it is not of any real importance I would appreciate it if someone could point out what I am doing wrong. I have a calc field 'margin' that calculates the margin as a percentage. When I display this field I would like it to have a trailing '%' mark. Let's assume this field contains 55.347654321 (which to me is fifty five point three four percent). When I go to format number for the field and set it to display as decimal to 2 places with the percentage notation I get 5534.76 % If I set it to display as decimal to 0 places It displays as 5534 %. How do I get it to display…

I newby find it difficult to get a value list to work the way I want it to. I've attached a sample file. What I need is the value list to update the address when I select the company name from the value list. I'm sure it's the relationships, but I need someone who understands this much better than I Thanks John valuelist.zip

Hello guys, sorry for this post but my search failed. maybe my bad english. In earlier versions of FileMaker it was possible to paste images not into the database. You was able to link to them. My database is growing and growing, and I cant finde the old declaration of the container field for the behaviour of it. I don't want to paste the pictures directly into my database I want to see them but the old way over links. Can anybody tell me where do they hide this funktion in version 8 of FileMaker? Thanks for any answeres.

Hello, I have a probabaly simple question. On a certain value in one field, I want to denie data input for another field. Example I have internal and external customers. For internal Customers , there should be no data in another address field, for external customers, you can put an address in another field . Anyone knows a simple solution for this Many thanks in advance

I am importing data from a date field formatted as March 9, 2006. I can strip out the month and year using the middle and right function, but cannot extract the day of the month due to the varying length of the month names and lack of leading zeros. Can anyone help? Thanks

I have a database in a single table with records that amongst other things contain a number field and a text field which are displayed on a layout. I have set up a second layout with a subsummary part containing a summary field for the total of number field values when sorted by the text field. The second layout also has a trailing grand summary part with the same summary field totalling the number field values. The second layout displays in preview mode. The second layout does not display the actual records. The result is that I get what I intended i.e. a series of subsummaries for each number value sorted by the text value and a grand total of these at the end. Wha…

Hello, I have been trying to do something, but have not been able to get it to do what I want... Hope you understand this... I know the system will let me type a line of text onto a page to be viewed on-screen or printed... that looks someting like this: <> - and the data that is located in that field will appear... What I want to do, is to be able to create a Field, and be able to type data into the field, and to be able to include <> within the rest of the text, so that when the Field is viewed it will show what was typed, and it will show the Data in that Field too... but it does not seem to be able to do this. The data will be ente…

Hi all, i have a problem... i want to validate a field to have a unique value, but i want to have two values that can be repeat. For example a field CATALOGID, must be unique but if i put teh value "NON CATALOGED", I want to pass the unique value validation. Anyone can help?? Thanks

I have a drop down menu that is displaying results from a related record & table. What I'm trying to figure out is, based on the item chosen in the drop down menu, how do I calculate other related data into the current table. Ex: I've got 2 files: Address & Bank From my Address file, my pull down menu displays a list of that client's Bank accounts from the Bank table. When the Bank account is chosen, I want it to calculate that bank account's routing number into a field I've designated in the Address File. I'm pretty sure that the field I want to be automated needs to be a calculation field (not a lookup), I'm just not savy enough w/ the calculat…

Okay, I think I've finally posted this in right the place... maybe? I'm not sure I've described the subject right... but what I'd like to do is: Set up a database field to retain live data, received via a relationship database (that I have no control over), as static data that won't go away when the live data is deleted from the relationship database. If possible I'd like to set this up to happen based on project status - i.e., when project category = archived, fill static field. It would, of course, be nice to set this up to work without manually tending to it... Possible? Or am I crazy?

I read a lot of posts about this, but I still really am not sure how to tackle this. I am hoping someone can provide an explanation using my scenario, I am struggling with getting a grasp on this. I have a start date of a project, and the expected amount of days it will take to complete. I need to calculate the end date of the project,excluding weekends. I read examples with scripts that made some sense, but i need to make this a calculation. I saw a lot that would tell me how many weekdays are in between two dates, but nothing real clear for situations where you did not have an end date. thanks!

Is there any way that I can import two graphics related to my records into two containers, and "combine" them into one graphic, and then export that one graphic to a third file?