Layouts

My users will cut and paste text into fields. How can I ensure that the text is converted into one standard font, size, format, etc. Thanks

I have a solution with over 100 layouts. I'm trying to organize the layout list so that the developer(s) can easily find things. I have some dummy layouts that are named "----- Reports -----" and "---- Data Entry ---- " etc. This helps visually organize the layouts. I'm using Mac OS X and FM 8 Advanced. However, I'm having a hard time figuring out the type-ahead behavior. For example, I have layouts named "Worker.Contact", "Worker.Financial", and "Worker.best" . If I click the Layouts popup and start typing "worker" it will jump to "Worker.best" which is third in the list. I wish it would jump to the first "worker" layout instead. …

Here is what I was envisioning: -- Data entry tabs and other layouts for data entry or editing -- Reports or forms that print out from populated data (many related tables) My users are accustomed to being able to edit reports/forms prior to printing. Is that normal? It gets complicated, because of portals (containing historical data) and other things that I have yet to implement and have no idea how that would work if they enter straight onto the form. Can I lock down the forms, so if any data entering or editing has to be done via the data entry layout? What are the “best practices” or recommendation or plain ole good advice? Thanks bunches

Can you import LAYOUTS from one filemaker file to another? I have a database in production use, but often add and update layouts in a working copy of the file with only test data. When updates are done, I want to import the new layouts to the prod version.

I have a pop-up menu that disappears after selection on Windows but not Mac machines running on Server 8. The menu is visible until the user selects a menu choice. Upon releasing the button, the choice and the borders of the menu just disappear from view. Wondering if anyone knows the answer to this problem. Thanks

Hello, I'm using maximized window in my solution. I would like to open another window - "pop up" window (300 x 300 px) in front of my "main window", but "main window" to stay maximized. Is this possible? Thanks, Lina

Hi, I am updating a Filemaker Pro database file version 5 i think (.fp5) I was working at the office on a mac in filemaker pro version 6v.4 to make changes to the current database. The program(database) is a label system which you enter some data in some text boxes, and then you select from a list of buttons on the side to decide what type of label you want the data to go on which type of label. i.e. a cd label, a dat label, a cassette label, etc. It works pretty well, (when it works). My job was to add a new style of label sheet to the list of labels. So that consisted of measuring out the different dimensions of the individual labels on the 8 1/2" x 11" sheet of label…

Hi there, We have an Apple OSX environmentaa and use FMPro8. Filemaker often defaults to US Letter paper size when we generally use A4 in Australia. Is there any way to set up a default paper size so that we dont have to keep changing to A4 from US Letter?

Hi All. Would like to execute a script everytime I change to another record in a database. I know that I can do it by making buttons and scripts. But I wonder if there is any way to make it work with the navigation in FM6 status area? Is the anyway to execute a script when using the status area. Best regards The Dog

Hello - I've been assigned to create some reports from a simple FM file that my supervisor gave me. I created a report layout that uses meeting dates as a break field, displays the items reviewed on that date, then shows a summary field (count) of the items in the trailing sub-summary section. This layout works great and is nicely formatted, so I duplicated and modified it in order to start on a second report. The second report uses manufactured part numbers as its break field, and a "Total Of" summary field in the trailing sub-summary section. This summary field is supposed to display the total of the "Quantity" field for all records in the sub-summary section.…

Hi, I apologize for being an extremely inexperienced Filemaker 8 user; although, given how easy Filemaker is to use, I've been making significant progress recently : My question regards the use of radio buttons. I would like to have a radio button set to a specific value if another field is between a certain set of values, ie, between 2 and 5, the radio button is set to a certain text value to give the user a general guess as to what the proper radio button selection is (with their ability to override it). However, I have set up the radio button value to be a calculated field, which checks another field for the number range (using the Case function). Doing …

Hi, Whats the trick to centring windows...: :

Is there a way to create contextual drop down lists Thanks in advance

How does one make a button (in the form of a tab) used to change to a different layout, become another colour when activated? - see the FM template "Family Medical Records" as an example Thanks in advance

correct me if im wrong. i have a printable layout, in which i use a title header (there is infor i only want on the first page) and then a normal header (same info as the title header just less of it) and then a body. When i print, the first page only prints the title header.... is there a way to have the title header print and have the body also print on the first page?

Hello, I am trying to construct a database and invoicing system for my dad's small business. I want to be able to make something like a dynamic repeating field of entries for the line-item part of the invoice. As it is right now, the Started Solution I am using allows for up to 8 rows of line-item input. If I fill in 3 rows, it still print out the other 5 rows as empty, which looks very impersonal. I want the invoice to be able to automatically trim the maximum repeated fields to the minimum amount of field that I have actually filled in. Or, another way to approach it, I would like to be able to start out with just one repeating field for line-items like Item, Price…

Hi! I have problem with showing summarized data. In attachment is sample of what I am trying to achieve. Database have users which are visiting different companies ( projects ) and do some work there ( categories ) for different amount of time. I need to summarize categories for one month ( ex: February 2006 ), how much hours users spent on each category. I also need to input how many hours they must work to fill company requirements for month ( ex: 20 workdays, 8 hours/day = 20 * 8 = 160 ). Then I need to show total hours they worked in selected month ( ex: 200 ), overdue hours ( ex: 200 - 160 = 40 ) and total overdue hours ( hours from months before ex: Janu…

Hello everyone, It is great to see such resources on the web for Filemaker. As to my issue...I am trying to develope a coding system to cross-code dental and medical codes. I have 3 databases and 2 join files AMA MEDAMA (join - reconciles relationship between AMA and MED Codes) MED ICD9Med (join - reconciles relationship between ICD9 and Med Codes) ICD In the ADA table I have a layout with a portal to assign medCodes. There could be multiple medCodes per ADA code, which are stored in the MEDADA db. I now would like to display on the ADA layout (portal) all of the icd9Codes pertaining to the related medCodes. I've tried creating a…

Hi! I have a database with many layouts. Each layout has the same title text, graphics, and buttons across the top. As it stands, if I ever want to change any part of that, I have to go through and change each layout, one by one. Is there some way to put this title text, etc. in some sort of header, so that if I change it once, it changes on every layout? Thanks!

I have a transparent portal that I have overlaid over a photographic background image. Whenever I switch between records the entire portal momentarily flashes white. If I fill the portal with a color the flashing goes away but it totally ruins the appearance of my design. Are there any tricks for eliminating this flashing problem?

Is it possible to vary the color of the text value of a calculation field according to what the calculation returns? I have constructed a database of commodity price movements. One field "Direction" returns "up" or "down". Is there some way to color "up" blue and "down" red? Of course if "up" and "down" had their own fields, I could easily do this in Layout, but that's not what I want. I also have various calculation fields returning the ANSI character ▲ or ▼. I would like to color code these as well. It might be possible to accomplish this using container fields. However I understand that it is not possible to perform searches, or further calculations using the…

I am somewhat new to FMP and I have a Layput Theme in XML but have no idea where I place it so that It will be added to my themes. I am using FMP 7 and all I can think of is to but it in "FileMaker 7/Extensions/" and then I get lost. Do I store it in my server software or in my client software? As you can see, I'm lost...

I'm a beginner and need some assistance. I have a student database with multiple related tables. One of these tables is a test scores table. The testscores table has multiple rows for a student. The rows have a student id (key), test id (e.g. SAT or ACT), test component (e.g. Verbal, Math, etc) and a test score. Rows - e.g. one row with 0001 SAT Verbal 800, another row with 0001 SAT Math 800, another row with 0001 SAT COMPOSITE 1600. I can display this test info in a portal for each student, but I want the test info displayed in table so I can export it to Excel as one record for each student. Where do I start?

I have a summary field which displays the total of values in related records. However, if any field is selected for editing on this layout, the summary field value doesn't appear when I move on to the next record. I assume that this is because the summary field can't store the results of the calculation. I can only get the summary value to reappear if I: - deselect all fields for editing - move to another record then back again, with no fields selected. Is there any way to make the summary field's value stay on screen for subsequent records I visit without having to do the above?

I have a portal which allows the creation of new records. The user enters some of the data in the portal (eg Name, Position). I use a go to related record script which opens another layout in a new window to allow the user to add the other details (eg address, phone etc). The problem is that the record in the new layout cannot be modified because it is being modified in the first window. This only happens when adding a new record - it works fine if I only want to modify an existing one. Is there a simple solution? I only just discovered the "open in new window" option and it looked like a good way to simplify the navigation for my users. I tried adding…

Sorry if this has been asked and answered before. I tried searching for a solution, but didn't find one. In going from 6 to 7, I combined about 10 databases into one. The letter layouts from each of those 10 databases are being used in the new database. This creates a huge list when you look at the layouts. Is there a way to manage the layouts with folders like in a favorites list in a web browser? Or is it possible to attach certain layout names to one layout like a donations layout would only display the names of various thank you letters. Thanks for any help John

I would like to change the background color in my contacts database to reflect if someone has died, i.e. when the radio button for Deceased? is marked Yes then the background colors would change to grey or black. Is this possible?

We currently have a database that stores hundeds and hundreds of constantly changing tasks as individual records with a start and end date. Our problem is that we require a more visual gantt style interface for data entry than filemaker can provide. We need a view that has name and task in the first two columns with each subsequent column representing a dynamically generated daily date. A task range would be represented by a range of 1's. Users would be able to adjust entries by adding or removing these 1's and be able to view surrounding records in a more visual way. In essence, we want filemaker to have some of the capabilities that Project has. (We do not want to…

I wanted to make a layout that would insert info from several different fields into an HTML template, in order to copy and paste the code. I made a layout, just using text with tags for the fields, and the code appears the way I want it, but I can't select it to copy it. What do I need to do to make the same type of thing that I could copy and paste? Do I need to do a calculation and break up the code into sections, inserting the fields in between?

Hi All. First of all I want to say thanks for the help I have recived from this site... Next I have yet another problem ;o) I want to make the color of the text in a field depend on the content of the field. Something like this: if xx=0 set color to red else set color to black Looked at the different script functions but have not found any that I think/know could do the job.... Any help would be great Best regards The Dog

I have a field that contains the lender a customer is using, this is selected via a value list based on a field in a related table. I need to set up a report that shows how many times each lender is used(preferably with zero used lenders excluded) ie Bos 9 Woolwich 4 Halifax 6 Gmac 5 Not sure where to start.

I made a button to navigate back to the main menu, but would like the data to show up in a table mode only. The button doesn't show up unless it's in form mode, is that correct? I put the button in the header, in the footer on the side, but am not having any luck unless it's in form mode. Did I miss this point in the documentation? Thanks in advance Have a nice day!

Hi Guys, Has anyone managed to turn the borders around repeating fields off? Ive got several repeating fields which are containers, which contain solid colours. Around each repitition I get a white border going around these colours (even though its a hairline)it looks like an eyesore on my layout. Ive tried the borders property, and turned line to nothing nut I cant seem to switch the border off. Many thanks as always

I've got an invoice layout where I sub-divide our billable items by category, and I'm trying to see if there's a simple way to prevent the category heading (leading sub-summary part) from being orphaned at the bottom of a page while the items it pertains to break to the following page? I've been staring at this for way too long, so hoping someone can either point me in the right direction or tell me it's hopeless so I can move on. :P

I have a database with fields in English and one field in Arabic. Every time I need to enter arabic letters in that field, I have to switch to Arabic layout by clicking ALT SHIFT on the keyboard. When done I click the keys again to switch back to English layout. [color:red]IS THERE A WAY to auto enter that mode when the cursor is in that field. THANKS

Howdy, howdy. Don't get up. I'm overlooking something probably very obvious--no surprise there! Referring to the attached file, I want to prevent duplicate Federal Aviation Regulations (FAR) from appearing in the report--in the example attached, FAR 121.191. I thought of a sub-summary angle, but alas no success since it won't allow for column set-up in there. The nerve! I appreciate your help in solving this minor brain hernia. Many thanks! Rich FAA_Database.zip

I have an Invoice layout, which works fine in browse mode, all info correct, etc. The Invoice number and customer name appear as merge fields in the header and again in the footer (same merge fields). When I switch to preview mode, The header is correct, but the footer now shows data from a different record. What did I do wrong? This is dang frustrating.

Don't know if this is correct forum? I would like to have a layout that displays records based on a value for a specific field. I have an inventory database and I would like a layout that shows items that correspond to a specific vendor. Ideally it would update itself when a record changes as well. I realize I'm probably making this harder than it is but the method I'm trying seems too involved. Thanks in advance

I am trying to figure out how to divide a field that uses ";" as a divider in it. Example: In my paperwork the Color field is filled in with something like R134;L228. These two numbers reference colors for lighting. I have a field that is Color 1 and another that is Color 2. I would like the R134 to end up in Color 1 and L228 to end up in color 2. I understand the basic logic of the calculation, but I don't know how to write the calculation for Color 1 field. I feel it need to be something like {if color contains ";" use data before ";"} but in proper syntax. Could anybody help me with this? Thanks in advance.

Hi All I'm having a problem with a script. I want to check if a field is empty and if not show a message. If it is empty all I want is to select the field I clicked on. I'm having no problem with testing for field empty but I can figure out how to select the field I clicked on. I can make it work if I make a script that selects a specified field (aka the one I clicked on) if the other is not empty. But to use this will force me to make different scripts for each field.. This works but I have to set the field I want to select.. if ["field-to-check <> """] show message ["field-to-check not empty"] exit script else go to field ["field-…

Hi I have a Table in which the person chooses an appointment by time of day (1-2, 2-3, etc). . . broken into categories. How would I display a nice report of that? I want to make it so that one sheet would list all appointments in chronological order. For starters.. the sort doesn't work because it is tricked by the text. I can't seem to figure it out.

My file has a damaged layout that I can't delete. Everthime I try to delete the layout, the program will quit unexpectedly. The file is otherwise functioning well. I have tried the help instruction given by the filemaker menu, never work. It just instructs us to scroll away from the layout then delete. Can anyone help?

Is there anywhere a set of rules about how to position objects near the bottom and top edges of a Part, so as to make things mesh properly when printed? In particular, I'm trying to do the Lineitem portion of an invoice. The column header is in the Header, each lineitem is in a Body part, and the View mode is to be List. I'm having a hard time figuring out things like: How to get the column header box to sit directly atop invoice line 1 (instead of hovering one pixel above it) How to size and position vertical line segments in the Body to create a long, unbroken vertical line when printed (or to not disappear entirely!) How to get horizontal lines between lin…

Hi All Can anyone help me. I want to divide a number (in another field) into 2 new fields. One holding the part of the number before the decimal and another containing only the 2 digits after the decimal. Have no problem with the first part but if I use a calculation with Round (number; precision) to get the part after the decimal it works fine as long as the number doesn't end with .00 When the number ends with .00 it takes the to digits before the decimalpoint instead of the to zeros after the decimalpoint... example This works number = 1025.95 firste part ok = 1025 second part ok = 95 This doesn't number = 1025.00 first pa…

Hello all, I'm trying to create a purchasing data base for my company. Our company is still creating purchase orders on a TYPEWRITER. Desperately trying to bring us to the 20th century. Anyway, All purchases need to start with a standard Purchase order. I have everything how I want it except I'm having trouble with the description field. Our purchase orders typically only need 1 or 2 lines of input information to describe what is expected from our vendor, but sometimes we have someone do very detailed work and the description field may have 20 lines of detail. What I need, if possible, is a way to have the description field expand and contract to the requ…

There is a dark horizontal line between my Header and Body that extends in definately to the right of the layout. It does not appear in Layout Mode. I would like to get rid of it. Any suggestions? Thanks!

In tweaking an invoice layout, I seem to have introduced a quirk in the way row #1 of the LineItems portal appears in Preview mode. The value in column 1, normally centered, is shifted to the right a quarter-inch and truncated. The value in column 4 is missing. The other values in row 1 are fine. Rows 2 and up are formatted correctly. The problem doesn't appear in Browse mode, nor does it appear when the document is actually printed. But the Preview looks wrong. Can anyone suggest what might cause this? Thanks, Chap

hello all, how can i stop the scrolling of record with my mousescrolbar? And can i turn scroll of a window? thx in advance

I hope you guys can help me. Here is my problem. I have created a form that collects information for the following: number of hours billed, number of hours worked, the pay rate, the amount and the month the information is recorded. I would like to create a report that would allow me to show the total amount of money spent for each month. For example Month Total Spent Running Total May $29,26201 $29,262.01 June $29,720.97 $68,982.98 July $49,910.21 $118,893.19 Creating the summary for a running total I can do. However, I am having a very hard time getting all of the months to add up and produce a tota…

Hello, I am new to Filemaker and this might be a stupid question and I am sorry if it has been asked before, but I googled and googled and cannot find an answer. My question is how can you separate the layout popup-menu so that when you click on the layout popup-menu instead of scrolling up and down and up down due to the tremendous forms is there a way to divide the layout popup-menu into two columns or more. It would be a great help if it can be done because time would not be wasted on something so trivial as scrolling all the way down to get to the last form. Any tips would be great!

I know there's been plenty of discussion about fonts looking bad in cross-platform databases, but: I'm on a Mac (OS X 10.4.6), and ever since FM 6.0, almost all fonts look just horrific in FileMaker, especially if they're any smaller than 12 points. This is true even with the ones you'd think would be pretty universal, like Times or Helvetica. I don't have this problem with other applications. I'm not crazy about Verdana, but it seems to be the least-screwed-up sans-serif font I can use. Any suggestions -- like, is there a setting in FileMaker that I should have known about by now? Thanks. Gregg

How do I add an icon to a button? i.e. The microscope icon to a button set to find records. Where are these icons within the program? I'd like to add the old set from a previous version of FM.

I have an existing contacts database for an alumni association, and I would like to create several catagories for the contacts. The primary one will be Alumnus of course, but I would also like to be able to change it to Friend or Family. So I am assuming that this should not therefore be a global text field. And I would like to populate the current records with the default value of Alumnus. How can I do this?

I'm trying to learn more advanced FileMaker, but can't find what << name>> means. In several templates there are references to <> <> and similar. These are clearly field names, but I can't find any information in Help, programming books, or the FileMaker knowledge base about what the << name >> means and how to program these things. Please help.

As a complete FM beginner I have already become stuck. I have a layout that gives me a list of a school house. I want to count the number of boys (M) and the number of girls (F) and the total number of students in that 'Found' group. I can't find a way to do that. 'Sex' is a field that is included and populated. I hope that all makes sense? Please help Peter.in.th

I´m finding one of the templates quite adequatI’m finding one of the templates quite adequate, it has most of the features I require although not all of them. I’m new to FM8 and am seeking for some assistance. The template is labelled “Email Campaign Management” and can be found in the directory “templates/Education – Administration/”. The additional features I seek are the following: (1)The possibility to add the “Notes”-information to an e-mail template, I’ve been trying to solve this myself by duplicating and modifying an existing “button”, eg. “Last Name”, without success. I can’t understand why I fail to do this?! Any clues? (2)To add multiple recipien…

I have a database that I'm going to distribute as a runtime solution. I want the user's information to appear in the header of every report. This information is really unrelated to the rest of the data in the database. The reports are pre-built for the end user, so database fields were the way I was going to go, not text labels. I've tried using a table to hold the user's information, but the report layout does not want to display these fields because the table is unrelated to the data being displayed in the body. How do I get the information from an unrelated table to appear in a report OR just any way to accomplish this?

I hope this isn't a dumb question.... Is there any way to get a header to print on only the "first page" of a multi-page report? If not an internal FMP thing, are there any tricks of the trade for us less experienced folks? thanks, Steve

I want to put together a basic runtime for a group of friends who have a mixture of Mac and Windows. I have decided to work on a screen resolution of 800x600 at the moment but I'm not sure how that reflects in terms of layout size, given that there are the dimensions of the menu bar, status bar, borders, scroll bars etc to take into account. Can someone give me an idea of what layout dimensions I should aim for to avoid "overflow" problems on either Mac or Windows? The development will be on a Mac. Cheers, Muzz

Hello All, I was wondering if this would be possible. I have 3 different text fields. Field 1 (Peanutbutter) Field 2 (Jelly) Field 3 (Toast) Is there a way to make a field which would contain the text of the other 3 fields making a Field 4 (Peanutbutter Jelly Toast) ? Please Advise, much appreciated!

Pardon if this is a silly question, but I've searched the forums, consulted my "Missing Manual" book and Googled the question, but can't seem to find an answer. Once we've created a button and assigned a script to it, is it possible to go back and edit the text on the button? It seems like that option should be available in the "Button Setup" dialogue box, but I don't see it. I'm using FileMaker Pro 8 Advanced on Mac OS X. Thanks in advance for any help!

Appoligies for the complete NOOB question but I am realy struggling with reports at the moment. Basicaly - I have a Matters table, Clients table and Proprties table. I am trying to create a report (layout?) on a matter(showing the matter details), then list all of the associated clients to the matter (many-many relationship) and then all of the associated properties to the matter (seperate many-many relationship) On the data entry layout I use two portals to display these, but for a report I'm stuck and cannot understand the way the summary parts work??? (eg I dont want to sum anything - just display multiple clients per matter and multiple properties per …

Hi all, I am a beginner at this so if this is deemed a very simple question then i can only apologise! I have made a layout that is a standardised letter that has fields for title, name and address. When i preview the letter. it shows the title, name and address but they have a big gap between the fields. The fields are the same size as the box they are made in on the layout page. How do i get the fields to just say 'Mr A Smith' rather than the current 'Mr A Smith' I the words to appear but ignore the size of the field box and just have a space in between the words. I have tried to find the section in the instructions but don't kn…

I would like to lock a field on a particular layout such that it can be viewed but not changed on that layout. The same field must be entered in the same record, but in a different (previous) layout. Any suggestions? Thank you, Jason

I'm using filemaker 8 to graph the number of occupants per floor in a building.. i'd like to prepare a report that shows a graphic representation of the % occupied per occupant on each floor.. along with the occupants name ... could someone point me in the right direction ? i'd like the report to look something like this: | smith (3) | jones (2) | frank (5) | paul (4) and have that repeated for each floor of the building, showing the number of units occupied by each person

I've attached a demo file showing how I've tried to do alternating row colors in list view. I want uc_RowBackground to completely fill each row with the calculated color, but I am unable to get rid of a transparent 1-pixel border. In the demo file, this is where you see the pale purple background peeking through around the edges of the alternating gray and peach boxes. I want for gray and peach to be juxtaposed seamlessly. Can anyone spot what I'm doing wrong? Thanks, Chap ListView.fp7.zip

I defined a lay out for data entry by key board. However, filemaker won't let me enter data. I am in browse mode and created three records. When I click into the fields they do not get activated. Using tab does not help either. There's probably a simple problem but as I am an ignorant beginner I have not been able to figure out what I am doing wrong. Thanks a lot for your help. Leviathan__s_Database.fp7.zip

I'm creating a database that uses a value list from a table. The user is allowed to add and remove values from this table. I have a checkbox that toggles an "Active" boolean for that entry. This Value List/database table is used for data entry later in another section of the database as a drop-down list. How do I get this drop-down value list to display only the values that are boolean "Active" as described above? I've tried a self-referencing as described in the FMP help, by adding a second boolean field that is automatically filled with a "1". No luck so far.

Can I use a merge field with a funtion like GETFIELD("KON"+$mes) so it act as another field ? if not can I use another way to acomplish that ?

Hi, New to FM. I have been working on a new db for about a week. I thought I was finished, just doing a little testing. Now as of today, in layout mode, my fields are displaying some weird information. Such as: "Powerfull Scripts", "Customizable" and on some fields it is showing input values from my value lists. Not one field is displaying the name I assigned it. In browse mode, everything seems fine. I am little concerned about using my db. Larry

I am looking to create a layout that will display information to clients in full screen, with a forwards and back button, so it looks more like Powerpoint than Filemaker. They will not have control over moving between pages, so there is no issue with how the records are sorted prior to display, or restricting them from accessing parts of the database. As I understand it if I use Kiosk mode that applies to all users, is there a way to achive this?

When I have the 'view object size box' open if I key in 0 pixels from the top and 0 pixels from the left it defaults to 12 from the top and 17 from the left. This is not a problem cos the object appears to go right into the top left hand corner but I am just curious as to why I cannot get it to accept a '0' TIA Phil

I used to have data into a global field when using FMP 8 networked, but when I moved to FMP 8 Server the same solution is not working, the global field retains the data only while the solution is open, after quiting and reopening the updated data dissapears only from global fileds. It is supposed to work like that ? any suggestion to overcome that situation ?

I want a button whose label and function change depending on the data: specifically, it goes from "Invalid" to "Make Valid", depending on and setting/emptying a timestamp field indicating when the data was known to be invalid. Sounded like a job for a calculation field. So I made one that would evaluate to "Invalid" or "Make Valid" depending on my criteria, and planned to make the button text a merge of this field, and then put more or less the same logic in a script to determine what to do when it was clicked. Well, when I put the merge field on the button, it does work. However, the name of the field is so long that Layout mode refuses to let me size the butto…

Just wondering if I have my understanding of how conditional formatting using TextColor works in regards to dates correct or not. What I want to do is be able to format the color of a date (red if greater then due date). That said, I also want to make use of FM's date format in layouts. For instance, in some places I need to just show day/month and not year. Can I have both and still only use one calculation field? It seems that if my calculation result is set to text I have the color but not the ability to format the date in the layout. If it is set to calculate a date I have the layout format options but the color doesn't show. Thanks, Br…

I'm a new to filemaker and am using an older version (3) I'm trying to make a layout that expands a text box when the box becomes full. It also needs to push the content under the text box down so all information is viewable.

Alriiight...I've been working at getting a Percent of Total field to display subtotals as percentages of the final total (hence the fieldname). To derive this I have two Summary fields: SumTotalProblems and SumPerProblems. The former is a Count of the Primary Key field (ID) and the latter is a Fraction of Total of the Primary Key field (formatted as a percentage in the layout). The weirdness sets in when I run the report and sort based on the break field. I've included a screenshot of what happens and another of the table structure. Basically, it seems to calculate the value appropriately for 1/3 of my sample data. Does anyone know why this is happening? …

Hello: I have a database set up for a client-top is basically contact info; bottom I have a portal that connects to another database which has notes on the client, by date. Each client has multiple records, based on project #. She wants a report to print up with status notes. I am having trouble setting up a report to ONLY show the last note added. I can sort the notes, to show the last note added, when you look at it in the regular view, however in the report view, it shows all of them, just in order of date. I only want to show the last note, not all, so when she prints up a status for a client it shows the most recent note for each project. Does this make s…

I can't even figure this one out through filemaker's own tutorial help function . . . . How do I create a relation? (and through which table to I make it/have it show through? Let's say I am creating a database with two tables: Company, and People. In the Company table I have a "name of company" field as well as a "ID" field with an auto-entry serial number, and an "address" field. In the People table I have the same "name" field and also with "ID" field. If say I want to have the name of the company each person is associated with and it's address to show what other fields do I add? and to which table? **I noticed that in creating a new table that a new s…

Hi All I know you can now have 'sticky' portals in FM7, to stop the portal popping back to the top. Is there a option to stop a text field from popping back to the top when you tab or click out of the field?

hello, I am creating a layout using an Avery template. With multiple fields to each record is there a way for me to have displayed/printed out onto a single or continous sheets of all those different fields but under the same record with the same info? Specifically under the avery label template layout I have 3 fields: Name of person, Company, Address . . . . . but with more than one name to each compnay I'm not sure how I can go about doing this. Anybody here get what I'm trying to do here? Seems like it could be a simple solution. -brian

I'm developing a solution to be used by both WinXP and OSX users. I have begun inserting graphics (buttons and the like) using the jpeg format through photoshop in WinXP. However, when I open my database in OSX the graphics do not display at all. (I get the windows logo where the graphics should be) How should I be inserting graphics in to my solution to ensure cross platform compatability? Do I have to make 2 different versions? One for PC one for Mac? Any help is much appreciated. Pete

Ok, somewhere along my development line I read that if you have multiple telephone numbers for your contacts (these days don't we all?)you should set up a separate table for Telephone Numbers. I also incorporated a Telephone Format custom function as well. Problem is custom function format doesn't accomodate international numbers. So, I set up a separate field for International numbers. My regular numbers are in a portal. Here's what I would like to do: Find a new custom Function that accomodates Intl as well as domestic numbers. That would be the easy way to resolve the issue for me. OR.... On some of my reports and layouts I want to just show t…

I have created pop-up windows with scripted user abort off/hide status area/pause. This works fine. Users cannot do anything until they click one of the buttons on the pop-up. The close box is not active. However, the resize box is active, so the user can monkey with the size of the window. Is there some way I can disable this? Also, I've had a user request to "dim" or gray-out the close box since it isn't useable. Is there anyway to customize title bars? Thanks for any advise!

We need to be able to quickly switch back and forth from a table (or portal view) to the form view while staying on the same record. I saw something a while back about programming this in Filemaker Advisor, but lost the article. How can I do this? ;)

Hi there, I'm a beginner at Filemaker and am currently trying to modify an existing layout. I would like to make a new box that I can check to sort a list. Any help would be greatly appreciated!! please see jpeg file, it'll explain more than I can. :P

I am trying to create a letter layout that will accommodate short and long letters. Is it posible to have the letter appear lower on the layout if it is a shorter letter?

I'm trying to construct a very simple summation-type report -- summing a designated account for a range of dates. I haven't found an example anywhere simple enough to get me past where I am. The ones I've downloaded haven't shed any light on what is obviously (to most) a fairly basic operation. I've attached my 2-table, 1-script example, but if anyone knows of an existing simple one, please let me know. Otherwise, I will certainly appreciate a little guidance. Thanks. SumTest.fp7.ZIP

I need to place a graphic and need the white background to be transparent. I wouldn't have to do this if there was a way to rotate text 90 in the IWP interface, all rotated text goes back when viewing online.

I'm developing a database for a small advertising agency. They use the Eureka typeface for all their communications. I can't find this typeface in the drop down menu for configuring typefaces - is there anyway to import a typeface suite into Filemaker 8? Thanks Debra

I can't for the life of me create any more than one tab for a text field in layout mode. When I click "new", it just replaces the first tab. I hope I am just miss'n it and that it isn't a bug.

O.K., I've figured out (finally -- on a 4th pass of the layout wizard) how to make my report group properly. MY REMAINING ISSUE is how to get the listed items to be separated by commas across the page -- rather than printed in vertical columns. In the accompanying database, the word “Clear” would show all synonyms separated by commas: Clear -- Bright, Transparent, Lucent, < . . . and so on> I've turned on the Slide Field option to no avail. This is my first attempt at a grouped report and I would appreciate it if someone could point me in the right direction. Thanks (An aside: I posted this question a few days ago under Printing, …

Is there any possible way to keep FileMaker from placing the black outline around a text field when it's selected by the user for editing -- or maybe change the color of the line? Turning off Show Text/Field Boundaries doesn't work, nor does placing the field behind a white line frame. I'm starting to believe the answer is "no", but I thought I would ask before I abandon the idea.

My layout contains a rectangle which surrounds a group of fields: [Name] [Company] [Address1] [Address2] [City] [state] [Zip] Company and Address 2 may be blank. I want the rectangle to slide upward, along with the fields it contains, but I don't want the fields within it to slide relative to one another. How do I define the Sliding properties of these objects? I suspect it's a matter of adding some "invisible fences" but I haven't found a solution yet. Thanks - Chap

Hi, I duplicated a Layout and deleted all of the records in the new layout. It wasn't until after I had closed the database and reopened it that I realised I had deleted all of the records in the original layout too. Is there any way I can get these records back. (No, I don't have a back up). thanks in advance stephrocke

I would like to know if there is a way to manually insert forced page breaks like those that can be inserted when using MS Word. I have a layout with a header and title header. the little dotted lines that are supposed to represent the page are severly skewed when those two parts are added. I have to flip back and forth between Layout and Preview modes and move the fields up and down and it is getting very annoying and slow. It's also very tiring to finally get the fields on the right page only to have the top margins vary from page to page. I am not opposed to a work around but I don't want it visible to the end user. Any help would be appreciated!!

I have built a invoice report that list line items by category. The category is in a sub-summary part while the line items are in a "body" part. When the line items are broken up to the next page, I would like for the category label to repeat on the next page with an additional label "...continued". Example of Report Layout: Category A ------------- Item one Item two item three [color:red]Category A (...continued) ------------- Item four Item Five Category B ------------- Item one Item two How can I get the Category part to repeat on the next page and add a "continued" label??

Is there a file that can control the look of the layout? Something like CSS for the web page. Thanx

Hi all, and thanks in advance yet again for answering another of my noob questions. I'm trying to create a simple report that shows total time billed for each staff member. I created a layout with one sub-summary part containing the standard fields "Staff" and "Hours Worked". The sub-summary part is set to sort by "Staff". What I get in preview mode however is a normal list view of each record for each staff member with the individual hours worked for each record. What I want is a single, cumulative line entry for each staff member that also totals the hours. What happens now: Joe Smith 10 hours Joe Smith 5 hours Joe Smith 10 hours Joe S…

My pop-up is long. Is there a way to have a pop-up presented in more then 1 row?