Layouts

Hi all, This doesn't seem like the most difficult of problems - after all there is a simple script step to do it, but for some reason my script that looks like this at the beginning: Enter Browse Mode [] If [Get ( PrivilegeSetName ) = "[Full Access]" Show/Hide Status Area [show] Else Show/Hide Status Area [Lock; Hide] End If Refresh Window simply does not do what I think it should. Everyone sees the status area, regardless of their privilege set. Can anyone think of a reason why this does not work? I want to use IWP to publish the database, but this script does not do what it is supposed to do either on a server or run directly…

I have DB with many layouts and all of them are well organized in folders. I have made a navigation set of buttons so I can navigate through the main ones but I have some “auxiliary” layouts that is impossible to incorporate to the navigation set, it would be too big and made no sense. My idea is to add a new navigation button named “Aux” and I would like to make a popup that will show me the list of the Auxiliary layouts so I can choose any of them to go to it. Is that possible? Thanks in advance.

I have no idea where to put this topic, so I stuck it here. Any input is appreciated as I am stumped. The Issue: We have a few workstations where the cursor flickers between the arrow cursor and the text cursor. 2 things: It does not happen 100% of the time, and it only happens on a few workstations. We are running FM Server 11 to about 15 workstations. Most workstations are Mac Minis. The computers that display this behavior are newer (late 2011) Mac Minis. I refuse to believe this is a corrupted system issue, but it's very possible I am wrong. Help?

Here's what I need to do. I have 3 fileds - Field1, Field2, Field3. Field 1 should be filled in first. Field 2 then gets filled in. Field3 depends on the following. If field1 is "x", Field3 should be blank. Otherwise, Field3 should equal to whatever Field 2 is with the option to be changed by the user to something else or blank. How to do it?? Mike

first of all I would like to apologize for my english. I'm a Dutchie. Second; I'm trying to get FM to tell me to total of the taxes on my invoices in all the quarters of this year. I've been searching and reading and trying but with little succes. I managed to get FM to tell the totals but I can't seem to split this in 4 quarters. I need this because I have to pay my taxes every quarter. I'm in the progress of migrating my administration from MsAccess to FM (advanced 11). If you have a sample you can share with me I would be very gratefull. TIA Bart

I have IWP up and running. Pages look good on Mac and Windows and most work without a problem but I have some that if I even put a cursor in a field, IWP freezes. It matters not what browser or system I am on. One weird part of the url when I get this is "check status" Locally, the db runs without error but not in two of the pages which contain a portal and links/lookups to other tables. Any help on this would be terrific. TIA Bob Moran FMP 11 Advanced on Snow Leopard and Win 7. Ports 591 and 8080 were used with identical results. The pages will come back after several minutes but that, of course, is not acceptable. :)

Hi everyone! Firstly, I'd like to clarify that I'm not sure if this post fits in this section. If not, feel free to reallocated! Secondly, I'm going to present my problem: - My DB. I have a table of Clients. This table is linked to a Bills table in a 1...n relationship using the clientID. I am storing when the bill was generated. - I'm trying to generate a report which shows a top 10 of clients for a given year. The clients should be sorted for the amount of money they spent. That amount would be generated as the sum of client's bills for the year chosen. My main problem is how to sum the bills of a client for a given year. Thank you in advance…

I have two data bases both are set to have black the standard color of any text, in one the text in selected cells, can be colored, black to red act, in that data base I can highlight the cell and change the color of any of the text and it remains that color when I click out of that cell In the second data base if I highlight a cell and change the color when I leave the cell the color changes back to black when I go back to the cell the color changes back to the chosen color. I have tried to compare the preference settings, tried changing Text under the Format Some suggestions please Mike B

I have a field called sCount which is a summary of the 'name' field. I would like to sort by sCount but I don't believe that I can because it is a summary field and it is greyed out in the sort dialogue box. I would like to sort my report by sCount descending because I would like to show the 'Name' with the most records first and so on in order to identify training priorities. Is there a way to do this? PS I did find a work round. I created a loop script that would enter sCount for every record of my found set into a number field. I then sorted using this number field and used as sub-summary on my report. Is there a cleaner way though?

I need to figure out how I can add a header, a footer, a page #, and current date onto the Table View?

Is it possible to play an MP3 Song right out of the movie template starter solution? I would like to put my collection in the template and be able to play my music from my external hard drive by clicking on the song in the template. Is this possible before I start trying? Thank you.

I'm developing a tool for my staff which, let's say for the sake of this discussion, tracks sales per employee department (front of house, B2B, manager, etc.) Currently, I have a report that displays a simple, short list that looks something like: Front of House 217 B2B 198 Manager 72 (etc.) This report contains two fields. Let's call them: Employee::Role (from related table) z_Count (from main sales table) What I want is another report identical to this one, but it only totals results from the main table where the SalesDate is greater than a specified date (this is a static date, so the end user need not edit …

Is there a way to script a list view window to "resize to fit" properly? Resize to display only the found amount of records be it 2 or 22. When you use FMP's resize to fit function on a list view layout it maximizes the window height to very top and bottom of screen. Which looks odd when database is only displaying a couple records. The resize to fit function on a form view layout works in a nice way, list view not so much. Thanks for any tips! :D

Does anyone know of a way that the manage layouts section can be ordered alphabetically? Joseph

A client has asked me to design a custom CRM system for his company to replace a legacy system. This client has some familiarity with FileMaker Pro. In initial discussions he is hot on the idea of using table view instead of list view layouts. I've been a contract developer using FileMaker for many years and have never employed table view in a project I've delivered to another company. I know that table view has evolved somewhat recently and I'm interested in hearing the community's opinion of the advisability of using table view instead of list view and the reasons pro and con. If it's as bad an idea as I believe it to be I want to be able to present a compelling argumen…

Hi Forum. I have a Layout like this: <Header> <<singletextfield1>> <<singletextfield2>> SOME FIXED TEXT </Header> <Body> [a single field] [another single field] </Body> <Footer> some footer text </Footer> singletextfield2 is a sizeable box 500 height x 150 width and it can contain one single or multiple lines of text. Thats why i make <<singletextfield2>> and SOME FIXED TEXT "Sliding up based on, all objects above as well as, Also resize enclosing part". However when the field only contains one line, the space left between SOME FIXED TEXT and the first line of t…

Hello all: I was just wondering what others use for displaying their data on browseslists and data entry screens when building an application for both Windows and Mac clients? I tend to use Arial, Helvetica or Tahoma. Thoughts ? Thanks. Dom

I have created a subsummary report that ranks items by total sold. The total sold is the summary field. I would like to add the rank number to the report, but cannot use the record number since each item has many sales records.Is there some way to add the rank number? It is a running count of the subsummary part.

FM 11 Advanced. Something is creating windows when I switch from layout to layout (in layout mode). Then I get the message "This layout cannot be modified in this Window...". I then have to close the window. The Window menu displays for example, Costs, Costs-2, Costs -3, etc. I'm not running any scripts and none of my script steps create a Window. Of course, the FM Help has practically no info on Windows. Any suggestions on what could be causing this?

I've read through several different posts, articles and tutorials about crosstab reports but I'm struggling to get it and I haven't been able to find any that have adjustable columns. So here I am. First step is to see if I can explain our business. We do fundraising wall calendars for Police, Sheriff and Fire departments. Our primary function is to solicite sponsors for the calendar and sponsors recieve an ad space. Tables Departments Jobs - A Job is how we refer to a calendar project Employees Sales Assigned - Join table between Jobs and Employees Customers Tickets - Tickets is our term for Invoices. Lines, Products A Department has many j…

Whats the best way to, when I click a button, instead of using the go to layout option, instead to simply pop-up a preview of the page/layout I specify while staying on my current layout. Thanks Matt

I have a pop up window that displays a Summary report layout. When I use Adjust Window [Resize to fit] at the end of the script, the window width shrinks to fit but the hight is maximized with a huge amount of blank space. I tried with all the different kinds of footers, including a trailing grand summary and even without a footer. No matter what I can't seem to get it to shrink up to the bottom row of the report. Any ideas?

Hello, I know there's a limitation of viewing 255 layouts in the layout dropdown on windows, but I was under the impression there wasn't a limitation on the mac. I currently have 56 layout folders with subfolders in each, but when I click on the Layout dropdown in the GUI, it only shows the first 17. I added a layout and that shows below the 17th folder, but none of the other folders show up. Any ideas what is going on? Thanks, John

Hi, I have some layouts presented in table view (only), and with a header that contains a series of buttons arrayed horizontally across the screen. This is to help colleagues that are more accustomed to Excel style data entry. However when a table contains many fields that go beyond the screen it becomes very inconvenient for the users to scroll back to the far left to use those buttons. Is there a way to make the header scroll sideways? Or more likely, an alternative that allows the user to see the button even if they are far far to the right side of the screen? Thanks for your help and advice! MacGuffin

Hey guys, i am new to the forum and start out with my first question. We are now migrating our severs to OSX 10.6 and are still working on the Filemaker 5.5 The problem that we encountered is that on some of our clients Filemaker doesnt display the data in certain layouts e.g. our invoice layout doenst show the data of the fields in the invoice. But if you print the invoice or you switch to our windows clients everything is showen properly. Please see enclosed the respecitve fotos. Further more on my laptop everything is also running smoothly. Would be really obliged if someone could give me a hand on this. many thanks in advance and best…

I have an application that has, among other fields, last name and first name. I have an input screen as well as labels. If someone types in the first name and presses enter by mistake, the label doesn't show the last name. I want to supress adding a line in those fields. ANy way to do that? Mike

I run across this situation pretty frequently, and dang it, it's time to do it right! I've got a Table for EVENTS and a table for CONTACTS and a join table in between for INVITATIONS. On an EVENTS layout, I want to have a portal where the user can create INVITATION records by adding Contacts to the portal list. Let's say on the portal row I have Date, Name and Status, so you can enter a dozen names in there and see the list of when you invited each person and whether they've RSVP's or not. To add individuals to the list, you need to get the Contact primary key into the Invitation foreign key field -- but of you want the User to be able to enter Names, no…

I have layout with two elements on it, a rectangle and a container field. When I copy and paste the rectangle into the container field, and then overlay the container on top of the original graphic, there is a notcible color shift between the two of them. Any suggestions on how to get around this problem? [FM11 with Mac OS 1.6.8]

When working in layout mode I occasionally get the message “This layout cannot be modified because it is already being modified in a different window”. What causes this?

Hi there... Slightly irritating problem... i have done a lovely layout... it fits perfectly on my screen when filemaker is maximised (screen res is 1280 x 1024) Now I go and check the layout on another PC, same res, and the layout is rendered a few pixels wider and taller!! This is causing the scroll bars to be enabled and it just looks "off" Why is there this difference? Whats causing it? Aare there any settings in windows I should be checking? It might be worth noteing, one PC is amd the other is nvidia Matt

Hi all I have a layout divided into header body subsummary and footer - a button toggles between two views - form and list so that the subsummary doesn't show in list view I am trying to do a custom background by entering a series of graphics into the various parts and then sending to the back. The problem I have is that the graphic in the body part will not align exactly with the edges of the part (the dotted lines at top and bottom) so leaving a small gap when it is in browse mode The part boudarys will not align exactly with the grid lines or the tee square making it impossible to get them exactly aligned even if I resize the graphic So what I was wondering …

I am relatively new to filemaker, I have been working on a database and its coming nicely. All my layouts are looking good except 1. When i view it in form view all the fields and containers stretch out to the length and width of window. None of the other layouts do their, if i grab the right edge and drag it to the left on the other layouts it just cuts across the fields. But on this one it stretches and shrinks based on window size and shape. I am sure i must have done something, but i cannot figure out what. it all lines up... any help you may be able to offer would be great. Thanks.. Brian [email protected]

Hi, I've been searching around for a solution to this problem and can't find much on it. Nothing recent anyway, so I hope things have moved on. I've convinced my company to switch from managing our pricelists in Excel to FM. However, we had hyperlinks on all products codes which opened the product page on our website. Excel includes this information for exporting to PDF no problem, so the link is still active in the cirruclated PDF version. I have set the product code text field with a button behaviour that opens a URL, picked up from a seperate field. The thing is this is only active in browse mode and not in preview mode, which is require to sort the product and pu…

I have uncheck the option "Save record changes automatically " So that "Save change to this record" dialog box appear in browse mode, when i done some changes and click on empty area. But i dont want this dialog box at browse mode, because im have written some script in save button for save the record. How to avoid this dialog box.. Could anyone please suggest me to stop or avoid this dialog box appear in browse mode Many thanks in advance for your support

Hi, All. Newbie here with a noob question (do we have any other kind?). As a noob, I don't have the FMP vocabulary that you guys have, so I'm including some screenshots of the problem to make it easier to explain. I am making a fairly simple equipment rental solution for my employer. The relevant tables here are: JOBS, GEAR, CREW, BOOKINGS_GEAR, BOOKINGS_CREW. On my main JOBS layout, I have two sets of tabbed areas, each with two tabs (see attached photo above). The two tabs in Tab Area #1 each contain portals listing All records for Gear and Crew, respectively. Tab Area #2 has two tabs with portals showing Gear and Crew that have been added …

Really simple question! If I'm needing to truly align two objects, my intuition tells me they should both be an odd number of pixels in size, or both even. Would that be right? Okay -- follow up question. If I'm wanting text in an Edit box to be centered vertically -- in other words, no closer to the top of the text box than the bottom -- . . . or to *appear* centered to the eye (which may not be the same answer - as framers often mat the bottom edge of a painting slightly fatter than the top) . . . . should the text box be odd and the font size also odd, or . . . ? Similar question arises when I have a text label I want to align centrally next to a fie…

Hello I have some buttons which allow me to define some values which will help choosing the kind of report which should be created. The button sets a variable value (for instance to "details", "daily", "monthly") and the script acts accordingly. My questions: • is there a way to show the value of the variable on the current layout? (found it after a much needed coffeebreak... ) • would it be wiser to use a global to store the choice? Thank you for your short answer. Cheers

I have a portal where I'm using an ID field and want it to show a name, not the ID number. I used the value list, selected the popup menu option, defined the id as its name, used the 'show second value.' All the relationships are in place for this to happen. When in browse mode, clicking on the field shows the name list but the name does not persist. If you go to another layout and come back, there is the id showing, not the name. What is really puzzling is I am duplicating an example, and I swear that I followed it exactly. The example persists; mine does not. Any thoughts? Thanks!

I finally got around to implementing drag and drop functionality within our database. I've used this simple technique http://fmforums.com/forum/topic/62097-drag-and-drop/ mainly because it didn't need scripts (and I've looked at other methods and couldn't get my head around it). What happens is I drag a staff members name onto a shift. This then populates that the shift has been filled by this staff member. It all works perfect. The problem comes into it with our Availability table (shows when staff are available). In the past, when we assigned a shift to a staff member a script would run that would update the Availability table to show they were working. With …

Okay, this is a tiny question, but one that's bothered me for years. When I'm in layout mode starting a brand new project, I like to set the body part to the approximate the size of the window, and then I use the T-Square lines and the line-drawing tool to sort of sketch out how I might use the real estate. Or whatever. But always, getting in the way, is that squiggly vertical line that shows where the edge of the "page" would be. . . . but this is going to be a data entry layout, never printed. So why must I have this thing distracting me all the time? Ironically, the only way to hide it seems to be to choose "View Page Margins" -- which is even worse. …

Hello, It's hard to describe the report problem I have. I am not sure if what I need can be done in filemaker. I need to sort by month, and conditionally add data from other tables. Please read on for the table design and the expected report layout. 3 Tables: Projects- (Each project will have one or more â��childrenâ�� subprojects) __kp_projectID projectName SubProject- (Each SubProject will have 1 â��parentâ�� project and 1 â��childâ�� SubProjectTask) __kp_subProjectID __kf_projectID subProjectName dateA (date field) dateB (date field) dateC (date field) SubProjectTask- (Each SubProjectTask will have 1 â��parentâ�� project ) __kp_sub…

Okay, this is somewhat embarrassing, but I can't seem to get a simple sub-summary part to display summary data properly. Table 1: Stocks -- 1 record per financial stock, with fields for Ticker, Manager (each stock only managed by 1 person), and a few others Table 2: Trades -- child table, 1 record per stock sale, w/ fields for date, # of shares, buy price, sale price, net $, etc. In the Trades table, I have various summary fields like "Total $ invested" and "Count of Trades" so that from the Stocks context I can see combined data for all trades of a single stock. This works fine. So, on to the problem. I want to have a sub-summary layout where the sto…

Hi, I only program occasionally and feel as though I've overcome this before... but can't recall how I've 2 tables A and B, both can have more than 1 related record with the other, when I do a summary in A where B has more than 1 related record, I get the multiple A values (and therefore they all sum() ) they but I only want that value once, and visa-versa. I know I can create 2 layouts but Ideally I'll like to be able to do it on 1 hope if explained it properly thanks

In layout mode there is record forward and backward while mouse scroll. I would like to stop this features with the every layout. Please share your suggestions Many thanks in advance

Hi, Just starting with FM and found problem with pop-up menu. I would like pop-up menu to have option to insert "Others" and also include that in the list next time user click on this field. I know there is a "Edit" option for pop-up menu but I don't want users to be able to edit entries, just add new ones to the list. FM Pro 11 Thanks, Mariusz

Hi all - I know there is, and has been for a long time, a Title Footer layout part. I have never understood it's behavior though. I want a part that will only print in the footer of the last page of a multi-page layout NOT the first page. Has anyone ever come up with a good way to do this?

Hello all I have been asked to design a table with a list of companies showing the various subscribers underneath Very easy main table - records by company then a join table to the main contacts database and show the subscribers in a portal However I have been asked to show the list of companies and then give the user the abilty to expand the record to see the subscribers as they see fit. As far as I know there is no way to do this although I understand you can re-size objects to take into account different sized windows Does anyone know a way of doing this or can you at least point me in the right direction We are still on filemaker 8.5 at the moment

I have a database I have been designing and I can not figure out how to get a relationship to allow me to type in fields that are on the main table. Here is my breakdown. I have a main customer table, I have an orders table and I have a customer visit table. I want my customer info stored on my customer table, and from my orders table I want to be able to type a customers name in the name field, and that automatically creates a new customer entry if the customer isn't already in the list. I want the same to happen if an employee enters a customer name in the customer visits layout. I don't want my employees to have to go to the main customer table and create a customer e…

My main layout is a rats nest of over two hundred fields. Some fields are duplicated (aargh!) The layout body stretches down some 60 inches, and things are sometimes almost randomly placed. Yes, it's so messy that I can't find where one particular field is located on the layout. (is it over on the bottom left of the layout? On the right side, fifteen fields from the top?) Of course, I should clean things up. But to do so, I have to find the fields that show up two or three times on this layout. Is there any way to be in layout mode and then find the location of a field ? ? ? I'll bet that there isn't ... can you prove me wrong? …

Hi All, Okay, I have an invoice print layout (table is InvoiceLineItems) that's structured like this: • Header (logo, phone numbers, address, invoice date, salesman, ship method etc) • Body (containing only the line items data) • Trailing grand summary (totals, places for writing hand-written notes, a spot for a graphic, spot for signature) • Footer (Pg X of X) Basically, the trailing grand summary contains a lot of things (that can't be removed or re-sized) that need to be there, but there's one problem: When I have more than 5 line items, the trailing summary will no longer fit on the page, and being all one big chunk, it gets pushed onto the next p…

I am struggling to reproduce a breadcrumb-like graphic in FileMaker. The content needs resize dynamically. Does anyone have any ideas on how/if this could be done? I was trying to do it without using a web portal but I don't think it's possible. Thanks.

Quick background: I work for NASA and up until 2 years ago we were using FM here to do some of our work instructions. We have since gone to another system (which none of us engineers like) and I am now trying to put together a little demo to show my management that we need to switch back to FM so we can run paperlessly runing FM Go. I am not a developer but I have built a crude system to mimic what I envision this system doing. I am hoping someone here can help me with what I hope is fairly simple: I need to be able to add "steps" (text fields). Each time an engineer writes a work document the number of steps varies based on the complexity of the task. A simple task ma…

Has anyone confirmed whether the new text highlighting feature can be used to highlight words in a text field according to a user-specified string (see attached example)? Thanks.

I am using a radio button on my layout. To see the click button area I give it a stroke of 1 pt but when I do this I also get a line on the top and left hand side of my field box. In effects everything is set to none so I cannot figure out why this is happening or how to fix it. If I click off the stroke for the button the lines disappear but then so does my button. How do I get my button to show up with a stroked line and no lines to appear around my field box in the top and left hand side? As always any help would be appreciated. Thanks in advance, The Missing Man

Hey Gang! HAPPY NEW YEAR TO EVEYONE!! I may be asking a question that may seem ridiculous, but please bear with me. I dont use the list view at all, but now that i have to print invoices out, i see the need as well as for searches. Can someone paste links here so i can see what others have done as searching in this site for me is quite difficult for some reasone for the list view stuff. I definately see reasons for invoice, but the layout parts i need help as documentation again is all over, but i am weeding my way through slowly. any help on how/why/when using list or table views would be great. Hope everyone has a great 2012~~~~~ -i…

Hey Everyone; Got a question about printing a report or in my case the order/ invoice . what would be the best practice here in printing the report via all these tables eg. Customer->order->orderITEMS->Payments I NEED all this information along with other info such as "company information in case of emergency,etc" i am about to do a report, plug the data into a virtual list and after place all information into a table. Does that make sense or is it just better to create a List Layout and put all information i NEed on the list layout with conditionals / text objects ,etc. thanks for your help as usual . =-ian

If I create a value list with custom values and begin it with a carriage return before I type my choices, the pop-up displays a blank at the beginning so that the option is also to blank the field. But if I use the same value list and attach as radio button, it does not provide the blank 'circle'. Why is the behavior inconsistent? It makes sense not providing the blank on checkboxes because they can be unchecked but radio buttons can't. I read about using shift to 'remove' a radio button selection it does not seem like the right approach. I would have to put a message above all my radio buttons (which I will allow removal of data). Also too, why does it then…

I have a potential client who has customers from both companies and individuals. What is the best practice to design the customer information? Thanks. Kent

I have a repeating field with 36 vertical repetitions. I would like each repetition to have visible borders around each one. When I turn on field borders for all 4 sides it only does the outside borders of the entire set of repetition fields. The other problem / trick is that the set scales with anchors set to top, bottom, and right so faking it with other objects is tricky at best. Any ideas?

As you can see in the photo attached my page margins don't match up with my layout ... I have searched everywhere and for the life of me cannot figure out how to specify the page layout/margins so they match the iPads screen size ... without changing the page margins for the entire database and regular computer layouts ... I tried to switch to landscape mode and that looked more fitting for the iPads screen size but then when i tried to print on another layout it printed incorrectly. Thanks, Matt 22.tiff

Hi - I have decided to replace a few drop down lists with small windows/layouts carrying portals. I have set the window height (via 'New Window') to 225px, but they always open at 167px. If I click in the window (outside the portal) the height changes to 235px! It does what I expect if I use a greater height measurement (eg: 445), but why is it ignoring me at 225? Is 235 a default minimum? And, if so, why is it opening at 167? It sets to 225 if I use Adjust Window (resize to fit) based on a background item, but I'd rather not use this.

Hello great fellow forum inhabitants! Ya'know how you can put your cursor in a field and then ctrl-i and it shows the index and you can even if you want, show word index (although I have no clue why you would want that)... Anyway, can I give person script to bring that open for them to select from? Okay, I think it is kinda handy and it might save me from having to create value lists all the time. I think it would need to be like this person has cursor in field then types (something) which does not type into the field to activate the script. Or maybe it is button on top of layout? Possible? Or triggers? then lastly, if they put something in the fi…

I have a table A, which has multiple items for each record in a sub-table B, which itself has multiple items in each record for a sub-table C. The records in C are all from a Value List. I want to create a report that sorts by C first, then A, then B, like this: Item from Value List C ------> Record from A ------> ------> Multiple records from B ------> Record from A ------> ------> Multiple records from B Next Item from Value List C Now I've tried using the Wizard, but it doesn't completely work. I get items from B in one group that belong to more than one A, without getting a new record listed for A. On wh…

I have text data which starts with a number, e.g. "1. Blah", "2. Blah", "3. Blah" .... etc. The data may also include "4a. Blah", "4b. Blah". The data is listed in a portal, and I want to sort the data by the leading number. Is there any easy way to do this, without 10 appearing between 1 and 2, but rather after 9....? I suppose I could put leading zeros, but I'd prefer not to. Thanks

If I show the Formatting Bar so people can see the bold, italic, underline, it works but it does not show all of the formatting listed in the menu, such as style. Why not? There is space for Style and all formatting options to fit across the status bar. Am I missing something obvious? Surely FM did not include Bold, Italic and underline but then forget everything else. I keep looking for the hidden button to show them.

Hi folks, I have a layout that is a template for printing CD labels. It never fails, however, that whenever I use it, it appears the whole layout needs slight tweaking to line-up properly with the CD labels I am printing on to. Since my file has users locked out of entering Layout mode, is there a way to somehow script buttons that can nudge all the objects on the layout up or down and left or right, by tiny increments, like say a few pixels? Currently the only solution is to enter Layout mode and select all the objects and manually nudge them. But if this could be accomplished in browse mode using scripted buttons, that would be great! Thanks fo…

I would like to limit the size of any photo a user may upload to a container field to a maximum size of to 300 kb. Is there a way to set a maximum allowable size? Field Validation? How would I implement this? Thank You, Greg

It is late at night and maybe I shouldn’t be posting, but I can’t get this to work the way I think is should. Users are requesting a “Back” (and “Forward”) button. We all know that they won’t work “exactly” like a web browser, but they still want it. What I did was use the “onLayoutExit” script trigger to set the variable $$layout to the Layout Name (or ID). Then I have a “back” button/script that says Go to Layout "$$layout”…simple right? Well, my little brain can’t get it to work. The layout recorded is the Layout that I go to not the one exiting from. So the “back” is the same layout. Uhg. Why is this? Feeling dumb and frustrated…especially if a bug!

Hi, I used the Insert Picture to place an image but mistakenly got the images from another unrelated folder thats not distributed. The ruuntime test fine showing images on My Computer ...however when i install on a virgin machine.. I have missing images.. (forgot and distributed to a client ummmm) Here is the question.. How do i see the properties of path etc of a image.. and i don't think you can?? I couldn't figure how to trouble shoot but copy my application files and folders to virgin computer so when I run it... I could now see "Missing Image File.png" Then able to see which layouts.. a bunch too And I can fix it.. Is…

I am developing a simple invoicing solution, and I need to provide a report that has a summary of information from 2 other tables. For the life of me, I can't seem to figure out how to apply the date range to the calculation. to simplify: table1 = labor sales, table2 = Item sales (assume each has a date field) I need to create a report that gives me summaries for a date range, a page that just has "total labor sales for date range" and "total item sales for date range". Can anyone give me some pointers on how to get the numbers to reflect the date ranges. Perhaps I don't understand how the relationship needs to be setup. Thanks kindly

I am using FM 8.5 on a Mac with a database of 50 labels. i am using the supplied template for Avery label L7161 (18 labels per each A4 sheet) and it all lines up and prints lovely EXCEPT every 7th address in the database is not printed! I confirm that 18 labels are printed per page and that the page is set to A4. The labels are printed down and then across. Why would FM omit printing what would be the 7th (and, thus, off the page) label of every column? Any suggestions on how to remedy this situation? Roger

I am housing Word documents in a container field. However, when I try to open them there is a problem and something funky happens. Am I doing somethin wrong here...? Thanks... Dr.L

I have a simple report layout for my CRM database that shows a sales rep's activities. The CRM has tables for contacts and related activities. The layout shows records from Activities, with a summary count field for each contact in a trailing sub-summary, so you can sort the layout by Contact and see just one line per contact. There is no Body part in the layout, just the sub-summary. I control what the report displays using three global variable fields in the header: the sales rep's name (actually the ID underlies the name), the beginning date for the report and the ending date. Once you set those, then I have a "GO" button that runs a script that finds a set of…

I am trying to show users to enter certain data but i dont want to have headers like [ firstname ] _________ What i want is something that looks like this firstname & when the user starts typing it gets overwritten. thanks, -i

I am trying to create a sub summary of certain data in my database. I have one table that lists patient IDs, and this parent table is linked with multiple child tables through this field. I would like to generate summaries of the number of patients who have certain qualities as specified in some of the child tables, such as a certain condition. I'd like to generate a list of such patients. While in patient list layout mode, I went to "insert" then "part" then sub-summary" and then specified a specific field from a specific table. However, nothing shows up after having done this. Can anyone please tell me why?

Dear All, I have a very interesting issue with the following database structure: Production Plan, key: planID Plan details, keys: planID, productID Product, key: productID, recipeID Recipe, key: recipeID Recipe details, key: recipeID, materialID Material, productID Material is a TO of Product The following relation is set: Production Plan (planID) >---< (planID) Plan details (materialID) >---< (materialID) Product (recipeID) >---< (recipeID) Recipe (recipeID) >---< (recipeID) Recipe details (productID) >---< (productID) Material The fileds I use are as follow: Production Plan: month Plan de…

I'm new to Filemaker. I am constructing a database which shows as columns in Browse and Table modes. I have sub-summary and summary fields totalling columns by category. Problem: in the summary fields I get, for example, "Total: 1325.00". How can I avoid having the "Total:" and show only the numerical result? With multiple columns the text takes up too much space.

Hey Guys, I think i know the answer to this already, but if it is no, just wondered if you had any alternatives. Basically my clients want to convert the excel sheet they have into a layout on filemaker, or an export to excel. It is an availability sheet for staff. So there is a table called availability, which has a row per date per member of staff. The staff is referenced by another table via an id. Each date has three shifts the staff can select as available and not available. The report the client wants produced, is to have staff names down the sides (row per staff) and have the next 7 days across the top broken down into the three shifts. So…

How do I leave a parent window restored (full-screen) when opening new window? Now when opening a new window with a small size, the parent window changes to something smaller.... You would have to restore the window once you close the current one... I have a 'Record ID' that requires a value from a value list... But the value list is 3000+ items and is simply to slow. So I want a new window where a simple search is done, the data can be selected and OK can be clicked. But the parent window resizing makes the screen jump and it's confusing for the enduser. Why does this happen anyway?

I really wasn't sure where to put this but thought it was more a presentation problem than anything. We're looking at adding a new feature to our solution where we can SMS staff with job details. The idea was to have a pop up window which displays a 'To' field and a 'Message' field. This layout is run by a temp table (sms_table) which will get cleared once the message(s) have been sent. They're going to be sent through email so all copies of the message will be stored in the email client. So, I have a portal the shows jobs which, when clicked, builds the message part up. I worked out a nifty counter (proud of this ) so that side of things is sorted. My …

I have a database with many different layouts. grouped into two folders. I would like a drop down menu pretty much identical to the in built Layout drop down menu found at the bottom left of the status toolbar. Reason being once I create a runtime solution, there won't be any status toolbar so this menu to hop between layouts needs to be in the GUI. Making 20 buttons with scripts to take the user to the specified layout is only going to clutter the screen. Thanks so much in advance.

I've always used checkbox controls for number-type fields used to represent logical true and false. In my latest project I thought I'd try something I've seen other developers do. I found two graphics files that look like checkboxes, one checked and the other un-checked, and stored them in global container fields. I've added a calculation field to my table indicating that if the value of the logical field = 1, return the checked graphic, otherwise return the un-checked graphic. I've placed the calculation field on my layout and made it into a button which activates a script that toggles the logical field. It worked perfectly and looks very polished and professional.…

Trying to add a new feature to FileMaker Pro in which you can have a "to do" list set up, to allow easy access to who needs to be called etc. Will appreciate any help not much experience with FileMaker. Thanks

So I have 2 tables. Inspection and Violation. They are joined in a many-to-many relationship. There are 2 records in Inspection. There are 6 records in Violation. I have a layout set up with parts (body, sub-summary) that show both inspection reports (records) and the list of violations on each inspection report. So there are 2 pages when this layout is in browse mode with the 2 inspection records- one inspection report on each page and a list of the violations within each inspection report. My problem is the numbering of the violations. Right now, the first inspection report violations are numbered fine (1, 2, 3, 4). The second inspection has viol…

And is there any way to stop this? Thanks so much

Evey time I create a new field in 'Manage database' and then go back to layout mode, that new field is inserted at the bottom of the layout. Major annoyance! I'll insert it when and where I like thanks. How does one switch this ever so intrusive feature off? Thanks so much

Hi All, I am in need of showing a page from a database on a large screen. I have turned off "status toolbar", but is there a way to turn off the File, Edit, View, etc. toolbar? Thanks...MG

Hi everyone! I am a bit overwhelmed by FileMaker and its capabilities, so I would greatly appreciate some help. Currently, I have a database of contacts throughout the entire United States, with separate groups. (Group A, Group B, Group C, Group D, Group E). I would like to create some kind of "dashboard" or "layout" for FileMaker so that I can see how many members of each group we have in each City and in each State in the country, possibly like a pie chart that adapts to the data. Could someone please explain to me how to go about setting this kind of layout up, so that I may browse these breakdowns on the fly? Best Regards, Jonathan Ross

Hi, I want to create grouping for my six portal tools. (like in Excel - The list will have a gruouping / ungrouping button) As I can choose number of items to be grouped, I want to select these portal tools Please find screenshot of my list attached. Thank you. screen shot.zip

I have a series of tabs, many of which contain LOTS of fields. I am trying to prevent users from having to scroll the whole window beyond the original window frame in order to see each tab's content and am trying to find a way to add scroll bars within a tab. I don't know what functionality would let me do that and the only other option I can come up with is to use another set of tabs within particularly dense main tabs. Any thoughts on how to address this issue most efficiently? We are worried that if there is ANOTHER set of tabs, users might forget to look at each one (which is important, as this for data entry on a research study). Any ideas?

I have a sub-summary part that provides summary data about my database according to record type. On the main database overview page, I created a portal with a self-join relationship (displays records from the same table as the layout it appears on) with relevant fields inside. Everything looks great, but the portal records are not also segregated by record type between the sub-summary reports. I have the records sorted by record type within the portal, but that just groups them. Right now, the portal looks identical in each sub-summary report. Is it possible to filter records so they only appear in the sub-summary part designated for their case type?

I am trying to create what I thought was a fairly simple database and I am having trouble with one part of it. Maybe my brain has gone on vacation but I can't seem to get it wrapped around my problem for some reason. Here is the detail: The output of this database is to: Create a voucher write a letter to a county write a letter to the dept of agriculture I have 5 tables: Vouchers; Voucher Detail; Vendors; Drain Commissioners; Drains The scenario: Vendor A submits an invoice for work done on Drain X. Before we can pay the bill a voucher has to be created and mailed to the counties the drain is in and the dept of ag. All drain commissioners and dept o…

Thank you if you can help. Form view, data in fields. If data too much to fit in the field, the data that is displaying sits too high in the field compared to the other fields which don't autowrap to another line. This mismatch in placement of data in the field looks terrible particularly on list view. How can I stop FM from recognizing wrapped text when displaying and jagging it upwards? I tried setting alignment to upper, middle and lower but it makes no difference. There must be some trick to it or a checkbox or something. :cry:

Hi, I have defined a relationship in my filemaker project to a completely separate database, I have created a new layout and dropped in fields from the related database. I have applied formatting to these fields - font size, font family etc, however in browser mode I am still seeing the formatting from the related database, not as formatted in my database layout. I'm sure I've seen an option to change this and override the styling of the related database but I can't find it anywhere. Can anyone point me in the right direction? Cheers Kevin

I have an ODBC connection to a MSSQL database that has several timestamp fields. In FM, I'd like some of the fields to display just the dates and other fields to display just the times. When I use the Inspector/Data Formatting area to make any changes, the changes do not stick - the fields always show both the date and the time regardless of my changes. I'm not sure if I am doing something wrong in FM or running into a limitation based on my data source. Any thoughts or work-arounds? Picture example of ODBC data source fields attached.

This may sound simple, but I find it very annoying: I constantly end up with the text formatting toolbar showing up twice on my screen. I have a script to turn off all toolbars. That takes care of text toolbar number one. But the other one always remains on the screen and there is no way I can interact with it to have it go away. (The standard Filemaker menu shows it greyed out) It stays right on top of header section, preventing use of the navigation buttons I put there for the runtime application. Sometimes, by fiddling with the system randomly, I can get it to disappear. However, the next time I open the application, it goe…

I'm trying to create a layout, which is used solely for searches. Let's say it's a database of Cheese-producing Nations. (It isn't.) Each main record is of a Nation and its cheese production data. Each Nation has a sub-table of farms. Then the farms have one-to-many attributes of cheese types, Delivery options, and err.... some other thing. Each of these is in its own table with an ID and a Value List. I have created a layout with a field for each of the three types, as a drop down list, and a portal that lists the farms and their Nation. I can select a value from the drop-down list, and perform the search, and I get a lovely list of results. Here's the …

Is there a way to skip summarizing data on a layout? I have a situation where I need to "Show all records" in a script. The summary fields then have to summarize which takes forever and the data I need to get to doesn't even involve those fields. Is there a way to tell filemaker not to summarize while leaving those fields on the layout?... or perhaps you may know a different work around. Thanks!

I need to change the double click function on the container type fields. I only want images to be uploaded.

Hey Everyone; I set up sliding objects on my layout but white space still there. Am i missing something? Sliding Arrows on the fields you should see