Layouts

I'm building a database of real estate properties. I have fields such as: TITLE, SHORT DESCRIPTION, MAIN DESCRIPTION, DSCRPTN 2, DSCRPTN 3, PIC 1, PIC1 CAPTION, PIC2, PIC 2 CAPTION, PROPERTY TYPE, AGENT and so on. The main output for this database is sell sheets. HERE'S MY QUESTION: I would like the user to have the ability to--once in a layout--choose which fields populate which areas. I'm thinking of a dropdown menu (suppressed printing) by each "field area" (sometimes it's a picture box, sometimes it would be a text box) so that the user can choose which fields populate that layout of that record, at that time. Can this be done?

I have a database containing "client" records and another containing "contact" records. These are relational and I wish to write a standard letter for the "Contacts" using a new layout. When I insert the merge fields to be used the <Name> comes from the "Contact" database but I want the other information such as <Company> , <Address> etc to come from the "Client" database. Whilst I can choose these merge fields from the "insert merge field" by choosing a related database (i.e "client") when I preview or print I don't get any information across ?? Pretty new to using Filemaker so if you can advise me I would be most grateful. Cheers guys.

I want to be able to print labels on a partially used Avery label sheets. I want to select what my starting label will be.

We are using File Maker Pro 6 on windows XP. One of our databases has a form that is too large to print on one page, even if we use legal paper set as landscape. The owner will not allow us to redo the layout to be more printer friendly. My question is, how do I make filemaker 6 for the PC shrink the layout down to fit on one sheet of paper without changing the layout? Is this possible? Thanks!

Is it possible to remove the entire menu bar of a runtime solution without using a plugin?

I am working on kiosk db. I have a "Search" layout that the user can use to find specific book records. After hitting the search button, the user is taken to the results Layout which is in List Mode. If they would like to see the information for a particular title, how can I take them to a Detail Layout for that one record? I would like something that functions like a web hyperlink- meaning they can click on the title and go directly to that record instead of having to type anything in to a new field to get there. Is that possible? Thanks for any advice, Catherine

Hi, If you are in a layout and you have a field or a number of fields, say a table of Music Groups information and you would like to put this information into another table, say called "Managers", then what is the best way to do this? I have found 2 ways so far. First way is using global variables. I set the field(s) I want to copy into a global field in the same table. I then switch to another layout, and then do a Set Field on the record in the other layout using the global variable. Set Field [bands::gBandName; bands::name] Go to Layout ["manager layout" (managers)] Set Field [managers::band_I_manage; bands::gBandName] The second way is to use Copy…

This may seem elementary to most of you but I'm new to FM7. Is there a good tutorial or book that would explain how to add or create "tabs" on a layout. Something along the lines of the Personnel Records layout template that comes with FM7. If I wanted to add another tab to the 3 that already exist I don't even know where to start and exploring the layout it's not intuitive to figure it out. Any help would be greatly appreciated because this knowledge could be used on many other layouts in the future. Thanks... I do enjoy this forum by the way.

Post deleted by vasilek

Hi, I am making updates and upgrades to a database created by someone else and I think I have hit the outer limits of my abilities. I'm hoping I can explain this clearly enough so you all understand what I'm talking about! This database has about 15 files, and I think 4-5 of them are involved in this report: Client information - holds basic client info - name, address, employer Workshop information - holds basic event info - title, date, location Workshop registration information - line item that registers a client for a workshop Session information - holds information about breakout sessions WITHIN a workshop Session registration information - lin…

I

Hi. Is there a way to create a splash screen, set a timer to shut it off and then go to a layout? And can you make this splash screen without the tool bar on the left... and then when it opens the second layout.. have the tool bar re appear? It's probably easy, but I'm new. Vandy

How do I make a layout in FM that changes color with the color scheme of Windows XP?

Our server and most of our clients are OS X. But we have a few rebels accessing the databases with Windows - mainly XP. But nearly every layout looks different in Windows and they cannot print forms that they need. The fields cut out some of the test and even objust are in different places. FMP is supposed to be cross platform, but I am getting frustrated. IS there a simple way to get the layouts to look the same in both platforms? Tanya

I'm running FM 7 on XP and I'm having a strange problem with my layouts that i cant seem to figure out or find any info on. It seems to happen at random but it always happens in the following order: 1. First, there will be any of a number of odd selection problems, including an inability to select/deselect certain fields; selection boxes staying put when the field they surround is moved; locked fields disappearing. Once this begins on a layout, it doesnt seem to stop (or spread) even after the computer and Filemaker are restarted. 2. Eventually (and inevitably, it seems), only one or two objects or fields will be selectable at all and even those are un…

Hi there - I am using FileMaker 6 on XP with FM Server 5.5 on Windows Server 2003. I have attached a copy (pdf format) of the report that is printing in an odd way. The section that is not printing correctly is under "Loose Items to be Built and Sent with Job" and under "Crown, Knifemold, Toekick, Shoemould, Decks and Bar Tops". For some reason, when this prints it is scrunching the fields in an odd manner. Any ideas on how to fix? Thanks! ShopTravelerExample.pdf

Does anyone use ACD Deneba Canvas to create layout design? I'm struggling with transparent graphics

Hi I am fairly new to FM. I have a multi-tabled project that I am working on. One table contains "families". A second table contains children. These 2 tables are linked by a family code. In the family table is the street address. All the children are seperate records in the children table. I am trying to create a mailing label that would say: To the parents of xxx,yyy,xxx where there might be 1 child in the family or 4 children. Thanks in advance cathy

I am having a problem with a layout that I am using as a contract. The layout is "Stock" 3 pages long but when in preview mode slides up to anywhere from 1-1/2 to 3 pages in length. It does this because I have a series of large text fields that shrink to fit the text within them. I have inserted a page numbering script that displays the page numbers as "Page 1of3". The numbering system works great! Here is my problem. The layout automatically wants to print 3 pages even if the last one is blank because that is how long the body of the layout is. My specialized numbering system doesn't jive when the last page of the contract says "Page 2of3". Thi…

We have both Filemaker 5.5 and 7 in our network. I'm converting some of the files over to 7, but things are not going too smoothly. Today's problem is the page setup. In 5.5, the page orientation was remembered for each layout. In 7, all layouts default to portrait. If I set it for landscape, print and then close the db, the next time I open it, it will be back to portrait. Anyone else see this? BTW we have 7.0v2 on all the computers. It's a global problem with FM7. Tom

What is with the buggy graphics in layout mode??? Lines looking cutup and such? If I scroll off screen and then back sometimes it corrects it. It has been that way from filemaker 5 to 7 and it seems that 7 is worse. It happens on multiple computers with multiple licenses. Is there a fix for this? Is it a Windows thing?

Hi everyone, I was told that FMP7 supported transparencies. I can do this with a container field, but is there a way of doing with a pasted background graphic? I have a picture that has a transparent background and I want to make it sit in the background of a layout with a colored background. Thanks in advance

How does one limit the font choices in FM? I olny want to show the Windoze/MAC compatable fonts.

How does one limit the font choices in FM?

Does anyone know of a way to hide or lock layouts (or make invisible) from users? I'd like to make it where they can still have access to the status bar but not be able to see the names of all the layouts.

Actually using WinNT. I have one page that I want to serve. When I hit the web link that shold take me to the page, I get the following error: Unable to process your request because the layout could not be accessed. Any idea's? tia, Brad

Hi, Just when I thought all my problems had been solved forever... Enclosed is a small attachment that best illustrates my problem (if you run it but see no problem, please tell me anyway). My main file (Main.fp7) has a startup routine that executes a script to go to a layout in another file (Help.fp7). It goes to the layout in the other file, but leaves a visible reminder of the opening layout in the main file. It appears that part of the non-client area of the original layout has NOT been removed from the screen. I can find nothing regarding this in the product errata. Has anybody seen anything like it ? {FM Developer 7 running on Windows 200…

Hi, I have a clients table (and layout) in one file and a contacts table (and layout) in another. On both layouts, I want a button to ADD various details of the record to the other table, so that name/address details will be copied across (or updated). I tried relating the tables through ID and using a lookup for the fields to be copied, but get the error 414 (layout cannot display the result) if I try to "Go To Related Record" in the other file (wrong use of the command !). Intuitively, the tables should be related to make copying easy, but I can't see how best to achieve this between the 2 files. I suppose the problem can be summarised thus: Q.…

I have a order entry database. The original programmer (a long long time ago, in a galexy far far away...) decided to use repeating fields (see another universe). One of the repeating fields is a part number. The objective is to write a report that will give the count of orders that use that part number. I have a field "Count of Orders" that is a summary count on "sales order numbers" I create a layout that shows the part number and order number. Then I have a Trailing grand summary that has the count. However that will only count the found records. So I tried to use the "subsummary when sorted by:" Part Number but that did not show ANY Counts. …

I currently need my layouts and reports to start a new page when the text I write in text boxes in the body field overuns the size of the A4 layout. Nearly all of the reports I need to create in filemaker need alot of accompanying text to go with them. This means that being restricted to one page for my outputted documents like estimates isnt a desirable situation. Does anyone know how to achieve multiple page reports and layouts that relate to single records, I'm stuck................. Thanx Ash

How can I make it possible to enter time in a field as such; 1.15 for an hour fifteen minutes without getting the box that says I have to enter time as 01:00:00? Help! I frustrated.

<< STD DISCLAIMER FOR HAVING HAD A FRONTAL LABOTOMY >> I execute a script in file A, that executes a script in File B to go to a particular layout (in file :. It appears to work okay. If I then add a line in the script in File B (after the Go To Layout line), to execute a script in File A, it does not go to the layout in File B, but stays where it is (in whatever layout I was in, in File A). Could someone please explain the underlying design feature of FileMaker that is causing this. I would love to know, because my only alternative at present, is to duplicate numerous scripts in all the files I am using. Thanks in advance. Roger.

I've been lurking around for while digesting things here in the forums. I finally have encountered a problem that has me totally stumped with FM7 and it deals with summaries and layouts. I have a table of records, call it Table A, which contains "call" records each stamped with call creation dates and account IDs. I am trying to create a summary layout which will show, for a given date range, a single line summary that looks like: Date Total Calls Account #1 Total Calls Account #2 Total Calls Account #3 In other words, no detail records, just summary. Almost like a pivot table view. I can easily generate a detailed report that lists the detail …

Whats the best way to keep a current running total across records when entering information in a different table? Confusing description, I know. I have a data entry table and a data storage table and the storage table stores the actual line item records created in the entry table. So I'll only see one record in the entry table while I have 10 created (from new line items) in the storage table. It would be great if I could see the running total of the records in the storage table while I am adding new items (to the layout that appears in the entry table). I have tried a summary field for the other table but it only shows me the current total for the page i'm on, and not al…

Why does FileMaker, even in version 7, continue to use the old style radio buttons, check-boxes and drop-down menus from the "Classic" Mac OS's. Under MacOS X the style of these things changed completely, and FileMaker's own GUI does use the new Acqua style. So why aren't these styles available to database designers? Or are they available, and it's a setting I have somehow missed? cheers, Richard

Have created a very basic database to keep track of DIY expenses. I've created separate layouts for electrical, plumbing, etc. Each layout is identical except for the receipt number, vendor (a pop-up menu), and the date. Although the other fields are identical they all have unique names, such as: elect_cost, elect_qty vs plumb_cost, plumb_qty and so on. The database works fine except for the following. When viewing, for instance electrical, I do see what I entered into electrical, but I also see partially filled records which are actually from the records of other layouts such as plumbing or other layouts. The fields that appear with data the 'vendor', 'date' an…

Hi, I was wondering if someone could explain how something works in the ContactsManagement Fm7 sample. When you do a find on a contact, a list view will appear and display all your matches. You then can click on one of the items in the list view and it will take you to the form view. What makes it do this? How does it know to go to that view? I have tried to somehow select a part of the listview in teh layout mode to determine what is special about it. thanks for your tips in advance, sincerely, J__

Hey everyone, I hope I can find an answer to this. I have the main layout, which has a few fields. What I'm looking to do is have a specific layout automatically created everytime I enter data into a specific field. IE: I have fields for 10 colors set up. If I fill out 1, I want another layout (will have diff fields and setup than the main layout) to be instantly created & some data taken from the main layout and copied over (except for the diff fields of course). So, if I fill out 10 colors, 10 layouts should be created w/their info. Is this possible? How would I even go about doing this? It's easy in Excel, but I can't seem to figure it out here…

Hello out there Well

I am looking at a database in browse and layout modes and can't see the layout menu even though each layout is checked in layouts> layout setup and in Layouts> Set layout order. In layout mode > View > show status is greyed out; what gives? What setting needs to be changed for the layout menu to be seen again?

Greetings Folks, I'm wondering if anyone has seen the problem I am having with find requests - I have a script with a "Perform Find[Restore]" where the find request consists of Client::ID[1] (ie. Client::ID = 1). The script works fine when initiated from a layout in the file where the Client table is, but doesn't appear to work in a layout based on the same Client table, in another file (I'm getting a 508 error). Aaagh !

Is there a way to view more than the first page of a report when in Preview mode if the Status Bar is hidden?

Hi all, My first experience with FM is really good and I was able to work myself without the help of any guide or book towards a solution required by my employer. I just can't figure out something... I have created a layout, a standard letter containing multiple merge fields. However, I would like to edit these letters in BROWSE mode to be more flexible, edit it directly and then print away. I know that this is not possible, but editing in LAYOUT mode gives me a headache since one cannot see the final outcome without switching back and forth with BROWSE or PREVIEW mode. I also tried copying the text in PREVIEW mode to edit in MS Word, but it is copied as an imag…

I'm a newbie ... Have a simple database for submitting entries (IWP) for a gallery showing. Fields are name, title of piece, size and price. Each person can enter five titles (with price and size). The titles, price and size fields are all repeating. I want to create labels for each title (with the artists name,etc.). I've used the get repeating field function to set up layouts for titles 2, 3, 4, & 5. This is ok unless a person has less than five entries; at that point my label layout is creating (wasting) a name label. How do I create labels for only the titles submitted ... and leave out labels if repeating fields 2,3 and 4 are empty (for example)? t…

What is the easiest way to display the number of records found out of number of records on a layout? Found: 56 Total: 6,789

I want to open a new window to ie. edit or insert new Customers, and i don

hi - i'm a documentary filmmaker and am developing a database containing very lengthy transcriptions of interviews. Instead of splitting up the 30 page word documents into seperate records within FMP, is there a way to make multiple pages of the lengthy transcription under one record? i'm not sure if this is an easy process, but i just haven't been able to figure it out. what i'm trying to avoid is having a page that's 50 feet long! edgaroso

I'm trying to get FileMaker to display calculated values in the color I picked through FileMaker's TextColor function when I display those in fields on layouts I created. For some unclear reason, the calculated values appear in black only, and only show color when I click on them. Is there a known workaround to this? I couldn't find information on this anywhere. Any hints will be much appreciated!

I have this old database for some clients who use it for printing stuff like envelopes and badges. I have rebuilt the database and copied most of the layouts over with the exception of the layouts that print envelopes, badges and other non standard paper stuff. My question is: Is there a way that I can copy the layout from one file(call it one.fp5) to another(two.fp5) and save all the printing margins and settings and what not? I have tried the simple copy and paste method but the printing comes out wonky. I would like to get this done since I am 1000 miles away from the paper and don't know the models of the paper or the envelopes. Help out! Andy

in layout mode, i can't seem to position/size boxes and lines exactly with the size info box. for example, when i type a field width of 1.35 cm, it snaps to 1.341 instead, grid on or off does not matter. the set rulers command also snaps entered values to something else. putting several objects in a row, this creates quite an error, i.e. after 11 objects like this i'm off by an entire field.

Hi! FileMaker 7, OS X 10.3. I'm new to complex FMP databases. I'm working on a project management solution for my company; it will replace a very heavy Excel file that takes 5-10 minutes to calculate, even when it's empty. I have a projects table, another one for phases and a trio of tables that contain detailed expenses related to each project and phase. The first table is for budget figures, the second keeps track of engaged expenses (for daily expense tracking) and the third is set to import data from the accounting department (to get final numbers). These expenses need to be coded according to their type (4405 for post-production fees, 6208…

I just learned a neat technique that I've never run across in the Forum. To produce subtotals that run across a page, rotate your total fields to print vertically. Align these vertical fields tightly together, and you can get something like the following without having to use GetSummary Total for April May June Cost 1100 4705 3100 Profit 540 660 225 The labels on the left go in the footer (also rotated vertical) and fields for month/cost/profit (in this made-up case) go in the sub-summary. Obesefeline

Please help! Is there anyway to "freeze" a column like you can in Excel, so that when I scroll over to the right, my first column will stay put? Thanks

I always work with object size box displayed (and px size). Occasionally I get two funky problems I can't identify and ask for assistance on it. Text field 175 px wide, font size 13 Verdana. Usually, I can select Format, Line Spacing, Custom and change the left indent to 5.00 px to move the text away from the border but now I get ... 'The left margin cannot exceed the right margin or the object's boundaries." Indent Left 0.00 px, Right 0.00 px, align left and no tabs or anything else set. But when I try to change left or right indent to 5.00 px it refuses - only on occasion like today constantly. The other problem I occasionaly get (and did again toda…

Hi, Is there any way to use a "Loop" construct to loop through all repeating field indices and (for instance) set them to "". I am currently doing the following: Clear( Select; Table::RepeatingField ) Clear( Select; Table::RepeatingField[2] ) ... It will be a pain if the repeating field has 100 items in it ! Thanks.

I would like to be able to divide a single layout into four pages for viewing and printing purposes. I envision scripting a button that will navigate the user to each corner of the layout. When they get to the specific corner they want, it should fill the screen as though there was only one layout. Does anybody have an idea how to do this? Thanks, Jarvis

I'm creating simple subsummary reports including a CounterSum field, to get numbers of items within various groups. Not a big issue. EXCEPT that when I start a new layout, blank, and add the subsummary parts, the printout is leaving somewhere around 5 pages of paper between the first line and the next one... and the next... etc. If I dupe an existing layout and just change the subsummary definition and fields, it prints right. There is no difference between the new one and the existing one, except that one prints right and one doesn't... This may be the first time I've added new layouts since I started using Filemaker 6, so that may be part of this. I've tried recovering …

I notice that even when using cross-platform typefaces like Georgia and Verdana, some text-intensive layouts do not display the same on both platforms. It seems to focus on line height - a block of text laid out on the Mac, with a number of line breaks in it, lined up niecely with other fixed elements on the page, will not line up when displayed on a Windows machine - the line heights show up as higher, so the text runs longer down the page, not lined up with the fixed elements. Sometimes I can work around this by making each line of text its own text box - but when users are contributing text to a large field, I can't go in there breaking things up into boxes -…

I'm trying to indent the second half of a line without also indenting the first, so that the end result - doesn't (can't do it here either) ---- look like: Category: datadatadatadatadatadatadatadatadatadatadata datadatadatadatadatadatadatadatadatadatadata datadatadatadatadatadatadatadatadatadatadata So I'd like all the data evenly indented to the right, leaving space below "category." The problem is, every time I indent part of a line (data) the whole line (including the category) is indented. Any ideas?

I modified one of the templates that comes with FMP 7 - I'd like to use it in a different Filemaker database. Is it possible to do that? thanks!

Just been using FM for 1 month, so sorry if answer is obvious. (Using FM 7 on WinXP.) I have a DB with two related tables - People and Stuff. They're related through a person_ID field. Each person may have zero or more "stuff" records. I want to create a list report that will give information about a person (e.g., name, address) and then one line under that info for each related "stuff" record. With subsummary I have done that just fine, using the person_ID as the break field. However, my users don't want the order of the report to be by person_ID - they don't know or care what the ID's are. Rather, the report should be sorted by the LastName field of the Peop…

Hi - I've just installed FM6 on my new machine and I now seem to be missing some of the Avery labels from the labels layout. The full list showed on my old PC, but not on my new one. Can anyone help - this is the first time I have used a forum - hopefully I'm doing it the right way!! Thanks, Brenda

I'm creating a layout to print a sheet of Avery 5160 labels. FileMaker Pro 7 can generate this layout for you automatically. But when it prints out, the last row of labels doesn't get printed. It is as though the bottom margin is up too high. Anyone have any experience with this and/or a solution?

Hi everyone. I'm having a little trouble creating a layout. Maybe it's just Friday and I'm burnt out :-) ...or maybe I'm going about this all wrong. Either way, I need a little help! Here goes... I have a Notes table containing client notes. This table relates to several other tables including a Clients table and a Users table. We don't need to worry about the Clients table right now. Notes can serve as tasks by adding a due date. If there's no due date, a flag defines the record as a note. If there is a due date, the note becomes a task. When the note becomes a task, it must also have a task owner. This is how the note record relates to the Users table. …

i was just looking throught the business tracker to get a first look at some filemaker 7 solutions. I'm still not that impressed with the fact that you don't seem to be able to have frames. i.e have a single top menu and a frame below that which you can use to navigate to different layouts to via the menu ...or have I missed something and this is now possible? Does anyone have any good demo files that show off some of the new things it can now do over filemaker 6?: Thanks

Hi! It's been a while. <sigh> RL can be a pain <lol>! I'm still with the calendar popup problems of always. I was hoping to finally get this resolved. All the good calendar popups seem to be shareware, naturally. And of those freeware ones posted by kind people one or two seem like they'd be almost as good but coding them into a solution has always been a severe problem for me. I have never, in all these years, been able to figure out how to get one to work. Is there any advice anyone can give and a freeware one they can recommend that a newbie can handle? (A URL if known would be really neat, too.) It's a tall order, but one of my so…

http://www.nightwing.com.au/FileMaker/demos1.html on CobaltSky demo for highlighting it involves basically entry in to a field for the highlight to activate - this makes the record locked - is there a way of doing the highlighting but not locking the record once it is highlighted? Any ideas??? Thanks

I am having a devil of a time getting my records to layout in the fashion we require for our proposals. When I use list view it doesn't summarize the records by room but rather lists them individually. I put a portal in the body and it summarizes by room but then only shows one room. I have attached a graphic example of what I'm trying to achieve (.jpg) i would appreciate any ffedback that anyone may be able to offer. This ones been a real headscratcher for me. LOL

I have been trying to get a subsummary report to work all day long. I want one field to head a group of all the other related records. LIke a heading. I know you have to sort to get it to work but it still isn't. Are there any other suggestions? Stan

This may be basic, but I can't figure it out. The browser/layout page size defaults to 21cm wide in accord with my printer settings (A4 size), which is about 600 px. I want to set it up for typical screen use which means 800 px would be reasonable. I don't understand why I can't just grab the edge of the page in layout and drag it to the size I want. Is that too much too ask? It would seem so, as the only way i can find to do this is to change the print setup to landscape format instead of portrait. This is an unsatisfactory workaround, as it relies on the printer to set the screen size. Is there a better, simple way to set screen display size…

Hello. I am new to this forum, and I have a question about FMPRO 6. Currently, I have repeating fields setup where I populate all of my data. However, sometimes not all the fields will be used. I want to make a layout where it will check the value of a checkbox field. If the box is unchecked I want the data across that row to show up on my report. If the box is checked I don't want the data to show up. Also, sometimes I will have all 10 rows populated, but some of those fields will not need to show up. Thus, I don't need to have all 10 of the rows in my layout taking up space (prepping for the worst possible case). I need it to be dynamic, and depending on how many …

Has anyone had any success with writting a script (or maybe thee's a built-in function I'm not aware of) to get FM7 Pro to open everytime on a specific layout, irregardless of the layout it was closed on. I am trying to get it to open to a "main_screen" layout each time it is opened by a user. Any feedback would be appreciated. Thanks,

I need a report that will display data in columns. Since the data I am reporting is in a summary field, how do I create columns? Unfornuteatly, I am trying to duplicate an existing form so I have little flexibility. Does any one know the answer?

I have a form that prints out in a letter format. The data is a sum field of 15 fields and compiles all the date from those 15 fields. I have a firm created for print view but sometimes the data is longer than one page. How can I get reports to print in letter format when the data is longer that one page?

Hi, I'm new to this post, and only familiar with filemaker and had a strange question. I'm currently maintaining a database that allows a variety of different users to input data. One of these users at some point inputted data into alot of records by cutting and pasting from another document. The consequence, the text in certain textboxes is not the same font as the rest of the text in the layout, and the rest of the records. These records are few and far between, so I'd prefer not to change them back by hand. So, better explained: The textbox on the layout is formatted for Arial Size 11. The text that was cut and pasted was done as Lucinda Grande Size…

I'd like to set up three layouts to print as letters, to be sent out when a payment hasn't been received. However, I'd like to give end-users the opportunity to rephrase the letters if they'd like, rather than stick with the default I provide. So, some kind of setup screen, where you fill in a global field that contains the message body. However, the message will probably be something along the lines of: "On referring to our records we note that your account remains unpaid. The amount outstanding is <<patient bill>> We would very much appreciate if you could make arrangements to settle this account as soon as possible." Is there a way to…

Is there anyway to add scripts to a portal in a list view? I have a list of contacts below and above I have a portal of companies related. I want to be able to click on a company in the portal and run a script to go to that info? Any ideas? Thanks

I hope I'm not wearing out my welcome by posting so many questions, but here's yet another one... I'm designing a participant tracking database for a study I'm running. Some of the information to be tracked is: Name and contact info (phone numbers, etc) Date they contacted us Date we called them back What meds they're being prescribed Appointment times I've designed my tables and done the related rows thing, etc. I'm not having too hard of a time doing that because my needs are pretty simple. What I'd like to be able to do is have a "start page" of sorts so that when the database is first opened, the user gets a list of options. Right now I'm u…

Hey everybody! Hope everything's funky with you. I've got a question, hopefully somebody's done this before. Here goes: To save paper, is it possible to take 2 separate list reports and put them on a single layout, one in the upper half and the other below? Both list reports, done on separate layouts, change day by day, but consist of ten lines each at the most, so more than half of the page remains empty. I'd like to kill two birds with one stone, if you know what I mean. Something like this: (Header) (Body) ------------- (Separation) (Header) (Body) (Footer) I sure hope it can be done. Here's crossing my fingers... Thank you.

I have 2 files that contain sales information for our customers for 2003 and 2004. In each file i have created a layout with summary fields that sort the sales so that we can see how much in sales each customer has purchased per manufacturer. I would like to compare the summary information in each file (comparing 2003 to 2004), but am not sure where to start. Is this possible?

Hi! I'm trying to figure out how I can shrink a layout to fit on one page. When I go to Print Properties and reduce (fit to page or custom), the records get smaller but no more of any individual record fits on a page (and no more records fit on a page). Does anyone know how to shrink a too-big layout to fit on Letter Portrait?

Any suggestions on how to change a specific graphic based on a field condition. Here's what we're trying to do: I am creating a project management database which will catagorize projects into various "stages". We have a number of unique graphics which represent the various stages of the project. Based on the stage of the project which the user chooses (drop-down list) the graphic at the top of the PM layout changes. Any suggestions on how to accomplish this ? Thanks, Stephen

In my Master List, there are various records that are "leaders". I have a "leader" layout that provides additional info on leaders, but that is only relevant for those records that are "leaders". How can I make this layout available ONLY to those records that are "leaders". I want to be able to browse through this layout and see only "leader" records. I know I can do a find, but that filters records for both my "leader" layout and my "master list" layout. I also considered making the leader layout unavailable in the menu, and having a go-to button available on ONLY those records that are leaders. Is this possible? Can you have a button that appears on a record cond…

I am building a dbase for my school and would like to have a statistics layout that reflects some data such as; how many male/female students (gender field is a value list); what ethnicity (again, value list ranging from 1-5); how many kids have IEP's; and so on. Administration wants it to kind of look like a spreadsheet, but I am having all kinds of trouble just getting the correct numbers to show up...can anyone lend me hand? Mark

Ok, so I'm completly new to all databases and so far it seems Like FM is the best one i have found. However, I cannot figurre out some of my own problems. So here is the problem: I am trying to create a presenatble report for timesheet info. THat is this information is taken off of timesheets. So the main thing i am trying to do is add up hours. However, I have found no way to keep a running record of the hours so that it adds up all the entries. Maybe I'm overlooking it, but doe anyone have a solution so that i can take one field of numbers and just keep a running count? and

Canadians as well as those of the "British Empire" do things a little differently when it comes to postal codes. Our system uses 7 characters { Letter # Letter space # letter #} i.e. B2S 1L7. Having worked with MS Access I would simply format the input mask as "L>L >L>". As a result the data that I would enter would be displayed as shown in the example, even though the key strokes were small letters. Similarly when entering phone numbers with area code I would format the input mask as !(999") "000-0000;0;_ Are there similar formating structures in FM? space

Anyone know why, when I try to move a field or object on a layout by clicking and dragging, it duplicates itself and I end up moving the duplicate, leaving the original field irritatingly where it is? I've just returned to using Filemaker after a break of 2 years and I don't remember this happening before. I thought it only duplicated if you did Option-drag. Grateful for any advice.

Howdy. Got a 6 page FM layout that's: page one of mixed fields (text, number, calc), but then 5 more pages of text that is all in one Text field. However, in Preview, and in Print mode, there is only one page (the 1st one), and I can't figure out what I've done wrong, and what i need to do to engage or make the otehr 5 pages come alive. Any advice? daniel Version: v6.x Platform: Windows XP

I wonder if someone can help me on this. I have an field which I would like to fit exactly regardless of the text length. So if the contents are too large it would either shrink/condense to fit etc Would i need to include a calculation field so that when the text is over a certain amount it shows instead of the main field? thanks

I need to create a duplex layout with the back side set up for labels. It's the labels that is causing me problems. I've inserted my fields but when it prints I get a whole page of the same record instead of a different record for each label. Any help? Thanks garrison

How can I center a window on the screen when it opens? Is there a calculation I can use or a script I can run that can figure the size of the screen the user is using and the Move/Resize Window appropriately?

I have a multi-user database that has been used by my company for several years. i did not create it however i have modified it several times. we use it to print all different types of labels. Lately a curious thing has been occuring. While i am one of the only people to have the admin password (and the only one to ever use it) the font has been mysteriously changing on all the layouts. We all use macs here and it is a little frustrating because I have to change it back on about 50 different fields because our labels have to match our company profile using a similar font (Helvetica Bold), in bold style, size 14 and the font always gets reset to plain, size 12, Gill Sans. …

Hi Guys and Girls, Hope you can help me out and stop me looking like . I'm printing out some envelopes. At the min, when it's printing a title and first name i get Mr(GAP)David(GAP)Smith because i've put a " " inbetween the fields in the layout - which is all very well and good. When the person doesn't have a title though, the (GAP) is still there, and so pushes the rest of the name out to the right by one space. So my question is, how do i get rid of this gap when there isn't a title, but yet retain it when there is? I was thinking of making a field (say "Gap") that checks whether there is anything in the title field, and if there is putting a space into it…

Hi, Everybody! I

My company is trying to decide if we should upgarde to FM7. Right now we have FM5.5. Is it worth it to upgrade? What are the big difference between the two?

Hi, I have real estate forms I need to keep in original format. I would like to insert said form into a FM layout and then set fields onto the form so they show the database information in my data files. No luck trying to do this. My forms are in acrobat.pdf format now. Appreciate all thoughts and tips. If not able to do a form in FM can I somehow have a pdf document import data from FM?

Hi, I need to create a field where I can select multiple choices from a value list. I was using check boxes, but I am trying to limit the layout to one page. I need to either create a pop-up list that I can make multiple selections from or I need to create a check boxes list where I can hide the boxes selected. Is there way to do either of these things? Thanks!

I'm trying to make it so invoice totals only appear on the last page of the invoice. I have a field, gLastPageNum, which keeps track of the total number of pages before printing. I tried putting a calculated container covering the footer with the calculation, If(Status(CurrentPageNumber) ? gLastPageNum, gWhiteContainer, "") Where gWhiteContainer is a container in which I pasted a solid white rectangle the size of the footer (which I created in FM). It's not working. Am I going about this the right way?

I created a large, light-gray box and placed it at the back of the body's layout underneath transparent fields merely for aesthetics . When I place a portal over this box none of the fields show any data. Fields outside the portal and over the box revea their data. I moved the field in the portal front-most and made sure that it was solid (filled, I used "white" in my scenario) as well as made sure the portal was solid. Nothing If I make the portal tranparent, the first record in the portal reveals itself, but no others Maybe I need to figure out better ways to make a "nice-looking" layout -Jeff

I have a layout displaying a set of data (goals and objectives). In any given record, I may need different numbers of the same layout, e.g. one record may have 3 goals, another may have 12. Is there a way to add additional layouts on the fly? Thanks, Rick