FileMaker Interface Features
-
Hello -- I have a feeling this is going to be simple. I would like to have a table layout with a popup menu at the top. This popup would be populated by a value list. Whenever one value is selected in that list, the layout only shows records that equal that value. The popup would not change any record. In this case, the list would be Semesters. Whenever a semester is chosen from the list, the table only shows classes from that semester. How would I make this work? Thanks for any help!
-
- 1 reply
- 750 views
-
-
Hi - I'm creating a small media placement process and have 3 fields - Type, Name, Format. I would like to enable the user to first choose a media type (eg: Magazine) from a drop down list. When they move to the second field - Name - it should show them a drop down list of only the magazine names (eg: Chatelaine). The 3rd field is then format - eg: 1/2 Page Ad. For each of the media types, there are specific Descriptions and formats related just to that media type. I can figure out how to use a table with a self-join for two of the options (eg: Type and Description) but can't seem to figure out how to have a third level associated. Any help would be appreciated. Tha…
-
- 6 replies
- 967 views
-
-
Is it possible to make the rows in a portal selectable, meaning click on a row to select and populate another field. My setup is a field in which you select a trade, (carpeting, painting etc.) the portal displays a list of all companies under that trade. I want to be able to have my users select the given company and have it populate to a grouping where your choices are held. Should I use another portal? and is there a way to make that row selectable? (I.E. double click the row and have your selection populate else where in another layout.)
-
- 3 replies
- 833 views
-
-
I wanted to make a layout that would insert info from several different fields into an HTML template, in order to copy and paste the code. I made a layout, just using text with tags for the fields, and the code appears the way I want it, but I can't select it to copy it. What do I need to do to make the same type of thing that I could copy and paste? Do I need to do a calculation and break up the code into sections, inserting the fields in between?
-
- 1 reply
- 944 views
-
-
Hello, I'm not sure of the correct terminology... If I have a field with a value list called "Countries", and if I choose the United States, I would like the field beneath it to have a value list with the 50 states. However, If I choose the country Canada, I would like the field beneath it to have a value list with Canada's provences. Is this called a conditional value list? If so, I can look through the FMP Forum archives to see if anyone has described how to set this up. Any help to point me in the right direction would be appreciated! Thanks! Alisun
-
- 11 replies
- 1.4k views
-
-
I have a portal that links to our main DB. It will list all of the jobs in house for a specific customer. It works great. But I want it to only show jobs that have not shipped. I need to "filter" out everything whose status field ≠ shipped. Any ideas how to do this?
-
- 2 replies
- 881 views
-
-
Hi All. First of all I want to say thanks for the help I have recived from this site... Next I have yet another problem ;o) I want to make the color of the text in a field depend on the content of the field. Something like this: if xx=0 set color to red else set color to black Looked at the different script functions but have not found any that I think/know could do the job.... Any help would be great Best regards The Dog
-
- 4 replies
- 892 views
-
-
I have a file with 2 tables. Person and Location. I have location related to person in 2 ways. Location Y ID field - related to - Person ID field Location N ID field - related to - Person ID field So I have 2 portals in person that is for YES AND NO. The problem is that with this setup the Location can be YES and NO. Is there a way to sort this so that either: The drop down list is dynamic so that if it is contained in LOCATION Y it can't be added to LOCATION N (or for that location Y again) Or Using a unique field Any help with this would be great thanks i have attached a rough demo to show the problem. Loc1 once it is added to t…
-
- 2 replies
- 933 views
-
-
Formatting text colour on individual rows of a portal, how would i do this.
-
- 12 replies
- 1.1k views
-
-
I have a field that contains the lender a customer is using, this is selected via a value list based on a field in a related table. I need to set up a report that shows how many times each lender is used(preferably with zero used lenders excluded) ie Bos 9 Woolwich 4 Halifax 6 Gmac 5 Not sure where to start.
-
- 17 replies
- 3.8k views
-
-
I made a button to navigate back to the main menu, but would like the data to show up in a table mode only. The button doesn't show up unless it's in form mode, is that correct? I put the button in the header, in the footer on the side, but am not having any luck unless it's in form mode. Did I miss this point in the documentation? Thanks in advance Have a nice day!
-
- 1 reply
- 769 views
-
-
Hello All. I'm struggling with a question that I think is probably pretty simple to resolve, but I just can't find the solution. I have a database of about 35,000 records (of student financial aid awards). Each of those records has a student ID number, the dollar amount of the award, and the type of the award (loan, grant, etc.). I would like to find the total dollar amount of each type of award for each student. In other words, I want to be able to say "Student Number 1323 had a total of $750 in loans, $300 in grants and $1000 in scholarships." How can I calculate a total according to these two criteria: student ID and award type? By the way, I …
-
- 2 replies
- 625 views
-
-
Ok i have the following two tables. Member(Name,Country,Points,Ranking,Season ID) Seasons(Name,Comment,Season ID) I have also created a self link from season to season based on Season ID,using a second occurence/copy of the season table(Seasonscopy).I changed the relationship from '=' to 'x'(ie match all records.) I have assigned members to various seasons then created a portal to show related records from member. However the portal isnt showing any data and i dont know why, ive done this exact thing in FMP7 before and it worked fine. What went wrong
-
- 7 replies
- 852 views
-
-
A button triggered script changes a status field in every row of a portal. The user then hits a 'submit' or 'cancel' button to commit or revert this change. Submit button works as expected. In FMP client, every update is reverted when 'cancel' is hit. In IWP, every update is commited when 'cancel' is hit. The only way to revert is to keep track of previous values and reset the fields. Is this a bug or am I doing something incorrectly?
-
- 0 replies
- 697 views
-
-
Hi Guys, Has anyone managed to turn the borders around repeating fields off? Ive got several repeating fields which are containers, which contain solid colours. Around each repitition I get a white border going around these colours (even though its a hairline)it looks like an eyesore on my layout. Ive tried the borders property, and turned line to nothing nut I cant seem to switch the border off. Many thanks as always
-
- 1 reply
- 726 views
-
-
Hi, I have a portal in one layout and I would like to add a field copied from a different layout. I have added the field to the table and relationship, but it won't work.
-
- 1 reply
- 611 views
-
-
I've got an invoice layout where I sub-divide our billable items by category, and I'm trying to see if there's a simple way to prevent the category heading (leading sub-summary part) from being orphaned at the bottom of a page while the items it pertains to break to the following page? I've been staring at this for way too long, so hoping someone can either point me in the right direction or tell me it's hopeless so I can move on. :P
-
- 1 reply
- 715 views
-
-
A user of mine swears blind that he used to Export the Records from a layout that has a portal on it, and he would end up with a tab separated file that had all the records from within the portal in it.. His end result would loook like this: main record 1 portal record 1 main record 1 portal record 2 main record 1 portal record 3 main record 1 portal record 4 main record 2 portal record 1 main record 3 portal record 1 main record 3 portal record 2 main record 3 portal record 3 Currently though, when using the Export Records menu command.. he's only getting this: main record 1 portal record 1 main record 2 por…
-
- 1 reply
- 659 views
-
-
I have a database with fields in English and one field in Arabic. Every time I need to enter arabic letters in that field, I have to switch to Arabic layout by clicking ALT SHIFT on the keyboard. When done I click the keys again to switch back to English layout. [color:red]IS THERE A WAY to auto enter that mode when the cursor is in that field. THANKS
-
- 0 replies
- 653 views
-
-
Howdy, howdy. Don't get up. I'm overlooking something probably very obvious--no surprise there! Referring to the attached file, I want to prevent duplicate Federal Aviation Regulations (FAR) from appearing in the report--in the example attached, FAR 121.191. I thought of a sub-summary angle, but alas no success since it won't allow for column set-up in there. The nerve! I appreciate your help in solving this minor brain hernia. Many thanks! Rich FAA_Database.zip
-
- 5 replies
- 967 views
-
-
OK, you'll have to think way back to FMPro v.6. I have set up a database of three related files to form a basic many-to-many relationship. One file is "projects" (manufactured pieces of furniture); another is "materials" (various lots of wood and so forth that is stored in inventory and then used in those projects); the third is a "lineitems" file that ties the two together, so that: In the projects file, I can view through a portal (to lineitems) all the various materials used in that project (and the dollar value of each). From the materials file I can view through a portal (again to line items) to see in which projects various types materials were used (and how much …
-
- 2 replies
- 1.2k views
-
-
I have an Invoice layout, which works fine in browse mode, all info correct, etc. The Invoice number and customer name appear as merge fields in the header and again in the footer (same merge fields). When I switch to preview mode, The header is correct, but the footer now shows data from a different record. What did I do wrong? This is dang frustrating.
-
- 1 reply
- 720 views
-
-
Don't know if this is correct forum? I would like to have a layout that displays records based on a value for a specific field. I have an inventory database and I would like a layout that shows items that correspond to a specific vendor. Ideally it would update itself when a record changes as well. I realize I'm probably making this harder than it is but the method I'm trying seems too involved. Thanks in advance
-
- 5 replies
- 799 views
-
-
I am trying to figure out how to divide a field that uses ";" as a divider in it. Example: In my paperwork the Color field is filled in with something like R134;L228. These two numbers reference colors for lighting. I have a field that is Color 1 and another that is Color 2. I would like the R134 to end up in Color 1 and L228 to end up in color 2. I understand the basic logic of the calculation, but I don't know how to write the calculation for Color 1 field. I feel it need to be something like {if color contains ";" use data before ";"} but in proper syntax. Could anybody help me with this? Thanks in advance.
-
- 12 replies
- 1.1k views
-
-
I have a report where I want all members info to print out. It looks like this: Name add city st zip phone I used a phone table for the phone numbers. On the report I have a portal that displays the phone numbers where I put the word phone. My question is, since everyone has a differnent amount of numbers, is there a way to tell filemaker to only use the amount of lines necessary for that record. Currently, I have to figure out who has the most amount of numbers and make it that big. This makes the report look messy when someone has just one number. Or is there a better way to do this that I am not thinking of? Thanks Dave
-
- 4 replies
- 1.4k views
-
-
I want to be able to sort columns in a portal by clicking on the headers. I have read some of the portal search threads in here and they are no help. It's just a bunch of calculations and the actual implimentation is never discussed. How does it work? Why isn't there a sort portal records script step in Filemaker? So you can select the field to sort by in the portal?
-
- 22 replies
- 7.5k views
-
-
Hi All I'm having a problem with a script. I want to check if a field is empty and if not show a message. If it is empty all I want is to select the field I clicked on. I'm having no problem with testing for field empty but I can figure out how to select the field I clicked on. I can make it work if I make a script that selects a specified field (aka the one I clicked on) if the other is not empty. But to use this will force me to make different scripts for each field.. This works but I have to set the field I want to select.. if ["field-to-check <> """] show message ["field-to-check not empty"] exit script else go to field ["field-…
-
- 5 replies
- 7k views
-
-
Having used Filemaker for quite some time, I am not just beginning to get into the nuts and bolts of it ... and I now have a portal question. I have a record that pertains to someone that has donated items to our golf outing. At the bottom I want to add portals so each year we can track what year someone gave something, what they gave and the value of it. I can enter information for last year and no problem. Then when I get the next line and enter in information for this year it creates a whole new record. What am I doing wrong? Thanks, Brian
-
- 2 replies
- 868 views
-
-
Hi I have a Table in which the person chooses an appointment by time of day (1-2, 2-3, etc). . . broken into categories. How would I display a nice report of that? I want to make it so that one sheet would list all appointments in chronological order. For starters.. the sort doesn't work because it is tricked by the text. I can't seem to figure it out.
-
- 1 reply
- 696 views
-
-
This is a common topic here, but I cannot figure my situation out. I have a table that lists "product line" and has up to 4 "category" fields. Example: Product Line: Category 1: Category2: Category 3: Category 4: Floral: Bouquet: Dried: Small Floral: Basket: Hanging Café Cake: Regular: Carrot Tort: Slice Café: Cake: Regular: Carrot Tort: Whole Café: Coffee: Mocha: 8oz Café: Coffee: Mocha: 12oz Café: Cold Drink: Regular: Ice Tea: 12oz So for each “coffee” drink that is a “mocha” there is an “8oz” record, “12oz” record and “16oz” record (3 records). I want to be able to choose only those fields that are related to those records. …
-
- 16 replies
- 1.5k views
-
-
My file has a damaged layout that I can't delete. Everthime I try to delete the layout, the program will quit unexpectedly. The file is otherwise functioning well. I have tried the help instruction given by the filemaker menu, never work. It just instructs us to scroll away from the layout then delete. Can anyone help?
-
- 6 replies
- 1.3k views
-
-
Is there anywhere a set of rules about how to position objects near the bottom and top edges of a Part, so as to make things mesh properly when printed? In particular, I'm trying to do the Lineitem portion of an invoice. The column header is in the Header, each lineitem is in a Body part, and the View mode is to be List. I'm having a hard time figuring out things like: How to get the column header box to sit directly atop invoice line 1 (instead of hovering one pixel above it) How to size and position vertical line segments in the Body to create a long, unbroken vertical line when printed (or to not disappear entirely!) How to get horizontal lines between lin…
-
- 3 replies
- 904 views
-
-
I wonder if someone can give me some hint on solving the following problem: For simplicity, I use the following simple scheme. I have an item table with several categories of products, product names of each category, product ID and cost (see Item layout); and a customer layout where I use the conditional value list technique to isolate one category of related items and then choose the correct item from the isolated category. I use the Lookup field option for product ID and cost. Somehow, each time I choose the proper item in a category, only the product ID and cost for the first item of the isolated category is shown. The product ID & cost fields would not show t…
-
- 1 reply
- 814 views
-
-
Hi All Can anyone help me. I want to divide a number (in another field) into 2 new fields. One holding the part of the number before the decimal and another containing only the 2 digits after the decimal. Have no problem with the first part but if I use a calculation with Round (number; precision) to get the part after the decimal it works fine as long as the number doesn't end with .00 When the number ends with .00 it takes the to digits before the decimalpoint instead of the to zeros after the decimalpoint... example This works number = 1025.95 firste part ok = 1025 second part ok = 95 This doesn't number = 1025.00 first pa…
-
- 10 replies
- 3k views
-
-
Hello all, I'm trying to create a purchasing data base for my company. Our company is still creating purchase orders on a TYPEWRITER. Desperately trying to bring us to the 20th century. Anyway, All purchases need to start with a standard Purchase order. I have everything how I want it except I'm having trouble with the description field. Our purchase orders typically only need 1 or 2 lines of input information to describe what is expected from our vendor, but sometimes we have someone do very detailed work and the description field may have 20 lines of detail. What I need, if possible, is a way to have the description field expand and contract to the requ…
-
- 7 replies
- 968 views
-
-
There is a dark horizontal line between my Header and Body that extends in definately to the right of the layout. It does not appear in Layout Mode. I would like to get rid of it. Any suggestions? Thanks!
-
- 2 replies
- 1.3k views
-
-
Basically i want to go through records waiting approx 10 seconds before fading to white then fading to the next record.. i.e. a slide show?.. is this possible at all or should i just build a seperate application in vb or something and sych the data? Cheers, i know its a bit of a wierd question for a database
-
- 8 replies
- 2.1k views
-
-
Hello everyone, i have seen that in the bps 1.0 instead of the menu option insert new record it said insert new contact Where can i change this? Also in the first main menu the menu bars are changed with other dropdown menu's instead of the standard filemaker menu's where can i do this? thx in advance
-
- 1 reply
- 1.5k views
-
-
In tweaking an invoice layout, I seem to have introduced a quirk in the way row #1 of the LineItems portal appears in Preview mode. The value in column 1, normally centered, is shifted to the right a quarter-inch and truncated. The value in column 4 is missing. The other values in row 1 are fine. Rows 2 and up are formatted correctly. The problem doesn't appear in Browse mode, nor does it appear when the document is actually printed. But the Preview looks wrong. Can anyone suggest what might cause this? Thanks, Chap
-
- 3 replies
- 853 views
-
-
hello all, how can i stop the scrolling of record with my mousescrolbar? And can i turn scroll of a window? thx in advance
-
- 0 replies
- 678 views
-
-
:) I have a portal that is based on a 1-1 relationship and I allow the user to create records in the portal, my problem is that everytime the user clicks out of the portal and goes back in there is a new empty line/record at the top of the portal. Which means her data that displays keeps moving down further and further. How can I stop this from happening?
-
- 4 replies
- 1k views
-
-
I hope you guys can help me. Here is my problem. I have created a form that collects information for the following: number of hours billed, number of hours worked, the pay rate, the amount and the month the information is recorded. I would like to create a report that would allow me to show the total amount of money spent for each month. For example Month Total Spent Running Total May $29,26201 $29,262.01 June $29,720.97 $68,982.98 July $49,910.21 $118,893.19 Creating the summary for a running total I can do. However, I am having a very hard time getting all of the months to add up and produce a tota…
-
- 7 replies
- 1k views
-
-
I've searched the forum and can't find this particular portal filtering question. I'm not sure there's a solution, but I figured I'd try. I'm trying to create a layout which will list all related records in a portal or filter them by "last name". I have included a screen shot of my current layout which is currently filtering by last name. Settng up a relationship to filter by last name is easy. So is setting up a relationship to display all records. I'm tryng to figure out a way to do both. The box next to "search by last name" is a global text field. I have a relationship from the "transaction" record (in the portal) to this global. The transaction side …
-
- 5 replies
- 960 views
-
-
I am wondering if I am completely off base here… I have a layout for People (that is the table) and the related table is Position (Job Assignment) One person can have more than 1 active job at the same time (ie half time receptionist, half time file clerk). However this is not the norm…. So how would I set up the data entry layout for that? Would I use portals? What I had envisioned is a normal data entry layout- that the user tabs from field to field with a portal window on the bottom that holds the data the user fills in (either on a commit or dynamically). That way, if the user has to fill in 2 half time jobs for Jane Doe, then the user can see the ot…
-
- 5 replies
- 746 views
-
-
Are all value lists effective as far as printing reports? For example, are Pop Ups just as reliable for reports as Drop Down menus? Is one better than the other? I have a large number of reports to print in the near future, so any comments on this topic would be appreciated! Thanks! Alisun
-
- 5 replies
- 805 views
-
-
Hello, I am new to Filemaker and this might be a stupid question and I am sorry if it has been asked before, but I googled and googled and cannot find an answer. My question is how can you separate the layout popup-menu so that when you click on the layout popup-menu instead of scrolling up and down and up down due to the tremendous forms is there a way to divide the layout popup-menu into two columns or more. It would be a great help if it can be done because time would not be wasted on something so trivial as scrolling all the way down to get to the last form. Any tips would be great!
-
- 1 reply
- 763 views
-
-
Anyone know how to add fields to an existing portal? When one initially creates a new portal, after the Portal Setup dialogue box, we get the Add Fields box. But once the portal is set-up, I can't find a way to get back to that Add Fields box. Thanks in advance for any advice!
-
- 6 replies
- 9.1k views
-
-
I know there's been plenty of discussion about fonts looking bad in cross-platform databases, but: I'm on a Mac (OS X 10.4.6), and ever since FM 6.0, almost all fonts look just horrific in FileMaker, especially if they're any smaller than 12 points. This is true even with the ones you'd think would be pretty universal, like Times or Helvetica. I don't have this problem with other applications. I'm not crazy about Verdana, but it seems to be the least-screwed-up sans-serif font I can use. Any suggestions -- like, is there a setting in FileMaker that I should have known about by now? Thanks. Gregg
-
- 2 replies
- 882 views
-
-
Hello, I want to create a portal based upon a field which combines two fields. Example: Client nr: 1000 (Unique ID) Status: 1 (Done) Combined field: 10001 (Client nr & status) Database 1 -> has the field "Combined field" Database 2 -> has the field "Combined field" Now I create the portal, but this portal only shows one record instead of all records basesed upon the field "Combined field" It is probably a indexing problem! Question: Is there a way to make my situation mentioned above work? OR (even better) Is there a way to pull once all the records based on the "combined field" into a specified field? Looki…
-
- 6 replies
- 838 views
-
-
The attached file contains a simple example of a portal that displays information for a selected User. The problem is that I want to display results only for a range of dates contained in that User's base record (the date pair is different for each user and can be changed when needed). I've tried two different methods and both fell short of what I'm trying to achieve. Any suggestions of a straightforward method will be appreciated. Thanks in advance. RangeOfDates.fp7.ZIP
-
- 9 replies
- 1.1k views
-
-
How do I add an icon to a button? i.e. The microscope icon to a button set to find records. Where are these icons within the program? I'd like to add the old set from a previous version of FM.
-
- 3 replies
- 1.6k views
-
-
I have an existing contacts database for an alumni association, and I would like to create several catagories for the contacts. The primary one will be Alumnus of course, but I would also like to be able to change it to Friend or Family. So I am assuming that this should not therefore be a global text field. And I would like to populate the current records with the default value of Alumnus. How can I do this?
-
- 4 replies
- 789 views
-
-
Out of curiosity, I've built a calendar (layout is in a different table). Built like this: Main Layout has 42 fields in 42 portals, each with a unique verifier. 2nd layout contiains information about each day/date and a unique verifier that links the two together. in 2nd layout, there is a relationship to an entirely different DB that pulls Sales Orders (just the order numbers) by date and lists all the SO's in a portal. Is it possible to pull that portal information into the portals? It goes like this: Calendar Day possible 1 of 42, uniqueID links to actual calendar days layed out in 365 records via uniqueID. Each record of the 365 has it's o…
-
- 3 replies
- 1.1k views
-
-
Hi All, I have a database which I have some of the field which I have a script which will cut and paste into a portal, but for some reason when I try to have the next record (First_Name2) at the next row, it is not doing what I want because it is replacing the first row. Any help will be appreciated. Here is the script that I have: Go To Portal Row [select;First] Go To Field[Main::First_Name1] Cut[select; Main::First_Name1] Go To Field[Presenters::First_Name1] Paste[select; Presenters::First_Name1] Go To Portal Row[Next] Go To Field[Main::First_Name2] Cut[select; Main::First_Name2] Go To Field[Presenters::First_Name2] Paste[select; Presente…
-
- 1 reply
- 651 views
-
-
I'm trying to learn more advanced FileMaker, but can't find what << name>> means. In several templates there are references to <> <> and similar. These are clearly field names, but I can't find any information in Help, programming books, or the FileMaker knowledge base about what the << name >> means and how to program these things. Please help.
-
- 3 replies
- 1.1k views
-
-
I'm stumped on this one. My portal shows related records for some entries, but not for others. First layout lists Customers (and some details) Clicking on a button takes you to the second layout which correctly gives all the details of that customer (same table). The second layout also has a portal to show the related records from a table listing documents. It works for some customers, and not others. I've ensured that the indexed field entries are correct (they are even automatically entered !) but they don't show up. Any ideas, please ?
-
- 3 replies
- 698 views
-
-
As a complete FM beginner I have already become stuck. I have a layout that gives me a list of a school house. I want to count the number of boys (M) and the number of girls (F) and the total number of students in that 'Found' group. I can't find a way to do that. 'Sex' is a field that is included and populated. I hope that all makes sense? Please help Peter.in.th
-
- 4 replies
- 895 views
-
-
I´m finding one of the templates quite adequatI’m finding one of the templates quite adequate, it has most of the features I require although not all of them. I’m new to FM8 and am seeking for some assistance. The template is labelled “Email Campaign Management” and can be found in the directory “templates/Education – Administration/”. The additional features I seek are the following: (1)The possibility to add the “Notes”-information to an e-mail template, I’ve been trying to solve this myself by duplicating and modifying an existing “button”, eg. “Last Name”, without success. I can’t understand why I fail to do this?! Any clues? (2)To add multiple recipien…
-
- 1 reply
- 1.1k views
-
-
I have a database that I'm going to distribute as a runtime solution. I want the user's information to appear in the header of every report. This information is really unrelated to the rest of the data in the database. The reports are pre-built for the end user, so database fields were the way I was going to go, not text labels. I've tried using a table to hold the user's information, but the report layout does not want to display these fields because the table is unrelated to the data being displayed in the body. How do I get the information from an unrelated table to appear in a report OR just any way to accomplish this?
-
- 3 replies
- 731 views
-
-
-
I want to put together a basic runtime for a group of friends who have a mixture of Mac and Windows. I have decided to work on a screen resolution of 800x600 at the moment but I'm not sure how that reflects in terms of layout size, given that there are the dimensions of the menu bar, status bar, borders, scroll bars etc to take into account. Can someone give me an idea of what layout dimensions I should aim for to avoid "overflow" problems on either Mac or Windows? The development will be on a Mac. Cheers, Muzz
-
- 6 replies
- 1.2k views
-
-
how do you edit value lists based on current field? I have some old values in list that i can't get rid of.
-
- 2 replies
- 721 views
-
-
I have set up a field with 2 options for radio buttons. I used a values list of "authorized" and "potential" for choices. The field was defined as text and then in format / set controls I chose radio buttons. When I click where the radio button should be it shows up but can't be selected and then disappears when I let go of the mouse. I've tried setting this up as a check box and no visible boxes there either. tia for help.
-
- 4 replies
- 768 views
-
-
Hi, I am a novice with FM so if this is painfully obvious please be merciful. I have bought and read the FM8 missing manual and am still a bit hazy about how to proceed with the syntax for a tool tip of this type. I am creating a workout database for my home. I have fields that contain the Exercise and the Method used to execute the exercise. Flat Bench would be an example of an Exercise Barbell or dumbbell would be examples of a Method. Now I have up to 6 Exercises and 6 Methods for each workout. (Exercise 1 -6 and Method 1 -6) I want a tooltip that would find the last workout I did with the selected Exercise and Method and tell me how much weight/rep…
-
- 16 replies
- 2.7k views
-
-
Hello All, I was wondering if this would be possible. I have 3 different text fields. Field 1 (Peanutbutter) Field 2 (Jelly) Field 3 (Toast) Is there a way to make a field which would contain the text of the other 3 fields making a Field 4 (Peanutbutter Jelly Toast) ? Please Advise, much appreciated!
-
- 2 replies
- 626 views
-
-
I have a value list that is displayed in a portal. This value list displays prices. However If I change the prices in the other table it changes the values on all the records that have already been created. I want to be able to change the price but only affect the records that are created from then on. If someone could help, that would be great Jeff England
-
- 3 replies
- 764 views
-
-
Pardon if this is a silly question, but I've searched the forums, consulted my "Missing Manual" book and Googled the question, but can't seem to find an answer. Once we've created a button and assigned a script to it, is it possible to go back and edit the text on the button? It seems like that option should be available in the "Button Setup" dialogue box, but I don't see it. I'm using FileMaker Pro 8 Advanced on Mac OS X. Thanks in advance for any help!
-
- 3 replies
- 706 views
-
-
I had a request to have a print form show the value of a checkbox's 'Other...' choice, and it got me thinking about what the best way to do this actually is. For example, if I have a list of checkbox choices for cars, most of which are available as checkbox choices, but where there may be some that are not available in the value list, so we allow an 'Other...' choice where the user can manually make an entry. Now we want to see what that Other value is when the form is printed. The first interesting method I've though of, is using a custom function to make an Other calc field, that only shows the values not in the original value list of choices. A second…
-
- 4 replies
- 1k views
-
-
I have a very simple database with one record for each hiking trail. I'd like to have a drop-down list on my layout that would list all of the "name" fields I have. When I select a particular name, it would go to that record. Of course when I add a new record, the list must be updated. Not sure what I did before but I got a dropdown list, but when I selected the name it just changed the contents of the name field of the current record to the one I chose instead of actually going to that record. I'm sure this is very simple but it's too tough for me. Thanks
-
- 3 replies
- 762 views
-
-
Dear Friend I had made relation between Detail Record (A.fm5) and Portal Record (B.fm5) and i made button that alowed user see detail record from Portal. Because of long list of record in portal, how can I display or select record from detail record. For example if I click "JASON" in portal other windows will appear to show detail of "JASON" but when I close deatil windows it doesn't go to "JASON" again but go to first row. How can I direct to "JASON" row in portal when I close detail record ? Thank for your kind attention, I do really need an answer. Cheers Ben
-
- 2 replies
- 757 views
-
-
Hi, I've learnt that @@ can be used to track the record number in a portal. However, the same @@ in the related table will give the current record number out of the whole table, and not just the current record number of the related records. Is there a function or short cut that I can use, that will show current record number from only related records? thanks indy
-
- 5 replies
- 1.1k views
-
-
Appoligies for the complete NOOB question but I am realy struggling with reports at the moment. Basicaly - I have a Matters table, Clients table and Proprties table. I am trying to create a report (layout?) on a matter(showing the matter details), then list all of the associated clients to the matter (many-many relationship) and then all of the associated properties to the matter (seperate many-many relationship) On the data entry layout I use two portals to display these, but for a report I'm stuck and cannot understand the way the summary parts work??? (eg I dont want to sum anything - just display multiple clients per matter and multiple properties per …
-
- 2 replies
- 667 views
-
-
I've attached an example of a problem I'm having navigating through records in a portal with scripting. The go to to "first" and "last" scripts work, but not the "next" and "previous" scripts. Any suggestions? Thank you very much Jason PortalNav.fp7.zip
-
- 7 replies
- 1.2k views
-
-
Hi all, I am a beginner at this so if this is deemed a very simple question then i can only apologise! I have made a layout that is a standardised letter that has fields for title, name and address. When i preview the letter. it shows the title, name and address but they have a big gap between the fields. The fields are the same size as the box they are made in on the layout page. How do i get the fields to just say 'Mr A Smith' rather than the current 'Mr A Smith' I the words to appear but ignore the size of the field box and just have a space in between the words. I have tried to find the section in the instructions but don't kn…
-
- 3 replies
- 737 views
-
-
I would like to lock a field on a particular layout such that it can be viewed but not changed on that layout. The same field must be entered in the same record, but in a different (previous) layout. Any suggestions? Thank you, Jason
-
- 2 replies
- 773 views
-
-
I'm using filemaker 8 to graph the number of occupants per floor in a building.. i'd like to prepare a report that shows a graphic representation of the % occupied per occupant on each floor.. along with the occupants name ... could someone point me in the right direction ? i'd like the report to look something like this: | smith (3) | jones (2) | frank (5) | paul (4) and have that repeated for each floor of the building, showing the number of units occupied by each person
-
- 2 replies
- 828 views
-
-
I am trying to filter a portal and having problems. I have tables of contacts, donations and donation detail. In the donation detail table the line items can be broken down to an ID field that is used to related to many other tables. Some of my contacts are builders who are, of course, building houses. Each house has a unique ID. This is the same ID used in the donation detail ID field. I need to link these ID's thru a portal. I have the inital files linked by contact ID so the builders are related to any donations by them. I created a second table occurance linking just the House ID to the donation detail ID. The problem is the table will list all donati…
-
- 0 replies
- 702 views
-
-
I've attached a demo file showing how I've tried to do alternating row colors in list view. I want uc_RowBackground to completely fill each row with the calculated color, but I am unable to get rid of a transparent 1-pixel border. In the demo file, this is where you see the pale purple background peeking through around the edges of the alternating gray and peach boxes. I want for gray and peach to be juxtaposed seamlessly. Can anyone spot what I'm doing wrong? Thanks, Chap ListView.fp7.zip
-
- 12 replies
- 4.5k views
-
-
I defined a lay out for data entry by key board. However, filemaker won't let me enter data. I am in browse mode and created three records. When I click into the fields they do not get activated. Using tab does not help either. There's probably a simple problem but as I am an ignorant beginner I have not been able to figure out what I am doing wrong. Thanks a lot for your help. Leviathan__s_Database.fp7.zip
-
- 5 replies
- 917 views
-
-
I would like the tab title to become bold or change color if a test is true (such as a field on the tab's layout contains data). Any idea how to do this? I want the tab to stand out to the user if the layout relating to the tab has values other than empty... Thanks :
-
- 5 replies
- 1.6k views
-
-
Can custom menus be assigned across an entire file based on the privilege set? I would like the full menu as an administrator BUT abbreviated custom menu for the end-user based on their privilege set.
-
- 1 reply
- 1.4k views
-
-
I'm creating a database that uses a value list from a table. The user is allowed to add and remove values from this table. I have a checkbox that toggles an "Active" boolean for that entry. This Value List/database table is used for data entry later in another section of the database as a drop-down list. How do I get this drop-down value list to display only the values that are boolean "Active" as described above? I've tried a self-referencing as described in the FMP help, by adding a second boolean field that is automatically filled with a "1". No luck so far.
-
- 2 replies
- 963 views
-
-
Can I use a merge field with a funtion like GETFIELD("KON"+$mes) so it act as another field ? if not can I use another way to acomplish that ?
-
- 1 reply
- 837 views
-
-
I have a portal that allos me to see all of our jobs that printined on a particular press on a particular day. It work great. I want to have another portal that shows me all the jobs that shipped on a particular day. Do these need to be in the same layout?
-
- 1 reply
- 722 views
-
-
Hello, I need to initially set up a drop down box to display the choice of 2 named lists(named a or (lists are in F19.F20) then place that selection as a drop down box in a separate location (f1) thanks
-
- 0 replies
- 852 views
-
-
Hi, New to FM. I have been working on a new db for about a week. I thought I was finished, just doing a little testing. Now as of today, in layout mode, my fields are displaying some weird information. Such as: "Powerfull Scripts", "Customizable" and on some fields it is showing input values from my value lists. Not one field is displaying the name I assigned it. In browse mode, everything seems fine. I am little concerned about using my db. Larry
-
- 2 replies
- 774 views
-
-
I am looking to create a layout that will display information to clients in full screen, with a forwards and back button, so it looks more like Powerpoint than Filemaker. They will not have control over moving between pages, so there is no issue with how the records are sorted prior to display, or restricting them from accessing parts of the database. As I understand it if I use Kiosk mode that applies to all users, is there a way to achive this?
-
- 4 replies
- 1.1k views
-
-
When I have the 'view object size box' open if I key in 0 pixels from the top and 0 pixels from the left it defaults to 12 from the top and 17 from the left. This is not a problem cos the object appears to go right into the top left hand corner but I am just curious as to why I cannot get it to accept a '0' TIA Phil
-
- 2 replies
- 725 views
-
-
I used to have data into a global field when using FMP 8 networked, but when I moved to FMP 8 Server the same solution is not working, the global field retains the data only while the solution is open, after quiting and reopening the updated data dissapears only from global fileds. It is supposed to work like that ? any suggestion to overcome that situation ?
-
- 2 replies
- 1.1k views
-
-
Is it possible to make a value list with script functions as the choices? Or calculations? I would like to make a drop-down that allows a user to choose which layout s/he wants to go to (without having to additionally click a "Go" button after choosing.) Thnx!
-
- 2 replies
- 1k views
-
-
I want a button whose label and function change depending on the data: specifically, it goes from "Invalid" to "Make Valid", depending on and setting/emptying a timestamp field indicating when the data was known to be invalid. Sounded like a job for a calculation field. So I made one that would evaluate to "Invalid" or "Make Valid" depending on my criteria, and planned to make the button text a merge of this field, and then put more or less the same logic in a script to determine what to do when it was clicked. Well, when I put the merge field on the button, it does work. However, the name of the field is so long that Layout mode refuses to let me size the butto…
-
- 2 replies
- 755 views
-
-
Ok, I have a tab control with 4 tabs, 2 tabs have portals on them. I would like the tab control to slide when printed. Is there a trick to this? I have tried going into set sliding/printing of the tab control, and the portals, but whhen I print, the portal slides, but not the tab control. Any ideas?
-
- 2 replies
- 1.4k views
-
-
Anyone can explain why Nth record stop calculate an unstore field with the following: Case(Get ( RecordNumber )=1;GetNthRecord ( num; Get ( RecordNumber ));num+ GetNthRecord ( SumStore; Get ( RecordNumber ) - 1) ) Thank
-
- 8 replies
- 1.3k views
-
-
Hi there I have a kind of "home page" on my database containing a single record, and the layout has a collection of portals showing me the status of jobs, invoices etc. at a glance. The problem is that one of them doesn't work and I can't figure out why. It's the portal showing me all unpaid invoices. Here's how it works (or in this case, doesn't) The [color:red]INVOICES table has a calculation field called [color:red]STATUS which checks if anything is entered into the [color:red]DATE PAID field, then displays the colour coded invoice status accordingly, like this: [color:brown]Case ( not IsEmpty ( Date paid ) ; TextColor ( "Paid" ; RGB (0;160;0)…
-
- 4 replies
- 814 views
-
-
I am trying to set up portal Navigation as described by Ray Cologon. After many hours of trying to get this to work I have "Most" of the problems solved. My main problem remaining is that when I click on the portal row the GTRR does not take me to the record. There is a CF as follows: GetNthRecord (Field; StartValue ) & If(IsValid(GetNthRecord (Field; StartValue + 1)); ¶ & GetValueSet(Field; StartValue + 1)) When I tried setting this up in a script to see where the problem was I get a seven digit number for RecordNumber?? so if I change it to the proper record number it goes to the correct record in the layout. Somehow I've got this …
-
- 41 replies
- 6.1k views
-
-
Just wondering if I have my understanding of how conditional formatting using TextColor works in regards to dates correct or not. What I want to do is be able to format the color of a date (red if greater then due date). That said, I also want to make use of FM's date format in layouts. For instance, in some places I need to just show day/month and not year. Can I have both and still only use one calculation field? It seems that if my calculation result is set to text I have the color but not the ability to format the date in the layout. If it is set to calculate a date I have the layout format options but the color doesn't show. Thanks, Br…
-
- 4 replies
- 1.3k views
-
-
I'm a new to filemaker and am using an older version (3) I'm trying to make a layout that expands a text box when the box becomes full. It also needs to push the content under the text box down so all information is viewable.
-
- 2 replies
- 918 views
-
-
Hello... I am trying to compare the old database to the new one I am developing. In the old database, there are many many value lists and I would like to print them out or export them or something so that I can logically figure out if they are needed in the new database. Any way to do that in plain ole Filemaker (not Advanced)? Thanks in advance
-
- 3 replies
- 907 views
-
-
Alriiight...I've been working at getting a Percent of Total field to display subtotals as percentages of the final total (hence the fieldname). To derive this I have two Summary fields: SumTotalProblems and SumPerProblems. The former is a Count of the Primary Key field (ID) and the latter is a Fraction of Total of the Primary Key field (formatted as a percentage in the layout). The weirdness sets in when I run the report and sort based on the break field. I've included a screenshot of what happens and another of the table structure. Basically, it seems to calculate the value appropriately for 1/3 of my sample data. Does anyone know why this is happening? …
-
- 0 replies
- 960 views
-
-
Hello: I have a database set up for a client-top is basically contact info; bottom I have a portal that connects to another database which has notes on the client, by date. Each client has multiple records, based on project #. She wants a report to print up with status notes. I am having trouble setting up a report to ONLY show the last note added. I can sort the notes, to show the last note added, when you look at it in the regular view, however in the report view, it shows all of them, just in order of date. I only want to show the last note, not all, so when she prints up a status for a client it shows the most recent note for each project. Does this make s…
-
- 1 reply
- 991 views
-
Recently Browsing 0
- No registered users viewing this page.