FileMaker Interface Features
-
Hi Guys, just new to this forum, was hoping anyone could help me. When I try to load in some URLs from a variable into my webviewer, the page also opens in Safari... How can I make this stop?! Thanks!
-
- 0 replies
- 1.2k views
-
-
Hi everyone, I'm working with a database that keeps track of companies and contracts that we have with them. Each record is for a separate company, and within each record I have a list of contracts. I'm trying to create a columnar report that lists each company *and* all of the contracts for each company (plus a few other fields, contact data for each contract). Essentially I want to have something like this: CompanyA ////Contract1////Phone# ////Contract2////Phone# ////Contract3////Phone# CompanyB ////Contract1////Phone# CompanyC ////Contract1////Phone# ////Contract2////Phone# (where //// represents a tab) Within each record, …
-
- 16 replies
- 2.4k views
-
-
I had created a file with two layout inside. This two layout are One Delivery Order and One Job Process Record. All this two layout is relationship with a field can Job No. And at the Job Process Record Layout I create a field call Invoice and with drop down list of COMPLETED, NOT COMPLETED and TO Bill. I also had another field call Billing and been set like below: Case ( Job No = Delivery Order::Job No: and Invoice = "Not Complete"; "To Bill" ; Job No = Delivery Order::Job No: and Invoice = "Completed"; "Completed" ; Job No = Delivery Order PEARSON::Job No and Invoice = "Completed"; "Completed" ; Job No = Delivery Order PEARSON::Job No ; "To Bill" ; Job N…
-
- 13 replies
- 1.9k views
-
-
I think I wrote that poorly in the Subject. My goal is to display a field's content formatted differently from how it was actually entered. Specifically, I want to remove all commas and replace them with carriage returns. But this would NOT be a permanent record change by using Find/Replace. It would ideally just be as the field is displayed in a given layout. Right now I've got fields with long strings of words separated by commas. It's hard to read. Carriage returns would make it easier in this case. Is this doable?
-
- 1 reply
- 1.1k views
-
-
so I am very new to Filemaker and am not sure how to make the layout function that way I would like it to. Here's what I have going on. I am making a data base to manage my event planning and make itineraries for my crews. So here is how I would like it to work. I have a table of companies. I have a table for schedule. and a table for each event. I would like to have a pull down list of companies where I can select the company that the schedule of events for that company will be displayed in a list. From there I would like to be able to select an event from the schedule and edit the details of the event in fields below. Ideally I would like all …
-
- 4 replies
- 1.4k views
-
-
Thanks for looking at my question. I'm new to FileMaker, having been in other environments since the mid '80s. We have a need to make a report that shows somewhat complex engineering data. We have the data in a table that is keyed by QuoteID and DataTag and DataTagSequence. The QuoteID would be related to other tables. The DataTag identifies the a particular piece of data (like a field name). The DataTagSequence allows for the nature of the data - unpredicatable number of entries in any particular DataTag. That is the sticky point - without that consideration we could pivot or crossTab the data into a single row by QuoteID. Anyway, I can't figure out a way to report t…
-
- 6 replies
- 2k views
-
-
I need to scale a video down to an appropriate size to fit in the smaller webviewer on my layout. It's a "preview" size, say 250px x 200px. The video remains in it's original 640x480 size when playing in the webviewer, so it's cropped in significantly. I've searched but can't find any info on how to scale the video down to the webviewer's size. It's not imperative that I use the web viewer, but I think it's the only way to preview a video file on the layout. Help?
-
- 3 replies
- 1.5k views
-
-
Warning:I am an FM noob. I barely know what I'm doing, but have managed to fight my way through things to get what I've needed. Sorry if this topic is in the wrong area. There's so many! Here's my current roadblock: I have a layout which shows a short version of some fields. Let's call them "Name" and "Short description". I have a button which I want to take the user to the full description of the fields for this record (e.g. Name, Long Description and bunch of other fields). Also, the fields are in a Portal. In my head, this is what I need to do, but I may be going the wrong direction: 1. Open new window when user clicks on button in portal row 2. Go to …
-
- 2 replies
- 1.3k views
-
-
Greetings - I am working on an job quote system. The tables are Clients - fields - the usual stuff Quotes - fields - totals, address of job, etc QuoteDetails - fields - Quantity Manufacturer Part# Cost etc Items - Database of the items in the QuoteDetails - Manu. Part# etc. So far things are working well. I have a layout with my quote and a portal for QuoteDetail. QuoteDetail includes fields for Manufacturer, Part# and Description with are data contained in the Items table. What I'd like to do is this: I create a new line in the portal and enter a Manufacturer so when I go to the Part# field a popup or pulldown appears with only the Part#'s as…
-
- 2 replies
- 1.7k views
-
-
need to billed a layout to insert orders to my suppliers. The problem is that once in the order id will be 1 item or 3 items . the BIG problem that is in the report i need to print the items can not bin a Columnar List i need to print it like this. sample: Item 1: price: arrive date: workers: Item 2: price: arrive date: workers: Can anybody help me. Dani
-
- 1 reply
- 1.1k views
-
-
I am building a database based on the FMP 8 template Task Management. In that template there is a script that creates a Project List using Sub-summary parts . . . which I don't fully understand. It lists the Project, then the Task, then the person or persons assigned to the task (see screenshots). I would like to create a similar report which shows only the records being browsed. Ideally, I'd like to have some Sort control also . . e.g. by Project or Status or Due Date. Is there an easy way for a novice to create this or modify the existing script?
-
- 6 replies
- 2.1k views
-
-
Hi all, I know it's as obvious as the nose on my face but what script item do you use when you want a user to go to a particular layout and then go to the first tab position. Cheers all. Milton.
-
- 3 replies
- 1.6k views
-
-
Greetings, I have another table that contains the data for the Attribs Colour, this table has the field Attrib_ID, Value, Product_ID, Sort_ID. You click on the script it opens a new window, you then select the colour that the lingerie comes in and then close the box, however i want it on the first screen "Products" layout to show a list of the colours; for example: Please Select, Black, Blue, Pink instead of where atm it shows this Please Select Black Blue Pink I don't know which option to use so that it will show the list like that, anyone have any ideas? Thanks
-
- 1 reply
- 1.3k views
-
-
First, being a newbie, I apologize in advance if this there is a self-evident solution to the following issue...: I have a database containing information about archaeological artifacts, with the following fields (simplified) Site, Artifact_category, Artifact_material, Number (of artifacts). Artifact_category and Artifact_material are drop-down lists from predefined value lists. From this I would like to make a layout where, when sorted by Site, each Artifact_category is summarized by Artifact_material (from which each value should be the header row). It should look something like this: Any suggestions will be highly appreciated! Anja
-
- 3 replies
- 1.1k views
-
-
I have spent some time trying to find this… hoping someone could help. Is there a way to get a list of all current Account Names for a database. I want to then use this to populate a value list. I have done this before for layout names, table names etc. but can not seem to figure out Account Names??
-
- 2 replies
- 1.7k views
-
-
I've got a database that's used to document flights of my highpower rockets. I have jpgs and quicktime fields in a container field. I friend sent a flight video in wmv format. When I try to insert the file, the icon shows, but it won't play. Is this just not a supported file format for FMP?
-
- 1 reply
- 1.3k views
-
-
Hi all, First post here. I have an invoice table that works fine, buy what I want is a complete list of all invoices that have been created, with InvoiceID, InvoiceDate, InvoiceName, InvoiceTotal, InvoicePaid and InvoiceBalance as the headings. The list could potential be hundreds of invoices so would need to be able to scroll thru or maybe select by start and end date. I don't know whether I should use a portal or the way to accomplish this. Any help would be appreciated.
-
- 1 reply
- 1.3k views
-
-
I do education using Filemaker for some illustrations. I would like to place circles over certain data fields for highlighting purposes, but the circles would appear over different field in different records. Is there any tool I can use that would hold these circles in place so that a pdf could be produced from the Filemaker data screens with the circles in different places for each record?
-
- 2 replies
- 1.4k views
-
-
Hi all I have a database which keeps track of customers and inventory. I am trying to change it so when a staff member logs in to the database, it automatically takes them to the layout they typically work on. Such as, when "Cindy" logs in she is automatically taken to the inventory layout because she works in that department, but when "Mike" logs in he is automatically taken to the customers layout, and so on. I imagine it is a start up script you would run that is some how tied in with accounts/privileges but I have no idea where to start with a script like this. Any ideas? Thanks
-
- 3 replies
- 1.5k views
-
-
I've gotten pretty confident about data modeling with related tables and using join-tables for many-to-many relationships, but I'm finding myself rther fuzzy at how I can then present the related data in a record print-out. For instance, let's say I have a table for Paintings. The curator needs to keep track of various Actions performed on each painting (Conservation, Loan, Valuation, etc.), so I have created a simple related table to hold these events. Now I can make nice reports at year's end that, say, list all the paintings Loaned in 2008. I would create these reports on the Actions table and pull in whatever Painting info I want from the related records. …
-
- 3 replies
- 1.3k views
-
-
One client accessing is the database remotely (from China), the font and the graphics don't show well (only for this client machine). I have attached 2 pics that show the difference. Any ideas? Thanks in advance!
-
- 1 reply
- 1.4k views
-
-
Hi All, I have lists of ingredients in my recipes, and when these are special ingredients, ie relying on my seasonal garden or that need to be bought from the shop, I want their text to change colour as a warning when contemplating what to cook. My Ingredients table has both "Ingredients" and "Ingredients Source", but I have no room in the portal to show the Ingredients Source, so want to change the colour of the "Ingredient" text itself. I've tried using the formula in the conditional formatting dialogue box by saying that IngredientsT::IngredientSource = "Seasonal Garden" but this doesn't work. Is what I want possible? Thanks heaps!
-
- 8 replies
- 2.1k views
-
-
Is there an elegant way to count the number of different values for a field in a found set? I can think of using a calculation field that has the field value if in the found set, empty if not. Then defining a value list for that calc field and counting the items with a values function. But that seems rather cumbersome. TIA
-
- 4 replies
- 1.7k views
-
-
Can anyone provide some insight into how to create a robust reporting module? I'm imagining a solution that is able to pull from multiple tables by importing into a reporting table and then being able to sort and summarize. Any tips and tricks? Thanks
-
- 4 replies
- 2.3k views
-
-
I have several layouts in which data is entered. I then have a layout with tabs that summarizes all the data. Is there a way to not allow entry into the field (on this data summary screen) but still have the scroll bars in an individual field? I'm pretty sure the answer is no, but wanted to double check with the experts. Thanks.
-
- 8 replies
- 2k views
-
-
Hello all, Sorry to bother you all once again with my neophyte questions, but I have another... In my database, most of my tables are related... There are a couple, however, that I have left unrelated, since they need to be related to multiple tables (and FM tells me it cant do that and needs to add another copy of the table or some such)... Basically, here's all I want to do... The tables are, for instance, lookup_states and lookup_countries... These tables look like this: lookup_states ------------- id (auto generated, serial number) state_name (text) state_abbreviation (text) lookup_countries ---------------- id (auto gener…
-
- 2 replies
- 2.4k views
-
-
In the search pages of my database layouts, I have a button button set up to perform the find and take me to the search results on a different layout (in list form). What I'd like to do is, on the results layout, is to show what was searched for. example: Using merge fields, I currently display "found xx of xx records." I'd like it to say something like "searched for _______ , found xx of xx records" (fill in the blank for what the user searched for) I haven't a clue how to go about this other than maybe to somehow store the search criteria in an unstored field and then display that as a merge field on the layout. The 'find' button is already calling up a scri…
-
- 3 replies
- 1.5k views
-
-
Been reading the forums, learning a lot! But have not been able to figure out how to show a filtered view of records in a layout. I have a product table with a sale type field that can have either 'Software' or 'Hardware' for each product. I want to create two layouts, one showing only software and one showing hardware. A script to run a find to filter for only software when the user opens the layout works but when the user performs a find on the layout it undos the filter. Anyway to only show Software records in a layout? Sounds simple, can't wait to learn how to do this.
-
- 4 replies
- 1.2k views
-
-
Hello, I often seemed to run up against this kind of problem and I haven't found a satisfactory strategy for dealing with it. I think this is a pretty clear example, which I've created to hopefully simplify things. Let's say I'm trying to keep track of baseball statistics. I have two tables: player table: playerID_pk, name, Bats_LeftRightOrSwitch yearly_stats table: playerID_fk, year, batting average percentage (note: we do this out of 1000 (=100%)... we just do, that's why.) Bats_LeftRightOrSwitch field values can be: left (bats left-handed), right (bats right-handed, or switch (switch hitter- bats either way). Obviously, it's a one to…
-
- 4 replies
- 1.4k views
-
-
I have a portal that has multiple records and each one has a unique ID. Sometimes it is necessary to have 2 of the same records in the portal, in the image for instance 2 delivery records are sometimes needed, yet in the total field (which is from the layout called invoices, the portal is from NonSerial Inventory) which has a calculation of Sum (tbl_NonSerial_Inventory::NonSerial Price) Yet, it will not sum the price if there is more than 1 of the same item. I'm not sure why, unless it won't add it because it is the same record? Any help would be appreciated. Thanks - Jeff
-
- 3 replies
- 1.6k views
-
-
Hi. I have a checkbox set with three checkboxes, yes, no, and n/a. Is there any way to reduce the spacing between the checkboxes? Thank you for your help.
-
- 1 reply
- 1.8k views
-
-
hey guys, I'm not sure how to do what i want to do, here is the basic idea of what i want to do: I want to create an inventory list and be able to build packages to rent out from this list. I have a whole inventory layout where you can fill in the date purchased, make, model, price, and so on. I also have a place to show which package it is in and where within that package it is located So say I have Products 1 - 10 and Packages A, B, and C. Package A has compartment 1 and 2. - Product 1 is in Package A compartment 1. - Product 2, 3, and 4 are in Package A compartment 2. - Product 5 and 6 are in Package B - Product 7, 8, 9, and 10 are in Package C. H…
-
- 1 reply
- 1.2k views
-
-
Hello all, I've searched all over the web for a solution, and I think I must be using the wrong search terms, so apologies if it is a simple solution. I'm in oceanography and setting up a database to hold information about all our samples. My real database is quite complicated, but I think I've boiled it down to a super simplified seteup that illustrates my problem. Hypothetical setup: I have three tables. Lets say they are: 1)Expedition 2)Stations (aka location) 3)Samples Expedition might hold info like the dates of the expedition, staff, name of the ship, start and end locations, etc. Each Expedition might have many Stations. Stations mig…
-
- 6 replies
- 1.7k views
-
-
This might not be the correct section for this post, but since I am now working on my layouts... I have a single table of Companies. Fields include Name, Address, Phone, etc., and a Category field. The Categories are set from a custom value list (Manufactures, Suppliers, Agencies, etc.) In a basic layout I can view all records and page thru them. I would like to set up tabs, based on the Categories, and view the same info, but restricted to the particular Category. Is there a way to do this with a single table?
-
- 22 replies
- 2.4k views
-
-
I have been stumped on this for a while and can't find an example of what I am trying to accomplish. I have a calendar system and it keeps track of locations, time, and Date. I am just dealing with a people table and a shifts table. I want a portal on my layout dealing with people to show shifts grouped in location and totaling the time for that location like this Location 1 | 5:00 Location 2 | 3:00 Location 3 | 6:00 Location 4 | 9:00 but as close as i can get is... Location 1 | 5:00 Location 1 | 5:00 Location 1 | 5:00 Location 2 | 3:00 Location 3 | 6:00 Location 3 | 6:00 Location 4 | 9:00 Location 4 | 9:00 Location …
-
- 9 replies
- 1.5k views
-
-
Hello all, I have been twisting my brain with this one, and hope for some help. What I want to do, is build a view, that will show the layout of a server rack cabinet, and show which slots are taken, and which are available for use. I have a table called "servers", and a table called "racks". The "servers" table has two fields; "Server_ID", and "Server Name". The "racks" table has got three fields; "Rack_ID", "Server_ID" and "Index_number". They are connected by a relation between the "Server_ID"'s On the "Servers" layout, I placed a portal to the Racks table, containing the Rack_ID and Index_number fields. When I add a server, I enter which rack it is…
-
- 9 replies
- 2.2k views
-
-
I run a tradeshow company and have written a couple of separate databases to track our business. Currently I have a main database that tracks all of our events and the exhibitors who will be attending those events. I have a separate freight database that we use in the warehouse to track their inbound shipments to us. To expedite the data entry for the freight database, I use a filtered value list setup so that they can pick the name of the show and then have access to a second drop down that shows the list of exhibitors filtered by the show name. Currently I export the customer list from our upcoming shows and manually add it to the freight database and then delete …
-
- 7 replies
- 1.7k views
-
-
I have a data entry screen for entering expenses. Is there a way of filling in subsequent fields depending on the first entry? The first entry is into a free text field (although it's supplemented by a drop down menu as many entries are the same.) I want something that looks to see whether an entry has been made before and matches the other fields if it finds it. If it doesn't then it shouldn't fill it. Linked to this, is there a way of running a script upon exiting a field? I know how to run one upon entering the field but can't work out how to do it upon exit. Thanks John
-
- 2 replies
- 1k views
-
-
I have two tables: - email addresses - notes. I have set up a layout with notes as a portal, and using a status on the email address I'd like to be able to add a note to the portal that is address is invalid and it's being removed from the record. Every way I try to script this I can't get a note record written in the portal if the portal does not already have a note in it. I have checked to see if you allow creation of record is checked off (though on the relationship table these two tables are not directly related) Any thoughts about what step I am most likely missing? I've tried both go to portal row first and next, and then replace the f…
-
- 6 replies
- 1.8k views
-
-
Hi - I do my Filemaker developing on a Mac but am doing a project for a person to use on a PC laptop. I've done some reading about differences in behavior on the two platforms but am finding that while my layout transitions on my Mac are rock-steady, we get a massive "flashing" of the whole screen on the PC. It doesn't seem to me that my layout is so larded with graphics that there shoudl be a problem. I have a gradient rectangle across the top that I copied, 2-px wide, from my graphics program and then "stretched using the object tool in FMP. There's a simple colored rectangle along the left, made in FMP. The buttons I drew in FMP except the List/Form buttons a…
-
- 3 replies
- 1.3k views
-
-
Can you have a pull-down menu in a repeating field?
-
- 3 replies
- 1.1k views
-
-
Hello guys, I'm trying to implement a navigation bar based on the user's privilege set. I have a table called navigation where I have 3 fields: button_name, privilege_set current_privilege_set (a calculation field equal to the user's privilege set). I have created an other instance of the same table called current_navigation and I have set up the relationship between the two tables (navigation.current_privilege_set = current_navigation.privilege_set). Now I would like to place in each of my layouts a portal to display the available navigation options. I have tested it using a dummy layout and it works but here come my issue: is it possible to show within a po…
-
- 13 replies
- 2.6k views
-
-
I have a sales prospects table with name, phone, addr, etc. I created a portal that shows related fields from a contact history file but just date and short desc. I am displaying multiple rows. This portal works just fine. But I want to be able to scroll through this list and display additional fields from that same record else where on the screen, right next to it to be precise. So as I scroll through a list of dates and short descriptions I'll see the fields containing the additional details I want on another part of the screen. It's the second bit I don't know how to do. Thanks
-
- 7 replies
- 1.5k views
-
-
Hi I'm currently trying to get the hang of FM. I am stuck on lookup lists. I have googled myself silly trying to resolve this as I am sure I am missing something very simple I want to use a drop down list to present a list of values from a 'lookup table' and have the selected value put into the main table. ie Main table is a list of properties in a property portfolio, it has the following fields... PropertyID PropertyAddress PurchasePrice etc.. [color:red]fk_CurrentStatus The Lookup table has the fields.. StatusID StatusTypeName StatusTypeName contains for example... 'Under Offer' 'Awaiting Mortgage Offer' 'Owned' etc. On a layout …
-
- 4 replies
- 1.4k views
-
-
Hi everyone. I have searched around the forum for an answer to this, but been relatively unsuccessful. If anyone knows of a thread or if I am searching for the wrong terms, I would be very grateful if you could direct me to the right place!! Essentially what I am trying to do is as follows: I have a helpdesk log (among many other tables that would link into this) which allows any user to raise an issue and allocate it to a department awaiting resolution. The table has the following fields (simplified) - Account Name (which is essentially the department raising the log) - Allocated To (who is to resolve the log) - Issue (problem stated to be dealt w…
-
- 1 reply
- 1.1k views
-
-
Hi, This should be a very simple question, but I just can't figure it out. I setup a portal with "Alternate background fill" check. It looks nice when I look at it. If I need to add records into the portal, some rows' alternate color just disappeared. The whole portal looks inconsistent, some with all white and some part has alternate color. Is there any way to make the portal nice during record entry? Thank you very much for your help.
-
- 2 replies
- 1.8k views
-
-
I need to auto check a 2008 Holiday Card check box based on a found set. I also don't want to update any in the found set which may already have this box checked. I've tried to use a loop with set field where the calculated value equals the current field & "2008 Holiday Cards" however this isn't working and I'm worried it may add the value to records that are already checked. Any ideas? Thanks
-
- 7 replies
- 1.4k views
-
-
I'm developing a simple project management database. Each Project has a tab for Related Project Files. I've created multiple container fields for the files and would like to associate a time stamp with each file/container field. However, my time stamp fields all reflect the same time even though each field is uniquely named. I'm guessing I can only have one time stamp field per record?? Is there a better way to accomplish my objective?
-
- 3 replies
- 1.3k views
-
-
Is it possible to remove the 3 icons that control a window - "Minimise - Maximise - Close" I have users that close windows by clicking the X icon and not the icon I have provided which does validation and other functions. They are making a total mess of the data and is becoming a nightmare to maintain. I have asked them to use only the icons I have given them but this only lasts a short time. I know in other DB's like 4D you can specify the type of window you want to use, but I can't find any for FM Thanks in advance.
-
- 1 reply
- 999 views
-
-
I have a portal to show records from child to a parent layout. I put a script to delete the row of the portal-child record but FM deletes the parent not the original record in the row of the portal. Why is this happen? Pascal
-
- 10 replies
- 7.9k views
-
-
A timestamp field is formatted to auto insert creation (date and time). The field is also formatted to show dates in the format of 14Dec2008 4:26PM. Older records show both date and time. Newer show only the date. Yet when I switch to a table layout the field shows both date and time. Therefore I know the time data is there. What's going on? How can I get the time to show again on the primary layout. Assistance appreciated.
-
- 2 replies
- 1k views
-
-
I've created a new layout. If I try to exit the program (File exit, or click the X) FM displays the message "This operation could not be completed because the target is not part of a related table". When I click ok, the program closes. This does not happen on any other layout.
-
- 1 reply
- 1k views
-
-
Hi there, I wonder if somebody can help me with a portal problem. As background here is the structure of the database In my database the fields common to all records are stored in a single big “base” table, with relationships to other tables based on “type” of data, that hold the other pieces of information. (Each type requires some specific fields, that’s why.) So, each entry consists of a “base record” that is related to one “type record”. For example, there is a table for the type “Topics”, and a table for the type “Resources”. Relationships between entries are being established via a join table using the base records’ keys. As each entry belon…
-
- 8 replies
- 2.2k views
-
-
Instead of tabs, I want to use a "phrase" of merged fields, devided by a fixed space (set in a space field). The problem is of course that the words in the "phrase" will change its position, due to variable lengths of the words. My wish is to be able to create buttons over these words, but how to make these buttons (or relative coordinates) to move with the position of the words? I've been thinking of making a row of buttons. Than when activating one of these, the script first calculates which word is under it before executing the script belonging to that word. But this sounds like a horrible amount of variables. Somebody have a suggestion for an easier sol…
-
- 9 replies
- 1.8k views
-
-
Hello, I've got a self-joining table in which each record can have a parent record and multiple child records within the same table, like so: (people) client vendor employee (artist) (performer) studio_artist actor (dancer) musician ballet jazz hip_hop modern belly (values in parentheses are parent records to the subset below) I'd like to be able to create value lists using this hierarchy, i.e. a performer list which gave me a choice between actor, dancer, and musician, and which in turn let me choose one of the types of dancer. Because of the directions in which my company is expanding, I need for end users to be able to create these value lis…
-
- 1 reply
- 1.3k views
-
-
Hello all, First, a bit of an intro since this is my first time posting... Typical computer geek. I'm a programmer and network admin by trade. Typical languages are Visual C#, C, PHP, and Perl. I'm very familiar with SQL and in particular MySQL. Most of my database projects are MySQL and PHP based. This FileMaker stuff is very new to me. I was given a project recently. It's a fairly simple database. At least at this point. I wanted to do it in FileMaker this time since I wanted to make it a Windows based application instead of a web interface like I usually do. Right now I have three tables: company_info site_info contact_info Each…
-
- 12 replies
- 1.4k views
-
-
Solution: Simple Highlight Row - layout or portal - uses conditional formatting Description: This is covered in the forums in bits and pieces, but here is a quick and simple description of highlighting a row beyond that little black bar on the right that Filemaker defaults to. This works in any layout or portal row, and has some nice extensibility. SEARCH KEYWORDS: highlight highlite conditional formatting current record layout row portal Working Under: Solution Status: Finished Pre-requisites: Author(s) KirkR Date: 06/25/08 Credits: Numerous other posts with bits and pieces concisely pulled together here. I…
-
- 1 reply
- 10.7k views
-
-
Hi, Apologies if this is in the wrong place, but what is the best way to get a pie chart to show data within FM itself? I have a database with some data which i would like to show graphically (without having to leave FM to go to a browser for example). Is this possible with the standard FM ... my research makes me say no. I have found quite a few plug ins by third parties that seem to do that - is this the only way to go / which is the best plug in / and would i have to upgrade to FM9? Many thanks, Slater
-
- 12 replies
- 2.7k views
-
-
Searched around and was not able to find anything on this that seemed to help. Client has a bunch of paper forms and wants them in FM. Short of creating a whole new set of databases (some of the forms have 70+ data elements), I'm thinking it would be easier to simply get the paper into PDF on the server then use a container field to point to them. Clicking on the container field will open the PDF. Is this possible? How?
-
- 1 reply
- 1.7k views
-
-
Does anyone know a way to list all fonts used in a Filemaker solution? I need to make sure I have the correct fonts installed for a solution I didn't develop. Thanks
-
- 2 replies
- 1.3k views
-
-
Task / Call Log Report List. I've created drop-down value lists for filtering purposes. So far so good. For now it will show records by the choice made which is great. Wondering if extending the found set through the drop-down field choice is possible. ( maybe with a modifyer key? ) Is there a way to allow a second choice (thrid or foruth etc.)either in the same drop-down value list or another to the displayed records. Also, is it possible for a value list to find empty records? Regads, Mike.
-
- 5 replies
- 1.7k views
-
-
I'm pretty new at this FM gig, so forgive me if this has been discussed elsewhere. Couldn't find the answer in my searches. I have a client DB (senior daycare) and I need a way to do assessments on each client for each day they attend the activity center. The scenario looks like this: 1)Click on client's name in the DB, 2)click on Daily Assess layout, 3) enter Date, Staff Initials, Assessment Codes for 5 or 10 "types" of activities, and possibly 2 or 3 other similar criteria. In my mind I see a calendar-like grid layout with "fields" for each of the above criteria...for EACH client. Essentially, a 31-day calendar (adjustable to weekly or daily view maybe?) wit…
-
- 1 reply
- 1k views
-
-
How do I add in the column names in the portal field? Basically I would like to see what the fields are at the top, and right now I can't get them to display? Thanks!!
-
- 2 replies
- 1.1k views
-
-
Hello, I am trying to do something wich is kinda complicated to me since I am a recently FM user. What I've to is something like this: _____________________________________________ Field 0 | Field 1 | Field 2 | Field 3 | September | 20€ | description | checkbox | November | 30€ | " | checkbox | _____________________________________________| --- Total = ? How can I sum the values on Field 1 so it would give me the result on Total field. The values on field 1 are already there , they are always the same, but they only Sum when I click on the checkbox. Can anyone help me! Thanks and sorry for my bad english. …
-
- 16 replies
- 2.2k views
-
-
If I create a report layout I can add a button or make a field a button in each entry, so that I can click on that entry in the report and go to a different view of that particular (related) entry. Is there any way to do the same thing in a table layout?
-
- 1 reply
- 987 views
-
-
FMP 9.01 - I've been using a value list which showed a set of customer names from the name field in another file. I wanted to filter the list, so I changed the list to look via a relationship from a global field to a text field in the second file. This works, although the list takes much longet to appear. We run this in a mixed network of PCs and Macs on a peer to peer system, with a dedicated 'server' Mac running FMP9. The real problem is that typeahead on this filtered list no longer works on the PCs, although it works fine on the Mac - albeit much slower. Any suggestions of why this is happening - is this a Filemaker bug? TIA Brian
-
- 1 reply
- 943 views
-
-
When I first open FP9, and when navigating generally, the contents of my container field will not show without me clicking in it, then in the frame of the record. The attached file explains better. Many thanks FP9_display_problem.pdf
-
- 3 replies
- 1.4k views
-
-
FM newbie but long time fan. I have a Clients table and layout that has a "Contacts" tab. I would like the portal on that tab to show all of the records from my Contacts table that work for that client. I believe I understand how the relationships work, but for some reason I cannot get the portal to pull up the right list. It just pulls up every record in the Contacts table. I searched the forum for this, but did not find a similar topic. I apologize if this question has already been answered elsewhere. Thank you all in advance! My friend and I have been really appreciative of the help here on this forum and our FileMaker 9 Bible in our quest to get th…
-
- 2 replies
- 1.1k views
-
-
Greetings, Maybe someone can help - I have 2 tables 1. Quotes which has a unique field QuoteID and a global field gQuoteLocation and 2. Quote_Detail which has QuoteID, QuoteDetailID and QuoteLocation. I've set up a layout with a portal so I can see the one to many relationship between Quotes and Quote_Detail. When I have the relationship set only for Quotes::QuoteID = Quote_Detail::QuoteID everything is fine. And then I have to go and get fancy. I added a relationship so that Quotes::gQuoteLocation = Quote_Detail::QuoteLocation. Everything works as expected, that is, I can filter by location, as long as there's something in the Quotes::gQuoteLocation …
-
- 4 replies
- 1.3k views
-
-
Edit: Changed title. Overall question is - can I get text with standard line spacing into a field that has custom line spacing, with that section of text retaining standard line spacing? Every method I've found of getting text into a field has it adopt the field's line spacing. Or, to put it another way - How can I make a letter template that has different line spacing in different sections, (just as I could with any basic word-processing program), with it all still being in one field? ------------------ Hi folks - I 'm trying to create a form letter that has data auto-inserted, and also formatted with line spacing varying thro…
-
- 11 replies
- 1.5k views
-
-
Hello, I'm trying to figure out a way to prevent a single record appearing more than once in a portal. I don't know how to work with the data in the portal fields since they aren't treated as part of the table I'm trying to affect. In the attached file, I've got two tables, contact and company, with portals connecting them. I've set up a button to create a new record in the other layout (i.e. create a new contact from companies) or to go to an existing record. My problem is preventing the same record from showing up multiple times in either portal. I apologize if I'm not explaining very well, I'm a filemaker newb and I welcome all suggestions and feedback. Thanks for…
-
- 1 reply
- 1.1k views
-
-
I've inherited a project created in FM 5.5. The main database has an established relationship with another file that contains a list of surnames, given names, middle initials and addresses. In the main database the user enters the surname and the remainder of the information auto-enters. The problem I've found is in instances where there are persons with the same surname, e.g.Smith, Adam and Smith, Zach. A user wants the information on Zach Smith but upon entering Smith the information auto-entered from the relationship is that of Adam. It's been about 6 years since I last worked with FM. I'm pretty sure that I've encountered this problem before but I can't reme…
-
- 18 replies
- 2.1k views
-
-
I use an FMP 7 database to control circulation for a trade magazine. For each subscriber record, I keep track of whether they're a buyer or seller. I do this with a "Subscriber Type" field, with a radio button value list displaying the values "Buyer" and "Seller". I want to set up a layout that will automatically tally the numbers of each value for a monthly circulation report. I've tried some of the Summary functions, but they'll only give me a summary for one value at a time. How do I set up a summary that will give me the individual totals for each value in the list? Thanks, Brian
-
- 4 replies
- 966 views
-
-
Hello, I'm working on a chinese-french dictionary application in FMP Advanced 9. The translation on chinese requires formatting of french text also in italics an bold. Done on MacOS (10.5), everything is fine. When I open the application in Windows (XP), the correct formating is retained only for the basic style of a font, all italics or bold is definitely lost, and moreover there is no way of reapplying styles (e.g. Font-Italic, Font-Bold etc.). Is this a known bug or is there a way to retain the formatting while going cross-platform? Thanks for any help or ideas.
-
- 6 replies
- 1.6k views
-
-
Previously I had an issue getting all of the records from a portal to show up in an invoice layout. That was solved by changing the layout to show records from the portal table. Now I am running into a similar problem, but require all records from multiple portals to show up in an 'invoice-type' layout. Here are the details: Themes: Theme ID Type ID FCP Transitions: FCP ID DJ Transitions: DJ ID Music: Music ID ThemeFCP: Theme ID FCP ID ThemeDJ: Theme ID DJ ID MusicTypes: Type ID Music ID I have ThemeFCP, ThemeDJ, and MusicTypes as portals in Themes and am able to select the fields properly. I create…
-
- 21 replies
- 3.4k views
-
-
Hello. I am trying to create a project management database for my company. I had planned to set up tables as follows [color:yellow]................company[color:yellow]...................phone number [color:yellow]............./[color:yellow]................[color:yellow]............../ Project[color:yellow].......................contact - email address [color:yellow].............[color:yellow]................/[color:yellow].............. [color:yellow]...............personnel[color:yellow]..................mailing address I created the contacts, phone numbers, mailing address, and email address tables, and created a relationship between contact and …
-
- 2 replies
- 1.3k views
-
-
Is there an easy way to conditionally format a field if the value is a non-integer?
-
- 3 replies
- 1.9k views
-
-
I would like to be able to provide an interface for users to be able to select multiple items from a value list and have it create a new record per item selected. Check boxes or radio buttons would look the best. I know this could be done with a multi-value field, but I would prefer to have one item per record. The image is what I am trying to achieve. Is this the impossible? Any advice would be greatly appreciated.
-
- 11 replies
- 2.2k views
-
-
I wonder if someone might be able to point me in the right direction. I have a database where the main data is in one table which stores timecard information. It’s linked to several other tables but that probably isn’t too relevant. I designed it to enter and view data at line item level i.e individual days and the interface that I have for that works well showing a week at time at day level. What I really want to do though is have another layout which gives me a week by week summary. I could then click on a button to go the more detailed view. My question is how best to do this. I have messed around with summary parts but haven’t really got them working –…
-
- 7 replies
- 2.1k views
-
-
-
In Filemaker 9 is there a way to Conditional format check box row color or at least text color? I want to "check" a few check boxes and have only those rows be highlighted (Red). I want to also "check" other particular check boxes and have only those rows be highlighted in a different color (Green).
-
- 2 replies
- 3.5k views
-
-
I am learning Filemaker 9. I have created a layout with multiple tabs that open each layout in the open database. Can a tab or other control (button) be created to open another filemaker 9 database? I have created 5 separate databases and it would be convenient to be able to "jump" back and forth from one to another directly from any open layout.
-
- 7 replies
- 3.3k views
-
-
I made a Invoice program before FM could use multiple tables in the same file. So now my invoice program have 20 different files related to each other. Is there a way to import or easy change this database so it's one file, but with 20 tables? Thanks.
-
- 10 replies
- 2k views
-
-
So, I'm wondering if there is any way to create a rounded field with an image in it? It's simple to make one with square edges, but rounded seems to be another issue. Layout mode has not offered a lot of hints. Any ideas?
-
- 4 replies
- 1.7k views
-
-
Hey everyone, I'm looking for suggestions on the best way to setup a portal with radio buttons. For example Topic A 0 0 0 0 0 Topic B 0 0 0 0 0 Topic C 0 0 0 0 0 Topic D 0 0 0 0 0 Where the 0's are radio buttons. Does this make sense. I can email a picture of what it's supposed to look like.
-
- 1 reply
- 1.1k views
-
-
hello I am working on editing a layout, this time it was resizing a field, the screen freezes, I exit out of the layout and go back , and everything is gone, the fields the buttons, it is all balnk
-
- 4 replies
- 1.2k views
-
-
I've created a new relational database using FM6. I've got portals to access the individual databases and they are working well. I have two issues when I access the database through the builtin web server. 1. When I go to the main database, I want the newest record to display in the form view. I can't figure out where to change this. 2. I have lookups for values in one of the fields for one of the related databases. Everything works great in the FM client but when using the web interface the lookup doesn't work. Is there a way to make it work? Thanks for your help. Brad
-
- 1 reply
- 1.1k views
-
-
Hi, hope I am not wasting your time guys. I want to have two link buttons. If Question A is answered YES I want button A to show, otherwise button B to show.....thats the premise. These buttons link to two seperate layouts with relevant data fields In effect, both buttons invisible until selection criterior is met.....Is this possible? Cheers Grandpa
-
- 1 reply
- 1.1k views
-
-
Is there a way to trigger a script in FMP 8 by exiting a field? I have a drop down list displaying values from a field, from which I make a selection which gets pasted into a Display field. Problem is I need to Set Field [Display field; '" "] first to get rid of any old info in it. If I put the script button in the value display field, then the drop down doesn't work. Any ideas?
-
- 4 replies
- 1.4k views
-
-
Hi Everyone, Is there a method that I can apply to a layout that features a portal based on "Events". The Events table was populated to display time values in 15 minute increments. I'm wanting the portal to only display the records that have data in the title field of the Events table. The current relationship is Days:Date = Events:Date. Thanks, R
-
- 4 replies
- 1.7k views
-
-
Hi there all, In a payroll table, each record is a shift worked. Earnings = pay rate * hrs worked. I have a sub-total (Gross Wages Due) appearing in a sub-summary part which is a total of Earnings. Next to it I want to use a calculation to show the tax due on Gross Wages. The tax must be calculated on the Gross wages, it cannot be calculated on each record's Earnings then shown as a sub-total itself. Is this possible because putting the Summary field in a calc to work out tax due doesn't work? Hope that made sense?
-
- 2 replies
- 1.6k views
-
-
Is there a way to have a field "Invoice Number" to be blank when starting, and then have the user input the starting number, after which all subsequent records would increment by 1 and still allow the user to over-ride the data if needed?
-
- 17 replies
- 3.1k views
-
-
[color:orange]Short Version: Is there anyway to resort a table by a specific field so that the record numbers are renumbered? For example: Record Number::::Field [color:green]1:::::01/01/2008 [color:green]2:::::07/01/2008 [color:green]3:::::03/01/2008 [color:green]4:::::12/01/2008 Becomes after you sort: Record Number:::::Field [color:green]1:::::01/01/2008 [color:red]2 ([color:green]old number 3):::::03/01/2008 [color:red]3 ([color:green]old number 2):::::07/01/2008 [color:green]4:::::12/01/2008 [color:orange]Long Version: I have a timesheet database and have a problem with displaying subtotals. The Main table, Clients, has clie…
-
- 2 replies
- 1.3k views
-
-
I want to lock out the status bar but still need/want the section of it that shows the little book, record # and records count. Is there something else graphic wise that I can put in my layout? Thanks
-
- 3 replies
- 1.1k views
-
-
Hi Gang, I am working on a new system where part of the out put will include letters generated from inside the system. I need to have the abililty to have the letter show text in normal, bold, and italics. Can I code into the calculation a set of HTML commands that would allow this to happen? The letter is already working perfectly in all other respects, but the customers wants the output to match their current documents that are created in MS Word. There is nothing real fancy here. Thanks, Steve
-
- 0 replies
- 1.1k views
-
-
hey, i was wondering how can i expand the right margin in layout mode. its the line that keeps everything to right of it cut off when you enter preview mode. i've seen some solutions where they are pretty wide and aren't effected by this margin at all. so i know there's a way to do it.i've looked in every option possible and no luck. thx
-
- 5 replies
- 1.4k views
-
-
I don't know is this correct place for this. (sorry if its wrong section) My question is that. I would like to have so called ghost text in few fields. this ghost text would explain what other users should write in those fields. Idea was that I have ghost text there that is maybe gray colored and when you click that field or start writing in it or click it that ghost text would dissappear. At the moment I have just written that text in that field and selected option that when you click that field it selects all text inside of it. When user starts writing something that text disappears, but this has created few problems so I would not use this if there …
-
- 2 replies
- 1.6k views
-
-
Umm... I have database for projects that I have done and will do. I did create drop-down menu for project styles. That list works fine yes I can choose what I want from drop-down menu, but I can also write what I want in there. Idea is that there is drop-down menu that contains several values example music, movie, etc. But you cannot write anything own into it. that is idea, but for some reason I cannot prevent user to write his own values in there and add that information into my database. Can someone help me to fix this up. Thank you... (I know there is lot of text that doesn't matter in this case, but I just feel like writing it there…
-
- 2 replies
- 1.2k views
-
-
Hi, this is what I have: a table (NAMES) with a relationship that is connected by a unique number with the X option (showing all records in the portal). [color:brown]My "problem" Nr. 1: after a FIND the related database still shows all records, what´s the trick to synchronise these 2 tables? I want both tables to show the same data, i. e. if I'm showing only names in "Frankfurt", the relation should behave the same. [color:brown]My "problem" Nr. 2: I have a script (got to record next) to move within the table and want to move within the portal. When all records are shown, a "Go to Portal Row[select, recordnr]" works ok. This of course does not work if a FIND…
-
- 11 replies
- 2k views
-
-
Can you tell me where the YES and NO on the button comes from in your condFmt example...I have torn the example apart but I am unable to locate the origin of the YES/NO text when the fields are locked or unlocked. Is it a fm9A feature? Thanks, Jim
-
- 9 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.