Layouts

I am looking to create a "part" on the right hand side which will display my extended help text. Is this possible? The idea is that user can scroll through my fields on the left-hand side of the screen and when active on a field an OnObject script will activate some extended help text to be displayed in this right-hand side "part" which is fixed. This must be IWP compliant and therefore if the OnObject script doesn't cater for the script I plant o create "Help" button which will activate the extended help text.

First, an appology if this has been covered before - but try searching for 'save as pdf' and see where it gets you I have two layouts that give me a problem of creating a blank page when there are more than 6 records shown. The first layout has a header, footer and a body that contains 20 individual portals showing up to 20 lines from a parts ordering system. The portals are arranged so that they do not cross a page break. There are 7 portals before a page break occurs. Sliding and printing is set to slide up, and reduce the size of the enclosing part. The second layout again has header, footer and a body that has a singal portal showing up to 20 records. …

Hello, Question that came up today. Can a layout be modified on a server. Here is what I want to do with all users off (we only have 6 so it will not be hard), I log in to the server from my workstation with full access and make changes to the layout, basically moving some fields around that I put in the wrong order. Will this work, or do I need to pull the db off the server and make the modifications and then upload it again? Thanks, M.L.

I'm working on a report. We'll go with my widget schema again. I've generated a report where it's first sorted by WidgetColor and then Widget with a count of each widget (widgetcount). I've presented this report and am waiting the next requirement. In the meantime, I am anticipating that he is going to want it to be: Widget Color1 Widget1 Widget2 Widget3 Widget4 Widget5 Widget6 Widget Color2 Widget1 Widget2 Widget3 Widget4 Widget5 And so forth (you get the idea). I know this can be "easily" done with a single iteration of each widget by doing a loop in the script to omit duplicates (each Widget Color-Widget ha…

I have designed my solution for the 'typical' laptop display - to fit a 1024x768 resolution without need to scroll either vertically or horizontally. This is great as a 'full screen' display for computers with 1024x768 maximum resolution. Users with larger resolution screens want to 'maximize' the solution with an accompanying scaling up of the objects on the layout. FM allows zooming only in fixed increments (150% 200% 300% etc) which helps only if the user has a larger screen - 20" or more - and zooming to 150% could be done. If the user's screen isn't big enough zooming to 150 requires scrolling to view all the objects on the screen. What I've done …

Howdy. I'm a newbie when it comes to FileMaker developing. I do know enough to build myself some simple and useful databases that I know how to run, but I struggle in making them more usable for other people in the office. What I have is a simple database that allows several of us in the office to add customer accounts that are disconnected. (I work for an electric company) I have it set up to add, edit or delete records and then if the record is in there, they can check a box that it is reconnected and then later, i can go in and run a script to remove all connected accounts. What I would like to do is add a "screen" when they open the file that allows them to log i…

Ok, I'm using FMStarting Point and haven't really modified it too much so hopefully your familiar with the layout. I have a field for each of the following: Date Name Subtotal Total We sell about 20 products, but are broken down into 4 categories (Product 1) (Product 1 Accessories)(Product 2) (Product 2 Accessories). Our accountant is wanting totals from each of the following categories which would also need sorted by date. I've gotten it to work with Find, but it's finding every invoice that has for example "Product 1" in it and getting a total from that, when Rather I need it to only take the price of "Product 1". I can try to expla…

Hey All, I am working on a solution where each administrator has their own page. In order to keep the number of layouts I have to a minimum I was wondering if anyone had found a way to change visual objects, such as a menu, based on a field. Confusing Right? For Example SET- will be a text field, each time I click a button, the field would be set with the script parameter, ie. the word written on the button, signifying which menu set I would like to appear. MENU Students Room Manipulation Public Area Damage Lets say I select the Students button. Without the Layout changing I would like to bring up a students menu so that the user can decide wh…

I've set up a portal with several tabs. There's a field which shows up under several tabs which is an irritation. Can't understand why. It seems to be related to its position in the tab where it is supposed to show - it is near the bottom. If I move the field up (problem is there's not much room) then it disappears. What am I missing?

I have a NAME field on a layout that displays a full name that is a concatenation of First, Middle and Last names from a parent table. (Obviously, as a calc field, the data cannot be edited here.) I have formatted the field as a button so that in Browse mode the user can click it and be taken to the parent record in a different layout. However, I would like the field to be Searchable, so I have enable entry in Find mode. If the cursor is in a different field on the layout and I enter Find mode, the NAME field is not enterable -- the cursor becomes a 'hand' icon and cannot enter the field (the button doesn't trigger either, since it's a "GTRR" button. If th…

Hello everyone, I have a new project. My company has a new contract and I'm setting up billing on FM 9 Adv. The fields necessary are simple: person who received service, date, customer #, and three more, BUT there are 30 different counties who will be billed about 22 of which who use one form and the others who have their own form, and just to make things interesting, those 22 each have their own unique information(address, telephone) that goes onto that most common form. So, my thought is to have a data entry layout with a drop down list for the 30 counties, and then have 30 layouts for printing the bills. I can program it the way I have describ…

I have been trying to come out with a summary field that totals i.e. "total amount owed" from another file or database. I could script it, copy and paste, but since files are related I just wanted to know if there is anyone that has tried to do this before. thanks in advance

I created a db on a Mac, OS X Leopard in FileMaker Pro 11. I used Lucinda Grande for the font. I thought that this font would be rendered through/as* Lucinda Sans Unicode on Windows (see chart). However, when I copied the file from my Mac to Windows 7 on my VM Fusion, it becomes Arial. In fact, I had to add Lucinda Sans Unicode to FileMaker; apparently it is on Windows 7 but not necessary available to FileMaker until it is added via Configure/More Fonts... in the formating bar in Layout Mode. So, I added Lucinda Sans Unicode and deleted the file. Then, I copied the master file over from the Mac side again, but the font still renders as Arial, even though Lucinda…

I have the latest version of FM Pro 11 Adv, and running on a Macbook Pro with Snow Leopard. I am trying to create a report layout but I need more than the 11 page limit. It is a report that is populated from many fields from a number of different linked tables. It certainly would suite a mail merge into word as there is an enormous amount of text around the populated fields. However I seem to be having difficulty in word allowing more than one table to be referenced, also. The report layout in FM is limited to about 11 pages so this presents a problem. Do I have to do the report in 3 different layouts and then merge somehow? Why is it so long? It is for Buil…

Hi friends! I have a field which holds a large number (ten digits). When I type the number, for example, 1234567890, and leave the field, the number in the layout converts to 1,2346+e09, and I don't want that conversion because the user should see the entire value. How can i fix this? Thank you very much!!!

Can I choose orientation vertical or horizontal a4 paper for each layout, because I need to print some documents in vertical and other in horizontal orientation?

I have a database for a Resident’s association that charges an annual fee. If residents do not pay this fee the association places a lien on their property. The lien form has to follow a specific format set by the State. We can only place a max of 4 records on each form. Each record needs 2 lines to show data. See layout below. I can sort to a residents list that are past due. What I want to do is add a check box to this list and choose which records to transfer to the Lien form, so I can limit them to 4 or less records. Can this be done and can I use 2 lines per record? Portal? Can someone point me in the right direction? Thanks. NAME AND ADDRESS (space) LOT NU…

I am working on a solution to fill out standard forms. I have these forms in PDF format. In order to ensure that my layouts will look exactly like the form, I have taken the PDF version and inserted it into my layout, as the background, and then just put my fields in the proper places so that it will print using the PDF as the "Template". This way I don't need to totally recreate the form in FMP, and it will be exactly like the standard format that we must follow. The problem is that the PDF consistantly prints out in a low resolution. I can print the PDF in Preview or Acrobat and it looks great. Insert it into FMP and it looks great on screen, even zoomed in all th…

Does anyone know if there's a layout folder limit with FM 11? I seem to have run into one ...

I have a text field that displays on a layout that is present for display purposes only. It is set to disallow entry. Data for that field is entered on a different layout. Often the data in the field is too long for the length of the display field. In this case it displays a question mark. I feel like in earlier versions it showed as much of the line as it could fit, which is what I need. The operator should be able to see the first few words and can click if he/she wants to be taken to a layout where they can see the whole thing. Thoughts?

I have tried to find the answer to this and it appears to be answered in many different places, yet it doesn't work for me. I thought I'd try this: I have two tables- Table A: Includes items completed (fields include item, date, employee who completed) and Table B: Hours worked by each employee (Fields include, hours, date, employee). Always, employees have multiple records per date in table A. Occasionally, employees have multiple records in Table B per date. I need to create a summary report that will compute # of items completed per hour worked, break field: Date. Is this possible? How?

Hi. I am looking for a method/trick to get around a small problem I am having. I have a splash sceen that uses an image of 800 x 600 as the background. The database is used over a WAN connection so, depending on the link speed, can take up to 3 seconds to load. I know that some of you are going to come back with the comment that I shouldnt be attempting this but I am looking for information WHY it does what it does so I can work on a solution that best fits. My problem doesnt seem to be too much different from http://fmforums.com/forum/topic/77847-freeze-window/page__p__364750__hl__image+load+order+layout__fromsearch__1#entry364750 but the topic went dead. …

I need to show summarized sales data for vendors and countries. The straightforward way that works fine is to create two summary parts: the first summarizes by a vendor's Country; under that are summaries for each vendor in that country. So I have something like this: But because I need to print this on one page with other information above it, I can make it fit if I can put the country summary on the first line of the first Company summary, like this: (I hope this shows up well once I post it.) You see this takes up about half the space of the first report. The challenge is to get the correct country summary on the same line as the first co…

FM11 advanced. I want to 'freeze' the window on a 'promotional' layout in the script run upon file opening while the solution goes about initializing data etc. The first script step is 'go to layout(promoLayout)'. The second step is 'Freeze Window'. The 3rd step goes to another layout. FM immediately takes the screen to this other layout. Why doesn't the solution leave the screen on the first layout?

A customer of mine is keen to have "open access" to the database to create ad-hoc reports via new layouts which aren't built into the system. As a developer I'm obviously not keen to allow table level access and to date have never provided such an feature in any bespoke system I've written for obvious reasons. However they are a charity with a small budget and next year will need some new reports that they can't possibly know about now, and they can't afford my fees to keep changing the system for ad-hoc requirements. I've thought about creating an export data set, into a FMP merge file which they can then open in FMP and create custom reports themselves (they h…

Can someone help me with this? I have several layouts with a "Zoom In" button and a "Zoom Out" button. For some reason I cannot get the Zoom Out button to work. I can choose Zoom Out from the menu and that's fine or I can hit Shift-F3 but the button won't work. I have discovered that if I open the File in FM10 it works fine but if I try any of the layouts in FM11 the Zoom Out won't work.

I'm fairly new to Filemaker. I'm trying to add a Drop Down Calendar. I set up a date field and then formatted it as a Drop Down Calendar. When I see it on the form, it looks good so far - I click on it and see the month and can select a dat. But then the problems start... I get a beep and a warning message "The value of tis field must be a valid date in the range of years 1 to 4000 and should look like "25/12/2003". Now the date shows as 25 12 2003, so I go to Edit Layout, Select Date Format and select the layout that gives 25/12/2003. But the next date I try to select, it resets to 25 12 2003, beeps and I get the same error message.I then have to Revert Fi…

I'm an absolute newbie to Filemaker. One thing that I can't quite figure out is how to display a table to a user while in Form View. I can get it to work with a portal, but isn't there a way to list information in Form View from the table associated with the layout? If a portal is the only way, how do you let the user search? I read that you are supposed to use tabs, with a different portal on each tab, but that gets cumbersome pretty quick. Thanks

Hi All My company are still in the process of migrating from FM6 to FM11. We are currently in the process of double entry testing - we have selected users in the office who are doing their daily jobs in FileMaker 6 and FileMaker 11 to test everything behaves as it should do. However there is one small thing which is causing our users problems... In the Window menu in FileMaker 11 it shows the name of the server the file is being hosted from in brackets. This means that most of the actual file name is obscured - this causes particular problems as we have a large number of files (125) a lot of which have similar names. This means that users may have to click on 3 …

Hi Is there any way to link account details (set up in Security) to a layout form in the database so users could update their passwords and low level administrators could update passwords and usernames. Rather than go through the menu path. Also for full administrators to add new users. Thanks in advance Cheers

I know I have done this in the past but can't find my notes. Is there a simple method of displaying the running count of records grouped by category and resetting each time category changes. i.e. DVD's grouped and sorted by category and title. Want the count to reset to 1 each time a new Category is displayed. I realize I can create a Script to run each time I use the report and create a field which is updated with the appropriate number but wonder is there an easier way. The option of using "Restart Summary for each Sorted Group" on the Summary field does not seem to be available.

I would like to create a list of documents (within an established database), similar to what would be seen in Excel, as follows: the first column would be dates, the second the name of the document (hyperlinked to the corresponding file on my machine) and the third column would be a memo field. See attached image. Can I do that in FMP? I would like the list to be sorted by date, if possible. Thank you, Norm

Hello everyone, I 'm not quite sure if this is the appropriate section of this forum, but I have the following question. I have built a medical database and in the report layout it has various objects (rectangular boxes for different sections, such as history, medications, complications etc) which contain all the available information about a patient (either true or false). My concern is that this kind of report is too lengthy (e.g. it needs approximately 20 pages for printing). This is a kind of extended report which I want to include in my database. I also want to create an abbreviated report based on the previous report which will only contain my true values (e…

Hello all, I am a beginner to Filemaker Pro and hoping for some advice. Also, apologies if this has been addressed already. I'm creating a survey database for school based health centers; this survey is meant to either be filled out by students on a computer, OR enable a research analyst to quickly enter the data from paper based forms. After reading several threads on this forum about survey design, I think I have a decent model (please see attached). As depicted in the diagram below, I have split the relationship graph into two components. The top half in yellow represents survey responses with unique combinations of questions and responses. The bottom blue-gre…

Good Morning, I'm trying to put together a layout that will allow end users to select items to be printed in a report. The selections are laid out hierarchically, and there will eventually be several hundred choices, so the best format would be an expanding tree structure with checkboxes to allow someone to select an entire directory or expand it out and only select certain pieces of equipment. The structure may rarely require going down as many as six levels, although most often the user will only be drilling down three or four levels for the report. I did a quick Google search and came up with a few older postings referring to a Multilevels example found on fusi…

Is there someone willing to help me figure a solution to get a report designed like the one I have attached. It is based on 4 tables and needs to be easily produced every day by novice users. It is a daily job sheet for my crew. The description field in the JobLineItems table is sometimes lengthy so I am trying to base the layout on this table so I can incorporate sliding. When I try to use the Jobs (parent table) with a portal based on JobLineItems I have to make ALL of the rows extra large to anticipate only a few lengthy descriptions. Other problems are how to easily produce the essential criteria for the report which is the SheduleDate field, ScheduleFrom field, Sched…

I have built a calendar in one of my databases that needs to be in Preview mode with printing 7 rows across for it to layout correct. I would like a view it on my ipad through filemaker go and as we know you can't view in Preview mode with Filemaker Go. does anyone know how to layout records in Browse mode across and down. I'm guessing the answer will be with portals and record repetitions. I just can't get my head around it thanking you in advance (a template is the easiest way to explain to me but i'll take any advise)

My users would like to be able to use the mouse scroll wheel to scroll vertically down the layout instead of scrolling through records. Is there a file option or a FileMaker preferences option to achieve this? I've read that this might be possible by hiding and locking the status area, but ideally the users would still have access to the Status Area and while being able to scroll down the layout using the mouse scroll wheel. Edit: I just tested the hide/lock status area. It does prevent scrolling to the next record but you still can't scroll vertically down the layout. Thanks

This is under FM 11 ADV When SET STATUS is OFF: When SET STATUS IS ON: When in LAYOUT mode: Has anyone experienced anything like this? The area in yellow 'expands to overlap the area below. Weird... What am I missing? Thanks

I have 5 layouts. 4 of the layouts 'can' access layout #3. I want Layout #3 to have a "RETURN" button that when pressed, takes the user back to the 'original' layout from which they came. Seems like GOTO LAYOUT ORIGINAL should do that? I created a button and in Button Setup specified Goto Layout - Original. It does NOTHING. So, I wrote a script and put GOTO lAYOUT -ORIGINAL in the script and hooked it up to button. I tracked it in debug... it executes but goes NOWHERE. (Yes, all the layouts are checked in layout management) There are no error codes. Got ideas? Thanks

I have a file with about 1000 records. Upon going to certain layouts I get that hour glass icon while the records are being sorted... Also while opening the file or updating records via script I get a coffee icon. Could those be replaced with a progress bar? No idea about this, or how to go about it if possible. Thanks.,

Hello Everyone - Long time listener, first time poster. While I've been a Filemaker end-user for years, I'm just now getting around to developing my own custom solution. I'm self teaching via John Mark Osborne's (excellent) VTC video tutorials and I have a two part question that I hope someone can shed some light on. The project is pretty straight-forward invoicing solution with a few twists: I'm developing a solution for a bakery to help manage kitchen production. The bakery takes ORDERS from CLIENTS on a weekly basis. Each order consists of multiple LINE ITEMS, indicating a particular ITEM to be baked, the quantity, price per item, and delivery day (Mon, Tues…

Hi all I am trying to replicate the native Filemaker status bar. Two reasons for this. My aunt who I'm developing the database for wants certain extras on the toolbar and I have used an archiving system that makes the found set and total record data inaccurate. I am having trouble with two things: (1) Disabling the small toggle status bar icon in the bottom left corner (2) Replicating the green found set pie chart I have tried creating a chart using my total live records calculation field and my total found calculation field. In value data I have specified the two fields aforementioned and set use data from current record. No chart displays, …

I've got a single Filemaker database that contains tables for supporting three separate but business-related databases, Loans, RMAs and Rejects. (This also links to a number of other legacy databases which support other aspects of the business.) I present these to the user in separate windows, so they see them as three discrete databases. I set the windows up with a set of script steps which test to see if the desired database is "open" and if not, set it up in it's own named window, then select an appropriate layout for that database. This works most of the time, but now and again the window 'disappears' from the window list. In the attached example, yo…

never mind. Question: "Isn't there someway for a poster to remove a posting?"

Hi all, I recently saw a solution that enabled the user to create their own letter templates. The user could also add various merge fields from a list on the right hand side to the body of the text and then save the letter as a template. Then when it came to printing a letter to a contact in the database, the user has a choice of previously saved templates to send to them. Unfortunately this solution is locked and I can't see how it is done. We have a need to create different types of letters all the time and so have a huge list of different layouts for each one. It strikes me that using a letter template, you could have just one layout which changed according …

Hey, In my database table, I have 6000+ records from four different years. I have created a data entry layout to display this data and also edit/enter new data. I would like to display only records of one particular year at a time. Very rarely a user goes back to viewing previous years' data. Hence, I would like to display 1500+ records of the current year and then if the user wishes (say changes the value of an input field) then I would like to display other records. Is this possible? Can you please tell me how can I implement this in FM Pro 11? Thanks,

For some reason, I cannot add borders. When I check the boxes left right top and bottom it doesn't show any borders. Also, when I click in a field in browse mode it doesn't show the cursor, text selection or anything I am typing in there. I have to click out of the field to see what I typed... Also also, when in layout mode, when I select a field to move I don't get the border and little resize things in the corners. Anyone seen these issues before?

I'm working in FMP11 Advanced on a Windows 7 client, working on a set of server hosted databases. I'm using a generic print system where I put the page to print into a new window, and control page preview using a small preview control window with controls to browse pages, scroll, print and so on. The preview control window is presented with a pause/resume indefinitely script set in a loop construct with Allow User abort off; this means that this window will stay at the front and not allow direct interaction with any of the windows underneath until the user presses a button set to halt the current script when clicked. Well so I thought - it turns out that you can…

Does anyone know where I can get a FMP reference file that provides the 'button corner's, ' box corners'....etc...? I have a memory that FM used to offer this but I can't find it now? Thanks

Hi guys, Sorry if this is a stupid question.... Im one of those newbie guys that has designed some fairly cool databases but only from trial and error mostly. I look to you guys when I simply cant figure it out. I've searched around and cant find what Im looking for. What Im doing is a database for my photography business. I want to be able to have the database open while Im shooting school photos of students. Prior to shooting the photos, the students will be inputing information into the database such as name, address, phone number, etc. After shooting the photo, I would like to be able to go to the image file and somehow put it into the database as a referen…

I have two tables in one file. I created a huge number of fields in table "b". And now, I need these fields in table "a", without records. I only need these fields in table "a", I do not want to create these fields again. Is it possible?

Is there a simple fix for a zero value that keeps displaying as "$1.00"? All of my fields are rounded to two decimal places, but when I type in a "0" in one of my fields this particular calculation field I have displays it as "$1.00." I have played around with the round function, to no avail. Any other ideas?

Hi There -- I have a products table with a products detail join table, with a "product key" tying them together. I am trying to get a layout working where I can have multiple products on the page (six on a page, in my graphic example). I am very well aware of portals and relationships, but the hitch that I have is I want to have different positions for the record information. In other words (refer to picture for clarification) -- basically have a product name (heading) and then a portal to the product info, and have a picture on the (right) or (left) of the portal. I tried numerous variations on "GetNthRecord", but altough it would work fine with a full…

Howdy, Can any one tell me how to get the total number of records on a form? I want the main page to have a text line that shows the Total Records in the database. I have found the Insert "Record Number Symbol", but, correct me if I'm wrong, that represents the current number being browsed, not the total number of records? Cheers

I created a product catalog that has several categories of products (ie. audio, lighting, parts, props, etc.). Now in the report view I would like to have it with the category title and then the products in that category underneath it and then the next category title and so on. Kind of like this: Category title Product Product etc etc Category title Product Product Etc I am sure it's something stupid easy but I couldn't find the answer so any help would be greatly appreciated. I am leaving for a convention on friday and wanted to be able to take this with me. Thanks.

In the image below there are two CommNonComm fields. The one at the top is a standard text field. The one below it is actually 2 fields set up as one item radio buttons. Each one of these activates a different script trigger. As you can see, both comm and noncomm are highlighted. This could create confusion among employees. What I would like to do is place the upper (text) field over the lower fields but I need for the script triggers to activate when I make a selection. Is there any way for FMP to see-thru the upper field yet still show a selection? Or, is there any way to divide the upper field into two parts so whichever is selected performs the proper s…

I have placed a pdf in a container and use it in the background of a layout. This way, I can print out the pdf with my database fields populating various components of the pdf. It seems to be working well, but only the first page of the pdf is accessible. Is there a way to access the other pages of the pdf? Thank you, Fed

I have a many-to-many relationship that is not producing the sub-summary sort that I expect to see. Basically, I can add a portal viewing the relationship that I want to sort and I can see all of my related records. however, when I switch the layout to a list view and add a sub-summary section using the same relationship that worked in the portal, I can only see the first related record after I do my sort. What gives? I've never had any problem with sub-summary sorts before but this is driving me up the wall.

Hi I have a problem with the fields and adjacent subtitles on the layout when I print out a report from Filemaker. It seems that whilst the layouts all look aligned and neat, when I print out the actual report, a subtitle and corresponding field seem ever so slightly misaligned. I have been through the sliding menus but this just does not seem to do anything and I still have the same issue. Does any one have any idea on how I can tie together both the subtitle and field so that they are always aligned horizontally. It just look a bit unprofessional and messy at the moment! Thanks

I've noticed that in order to change the text on a button, I need to remove the action (like a script) on that button. Only then can I access the text on the button. Then I need to reset the action on that button. I think I am missing something. Is there an easier way to change the text on a button? Thank you, Fed

Ok, so I'm pretty much completly new to FM. I'm using FM Starting Point as my well.. Starting point. The invoices that it generates only accept up to 19 Rows of line items then it won't print anymore. I'm in need of how to make it generate more pages if there is more line items. Sometimes it could be up to a couple hundred rows, so It'd need to go from 1 page up to however many is needed, with the totals etc only on the last page, and the header information etc maybe on all the pages? I've searched the forums, but I can't find out how to do this in more simple terms. I've seen something about having relationships with portals and printing from line items, …

Everytime I think I have it I get confused. I have an EXCEL spreadsheet with 500 students listed on it. It has their grades by what period and who the teacher is. Not all students have all 7 periods. Some have one some have more than one. This report is only for failures. The periods are listed under the column Period. I am not sure how to set up the layout to be able to accept the import correctly. In other words I know when I import I am importing the column with the period but that stduent my have more than one period. How does the layout know? I have attached a sample of the EXCEL spreadsheet. It has two students, one has only one class failing the other on…

Is there a way to use a script to change the 'behaviour' of a field on a layout in browse mode? I have some fields that are not accessible to be changed on a layout, but I would like to have a button to be pressed to allow access to that field. Thanks, Fed

Is there any way to automatically highlight the position attributes upon entry in the Inspector?

We've seen it all the time on websites... In a untouched field it gives some sample data grayed out to let you know what format to enter your information. Once you click in the field it disappears never to show again, even if you don't enter information. Is there a way to do this in Filemaker?

Hi all, I'm looking for a solution to a text formating issue. The project I'm working on requires a section where users can build and manager legal templates. Part of this section requires the ability to add pre-set legal clauses to the templates. What I would like to be able to do is have a List of available clauses (portal) beside the document and the user would click the required clause and have it inserted into the active document with preset formating. like this The project I'm working on requires a section where they can manage and build legal templates and part of this involves adding in pre-set legal clauses to the documents. What I …

Hello everyone, I'm looking for checkboxes other than the filemaker's native one. Has anyone some advice on either creating a custom checkbox or adding a plug-in that will give me the functionality I'm looking for? Thank you in advance, Levon

I'm having a royal brain hernia trying to get a count of the ATT Dates used in a report. Please refer to the attached file. Go to the Attendance xStudent layout, sort it, then go to Preview mode. You'll see the results in the attached screen shot. Here's where I'm stuck: How can I get a count of Att Dates? There's eight of them and I want to put that count somewhere on-screen. I can count the separate periods and their total as seen on the right, but after trying all kinds of calculations and permutations I'm stuck. TIA for your help! Rich test.fp7.zip

Is there a max number of columns that a table view will display. Thanks Michael

hey. 1.i need to make a : like i have this data in the field drop-down menu: UTILS,SYSTEM,AUDIO SOFTWARE and i want to make matching picture appear when i select each one. when i select utils from the drop-down menu the picture that will appear will be a UTILITIS PICTURE etc.... 2.i will also like to know know how i can make those fancy check boxex with picture. 3.please help me i don't understand how to do this 4.thanks

How would I combine similar records? I'm showing a condensed version of a report and want all of the same categories to be combined into one sum total. See attached for better explanation. Thanks!

All, I want to create rental forms for our property management business. I have about 30 properties so I would want a data base that will identify the property and put the address and specifics on the rental form and other forms, use in rentup and vacating. Then I would want to pull the tenant from a different data base so his information would be automatically shown on all the forms. What is the best way to do this... pulling info from two different data bases, or perhaps combined into one, but have the ability to select the data once and it appears on all forms. So, the end result would be: Enter tenant into data base, Select layout that has …

Hello everyone, this is my first post here Anyway, here's my issue: in my company we had FileMaker 4.0 for ages (for cataloging purposes, quite important part of our business) and recently we decided to switch to FM11 (got only 2 licences so far). Suprisingly enough, importing that ancient database from FM 4 to FM 11 went rather smooth, except for a minor (but for us crucial font issue). As it is, we have our own company font for years, which we use for printing out labels and stuff and its important that we keep it. But when I try to ratrieve mentioned font type, using "more fonts" option, they simply do not apply. Same goes for eg. Symbol font. Selected text ch…

I have a several layouts which display a number field which is an auto entered serial number. When I made an invoice layout, I included this same field, and it correctly displays the number. But when I hit "PREVIEW" to look at how it will appear when printed, no numbers show up in the field. This only happens when in PREVIEW. What am I doing wrong here? Thanks so much Tom

Hello to all Please excuse me if I have logged this question in the wrong forum. If I have, please advise. I have a table Called Art. Among Art's numerous fields is a field called Pic. Pic stores the filename of the picture file. The picture files are stored in C:\Artpics\ I know FM can store image files within itself, but in this case I can't go that way. Another person needs access to the picture files in a different way so this is the solution we came up with. Is there a way to include the image file in my reports by using the field Pic and knowing the location path of the directory? Any suggestions? John

Hi. I am having trouble with a layout and would like some assistance please. I have read through a number of article in this forum but not found quite the same problem listed, although I have heard a few people grumbling about sliding objects. The problem I am having relates to the Parts of the layout Im using. The report (a quote) is to have a major block of text at the top of the first page (Title Header), the main Body of the text (this is the problem area) and then Footers and Trailing Grand Summary. I think I have the tops and bottoms worked out, but the main text is giving me grief. After unsuccessfully trying to use a single layout (which is my …

Greeting, perhaps I can get some help. I am trying to create a Budget/Chart of accounts solution. I have 2 tables -1, Chart of Account which includes a unique 4 number account code (eg 3012) and a budget amount The second table is Line Items which contains an account code and an amount. The 2 files are linked via the 4 number account code I have a layout where I can go to a Chart of Account record and enter line items via a portal. So far so good. The problem I'm having is this - I have many more records in my Chart of Accounts than I do line items. I need to create a report that shows every record in the Chart of Accounts and all the detail, ev…

Hi~ I am looking to see if there is a way, I am assuming using a script trigger, to have the color of a Tab change based on a radio button selection? For example the Tabs would be "Print" , "Ad", and "Digital". If a person selected "Print" from a radio button in a field outside the Tab area, it would make the "Print" Tab color turn Red and the text inside white. Any help would be greatly appreciated! Thanks All!!

Hello. I'm new to Filemaker and am using version 9. A quick question: Is it possible to change the background color of a form? I figured out how to change the field box colors. I also created check boxes, radio buttons, and a drop down menu, and figured out how to change their colors. Is this possible? I went into Layout Setup and looked around, and saw there are various layout designs with various colors, but I just want the body to be light yellow, without having to create a new layout. Thank you! Jd

Here is another description of the problem: I have a table called Members. On this table (in a 1:many) is Dues which is a portal. The fields on the Dues portal are: DATE DUES PAIDYEAR Date has an ONOBJECTSAVE trigger that runs a script called DuesDefault. DuesDefault looks like this: Go to Field PAIDYEAR -- This works IF --- setfield (all setfields work and are on the portal... but still on Members. Else-- setfield ENDIF IF--- setfield Else setfield ENDIF >>>As I run Debugger, I can see that the Go To Field sends the cursor to PAIDYEAR but... when the script falls out of the…

Hello everyone, I think that I need some help on how I can accomplish something. I have a table that represents banks. and an other that has the account name de debit the credit and the sum. Until now it worked fine. But now I have a new need. I want to have merged accounts What I mean by that. I have lets say a loan that is linked to a bank account the pays the loan. So I would like to have a layout that has both accounts side by side. Let me explain. I need something like this: Date | comment | account 1 credit | account 1 debit | account 1 sum | account 2 credit | account 2 debit | account 2 sum shown in list view. so if someth…

Hey all, I'm a brand new FM user but have a good amount of tech savvy. I'm working in FM10 Advanced. I'm creating a database for a music library. I used the FM "Music Library" template to start out but my catalog is song based and not album/disc based so I had to do some editing, i.e. "Album Name" is now "Song Name." I took the portal in the template that was intended for tracks/songs and made it for Composers and their associated writer affiliations, percentage shares, etc. (changed the related table name to "Composers"). I used the existing portal because I couldn't quite figure out how to build it from scratch so i just replaced names, validations, etc. t…

Hi there ! I've created a long time ago a database for our client's list, Service Calls and Route Planning. The Client List and the Service Calls are related by the phone number of the client. So when we create a new service call, there's a script that copy/paste the phone number from the list to the service call. All the other fields ( Name, address, City, etc. ) are "lookup" so they "enter" automatically. When we do the route planning for a particular day, there's a script that find the service calls for that day and copy/paste all the info of the service calls ONE by ONE in seperate fields for seperate service call. Now that we have 2 different client's lists and …

Hello to all I hope someone has a possible solution to my problem. I have a Report called Contact List. It shows contact information for all the people I have in my table. The use can use various finds to cull the list of contacts. So I'll cull my list and then print it. Days later I'll forget who makes up the content of my list. Sometimes it's easy; oh they are all from the same city. Sometimes it's not to easy to tell as I have many different fields that I can do "finds" by. I can't make a specific report with a specific title because there are far too many permutations. So I've started writing down "subtitles" on the report who is on the lis…

Hello, I'll do my best to explain my situation. I have a table of records that represent defects based on each job number. So for each job number I could have 5 records linked to that job number describing each defect and the quantity of each one. In order to do defect rates based on job number I have a field called job_qty that looks up the quantity for that job number from the job table. The problem is that when I go to do a summary that gives the total job_qty the value is incorrect because it adds up each one of the 5 entries as a different value instead of combining them into the same job quantity. I hope that makes sense. Let me know if I need to ex…

This is a strange one. I have a client who when they click into a field the data looks like it disappears...when you come out of the field the data reappears......this also happens in find mode, when you click into a field and start typing the search criteria you cannot see the text entered until you exit the field. There is no script trigger or conditional formatting on the field. It happens to any field on the screen. Client is using FMP 11 on an XP service pack 3 machine. It looks like it only happens on this machine as when testing from another machine there is no problem....does anyone know what is happening here

Greetings all; I have phone numbers stored into the database, however some of them are formatted as (01) 2345 6789 and others are 01 2345 6789. What i want is it to check to see if it is formatted as "" and if so do this code "(" & Left ( ${Phone Number1 (Imported)} ; 2) & ")" & " " & Middle ( ${Phone Number1 (Imported)}; 4; 4) & " " & Right ( ${Phone Number1 (Imported)} ; 4) otherwise just copy the "phone number imported" to the field "phone number"

I know it will be something obvious but I cant see what it is: In a couple of my databases I seem to have lost the ability to resize the body of the layout, but only in the last couple of days. I have unlocked all the field in the layout to no avail. suggestions? Actually, the more I check the more widespread the problem is....

Hi all I have created a layout which is solely displayed as a list. The layout has been designed co create a faux table (for info, the table headers/titles sit within a 'Leading Grand Summary' part). Is there a method to resize a field object dynamicaly, so that the object size is greater than the width that is necessary to display the full field content? Another question (slightly related) is why if a file developed within Windows, when loaded on Mac, does the current font switch from Arial to Lucida Grande? I'm assuming it may be that the Mac PC (not my machine; I don't own a Mac) on which database has been loaded, does not have the Arial font set as stan…

All, Is there a way to preset a font and size so that no matter what font is entered into a field it comes out the same. OR is there a way that I can change all the contents in a field for the whole data base to one font and size. Right now, I'm doing every line by hand and it's painfully slow. Thanks. Larryo

Does anyone know how I can create an outliner in FileMaker? I'm still using an ancient version FileMaker 7 so seeing if there is something I can utilize with this. An outliner where there are headings, then you click on a heading and subheadings appear under it. Often used in task management. > Some topic 1 > Some topic 2 > Some topic 3 > Some topic 1 | Some topic 2 subcontent line one subcontent line two subcontent line three > Some topic 3

Hello to all I am new to FM so I would appreciate the help. Is there a way to get all of my sub summaries in my report to all appear at the end of the report? I kind of want a summary of my sub summaries to display as the last thing on my report? How do I accomplish this? John

Hi All, I have filemaker 9 installed on my machine, the database is on our server. Everytime I open something in filemaker (for example contacts) the window is small, I would like it to open maximised and zoomed in if possible. Is there a setting somewhere that allows you to change this? Thanks

I cannot think of a solution to this problem. I have some related records in a portal. I want for example to get all the suppliers names form a column and make them into a single text field to display in a merge field on another layout. I'm sure this is possible and probably easy but I cannot think of a solution. Any help would be appreciated. :mellow: Cheers Patrick

Hi, I have text that exceeds the portal size. I'd like to crop the text, but include an ellipsis to indicate that there's more to read. Any thoughts on how to do this? Thanks!!! :)

Hi I have Filemaker pro 10 running on a small Mac network. For some reason recently when we open the file from some machines, the opening window is most of the way off the screen and there is no status bar. This can be dealt with each time by tiling the window and manually resizing it and showing the status bar, but the next time the file is opened it does the same thing. How do I reset it once and for all? Thanks Sue

I have a sub summary with three fields; sumqty, serial_qty, and reject_percent. sumqty is a summary field which is a total of the "qty" field. serial_qty is a calculation field that basically looks up a value from another table. reject_percent is a calculation field that = ( sumqty / serial_qty )* 100 In the report, the sumqty and serial_qty are correct and change according to how the report is sorted. The reject_percent, however, always calculates based on the sumqty of EVERYTHING in the table. For example: sumqty | serial_qty | reject_percent 340 | 4605 | 693% When I look in t…

Hello! I'm trying to figure out how to make a report with option to group data and totals by months and quarters of a year. Knowing how to find a range of dates with globals, I just don't understand how to find several ranges and group data in a readable report. Does somebody have any clues? Sorry for this may be silly question. Thank you in advance, Serge

I have a field, set as date & indexed. In the layout it has the dropdown calendar for selection. The user wants to key in a date as well as use the calendar. It is acting like autofill is selected for this field, but that is not an option. For instance, we want to enter 2/15/2011. You can enter the 2/1, but it autofills to 2/1/2011. It will not allow for the second digit entry. Is there a way to correct this, to allow both dropdown calendar and type in values? thanks,