Layouts

Hello all I have already created a detailed invoice layout associated to an invoices table with several relationships i.e. wholesale clients, invoice payments etc. A client required a packing list recently. All the information is on invoice. So i hightlighted fields not required and used Sliding Printing not to print those fields. Can i button be created and will automatically take data from invoice and create Packing List? I'm sure there is a way! Look forward to any replies. BFGK

I have a file with data entry page that frequently requires a look back at the reference information. I'd like to allow the user to open the reference files by using a button that opens a "pop up" window displaying the reference info. The reference info is tabular, text file, stored in a layout as a container file. Any thoughts on how to do this would be greatly appreciated.

Hi, I have a button on my layout which will insert the date and time, however it all comes in as one long line... 6/22/20071:04:51 PM Is there a way to add a space between the date and time? Thanks, James

I have been searching the forum for hours and have found many solutions to similar questions but none seem to fit my problem. I have a field on a layout. That field, Named Non-Active, is a check box with one value. I want to hide that field on the layout unless values in two other fields are met. Field A = x Or Field B = x Non-Active Field = Visible Otherwise Field = Invisible Very simple. All fields are in the same table and on the same layout. This is making me feel like a complete morron again.

Hello, Its been a little while since I posted last…everything is going OK, until now. I really need some suggestions on how to go about this new problem. I currently have a form that I would like to develop in FM. The form is a monthly calendar which has numerical stats for about 25 questions. Currently the form is laid out in Excel and looks like this (of course with the grids) NOTE: I cant get the example below to align properly…so if you will imagine that each bit of data is in its own grid in the Excel sheet (the numbers would of course be under the listed dates). .............. July 1 July 2 July 3 July 4 Question 1: 44 …

When you "Duplicate" an existing record, is there anyway to have certain fields made blank automatically on duplication?

I'm trying to work around filemaker's 12-page per record limit by having a separate report for overflows. I have a seperate input field with instructions to continue into the overflow input field if the input is past a certain length. This goes into a separate report layout that just has the standard header/footer, and this text field for the overflow. I'm setting up a script to print from the main report, then print the overflow report, by record so it prints out properly. Here's the problem: Even if the overflow field is blank (meaning the input data was less than the 12 page limit), I get a page for the overflow, which is blank + headers/footers. I don't want…

Hey all, I am adding several functions to an existing contacts database (this db is a perfect example of an 'angry fruit salad' database!) And my boss wants a scheduled call back layout that pops up at the push of a button. Now i built him a simple scheduled calls table and a nice little layout that pops up. Now the issue is that the layout in the background is resized when the layout window with the callbacks pops up. He wants me to make the button that opens the callback window make the window 'float' on top of the other table, so that no matter what, the main contacts db is maximized in the background. I do not know how this is possible. But he swea…

I am a filemaker novice, and have finally come to the conclusion I probably won't figure this out by myself... I am creating a lighting audit database which records existing location information pertaining to light fixtures. These existing locations are then analyzed and new, more energy efficient light fixtures are specified. I have created an existing (EXI) fixture table, and new (ECM) fixture table to record all of the details. I have also created a location table, which will automatically populate a list of locations which can be matched back to a drawing or plan. It is here where the specifications are decided. My problem comes when I try to crea…

Hello! I have a people-table that has the following fields; Firstname, Surname, ID, Salary and SalaryHistory. They are all text fields. Now I want to create a custom layout that allows me to modify my people-info. At the top of the page I want a drop down list that contains the first name and surname of all people in the list. When clicking a person in the list I want the layout to jump to that person (record) in the table. The drop down list should be read only, so that modifying people in it is not possible. The layout will have fields for the first name, surname, ID, and salary for each person. It will also have a button named "update" that actually comm…

Changing the vertical size of a layout seems fairly simple (click and drag). However, I cannot figure out how to adjust the horizontal size??? Thanks

From the other threads, I've put together a script that will automatically find records between two dates using fields (startdate and enddate). I would like the script to be executed automatically when the user changes the dates. To accomplish this, I tried making the field a button that executes that script; however, once I added the script to that button, it no longer allows one to type in to the field. Instead, it seems to just keep executing the script every time I put the cursor over the button to type. Is there a way to allow me to enter my date in the field and then automatically execute the script when I tab on to the next field? Thanks ahead for responses, B…

I do not want a field to be able to take in more sentences than will show during printing. How do I limit the field so that it doen't keep expanding as someone enters data? Thanks,

Hello, I am having problems printing barcodes in landscape on the page. If I print in Portrait, the barcodes are crisp and thin, in landscape they are thick and blotchy. Is there a fix for this? I 've tried two different True Type fonts, same results. Top is printed in Landscape Bottom is Portrait

Hi. I have 2 report pages (Browse;List) that look almost identical other than one has a Footer and the other does not. In the body of both these pages I have a list of records, and on the footer of the second layout I have details of the record. On the header I have a button that Hides or Shows this record detail, and it just switches between the two layouts. Rather than having two layouts, is it possible to view/hide the footer on the layout, or do I just leave it the way it is. Its just that if I make changes to the layout (database still in development) I have to make them to two layouts rather than one. Anybody got any ideas please? Greg

While beta testing my app in vista, I am told the colors and graphics convert to a basic scheme and look like crap. How do I fix this issue, or is there even a way to fix this issue? Thx :o

I would appreciate some input. One file, two tables, there is similar data in each table. I can generate a report for one table easily, but is it possible to follow the record listing from the first table with the records from the other table? (Note: it is a design reason to split the "category" tables) products.zip

Hi all, I'm a novice+ FM 8.5 Advanced user and I just became a victim of the "your Filemaker prototype is actually more dependable than the custom application we run part of our department on" syndrome So, long story short, I'm stuck with the following scenario: I have a daily medical consult table constructed with the following relevant fields: patient ID, date, doctorID, sex, ailments and treatments. Both ailments and treatments are one text field each that can contain multiple values through the use of a checkbox list in the interface layout. Now I have to make a report like this: Date range | sex | doctor ID | ailment1 |...| ailmentN | Treatment1 |…

I am supporting an FM 7.0 database that is a company manual that flips between layouts in a fashion similar to hyperlinks. It is used almost exclusively in browse mode. Unfortunately one of the dynamic reports I had to create in this "manual" requires a header part. The layout is meant to display in a way that mimics an 8.5 X 11.0 sheet of paper. Unfortunately the boundary between the header and body part creates a line that shoots off to the right for the entire length of the layout spoiling the image of the page. Is there anyway to hide this unsightly line in browse mode without removing the needed header? Thanks.

Good Morning, Just when I think I'm getting somewhere...It's back to where the true knowledge is! I have a set of data where my boss is asking for a report that if it is possible in FMP I don't have the slightest idea how to do it. In Excel, this type of report (Pivot table) is a snap. My Fields are: Customer2 (GreenGrass, Corporate, Retail, BigBox, etc.....) deLogo (I need to create a sumField Count of deLogo) the Months will display the Count of deLogo. I Then need to build a report that looks something like this: .................January.....February.....March.....Etc. GreenGrass.100..........132............432........999 Corporat…

FMP8 Adv, WinXP The Background: Layout 1 in Table A (Students) shows a student record along with a portal which lists the assignments selected for that student. Layout 2 in Table B (Assignments) shows the same student record and a portal listing the complete list of more than 1000 available assignments for the course. As assignments are selected from the portal in Table B for that student, they show up in the portal in Table A for that student with a checkbox in each portal row to be checked when the assignment is completed. The Task: I’d like to create a popup window that shows the assignments for that student (checked and unchecked) from the po…

:o Ok so I am brand new to this program. I need to make a database of test results. I need this to have 2 pages then I can get to by pressing a "Page 2" button or "Back to Page 1" Button. I am not sure how to get multiple pages though. I figured out how to get 2 pages in the preview layout but I need it to be 2 separate pages in the browse layout. If anyone has ANY guidance it would be greatly appreciated

... Okay so with a field you hold down control and click a de-selected field, is there any way to set the default appearance for a label?

Hi: I work at a school as a DBA and I am trying to create a cummulative report for each student graduating 8th grade. I have a 'People' table that has a 1:M relationship with my 'Student Roster' table (each current student People type can have many related student roster records)...The 'Student Roster' table has a 1:M relationship with 'Class Roster' which has a 1:M relationship with 'Classes' table ('Class Roster' table acts as a Join table between 'Student Roster' and 'Classes'). Basically I am trying to Display, on a single layout, multiple student roster records and related grading info. Any advise would be greatly appreciated... thanks …

Hello, I'm fairly new to filemaker. I've had to take over use of it in the current company I work for, as its the customer database program my boss has been using for about 15 years now. I had no experience with it when I started here, but in time through the help file and such I've learned alot. Whats stumping me however, is when I want to print a collection of records. It treats every record as a separate page. Even though there is room to fit at least 2 records per page. My boss obsesses over paper costs, any help you can give on how to set up filemaker to print this way would be very appreciated. thank you!

Is there any way to indicate if a text field has more text in it than is visible on the layout? e.g. build a little script field that can tell if the field has hidden characters and show an indicator. Thanks in advanced for any ideas or hints. Anatole

I've taught myself the basic and advanced concepts in filemaker pro, Masted most of them. The only problem: Lack of layout experience. I have purchased the Theme Library 3 from scriptology.com - it is a great start, but actually applying it is a bit challenging. Could someone point me in the right direction for how to make better and more efficient use of my space? I have taken several stabs at making a proper fmp database for my company and have always hit the brick wall when it comes to the interface. I get many criticism and have to rebuild them half the time! Thanks in advance!

I'm using Filemaker to compile a printed report of many different records. One of the fields contains large blocks of text. I would like to have this field in the layout/report change size based on the record data, and information after it to change positions based on size. That was probably unclear, so here's examples. If the data in that field is just a short paragraph, it would stay on one page, and whatever is after it would show up right after it ended. If the field data is very long spanning several pages, then filemaker should (instead of cutting it off at the end of the page like it does now) continue on multiple pages as it needs, then place whatever is afte…

Hi, I have two fields on my screens that act as titles for that page. They are global and as I move to each page with those fields on them they are set to the screen name, and the description of that page - thus allowing me to keep my layouts fairly universal. Anyhow, when I go to these screens and Set Field for the values they are to display, they stay in a mode that appears as those the field has just been entered. I have tried various things to "move" the focus off that field and whilst the cursor moves the field stays in entry mode. Can anybody give me a tip here please. Greg

This is my first database, so I suspect the solution will be obvious to somebody. I set up 4 tabs and then I entered fields within each of those tabs. Everything looks just fine when I am in layout mode, but then I switch to Browse mode and each tab contains all of the fields from each of the other tabs, resulting in a big mess! Any suggestions as to why this is happening and what to do about it? Thanks ahead for replys.

I have a field that holds the lyrics of a song. When printing/previewing, I want the lyrics to be all on one page. But some of the songs get cut off. Is there a way to split the text into two columns on the same page?

Here is my problem and I cannot wrap my head around it... I have about 3000 sites in 6 States that need to be visited in certain intervals (About 10 times a year each). I have a sites table with all the information and a visits table, both are related by site number. The sites table actually has a field that counts how often a site has been seen. What I want now is a one page summary, per state, giving me a count of how many sites have been seen once, twice, three times, etc. I have something along those lines where it list every site in that fashion, but that turns into a 200 page report, where all I need is one page. Once I remove the body of the layout - it no lon…

Need some help! I have a db w/ multiple layouts. I created the attached layout the other day. It is a letter using merged fields. When I go to the layout in the browse or preview mode, it looks excatly like I want it. Then once I hit the print button, the screen changes. I have attached a before and after screen shots.. The first 2 pages are before the 2nd two are after.(The printed copy looks just like the screen after I print. But only part of the page prints.) I have tried printing using a script, and by going through the file menu. Happens both ways. My guess is this is a simple solution, but it is driving me nuts!! Any help would re…

Two of the tables I have in my database are a Budgets table and a Budget Line Details table. They are related by three fields, Fiscal Year, Location, and Funding Source. I have a layout setup with Budgets fields above a portal to the Budget Line Details table. Everything works and looks fine on the data entry layout. What I need to is setup a print layout that will let a certain field on the line detail portal called Projects expand or shrink with what is entered. I tried setting up a layout with no portal and repeating fields for the detail portion but I only get one line of detail for each record. What am I doing wrong? I understand you can't make portals shrink f…

Hi I have a layout that opens in Find mode, it has a field called "Status" that has a pop-up and uses a value list. In find mode I get a message "No Values Defined" but in browse mode I can see the pop-up list. Can anyone tell me why this is happening? Status field is a text field. Thanx

I'm trying to insert page numbers by record. That is, they start at 1 for each record and increase until the end of the record. Next record starts at 1 again. Can I do this?

I created a layout using the report wizard and I had the wizard create the script for printing. Question : the script puts the layout in preview mode. I tried putting a button on the layout but the button can't be pressed in preview mode. How does one go from preview to the ability to PRINT it out?

We have had FM7 and in myt scriptsteps I have created new windows and put them outside the screen so that they are not viewabale by the users Possision -100 for example in the New Window script step. Now in Filemaker 8.5 this doesent work, and that makes the the new window pop up viewabale to the users. How do I hide the windows? Regards Jocke

Not sure if this is the right place to post it but here it is: Some of my layouts are quite long so that they need to be scrolled down in order to see everything. The problem is that people are used to scroll up and down with the third mouse button or click wheel - whatever you call it. In FM it scrolls through the records and not up and down in the layout. How would I disable that mouse button or make it so that it scrolls up and down it the same layout and not through the records. Thank you.,

This seems like an incredibly stupid question- but I've pored over the forums with no luck. How do I change/add the label of a button. I created several layouts containing buttons that, when viewed over IWP, are only clickable in the blank space - not the area of the text box. I figured out that creating a button with the button tool fixes this problem- but I don't want to recreate 20 buttons.

I have tried everything possible in my knowledge, I red a lot of manuals but the problem is still there. You can see it from the enclosed PDF. Sorry is in Italian language, hope it can be clear anyway. This is an invoice, the problem stands on the bottom of the page. The Blue and Gray stripe shouldn’t be there but on the next page, but it doesn’t. This stripe is placed in a “Summary when sorted by” part and represent the title of all the subsequent lines that are on the "Body" part. As you can understand the stripe lose its meanings (title) if it is separated from the lines below. Would be enough for me, to have also one line of the "Body" part, that now is in…

After using FMPro4 for years on XPPro, all of a sudden (no apparent reason)changing page orientation from Portrait to Landscape won't hold: on screen it looks landscape, but prints in Port. and when I look at page setup again the setting has reverted to Port. Also, then FMPro "suddendlly" quits. Happens with networked files, and local files. Different files too. Any idea what's up?

Can anyone tell me what is the maximum number of fields that will display in Table View? Is this user definable? Thanks Steve

I use Helvetica 9 pt extensively; even have a QuicKey to turn everything in a field to Helvetica 9 pt because it was a comfortable and compact size. When I went up to 8.5, I can hardly read that size of font because its so teeny weensy! In fact, all my font layouts that use Helvetica are screwy. What happened? And can I get back to where I was - font size wise? Appreciatively, Elaine (I've used FMP since it came out & never had this happen in an upgrade)

Could someone please explain to me whether the following problem with summary fields is due to 1) how I’ve (mis)designed the database (should it be multiple tables instead of the current single one; if so, how should the tables be designed), 2) how I’ve designed the summary fields, 3) both, or 4) something else? If the database needs redesigning to fix the following problem, how can I incorporate reporting grand totals for each fiscal year in addition to totals for each month? The goal of the database is to track numbers of events and participants at each event, summarizing these two quantities each month and each year for each of seven categories of participants (“a…

Is it possible to have a text field slanted, say, 45 degrees? I'm still pretty new to FileMaker and was hoping someone out there could give me a quick 'yes' or 'no' answer before I spend too much time looking for a way to do something that might not be do-able. BTW, if the answer to my question above is 'yes', I'd appreciate it greatly if you could also tell me how this is done }:(

Hi, I'm working on a report with 2 Sub-summaries and a Body. I need to get FM to reprint the Label after each page break and add „continued“. Eg. USA Los Angeles Joe Miller Joe Miller Joe Miller Joe Miller Joe Miller Joe Miller (Page brake) Los Angeles continued Joe Miller Joe Miller Joe Miller Joe Miller Joe Miller NC Joe Miller Joe Miller Joe Miller Your help would greatly be appreciated. If a demo file is required, please let me know. Regards

Hi In filemaker 6, i was in a field and with my mouse button i was able to scroll record by record to compare data... With filemaker 8.5, i am not able to do that, I have to click outside the field and then I can scroll... does anybody have a solution for me?? thanks a lot

Hello, I recently upgraded from FM7 to FM8.5 and now many of my reports are printing incorrectly. I did a bit of sleuthing, and it appears that the line spacing settings are slightly different in 8.5. Single-spaced lines are bunched closer together in FM7 than the are in FM 8.5. The upshot of this is that the text on many of my layouts is now getting cut off when I print it (and when displayed on screen). I can go in manually and adjust the line spacing height from 1.0 lines to, say, 0.8 lines (in Text Formatting > Paragraph > Line Spacing), but this is really tedious and would have to be done in ALL of my 40+ layouts. Is there something I'm mis…

Hello Here my problem, I use a time sheet with hour_start and Hour finish field... when I type my hour I HAVE to type 11:00 but I want to type 11.00 is it possible and if it is?? HOW Thanks a lot

This may be a simple question, but I haven't figured out the answer yet... I made a subsummary report, that is grouped together by team member. It looks very good, except for when someone's info extends onto the next page, then I cannot tell who's data is on the following page. For example: John 5/27/07 6 hours 5/28/07 6 hours Sam 5/26/07 4 hours 5/27/07 4 hours 5/28/07 4 hours 5/29/07 4 hours 5/30/07 4 hours (pretend start of next page) 5/31/07 4 hours With a subsummary report, how do I get the person's name to show up on the next page, above their hours? Alisun

Is there a way to make a particular field entry accessible or inacessible based on another flag field? Or better yet, is it possible to make layout items disappear or appear based on the flag? Let me try to explain. I have a layout on which a user will check "Yes" or "No" on a flag field with radio buttons. What I would like to do is make another field box either disappear or become inacessible in browse mode if the flag field is "No", and conversely appear or become accessible if the flag is "Yes". However, I'm not sure how to approach this problem. Any nudge in the right direction would be most appreciated.

I've figured out how to hide the status bar and the tool bars but I can't figure out how to hide or deactivate the tool bar at the bottom of the window. Particularly the button that lets you switch between Find Mode, Preview Mode, Etc. (directly adjacent to the zoom buttons) I know this seems like a small thing but some of the people I work with can destroy a database by walking by a computer while looking at it! Thanks, Mel

I have a notes field that I want my users to view and be able to scroll BUT I do not want them to be able to enter the field to enter any data. It seems that filemaker will not scroll a field WITHOUT actually entering the field. I was hoping that I could create an up and down arrow (Buttons) that would scroll the field by script but my search has proven to be fruitless. Any Ideas? Thanx, Mel

Hi Gang, I have a small layout which contains a handful of fields. One of the fields is a "Drop Down List" field which shows the contents of a table with a very large number of records. This is a Global field that has no Autocalculation. I have it configured to "Auto complete from value List". The weird behavior is when I click on the desired value, the field gets assigned the value, but the drop-down list drops down again. I have to click on an empty area of the layout o get rid of it. I tried setting the Tab layout order so it's at the begining of the order list with items following it, but it still does this. I tried setting it to a a Popup Menu behavior…

so i want to get rid of the sidebar in a database i'm making, but i'm running into a problem of being able to browse records that i have found in a search. is there any way to create a field that will show you the total number of found records and another one that shows which record you are currently browsing (just like in the sidebar)? i don't like the idea of giving up so much layout space for just a little bit of information, so any help with that would be greatly appreciated!

1. Can I do "4 up" printing? My current design calls for pages that are 1/4 of a letter-sized sheet. With columns I can lay out two 1/4 pages on a layout. Can I put two more pages below the first two? The idea is to print 4 directory pages on each letter-sized sheet, then cut it to get the 4 pages. Note that I am not using OS X's "n-up" printing, which reduces the size of multiple pages on each sheet. 2. Can I arrange pages in "folio" format (if that's the word)? For example, for a 16 page directory pages 1 and 16 would print on the first sheet, 2 and 15 on the next, 3 and 14 on the back of 2 and 15, etc. The sheets would fold together to make a booklet. …

Is there some special incense I need to burn in order to make format a layout to properly print out on Avery 8373 labels? This seems to work in WORD but will not align properly in filemaker. Page set up is set for vertical orientation. Scale is set at 100% Label format is selected at avery 8373. Any suggestions? Jarvis

When Mac users save FM reports as PDF, using Adobe Acrobat 8, it's okay. But when, they open the PDF and print it, Adobe 8 doesn't print the report and crashes. Anyone having the same problem? Thanks, Maria

Hi, I have a parent table and a child table. The parent table has a number key called CLID and the child table has a number key called CHID. In the child table I have a second number field called CLID so that in the Relationship I can link the parent and the child. On the Relationship screen it looks good, the parent and child have a one-to-many relationship. Am I doing ok so far? Then on the layout for the parent, I have a button which I would like to navigate to the related child records. So I went through the steps in the setup, related field, specify the record and layout, options: show only related records and match current record only. Is this right? It mu…

Newbie question here. Is there a maximum length/number of pages a layout can be? I've created a report layout that is pretty long and I've reached the bottom of the page and it won't let me expand the layout any further.

I have a rather simple database, created in FMP 8.5 and hosted through the 8.0 Server Advanced. I have the Guest account set up as read only and anyone accessing the database through the web only has access to the Guest account. They can read and peruse the database only. But the database has 5 layouts - only one of which I want IWP users to see. However when I go to edit the Guest privilage set the area where I can set layout access is grayed out. Does anyone have any idea how I can limit the IWP access users to just one of the five layouts? TIA

I have a checkbox field that I've defined with a button over it so when it is clicked it runs a script. The problem is when I go into Find Mode I need to be able to search based on this checkbox, but in find mode the button is still active so I can't directly select the checkbox. This is probably a basic question, is there a way to disable the button when in Find Mode? Thanks.

Hi I am not sure if this problem should go here or not. This is my case. I have a container field (g_graphic) that is defined as a repetition field from 1 thru 50 and is also a global field. This field holds all the images that are being used in the system. I added one image in g_graphic[40] ie, in 40th repetition. In browse mode, I clicked on the field, then clicked insert->Picture and then selected the graphic file. Everything works fine after that till I close FMP file. the image does not get stored in that field. When I reopen the file, the image is gone. Please help as I really need to get this image in there. I also tried creating a regular contained f…

Is there a way of implementing a modifier key for a button? I'd like to have one button but have it run a script differently based on the how it was clicked (control, option, apple/alt, etc) Thanks.

Hello, I am a total beginner. I have a layout which includes radio buttons. Then I started a second layout for a different table, and for some reason I can't get radio buttons to work anymore. When I go through the steps, I get a value list but no buttons. Just the list of choices, like this: Male Female Where'd those buttons go!!! I did it before so I know the instructions worked once, anyway. Thanks!

Hi there. I have a page whose Body contains a list (Browse; List) of some records. On the Footer of the page are more records laid out that display much more information about any of the single lines on the list above (when clicked/highlighted). As the footer section is fairly heft in screen real estate (half a 1024x768 page) Im looking to achieve a rollup effect. I want to be able to have a button (maybe on each row of the list, or preferably a single button for the page) that opens up the detail section only as required, leaving more room for the main list to display in. Is it possible to turn off viewing a footer on a layout dynamically? This is basically what…

Not sure how to give this a subject but here's what I'm trying to do. I've got a typical quotation system, separate header table contains name, address, date, along with subtotal, taxes, shipping, etc. I'd like to produce a layout that will handle multiple pages. The problem I've got is trying to only display the subtotal, taxes, shipping, comment, etc. on the bottom of the last page. I've tried: A) using a trailing grand summary but this floats. I can't get it pinned down to the bottom of the page. B putting these fields into a footer, but this means these fields appear on every page. I only want them on the last page. I can't 'count' the number of l…

Hi. I am looking to change the background color of a row depending on data in the row. I was thinking of using a technique like changing the text color based on a condition as a field, by having a background block behind the fields on each row and having it change color depending on the condition. My problem is how to identify it as an item in FmPro then change it's attributes as data conditions change. Is it a field? An object? A container? Anybody got any ideas please? Greg

Hello. I have a list of data that I want to display to users in Browse Mode, and I need to find a way to visually separate the sections of it when the date field changes. The best way I can think to describe it is that, when I build the layout with a sub-summary field that displays when sorted by date and contains a horizontal line, I get EXACTLY what I want - in Preview Mode. But I need my users to be able to interact with the data. I have found several references to making lines appear or other layout elements change based on either the number of records that have been displayed, or on some other criteria in the current record. All of the examples I've foun…

Hello group! I'm new to Filemaker and need some help that problably sounds real simple to all of you. I work for Public school sys here in Florida US at a school. Working as Tech Coordinator. I have my database of students in Filemaker, now I need to print certificates for 240+ students. I have the certificates scanned in a JPG format signed. How can I place that within Filamaker and place txt box so names can be imported? We use FMP 8.5 client and 8 server. Any help would be appreciated, thank you!

Hi all, I am new to Filemaker & was wondering if the following is/are possible: 1. Can you insert a field into a PNG image object via scripting dynamically in which the field is limited to the size of the object? -OR- 2. Can you insert a PNG image object into a container field that expands to hold the object at its original size using a script? I would like to be able to have a user pick a range of numbers that are then generated dynamically onto a precisely printable form into label boxes & I was thinking that using an image object of a certain size would help in avoiding expansion/ collapse when printing (having set the margins to 0). …

I have a file that includes a variety of multi-line fields that aren't wrapping entire words but rather are line breaking within a word. The words aren't hypenated and there's nothing unusual about them. It's happening for every word that should wrap to the beginning of the next line. Anyone seen this? Am I missing a setting? Sound like corruption? Thanks

Hi Everyone, After reading some white papers and talking to other developers many people seem to be in agreement that supressing the Status Area is a good idea when developing solutions for distribution to people other than other FMP developers. I have programmed my most recent project that way and aside from some other things I really like the way it reclaims some valuable screen real estate. However, I find it confusing when "finds" are performed that result in multiple records being located. Does anyone have a suggestion for best method in displaying "found count" that will not be confusing to my users who might be wondering why the number of records k…

I have a layout that displays, in List view, a set of Invoices. Invoices are paid either by Cash, Check, or Charge. In the footer of the list I'd like to show totals by payment method, updated automatically as invoices are added. I could create three buckets in every record, populating the appropriate one with the invoice total, and create three summary fields, but I wondered if there weren't a slicker way. Thanks! Chap

I'm trying to create an ultra-simple invoice generation interface for people who may have never used a computer before. LaRetta's technique for highlighting the active field works absolutely great, and I'm most appreciative. I'm stuck, however, with making radio buttons look and act the way I want them to. There are three forms of payment: cash, check, and charge. They're arranged like this: O Cash O Check [#_______] O Charge [Purch.Ord.#________] As they tab through the interface (and I want them to know that Tab will always take them to the next field) I want them to "visit" Cash, then Check, then Charge. When they arrive at th…

I am a total newcomer to FileMaker... I have a layout and would like to add a portal so that I can add records to another table. So I walk through the steps to add the portal, but then when I go to browse mode, I can't enter any data into the portal area. I can change the tab order to include the portal fields, but in browse mode the tab never goes there. I must be missing something! Thanks!

I am changing some layouts made by a former employee at my company. I have modified the phone # field on our proposal layout and now when we print preview or actullay print the phone # shows above the field. Anyone know how to fx this? Or do you need more info? Thanks!

This is probably an age old question but I don't see an answer and can't solve it myself. Create a complex, multi-page report with sliding fields, how the heck do you keep fields from getting split in the middle at the bottom of the page. I lose an entire row of data to this problem most times. I've gone so far as to make sure everything was an even multiple of 18px so that if it did break, it would do so evenly--nope, no cigar. I still lose data and print drivers screw things up anyway.

I have a DB with approx 100 layouts. Recently when changing the layout order the moved layout's name changes automatically to the name of the layout above it. Is there a fix for this or is FM just being screwy. Poses some problems if you want to maintain a logical order of things in the DB ?

Hello, I have a team of people working on a project, and would like to have everyone's names listed on one layout, with a button next to each name called "Click for Hours". This would open a new window which would show their hours. I am not sure how to create a new pop-up window for each person. Any help would be appreciated! Alison

This is a goofy thing. Tried it in FM 7 and 8 with the same result. Defined a field on a layout as a pop-up menu. Menu behaves correctly in find mode, but not in browse mode. Any ideas of what to check?

Hope I am in the correct section. I want to use elements from one database in another. Is there a way to combine them? My goal is to have a form from one to become a table in another, complete with scripts, etc. There is no data in them at this time.

I have a layout with multiple portals in it. I've used sliding to adjust the portals to fit the information within them. Is there a way to eliminate whitespace between the individual portals (bring them closer to each other when they have less data and are shorter then originally set in the layout)? Never mind my newbie question. I figured out what I was doing wrong (not selecting all the objects that I wanted to slide at the same time and setting sliding guidelines).

Im having problems with getting the sliding function to work. I have attached a small version of the database Im working on. I have marked off the sections I would like to slide, based on how many extra fields have been added on the main layout. However, neither in preview mode, or when printing does it actually slide up. Am I missing something?? Any help would be much appreciated Legal_Database_Clone.zip

Hi, I am wondering. Is it possible to have a file such as a word document linked in a text box or container as a referance only. I want to make sure the database user is not given the option or cannot embedd the external file. Windows standalone. Thanks

I have many instances where this would come in handy but I'll give one example. I have a layout that everybody here has been using that displays all of a product's information on one screen. One particular peice of data displayed here is called Status (sold, returned, tech, rma, etc.) I actually have 2 status fields. One is a regular edit box and another is an calc. field that updates based on when that particular item has been added into an invoice. If the item hasn't been added to any invoices it uses whatever the regular Status field has. The problem is that all of the sales people want to see the calc. field displayed on the layout. They never have to ch…

I'm totally blanking here. I've got a table of Donations and a table of Donors related by Donor ID. I've got a found set of Donations, sorted by alphabetically by Donor Name. I've got a sub-summary part breaking on Donor Name, listing the Donor Name and Donor City and Donor State and a summary field of Total Donations. That all works fine. I just want to number each Donor on the sub summary section of the report, but can't figure it out. What am I missing? DJ

I'm sure that the answer is out there for this, but I haven't been able to find it (or one that I understand). What I want to do sounds simple to me, but I can't figure it out. I have some fields that are either YES or NO (currently set up as a drop down list). I would like to make it so if someone chooses yes the text or the background would go green or if they choose no the text or background would go red. Any help on how to do this? Thanks

Hi - I have a list layout that I was adding an active highlight bar to, following one of the demos on the Nightwing site. It was going fine - I had it working, and was just trying to tweak a couple of appearances of fields, and all of a sudden it stopped letting me switch to layout mode on that layout. I can switch on a different layout, but as soon as I come back, it goes into browse mode. I think it has to do with the zippscript that is part of the technique, but not sure why that should keep triggering and bringing me back to browse mode. Thanks, Michael

Hello All, I've got a database that tracks volunteer information and a related table that tracks the hours the volunteers put in. Each record in the related table only tracks the Department, Month, and how many hours they put in for that month (no date fields involved, strictly text and number). How can I summarize all of the hours for all volunteers (separately and all together), and also split up by which department the hours were for? I'm so confused, I don't know where to start! Thanks, Chris

Whenever I navigate to anyone of the last 8 layouts in my solution using the layout menus I’m always taken to the last layout. I have 264 layouts. If I select any layout from 1 to 255 using the layout menus, works fine. If I select 256 or any layout beyond 255 I end up on the last layout (264) every time. It’s the same in browse or layout mode. Is this a normal limitation of the layout menu? Thanks

In my FM database, I have a field for "quantity". It is only a number field. However, if that field is set to "0", I would like to have the fields named "price1" and "price2" set to "Call" and field "price3" set to "N/A". How can I do this?

can i change the border and background color of a field with a script or a function?:?

I have a table with many cells and id like to freeze some of them vertically as you can in excel, does anyone have any ideas as to how this is possible?

In MS Excel there is a simple command to transpose data. To do this you copy a row of values then perform a process called "paste special > transpose". Anything that was a row becomes a column and anything that was a column becomes a row. Is there a way to do something like this in table view? What I would like to have is my fields arrayed in column format with all the record values distributed horizontally across the page like a spreadsheet. In this example the text "CUT DOORS" etc would be a field name and the text A:B:C would be values for each record. This would give me a graphical spreadsheet to monitor production status. Any ide…

Hello, Is there a way to combine multiple tables into one report? When I try to use the Sub-Summarize By, the set up dialogs make this eem like it would work but when I perform the actual sorts I get results I do not expect. Does anyone have a sample they could post that would demosntrate such a technique? Thanks, Steve

Hallo, I have some fields, which I would like to display as (in) a table in the layout mode. As it is pretty difficult to arrange all the fields in a table pattern, I would like to now, whether there is a way to do that automatically in FM. I have the Version 6.0 Thanks Ralf

Hi: I have a problem:there are two table,it is T1 and T2.Now I want find(or filter) the data through "F1" or "F2" field in "T2" table.How to do?thank. Text.zip

So our lab is currently using FMP 6 and have been using our current database for quite some time now, however there are a lot of problems with the database right now and I am goign to create a new one. I was wondering whether or not it is worth upgrading to FMP 8 and if the features in it make it worthwhile to upgrade or not. Thanks for looking!