Layouts

Okay, I must ask because I had spent a hundred hours searching for the answer to this, over my 6 years using FM. And a friend pointed, clicked and showed me in 1 second. But it is NOT anywhere in FileMaker Help that I can find. Does anyone know where there is a reference to this functionality? I've struggled with the body tab being over the layout where I want to place a field. I had seen some people's files where the body went up the side vertically instead of horizontally (same with all parts). I was shown that the little box on the status bar (while in layout mode) that looks like a very tiny tab on a layout actually toggles where the part labels reside. I …

I have 2 layouts (layout 1 and layout 2 for these purposes) that have the same field information from the same table within them but everytime I create a new record for layout 1 it will create a record for layout 2. I do not want this to happen, I only want layout 2 when I select a new record for layout 2. Do I need to create a new table of fields for layout 2 or is their an easier way around this? A lot of the fields for layout 1 are common in layout 2, can a table with all the fields be copied and renamed as a new table or do they need to be recreated? Thanks!

Trouble deciding which forum to put this in, so moderator feel free to move it. When I click and release the left mouse button on a button in the database, no action happens until I move the mouse away from the button. This same thing happens when I am designing a layout. I can't move a field or label if the mouse cursor is resting on it. I have to click, release, and move the cursor in order for any action to take place. This only happens on my laptop. Any clues?

I'm trying to identify duplicate URLs (for thumbnail images) in a database, in order to identify "stand-in" images that should not be shown (for example, many merchants have a standard image that says "image not available" which is silly for me to display). I've defined a summary field called "count_of_thumb" and I've tried creating new layouts several different ways, but all I ever end up with is either all 1's or all values the same (being the count of all records, I'm not sure if it's all records with a value in the field or a count of unique valies). Clearly I am not understanding the concept of a "summary field" or a "subsummary" in a layout. I've trie…

This has me very confused. I am trying to put together a report. In a subsummary there is a calculation field. The calculation is based on two summary fields. Basically s_TotalEarned - s_TotalUsed. In the sub-summary where I seperate by people I also display these two fields and they look fine. But the calculation field shows data that is s_TotalEarned - s_TotalUsed(but for everyone in the query). These records keep track of how much is used. The amount earned is calculated elsewhere, so I cannot do the subtraction in each records then summarize that field. Does anyone know a way around this?

hi there : I'm setting up a database for medical records for an acupuncture clinic.... each patient will have their own record, and within that record, the patient will have basic contact info and medical history etc that all seems straight forward so far... but I'm a bit stuck on how to organise the patients treatments... I have a basic outline and layout of fields for a single treatment, [date of treatment, duration, objective signs & symptoms, subjective, progress, treatment given, points used etc] i wanted to "duplicate" those fields for the 2nd, 3rd, 4th treatments etc.... [up to 24 probably....] but when i duplicate or c…

hi how can make that in a drop down list i can select only what is in the drop down and not tape anything in the drop down?

I have a list layout. If you click on a line item ID field, I've got a New Window popping up with further details on the line item (the list only shows a small amount of data). Now the tricky part: to close the pop-up window, the user has to click the Close button on the window top (coming from the OS GUI, be it OS X or Win). Is there a way to script it so you can just hit Esc on the keyboard and make it go away? As always, many thanks, people.

Is there a way to script to open a New Window and position it so that its top left corner is where the mouse is currently? Something like, Get(CurrentMousePositionX/Y)?

I have a project that requires one layout of data to be printed in landscape and on legal 14" paper. All other forms for the same project/application are in portrait style 8.5 x 11 paper. It seems that there can be an "overall" setting of landscape OR portait but not a specific format for each individual layout ... Hopefully there is a way of accomplishing this probably a script but heh I'm a rookie Thanks anyone

I am new at Filemaker Pro 10, and I wanted to know, in the layout, is there a way to only allow entry into a field based on the value in another field? For example, let's say I have a field called "Individual or Company". The possible values are chosen from a value list and they are Individual and Company. If the selection is company, I want the user to be able to enter data in the Company Name field. I don't care if this is via a pop-up entry request window (not sure if this is possible), or if a new field can appear on the layout. I know that you can hide the field and make it appear based on another fields value, but wouldn't you run the risk that way of a user in…

Hi, I have 2 tables Products and Delivery Both have the columns ProductID and Product type. The relative data exists in both tables. Exp Products table ProductID ProductType P001 LowEnd P002 Medium Delivery Table ProductID ProductType P001 LowEnd P002 Medium Both the tables are in different Database. When I am in the Db containing Delivery Table, I need to link to products table. In the relations I create a table Products_Delivery and link them through Product ID and Product type. When I do that, the resultiong table has 2 records but with blank data and 0 count. When I delete the condition Pr…

We have recently moved from FM5.5 to FM9 on many of the PCs in our school but there are still many PCs and many databases which have not been update/converted. As a result we are having to maintain FM5.5 databases on PCs which have both FM9 and FM5.5 installed. There are no problems except that... In FM5.5, every time we create a new layout we get "Filemaker Pro.exe has encountered a problem and needs to close. We are sorry for the inconvenience." A new blank layout is the only one which works. Thanks.

I'm working in FileMaker Pro 7 on Mac. My goal is to print labels of my database. I choose layout mode, then "new/layout report", then records from my correct database, then "labels", then I specify label contents. After this, I look in preview mode of FileMaker and all of my labels look great. However, in preview mode when I go to print, only the first label is displayed. Consequently, only the first label of my database is printed. I've created labels taking these exact steps with other FileMaker Pro contact databases of mine, but with this database I have had no success and I don't understand why. Does anyone know what is happening? -Jenny

I have a field which extends across a page boundary. (set to slide when small amount of text). I loose a number of lines from one page to the other or the line is half cut off. This is making my database unusable. Any workarounds?

Does anyone know how to create a script to export the records only on page 1 in preview mode...I am trying to do a table of content for my records. many thanks. Kent

Hello. Two FM9 questions here: 1) I want a couple of fields to default to title capitalization, yet to be able to override this default on a per-record basis. That is, usually have text formatted by title capitalization, except to be able to change it when inappropriate--such as when Roman numerals are used: Henry VIII not Henry Viii It seems that I can only toggle the control in the Text.. dialog on a database-wide basis. 2) Is there a way to change the appearance of checkboxes--specifically, to make them larger?

I am helping someone create mailing labels from what I think is a predefined FileMaker Pro 9 database called Contact Management. (Someone else - who is gone - set up the database and entered the data.) There are fields for both Home and Work addresses. There is a section labeled "Preferred mailing address." Under this label are two boxes - one for Home and one for Work, with the check mark appearing in the preferred mailing address. If a record contains both the Home and Work addresses but the Work address is checked how do I get only the Work address to print on mailing labels? Likewise, if a record has both addresses but the Home is the preferred address how do I g…

I have a database that is tracking our server backup jobs. I am working with FMP 10 but the database is served on FM SErver 9.0.3. I have a layout that I have created 2 sub summaries that print above the records. The first sub summary is based on ServerName and the second sub summary is based on CheckBackupJob. There are 3 different value possiblities for the CheckBackupJobOn field (ServerConsole, BackupExec, DHOps). The backup job details is in the body. When I sort the records by CheckBackupJob and then Servername and then go into Preview Mode, It only shows one of the possibilities of the CheckBackupJobOn field and then lists all of the backupjob details under t…

I am going to print a huge list of addresses for sending out mail. Some of the names from the name field and address field are too long, and because of the size of the list, it would take too long time to cut them up and add more fields on the label, etc. Is there any way I can auto adjust the text that is too long, so it would fit the label?

I lose my page configuration to a especific size so i can save it as pdf without croping, everytime i close the aplication. Can i set something as a default so that stop happening?

I designed an essay layout report in form view that consists of ten questions, with answer fields below each question. These text fields are formatted with a scrollbar to accommodate extended amounts of text.The entire report fits on one page in browse mode as formatted. I want to print this report and have the answer fields expand appropriately, depending on the amount of text entered for each question. The printed report could end up with one page or ten pages, depending on the length of each answer. I know I need to set up a separate layout specifically designed for printing, but cannot format it correctly. I have asked for help before on this forum and have …

Can anyone explain to me why the fonts being displayed in my pop-up and drop-down value lists are different? The drop-down list provides a nice clean font, whilst using a pop-up for the same list provides a scrunched up font - barely readable. The attached screen shots show the problem.

Hello, Is there any way to have record data pulled into a crosstab summary based on month. I can get numerical data to flow, but not text fields associated with that number. I am trying to make an media schedule for ad buying. The structure of the report is seen in the attachment. I was able to get the data to pull for one month, but if there is an ad running in the same publication in the same year the other data won't show up. See "Aftermarket Business" row. I'm using a calculation for each month to grab the data: "Details Jan" Let (Month = Month(Issue Year) ; Case (Month = 1 ; GetField ( "Job # ") &"¶"&GetField ( "I.O. # ") &"…

Hi everyone, I have a report in Filemaker that utilizes sub-summaries and portals. It's set up exactly as I want it, but someone needs it exported as an Excel spreadsheet. However, when I try to export the individual fields to Excel (specifically the field I had set up a portal for), the sorting and ordering of the data I have in my report is lost. Is there a simple way to export my report to Excel so that it looks exactly the same as the report in FM? Thanks!

In FileMaker 10 (new real version) in "Edit Layout": When I try to go to "Button Setup", the layout freezes to the point that I have to do a force quit. I have a new MacBook Pro 2.8Gh/4GB/128GB SSD with all updates. I have tried a recover on the File without success. Any ideas?

I would like my Purchase order layout to work similar to the way quickbooks works. i.e. You type a few characters of the part number in the appropriate line item field and then a few matching part numbers are displayed in the dropdown menu. When you select the part number the rest of the fields are filled in by lookup. Is there a way to implement this kind of functionality in filemaker? Right now I have a popup selection routine where the user performs a find and selects the appropriate part. It works but it takes time if there are a lot of line items.

Hi, Me again. Another prpoblem I'm having between my iMac development vs. PC laptop deployment is that the colors on the PC are looking significantly different. For instance, all the shades of grey represented on the left-most column of colors in the 'fill' palette come out looking some degree of *lavender* on this PC, which spoils the whole look of the thing! Other colors are also significantly different. Is this known as a standard difference between the way Mac and PC colors work, or is it more likely to be a matter of this particular laptop being oddly calibrated? I want the solution to look good for the client -- but on the other hand, if it winds up being u…

I know this can be done. I just can't find in the manual the right words to find it. I have an invoice layout with links to a contact table & a calculation table. All I want is that when the invoice is finished, I can block the entry so that if the contact info or calculations change, they do not change automatically the invoice I have created. On the other hand, I still need to be able to change info in the entry if need be. many thanks

Hi, I have my layouts set, but when I use Kiosk mode the portal I have on a Tabbed layout just stays in the same place and I want it to be in the middle of the window. I've changed the anchor points but that has no effect. Any suggestions would be most welcomed!

Hi. I know this isn't the right place for this question, but I can't find the right place. So can someone please point me to it.....or just answer the question ... I have 3 value lists. The first one contains all the values from both of the other lists. When a value is chosen in the first list, I need to search both the other lists and match the value chosen in the first list. Based on which list (2nd or 3rd) I will set a value in another field. What I'm looking for is something like if (value1 (match (list1));0 else (value1 (match (list2);1 That's not the right form, but it's something like. What I don't seem to have is a "match" function. Can…

Can filemaker 9 (xp) import word documents (templates for letters) and then add fields within that container/ole word doc? i.e. the client has half a dozen of templates in word (tables and lots of graphics and formating) and they need to add fields to do mail-outs in Filemaker. The templates must also be modifiable for future proofing. odbc mail-merge or xml export is a last resort. what are my options guys? ta

I am working on a project for appraisals. I have generated a few layouts for entering clients information. Appraisal Information and Item Information. My end goal is to generate a single report based on the information entered which changes based on the input. The first attempt failed which I will try to explain here. The report would read something like as follows "As you requested, on <> I conducted an appraisal inspection in your presence... The objective of the appraisal was to estimate <> of the listed items for use in <>. The estimated costs are effective as of the inspection date. The goal is to have <> change…

Hello world i am brand new to this filemaker stuff and im sorry if this in the wrong area i have begun to make a cash register system for my work it is a small sandwich shop i have all my buttons for the sandwiches and sandwich changes. i can get the sandwiches and price to appear on the receipt layout with the button but i cant figure out how to get the changes to appear in a list under the sandwich...so please any help anyone could offer would be greatly appreciated -Thank you all in advance

I've looked through previous posts, found one that addresses this question but no good answer. I have some horizontal buttons across the top of my layouts that I would like to "freeze" in position as the user scrolls up and down (multi-page layouts). Don't want switch from Form view to List view. I only want the user viewing a single record at a time... has anyone else found a "work-around" to accomplish this? Thanks!

[color:blue]My main question is: Is it possible to show in the Layout a certain field only if another field has a content? Does someone have experience with this kind of solutions? thank you in advance! miguel [color:blue] My problem in detail: I'm doing a database for i ging queries case 1 If i.e the first line of the hexagram changes, the field "line1_changing" is showing his number (for example 34.1 for hexagram 34 line 1) Otherwise I keep the field "line1_changing" empty. Now I want to show the field "line1_comment" only if the field "line1_changing" has a entry. case 2: the 64 hexagrams and their 6Lines have one table together…

My layout is maximized to full screen, but when I open a new window using a script, the original window is no longer full screen. Is there a way to override this so that the original window stays full screen when another smaller window is opened from it?

Hi Everyone, I've been working with FMP 9 for a few months now but have run into a problem. I am putting together a report (layout: invoice statement in the attached files). I have two test invoices and when viewed in browse mode, I can scroll through the invoice lines and the various attributes change correctly. However, when I view the invoice in preview mode, all invoice lines are shown (not separated by invoice number). I have setup the subsummary report section to start a new page on every new invoice number. Please could you have a look and possibly let me know where I have gone wrong. Many thanks. George PS. I have created this solution wi…

I`m trying to change the distance between fields in one go. Creating a new table filemaker displays all the fields within that table on a new layout with a certain distance between the fields. I would like to change these distances all at once or be able to determine the distance between fields before filemaker creates the layout. Perhaps very easy but have been trying a long time with no succes. To show you what I mean I attached example. Does anybody know how to do this? Thanks Interfieldspace.fp7.zip

Hi, This one is officially eight rows. The one bundled in Filemaker Pro 9 is 7 rows. Does anyone know an equivalent one that does work (in A4) OR have all the magic numbers for a correct version of L7562 (the different page margins are the fiddly part)

if i have in table 1 invoice number and in table 2 invoiceLine how can i billed a invoice repot what will show the oderlines by invoice number?

I am trying to limit entries into a master activity field to only those entries inserted via a script which attaches a date. That part works fine. I then locked the field so the user cannot modify in browse mode. I've just realized that by locking out the user they can no longer use the scroll bar to move through the body of the text. Most of these field contain a large amount of data so scrolling is crucial. Any thoughts on how to have it both ways? Thanks for your help.

Hi, I have built a database for an auction. On the main page of the auction I have button to drive various reports for bidders, donors, etc. On that main page I also want to display the current total of all revenues. I have a table built to capture the revenues of all items and fees entered so far, based on a summary report. I can correctly total all items in the report itself, but when I add the summary field to the main page it doesn't calculate correctly. I've tried GetSummary and can't get that to work correctly either (even though I have set the report to show all records before pulling the value). This seems like it should be fairly simple, but I'…

Hi, In my design process, ive realized that i want to have the same basic buttons and fields across all my layouts. (or many at least) However, i also know that i will want to change names etc as time goes on. Is their a way to create a layout on which all the other layouts (as requested) are built upon. Or, better put, can i include a layout on another. This way, if i want to updated a button or filed, i can just change it on one layout and all to which it is called will update. (i guess it would be like an include function in php, calling a menu from a single file into multiple pages) Anyway, any ideas on the idea would be great.

How do i write a script that if i select in layout 1 a line it will open in layout 2 and create a new record ?

I think I wrote that poorly in the Subject. My goal is to display a field's content formatted differently from how it was actually entered. Specifically, I want to remove all commas and replace them with carriage returns. But this would NOT be a permanent record change by using Find/Replace. It would ideally just be as the field is displayed in a given layout. Right now I've got fields with long strings of words separated by commas. It's hard to read. Carriage returns would make it easier in this case. Is this doable?

so I am very new to Filemaker and am not sure how to make the layout function that way I would like it to. Here's what I have going on. I am making a data base to manage my event planning and make itineraries for my crews. So here is how I would like it to work. I have a table of companies. I have a table for schedule. and a table for each event. I would like to have a pull down list of companies where I can select the company that the schedule of events for that company will be displayed in a list. From there I would like to be able to select an event from the schedule and edit the details of the event in fields below. Ideally I would like all …

Thanks for looking at my question. I'm new to FileMaker, having been in other environments since the mid '80s. We have a need to make a report that shows somewhat complex engineering data. We have the data in a table that is keyed by QuoteID and DataTag and DataTagSequence. The QuoteID would be related to other tables. The DataTag identifies the a particular piece of data (like a field name). The DataTagSequence allows for the nature of the data - unpredicatable number of entries in any particular DataTag. That is the sticky point - without that consideration we could pivot or crossTab the data into a single row by QuoteID. Anyway, I can't figure out a way to report t…

Warning:I am an FM noob. I barely know what I'm doing, but have managed to fight my way through things to get what I've needed. Sorry if this topic is in the wrong area. There's so many! Here's my current roadblock: I have a layout which shows a short version of some fields. Let's call them "Name" and "Short description". I have a button which I want to take the user to the full description of the fields for this record (e.g. Name, Long Description and bunch of other fields). Also, the fields are in a Portal. In my head, this is what I need to do, but I may be going the wrong direction: 1. Open new window when user clicks on button in portal row 2. Go to …

need to billed a layout to insert orders to my suppliers. The problem is that once in the order id will be 1 item or 3 items . the BIG problem that is in the report i need to print the items can not bin a Columnar List i need to print it like this. sample: Item 1: price: arrive date: workers: Item 2: price: arrive date: workers: Can anybody help me. Dani

I am building a database based on the FMP 8 template Task Management. In that template there is a script that creates a Project List using Sub-summary parts . . . which I don't fully understand. It lists the Project, then the Task, then the person or persons assigned to the task (see screenshots). I would like to create a similar report which shows only the records being browsed. Ideally, I'd like to have some Sort control also . . e.g. by Project or Status or Due Date. Is there an easy way for a novice to create this or modify the existing script?

Hi all, I know it's as obvious as the nose on my face but what script item do you use when you want a user to go to a particular layout and then go to the first tab position. Cheers all. Milton.

First, being a newbie, I apologize in advance if this there is a self-evident solution to the following issue...: I have a database containing information about archaeological artifacts, with the following fields (simplified) Site, Artifact_category, Artifact_material, Number (of artifacts). Artifact_category and Artifact_material are drop-down lists from predefined value lists. From this I would like to make a layout where, when sorted by Site, each Artifact_category is summarized by Artifact_material (from which each value should be the header row). It should look something like this: Any suggestions will be highly appreciated! Anja

I've got a database that's used to document flights of my highpower rockets. I have jpgs and quicktime fields in a container field. I friend sent a flight video in wmv format. When I try to insert the file, the icon shows, but it won't play. Is this just not a supported file format for FMP?

I do education using Filemaker for some illustrations. I would like to place circles over certain data fields for highlighting purposes, but the circles would appear over different field in different records. Is there any tool I can use that would hold these circles in place so that a pdf could be produced from the Filemaker data screens with the circles in different places for each record?

Hi all I have a database which keeps track of customers and inventory. I am trying to change it so when a staff member logs in to the database, it automatically takes them to the layout they typically work on. Such as, when "Cindy" logs in she is automatically taken to the inventory layout because she works in that department, but when "Mike" logs in he is automatically taken to the customers layout, and so on. I imagine it is a start up script you would run that is some how tied in with accounts/privileges but I have no idea where to start with a script like this. Any ideas? Thanks

I've gotten pretty confident about data modeling with related tables and using join-tables for many-to-many relationships, but I'm finding myself rther fuzzy at how I can then present the related data in a record print-out. For instance, let's say I have a table for Paintings. The curator needs to keep track of various Actions performed on each painting (Conservation, Loan, Valuation, etc.), so I have created a simple related table to hold these events. Now I can make nice reports at year's end that, say, list all the paintings Loaned in 2008. I would create these reports on the Actions table and pull in whatever Painting info I want from the related records. …

One client accessing is the database remotely (from China), the font and the graphics don't show well (only for this client machine). I have attached 2 pics that show the difference. Any ideas? Thanks in advance!

I have several layouts in which data is entered. I then have a layout with tabs that summarizes all the data. Is there a way to not allow entry into the field (on this data summary screen) but still have the scroll bars in an individual field? I'm pretty sure the answer is no, but wanted to double check with the experts. Thanks.

In the search pages of my database layouts, I have a button button set up to perform the find and take me to the search results on a different layout (in list form). What I'd like to do is, on the results layout, is to show what was searched for. example: Using merge fields, I currently display "found xx of xx records." I'd like it to say something like "searched for _______ , found xx of xx records" (fill in the blank for what the user searched for) I haven't a clue how to go about this other than maybe to somehow store the search criteria in an unstored field and then display that as a merge field on the layout. The 'find' button is already calling up a scri…

Been reading the forums, learning a lot! But have not been able to figure out how to show a filtered view of records in a layout. I have a product table with a sale type field that can have either 'Software' or 'Hardware' for each product. I want to create two layouts, one showing only software and one showing hardware. A script to run a find to filter for only software when the user opens the layout works but when the user performs a find on the layout it undos the filter. Anyway to only show Software records in a layout? Sounds simple, can't wait to learn how to do this.

Hi. I have a checkbox set with three checkboxes, yes, no, and n/a. Is there any way to reduce the spacing between the checkboxes? Thank you for your help.

This might not be the correct section for this post, but since I am now working on my layouts... I have a single table of Companies. Fields include Name, Address, Phone, etc., and a Category field. The Categories are set from a custom value list (Manufactures, Suppliers, Agencies, etc.) In a basic layout I can view all records and page thru them. I would like to set up tabs, based on the Categories, and view the same info, but restricted to the particular Category. Is there a way to do this with a single table?

Hello all, I have been twisting my brain with this one, and hope for some help. What I want to do, is build a view, that will show the layout of a server rack cabinet, and show which slots are taken, and which are available for use. I have a table called "servers", and a table called "racks". The "servers" table has two fields; "Server_ID", and "Server Name". The "racks" table has got three fields; "Rack_ID", "Server_ID" and "Index_number". They are connected by a relation between the "Server_ID"'s On the "Servers" layout, I placed a portal to the Racks table, containing the Rack_ID and Index_number fields. When I add a server, I enter which rack it is…

I have a data entry screen for entering expenses. Is there a way of filling in subsequent fields depending on the first entry? The first entry is into a free text field (although it's supplemented by a drop down menu as many entries are the same.) I want something that looks to see whether an entry has been made before and matches the other fields if it finds it. If it doesn't then it shouldn't fill it. Linked to this, is there a way of running a script upon exiting a field? I know how to run one upon entering the field but can't work out how to do it upon exit. Thanks John

Hi - I do my Filemaker developing on a Mac but am doing a project for a person to use on a PC laptop. I've done some reading about differences in behavior on the two platforms but am finding that while my layout transitions on my Mac are rock-steady, we get a massive "flashing" of the whole screen on the PC. It doesn't seem to me that my layout is so larded with graphics that there shoudl be a problem. I have a gradient rectangle across the top that I copied, 2-px wide, from my graphics program and then "stretched using the object tool in FMP. There's a simple colored rectangle along the left, made in FMP. The buttons I drew in FMP except the List/Form buttons a…

Hi everyone. I have searched around the forum for an answer to this, but been relatively unsuccessful. If anyone knows of a thread or if I am searching for the wrong terms, I would be very grateful if you could direct me to the right place!! Essentially what I am trying to do is as follows: I have a helpdesk log (among many other tables that would link into this) which allows any user to raise an issue and allocate it to a department awaiting resolution. The table has the following fields (simplified) - Account Name (which is essentially the department raising the log) - Allocated To (who is to resolve the log) - Issue (problem stated to be dealt w…

I'm developing a simple project management database. Each Project has a tab for Related Project Files. I've created multiple container fields for the files and would like to associate a time stamp with each file/container field. However, my time stamp fields all reflect the same time even though each field is uniquely named. I'm guessing I can only have one time stamp field per record?? Is there a better way to accomplish my objective?

Is it possible to remove the 3 icons that control a window - "Minimise - Maximise - Close" I have users that close windows by clicking the X icon and not the icon I have provided which does validation and other functions. They are making a total mess of the data and is becoming a nightmare to maintain. I have asked them to use only the icons I have given them but this only lasts a short time. I know in other DB's like 4D you can specify the type of window you want to use, but I can't find any for FM Thanks in advance.

A timestamp field is formatted to auto insert creation (date and time). The field is also formatted to show dates in the format of 14Dec2008 4:26PM. Older records show both date and time. Newer show only the date. Yet when I switch to a table layout the field shows both date and time. Therefore I know the time data is there. What's going on? How can I get the time to show again on the primary layout. Assistance appreciated.

I've created a new layout. If I try to exit the program (File exit, or click the X) FM displays the message "This operation could not be completed because the target is not part of a related table". When I click ok, the program closes. This does not happen on any other layout.

Instead of tabs, I want to use a "phrase" of merged fields, devided by a fixed space (set in a space field). The problem is of course that the words in the "phrase" will change its position, due to variable lengths of the words. My wish is to be able to create buttons over these words, but how to make these buttons (or relative coordinates) to move with the position of the words? I've been thinking of making a row of buttons. Than when activating one of these, the script first calculates which word is under it before executing the script belonging to that word. But this sounds like a horrible amount of variables. Somebody have a suggestion for an easier sol…

Hello all, First, a bit of an intro since this is my first time posting... Typical computer geek. I'm a programmer and network admin by trade. Typical languages are Visual C#, C, PHP, and Perl. I'm very familiar with SQL and in particular MySQL. Most of my database projects are MySQL and PHP based. This FileMaker stuff is very new to me. I was given a project recently. It's a fairly simple database. At least at this point. I wanted to do it in FileMaker this time since I wanted to make it a Windows based application instead of a web interface like I usually do. Right now I have three tables: company_info site_info contact_info Each…

Solution: Simple Highlight Row - layout or portal - uses conditional formatting Description: This is covered in the forums in bits and pieces, but here is a quick and simple description of highlighting a row beyond that little black bar on the right that Filemaker defaults to. This works in any layout or portal row, and has some nice extensibility. SEARCH KEYWORDS: highlight highlite conditional formatting current record layout row portal Working Under: Solution Status: Finished Pre-requisites: Author(s) KirkR Date: 06/25/08 Credits: Numerous other posts with bits and pieces concisely pulled together here. I…

Does anyone know a way to list all fonts used in a Filemaker solution? I need to make sure I have the correct fonts installed for a solution I didn't develop. Thanks

I'm pretty new at this FM gig, so forgive me if this has been discussed elsewhere. Couldn't find the answer in my searches. I have a client DB (senior daycare) and I need a way to do assessments on each client for each day they attend the activity center. The scenario looks like this: 1)Click on client's name in the DB, 2)click on Daily Assess layout, 3) enter Date, Staff Initials, Assessment Codes for 5 or 10 "types" of activities, and possibly 2 or 3 other similar criteria. In my mind I see a calendar-like grid layout with "fields" for each of the above criteria...for EACH client. Essentially, a 31-day calendar (adjustable to weekly or daily view maybe?) wit…

If I create a report layout I can add a button or make a field a button in each entry, so that I can click on that entry in the report and go to a different view of that particular (related) entry. Is there any way to do the same thing in a table layout?

When I first open FP9, and when navigating generally, the contents of my container field will not show without me clicking in it, then in the frame of the record. The attached file explains better. Many thanks FP9_display_problem.pdf

Edit: Changed title. Overall question is - can I get text with standard line spacing into a field that has custom line spacing, with that section of text retaining standard line spacing? Every method I've found of getting text into a field has it adopt the field's line spacing. Or, to put it another way - How can I make a letter template that has different line spacing in different sections, (just as I could with any basic word-processing program), with it all still being in one field? ------------------ Hi folks - I 'm trying to create a form letter that has data auto-inserted, and also formatted with line spacing varying thro…

I've inherited a project created in FM 5.5. The main database has an established relationship with another file that contains a list of surnames, given names, middle initials and addresses. In the main database the user enters the surname and the remainder of the information auto-enters. The problem I've found is in instances where there are persons with the same surname, e.g.Smith, Adam and Smith, Zach. A user wants the information on Zach Smith but upon entering Smith the information auto-entered from the relationship is that of Adam. It's been about 6 years since I last worked with FM. I'm pretty sure that I've encountered this problem before but I can't reme…

Hello, I'm working on a chinese-french dictionary application in FMP Advanced 9. The translation on chinese requires formatting of french text also in italics an bold. Done on MacOS (10.5), everything is fine. When I open the application in Windows (XP), the correct formating is retained only for the basic style of a font, all italics or bold is definitely lost, and moreover there is no way of reapplying styles (e.g. Font-Italic, Font-Bold etc.). Is this a known bug or is there a way to retain the formatting while going cross-platform? Thanks for any help or ideas.

Previously I had an issue getting all of the records from a portal to show up in an invoice layout. That was solved by changing the layout to show records from the portal table. Now I am running into a similar problem, but require all records from multiple portals to show up in an 'invoice-type' layout. Here are the details: Themes: Theme ID Type ID FCP Transitions: FCP ID DJ Transitions: DJ ID Music: Music ID ThemeFCP: Theme ID FCP ID ThemeDJ: Theme ID DJ ID MusicTypes: Type ID Music ID I have ThemeFCP, ThemeDJ, and MusicTypes as portals in Themes and am able to select the fields properly. I create…

I wonder if someone might be able to point me in the right direction. I have a database where the main data is in one table which stores timecard information. It’s linked to several other tables but that probably isn’t too relevant. I designed it to enter and view data at line item level i.e individual days and the interface that I have for that works well showing a week at time at day level. What I really want to do though is have another layout which gives me a week by week summary. I could then click on a button to go the more detailed view. My question is how best to do this. I have messed around with summary parts but haven’t really got them working –…

I made a Invoice program before FM could use multiple tables in the same file. So now my invoice program have 20 different files related to each other. Is there a way to import or easy change this database so it's one file, but with 20 tables? Thanks.

So, I'm wondering if there is any way to create a rounded field with an image in it? It's simple to make one with square edges, but rounded seems to be another issue. Layout mode has not offered a lot of hints. Any ideas?

hello I am working on editing a layout, this time it was resizing a field, the screen freezes, I exit out of the layout and go back , and everything is gone, the fields the buttons, it is all balnk

Hi, hope I am not wasting your time guys. I want to have two link buttons. If Question A is answered YES I want button A to show, otherwise button B to show.....thats the premise. These buttons link to two seperate layouts with relevant data fields In effect, both buttons invisible until selection criterior is met.....Is this possible? Cheers Grandpa

Hi there all, In a payroll table, each record is a shift worked. Earnings = pay rate * hrs worked. I have a sub-total (Gross Wages Due) appearing in a sub-summary part which is a total of Earnings. Next to it I want to use a calculation to show the tax due on Gross Wages. The tax must be calculated on the Gross wages, it cannot be calculated on each record's Earnings then shown as a sub-total itself. Is this possible because putting the Summary field in a calc to work out tax due doesn't work? Hope that made sense?

I want to lock out the status bar but still need/want the section of it that shows the little book, record # and records count. Is there something else graphic wise that I can put in my layout? Thanks

Hi Gang, I am working on a new system where part of the out put will include letters generated from inside the system. I need to have the abililty to have the letter show text in normal, bold, and italics. Can I code into the calculation a set of HTML commands that would allow this to happen? The letter is already working perfectly in all other respects, but the customers wants the output to match their current documents that are created in MS Word. There is nothing real fancy here. Thanks, Steve

hey, i was wondering how can i expand the right margin in layout mode. its the line that keeps everything to right of it cut off when you enter preview mode. i've seen some solutions where they are pretty wide and aren't effected by this margin at all. so i know there's a way to do it.i've looked in every option possible and no luck. thx

Can you tell me where the YES and NO on the button comes from in your condFmt example...I have torn the example apart but I am unable to locate the origin of the YES/NO text when the fields are locked or unlocked. Is it a fm9A feature? Thanks, Jim

can anyone help me with this? i want to use data from a record to be a title on a layout for other data. i hope that makes some sense

Hi all, I want users to be able to send written "communications" (e-mails and letters) to contacts within the database. Such communication frequently includes indented/bulleted/numbered text. I have succeeded with HTML emails (using a plug-in) but I want the user to have the choice of sending as a letter (or indeed a plain text e-mail) My problem is how to deal with indented and/or numbered lists At the moment: The "body text" is entered into a field called "body text" When the user wants a list to appear the enter the text "list1" (they can enter up to 10 lists eg by entering list2 list3 etc) The "lists" are entered into an additio…

Is there a way of hiding buttons in a script? I would like to have a script run that loads a layout and if it finds data, the create new timecard button would be hidden. If it doesn't find data, it is shown? JL

I am probably asking for something that cannot be done, but does anyone how to get a field that is completely void of color? I am attempting to create a drop down list that appears like a number in a box, so that the user knows which order to choose the items in. I know that I can simply put them side by side, but it would work and look better one on top of the other. Thanks.

I have been running some spellchecks on my largest database. Since it is quite specialised I have added many words to the User Dictionary. Today I am trying to add words in the usual way by pressing the 'Learn' button in the spellcheck dialog box and I'm getting a "Cannot add word to User Dictionary" error box. Is it full? Can it be increased? Is there something else I should be doing? Many thanks in advance

I'm trying to simply copy a field's entry to the clipboard. I've tried a bunch of different ways, but none of them work because the field who's contents I want to copy are not displayed on my layout! I've got a calculation field set up which calculates a filename (to be pasted by the user) based on the entries in two name fields and an ID field. This calculated field does not show on my layout. The calculation works fine - the entry it's calculating is correct. I've set up a simple script to copy the contents of this field, but it only works if that field is showing on the layout. If the field isn't showing, what it copies is really odd - it appears that it's copying…

Hey guys just wondering if you could help me out, i am trying to identify relationships between three tables; the relationships can either be 1-1, 1- ∞, or ∞-∞ I have identified the primary keys as well but am not sure they are correct, the only relationships i think exist are between years of experience in the pay info table with years of experience in the staff info table, along with scheduled week in the staff info table with week # in the scheduled table please look at the tables in the attachment and help me out!? thanks! tables.pdf

Greetings, I have a table with a number of fields, some with text calculations that can be appended with user input. If the user cuts and pastes from, oh let's say a webpage with a different font, the new font and it's size are pasted in the field. Is there a way to automatically conform all input to the font set in the field? Thanks for any help.