FileMaker Interface Features
-
Hi all, In my student database I have a checkbox field which identifies students with a disability. I have added a button next to the checkbox which users can click to take them to another layout which provides extensive info. re: the disability. Question: From a design perspective, it looks confusing (and ugly) having both a checkbox and then a button next to it. What options do I have in making this design more user-friendly? Is there an option where the checkbox and button are one and the same?
-
- 4 replies
- 1.2k views
-
-
I have noticed 2 things with a portal that seem to be acting as if there is a bug, however I could be doing something wrong. So I am looking for input. The following is my situation. I have two tables that are related through a field called "ActiveContractID". In the first table (the table being browsed) the field is a calculation as follows: Case ( ActiveContractName = "AFF" ; AFF_ContractID; ActiveContractName = "VF" ; VF_ContractID; ActiveContractName = "SP" ; SP_ContractID; ActiveContractName = "FIAV" ; FIAV_ContractID; ActiveContractName = "alFresco" ; AlFresco_ContractID; ActiveContractName = "Inspired Doc" ; ID_ContractID; ActiveContractName …
-
- 15 replies
- 4.1k views
-
-
I have a dropdown list with a value list from another table. If I type fast I can type several characters for choosing a value. But if i type slowly it jumps up and down for the first character only. Sorry little hard to explain, but can I change anywhere so I can type slower?
-
- 0 replies
- 908 views
-
-
Hey Everyone. Could anyone explain to me how to sort a portal? I have two databases connect via "x" relationship. I want to be able to sort the portal by month and I would also like to make some sort of button or something to only show the top 5 recent records. Does anyone know how to do these things? Thanks for the help!
-
- 1 reply
- 1k views
-
-
Hi All, I've got a set of invoices that i want to sort by the month and year , which i'd then show in a sub-summary report. That report would produce a list something like: 2007_01 2007_03 2007_08 2008_01 2008_02 2008_03 I'm sure there's an easy way to do it, though i've been searching and i couldn't find anything. I have tried Date_to_Sort_By = Year (Job_Date) & "_" & Month (Job_Date) but the result for Jan is 2008_1 rather than 2008_01). This then doesn't sort properly because of Oct, Nov and Dec (ie 2008_10). Many thanks if you can point me in the right direction, Slater ps am i right in thinking that i can't do an…
-
- 4 replies
- 4k views
-
-
Thanks... Now that that working I have one difficult question related to topic but a spin off. I want to be able to select items from the imported list but limit what can be picked from based on what customer name shows up in another field. So If I selected Jim Bob as a customer from an existing drop down (Fields from customer table. In the roll selection field drop down I only want the rolls starting with CF to appear in drop down list that was pulled from the excel file. roll_id qty_avail CF1001 1000ft CB1002 1000ft MF1001 1000ft MB1002 1000ft
-
- 15 replies
- 2.3k views
-
-
Hi, I have a field that I only want to allow data entry into if it is empty. Is this possible? If so, what is the best way? Hal
-
- 2 replies
- 1.3k views
-
-
Jeez -- I've gone 'round and round on this for the past hour. I have a portal displaying item records from a join table with an "Insurance Value" field accessible to the user to set $ values. Just below the portal I have a Summary Field that totals up the Insurance values. (I have it set up as a text Merge Field since its display only) Basically, it works. . . But I'm struggling with the various ways that user behavior can make the Summary Field update itself . . . or not. If the user enters a value in a portal line item and clicks out onto the layout, the Summary field refreshes itself -- but if instead they tab to or enter another field directly, the Summary fi…
-
- 1 reply
- 1.2k views
-
-
I'm just starting to work with Filemaker 10 and I must say that I am fairly impressed so far. I am struggling a bit with the new layout tools. As I recall, I used to be able to see at a glance how many records were in my database and which record number was currently active. Wasn't there also a small scroll bar gizmo that allowed you to scroll through the records? There was also a button that you could click and hold down to dial font sizes up or down. Can anybody tell me how to find these tools again? Thanks, Jarvis
-
- 2 replies
- 982 views
-
-
Hello, I'm a complete beginner at this, my inquiry may be completely dumb.. I have a layout that is meant to printed.. it displays data from certain fields.. ie: Hello <>, is it possible to add an additional field input ?, only if there is data in the second field? ie: Dear <> and <>, yet, if no data is in "field 2", then only field 1 is display... without the word "and" as well. I know this might be very easy, but after searching I don't where to start.. Thanks for any help possible.
-
- 2 replies
- 883 views
-
-
Hi, I am a Biology major with zero programming experience. I've just started using File maker and I'm creating a database for an online store in which, I have provided my customers the opportunity to pay via credit card. In my database, I have two sets of addresses: 1)Billing address 2) Shipping address. I've put in a radio button to check whether both addresses are the same. If the radio button option selected is Yes, I would like the address details entered in the billing section to automatically copy themselves to the shipping address fields. If the radio button option selected is "No" I would like my representative to be able to enter text int…
-
- 2 replies
- 1.1k views
-
-
Is it possible to have a field display text on an arc? I need to display text from a database on a 1/2 circle and would LOVE to be able to do it in FM. I have version 8.5 now but have downloaded the 10 trial but no luck. Hoping a FileMaker master knows a way! Otherwise I'll be exporting and scripting in InDesign to pull off what I hope is a simple function in FM. Thanks!
-
- 2 replies
- 945 views
-
-
I need to change the name of several layouts (ie; from "name" to "name-temp," then after changes to the layouts back to "name"). Is there an easier way than renaming each one individually? Thanks in advance.
-
- 6 replies
- 2k views
-
-
Long time reader, first time poster. Hoping someone can shed some light on a problem I'm having. I want to track the progress of Applications. Within each application can be a number of clients, so I want to create/list the clients in a Portal within the Application Layout. I also want to click on a specific client within the portal to show the Phone, Email, and Address of that client. I have attached the sample file I'm working on for your review. I would like the button marked "View" to populate the fields at the bottom showing the Phone, Email and Address fields. I have found similar posts, but I am a novice and couldn't come up with a solution for my…
-
- 2 replies
- 1.6k views
-
-
Its probably been asked before... If I have a report that is sorted and summarised by 3 fields In this case Customer/Project/Deliverable I would like a page break before each customer and before each project - but not the "first" project for each customer as that creates an empty page? How do i configure the part set up? Many thanks
-
- 4 replies
- 1.8k views
-
-
Hi. I have used Filemaker's web viewer successfully in the past to access a web site and supply the necessary information to the site's form field when the field was text type. When I changed the web site's field type to "password," FileMaker stopped putting the correct data in that field. Is there a way to force this? Thank you
-
- 0 replies
- 1.3k views
-
-
i have a portal where i have set-up a table in which a crosstabulated total for each year is being computed (Stats). i would like to know how to create a numerical change auto-compute field to be placed beside the fields so the user can be notified of the changes as well as the difference. concept sample is on layout "What I want to accomplish". if my description isnt clear enough, pls look at the 'Stats' and 'What I want to accomplish' layouts in the attached fm7 file here . thanks in advance
-
- 2 replies
- 1.2k views
-
-
I'm going overboard on the tool tips, using them for all sorts of things. Problem, when you hover over an object the tool tip shows for just a few seconds and then diapears. Is there any way to make it stay longer?
-
- 4 replies
- 10.8k views
-
-
Is there a way in which to combine reports from different tables into one report without using the PDF features? I have what is basically a kind of contract. Each section of the contract is a single large text field. On my report layout I used a merge field for this text field so it can span several pages in the body part and break properly. I would like the ability to insert some data from another table after one of these sections as per a user selection. What I want to insert is more or less a spreadsheet like chart with data from another table. Is this even possible? Thanks, Greg
-
- 16 replies
- 2.5k views
-
-
I created a portal that is supposed to have different values in them but when ever i try to add another one, it replaces the previous one rather using the second line. I am very new to this program and I would be grateful for any help. ex: i want it to show two records that are unique (pre-set from a different table), but it only shows one, the most recent choice.
-
- 11 replies
- 2k views
-
-
I'm in the process of trying to set up an inventory/order system for our company. I would like user to be able to enter the lot number and quantity of a product into the order main layout and that data draw into a portal for the Lot# and automatically deduct the shipped qty from the stock qty. Currently I have two tables: Order_number and Lot_number. In the Order_number table main layout, users can enter the lot # from which the product is being pulled in up to 3 fields: Lot_ID1, Lot_ID2, Lot_ID3. Users then enter the qty of product in fields: Lot_qty1, Lot_qty2, Lot_qty3 respectively. I have a sum field that sums those three lot qty's for a total of product shipped.…
-
- 0 replies
- 951 views
-
-
I have earlier done some Access programs but are now a happy Mac user. I have done a nice application but have one problem, so I made a new databse just to describe the problem. I have one table called "street" and it carries a street register with the postal number and address. In my other table "delivery" adress I will add streeets from table "street" and if they are there it will add the postal number & adress automatically. You should be able to write a new address if it is not found and change the postal number and address if you want. My example works except that if I choose the street "Andersson Street" and selct the secon Andersson street wi…
-
- 2 replies
- 1k views
-
-
Hi Fellows, It is possible to use differents value lists relationed? For example: Two Fields - Category and Group: Category: First Value List Group: Value List related to the first value list(Category) Example: Category: (Value List of 3 items) Finance Marketing Sales If Category is "Finance" The value list to field Group is accounts If Category is "Marketing" The value list to field Group is Promotions It is possible? Thanks in advanced, Andre Luiz From Brazil
-
- 6 replies
- 1.3k views
-
-
Hi all, is there a way to find out what fonts are used in layouts? I can go through one by one of course, but maybe there is a usage menu or script that I"m not aware of. thanks in advance Hank101
-
- 0 replies
- 1k views
-
-
Arrghhh -- I've spent the last half hour rooting around the forums in search of a thread I read last fall about various methods people use to create child records -- not by just typing into the last portal row (sloppy) or by scripting their way to a child layout (clunky) -- but by simply running a simple "Set Field" script that triggers record creation in the Child table via the realtionship (with record creation 'On'). I posted a question about this on a year-old thread, but not sure such things get seen by anyone: http://fmforums.com/forum/showtopic.php?tid/193433/post/318322/fromactivity/myposts/#318322 Any help? I feel there something important here I'…
-
- 5 replies
- 1.2k views
-
-
Hi All, As I'm on a 10" laptop, every millimetre is precious! I'd like to be able to hide the bottom scroll bar (which includes the Zoom Controls, Status area controls and mode pop-up) in some layouts. Is this possible? Thanks heaps as always! Helen
-
- 3 replies
- 1.8k views
-
-
Hi All- I have a database of films for my company. We're creating digital assets for each film, and I'm tracking those. I'm also tracking the various platforms these assets will go to. To this end, I have a table for films, a table for assets and a table for platforms (among many other tables for other functions). I have a dynamic value list based on the platform name field that generates a list of all platforms. Users use this list on the asset table to specify which platform a particular version of an asset is for (via a portal). However, some films will not be available on some platforms. I have a checkbox in the films table where users can check off which platfor…
-
- 2 replies
- 1.1k views
-
-
Hello. I am having trouble deleting portal rows and would really appreciate some help. I have 2 separate files that connected who relationships are connected with one able to be deleted if the master record is deleted. Whenever I click to delete a child portal record from the parent a pop up box appears that says "permanently delete this one related record". Even with the portal row highlighted, nothing happens. So then when I click out of the portal row to commit the record, the entire master record deletes. I am so confused. Any suggestions???
-
- 1 reply
- 1.1k views
-
-
Hi there, I have 3 tables: Orders, Order Lines, and Items. On the orders layout I have an Order Lines portal. I have a transparent button on top of the portal row and a platform below the portal for adding, editing and deleting records. I can delete portal records from a button on the platform. Yeah! I would like to add new Order Line records by selecting Items from a drop-down on the platform. I think I need to establish a working relationship between Order Lines and Items. I have a relationship, but since there are no Order Line portal records yet, there are no Items showing up in the drop-down! Do I need some kind of utility relationship? How do I do t…
-
- 13 replies
- 2k views
-
-
I have a report that looks like this in preview: Fred Smith -this is the sub-summary part 1/2/09 8 hours - 1 record 2/3/09 8.5 hours - 1 record 3/3/09 8 hours Mary Jones 1/2/09 6 hours 2/3/09 7 hours 3/3/09 8 hours I don't want Fred's or Mary's records to split across a page, but I don't need everyone to start on a new page. At the very least I'd like 'Mary Jones' to repeat at the top of the next page if some of her records don't fit. I suspect this can't be done, but would love to be proved wrong... I hope the question makes sense.
-
- 2 replies
- 1.1k views
-
-
Anyone else seeing this. On vista after going in and out of layout mode multiple times, it appears. Close and re-open it's gone.
-
- 3 replies
- 1.3k views
-
-
Sorry to bother with my neophyte questions... Several years ago, I developed a fairly extensive database on another platform. It handled value lists mainly through a lookup table. One could add multiple fields through queries and set the data source field independent from the list displayed value. This technique became handy for saving abbreviations and displaying descriptive text in forms and reports. The query would form the basis for the drop-list; and the drop-down control would have its source value set to the appropriate column. The simplest explanation relates to a State lookup table. StateID => CA StateName => California The drop down …
-
- 1 reply
- 1.9k views
-
-
I am trying to create a portal on the AI Advisors Note layout, but the data is not show. Can someone help me figure out what I have done wrong. AI_Tracking.zip
-
- 2 replies
- 1.3k views
-
-
Hi All, I want to be able to view a list (that varies from about 15 to 30 items) on the computer. I want large type in columns. Is this only possible in Preview Mode? I have assumed that, so in my script I enter Preview Mode ('Enter Preview Mode [Pause]'), then I have 'Enter Browse Mode []' so I can return to the previous layout, but this doesn't get me back into Browse Mode. Can I get back to Browse Mode without using a FileMaker toggle menu, ie is it possible to have a button on my Preview layout, or do I need to use a different command in my script? Thanks heaps, Helen
-
- 6 replies
- 1.8k views
-
-
I'm creating a database for a company which fixes computers. Whenever a customer comes into the company's shop, a record is added to a "session" table. This record includes a customer ID, computer ID, the time the session started, and the time it finishes (left blank until the session finishes, obviously). I have another table called "session events". This table contains one record for every event that happens during the session: for example, "replaced motherboard", "installed filemaker" etc. "session events" is linked to "session" via a session ID number, which is a serial number generated when a new session is created in "session". I want to create a cond…
-
- 4 replies
- 1.2k views
-
-
I loaded an HTML file in to the web viewer and it displays screenplay formated text properly. When I copy and paste the text into a "Text Field" I am losing all my formating. Is there a way to get the text field to respect the HTML formating or is there another way to do this? I want to be able to use just a part of the HTML text and associate it with different records. Thanks Ben
-
- 1 reply
- 1.2k views
-
-
I'm looking for an efficient way to validate an exit of a portal row. Specifically I want to allow users to enter data into portal row fields in any order they want unencumbered. But if they exit the row completely, then I want to test whether the state and country fields have been left empty. In FMP10 is there a way to do this? Much appreciated.
-
- 2 replies
- 1.1k views
-
-
Hi, Is it possible to create a common button bar for multiple layouts? I created one a few years ago, but if I needed to add or change the behavior of a button, I had to copy/paste the button on each layer that would have the button bar. This way is not very "maintenable". Do you have a better idea?
-
- 5 replies
- 1.2k views
-
-
I've set up a simple subsummary report that displays the sum for two levels of break fields. Some of the top-level categories have subcategories and some don't (subcategory field is empty). So here's what I get now: Category I 10 Subcategory a 6 Subcategory b 4 Category II 12 12 Category III 8 Subcategory a 5 Subcategory c 3 What I want is to get rid of that extra "12", in other words, not show the subsummary part if the break field is blank for that category. I tried using conditional formatting comparing GetSummary calculations to try and make the sum field white if the category and subc…
-
- 3 replies
- 1k views
-
-
I have a DB for my antique radio shop, and I want to give a copy to others. The problem is this: I have two models of tube tester in the shop, and in this DB I have a table for each tester model. On a particular page I have two tabs, one for each tester table. I can easily create several tables for different models of testers, but what I want to do is have a value list (On a setup page of some sort) with check boxes, and have it only show tabs for what models you have selected. In other words, you click what models of testers you have, and those are the only ones that show up.
-
- 0 replies
- 1.5k views
-
-
Is there a way to page up and/or down in preview mode without going to the Status Area?
-
- 2 replies
- 1.1k views
-
-
Hi everyone, I'm having trouble using Value Lists when a relationship between two tables is by UID, but I want the the Value List to be populated by a non UID. I have two main tables: (1) Users - each user has a pk_UserID field (permanent) - each user has a Fullname field (which can be edited later on for spelling etc.) (2) Jobs - each job has a pk_JobID - a job can involve multiple contacts (not sure if this is relevant in presenting my issue) In my Job layout, there is a portal to a different table where it creates a new record joining the Job with a User. (fk_UserID, f_Fullname, and fk_JobID) I I want to be able to select the…
-
- 4 replies
- 1.3k views
-
-
Using Trial Version of Pro 10, hosted up for IWP, with one other person updating via web. While I was working in layouts (via program, not web) something glitched (hosting?) resulting in a freeze up. Had to exit and re-open. Now the layout I was working on is blank, no fields, etc. and I can't delete. I would appreciate any thoughts.
-
- 4 replies
- 1.5k views
-
-
Hello, I am having problems trying to get a relationship to work in my database. I am new to all this and what I am trying to do is a bit above me so any help would be greatly appreciated. Basically I have 3 tables contacts, jobs and clients. On the jobs page I have a portal which shows the client name and the company they work for, this data is taken from the other 2 tables. What I am trying to do, unsuccessfully, is have a button in the portal which when clicked displays client info, such as company name and address, and contact info, such as contact name and telephone number, from there respective tables, on the jobs table. I have put a button in the portal with…
-
- 0 replies
- 1.1k views
-
-
I hope that I am not right about this, but it appears that FileMaker 10 Instant Web Publishing has retained the old 'Status Area' instead of sporting the new 'Status Bar'. Any comments?
-
- 1 reply
- 975 views
-
-
I have looked at a few sample files uploaded in some previous threads, but still am a little confused about what mistake I am making with my file. I have three tables, with the following fields: Customers Job Id Name Material Items Material Category Material Description Material Price Job Id Material Pricing Material Category Material Description Material Price Material Pricing is set-up with each of the categories, items and prices for our list of possible supplies. I have a portal in the Customers layout for Material Items. I have it set-up so that the Material Items & Material Pricing are joined by a Material Des…
-
- 7 replies
- 1.6k views
-
-
Hey guys - I'm new to filemaker and I am wondering if there is a way to lock a picture to the background of my body. Basically I don't want the image to scroll when I scroll the rest of the page. Is this possible? A web example would be something like twitter.com where the background clouds don't move when you scroll. Thanks, Will
-
- 2 replies
- 1.2k views
-
-
i'm not sure if this belongs to portals. I have a simple FM DB to keep track of my patients lab tests. I need to keep track of what each patient pays for his lab tests, for example: NAME-------Date---Amount Due--Payment--Balance John Doe--1/10/09----$100------$70------$30 ------------1/13/09----------------$30------$0 ------------2/1/09------$120------$100-----$20 ------------2/5/09-----------------$20------$0
-
- 3 replies
- 1.4k views
-
-
Hi ! I ran into serious troubles when trying to build a work flow -solution. I have two tables: employees and Work places. I would like to set all these in one page as a matrix, so that there is date in column (vertical) and Work Places as upper row (horizontal). In each row there is a name of employee who has made a reservation for this date and place. Hope you understand what I mean. Is this possible to do at all ? I've lost my nerves with this already... Or is portals the right tool for this at all ? Thanks in advance !
-
- 2 replies
- 2.6k views
-
-
i have a table with a field containing "year" data. my objective is to count the number of each 'year' instance via a count calc field and managed to produce a list/report (IUCN) containing each 'year' listed uniquely with a corresponding count it has appeared in my table. my question now is that how am i going to be able to reproduce this report into a portal so i can add it to a a layout? you can download my sample data here: sample data im just starting to learn fm so pls dont be too harsh on me : thanks i advance
-
- 5 replies
- 1.5k views
-
-
When I generate a sales order, I can print an address label. How do I pick which label on the paper to print to, as opposed to always printing on the upper left corner label? I'm sure it is easy, but I haven't had any luck finding the answer. Thanks.
-
- 2 replies
- 1.5k views
-
-
I want to create a layout that lists individual names in a permanent table view. I know it's simple, but I can only get one name to show up at a time. Assistance please?
-
- 8 replies
- 1.8k views
-
-
I have set up checkboxes and value lists to populate my database in which I have many-to-many relationships with multiple choices for each field. e.g. -- I have a table with PROGRAMS and a table with FORMULAS Each PROGRAM can have multiple FORMULAS S so I set up a checkbox using a value list from FORMULAS... Now I have each PROGRAM with several FORMULAS listed. Now I also have a table with BOTANICALS Each FORMULA can have multiple BOTANICALS so I set up a checkbox using a value list from BOTANICALS... Now I have each FORMULA with several BOTANICALS listed. But then Each BOTANICAL can have several THERAPEUTIC USES, and I need to link e…
-
- 2 replies
- 1.3k views
-
-
Hi Need help I create a layout call Portal test with 3 field in my record call E1, B1 and Qty1 and all this 3 field had the repetition of 5. I also create anther layout call Protal report and using the 2 portal call Binding PB and Binding Saddle to show my B1 product. But I get the same data for both Protal. I attach file for you to take a look Thanks gregory Portal_Test_copy.fp7.zip
-
- 5 replies
- 1.4k views
-
-
I have two databases - Main Customer & Pricelist. There is a portal from one of the Pricelist tables in the Main Customer layout. I want my Production Mgr to be able to create a pricelist in the Main Customer layout, so he doesn't have to leave that screen. But, when he goes to create a portal row it tells him he is not authorized to do this. BUT, when I gave him access to the Pricelist file, to see if he could create a new record in that database, it would allow him to. Why would he not be able to create a new record via the portal, but can directly through the table? I thought the permission settings would be transferable across tables and databases, if they a…
-
- 9 replies
- 1.6k views
-
-
Hey there, I am trying to get a total of ALL the records in the portal, related or not. Maybe using "portal" is not the correct wording because the data is in a table, and portals only show related records. But here is how it is set up.. I have a sponsor table and a ticket table. A sponsor can request tickets, when an employee finds out a sponsor wants tickets they enter in the # of tickets that the sponsor as requested. I want the total of ALL tickets that have been requested across all sponsors. I tried using summary fields and summary parts but summary parts seem to only calculate data on a group of records currently being browsed. And as the user…
-
- 3 replies
- 1.1k views
-
-
Hi All, I'd like to create a database of legal provisions that will be used in various contracts. Some of the provisions are quite long (up to 3-4 pages each) and may contain formatting of sorts(eg, underline, bold, tabs, indentations, etc.). I'd like the text or container field that will contain the provision to preserve such formatting, so that when the user later copies the contents of the field and pastes it into a Word document, the formatting will come with it so that the user doesn't then have to run around the Word doc reformatting the text. Can this be done? Thanks! J
-
- 1 reply
- 1.1k views
-
-
Is there any perceived wisdom/best practice on the following: I want to do bulk mail shots (not email) using a file maker report to multiple contacts - the quantities are not huge, usually less than 400 contacts per mailing) Is it better to build the list and then print one report for all 400 contacts (with all details in the body part) or is it better to build the list and loop through the list printing a single report for each contact sorry if this is really basic but it obviously affects scripts many thanks Simon
-
- 1 reply
- 1.2k views
-
-
I can't figure out why this is happening but I seem to have a bit of an anomaly here. I have an address field set up to display in a Brush Script font yet one field refuses to show up in that font. All the other fields display properly but not the address field. I have tried a number of things: - re-typed the values in the field - duplicated another field and then renamed it to the address field so as to copy it's attributes - re-formatted all the fields as Brush Script. - etc. etc. Any ideas anyone?
-
- 3 replies
- 1.1k views
-
-
I'm hoping this is easy and I'm just missing something simple. Here's my issue - I found a survey db which I've been able to customize for a solution I'm trying to provide. I created a db which allows teachers to vote (yes, no or nt) for students for an award. They can also add comments. The issue I have is totaling the votes for each individual student. I created a totals layout which has a portal that pulls the teacher name, vote, and comments for an individual student. However, I haven't found a way to successfully total the number of yes, no or nt votes for that student. I'd be happy to send a copy of the db if needed. Thanks,
-
- 1 reply
- 1.4k views
-
-
Hello All, I've just tried a very simple button setup on a field...get related record from table A, show record using layout X, check the "Show in new window" and specify a small window size. When I click on the field, a new window pops up as the size I wanted. The problem is that the main window also shrinks its size to the same size as the popup window. This happens to my test database, which is a copy of the real database. I tried the same button setup on the live database, the main window shrinks too. However it shinks only a quater of an inch. I also tried a scrip with New Window, that the effect is the same. I normally have the database window in full size. …
-
- 2 replies
- 1k views
-
-
Hi everyone. First off, just a quick note to say that what I've been able to develop with FileMaker 10 in just the first month of using it has been phenomenal. As a winemaker, I've been able to recreate and improve upon solutions that in my industry cost tens of thousands of dollars. And I've enjoyed almost every minute of the process. My current issue has to do with my implementation of an FM 10 specific drag and drop technique developed by Andrew Persons at Excelisis ( http://www.excelisys.com/web/downloads/index.php). In standard wine production after crush/destemming, grapes are loaded into fermenters of various sizes (usually 1- 6 tons for small wine…
-
- 2 replies
- 1.4k views
-
-
Hey all. Here's the dealio. I have a Prospects Table. Each prospective client record has a marketing campaign assigned to it. Thusly, I have a Campaigns table with a portal showing all prospects assigned to that campaign. Each Prospect has a portal assigned to a table of ContactHistory for that client. So, the relationships are linear so far: ContactHistory -> Prospect -> Campaign. The Prospect Layout is sorting the ContactHistory in descending order by date, latest contact history on top. My problem is getting the latest ContactHistory to be shown on the Campaign page. When I sort the relationship between the Prospect and the Campaign, it sorts one l…
-
- 2 replies
- 923 views
-
-
Hi All, I'm trying to use FM to output invoices of mine, and i'd like to be able to have lines in the invoice excluded if there's nothing in a particular field. For example, the report would show something like: Days worked: xx at rate: yy totals: zz It would show this if x was a value, but if there was nothing in x (ie no work had been done) then the whole line would dissapear. Is this possible? I'm thinking that i have to got to do this with a calculated result, ie LINE1 = if NUMBER DAYS >=1 ; "Days worked: " & NUMBER_DAYS & " at rate: " & RATE etc ; "" This being the case, how would i format the info in the calculation - for e…
-
- 8 replies
- 1.3k views
-
-
Hi everybody, I am fairly new to this and would need urgent help with some sub summary issue. Everything worked fine until some days ago. Created fantastic subsumary reports of consolidated data. Every since about 1 week, when I close the db and reopen it the layout does not recoginze the subsumary parts no more. Meaning, that the Trailing Grand Summary, Header and body are there, but in preview mode the both subsumary parts are simply not there no more. Happened also a couple of times when I switched between layouts.Looks like the layout does not recognize the subsumary part. Anybody here with similar problems or solutions?
-
- 9 replies
- 1.7k views
-
-
Hi I have an issue with sorting a portal by one of its fields. When this portal represented the original instance of the underlying table I was able to sort it by a specific field. However, since changing the portal to reflect a second instance of the underlying table, it is no longer sorting by any field. Any ideas why this or how I can get it to sort again? John
-
- 19 replies
- 2.8k views
-
-
A picture is worth more then a thousand words Direct-link: http://img443.imageshack.us/img443/9283/listdatabasege1.jpg What would be the easiest way to achieve this? Please be very specific, I started using Filemaker yesterday... my filemaker-knowledge is seriously lacking. Any help is appreciated
-
- 1 reply
- 1.3k views
-
-
Not sure if this is where to put this, but I'll start here. A user has transferred my runtime application onto a laptop. When the application is run, field, portal, and button borders do not display. Nor do the 'lines' on text boxes or other objects. I don't think any lines display anywhere on any layout. The color content of container fields also does not display. None of these objects uses conditional formatting (I don't think you can conditionally format borders anyway). Fill colors and text appear to display completely. No other user has experienced such problems in 8 years of application. I have no idea how to diagnose the problem, but I…
-
- 0 replies
- 983 views
-
-
I have created JPEG button images that work fine in the Mac Version of FileMaker 10 Pro (this problem also occurred in FileMaker 9 Pro) but not when I use this file in the Windows version. The Windows version graphic becomes text: "Quicktime and a decompressor are need to see this picture." What is the best way to solve this problem?
-
- 4 replies
- 1.9k views
-
-
I want to create a report that displays the dates that certain Acts are available to be booked. Now here lies my problem. I have (which relate to this) 5 tables acts, members, events, avails, agents So Acts is self explanatory, members are the individual people who make up the acts because some are in more than one Act (1 act can have many members, and each member can be in many acts), Events are the event bookings for Acts for certain dates and avails are when an act has made itself unavailable on certain dates and agents are the people who look after the acts. So I want to run a find by agent and date range to draw up a report to show, grouped by act, wha…
-
- 8 replies
- 1.7k views
-
-
Hi there, can I use the conditional formatting using a variable as part of the field name. The example is:- I have quite a complex set of conditional formats and I want to write a formula which takes account of part of the field name: I have "field 1" to "field 53" I want to have a formula to read something like this:- if(GLOBAL NUMBER>rightwords(getactivefieldname);1);colour blue;colour red) Can that be done? Or something like that? Or a custom function? I am sure it is easy, but I'm blowed if I can find how to do it! Thanks in advance.
-
- 3 replies
- 1.6k views
-
-
Hi folks, I've been playing around with FileMaker for a while, and i've just come across something that I can't figure out - it's probably a simple fix, but I just can't find any reference to it anywhere. The database i'm working on at the moment is a stock management/invoicing jobbie - it all works well, and i'm just adding extra functionality now. Currently, an invoice has on it all the standard details (name, address, etc etc), as well as a portal which is used to add stock from the stock table. This stock is organised by category - Audio, Visual, Computing, Hardware, and so on. Sometimes, it might be necessary to add more stuff to an already-create…
-
- 14 replies
- 8.4k views
-
-
Is there a way to get a count of the number of windows that a certain database has open at any time? Long story short—my users keep on exiting the database by closing windows (using close buttons I've created) and need to log back in, which they get tired of quickly. I tried a script to let them know when they are about to exit the db, and not just a window, and set it to run when the db closes through file options. But when the cancel option is selected to stay in the db, it closes out anyway, I'm guessing because technically the file is closing and nothing can stop it. I'd like to be able get an open window count and test that when they hit my close buttons…
-
- 10 replies
- 13.5k views
-
-
Here's my layout: I have a main Layout/db of prospective clients called Prospects with main table of prospective clients called Prospects in the Relationships graph. I have a tabbed display and on one of those tabs is Contact History. That tab has a portal showing data from a ContactHistory table. This has a few fields including one included for which employee contacted them. What I'm trying to do is find a way under each "Prospective Client" record to be able to filter the contact history table by employee. I've set up buttons to do this. Every time I try to do this, it filters the main prospective clients table, not the encompassed client history table. I don't care if …
-
- 16 replies
- 2.9k views
-
-
I really hope I haven't missed something in my searches, but I have been unable to make this work. I have 2 tables, components and computers. In my components table, I input all the info about each part of the computer. Now I want to create a list for each part of the computer, (motherboard, processor, RAM, etc) that pulls data from the components table, but filters the results to the corresponding field. I am not sure what I need to do to get this function to work. Thanks in advance. Jason
-
- 3 replies
- 1.5k views
-
-
Okay, I'm probably going to get in way over my head here, but I'm trying to design a rather complex report. The report lists health supplements that correspond to a particular regimen. The doctor wants to see the list in a particular format and order. What I'd like to do, for a given item in the final report, is test the db and see if the item (let's use "nettle" as an example) both exists in the db *and* is flagged as "current (Y/N?)". So I'd like the field on the report to do a find for Name=nettle and Current=Y. I'm thinking along these lines: For a given field in the report (i.e., layout), look for db record where Name = [X] and Current? (Y/N) = …
-
- 23 replies
- 3.7k views
-
-
I'm a web designer struggling with learning FM pro 10, and I need to do something in FM Pro that is easy peasy in web design. I want to insert a tiny 'questionmark' button against a field, so that when the cursor rolls over the button, a text window with information pops up. In web design, I would do this with a hidden layer and an 'on mouseover' command to make it visible. Is there an equivalent in Filemaker Pro 10?
-
- 3 replies
- 1.2k views
-
-
Hello All, I need help with a task. I have a database with 30000 records representing members.... I have a field for 'State' and a field for 'Current'. All I want to generate is a report that lists each state and how many current members within each state. So for example the report would be: AL =96 CA=77 and so on ... So far I have used a script to isolate these records and a summary field to list the total within the state but I cannot list more than 1 state at a time.... Do I achieve this through a portal or :? I may be making this harder than it is, but any help you may be able to provide would be greatly appreciated!
-
- 4 replies
- 1.2k views
-
-
We are working on developing a tour guide database for our student workers that will track information about each tour, tour guide, and the tours they gave. The problem or request that I am trying to work through is that when creating an assignment to a tour, they only want the value list to display those tour guides who are currently active for the term. Their activity can and will change throughout the course of the year and the relationship needs to be dynamic while also not losing the tour history feature for each tour guide. I am continuing to research how to adapt a conditional value list to work in my scenario, but any help would be greatly appreciated. I am at…
-
- 2 replies
- 1.3k views
-
-
I'm coming back to FMP after a long absence so please consider me a newbie. What I want to do is create a menu system that is based on a User so that at the top of each layout are MENU and submenu options depending on whether the User has permission to see them. After clicking on a menu, the menu name gets passed as a script parameter to a Navigation script I have that works and takes the user to another layout. Attached in 'A' is an example of what I want it to look like assuming the User had full access--2 horizontally oriented portals set to display 1-1, 2-2, etc... I understand that the menu positions and maximums are going to be fixed (7 Main, 8 Sub) L…
-
- 13 replies
- 2.4k views
-
-
Dear Forum I need some help with a summary field, the situation here is that I have a normal portal with fields in it. This fields are the typical fields to make an order in a POS system, 1. quantity 2. unit price 3. total price quantity field * unit price = total price at the end I have a summary field that gives me a total of the total price for my ticket, everything is ok, but the problems is that if I change the quantity field with a pop up list from 1 to 5 for example the changes are not visible in the summary field at the moment just when I change to another layout. The summary field is outside of the portal. Anyone knows how to make active the…
-
- 3 replies
- 1k views
-
-
I'm really sorry about this... It's probably the most basic question ever asked but I'm really struggling to achieve the following: I have an invoice table and the layout contains a portal in which I create records in my line table. I'd be grateful if someone could tell me what script to use in order automatically to complete the next portal row (so create another line) if a specified field in the current row contains a specified word. To explain; we sell shoes. The portal includes the fields "make" "style" "dye_or_taken" and "price". The "dye_or_taken" field is a drop-down list including "dye". If "dye" is selected in the current line, I want to automatically g…
-
- 10 replies
- 5.9k views
-
-
Hello, I would like to create a drop down list using 2 different fields from 2 different tables. any way of doing this? PS - I did a search, and found a few links, but nothing about using multiple tables... thanks!
-
- 2 replies
- 1.2k views
-
-
I want to disable the feature of browing the records using the scroll button. Can it be done? :)
-
- 5 replies
- 2.2k views
-
-
Hey all, I am working on a field that I want to hold the active years of a contract (ex. 2008, 2009, 2010,.. etc). I created a repeating field and I am looking to show or hide the repetitions based on weather the previous repetition is full. Is this possible? I have read about using a portal technique to show and hide fields but I having a tough time understanding that method and how I could apply it to this situation. Is there some sort of simple function to modify object properties? Thanks
-
- 5 replies
- 1.7k views
-
-
Hey all, I am looking at creating a list style report that shows the company names of contacts within my database. company name is a field in the contacts table. I only want it to list the company name once, not every occurrence of the company name. I have created a summary field with the options count of the field "ID" (there is always a value if the record exists) when sorted by "Company Name". However this returns just a count of the records it seems (1, 2, 3, 4....etc) it doesn't seem to be counting the amount of records per company name like i thought it would Any help is appreciated. Thanks Looks like I have a report with appropriate …
-
- 4 replies
- 1.2k views
-
-
How can I control close window or the database, that it will ask me if to close are not? or in a layout i can not hit the X button ?
-
- 3 replies
- 1.3k views
-
-
I have a table of around 25000 "Parents" and 11000 "Children". I want to display the Parents (or a foundset thereof) in a List view, each with an indicator (implemented by Conditional Formatting) of whether or not that Parent has any Children. I placed on the body of the layout a related field Children::Name, and set Conditional Formatting for the field as follows: Formula: Count(Children::Name) = 0 Format: set fill=red When I display this layout in Browse mode, it renders VERY SLOWLY - row by row - and puts up a Find-in-progress message between each one. Each row takes about 5 seconds to add to the list. When displaying any significant number of paren…
-
- 4 replies
- 1.7k views
-
-
About 2 years ago I started a project in FM 8 to help track inventory and work orders for the IT department. I can say that the solution functions fine and has been for over a year. Now I have better understanding of what makes Filemaker work and I can correct some of those things in my solution that were just lacking before. Another thing I ignored in my original design was a nice looking interface. I have been lucky enough to get slotted with some free time and I want to improve the over look and function but I don't want to spend loads of time creating cool graphics but I still want it to look cool. Does anybody have a simple but cool layout graphics that t…
-
- 1 reply
- 1k views
-
-
I have several fields in my database that I can't type into. Any ideas?
-
- 1 reply
- 1.4k views
-
-
Hi all, If there a way or a Plug-in that would allow me to drag-and-drop a "PDF" document in a container. I created a DB to generate and keep track of my "Service-Tickets" and use a container to store the ticket that the customer signed. I would like to optimize the process by scanning the ticket to the desktop and then just dropping it on the container. I am using FM 8.0 Thanks Rudy
-
- 1 reply
- 1.9k views
-
-
I'm trying FM 8.5., so I'm new. A question I cannot solve yet. Is it possible to play a Quicktime clip from a container field in full screen with basic FM 8.5 or do I need FM 8.5 Advanced? My problem is that I cannot try Advanced to find out! Thanks for your help. Knut
-
- 9 replies
- 2k views
-
-
I have a database listing contact names. I want to create a report that consists of all the cities listed in my database with a summary field displaying the total number of contacts in that city. I do not want to display each individual record in this report, only a list of cities with the corresponding count. I have been able to create a subsummary field with the contact count, but I cannot figure out how to list each city only once in the report. Any help would be appreciated.
-
- 2 replies
- 1k views
-
-
Hi, my data modeling skills are rusty and the solution is not clear to me. I have a table with 6000 records, it's a join table for two other tables and it contains a Product ID field and a Category field. The products are not unique and neither are the categories - they repeat throughout the array. I have managed to show for every Product the multiple categories that the product can be in through a self join in a second table occurrence - yay for me. However, what I'd like to do is build a calculation that writes the values in the self-join portal out to a field that looks like this: product_id = "Category_1" & "/" & "Category_2" & "/" &…
-
- 4 replies
- 1.5k views
-
-
Thanks to the kindest of BCooney, I have been working on a simple Debit & credit db for multiple projects. It basically has 3 tables, one that contains a debit amount, a second for the credits and a projects table. I been trying to create a report that summarizes both the credit & debit info for all the projects but without success. My problem is that I have a summary field for all the credits in one table & another summary field in the debits tables, but I try to use these results via a relationship in either table layouts, I don't get the same figures & the calcs are all wrong. Is this normal? Should create a new table for global results? I have tried ge…
-
- 3 replies
- 1.2k views
-
-
Hi all, Wondered if this was possible. I have a report layout that includes a sub-summary part. Within the subsummary is 1 field called "Sector" the body contains details for the records Each record in the database is assigned 1 of 15 sectors. In the sub-summary part definition I have it set to... Sub-summary when sorted by "Sector" And Page break before each occurrence To run the report the script shows all records, sorts by sector, then goes to the report layout and print. All works perfect. Each page fits 10 records on it. Sometimes a sector has less than 10 records. So this page will just print say 3 records then starts a new…
-
- 7 replies
- 1.5k views
-
-
Hello everyone : I want to know if there's any trick to save the Layout format (text format only without images) of Filemaker to text file. I know that we can save the layout format to PDF file, not text file. Is there any workaround for this so I can see the same format on the text file? Thank you.
-
- 2 replies
- 1.1k views
-
-
Hi, If I have a 3-tiered conditional value list, how do I prevent users from selecting invalid combinations (or how do I prevent them from being displayed in the first place)? Example: in a state-county-city hierarchy, the user selects the state, and the counties field (drop down) only shows counties in that state, then the city field only shows cities in the county selected. I think I have the relationships right, because my drop down lists are showing the appropriate choices. However, if I select a state and county, then change the state, the county selected remains (an invalid combination, like state=New York and county=Orange). Can someone suggest a s…
-
- 4 replies
- 1.3k views
-
-
In previous versions of FileMaker, if I made a textbox that was too large, I would click on the "single space" button and the box would resize to the enclosed text. In 10, that button is gone... so what do I do now? Help?
-
- 1 reply
- 1.1k views
-
-
Hey all, I have two tables, a "sponsor" table and an "events" table. The "sponsor" table holds info specific to the sponsor. Each sponsor can sponsor ONE event. The event that is sponsored is held in a field within the "sponsor" table called "sponsored event", there is also an "event id" field that I want to hold the ID # of the event for a stable relationship between the two tables, as creating a relationship on names isn't totally reliable. The "events" table holds all info specific to the event. This includes a field called "ID" which is a unique number for each event, and a field called "event name" to hold the english name of the event. As well a fiel…
-
- 2 replies
- 1.6k views
-
Recently Browsing 0
- No registered users viewing this page.