FileMaker Interface Features
-
Hi guys/gals, I hope you're all doing well. I have a question that doesn't really matter but would be nice. If you have a button in a portal row to Set Field [whatever] to a value that will then switch the portal row relationship to another, you have to click out of the portal and almost off screen before it refreshes both portal windows. Is there something I can add to my script which will refresh the window without having to do this? I tried adding in REFRESH WINDOW but that seems to be for something different. Also, one more thing - in FM7 you can have multi windows. They are independant from each other - if i scroll through records in one window…
-
- 3 replies
- 844 views
-
-
I develop my solutions in both mac and windows and sell them as separate versions. I do all my graphic work on the mac side (photoshop) then develop the solutions on the windows side. The reason for this is mostly an issue of text variables being easier to adjust in the mac version after creating the solution in windows. The most annoying problem I experience is the color selection options available on the windows side is so limited compared to the mac options (ie no: color picker, web safe selection etc.). Am I missing something obvious in the windows filemaker environment? FileMaker Version: Dev 6
-
- 16 replies
- 2.6k views
-
-
I have a simple layout with only a merge field preceeding a regular field. The merge fields' contents are only one line, but the regular fields' content varies from a paragraph to half a page. My problem is that I would like only a single newline between the first entree's field and the next entree's merge field, but instead I am getting inconsistent vertical spacing (possibly due to sliding?). How exactly do I make it so that there is only one new line after each field and before each merge field? Thanks!
-
- 1 reply
- 1.1k views
-
-
Howdy! Q: I want to flag the user when checkbox options in Field B match the options selected in Field A. I don't know how! Details: I have a value list of checkboxes. This list is EDITABLE by the user. Let's say: Option A Option B Option C Option D (keep in mind, the names and number of items in the list can change!) There are two fields: Field A Field B Field A is used to select Options from the value list. This is generally set once. Field B is used to re-select the same options at a later time. Generally at indeterminate times (not all at once) and not in any order and definitely not in te same order as those made in Field …
-
- 3 replies
- 864 views
-
-
Collections of flags in Pict form for Filemaker community. db is password protected. If you accept
-
- 2 replies
- 1.2k views
-
-
This may be a newbie questions, but... Is there a way in fm7 to set font size of fields based on data in another field? What about setting the actual font of a field based on the data in another field? What about the vertical location of a field based on the data in another (calculated field)? What about the vertical location of a Form Layout Part based on the data in another (calculated) field? Why do some fonts and font sizes not show up when formatting a field in design mode? FileMaker Version: Server 7 Platform: Windows 2000
-
- 3 replies
- 1.4k views
-
-
I have images in a container field that I am displaying in a series of portals to simulate a sheet of image thumbnails. The concept is working fine, with the exception of a minor glitch when viewing the file over the internet. In layout, I have chosen the graphic format options of "Reduce or Enlarge" and "Maintain original proportions". This format works fine when viewing the portal from within FM7, but when viewed through a browser, some of the images are distorted, ie it appears to ignore the "Maintain original proportions" option. Has anyone got any suggestions? FileMaker Version: 7 Platform: Mac OS X Panther
-
- 0 replies
- 727 views
-
-
hello all, this is my first post to these forums. I'm a newb when it comes to working with Filemaker, so please bear with me. I work in a production biochem lab, and our production is documented using Filemaker. First, a look at the database I'm working with and then, a look at what I want to do with them. I have two files of concern right now. One is called Inclusion Body QC. The other is Tetramer Production. Inclusion bodies are reagents that we must produce to make tetramers, tetramers being our final product we ship to people. so here's the deal. there is a lot number for each record in Inclusion Body QC. Tetramer Production references this lot nu…
-
- 2 replies
- 943 views
-
-
I'm struggling with what should seem to be a simple issue, but I'm stumped. I have a text field which has content of varied length (anything from 3 lines to a couple of pages). The problem is that I can set the field in sliding/printing to shrink, but I can't get it to expand - so if it is more than the maximum space I've allowed the text gets cut off in preview mode. Any ideas? Am I missing something stupid? Version: Developer v6 Platform: Mac OS X Panther
-
- 1 reply
- 1.2k views
-
-
Hi, I'm trying to set up several fields such that when you select a value in one, the options for the other fields are decreased. The fields will contain stuff like Company, Product, Size, etc. When a specific Company is selected, the available products from that company are narrowed down. And then when a specific Product is chosen, the available Sizes are further decreased. Also, I would like to have the order of selection be variable. (I have a separate file with Company names, products available from that company, and their sizes.) I tried doing this with portals, but couldn't get anywhere. Any help is much appreciated. Thanks in advance! …
-
- 4 replies
- 947 views
-
-
I am looking for a list of html / php tags a nice long list of them I am trying to include them as references so that I can use FP7's text formatting functions to be able to colorize tags in a text field akin to that of BBEDIT. FileMaker Version: Dev 7 Platform: Mac OS X Panther
-
- 5 replies
- 1.4k views
-
-
I have a database that I use to track Mortgages. I have a contact log, which is a portal, that I use related scripts to do data entry. (Keeping the phantom record out of my portal.) Last week, I made some updates to the database, mostly layout changes, and now, new records will not show up in the portal. All records that were previously there, are still there, and new records I put in, show up in the "Contact Log" child file. However, new records don't show in the portal itself. I've rebuilt the portal, the relationship, and the fields. Same thing. Another strange aspect, I went into the child DB directly, and duplicated a record that is still showing up, and…
-
- 3 replies
- 792 views
-
-
Any suggestions for how I might format layouts/reports so that I can produce an indented list? Specifically, if I have a chart of accounts with basically two fields, accountNumber and accountName, can I get the sub-accounts to indent? E.g., 4500, Utilities .. 4501, Utilities, Electric .. 4502, Utilities, Gas 4600, Insurance .. 4601, Insurance, liability etc. (These are just sample numbers--the periods are just to force an indent here; the actual account numbers I'm working with are longer and have up to two [perhaps 3?] levels of sub accounts.) I've thought of breaking the account numbers apart (e.g., 45 and 01) so I can summarize by each part …
-
- 3 replies
- 1.2k views
-
-
Hey, I'm developing a Contact Management System for a school team project and we're a little new to filemaker pro. Very new actually. We're working with FileMaker Pro 7 and need to if and how to mix different fields from related tables in a single portal. Here's the deal: The client wants a Contact Activity Log, tracking communication and donation activity. The Communication and Donation are related back to Contacts via 1-to-M relationship Contact Table (ContactID, Name) Communication Table (ContactID, MessageID, Message, Date) Donation Table (ContactID, DonationID, Amount, Date) For a given contact, I can get a portal to show either the related c…
-
- 3 replies
- 840 views
-
-
I am making a Layout to print some envelopes. In order to make the navigation easier on the envelope layout I added some buttons in the header. However when I print the envelope it also attempts to print the Header buttons. I then tried to change the header to a Title Header thinking maybe it would skip the printing, it doesn't. So is there a type of header that is non printing? or is there a way I can designate the buttons/header an non-printing Thank You FileMaker Version: Dev 7 Platform: Mac OS X Panther
-
- 3 replies
- 1.7k views
-
-
Hi All, I'm creating a questionnaire for subjects in a psychology experiment. I have one table containing all of the questions, and have created a separate layout for each question (so one question appears per layout along with a "next" button advancing you to the next layout with the next question on it). I want to include validations such that people MUST respond to each of the questions before moving forward. When I have tried to do so, it seems that the program wants ALL of the conditions for the entire table met for each layout/question. For example, I complete question 1 (select a radio button number), then click next to move forward, but receive a pop-up info…
-
- 3 replies
- 1k views
-
-
Hi, Lets say I have: "ITEMS INFO" with three records, being the field "name" content "A","B" and "C" "INVENTORY OF ITEMS", related by "name" to "ITEMS INFO", with six records: A,A,A,B,B,C Can I have a portal in "ITEMS INFO" so it can show and inventory, as follows? A: 3 B: 2 C: 1 Thanks in advance! FileMaker Version: 5 Platform: Windows XP
-
- 3 replies
- 1.1k views
-
-
Can I get coordinates of a mouse-click, to indicate where on a map somebody has clicked? Needs to work for both Mac and Windows. [color:"black"] FileMaker Version: Dev 6 Platform: Mac OS X Panther
-
- 2 replies
- 1.2k views
-
-
I have a layout with a report: Agent fees by year. My problem is when one Agent has salary plus taxes monthly (2 lines), I need to make a third line : Subtotals (by month). Is there any elegant way to make it in a single line? (Cf. PDf Layout & Pdf. Preview):: Another question: In the bottom, summary part. I need to calculate the average ("promig") of hours cost but instead of counting the subtotals divide by the number of entries (or mouths), it counts by entries. Any elegant form or a calculating field to made that? Really thanks a lot Toni FileMaker Version: 6 Platform: Mac OS X Panther Layout.pdf
-
- 1 reply
- 1.1k views
-
-
Hi, First ever post so here goes... Overview I am trying to create a portal showing all the unpaid invoices for a client. The ultimate goal is to have a button to produce an individual client statement of amounts due. Structure I have a client table, an invoice table and a payments table. The fields I'm using are 'client ref' and 'pay status'. 'Pay status' is calculated by taking the sum of payments in the payments table ('due') and subtracting it from the invoice total ('total'). The calc for 'pay status' is If(due=0,"paid", "unpaid") The Problem I'm trying to define a relationship between the client and invoices table based on a calculated…
-
- 4 replies
- 862 views
-
-
Hello I would like to know if it is possible to do the following. Have a field called "color" Have a field called "intensity" a Value list called "Regular" with the following RED, BLUE, GREEN a Value list called "Pastel" with the following "PINK, GREY, YELLOW" Is there a way to change value lists if the field "intensity is changed" so if "intensity " = "REgular" the Regular list gets in the field color through a drop down. But if "intensity " = "pastel" the pastel value list gets in the field color through a drop down. I am just trying to find out how to do this? Thanks STan FileMaker Version: 7 Platform: Mac OS X Panther
-
- 4 replies
- 887 views
-
-
I have a self-join relation and a portal based on that. Within the portal I want a calc field to compare the value of a field in the portal, with the value for the current record (outside the portal). There seems to be no way to get them both at the same time. If I base my calc on the portal's relation, I can get the portal row's field value, but not the current record's field value (it evaluates to the related value). If I base it on the current layout, I can't get the portal row's value. Any ideas? FileMaker Version: Dev 7 Platform: Mac OS X Panther
-
- 2 replies
- 614 views
-
-
I am trying to generate a value list from field entries. Here's the scenario: 1. I have a 'customisation'-layout with 10 fields declared as (text) variables: They're named 'Unit1_description', 'Unit2_description' etc. . 2. In this layout I also have a calc-field named 'Unit-list'. It has a formula which concatenates the entries in the unit description fields into a list. 3. On a separate 'manager' layout (the one for specifying the actual DB records) I have a field pointing to a value list called 'Unit_descriptions'. 4. 'Unit_descriptions' is set to import its contents from the calc-field 'Unit_list'. BUT: it won't. When I try to select something from th…
-
- 2 replies
- 955 views
-
-
I have created a very simple non-relational survey form with lots of multiple-choice checkboxes. Halfway through, my checkboxes are no longer visibly working, although when I change them to pop-ups, my selections are there. Are there some kind of limitations placed on how many value lists you can include on a form by using checkboxes? How can I work around it? It's making a very very simple project turn into a frustration. I'm a non-techie, so please, keep it easy to understand. Thanks for your suggestions! After I get all these surveys done, I will have questions about how to correctly compile and interpret my data...any ideas? Robin FileMaker V…
-
- 10 replies
- 1.3k views
-
-
Hopefully there is an easy answer to this: My invoices file has a portal that contains client files from a related file. If they have paid, the paid field says "yes", if they have not paid the field says "no". Let's say I have a client that has not paid for 3 items and those 3 items show in the portal. When they have paid, I would like a script that would change the 3 portal row paid fields from "no" to "yes". Thanks in advance for you help - sam FileMaker Version: 6 Platform: Mac OS X Panther
-
- 1 reply
- 665 views
-
-
I have 6 views of the exact same data - in two of the views, the data is filtered based on different globals, in the other 4 of the views, the data is sorted differently. Is there a way to Duplicate Layout, change the portal to the appropriate relationship and then do something (other than having to reset each field - there are 25 per layout) that will force the fields to take on that relationship?
-
- 1 reply
- 839 views
-
-
I need to select fee codes from a list. Some fee codes are available to all technicians, some are available only to one trade and some are available to more than one trade, but not all trades. To make it more complicated, some technicians are qualified to bill in more than one trade. I tried using repeating fields and conditional value lists, but didn
-
- 5 replies
- 1.3k views
-
-
Hi there, I am working on two different solutions and in one of them when I insert a global filed on the "header" or "title header" areas they become inactive! This is happening while I have global fields are working normaly on the "header" part in my other solution. I'm totally confused. Does anyone know why this is happening? I'd appreciate any help. Thanks, Saeedd FileMaker Version: 6 Platform: Windows 95/98
-
- 2 replies
- 1.1k views
-
-
Kind of a 2 part question: 1) I have a order entry db where you select the customer. The customer list is based on a Customer Database file. However there can be more than 1 entry of a customer name but have to different bill to addresses. Such as: Customer BillToCity Best Buy San Fransico Best Buy New York If I did a field list on field Customer, Best Buy only shows up 1 time, even though there are 2 entries for it. If Order Entry selects "best Buy" OE only the related information for the first city appears, the other city does not, and is unchooseable. Is there a way to see both "best buys" in the value list??? Part 2 of question:…
-
- 5 replies
- 900 views
-
-
This is my first FM and contains the in/out post between my office and others in diferent cities. I made one file (register) and two related files (in and out): each record with the fields (from, to, date, reference, issue, reference out). In the register file I made two layouts (in and out), each one with a portal that shows and filters the records. I would like to automatize one thing. When I create a new record in the out portal, and I type de "reference" field, I'd like FM to find this record in the "in" portal, type the reference in the "reference out" field and get the "issue" field value and type it back in the "issue" field in the "out" portal. I don't know …
-
- 1 reply
- 803 views
-
-
I have one file, with 2 different layouts. I would like to hide certain records from layout one, but would like to see these records in layout 2. When I try this, the records disappears from both layouts. Can this be done? Thanks for your help. Bubette FileMaker Version: 6 Platform: Mac OS X Panther
-
- 2 replies
- 1.2k views
-
-
I've noticed in several sample files I've downloaded that the developer placed the header,body and footer on the left side of the screen allowing an unobstructed view while setting up your layout. I can't seem to find any information on how to move these objects. Any help greatly appreciated. FileMaker Version: 5 Platform: Windows 2000
-
- 2 replies
- 1.1k views
-
-
Hi, I created a value list consisting of +, -, d. I'm tyring to sort in the order +, d, - but despite defining the list in that order, the sort is not working. Does anyone know of some special rules that apply to using non-alphabets in these lists and how to fix it? Thanks! FileMaker Version: 6
-
- 1 reply
- 975 views
-
-
In my invoices file I have a global value list to check on a customers paid status. Value list = yes, no and all. I have created a calculation field in invoices: paid_filter & " " & customer_id The paid_filter is the global field that has the value list. In the right hand portal relationship I have creaded a calculation field: Paid & " " & customer_id & "
-
- 2 replies
- 725 views
-
-
In version 6 I have a file set up in layout mode that is view 1 page at a time. If I browse it, I see one page at a time. If I look at it in preview mode, I see a page between 1 and 2 that is a partially formated (some of lines,but no data) If I print all pages this page prints.If I print and select page 1 or page 3 it does not print. If I browse all pages, I do not see a page between 1 and 2. I have tried entering more data for up to 5 pages and then deleting pages 1 to 3, but it stills shows(the partially formated page) when I print, or look at it in preview mode. How can I get rid of it??? Thanks Learning FileMaker Version: 6
-
- 4 replies
- 1.3k views
-
-
Hello, I copied a tab interface from a DB and pasted it into my layout. Each tab has a label, and both the label and tab are set to "Go to layout(LabelName)". Most of them work properly, but 2 or 3 of the buttons do not perform. They just blink as if they're "Do Nothing" scripts - but when I DC on a faulty one, it shows the proper link to "Go to" the correct layout. I tried selecting them as a group, arranging them to Front and then back, but I can't figure out what the problem is. Finally, I copied the tabs/labels and pasted them into a new DB - and they work fine - which leads me to believe it may be a layering issue - or maybe an "order of creation" issue. …
-
- 2 replies
- 1.4k views
-
-
Hi Folks, I'm tooling around with a eval copy of FM7 and am using the Photo Album template. However, I cannot seem to size my window any wider than the default 600 pixels (+-). I am able to make the window taller by dragging the dotted line at the bottom using the Move tool but cannot make it any wider. Any suggestions? Thanks in advance, Lurch FileMaker Version: 7 Platform: Mac OS X Panther
-
- 0 replies
- 1k views
-
-
With FMP 7.0 in hand, I'm updating my department (Media Services) database from 4.0. We keep multiple files open for diffent scheduling and equipment allocation forms. There are usually three or four open at one time and we need to go back and forth between the files. (I hope this makes sense) I was wondering if I could make a navigation bar that would stay on the screen and always be available to take the user to any of the files that are open. I'm starting to plan out the new databases and would like to work this in somehow. I have a lot to learn about the new 7 version, I just got the hang of 4. Thanks for any help, Kris Kauker FileMa…
-
- 1 reply
- 1.5k views
-
-
NB - just realised I posted my query in the wrong section (I think) - many apologies for doubling up.... Hello, I have a 'wish list' field and an 'actual' field containing multiple items (could be check boxes or radio buttons). These use the same value list. I'm trying to create a 'pending' field to automatically show me the 'wishes' that aren't yet 'actual' but can only get a blank field. Thought I could have an auto-enter calculation to say 'wish - actual = pending', but (of course!) its not working. I'd really appreciate any help anyone out there can give. Many thanks in advance, Holly FileMaker Version: 5 Platform: Windows XP
-
- 2 replies
- 811 views
-
-
I know there has to be a way to do this, but this is the first I've tried, to use memebers of a value list in a calc. for instance (if(X is a member of value list A, "it is a memeber", "it is not a member") Any one know? Version: v5.x Platform: Windows XP
-
- 6 replies
- 935 views
-
-
Instead of just listing the current page number in the header of a report, I need to list page 1 out of X where X is the total number of pages in the report. I could not find a function to calculate total pages in report. Is there such a function. Or does someone have a good formula or work-around for this. My client sends our multi-page proposals and wants to be sure the recipient knows when pages are missing. Thanks Version: v6.x Platform: Windows 2000
-
- 4 replies
- 1.4k views
-
-
We use filemaker for publishing of books and we want to use filemaker to also create our flatplans onscreen - this makes sense as the databse holds all our production details. So what is needed is a layout where there are 32 records per page. These have to be in four rows of eight,so the page is landscape. Now this can be easily done by setting up the layout to have 8 columns across etc which can be seen in preview mode. However in preview mode you cant access the data. For that you have to go to browse mode which reverts to a single column. This is no good, we want to be able to access data while in the layout mentioned before. I figured that this could …
-
- 1 reply
- 959 views
-
-
Can I format a field to 'include vertical scrollbar' and also have the data non-editable? I have some forms that are psuedo-"read only", and a few of the fields require a scrollbar. But when I disallow any entry into the fields, the scrollbar no longer works.
-
- 8 replies
- 1.6k views
-
-
Hi I have a related field I wish to use as a value list. I know how to do that, but I need to filter out the values that arent part of the relationship. Trouble is when i select "include only related values" the pop up doesnt work any more. if I select all values then I get too much and not related info in the list. thanks for any ideas I'm using v7 Version: v6.x Platform: Mac OS X Panther
-
- 7 replies
- 1.1k views
-
-
Is there anyway to get rid of the splash screens that appear when your database opens related files? Mine opens about 10 related files in the Open Script and I'd like to show a screen that says something like, "Please wait while the system starts up", without having each splash screen pop up as files are opened. FileMaker Version: 6 Platform: Mac OS X Jaguar
-
- 1 reply
- 1k views
-
-
Hi, Firstly - I'm so happy that you are all out there! Got lots of useful info from this site and will do my best to feed anything I learn back in (one can hope!) Total newbie who is sure FM should enable me to do the subject I typed, but no information I can find as to how. I have 5 main categories in my DB, and want a different range of fields to be presented for data entry depending on the category chosen (only three different fields, but unless I manage the process, I know people will do it wrong!). I thought I could calculate it, but no option to input my value list and think that I can only use this to calculate a value rather than perform an action.…
-
- 2 replies
- 769 views
-
-
Hello I would like to have a layout that is used to input information that can only be put in once. After the information is entered and proven to be correct through a dialog. I would like the layout and those fields to be locked out and only then -is this possible ? Thanks STAN FileMaker Version: 7 Platform: Mac OS X Panther
-
- 5 replies
- 1.4k views
-
-
This is probably a very easy question for someone to answer and I feel a little dumb asking it, but......Can someone tell me how to change the formatting of radio buttons that I have set up in an input form? I just need to know how to change the color, size, etc. FileMaker Version: 6 Platform: Windows 2000
-
- 2 replies
- 928 views
-
-
Hi I use filemaker pro 5.5 for windows I have made a global container field with 2 repetitions. The problem is i want to have a different colour in each repetition (Red and Blue), but i can only colour both in the same colour at the moment is there a way of making the repetitions have different colours I am a very simiple user, please expain in full Thanks FileMaker Version: 5 Platform: Windows XP
-
- 1 reply
- 1.1k views
-
-
Friends, please help. I have no idea where to start, but here's what I'm hoping to do. I am in the process of creating a db and have found the need to create a method of dynamically populating fields based upon a selection of another field. I have three levels of categories, main, secondary and third. If the user selects 'A' in the main category list, I need only the applicable values to show up as available for choosing in the secondary category field (same for the third category, the selection made in the second category populates the applicable list for the third category). Please tell me where to start and anything really important I need to know …
-
- 1 reply
- 891 views
-
-
Hi Perhaps this is a simple problem but I can not find a solution for it I am working on an inventory system. So far I made everything except for the final report. I have several products and I use one new record for every transaction (purchases, sales, transfers from one warehouse to another, etc.). Every record has the item number, item description, quantity for the transaction and price. For the final inventory report, I need one single line for each product with the item number, item description, current product quantity (the sum for all the transactions in the database with that item number), the price (from any of the records as all the records are upd…
-
- 3 replies
- 1.3k views
-
-
I listened to Miles Davis' Kind of Blue CD earlier in the week and cannot get the song "All Blue" out of my head. Cannonball's alto sax solo has been bouncing around in there for like three days now. That and the piano solo that follows. And Coltrane's tenor sax... Not even Bruebeck's Take Five at "realistic sound levels" has been able to get it out. Any suggestions?
-
- 26 replies
- 3.1k views
-
-
Hi there, i wish to create some calculation field to validate the record inside a portal. For example if a field length more than 15 characters then it will display a message to let user know. Now my problem is the validation field is out site the portal and i will only display the validation message for the first record of the portal. If the fiest portal record contain no error but the second record contain error, it will not display anything. What i need is to display out the corrent error message inside a portal list, not only the first record. I have attatch 2 sample testing files that let you all know more clearly about what problem i face. Regards, Henry…
-
- 1 reply
- 729 views
-
-
When I show a portal on my main Form Page and submit data, the portal rows are not consistant. It will show the first 3-4 rows ok, but then starts leaving related rows out of the Form View. Is there a limit as to how many rows can be shown? Ar portals just sporadic within IWP? Thanks for any help you can give me. Very frustrated. Version: Developer v6 Platform: Windows 2000
-
- 0 replies
- 820 views
-
-
I am just now starting to play around with this but I thought if I asked the question now that someone might be able to save me some time. Here is the setup: Lets say I have a FM database for my music collection. In each record there is a place where you have Album Art displayed (in a container field). For one I would like to be able to display the Album Art, title and artist. I know how to do that but what I am wanting to do is instead of having just one tiny record per page, how can I get it to print say 3 rows with 4 records per row? It seems to only want to print one record per page which isn't very big and wastes a lot of paper if you are printing ou…
-
- 15 replies
- 2.3k views
-
-
I have a layout with many fields that are non-editable. All the fields are formatted exactly the same, to make sure I used format painter. It's driving me nuts because when I go to different records, I get drop-shadowed looking borders around the fields where other records there is nothing! Here are some pics so you understand what I'm talking about: No borders: Borders: I even tried duplicating the layout. It's completely random and for someone who is as anal about the layouts as I am, it's driving me completely insane, I've already spent over an hour with this today. Please help! P.S. - It's dummy information, so don't worry about t…
-
- 6 replies
- 1.5k views
-
-
Hi All, I have a portalk with 3 fields, I want to know from the main page ...i have 3 buttons, I want each button to sort each field in portal as I want. Is there a way to do so since the relationship from portal and main page is sorted already, i can not change anything? Any help Thanks Version: Developer v6 Platform: Windows 95/98
-
- 11 replies
- 1.6k views
-
-
Dear All I have created a value list that is based on a relationship. When two people are trying to enter the same value in to their record it says that the other person is modifying the record. Is there any way around this. All help much appreciated Version: Developer v6 Platform: Windows 2000
-
- 4 replies
- 1k views
-
-
hi all, I need help. All I need to do is have the same field of a found set of records become a value list as check boxes. This found set will never have more than 5 records, and I'd like to collect the data from each found field, and place it in a global field. However, I can't use a global field as a value list. What to do? I have what appears to be a simple task, but I've been racking my brain for hours to no avail. I have a single FM6 database that's not part of any relationship with other files. (I'd like to keep this as a single file database, not multiple files.) I've tried creating a script to copy/paste the global field information into a differen…
-
- 3 replies
- 749 views
-
-
Can anyone tell me how to export layouts from one filemaker file to another, if thats possible ? Version: v6.x Platform: Windows XP
-
- 4 replies
- 8.4k views
-
-
Please tell me I'm missing something simple! When creating "popup" value lists, I can [color:"red"]"Use values from first field" and [color:"blue"] "also display values from second field". Can the "popup list" be formatted to store the [color:"red"] first value (foriegn key) but display only the [color:"blue"] second value during and after selection... as one can with HTML popup lists (as shown below)? <select name="platform"> <option value=" [color:"red"] 1 "> [color:"blue"] Windows </option> <option value=" [color:"red"] 2 "> [color:"blue"] Mac </option> </select> Right now, upon selection, the user see…
-
- 10 replies
- 1.6k views
-
-
Hello, all. I'm developing a system for a school what will track student data, staff data, etc. I'd like to get some feedback on my UI if I could. You can find a sample here. I'd appreciate any and all feedback. I've also created a main menu database, what I'm calling a "task file." It does nothing other than allow the users to launch the various databases. Good idea? Thanks again. Version: v6.x Platform: Mac OS X Panther
-
- 6 replies
- 1.6k views
-
-
Hi, I was working on a simple invoice database, populating a simple custom value list with custom values (not related or from field). When I tried the value list it said "<Value list missing>". So I went back to the value list set up screen and then BOOM "The file "<Unknown>" is damaged, please use recover, do you want to continue using this file ?" So I tried recovering the file, the recover went fine but the result was the same. The file opens, define field and define relationships are ok but whenever I try accessing the value list setup the file crashes. And if I say "Yes" continue working with this file, FMP freezes. I'm l…
-
- 6 replies
- 1.1k views
-
-
I have 3 databases including a join file. A is a Vendors rolodex, B is a tariff of available Activities, and C is the join that allows all activities a vendor offers to be shown in A while all vendors who offer a particular activity are shown in B (via portal). Match fields are just a unique record ID (for each Vendor and each Activity) that are not useful for users to see. I'm stuck on the following: for each activity, I want the user to be able to enter multiple vendors by choosing from a value list that pulls all vendor names up from the Vendors file. I don't want them to be confused by the Unique ID, thus I don't want them to see it. How do I have them choose…
-
- 1 reply
- 881 views
-
-
i have trial 7 - i created three simple relational tables suppliers, components & products products contain many components in 6 all in well same theory in 7 doesnt allow me to into into the portal I have created to list all components and their various quantities ::?? what am i missing : Marcia
-
- 4 replies
- 1.2k views
-
-
I'm updating a file for a client who _refuses_ to have a relational database (every bit of information must be in one or it's too complicated for her to figure out...believe me, I've wasted a lot of time and effort trying). The file is essentially a Roladex of travel agencies, where individual agents within each agency are listed across 4 repeating fields (first name, last name, job title, email address). Client insists that she must have a way to make address labels for each individual agent. I'm not sure how to do so without a second, related file (again, which she refuses to use!). Is there a way to set up a report that will take First Name/Last Name from each …
-
- 5 replies
- 1.6k views
-
-
Howdy. I am attempting to create a situation where when i choose one item from a pop-up menu, for example, an island in hawaii, I want the pop-up menu in the next field to contain only data specific to that island. For example, if i choose "Maui" from my first pop-up, i want only a list of beaches on maui to pop up in the next field; if I choose Kauai, then only beaches on Kauai will appear in the next field's pop-up. i know that I have to create a relationship between the two fields, "Islands" and "Beaches" and then to create value lists that work within that relationship, HOWEVER, I can't for the life of me figure out what the hell to really do, tho its not fo…
-
- 1 reply
- 848 views
-
-
Hi! Help! I am attempting to create a new layout for my database, one in which I pull many of the fields into a printable contract (or any type of document, actually) without any graphics or text boxes, etc, just a document I can print and fax to clients. But trying to use the Insert Merge Field method is definitely not working due to the number of fields (slow going), and the fact that I'm then having to go back in and type the field names in front of the inserted merge field, and the texts are overlapping, difficult to organize, and too numerous to organize, too. Not every field, however, needs to have the field name in front of it--only some. I intuit that t…
-
- 2 replies
- 1.2k views
-
-
I have created a layout which contains summary and subsummary parts. The preview mode works fine for most of the time. I am not sure when it occurs, but at some point when I click on preview the summary fields do not show up anymore, just the header and the body. Oddly enough, in Browse mode in form view the single record looks fine with the subsummary fields correct etc. any thoughts? Version: v6.x Platform: Mac OS X Panther
-
- 4 replies
- 1.4k views
-
-
What I am trying to do is to move lots of info into a portal using a script. I have about 90 lines and for each line I want to make a new record via a portal, so i can create some reports in another database. I wrote a few lines in my script..Surmized..copy field 1 row 1;paste field 1 row 1, and it goes to the right fields in the portal. Now when i go to copy the second line (the portal does allow creation of records), it pastes it over the first record. I Tried using the, goto portal row (next), but that works like firetruck without water! Thanx think [outside the box] Version: v6.x Platform: Windows 2000
-
- 2 replies
- 793 views
-
-
Hi all, I need to know if it is possible to have 'multi-lined' text (in specified fields) in the table in browse mode. I have a field that is usually about 20-30 letters long. In the table the text stays on one line but I want it to start a new line instead of being cut off and unviewable unless you click on it. Help! Thanks in advance, Nick =: Version: v7.x Platform: Mac OS X Panther
-
- 1 reply
- 1.3k views
-
-
I am a new File Maker user. I am creating an order form and I would like to be able to choose a graphic from a pop-up menu. I have been able to make text pop-up menus. Isn't the first step to make a 'value list'? Also how would I choose a graphic that is in another File Maker database in a container field? Thanks Version: v6.x Platform: Mac OS X Jaguar
-
- 1 reply
- 779 views
-
-
Hi guys, Is there anyway I can have the user do a search on a value list? - in that once in find mode, you can select an item from the list? (see screenshot) i.e the value list is from another database of company names, as such the user needs to open up the matter database and search for xyz Company to display their records. I can't create buttons because the list of company's will expand constantly. Hope that makes sense. I have FM 6, but have FM 7 also - just haven't installed it yet. test.zip
-
- 12 replies
- 1.3k views
-
-
Hi I made a beautiful looking interface in Photoshop. Converted it to a jpg and then pasted it into the backgound of a blank layout and it made the program really slow. I have found that little graphic objects have white flickers as well. Is there any way around the background problem. It is such a beautiful file but very slow. Please tell me there is a way to speed things uP! Thanks Stan Version: v6.x Platform: Mac OS X Panther
-
- 2 replies
- 1.4k views
-
-
Well I can't figure this out...I need a conditional value list where when the user selects a state the state standards appear...sound simple but it might as well be brain surgery cuz I can't make anything out of it.... I've included the file if anyone can figure something out name your price...I just have to result to bribery! Version: Developer v6 Platform: Windows XP pe.zip
-
- 20 replies
- 2.9k views
-
-
hey do i make it so when a item is selected in a pop-up menu it then take you to another layout and displas the info of the record seleted from the popup
-
- 2 replies
- 1.1k views
-
-
Wish to construct a layout that will use other calculated fields to build another calculation like on a spreadsheet Example: Date, leave earned, leave taken, total leave 01/01, 12 hours, 3hours, 9 hours 01/03 0 hours, 2 hours, 7 hours 02/03 12 hours, 8 hours, 11 hours Total leave is a running calculation based of previous record calculation The example above would be a report layout. Data entry would only be for date, earned, taken Thanks Version: v6.x Platform: Mac OS X Panther
-
- 5 replies
- 1.5k views
-
-
Gday all, I have two tables, one for Schools and one for Students, with a one-to-many relationship set up using SchoolID::SchoolID. I have a Portal in Schools displaying the students for each school, that's all working fine. Now I need to be able to refine this list by various properties, a couple of which can be drop down lists (student classes, grading), a couple are wildcard text comparison (names etc). I have read many many posts on this problem on this board and others, and I understand the issue as presented in djgogi's Article (http://www.fmforums.com/threads/showflat.php?Number=54888), that using Find in the portal will only search the Schools tabl…
-
- 3 replies
- 807 views
-
-
Greetings everyone. Sorry for the newbie stuff, but having followed the manual to the letter ( I believe), and reading many of the portal-related emails here, after several days I still need help... I
-
- 32 replies
- 2.6k views
-
-
Help please - I need a method for printing the same lable over the whole page of lables. I'm a brand new convert from access . Any suggestions greatfully appreciated !! Version: v6.x Platform: Windows XP
-
- 3 replies
- 1.7k views
-
-
How do you format a calculation resulting number when it is used in a mail merge field. $125.50 shows as $125.5 when the field is placed in a letter using mail merge. I cannot get the field to show the second 0 as $125.50. I can format the number field to show the 2 decimal places when it is used on layouts as the number field it is, but in the mail merge layout the <<mail merge>> field when selected only gives options for text formatting- the number option is grayed out. If I mail merge a number field that it not a calculation field, the second "0" shows but not when it is a number resulting from a calculation. Book cost(number field) of $2.50 mail mer…
-
- 2 replies
- 1.6k views
-
-
Hi all I have a portal that i want to use for finding drawing number. I have create a simple script that would goto related records Goto to Layout Main Goto related records (show only related) And attached this to a field in the portal. Put when someone picks a record the first record in the portal is shown, no better which record is chosen. I have create a self join relational to create the portal and the related record script is base on this relationship, What am i going wrong. I an using FM 6. Thanks in advance Lionel
-
- 2 replies
- 760 views
-
-
My database users have a variety of monitor sizes. Is there a way that I can have filemaker zoom the layout to fit the screen? Thanks Version: v6.x Platform: Windows XP
-
- 3 replies
- 1.4k views
-
-
Hi, I have a portal with a delete graphic (a global) in the portal row. Unfortunately the graphic shows in the new entry row at the base of the portal (background formatting to the other fields shows too). I can see people trying to delete what seems like an empty record. Can I get the last portal row to not show any formatting? thanks Version: v6.x Platform: Mac OS X Panther
-
- 6 replies
- 775 views
-
-
I asked this before but didn't get answers from all the guru Carpal Tunnels How do YOU make popup menus look OK when displaying value lists? The goal is to get the serialized record ID of the record whose value is selected in the popup. An alternative in FM7: a field could be made into a button with a script that pops up a window with a portal, where each line is a button scripted to set the proper value and close the window. Here's what I have done, attached are two FM6 files. [color:"red"]Scenarios Basics: Related file has serialized record IDs in field RecID. A calculation field has person's name: c.LastCommaFirst. The main file has a field f…
-
- 6 replies
- 1.1k views
-
-
This project is for a school. I have a group of records with data: State_________Days_______Billing Days PA____________29 PA____________60 PA____________193 What I need to occur is have Billing Days be a calculation that says if any of the Day fields are over 180, put the following calc: If(Days >180, 180, Days). So the data would look like: State_________Days________Billing Days PA____________29____________29 PA____________60____________60 PA____________193__________180 But this should only happen if one or more of the State records has over 180 in one of the Day fields. If the records look like the …
-
- 4 replies
- 882 views
-
-
Okay here is the situation, I have four tables; events, group, students and schools. I want a portal on the events layout to display information based on data from the group, students and schools tables. Where lationships between the tables flow like this: { events -> groups -> students -> schools } events::Id -> group::Id group::studentId -> students::studentId students::locationNo -> schools:locationNo Here is a sample of the table schemas EVENTS: eventId eventName ... GROUP: eventId studentId studentName currentAge currentGrade currentSchool ... STUDENTS: studentId studentName studentDateOfB…
-
- 4 replies
- 973 views
-
-
Hello everyone. First post, but have received tons of info on here already. Thank you. I have a DB that has 5 tables. One is equipment.fp5 and one is who_had_last.fp5. The relationship is based on an Inventory_NO field in both. When a tool is checked out, the check_out date is filled in along with Assigned_to. When it is brought back in, the user presses a button that runs a script to put in the current date to the Check_out date field, and the warehouse it was returned to. They were wanting a way to track who had that tool last. I came up with adding to the script to move the data from Check_out date and Assigned to over to the who had last.fp5 file. …
-
- 0 replies
- 711 views
-
-
Example: I have 2 FM files. In the first file I have Layout with 3 fields (US Dollar rate, AU Dollar rate, NZ Dollar rate). Record keeps currency rates for every day. In the second file I have Layout with fields Item, Cost, Date, Currency, Converted Cost. Currency is a text field (pop up list: US Dollar, AU Dollar, NZ Dollar). What I need: If I create new record in the second file, enter Item name, Date, Cost and choose currency, program will look up for the Currency rate (specified in Date) in the first file, calculate cost and put it in Converted Cost. Question: Is FM able to do that? Thanx! Version: v6.x Platform: Windows XP
-
- 2 replies
- 1.5k views
-
-
We recently moved from Macs to XP and have started to experience a strange happening when printing layouts with text fields, i.e., just about all of them! I've simplified the problem with a text field with a border on a layout. I've typed some text into the field so that on the screen and in Preview the text occupies the space I've allocated to the field. But when it's printed there is a gap between the end of the text and the bottom of the text field. Can anyone explain why, or better still, what to do to get rid of the gap? I've tried Sliding, using different fonts, using different printers. It even happens when I create a new database. Surely not everyone usi…
-
- 4 replies
- 1.6k views
-
-
I have a pop-up list field and a portal. I would like to make each new record in the portal contain the information selected in the pop-up list. I tried using a global field, but this interfered with other areas of the database. By dropping the pop-up list in the portal, I can get the info to show in the first portal row, but no subsequent portal rows. Any ideas how to get this to work? Would like to avoid scripts if possible. Thank You. Version: v6.x Platform: Windows XP
-
- 2 replies
- 848 views
-
-
I have a calculation that uses future (planned)invoice record totals. These future invoice records are presented to the user via a portal. When a future invoice record (located in another file) is deleted from the portal (delete portal row button)the calculation doesn't immediately update. However, if you change the invoice total in the portal the amounts update. This seems strange. In addition, after deleting a record, the calc field will show the result of the deletion once another field being used in the calculation is changed. I don't know is this is important, but I am using a "sum" operator in the calculation. Please help. I would like the deletion of a r…
-
- 3 replies
- 685 views
-
-
Hello forum, I would like to create a field where as a user could select hours and minutes from a value list. I think creating a custom value list of numbers just wouldn't do it. example I have a field called events and I would like to allow the user to enter a time for the event from the value list. Hope I am clear? Also I would like to have a layout where the user could use a calendar and click the day of the event upon clicking the event information would appear of which he or she selected Thanks for you help in advance dharkin Version: v6.x Platform: Mac OS X Panther
-
- 4 replies
- 1.2k views
-
-
Hi everybody ! I try to create a report showing subsummary results in a 2-entries table. Let's say I'm selling products that have references as key identifier. I would like too have informations about the revenue I got with one product in one month. So this revenue is a subsummary per month AND product reference. I can easily have this result, but I can't find the way to present it in a table... See the attached file for more details. Help. Thank you Result.txt
-
- 4 replies
- 1.5k views
-
-
ok i have to feilds name and address both in 2 diff files i want it so when hte click the field Name in file 1 they choose a name and it inserts it aswell as the corresponding address from file 2? i have it so far so when they click Name in file 1 it inserts the name from file 2 but how do i make it so it also adds the address? thansk
-
- 6 replies
- 1.1k views
-
-
Does anyone have any experience with using barcodes with Dymo labelwriters? My issue is when using barcode fonts printed straight on wide labels they can be read without issue. As soon as I rotate the barcode and print it doesn't read correctly. Font is IDautomation Plug-in is also IDautomation Font printed portrait or landscape (with filemaker) on a laserprinter works fine. I'm assuming, the graphical representation that filemaker provides is the issue. Thanks for any input Version: v5.x Platform: Windows XP
-
- 0 replies
- 1.3k views
-
-
Hi, I have a dB with 2 fields defining the number of checkboxes in two other field. Example: Field_1 --> 5 ---> I got 5 checkboxes into the field CHECK_1 Field_2 --> 3 ----> I got 3 checkboxes into the field CHECK_2 Now, I would like that CHECK_2 is repeated for the times defined by Field_1, in a manner that each group of checkbox is independent, but contains the same number of checkbox. Example: Field_1 -->5 Field_2 -->3 CHECK_1 CHECK_2 1 1 2 3 2 1 2 3 3 1 2 3 4 1 2 3 5 1 2 3 And I would like to sign…
-
- 0 replies
- 768 views
-
-
I have a lesson plan database that I want to create into a Runtime so as to distribute. However I would like to include the State Standards for each state and have the user choose their state and have that state's standards appear in another field as check boxes. I originally planned on charging extra for the cutomization but I know that would be a nightmare... Is there a way I could have the standards made as value lists which allows the user to choose their own? My next concern would be that when I make the runtimes I always select do not allow the user to modify the database. Is there a way to allow them to only modify the standards and their school district …
-
- 3 replies
- 1k views
-
-
I have an Events Table (fundraising Events). I have another table that has Categories - each event can have its own Donor Categories, and the user can add categories as they wish for the event via a portal. So, they have entered "Donors", "Silent Auction", "Program", etc. to record the various categories for that Event. The portal on the Event Form selects records in the EvtCat table where Event::RecordID = EvtCat::parentRecordID. Now, of course they want sub categories added - and so I created a SubCat Table so that for example the Donor Category could have "Gold", "Silver", "Bronze" etc for the level that the donor contributed. So on the same Events Form I would like…
-
- 3 replies
- 932 views
-
-
Hello, Is it possible to have a calc field the calculates only on defined lines of a portal. eg a 'sum' calc for only the top three records in the portal?
-
- 14 replies
- 1.9k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online