Layouts

Bought Filemaker 9 to try instant web publishing. I figured I could create my own Web 2.0 application for receipts and expenses. I have occasionally gotten the iPhone to work using WiFi, but never using AT&T. Is there something about Filemaker that prevents access via a slow connection? Or is it something else.

I have a .fp5 database that sorts on a date field. When records are sorted, any record with a null value in the date field is located at the end of the sort order. When I converted to .fp7 (using FM 8.5) the sort order is correct, but the records containing the fields with a null value are located at the start of the record set. How can I fix this? Thanks in advance, Aaron

I am creating a letter in FMP using text, graphics and merge fields. However the line spacing is not consistent. In layout mode a single line may result in 2 lines in preview once the data is populated in the merge field. If the text expands to more than one line the spacing is larger between the last line then the previous. Also, one of the merge fields is italized. How do I get the line spacing to be consistent? PS: The inconsistent line space is not consistent. It appears to occur when the first word in the line is italized.

Forgive me if this seems stupid, I have managed to avoid the joys of MS Windows thus far in my life but a recent system change means I am now rubbing shoulders with the vulgar populous! I have a little small windowed Filemaker DB, a kind of specialist calculator (really it is a one record 'app') that I provide to my Mac users. For them it pops open as a nice little single window they can drag about and put where ever they want on their screens while they work, dipping into it like you would with a real calculator on a real desktop. I am now providing it to some Windows users and instead of the elegance of the single window, FM opens a sort of 'desktop on the d…

I have a number of different FM databases with portals. On some if you tab to the end of the line of a portal it will tab to the next line allowing you to create a new record in the portal. On others it ALWAYS tabs out of the portal at the end of the line. I want to always tab to the next line of the portal. How do I control this? Thanks.

I'm on the Demo, trying to decide if FM 9 can meet my needs. My data in several fields varies widely in character length - I don't want to see only 1 line of my lengthier entries in Preview/Browse/Print, and I don't want to print huge amounts of empty space if I set the layout for the longest entry. I can't use Excel, in which the record height is individually adjustable, because of the 255 character/cell limit. Pre-Sales couldn't help me after 1 1/2 hours, and suggested that maybe someone here could come up with a solution. He didn't specify which forum, so if I should ask somewhere else, please let me know. I would greatly appreciate any creative input …

I have a field for a phone number that I would like to be formatted for easy viewing. ie; (111) 222-3333 without actually using those characters in the field as this field needs have JUST the digits. The formatting would be for display purposes only while the data is JUST the ten digit phone number. Any ideas? TIA, Steve

Hi sorry if I'm in the wrong place. I have been using my database for years and now made the jump to filemaker pro 9. I am 75% done with the database for my martial arts school but I ran into two snags. 1- I would like to have a customizable i.d number that when I create a new account automatically offers the last number plus one. I tried creating a i.d number field with a +1 formula value from the last visited record but that flopped. 2- I would like to have a layout/report that totals a monthly payment amount field. I set the field to 'numbers' but I can't seem to get the fields totaled (or grand totaled) I know these are pretty simple things but the lear…

Hello, i am very new to FileMaker and this will be my first database. I am creating a maintenance Database for our company to organise maintenance reports. I already have a complete solution in MS Access. i found filemaker and loved the idea of being to be able to do data entry over the intranet. Now onto my situation. it seems my background in access had led me in the wrong direction. i currently have two tables, :Equipment -EquipmentID -EquipmentTypeID -EquipmentName ::EquipmentType -TypeID -TypeName They are linked on Type Fields ie CM11 is a Continuous Miner In access i had a combobox that would drop down and autocomplete …

I have a regular layout and button that opens a pop-up window which opens a quick data enter layout. I would like to lock that new window so that the user cannot go back to the original layout without closing the pop-up first. Any thoughts, tips and how-to's appreciated. Thank you.,

Hi guys, I'm trying to build a report viewed in preview mode that has a table of quote items on it with a few subsummaries and whatnot. It's working fine so far, but I want to put vertical lines to separate columns. In the body part I'm using a large text field that spans about 10 lines for the main description field and have the sliding options set so that this slides up when there is less text than the 10 lines (almost always). I've tried drawing vertical lines in the body part but the problem I'm having is that they do not shrink along with the text field, which is kind of expected, but that's really what I'm trying to achieve. Anybody got any ideas how to get aro…

Is there an easy (or doable) way to allow users to create report layouts, but actually never use Layout mode? The users will probably create many one time reports and the layout mode is not an option. Kind of like a custom merge letter, but for reports. thanks!

The default font is Helvetica Condensed but when I key in “option-hyphen” to get an en-dash, the text changes to Lucida Grande. It only seems to happen if I’m typing fast as well! Weird and annoying. Any ideas?

I am currently working on a database that will store the various department’s annual reports (or end of year reports). Some of the text fields will be quite big and some will be a paragraph at most. But the size will vary by department and there's really no way of predicting what it will be. I am having issues printing. I would like to print the reports and have the fields auto-size on the paper. I have checked “Set Sliding/Printing”, but it’s really not doing what I think it should. Any help will be appreciated. Thanks in advance ann_BLank_Text_issue.fp7.zip

So far I have always used summary reports where sub groups are added together. In my current situation I need to get partial results ie subtract a subgroup from the preceding subgroup like this: 5 3 6 2 16 ---> subtotal sg1 2 2 3 7 ---> subtotal sg2 9 ---> Net1 (sg1 – sg2) .... .... 5 ---> subtotal sg3 4 ---> Net2 (Net1 – sg3) ..... etc... I can’t figure out how to do this in a columnar report with subsummaries.

Hello to all, I'm finishing the design of a FM database that holds hotels, prices and services. One of the fields has to hold an image of the hotel. As there are hundreds of hotels to be feeded into the database, I've created a button to insert an image into the field. It worked a few days ago and doesn't anymore. I tried several solutions but must be missing something. Even when I transform a container field into a button with the "insert picture" function, it doesn't work either. I know this is a very basic question, and I'm sorry about it, but it gets me very angry as I've managed to put together the whole db with currency calculations, scripts and am stuck with…

Is there a way to show the record number within a sub summary? I have created a report with this type of layout: Type A Company C, Avg: 5 Company B, Avg: 4.7 Company D, Avg: 3.2 Type B Company A, Avg 4.9 Company E, Avg 2.4 Type C ... ... The Type and Company are both sub summaries when sorted by Type and Company, respectively. I do not have a body; I wasn't interested in displaying each individual record, but they do drive the calculation for the Avg for each company. That report displays exactly how I wanted it, but now I would like to add a Company's "rank" by enumerating what order they show up inside each Type. So, I …

I would like to create a layout which displays a little like an excel spreadsheet. However to show a list of records (Agencies TO) vertically down the left side of the page (List View) with records of Client Names along the top. Where an Agency row meets a client Column for whom they have worked (WorkDone TO), the Invoice total appears. See attached image. - What is the best way to create such a layout?

I am recreating a database to replace a series of excel spreadsheets. The visual views available in excel that we use numerous times to look at our tables is to have customer’s listed vertically, and jobs listed horizontally, and then show their sales numbers listed in the grid area. We can have up to 30 or so jobs in a given layout, and excel allows you to split the screen to “freeze” the customers column while you scroll horizontally and view the numerous jobs. Does any one know how to recreate this freeze ability in filemaker? If it’s not possible, does anyone have any good examples or solutions where you can show a customer list vertically, and then list hor…

I just read that title headers cannot be reduced in size. Does anyone have a suggestion on how to save space on an invoice where I need optional comments above the line items area (above the subsummary)? Right now I have address and contact info, two optional remarks fields, and then column labels (like Qty, Item, Price) in the Title header (all of which I tried to set as sliding up and reducing the size of the enclosing part). I get all this unwanted space when the comments are empty. Any suggestions? I just can't think of a way to make this document look the way the client wants it without that sliding and reducing capability. pz

Hi, I want to be able to count records related to my parent table based on the field's value. The parent table is called 'group' while the related table is called 'individual'. The 'individual' table has a field called 'survey' which has integer values from 1 to 5. I want to create a summary field in the 'group' table which will count based on the value of the said field. For example, I want the summary field to count the number of 3's in the related field. I tried the 'count' function but this counts regardless of the value in the field. Can someone please help? What's a good way to make this work? : Thanks in advance! :)

Hello, In the system I am creating I need the user the user to be able to see the history of information while creating new data. For example, for a given event, he has to update the probability and the impact each year. so I need him to be able to see the previous info in the new form and create new records. Previously the company was using a word table with last year's info and current info.I searched all the documentation I have for filemaker but can't find anything about this. Does anyone have any suggestions? Thanks in advance

Good Morning, I have 2 questions, the first is more esoteric. 1. I am almost certain question 2 has been asked and answered on this forum, but I can't find it by searching. If someone reads question 2 will you please give me a suggestion for what is the proper way to search the archive(s)for these types of questions? 2. Main Question: Is it possible to change the background fill color of a field based on the result of a calclulation? basically: If Point total = 0 to 25 background color = white 26 to 50 background color = red 51 to 100 background color = Blue etc. Any help would be greatly appreciated. Thanks, Steve

This comes up infrequently enough that I can't nail down why it's happening and often enough to be annoying. I find that sometimes, when I'm making text on a layout, either by typing directly onto the layout or using the text tool, the text gets cut off by the box. If I'm typing "Address" then click out onto a blank section of the layout, only "Addre" shows up and I have to manually drag the box larger. I haven't been able to find a pattern, it happened in 8.5A and is happening now in 9A. It happens occassionally, like a couple times a week in different files and different layouts. Can anyone shed any light on this?

Here is my setup. I have a set of radio buttons with Case A, Case B, and Case C. If Case A is selected, I would like another set of radio buttons to become editable. If Case B, I would like a text field to become editable. Otherwise, the second set of radio buttons and text field should not be able to be edited, and preferably grayed out if possible. What's the best way to do this? Thanks!

I have a field price_per_pound. (total_revenue) divided by (total_weight) this gives me the price per pound. However in a subsummary preview it does nor calculate correctly. I have 3 other totals that work fine. Any ideas? I used GetSummary and it seems to work right. Thanks to all that looked at this post.

Hi, is it possible to shrink the size of the footer by use of the sliding/printing function ('also reduce the size of the enclosing part') I can't get it to work for the footer. any ideas? TIA

Hi! I would like to hear advices or recommendations about using global fields for the icons of a solution, instead of just pasting them in each layout. The database is intended also to be share in a network. The idea is to change an icon in only one place, not in all around the database, and also to keep it in good size. Tks.

Greetings. I have a vlaue list that users contribute to, and would like to see this list automatically sorted alpahabetically - how can I do this please? Greg

Hi there, I am having trouble with a field highlighting when it gains focus. I have a layout with a black background and white radios (easier to see at on-site events) and when the radios gain focus, they become highlighted white. When this happens, you cannot see any of the tags or radio buttons. Does anyone know how to turn off highlighting or, at least, change its color? Thanks, PerryL7

Hi. Ive found no mention of it so thought I'd ask... Is it possible to have Flash plugins or the like that would add greater graphic capabilities to an FmPro application - such as an opening screen - even animated GIFs? Greg

Seems like the "focus" is lost on mouseup, and so I can't grab the button's object name. Hopefully, I'm missing something obvious...

FM 8.5 adv. I have a calculation GetSummary field in a subsummary part. I need to total it in the grand subummary part. I've tried summary and getsummary calculations but nothing works. They don't total properly . Is there any way I can do this?

Hi, I want the user to be able to select records from a table through a drop down menu.So I have created the recrds in the table and created the drop down menu that shows the items but the problem is that when I select the item it creates a new entry of it. for exemple if I select "client", it creates a new entry with client as a type and a new serial number. Does anyone have an idea about what makes this happen? Thanks in advance

Hi: I've inherited a rather cumbersome database with one table, 1400 fields, and hundreds of layouts. I'm trying to eliminate unused fields. I'm familiar with the Functions: FieldNames and LayoutNames. Is there a way to get Filemaker to tell me every layout a particular field is used in? Thanks

I'm trying to create a table of contents page for my database. There is a print in colums option in Layout setup that does something very similar to what I want, but I need it in rows, not colums. Is there a way to do it instead? This seems pretty common sense, so I'm sure it's there, but can't find it in the manual. I'm trying to have each record take up a row, not a column.

HI, Running Server 8. I'm on a Mac 10.4.10 Just finished a letter layout with 9.5 adv - looks fine and prints fine. But the same layout on another Mac running FM8 has huge line spacing like an inch and a half between lines, but the "paragraph" settings are the same - 1.00 lines. Font is Optima an is on both machines... Any Ideas??? Thx

:bang: I have a database that manages all my clients and current projects. I would like to create one layout that holds on navigation that I could then include in each layout. This way if add a module or remove one the navigation would automatically be updated to all layouts and it would not require me to edit all 100+ layouts. Is this possible and if it is how ?

Is it possible to set up a list type layout for printing, where a "notes" field will "expand" to accommodate the printing of the field's entire contents? Other records without contents in the "notes" field would still print on a single line. I believe that is is a feature found in Excel. Can it be done in FileMaker? Thanks, Dudley

I didn't see an area dealing with attributes so hopefully this is the right place. I've placed an auto-enter serial no. attribute in the header of a report layout. With each new occurrence of the report a new serial appears in the header but when I attempt to print this auto enter attribute does not print. The 'do not print this element' is not clicked in the format menu so I know that's not the problem. 'print/sliding' is also not clicked just in case there might be some issue with that. Am I breaking some basic DB rule by having an auto enter in the header? The auto enter criteria creates a new record with each report I pull up. This is a batch report th…

Hello I am stuck on finding a way to highlight changes. I have a database that changes often and every once and a while I need to write out a report detailing the changes. What I have currently been doing is just changing the text color on the fly so that it is red. It is extreamly time consuming but better than having to compare two whole copies of a printed database. I have been racking my brain to try and find a way so that filemaker can do it automatically. I want everything that I change to turn red and then when I hit a button everything returns to it's original color. I tried an Idea with duplicate fields for each record/field that kept track…

I was wondering if there was a way to organize layouts into folders or seperate lists. I am starting to built up databases with way too many layouts mostly for sending letters out to clients and it is becoming unorganized. Also, I was wondering if there is a easy way to copy layouts from one database to another. Right now I only have the client version of filemaker. Do I need to purchase the advanced version? Thanks for the help, Kaduby

I have two layouts, and I would like to be able to combine them into another layout that will list information from both. In one of the tables, teachers are able to evaulated the student's attitudes about various topics, in another table it holds the grading information, for each level, and the individual classes. since each teacher is allowed to input their opinion of the student's attitudes I have created a summary field, which takes the average of the opinions for each level. The layout shows the class, the teacher, and their scores and at the bottom the average scores for that level. On the other layout it shows the overall grade for the level, the in…

I am required to use a Word file for our estimates. I am trying to create a layout so similar (in FM) that my boss will let me use my database verus word to write the estimates. The problem is we have a lits of possible iproductes in a list in the word file and most are not used in every quote.. is there anyway to create a field with a large amount of data with the ability to edit it on the fly? look at this word file - it will help with my question

Hi, After the creation of my database, I have figured out that I need an additional field in one of the tables which I did. but the problem is that the new field does not show up in the layout of that table and new records are not created for that field. Any suggestions? Thank you for your help

Hi. I'm new to this forum and a novice to Filemaker. I have build a few simple database solutions but now am trying to expand my skills by creating a Knowledgebase, to be used in a business environment. First off, have any of you ever developed or seen a knowledgebase created with FileMaker? I have searched the web, looking for an instance where FileMaker was used to create a knowledgebase, and hopefully look at a screen shot or two, but I can't seem to find any examples. Secondly, I have already created the input form where the user can input a question or statement, and the same user, or others via Instant Web Publishing, can contribute to the answer or exp…

I am trying to generate a Dynamic layout based on the data people have entered, the layout is a report where sections will be added or removed based on what info they entered. I can parse the data fine I was wondering if anyone knew a good way to add or remove fields from a layout?

I made some form letters in different layouts with merge fields. They are great for printing. But I would like to email them, is there a way to do this? Thanks

Hi, I've done a database which contains mailing adresse with streets that belongs to city. Here's the schema: Mail (pkMailID, fkStreetID) Street (pkStreetID, name, type, direction, fkCityID) City (pkCityID, name) The question is how can I select the right street in the good city? Let say the user enter the street and after the city. How can I make fkStreetID be entered automatically?

I have recently taken on a project which has introduced me to FileMaker, though there is no one with much experience on the program so the minimal knowledge I do have has come from the User's Guide, the Help section in the program itself, playing around with the program itself, and reading old topics in this forum. The User's Guide is not much help as I am not terribly computer savvy. At present, I am trying to create a layout/table (not sure which word is accurate here) in my database for donations. On this layout/table I need the top section to have information like the Purveyor, Donating Organization, etc, then the bottom to have a table (not in the FileMaker sen…

I have this report layout built for one of the Doctor's I work for but I am stuck. Most of the report fields are averages but for margin% field he wants a percentage from margin field. The margin field data is either a 0 or a 1. I thought this would be simple enough. I want a total of all the records in the database. Then add up all the 1's in the margin field. Divide the record count by total of 1's in the margin field to populate the margin% field. This sounds simple but I rarely have to do a calc of this nature and it is making me crazy. Am I making this harder than it should be? Any advice appreciated. I am still trudging through the fm…

I wonder if this is possible: I have a image db solution that is used on Mac and PC. Management want users to login automatically. Is it possible to send the user to a Mac or PC specific layout based on the system platform. Or hide layouts based on which platform the db is on. I know how to do this with specific accounts and have the user login.

Hello... I've recently been asked to create an employee database which includes each user, their computer models and service numbers, windows version, etc., and a notes field. I figured everything out, except how to create a notes field (or Table) that includes the date is was created. I would need to be able to add a new notes section for each record periodically, and would really like the date to be stored also. These notes would need to be viewable on the main window that contains all the other user info. It would be preferrable if the new notes would appear at the top and "push" the old ones down... Am I out of luck, or is this possible....It's similar …

Good morning. When it comes to Filemaker, I am not even a beginer, I am for the lack of a better word, totally ignorant. I just registered at this forum and when you register you have to answer certain questions as to what version you use etc. Since there was no option for "none", I put the lowest version. Please disregard that. I don't even have Filemaker. Never did. The purpose of my thread is two folds: 1-How does Filemaker compare with alpha? 2-I am a long time user of alpha. I have recently designed a development module that solves many of the most daunting problems with alpha. I had a feeling that the same problems are common to both programs. I was…

Hi, I'm creating an invoice system for an entertainment agency based on relationship tables and databases. I have a database for clients, performers and events. Within events, I have two tables. One for the event, and another for the invoice. What I want to do is for an invoice to be automatically generated when certain criteria are met. I think this may be a portal, but I want to include information from another database that isn't in the event form. I hope that wasn't too confusing Thanks for your help Hayden

Yup, another newbie! I'm running a solution for my police department containing over 30,000 records. The solution has roughly 20 tables and is used for everything from keeping arrest records and traffic ticket information to reports and general complaint information. My problem is this; I have a layout which has around 50 summary fiels which keep a running summary of statistical information. When going to this layout, it takes a rather long time to summarize and dispaly the results. It wasn't bad when there weren't so many records, but it's taking more and more time as the number of records increase. Is there a more streamline way of using summary fields…

Hi, I'm not sure if I am posting in the right place but I'm very new in the form so forgive me if I do a mistake. Tha database I'm planning is a relational database and I would like to create a form to enter that data in different tables for creation and updates. Is it possible to have this with filemaker 8.5?

I've got a Filemaker solution that I'm working on and I've run into some difficulty. I'm trying to create a timetable matrix report for a school information system - but it seems pretty difficult to do what I want. The report will have columns representing each term, which are managed by adding/removing records in the tblTerm table. The rows in each table are the individual periods that appear in the schedule, these are managed in the tblPeriod table. The information that needs to be displayed in the rows/columns comes from tblCourseEnrolment, and contains information such as CourseCodes, CourseNames, CourseTeacher, CourseRoom, CourseTerm, etc. The t…

In a database that I am currently developing, I have text boxes that should be able to grow as the user types.... but I want the contents to grow and the field provide a scroll bar. Currently the field is growing and covering up the lower fields. I have attached a screenshot to show the issue. Thanks in advance (when I type in this box.... at a certain point a scroll bar comes up and the box doesn't grow, but I can scroll to type more and more and more).... that is what I want to do in Filemaker. Any advice will be greatly appreciated

I am sure this has been covered, however I am working in FileMaker 5.5 and I sometimes run into trouble using FileMaker 8 calculations. I have two date fields "Target Launch Date" and "Launch Date". The Target Launch Date must be less than the Launch Date. If the Launch Date is greater than the Target Launch Date I need for the field or Text to turn red. Any suggestions? Thanks for your help.

Hi! I have a newbie question. I have a long layout that goes across multiple pages. I want to set up a button so that on page one, I can automatically be taken to the start of page 3, without scrolling. How do I do this? I've tried several options, but can't figure it out. Thanks!

How can I modify the properties of a textbox, input field, etc using a script? I'm trying to do 2 things: Having my print script delete the header labels for some text fields if the fields are empty, and having a button disable input into certain fields. For the second one, I know you can do this with behavior property, but I can't find this in the script menu. To get rid of the header labels, the most elegant solution would be something like "If IsEmpty(table::field), delete label1". Alternatively, it could change the text value of label 1 to "", or set the color to white. Is there a way to do any of these things? edit: I can't even find unique identification f…

Is there a way to change the setting for layouts "save record changes automatically" globally or do I have to change each layout seperately?

I am trying to get the colors in my FM layout to match certain CMYK colors. Everytime I enter the CMYK colors, FM changes them significantly. I know FM runs of RGB but does anyone know of a way around this besides randomly guessing colors - I need them to be very close to exact.

Is there a way to insert tables or images in a text field? Maybe something that involves importing document files (PDF, Word etc) into a text field? I know it's possible since I've seen a (secured) filemaker file that has this. Thanks.

FM 6 Database running over Macs of all ages -eMacs, iMacs (anglepoise, standard screen and widescreen models), G4 towers with 17, 19 and 24 inch screens. Current design of database layout seems based on 12" screen in use when dbase was written. I am not a programmer, but maintaining the database/ work record has fallen to me. Is there an elegant (and easy) way of maximising the layout area that will optimise/maximise the layout for these various screensizes? Currently the onscreen size is only a portion of the screen real estate available. Dragging the bottom right corner of layout when in BROWSE reveals part of next record. Can this be avoided b…

I was not able to find hot to do this so any pointers are appreciated. I have about 800 records. Among the fields I have Item_Name, Picture and Cost. I would like to make a catalog layout where the records would show up horizontally one next to each other rather then vertically. I can get them to show like: Item_Name, Cost Picture Item_Name, Cost Picture Item_Name, Cost Picture Basically a regular list layout. I would like to show them as: Picture Item_Name Picture Item_Name Cost Cost constrained to page width for printing purposes. Thank you.,

I have a problem with the format of text that is copied from the internet and pasted into a field. In the table, I have the field set to a particular font and font size. When I manually type in the data the format is fine. However, I get a lot of the information I need from the internet. When I copy and paste the text from the internet into the field the formatting from the internet overrides the settings on the field. Is there a way to force the field to change the formatting to specific settings after pasting the data in? Thanks for any help you can provide.

Hello, I need to create a product sheet / entry form that lists every product from a products table as well as fields that display and allow the user to enter order values for a particular customer. I have a standard 3-table relationship schema of: Customer (IDCust_pk) Customer_Orders (IDCust_fk, IDProd_fk) Product (IDProd_pk) On the customer layout, I can get a portal to display just the products that the customer currently has orders for. What I want to show is a layout where EVERY product is listed, customer information, and data fields for what the current orders are by product. Any help would be very much appreciated. -Brian

Aside from doing a screen dump, how can one print a layout--with the header, footer, and all design features--from within FileMaker? Ordinary printing leaves out the header, footer, and design features (like tabs). Ordinarily I wouldn't need these to print with a record, but I do for design documentation.

Hi. I'm relatively new to Filemaker and have been trying to figure out how to get rid of the main window scoll bar when not in use. At the moment the scroll bar is always greyed out when not needed. This interferes with the look of the window if I place a grey fill graphic at the top to extend the title bar down to form the background of a menu bar. The right hand side can't cover the scroll bar so the window doesn't look like a "real" application. Because of this I've been looking at using Runrev Revolution as a front end to a database. It allows objects to be automatically resizable (now available in FM9 according to the website) and complete control of the windows. …

Background: I have a survey database for our company. It surveys employees about their training needs. We ask employees to rank how often they use a particular software and how important training would be. I have created summary fields that give me the Averages of importance. Now I want to display the data in a report. I have a sub-summary section when sorted by Training Program name that displays the Avg of Importance for each training program. The problem: I need a field that is calculated based on the Importance average Summary Field. If the average is between 4 and 6 display "Important." If the Average is between 6 and 10 display "Very important." …

Hi there, I am very new to FileMaker, but I am quite adept at other databases (Access and a variety of legal dbs). We are using FileMaker cross-platform - XP and Mac. When I view the Mac terminal I cannot see the contents of any field until I click into that field. I don't know if this is a setting on the users part or a Mac issue (I am a PC user myself.). Any advice would be great! Much thanks, Ky

Hi, This is my first official post. I was redirected here from Fm tech support. Here is my situation: I am using FMV6.0, Epson LQ-590 Impact Printer, WinXPPro. Here at the office we are required to print these government certificates on an impact printer. These certificates are numbered, preprinted and a bizarre size. Now I am able to print the first page no problem. The problem starts with the line of the second page, it starts too low. All these certificates are on one continuous roll, and we are suppossed to print them out multiples at a time and tear off once done. In print setup, I change the page from "Letter" to "C5" and it does line up a l…

I'm creating a database consisting of a listing of researchers, their contact information, what institution they are affiliated with and their research skills/interests. I'm confused about a few basic things: 1. Do I need separate tables for these 3 items? (contact, institution, research skills/interests? 2. This is a public db web published. I want people to have a main page publicly accessible where a member can do a search for another researcher based on location, skills or interests. How do I do this correctly? Portals/reports/or..? What I have done so far is set up a "main" layout with fields and a search button which runs a script going into find mode,…

I have a very simple script to duplicate a record, and add ".1" to a certain field. Duplicate Record/Request Set Field [Main table2::Transaction $; Main table2::Transaction #+".1" It basically works, (and if I duplicate a duplicated script, it changes the .1 to .2 which is useful, but odd it does that without me telling it to) but the field it modifies usually has a hypen, which is deleted in the duplicate record field. The original record will show "2003-25", while the duplicate record will show "200325.1". Why is it deleting the hypens, and how do I prevent this?

Hi all, I come from an MS access background and now am using FM 8 in my current employment and can't pull something together like I have done previously. I need to track licenses for products and the users who have the license. So I need in the top part of a screen product information with serial numbers, purchase order info, number of seats on the license etc etc (in a table view). In the lower section of the form I want to have another table view but to contain all the user information relating to the locations of the licenses. So if I click on a particular Photoshop line in the top, then all the users who have that license allocated to them (for volume licenses…

This is kind of like a philosophical question more than technical. When I was less experienced I created a layout attached to one of the tables in my database for the purpose of excuting scripts that produce reports from other tables in the database. Over the years it has become massive with a lot of buttons for various reports and different output formats. Since those days I've learned to create function scripts so that the user can specify the output type upfront. That has reduced the number of button but the number of reports required continues to grow. The question is: Is it still a practical navigational Interface technique for producing all these reports o…

I have the following Fields that I am trying to get a running total from, when I do it gives me a number but it is wrong. DH_TRANS_DATE -> DATE DH_CODE -> Transaction Type (NUMBER) SumOfDH_TOTAL -> Transaction Total (NUMBER) CODES_DH_TOTAL -> CALCULATION (10)(No of Rep) Case(Get(CalculationRepetitionNumber)=(Extend(FM_CODE)); Extend(SumOfDH_TOTAL)) CODES_TOTALS -> SUMMARY (10)(No of Rep) =Total of CODES_DH_TOTAL CODES_TOTALS_BY_DATE -> CALCULATION (10)(No of Rep) GetSummary(CODES_TOTALS; DH_TRANS_DATE) CASH_BOOK -> CALCULATION -(GetRepetition(CODES_TOTALS_BY_DATE;3)-GetRepetition(CODES_TOTALS_BY_DATE;…

Hi I have built a database with records. This allows me to print envelopes to a client. If I select one record and print the envelope it is blank (not on the screen but in printing and preview). If I select all and hit print/preview (it will now print all records) non are blank. If I than ask it to print/preview the one record that I wanted to print in the first place by entering print from X to X, it prints fine. Any suggestions? Thanks

In my solution I have "Help" buttons which open new windows and, hopefully, enlighten the user. My problem is that I need to locate and close any "help" windows which may still be open prior to Quitting FMP from my base window.

Is anyone out there currently designing in AutoNavigator by David Kachel? I would like to share notes.

We have a form at work that we use as a cover page for our documents. Frequently we use a rubber stamp to denote that a vehicle is associated with the record. I would like to add a check box that when checked, makes a box with some text appear on the top of the page when printed. The box would not need to have any data entered/retained, it would just need to print when checked, and not print when unchecked. Thanks in advance, I'm a FileMaker newbie.

I need to add a time stamp to a running note field, something the user clicks a button to add a current note. My attempts are replacing all the note field contents. Help!!

Okay... I have a question, and I don't even know how to ask it. A client of mine runs a non-profit organization and sends his donors receipt letters. He would like those letters to include a year-to-date total, so they can see how much they've given for the current year. I developed a couple summary fields that seemed to do the trick. But...those fields summarize ALL the donor's giving, not just the current year's. So, for now, it would work, but come January, the total wouldn't go back down to $0. Any ideas? I'm really lost on this one. I'm afraid that I may have gone through the back door to get things done one to many times, and I'll have to redo a bunch …

Hi. Im doing something wrong Im sure, but cannot work it out. I have an database that is maximised for the most of it's operation, and occasionally need to open a small window in the foreground to (for example) select an item from a list but when I create then size (or new window with dimensions) the original window/app also changes size. Could somebody please explain with a simple demo of steps the process of doing this as I have various sized screens all over the place. Thanks, Greg

Hi Anyone know if it's possible to format text based on what's in a field? For example: In my layout I have a field called "status." At the top of the layout I'm using <> to display "Complete," "Pending" or "Working," depending on which is in the "status" field. I want the text in <> to be red when the field for that record is populated with "Working," yellow when populated with "Pending," etc. By the way, does anyone know what that function of displaying text from a field using << >> is called?

hi in my database i have a portal where items can be sold out, nothing special. However i want to be able to print an invoice of the current sale from the point of sale screen. Ive tried duplicating the POS layout and viewing it in preview mode but the portal doesnt change on the invoice page obviously. Is there any way to be able to display the portal items from the POS screen in another layout that i can print? thanks

Hi All, Is it possible to have a Title Footer display on the last page of a multi-page print job as opposed to the first page? On a multi page documents where the totals/summaries are presented on the footer I would like it to appear on the last page as opposed to the first or (to me worse) all pages. It would be great if FMP would provided this as an option. i.e. "Display Title Footer on First or last page of Multi Page Documents." Is there a technique that I can use to work around this? Steve

Is there a way to have a button take you to a specified layout but then also to a certain tab on that layout? Thanks

I'm not exactly sure where I should go with this but I'll give you my dilemma. I have created a database for a cemetery. The database tracks which section, lot, and grave someone is buried in. My client is looking for a map of the cemetery so thay can click on a particular grave and it would bring up the related record of who is buried. The cemetery is broken up into different sections and they are odd shaped. Any suggestions or examples would be greatly appreciated.

I've run into an interesting quirk. On Windows XP with 8.5 advanced, I have a list layout with a footer. In the footer I have multiple portals. When I drag and drop text into the portals I get different results. Sometimes the drop does not work, sometimes it drops data into the portal below (a different table and different field), sometimes it unexpectedly creates related records, every once in a while...it works as expected. I've tested the data file for corruption, I've reinstalled the app. The problem goes away if I change the view type to a form. Has anyone else seen this? Is it just me? Any ideas?

All right, I ordered several FM training CD-Roms that were extremely helpful, but there is still a problem that I am facing that I have been unable to solve. We use FM to track user usage of our equipment, and then cost. Each user is listed under a different boss, and that boss then receives the bill. I have been able to create a report that shows single visit costs per user, total visit costs per user, and total visit costs per boss and then total visit costs for all bosses. This same report also shows me how often each user came in, how often users came in for each boss and how often users came in total. I cannot get the report to give me the total number of users …

i searched the forums but couldn't find a hint. that's why i'm posting: can i add more avery label formats to the ones already in the filemaker format list? it seems that the ones in the format list are all in US letter format and not in A4 format as we use it in Europe. i need to print the labels in avery 3474 by the way. obviously i could define a customized format but i just can't believe that filemaker doesn't offer a better solution. Thanks, Hans

I have searched this question but can’t seem to find a solution. I have a field for a Social Security Number…I want to validate this to insure that a duplicate number is not entered. I have tried every setting I can to get the Revert Record button to go away and just have the message pop up with the yes or no button. Is it possible to remove the Revert Record button from the Validation / Unique Value settings? Thanks, James

Hello: I have a form that displays in table view that lists job orders. If someone changes the quantity of a job, I want to change the font color of the quantity to red to indicate a change. Is this possible in table view? I change font using TextColor()on a field in Form view but cant get it in table view. Thanks! Rick

Hi, I have a page with a number of fields that display summary of database data - eg calculated values. It displays the information as I want, but I have to do a Find from this page as well, and when I go into Find mode the values/text disappears. How can I make the values stay there whilst in Find mode? I have tried playing with the field behaviour and entering Browse Mode, Find Mode etc but it makes no difference. Any tips please. Ta. Greg

Hi there, I am only new to Filemaker, but since I have a lot of experience with PHP and MYSQL Databases, I have been able to use this in building with Filemaker. My question is: Am I able to define a region where the sorted files or "Repeat Region" are in the Body section of the page. I want to display a large background image in the body and have the displayed fields (from search) over the top of this. So far I can only see that a repeat region occurs when you set a line of fields and move the body tag under the first line. This means I can't have a print out with the full background image. Can you display a list of results in the Body inside a c…

Hi, So does anyone know if there is a way to create a breadcrumb effect in a Filemaker layout? I would like to mimic the effect as seen in a web site like this very fmforums.com site (attached screenshot image with breadcrumb highlighted). What I am hoping to do is to create the breadcrumb trail based off of a 3 level (or more) tab control layout referencing the tabs as Objects. Example: Project->Customer->Invoice where there is a 1st (top) level tab control for Projects then a 2nd level tab control inside Projects for Customer & then a 3rd level tab control inside Customer for Invoice Make sense? Thanks, thegooglemoogle

Hi. I have two tables. One is "Job List" which is a list of jobs for clients, and the second is "Timesheets" which is used for employees to enter times against various jobs in the first database. The layout Im using (in Timesheets) allows users to enter a single timesheet entry at a time against a single Job List job. I want to have it so I have a spreadsheet layout (assumably a portal) that allows me to enter multiple tasks for an employee on any of the jobs inthe first table. I can sort of get this working, but am having trouble with a feature the client requires. In the timesheet entry screen I can drop down a lookup list to the list of job numbers, but th…