FileMaker Interface Features

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 …

• 2 replies
• 980 views

LaRetta

January 30, 200917 yr

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!

• 13 replies
• 1.6k views

mr_vodka

January 30, 200917 yr

Hello I have a portal (child table) on a layout (parent table) that I am trying to filter through the database relationship between the tables. The relationship between the tables is defined in two ways: 1. The parent table's ID is maintained in the child table. 2. A global field defined in the parent table (containing a static value) is associated with a field in the child table. This relationship is defined through a second instance of the child table. The problem is that on the layout, only the first record in the child table is displaying in the portal. Any ideas on why this is not displaying all the associated records? John

• 3 replies
• 1.2k views

hassam36

January 30, 200917 yr

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?

• 1 reply
• 878 views

IdealData

January 30, 200917 yr

i have created a drop-down list with the first field hidden and the second shown. the hidden field is a key. id and label. (using it like an array) the drop-down is for a field of a child table of that sits on the parent layout in a portal. the drop-down value list is not related to the parent or child record. in a script I need to get the second field based on the first field. i looked at getnthrecord, but I need to get by key not record number. anyone have any ideas? thanks

• 3 replies
• 1.8k views

comment

January 30, 200917 yr

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…

• 10 replies
• 2.2k views

KirkR

January 30, 200917 yr

I have tried many times to figure out a good way to adjust the space of the border around a text field. I dislike that there is only 1 pixel space between the border and the text when the text is left Justified. I would also like to add more space to the top and bottom of the text. Any suggestions on how to add more space? Thx

• 0 replies
• 1.8k views

bena

January 29, 200917 yr

I have a database that in the main table it shows the product name and product serial number and also shows a portal with the parts that make the product. This parts come from the parts table. I need a script to add a new part to the product from the portal, but because it is partID related it has to create the next partID number and put it in the portal in the partID field. I am losing my hair trying??? Any help??

• 1 reply
• 1.5k views

mr_vodka

January 29, 200917 yr

Forgive me if this is answered elsewhere but I've searched for a few days and been unable to find it on the forum. I'm a beginner. My wife and I own a shop selling wedding dresses, bridesmaids' dresses, etc. I'm creating a database containing tables for stock items, customer details, invoices, and lines (individual items sold which will then be shown on an invoice). I also have a table called "make_item" with two fields; the designer name and the item that designer makes. Some designers make more than one type of thing. For example, Mori Lee makes both bridal gowns and bridesmaids' dresses. The "line" table has fields for "make" "item" "style" "colour" and other…

• 2 replies
• 1.2k views

michaeldaly

January 28, 200917 yr

I am new to this forum and have not developed anything in FMP for a number of years. I have started an ambitious project. I started an "Issues Tracking" project to build aworking prototype tracking / reporting system and get the users away from using Excel. I started with a FMPro Template. We have an internal IT app that tracks projects. This system can export the data to a xls file. I have created a QA Main db that maps these fields so I can import the xls file. There are 3 situations in the daily export: (1) dates changed in some records (there are 3 different dates for projects status: DatePushedtoQA, DateQAComplete, DateUATComplete), (2) records h…

• 0 replies
• 1.7k views

drock1

January 28, 200917 yr

Is it possible to use a drop down to select a job number and be able to auto populate fields based off that job number that have been entered in another table? What would the formula(s) look like if its possible

• 7 replies
• 1.8k views

comment

January 28, 200917 yr

I have created a zero-plugin Web Viewer interaction example. It illustrates an interesting technique, but also illustrates what appears to be some text encoding problems that are encountered when using the data URL with web viewer. I have submitted this as a bug report but I welcome comments. See example file here: http://www.concise-design.com/downloads/simplewebtrigger.zip The "holy grail" of the FileMaker Web Viewer is interaction between the web viewer and the FileMaker application. There are plugins that can accomplish this. This file demonstrates a technique that provides limited interaction but does not require a plugin. This can be do…

• 5 replies
• 5.1k views

bruceR

January 27, 200917 yr

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?

• 2 replies
• 1.2k views

Pbeyrouty

January 27, 200917 yr

In FMP10 Conditional Formatting doesn't always evaluate consistently. The script involved is just a single step, set a field value. Conditional on that value the field contents change colour. That's it. I've added a Refresh Window step but that doesn't make a difference. I suspect it has something to do with exiting a field because clicking on a neutral place on the layout forces the evaluation when it stalls. In FMP6 there was an Exit Record script step, but not in FMP10. Any ideas? Kind regards,

• 2 replies
• 1.5k views

sandyinlet

January 26, 200917 yr

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…

• 16 replies
• 1.5k views

bcooney

January 26, 200917 yr

Hi - I've been battling with this all day and I just can't figure it out. I have a DB with 3 tables all linked via an account name field. The DB is split into UI and data files (separation model) and in the data file I have joined the tables via the account name field and allow creation of related fields both ways. When I go to tab Transactions in the UI file and add a new transaction in the portal (see record with ID 118) with an account name that does not exist (Card 3) I would have expected it to create a new record not only in the transactions data table but also in the groups and accounts tables. Why is it not working - I can't figure it out. I have at…

• 2 replies
• 1.5k views

michael_w

January 25, 200917 yr

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?

• 2 replies
• 1.1k views

Dani R

January 25, 200917 yr

I have a Parent (Party: includes Contacts & Companies) to Child Portal relationship (Companies only) to Grandchild portal relationship(Shareholders: Contacts & Companies from Parent). I have a button on my grandchild portal that I want to perform a script to return me to the related record in the Parent. Does anyone have a suggestion on how to write such a script? Thanks in advance for any assistance.

• 1 reply
• 1.3k views

Digital Life

January 25, 200917 yr

Hi everyone, I have a table which contains notes for members, the portal shows the related notes to members fine. The notes Table has 6 fields (Noteid, NotedDate, NoteCategory, Notesubject, NoteText & Notememberid) I use a portal to show all the fields except the Note Text field because it will contain a long text, so I put this field on the right of the protal, what I am trying to do is that when I click on a button on the portal row to show the related NoteText field next to the portal, can someone please help me to achieve that? Would appreciate if you can send me little bit detailed script as I'm a really a newbie with FM, I'm using FM10 Advanced Pro. …

• 3 replies
• 1.4k views

seifo

January 25, 200917 yr

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.

• 5 replies
• 1.3k views

alexliz

January 25, 200917 yr

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)?

• 0 replies
• 1.1k views

alexliz

January 25, 200917 yr

I want to make a value list display values based on what another field says. What I have is a field to describe what role a person plays on a Production i.e. "Contractor, Talent, Interview Subject". If the user selects Contractor, I want the next field to list "Producer, Director...", but if they select "Talent", I want that next field to list "Voice, Actor, Musician...". Can this be done? Thanks in advance for your guidance.

• 4 replies
• 10.3k views

wedgeman

January 25, 200917 yr

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

• 1 reply
• 1.3k views

bcooney

January 25, 200917 yr

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…

• 1 reply
• 1.4k views

bcooney

January 24, 200917 yr

Hi, I have a field where the user currently enters a product code into a text box, made up of 4 letters, and then 3 numbers. I need the 3 number part to be automatically generated. How can i do this? I haven't written a script before, but can easily learn as i have a good knowledge of programming functions in other applications. Or maybe it is a simple text control. Thanks in advance.

• 1 reply
• 1.2k views

bcooney

January 24, 200917 yr

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…

• 1 reply
• 1.1k views

RalphL

January 23, 200917 yr

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.

• 1 reply
• 1.1k views

Colin Keefe

January 23, 200917 yr

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

• 1 reply
• 963 views

aldipalo

January 23, 200917 yr

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?

• 4 replies
• 1.2k views

Aussie John

January 23, 200917 yr

I am trying to add a product catalog to my quoting database. I currently have 2 tables for the catalog. Catalog_Select Fields: Supplier - global Catalog_Group - global and Catalog Fields: Supplier Group Item Code Description Price I have a layout with Catalog_Select::Supplier and Catalog_Select::CatalogGroup which have drop down value lists from Catalog::Supplier and Catalog::Group. Selection from these lists filters a portal showing records from Catalog. The problem I am having is that while I always need the entire list of suppliers, I only want groups related to that supplier to show in the Group Selection. The rela…

• 1 reply
• 1.1k views

RalphL

January 23, 200917 yr

I am trying to create a Time Card database for Employees. I view the records through a portal. Problem is when I try to add a new portal record the date field reverts to the end date in the current time sheet. I need to select the date again to make it stick. Also is there an easier way to manage the creation of duplicate records. I have a unique id on the DailyRecords table, but the user does not see the Error Msg. until they click outside the portal. Each Record on the DailyRecords table is unique through a combination of date and employee Id. Account Name: jdoe Password: new Adminstration - Account Name: admin Password: admin NewTimeshe…

• 6 replies
• 1.5k views

Ballycroy

January 22, 200917 yr

Can anyone offer a suggestion for a good approach to highlight URLs within text fields? FMP has provided the right-click "Open: http: //........" for years. However, it's often hard to spot a short URL (like http:// www .m-w.com) in a large text block. I'd like to have any URL highlighted in a different text color or maybe underlined like a link. I've considered occasionally running a script to parse all text fields in my application and insert color settings. Or (in FMP 10) have a script that executes upon exiting each field, to modify them one at a time. Hopefully, someone has considered this before and can offer some insight. Thanks for any help.

• 6 replies
• 6.2k views

comment

January 22, 200917 yr

New to FileMaker, been working with sql-based databases before and can't really get my head around a few things. A basic contact register: You've got a contact layout and a portal with phone numbers, an unlimited number. I've got the relationships setup etc. One of these phone numbers is the primary, so you got a checkbox. But only one of these can be set at a time. So when the user checks one, all the other have to go unchecked, for that particular contact. How do you do that? Much obliged. Martin

• 5 replies
• 1.9k views

Søren Dyhr

January 22, 200917 yr

I understand that FMP10 enables script triggering when clicking an individual tab on a tab panel. In my experiments assigning a script trigger to what I intended to be to a particular tab resulted in that script being applied to all of the tabs. I've been unable to track down documentation on how to do this. Or else I've been misinformed. Assistance appreciated.

• 6 replies
• 3.3k views

Hijack

January 21, 200917 yr

Hi I have a question concerning creating the initial record in a portal accessed through the web: is there a way to do this without adding some kind of 'create record' button on the layout? I'm asking because unlike accessing a portal using the Filemaker client software where there is a way to just type in the open record displayed, nothing shows up for portals without records on the web. John

• 0 replies
• 885 views

hassam36

January 21, 200917 yr

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

• 2 replies
• 1.1k views

Brian C

January 20, 200917 yr

Hope this is an easy one. I have a portal that contains multiple line items. These line items may increase enough so that it will have to go to another page. Without going into the related file of individual items and creating a new report, is there a way to have the portal records extend onto multiple pages when printing. Sorry for the run on sentence. Thanks. Mike

• 2 replies
• 1.4k views

mleiser

January 20, 200917 yr

Hi, this is probably simple, but i can't seem to get it right. I have a script and at the end of the script it calls for "go to portal row (select; last) set field [iten number_products::ItemNumber;$sn] but for some reason it always goes to row #2 under my portal, and if i change it to first, then it always replaces my first. how can i make it so that the info goes to portal row 1 and then 2 and then 3. My portal has 10 rows. Thanks

• 4 replies
• 5.7k views

Søren Dyhr

January 20, 200917 yr

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?

• 5 replies
• 1.7k views

Scott_R

January 20, 200917 yr

Hi - I'm using FMP8 and have some trouble with my DB. I have a layout with multiple tabs - say tabs A, B, C, D. Each tab has a portal. The tab showing is C and it has a button to execute a script. As soon as the script hits the Go to Portal Row step FMP switches to a different tab. I tried creating a field, made it visible only on tab C, and then added a Go to Field step before the Go to Portal Row, but it still changes the tab. Why? And how can I make FMP stay on the same tab? Here's my script: Set Field [ t.AccountsUI::g.CurrentTab; "Transactions" ] Go to Layout [ original layout ] Go to Field [ t.AccountsUI::k.Transactions ] [ Select/perf…

• 11 replies
• 2.1k views

michael_w

January 19, 200917 yr

Value lists have the option of being populated with values from specific fields. Is there a way to allow the value list to consist of values from more than one field? Can these fields be in different tables?

• 17 replies
• 2.2k views

comment

January 19, 200917 yr

I had developed a method with a web viewer parsing xml data (custom function) as a result from url passed to the web viewer. however on the mac it works as the web viewer displays all the data in a big text block, and using the GetObjectAttribute grabs the raw xml... but on windows the webviewer wants to structure it and show it with a bunch of HTML formatting invalidating any scrapping - or showing the raw xml... is there some setting in the windows browser to NOT render xml results page as html? s

• 1 reply
• 1.7k views

fabriceN

January 19, 200917 yr

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…

• 1 reply
• 1.1k views

bcooney

January 17, 200917 yr

I want to recreate a "Pop Up" Value List with people who are marked as donors. Currently, I'm getting all people, regardless if their "donor" field is set to "Yes." How can I get a value list with only people who are also marked as "donors?"

• 4 replies
• 1.7k views

theoph

January 17, 200917 yr

Hi all This what I was wondering if it can be done in a portal or in FM. We are required to track if a welder welded in a qualified welding process every six months. A welder may have four or five qualified welding process at one time. So all of these process have to be used in this six monthe period. So each records for one welder for one process would look like this in the continuity log table Record number one Name: Hank Waldmann WElding process GTAW Last day welded: 1/2/2007 Record number two Name: Hank Waldmann Welding process FCAW Last day welded 1/8/2007 Record number Three Name: Hank Waldmann Welding Preocess SAW Last …

• 24 replies
• 3.1k views

Søren Dyhr

January 17, 200917 yr

Hi all, Is it possible to use a drop down menu using a value list within a Custom Dialog box? Using FM9. Many thanks Ed

• 3 replies
• 1.9k views

bcooney

January 16, 200917 yr

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…

• 3 replies
• 1.3k views

laker_42

January 16, 200917 yr

Is there a quick way to import (move, copy) value lists from one database to another?

• 1 reply
• 1.3k views

Steven H. Blackwell

January 15, 200917 yr

i made a global field that shows a value list ( Pop-up menu ) from another field in the same table, then i need to get number of selected items in this pop-up menu & aslo i need to get the selected items thanks for r time

• 0 replies
• 989 views

abdelrahman

January 15, 200917 yr

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?

• 2 replies
• 3.3k views

LaRetta

January 15, 200917 yr

Hello all, I have a field that I would like to make inaccessible, unless a checkbox has been checked. Is this possible in FMP10? Best regards, Jes

• 1 reply
• 2.3k views

comment

January 15, 200917 yr

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?

• 3 replies
• 1.2k views

bcooney

January 14, 200917 yr

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 …

• 2 replies
• 1k views

SteveS

January 14, 200917 yr

Not sure if or how to do this but here is what I would like to do. I have built an event planning database. I need to add flights to events. I also need to assign passengers from my personnel table to each flight. What I would like to do is add a flight and assign it to an event. after that I want to be able to select what passengers will be on that flight have my value list only show personnel from the event that this flight is assigned to. Hope that makes sense. Thanks for the help.

• 1 reply
• 1.4k views

bcooney

January 14, 200917 yr

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.

• 12 replies
• 2.5k views

Jim Lah

January 14, 200917 yr

Hello, I am trying to understand how to use a checkbox field in a portal to make a selection. Here are the details: Music: - Music ID - Type (checkbox with defined value list) - Song Title Themes - Theme ID - Music Type (drop down with same value list as Music:Type) ThemeMusic - Music ID - Theme ID In Themes I have a portal (ThemeMusic) used to select which songs to use. I can get the portal to do this fine, but I want to limit the list of songs available to those that have been checked the same as the chosen Music Type. I know how to limit the records in the portal field if the original field (Music:Type in this case) can onl…

• 12 replies
• 2.6k views

georgewash

January 14, 200917 yr

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. # ") &"…

• 2 replies
• 1.2k views

paulsyhand

January 14, 200917 yr

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!

• 0 replies
• 995 views

SGT

January 14, 200917 yr

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?

• 2 replies
• 1.2k views

Tom Kennedy

January 14, 200917 yr

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.

• 1 reply
• 1.3k views

Dave Graham

January 14, 200917 yr

Let me start by saying I'm truly a newbie, in all senses of the word. Don't let me fool you with my fancy talk, I KNOW NOT OF WHAT I SPEAK. That being said, here's what I'm trying to do... In my contacts database file, I have a check box field called "shows" which is a value list of 8 different tradeshows that each client or contact attends. Each client may attend 0-8 of these shows, and the list may be adding new shows in the future. Here's where it gets complicated. Each show is done 1-5 times a year, and should also be listed by month - each show has it's own schedule, so there should be a related but separate field titled "month", which would be conditional. …

• 1 reply
• 1.3k views

Dave Graham

January 14, 200917 yr

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…

• 2 replies
• 1.2k views

Johnnycode

January 13, 200917 yr

Anyone know why the "Value is" condition in the conditional formatting drop down would be grayed out? I have one condition already set based on a "Formula" and need another using "Value Is".

• 2 replies
• 2k views

David Jondreau

January 13, 200917 yr

Hello I am looking for some advice about portals, since I am a bit new to all this. Basically I have a company table which holds fields such as company name and address and I have an employees table which holds the employees details. The tables are linked via a company id. I have a one to many relationship set up, as a company can have many employees. On the company table I want to have a portal where you can input the employees name which can be added to with more employees in the future, this list can be scrolled up and down and when you select the employee name it shows you their telephone details in another portal. Does this sound sensible and is it possi…

• 2 replies
• 1.3k views

Oldsneekers

January 13, 200917 yr

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

• 3 replies
• 1.2k views

chlowden

January 12, 200917 yr

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!

• 9 replies
• 1.6k views

alex005

January 12, 200917 yr

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…

• 1 reply
• 876 views

comment

January 12, 200917 yr

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

• 0 replies
• 1.2k views

Rafal

January 12, 200917 yr

I'm trying to put a conditional format on fields in a sub-summary layout part. The condition is a 'formula' condition. The formula tests whether a summary field (count of records being summarized) = 1. FM does not apply the conditional formatting. Is this a limitation of the conditional formatting?

• 4 replies
• 2.1k views

comment

January 11, 200917 yr

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…

• 1 reply
• 1.1k views

LaRetta

January 11, 200917 yr

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

• 1 reply
• 1k views

aldipalo

January 11, 200917 yr

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!

• 2 replies
• 1.4k views

LaRetta

January 10, 200917 yr

How do i verify in a portal that all the filed are full and not empty?

• 0 replies
• 1.3k views

Dani R

January 10, 200917 yr

[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…

• 7 replies
• 1.9k views

Raybaudi

January 10, 200917 yr

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?

• 4 replies
• 4.1k views

LaRetta

January 10, 200917 yr

I've created a custom menu that contains calls to run scripts—my way of providing users with keyboard shortcuts to on-screen buttons. However, strangely the menu contents are always greyed out. I've tried setting the Script privilege to All Executable and All Modifiable. No change. I've left the Command at its default setting of . Couldn't spot an appropriate command for this situation. See attachment. What am I missing? GoTo_Menu.pdf

• 1 reply
• 2.4k views

LaRetta

January 10, 200917 yr

Hi all Been trying to get my portal to filter the welders continuity records and not having any luck. The relationship on which I created the portal is as follows [color:blue]expiration date (greater than or equal to) start date and expiration date (less than or equal to) end date this doees not show any records in the portal. The expiration date is formatted as date. The start date is a calculation formatted as a date the end date is a calculation formatted as date. I tried changing the format of these fileds a dozen times trying to get this to work. I know I got something wrong but I can not figure it out. I included a sample file of what I a…

• 2 replies
• 1.7k views

The Big Bear

January 9, 200917 yr

I manage 500+ records in a related table. I can get the portal to display them; however, you have to scroll down to see them. Is it possible to have the portal run horizontal? Better yet - Is it possible for me to arrange the related records however I like? In multiple lines or in a circle for instance? Would that mean multiple relationships? over 500!? Thanks. Chris

• 1 reply
• 1.4k views

comment

January 9, 200917 yr

Hey, I'm trying to put a line on top of the web viewer. But whatever I try, the web viewer stays on top and the line (or other objects) stay behind the web viewer. Any idea? Furthermore, when displaying text from a field in the web viewer (using "data:text/html," & Table::Field...) I get a "border" at the left side of the web viewer causing that the text starts about 8 pixels from the left border of the field. Is there a way to reduce this? I've tried the settings in Text / Paragraph / Indent Left, but this works only for text fields. Thank you, Mike

• 2 replies
• 1.6k views

polarpro

January 8, 200917 yr

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…

• 5 replies
• 1.6k views

LaRetta

January 8, 200917 yr

I know I've seen this many times, but, can not find the posts addressing this. How do you make the new record entry as the first line of the portal? TIA

• 1 reply
• 1.2k views

aldipalo

January 8, 200917 yr

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

• 4 replies
• 1.8k views

Lee Smith

January 7, 200917 yr

I have a report which gets printed as a pdf. It contains several categories - the category name field is in the leading subsummary part, the break field is the category name. Very often, the body of any particular category continues on the next page of the report. I have put the category name field (along with "cont'd.") in the header as well with the condition that it not print on the first page. So far, all is good. When the category at the end of the first page continues onto the second page, the top of the second page shows the name of that category cont'd. However, sometimes, the categories do NOT break across pages. How can I formulate a condition so that the header…

• 2 replies
• 1.6k views

martie

January 7, 200917 yr

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)

• 1 reply
• 1.3k views

IdealData

January 7, 200917 yr

Hi I'm new to Filemaker. Can someone tell me how to organize independent tab sequencing for each tab panel? Each panel contains a portal to a different table and the user chooses which tab they want to work with. There is no relationship between the tables at time of data entry, so it makes no sense for the tab sequence to continue from one panel to the next. I tried to reset it for the second panel, but no luck. Thanks, jl1

• 2 replies
• 2.6k views

jl1

January 7, 200917 yr

Hi, I have figured out what needed to be changed in order for the following to work, but I don't understand why. I'm hoping someone can explain it to me. I have two tables: Insurance and Client. I need to be able to see all Insurance companies available in all the Client records. I also have to be able to add new insurance companies to the list while I'm in a client record because the one that is needed might not be in there. So the relationship that was set up was Insurance::onelink (where onelink was a *stored* calculation equal to 1) to Client::linkis1 (where linkis1 is a global auto-entered validated number equal to 1). Adding of record through relation…

• 1 reply
• 1.3k views

Razumovsky

January 6, 200917 yr

I am working on an application for garments and I want to use a drop down list in the user interface for garment sizes. My problem is mostly aesthetic in that I cannot figure out a way to sort the sizes into the logical order they come in. I need to use related records because the sizes vary depending on the garment, so using custom values doesn't work, though in my example I use one to show what I am hoping to accomplish. Any ideas ? Size_Example.fp7.zip

• 10 replies
• 2.1k views

comment

January 6, 200917 yr

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?

• 16 replies
• 1.9k views

RalphL

January 6, 200917 yr

I apologize for posting this question in the wrong area (if I indeed have). I'm new to this site and am in desperate need for help. I've been using FileMaker for about 4 months now. My "Thanks" in advance to anyone with the time to help me out. I'm going to try to state this as quickly as possible: I have a "Customer" table and an "Invoices" table. I want to show a filtered Invoices portal within the Customer Table. I'm using a global field "zInvStatus" in the Customers layout as a check box set that relates directly to the calculation field "cInvoiceStatus" in the Invoices table. This allows me to show either "Receivable", "Partially Paid", and "Paid" Invoices …

• 2 replies
• 1.1k views

GeckoPSU

January 5, 200917 yr

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.

• 2 replies
• 1.1k views

Ultradistance2005

January 5, 200917 yr

Hi everyone, Is it possible to change the size of a field box without using the mouse? I have a field box that I want to make a little bit larger, but when I click and drag using the mouse, the next size it will allow is too large. Is there any other way to change the size of the box to make exact changes? Thanks!

• 3 replies
• 1.1k views

SGT

January 5, 200917 yr

Hello everyone! I'm stumped on this one. I've got this layout with a portal. (I've attached a copy to the post.) For some reason, even though I do not have "sliding left" turned on, the fields within the portal are sliding when I print. It shows up this way in print preview as well. I've tried turning sliding off and on for both the portal and the individual fields but neither has helped. The fields don't appear to be collapsing, but just "jumping" over a little bit for printing. Any ideas? Haines-Improved_Clone.zip

• 5 replies
• 1.7k views

brandie

January 5, 200917 yr

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'…

• 3 replies
• 1.1k views

Søren Dyhr

January 5, 200917 yr

Hi, I think this has been covered in the topic http://fmforums.com/forum/showtopic.php?tid/199890/ but as a beginner im not 100% sure it applies to what im doing/ i dont fully understand the structure. I have a customer record and that customer has several Hydrants. Each hydrant is inspected anually. On the hydrant detail layout (which displays all that hydrants specifics) i want to display a portal of all previous inspections related soley to that hydrant. (then i will be able to review previous years inspections as needed) I have a portal that works but of course it displays all inspections from all hydrants, not just the one which im looking at. S…

• 2 replies
• 1.2k views

titanium

January 5, 200917 yr

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.

• 3 replies
• 1.5k views

bcooney

January 4, 200917 yr

I have a repeated field with text content. Each entry may be multiple lines, having a 'paragraph'or enter/return character in the text string. I would like to use the repeated fields in a value list, but when I do, the values offered in the drop down list are not the field values, but each of the individual lines from the field values. E.g., Repeated field 1: Line1 Line2 Repeated field 2: Line3 Line4 if I define a Value List for the repeated field, it shows 4 choices in the drop down list: Line1 Line2 Line3 Line4 when what I want are 2 values: Line1/Line2 Li…

• 4 replies
• 1.7k views

comment

January 4, 200917 yr

Hi, i think this should be fairly simple, but cant seem to figure it out... I have a portal which displays some data from a related table... the problem im having is that i am able to edit the data in the portal but i dont want to be able to. I only want to click on the row and goto the related record to edit there (this is working fine). I do not have the Allow creation boxes checked in my relationship, nor do i have the Allow deletion box checked in my portal setup.. Not sure what im missing. Thanks in advance for any direction you can offer.

• 3 replies
• 2.7k views

titanium

January 4, 200917 yr

Is it possible to have multiple value lists for the same filed based on another fields data? For instance if Field A = Yes than I want the drop-down in Field B to be ValueList#1. If Field A = No than I want drop-down ValueList#2.

• 5 replies
• 2k views

comment

January 4, 200917 yr

Dear Community I have a POS solution and I have a portal So every time that I want to select a data from this portal I click in a row of the portal and the hit a button , the thing is that I need to make the row a button of itself to make it fast but I need to be activated when I hit the row with a double click in order to make the action of the button. Help Please, I don´t know if this is clear enough. Thanks everybody BluiSh

• 2 replies
• 1.3k views

BluiSh

January 3, 200917 yr

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 ?

• 1 reply
• 1.2k views

aldipalo

January 3, 200917 yr