FileMaker Interface Features
-
Newbie-ish Question: So I'm getting ready to start cleaning up my application. I've come up with a color scheme/left-hand navigation pane/"main area" coloration etc. What's the best way to make it uniform on all/most of my layouts? I estimate that I have about a 12 -15 different layouts that the user will see - all of which I want to have same base "look amd feel". Thanks in advance for your input. -Mark
-
- 8 replies
- 1.2k views
-
-
How much overhead is involved in creating new instances of tables in the relationship graph and using them in portals? The reason I'm asking is that I have a month display in which I want to use 31 separate portals. In the relationship graph I made 31 serperate instances of a particular table which are accessed by a table with a date and 30 unstored calcs that increment that date (eg. date1 = date + 1, date2 = date + 2). How does filemaker store the 31 instances of what is basically the same data in the graph? There wouldn't be 31 seperate copies of the same data stored in the file right?
-
- 2 replies
- 684 views
-
-
Is there any way to show multiple records horizontally in a portal, instead of vertically? I have two tables: one of music SCORES, and one of the individual PAGES in each score. Each score has a different number of pages, 2-10. I have thumbnail images of each page in a container field in the PAGES table. This is related to the SCORES table through the unique score number, which both tables share. The PAGES thumbnail container field is displayed in a portal in the SCORES table. Thus, each record in the SCORES table displays only the corresponding pages in the score. However, these are displayed vertically. It would be much more elegant to display the mulit…
-
- 3 replies
- 1.1k views
-
-
I have layouts with a portal on the left and related fields on the right for viewing creating editing and deleting records within the table There are 3 table occurences involved Zones A, B and C... all are based on the same table i'e Zones The layout is based on Zones B with a global field relationship to Zones A (Zones::g_ID = Zones B::g_id) . This shows all records in the table in a portal based on Zones A. Fields used in the layout but not within the portal are from Zones C which is related by the unique value ID field (Zones B::g_ID= Zones C::ID ) This allows me to click on any record in the portal and populate the fields in the layout... so far…
-
- 0 replies
- 644 views
-
-
I have text entries in a portal how would i add the number of entries together for only one record
-
- 2 replies
- 623 views
-
-
I have a DB listing shirt sizes and pants size for 400 records. The sizes are controlled by a value list using radio buttons. I am trying to do a sub summary showing how many of each size I need. When I do a sub summary by shirts and pants I get the following breakdown. Shirts: YS 4 YM 6 but then I get the following breakdown for the pants: Pants: YS 4 YS 3 YM 3 I want the pants to display as YS 7 YM 3. I know that it has to do with my sort order but is there any way to sort by two fields consecutively?
-
- 3 replies
- 820 views
-
-
I have a client that has an older db that uses repeating fields. For phase 1 of the project, I am not quite ready to remove them. He sells to retail and wholesale clients and I'd like to relate his inventory file which contains a retail and wholesale price to his invoicing system. But I can't figure out how to displace the right price based on where his customer is a retail or wholesale customer. Any thoughts on approach. Remember, his invoices are now using repeating fields and not portals with a separate invoice line item db.
-
- 6 replies
- 721 views
-
-
I have a related file that builds a value list fields 'attendance_code' = A-Absent AM... 'debit' = .5 I use the field 'attendance_code' (alpha) for selection purposes but need the related field 'debit' (numeric)to be used in calculating a number of fields using the 'attendance_code VL'. Perhaps this should be in Calculations but I think I am just stuck getting 'attendance_code' = 'debit' thanks!
-
- 9 replies
- 1.3k views
-
-
I created a line items report and all was great, until I went back to add a field, now my report is not subsummarizing how I created it with the report wizard. I didn't change any of my page breaks, so why did my report go from calculating my subsummary totals, to not showing any totals and listing all the records one after another? The field I added was in the header and not in the body..not only that, but another report began doing the same thing and I didn't even touch that one, If you change a layout does it affect your other layouts as well??? All ideas are welcome...thank you!!
-
- 8 replies
- 916 views
-
-
hi there... been a while, here is what i am having truble with. i have a field that is a value list (builders names). i have another field that is called "sites" i have 3 different value lists called different "builders names" in each one has about 3 to 5 different "site names". is there a way to have the value list for "sites" change as the name in "builders name" changes? any help would be great.
-
- 0 replies
- 694 views
-
-
I have two related tables, PO_Job and Job. I want to produce, in a portal, a list of all jobs that do not have a relationship to PO_Job. So, I created a value list, Assigned Jobs, of all the Job keys from PO_Job. In another table, Preferences, I have a global field, AssignedJobKeys, that is a calculation: ValueListItems ( Get ( FileName ) ; "Assigned Jobs" ). From Preferences I create a relationship to Jobs: AssignedJobKeys (not equal) JobKey. I then have a layout based on Preferences with a portal displaying the jobs. After creating the calculation, the field is filled in correctly, but as I create entries in the PO_Job table, the calculation in …
-
- 0 replies
- 872 views
-
-
Hello,say i have a list of numbers in a portal how would i add them together
-
- 1 reply
- 714 views
-
-
I have a portal with a field filled in by pop up list. eg. can choose entry a, entry b, entry c etc. Is there a way to choose entry a then add next to it entry b, then add entry c so that the field ends up as "entry a entry b entry c". I tried to place that data on the layout and cut and paste but it won't allow. Any suggestions?
-
- 5 replies
- 1.2k views
-
-
I have a custom label layout, so the layout's size set at a size that will allow me to print 5 labels out onto the label. However, whenever I add a new field to the table that the layout uses, FM7 will automatally add the field to the end of the label, which expands the size of my label and throws off the printing for the label. I realize I can just switch to another layout when I'm editing the table, but I'm curious to see if anyone knows if there's a way to either lock the layout, or have fm7 not automatically add the field to the end of the layout. Thanks
-
- 4 replies
- 972 views
-
-
I'd like to get a text summary of the contents of a field from related records in another table. FM does this all the time internally when you ask it to create a dynamic value list from related records. But I can't figure out how to set up a calculation or summary that outputs a text list of one field from another table, with entries separated by line returns. All the summary functions have numerical output. I could use a portal if all I wanted to do was to view the results, but I'd like to able to manipulate the results using text functions.
-
- 20 replies
- 2k views
-
-
Is there any way to use a value list to populate a row in a portal? Consider this scenario of a simple sales tracking database .... Database A contains a list called item numbers. Database B contains a layout with a portal of Table C, call this layout order entry Database C contains a list of individual orders. In db B I have a layout displaying all of a customers orders, using a portal to display those rows. I would like to have a value list (menu style) of all the item numbers and use that value list to help automate adding an order to db C. It would be great if the value list could be contained in the portal itself, simply just be one of the fields. …
-
- 0 replies
- 695 views
-
-
i posted earlier on this list asking if i should be using a portal w/a realated file in my situation, or if i should just be using repeating fields in my master file to list all the donations we receive. i will want to summaries of this info and somone posted back to me saying portals were the way to go, but now i'm not so sure. here's the situation: i have a master file of individuals w/contact info and lost of other details about them. i wanted a nifty little box w/a scrollbar to list their donations as they come in over the years but the box only needs to show a few rows and then you can scroll down the view the rest as they come in. so it seemed a por…
-
- 2 replies
- 646 views
-
-
i'm new to working with relationships and portals in FileMaker. I am creating a portal to display donations received towards our capital campaign in my master file. i have a related file with all the donation info and in it is a field that lists the level of campaign they are participating in. It is formated as a pop-up value list in the related file but not in the Master file. what do i need to do to make that happen? in addition, the fields in the related file are all repeating fields. is that the correct thing to do when using a portal? thanks for your help!!
-
- 0 replies
- 677 views
-
-
Hi I have a portal of table 1 in table 2 that have a 2 fields critaria relationship. That work fine. Now, i just want that portal to make appear only the records that are in "Category A"(which is a field that have a Custom values-list) So, filtered-out, all others records that are in others categories. How can I make a portal filtered some records ? keep in mind that i whant to still use the basic relationship for others layout / view. thx guy
-
- 13 replies
- 1.3k views
-
-
I'm sure this has probably been asked somewhere in the recent past, but.. Is there a quick way to make a pop up list field LOOK as if it has a pop up list? I mean all FM does is add a silly drop shadow for a menu, but for a list it does nothing. I've seen an example file with 'drop down boxes' that look like those on a web page. I don't know how they did it, though. Any ideas?
-
- 1 reply
- 704 views
-
-
Simple task but I'm not sure how to make it all happen. First is a table of items, contains fields such as item number, item description, item cost. Second is a table of orders, an order entry form if you will. On the order entry page I generate a pop-up menu value list of the item numbers from the first table. The idea here is to click on the popup menu, pick an item by number, then fill in a few other fields to complete the entry for this order. My question is this ... how do I fill in the other fields on the order page? The pop-up list just fills in the one field, how do I pull the rest of the item data over to the order page based on choosing the item n…
-
- 1 reply
- 709 views
-
-
on my layout I have a portal to input up to 10 records, which works perfectly on my local machine. When it is over IWP however, the portal only allows me to input 1 record at a time. If I hit the submit button and then go back and edit it again I can put in one more. Is there any way to be able to type in all 10 records without submitting them one by one? Thanks
-
- 0 replies
- 1k views
-
-
a couple of things... 1. I have a portal which displays line items in my jobsheet/invoice layout in this layout I would like to show a total for the listed line items - how do I do this? I have tried to do a summary but it doesn't offer the line items total - am I missing something? 2. If I want to delete a line I would like to just delete the quantity field and for this to automatically delete all the info attached to this quantity - how do I set up this? thanks in advance
-
- 3 replies
- 807 views
-
-
I am developing a database designed to contain examination questions. A growing issue is the need to accommodate several tiers of questions, 3 tiers, along with related answers/scoring keys. The organisation requires that all are visible on the one page (otherwise I would make another layout linking back to this using scripts), the 'Question Bank' encompases the group of records, however the 'Question' is the core table for this layout. 1. Question Bank (2) 2. Questions (2.1...) Question Answers Marks 3. Subquestions (2.1.1....) Subquestion Answers Marks As such I was hoping to use a portal within a portal to relate subanswers t…
-
- 0 replies
- 683 views
-
-
Ok, I have a DB for a sports league. 2 realted tables-1st table contains team name, captain name, etc and the 2nd contains all the players and their id numbers. They are related by an index field. I have it set up now so you can choose the team name from a drop-down menu and all the info and players are displayed via a portal...but I need to be able to display 2 teams that I choose from the menus and their respective information side by side on the same layout. I can't seem to find a direct way to do this, can anyone help. Much appreciated.
-
- 6 replies
- 1k views
-
-
The latest FM update now pastes styled text (with font, size, etc.) into text fields along with text. Unfortunately, I almost never want to preserve font and text style when I paste stuff into a database. How can I set up a layout to disregard any font or text style and use the field's defaults settings? Alternatively, how can I strip out font and text style or execute the paste command so that font and text style don't get into the database in the first place? Thx, Chuck Henebry
-
- 2 replies
- 785 views
-
-
After I have the script perform a Find, I need to sort all the found records in an order that varies 4 different ways. Each record is in a specific category (1-4) and has it's own rating (1-5). Depending on the category number, I need it to sort records by rating, but in different orders. Example: Category 1 = Sort 1, 2, 3, 4, 5; Category 4 = Sort 5, 3, 1, 2, 4. I've tried creating a value list from a field in which I enter the order I want (to use as custom sort order), but the value list just puts the numbers from the field in numerical order. Is there any way to do this? And if not in FMP6, could I do it in 7?
-
- 2 replies
- 614 views
-
-
Anyone know what to do...I have a pop up list with client id numbers in an invoice which displays a portal of line items I have entered a dummy record but when I go New Record and select the same client ID number the portal fills with the data from the previous entry - what am I doing wrong?
-
- 2 replies
- 661 views
-
-
I have started a layout of family contacts. Does anyone know if there is a premade template out there that I can use for a family tree? I'd like to keep it all in FMP. Thanks! [email protected]
-
- 1 reply
- 882 views
-
-
Been searching posts to accomplish switching layouts by PopupMenu...Am I asking alot to be able to have a one-click selection, how could this not be a feature of FMP?...So does someone have an example (to download) of a function, script, script parameter whatever so that I (a person trying to understand FMP) can understand. For clarity: Need a PopUpMenu that has the names of the layouts that the person clicks once and they are instantly brought to that layout. This is a great forum thanks to all that take the time!
-
- 10 replies
- 1.2k views
-
-
Hello I'm not sure if this is the right group to be posting to, so apologies if it isn't. I have a file called Estimate and I want to be able to display a pop-up menu of all the estimate dates for the active street address line. Can anyone tell me if this is possible and if so where do I begin? I suppose a value list would be required but I'm not sure if I need to do a find on the street address line first to get all the estimate dates and then I don't know how to get them into a value list. Any help would be most appreciated. Many thanks eSBee
-
- 19 replies
- 1.6k views
-
-
Hi. I have a table (A) with >100 fields, which is formatted with a custom layout. I would like to create a different table ( using a subset of the fields from table A with the same layout. Is there a way to duplicate an entire table, then rename and edit it? Thanks, Gwen F.
-
- 4 replies
- 1.1k views
-
-
I have a layout set up with two portal windows formated the way I would like the records displayed. Both using a self-relationship, date=:date. At the top of the layout I have the date field displayed so that in find mode I can query a date and have all related records appear in the portals. This works fine the trouble I am having is when I want to print. If there are 10 records associated with 3/15/05, all ten records are displayed in the portals but when I print filemaker wants to print 10 pages, one for each record. I get 10 copies of the layout showing all 10 records in the portals. If I am in list view I can scroll down and see the 10 images of my layout, when in f…
-
- 4 replies
- 695 views
-
-
Anyone have a good solution for displaying a portal row in highlight to reflect the current record? Say for example, I have a portal displaying a set of records from the CURRENT table. Not really a self-join but a portal that shows matching records from the current able based on a global. Say, a global set to "New York" and joined to a State field in the current table of contact info. The portal would then show all records with people in New York state. If set a button in the portal to show the related record, I can hop to that record and quickly isolate the current found set to match the portal contents. Then, if I flip through the found set, I'd like to be abl…
-
- 7 replies
- 1.3k views
-
-
Hi to all friends do you know how many caracters can be placed in a value of a value list ? It seems that there is a limitation, but I don't know !
-
- 5 replies
- 770 views
-
-
Is there a maximum number of pages you can have in any single layout? I was trying to have over 10 pages or page breaks, but it wouldn't let me drag the body down any more. Is this the max ? (10 pages)
-
- 3 replies
- 884 views
-
-
Hi I got an identical portal placed on two layouts. When I go to the next layout through a button, I want the cursor flashing in the QTY field on the last line of the portal. I manage to activate the cursor on the first line. But I got no idea on how to activate the QTY field in the last line. I am sure there is a way to do that. Any suggestions would be great!
-
- 1 reply
- 821 views
-
-
...couldn't find a posting for my kind of problem, so forgive me if one exist - or better tell me where I can find it I try to narrow down new entries in a portal by what was entered before into the last row of another portal. In fact, I got a text database that shows different portals to other files (like contacts or projects). When I match a text to a contact (as step 1) then just the projects related to this specific contact should show up in a VL when I match the text to a project (as step 2). This works well, but the problem is, if a contact has no related project (coming from a bridge file) of course no VL exists. So what I try to find is something like a …
-
- 4 replies
- 854 views
-
-
I am writing a royalty program for a small record company in filmmaker pro 7. I am having a problem printing portals. I have two tables that have different royalty information for the same recording artist. Each table has several different records for each artist depending on how many different types of royalties they get. I have a third table that has a layout for a royalty statement for each artist that has a portal to table number one and a portal to table number two. Each portal line lists a royalty due. Since I don
-
- 6 replies
- 893 views
-
-
I am stuck on what seems to be an easy layout. I have a table of medical patients and within that are two portals, one for medication allergies (each patient can have many allergies) and below that a portal for their medications. In the medication portal there is an active checkbox and the portal sorts active to top and inactive to the bottom. (again each patient can have many medications). All I want to do is on that same page have 1 button that will create a report that I can print with patient being worked on at the top, then allergies and then only the active medications. Would appreciate any ideas. I will attach a sample file without any real patient data. Than…
-
- 4 replies
- 1.3k views
-
-
I have eight competitors in the portal with four of the competitors from two different schools. I wanted to make sure that two from same school are separated by one in the top and other in the bottom of the bracket so they don
-
- 3 replies
- 1k views
-
-
I've been digging around here and the posts on conditional value lists have been helpful. i.e. helpful value list post However, I think this one is a hair different... Here's what we originally started with: A single table containing a value list of 25 CUSTOM values, cap warning calculation fields for each entry in the value list and supporting summary fields for the calculations. Field 1, "Sessions", displayed the values of the pop up list and the other calculation fields would display "CLOSED" once a value had been selected from the pop up list in ten separate records. Therefore, if we selected value A02 in the pop up list in ten records, the cap …
-
- 0 replies
- 776 views
-
-
-
Quick question regarding layouts, Ive got a layout I
-
- 1 reply
- 678 views
-
-
File 1: Record number -- auto serialized Portal w/ item field, type field, qty field File 2: Record number Item Type Qty Relationship record number =:: record number; allow creation of related records works great -- but when I try to duplicate a record in File 1, no portal data is duplicated in new records in File 2. Is there a way to have a duplicate record (with new record number) that includes the portal data from the previous record?
-
- 37 replies
- 4.1k views
-
-
Hi all! Any advice would be really appreciated... Say I have a checking-account like application: I have a transactions table that stores the withdrawals and deposits to the account. And let's say I have a summary field that gives me a running total for the account. Then I would like implement the following process: 1) Allow the user to pick a year to report on. 2) Look up the starting balance for that year in a table. 3) Generate a report that adds the starting balance to the running total. More specifically, let's say the report shows the starting balance on January 1 of the chosen year then shows subtotals for every month. I'm okay with steps 1) …
-
- 1 reply
- 787 views
-
-
I went back to the drawing board and fixed my previous problem but I have one hurdle left. I have now successfully set up popcal1.0 to trigger from my field "closed" and it enters the date correctly. However does anyone know why popcal comes up on the screen every time I call for a new record? Can this be disabled? Thanks to Munchie for the help on calling the calendar in windows.
-
- 2 replies
- 764 views
-
-
i need to monitor people in a self study classroom as they checked in and out there name would be added to a portal what pc they were asigned to and the time they checked in . i think i could use a drop down list based on the number of pc's in the room. when there record was retreived from the search will be able to asign a pc# then it would time stamp and add to portal bottom of record screen when they checked out could click button on there row in portal to time stamp and remove from portal kind of like the lending libary i need to generate reports how many times and how long each person was in the room this should be simple i am lost on the scripting for the portal i d…
-
- 1 reply
- 839 views
-
-
I am new to FileMaker but am familiar with database structures (I am a Crystal Reports consultant). I have what seems to be a simple need: I want to be able to show two levels of one-to-many relationships on the same screen. I have a database for interior decorators. I have a Job table, a Room table and a Room Detail table. I want to create a Job screen that will show multiple rooms with multiple detail items for each room. At first I thought you could put a portal within a portal, but that doesn't work. Is there a way to group the top level and then insert a portal? I'm used to grouping using Crystal Reports but I can't seem to be able to figure it out in…
-
- 3 replies
- 1k views
-
-
If you Insert Field and check the box 'Create Field Label', FM will nicely do so. Everyone knows this but did you know that, after creating a field label name in this matter any subsequent changes to that field name in Define Database (vs. 7) and Define Fields (less than 7) will also change the field label names everywhere it's been used throughout your solution? Some Developers know this so create their own field labels to avoid this bug. Some Developers know this so use this feature to save time having to then change the name everywhere. I borrowed the idea of FM native 3D titles, headings and field labels from Ray Cologon (CobaltSky). By using FM native headin…
-
- 0 replies
- 810 views
-
-
Hi, I am currently creating an image database. I have a value list of about 40 projects that an image has been used in, and another value list of corresponding project codes. Some images have been used in more than one project so I have the lists displayed as checkbox sets. I would like to be able to set it up so that when the user checks boxes in the project list, the corresponding project code boxes also to become checked, and vice versa. Is this possible? I can get it to work if only a single box is checked (using the auto-enter calculated value option and setting up a case statement), but doesn't work if i check more than one box. Can anyone help? Hope this all m…
-
- 2 replies
- 670 views
-
-
I'm trying to create a report that will prompt the user to enter a date range, but will already have certain criteria checked off that it needs to include in the results. Here's an example of the fields: [Date In] - This is where the date range can be entered for lookup [Rush] - This is a checkbox that will have already been checked before the user enters the dates [stage]- This is a drop down list of items and "Hotslip" is the one to be used as part of the results. Now I know you can just go into Find Mode and make these choices yourself, but is there a way to automate it where "Rush" will already be checked and "Hotslip" will already be chosen so that when t…
-
- 39 replies
- 2.7k views
-
-
Is it possible to format the text within custom dialog boxes so it is different sizes, bold or italics? I've tried using TextStyleAdd on one or two words and the whole messge without luck. Is it a limit that FM7 always uses what looks like Lucida Grande at 10/11 point (the Macs system default setting)? I'd be grateful for some insight.
-
- 5 replies
- 2k views
-
-
I have records sorted by employee name, and in preview it looks fine, with the name and then all the records sorted below the employee, but when I publish it on the website, the employee name shows up, and the records below are not at all for that specific employee... like its not taking the sort on the web or something. There is no summary fields or anything complex, just one simeple3 sort by name. Any ideas?
-
- 0 replies
- 730 views
-
-
I have some portals that only show some of the details from the actual table. When a user would like to edit those records, there is a button within the portal they may click. Pleasantly, this button disappears when there is no record to show. I would like buttons to add a new record, and to associate an existing record, in a case where there is no related record to show... it would be great to mirror the edit buttons behavior, and hide when the user shouldn't try to use them. Any ideas how to accomplish this?
-
- 3 replies
- 771 views
-
-
Using the Time Billing free solution that originally came with FMP 5.5 and upgraded to v7. Activity, Customer & Project fields in portal are now configured as validated entries by value lists with "Other" capabilities. The problem: I have 74 master records, I want to create a 75th record and so on. When I create the new record and fill in the Employee name & number and the beginning of week date, the cursor jumps to the date field in the portal, (as it should), but all the fields in the portal are filled with data from a prior record. The filled date does not come from the prior record but from a much prior record. I've checked relationships, field …
-
- 7 replies
- 755 views
-
-
Heres my situation: I have constructed a table that lists some of the layouts im using. (easy enough) A value list has been created that contains the names of these layouts (also easy enough) My problem is how do i determine if the current layout is a member of that value list? Cheers for your suggestions.
-
- 5 replies
- 701 views
-
-
In my FMP 7 database, I have a layout/report that uses info from two tables. When I bring up the basic tabular layout for one of the tables, call it table A, I notice that due to some cutting and pasting done in populating the table, the font style varies across the fields and rows. When I view my layout/report in Preview mode, I find that the field font styles I specified in my layout/report design are ignored and the font styles seen in the basic tabular layout are being used instead. How can this font style override be eliminated without resetting the font style of every field in every row in table A? I hope this makes sense Thanks, Steve C.
-
- 5 replies
- 806 views
-
-
Hi All, My dbase has invoice, invoice line item and item tables. (And others...) I have a portal in 'invoice' which is selectable from a drop down box. I would like to make this list only contain items that are available - thru searching with the date the item is due to go out and the date the item is due back, to ensure that only available items appear in the portal list. (these parameters have previously been entered) I believe this is not possible. Is this true? I can't think of any other way to achieve this. Any suggestions?? Thanks Terry
-
- 12 replies
- 2.7k views
-
-
I have the Portal List on the left side of my layout and the related Data is shown to the Right To make life easier for my users I would like to keep the selected Portal row highlighted. How can this be achieved? Thanks in advance.
-
- 13 replies
- 1.9k views
-
-
In list view, is there a way to make it so that the current record has a different background color? I am very new to FM, any help with this is much appreciated!
-
- 8 replies
- 1.1k views
-
-
Hello, I've recently converted my db's to 7.0v3, and notice that my drop down menus have an incredible lag. With version 5, I was able to just fly through my data entry and FM was able to keep up. Now, I have to stop, pause, wait for the menu to "open" (drop down) make the selection, wait to make sure that it is actually selected in the field, and then carry on. A real waste of time... Anyone else have this problem? Is there a quick-fix? Thanks. Travis.
-
- 11 replies
- 1.7k views
-
-
Hi, When scrolling to the last record in a portal it stops at the last record. If I continue to scroll it repeats the last record adding new lines in the portal ad infinitum. Is this a bug, or am I doing something incorrectly (besides continue to scroll)?
-
- 8 replies
- 781 views
-
-
I have a portal with a list view. I have a second portal next to it in which I would like to display more details about the selected line in the first portal. Any idea how I would do this? It would need to show only the related info from the currently selected row in the first portal and update as the rows are clicked. Thanks.
-
- 14 replies
- 1.3k views
-
-
I am a bit of a Newbie to FM, but I have been building websites for years. I am wondering if anyone knows if FM has the ability to do layouts in frames? In other words, is it possible to have a list of records on the left, when you click on the record details of that record appear on the right but the list of records stays on the left. Any ideas? Thanks!
-
- 5 replies
- 860 views
-
-
Does anybody have a procedure for changing the background color of a field that has focus or is selected? I don't think this is possible but thought I would throw it out there before i totally dismissed it. Is there a plugin that might do this? Thanks! John
-
- 11 replies
- 1.4k views
-
-
All, I want to create my own themes. This is not documented in the FMP 7 Help, but the theme files are easy to locate and they are pretty straightforward XML. So I could change themes or create new ones if I like... trying this and that to get things the way I want them, spending a *lot* of time doing so. So... does anyone have, or know about, a documentation of possible settings? FM does not provide that information, it seems- I scanned the Techinfo without result. Thanks for any help! Lutz Pietschker
-
- 8 replies
- 1.1k views
-
-
I have a simple database that is designed so that users can log company supplies they have used on a week by week basis. Each week the employee will create a new record and log there supplies. I have another layout in this database designed so that I can print all of this information for that employee/week. The problem I have is that when I go to the printing layout It shows me all the records. I only want to view/print the record I was looking at on the other (browse) layout. Is there a way to say "find current record" via a script? Any thoughts are appreciated.
-
- 26 replies
- 1.8k views
-
-
is there a way to print only the checked checkboxes in a list? thank U for helping me
-
- 8 replies
- 1k views
-
-
I want to create a layout with a menu to access other layouts. Exemple: Go to "FILE" and a menu pop-up let you select where to go, or just select "print". and something like that. Go to "Exit" and exit the app. Is this possible?
-
- 8 replies
- 916 views
-
-
Hello, I have a 1-M / Master-Detail layout. In the header i put my main table (Invoices) and then in the body I put the invoiceLineItems table. Invoices has a 1-M relationship with InvoiceLineItems table. is there a way to print the header only on the first page and then on subsequent pages only print the body? sorry if this is a faq. thanks J__
-
- 8 replies
- 766 views
-
-
Hi there, I'm trying for days now on this one.... I have different tables defined in my db and what I want to do ist simply display the value of a statistic field on the layout of another table. All I always get ist an empty field. Relations are properly defined and everthing ist working just fine. I just can't get data displayed from one table on the layout of another... any suggstions ? Dirk
-
- 5 replies
- 1.5k views
-
-
I am new to Filemaker Pro and am attempting to design a genealogy database for my own use. In theory, each individual in the database is assigned their own record displaying birth, death and marriage details etc. Should the individual have children, I would then like a list of the children's names to be displayed with the user being able to select or click on a child in the list which would then display this individual's record. Would it be better to use a portal or some kind of list/menu field for this. If using a portal, am I able to assign the 'go to record' script to each row (individual) in the portal or only the portal as a whole? Thanks for your help. …
-
- 5 replies
- 907 views
-
-
Hi I have a database of companies details (name, address, etc...). Each company record has their profession name listed (i.e. Builders, plumbers, etc...). What I would like to do is be able to email any new companies showing a list (Company name only) of the existing companies within their profession on the email (i.e. Hi Mr Blogs, please be aware that we are currently offering our service to the following compaines within your profession: Blah Ltd, HoHum PLC, etc..). Incidentally, the list should only show companies within that profession who have had a "Yes/No" radio button checked "Yes". The email is plain text so no formatting required (although any tips pr…
-
- 2 replies
- 1.2k views
-
-
In the preview mode the one row in the bottom is appear, but why in printing result the one row disappear ? i have enabled Sliding and printed on. can you help me?
-
- 14 replies
- 876 views
-
-
Hi, I would like to know if it is posible to deconstruct a range of dates, just the opposite problem we have dealt before v7. In essence. I get from related Value list the following dates 14/7/2003 17/7/2003 18/7/2003 21/7/2003 22/7/2003 23/7/2003 24/7/2003 28/7/2003 29/7/2003 30/7/2003 Bu I need 14/7/2003, 14/7/2003, 17/7/2003, 18/7/2003, 21/7/2003, 24/7/2003, 28/7/2003, 30/7/2003, ranges in pairs in order to be sent for charting. I know how to make it with a go to related records & loop passing through the records sending data to a global an gettng the result. But for speed (
-
- 5 replies
- 785 views
-
-
I have a layout based on my work orders table. On it is a portal to the work order items table. I use this layout in a script to add new related work order item records and it works fine, except when the number of portal records reaches the total portal rows displayed. Then nothing happens. The step Go to Portal Row (Last) no longer goes to the blank portal row at the bottom. Adding a Go to Portal Row (Next) doesn't help either, the focus remains on the last completed portal row and won't move down to the blank row. As soon as I add displayed rows it starts to work again. Can Delete is on and, of course, Allow Creation is on for the relationship. I have other portal…
-
- 8 replies
- 906 views
-
-
Is this possible? Have a nice looking header with two buttons in it with script applied to the buttons. Do I have to recreate this header in all layouts or is there an "Apply To All" function somewhere? Thank you!
-
- 5 replies
- 845 views
-
-
How can I start page numbering other than by 1 without putting blank pages in my layout? Or how can I decide the starting number of page numbers?
-
- 5 replies
- 985 views
-
-
hey guys i have a layout that has a blue background. on top of the background is a large white rectangle. on top of that are multipl eother colored rectangles. on top of them i have transparant text fields. anytime you click on any one of the fields that are transparant you can see through all of them all the way through to the background. is there anyway to get around this? is this a bug or am i just doing something wrong? thanks, Anthony
-
- 5 replies
- 869 views
-
-
I tried searching for this topic, but couldn't find any posts... I want to be able to create advanced button designs for my FM solution. I'm using FM Developer 5.5. on Windows XP, so that rules out the button tool that I found on Apple's website. Does anyone know of a button generating tool that allows you to create buttons for use in FM on the windows platform? I found out how to make cool "Aqua" buttons using Photoshop, but am unsure of how I can implement these in my FM layouts. If I "Insert Picture" it inserts a rectangular image (even though my Aqua buttons have rounded ends). Also, the colour that the button makes upon click is HIDEOUS! Anyone out the…
-
- 8 replies
- 2.2k views
-
-
Goal: I need to cross-reference two different portal sets of data. This will take manual intervention and decision making. This example is based upon Pickup table (Main), LineItems (Portal1) and Returns (Portal2) but I'm keeping it generic because it will be used in other wonky situations that require manual decisions. User will be presented with something similar to the demo I've attached. Their job is to view the first item in Portal2 and find it's match in Portal1. Only each staff person will know which Portal1 item to select - there are many factors (date purchased, sales reps handle things differently, etc). They will use the radio to filter Portal1 down to…
-
- 32 replies
- 1.5k views
-
-
I want to affect, with a percentage, the total of each summary fields seperatly with different % numbers. How can I do that? Is that possible?
-
- 2 replies
- 786 views
-
-
Hi. I'm new to FileMaker Pro so please bear with me. I have a Person table and a related Donations table. I am using the Layout Wizard to make a report with groups (based on the FullName calculated field in Person) that includes the donations from each person and subtotaled per person. When I click the Specify button to choose the Amount field for subtotals, all the fields in the list are greyed out for all tables and I can't specify anything for subtotaling. Am I going about this right way? Is it possible to get subtotals in a report containing related tables? Thanks David
-
- 14 replies
- 1.5k views
-
-
I understand that FM7 introduced the possibility of having more than one table in a file ... and that it was thereby possible to have metadata and layouts in one file and data in another. Is this so? If so, is it possible to combine layouts from several files into a single file?
-
- 32 replies
- 3k views
-
-
The layout header is light gray with some black text. The rest of the layout is a subsummary line. A footer contains the text "hi there". Viewed in Preview mode there are 23 pages, completely and utterly white. Everything is set to be printable. It was working until I did some fiddling, so most likely it was one thing I did to make everything invisible. Does this make anyone go "ah-hah"? Gratefully, Chap
-
- 11 replies
- 997 views
-
-
Hello, It was tough to describe what I am looking to do in the Subject line. I am trying create a form that only populates if corresponding fields are populated. Let me give this some context.....I have created a database to enter in details for producing photo shoots. All of the logistical information is enetred in several layouts (using tabs for the user interface). What I am trying to do is take the information that was entered about a specific photoshoot and output that to a form. When the photo producer needs to get something approved, they would push a button to take all of the information that was input and present it in a nicely formatted form that…
-
- 23 replies
- 1.3k views
-
-
New to FP7. I added a great looking header to one of my tables. Is there a way to apply said header to all existing and new tables I create? Many thansk all!
-
- 5 replies
- 927 views
-
-
Hello, I have a number of uses for putting two portals on one layout. One simple example is for a recipe database. A recipe has many ingredients. On the recipe layout, I would like to show the first ten ingredients in the left portal and the second ten ingredients in the right portal. There is no particular order to the ingredients. For example, if there were eight ingredients they would only show in the left portal, but if there were 15 ingredients then ten would be in the left and five in the right Is there a way to do this without a script? I currently have two portals with ten rows each from two table occurances (both the same table) called ingredients…
-
- 8 replies
- 733 views
-
-
Sorry, I posted this to filemaker general earlier today. Is there a way to have your words wrap in a value list? Instead of being in one long straight line? Thanks for any help, Doug
-
- 11 replies
- 2.9k views
-
-
Hey Guys, i want to be able to have a status area on the main screen of my ui. the status area will show how an order works its way through they system. i want to be able to use either pictures that change automatically based on a condition or an object that changes color automatically based on a condition. this condition will be a simple true false with only 2 possible results for each object or picture. anyone know how to do this? Thanks, Anthony
-
- 5 replies
- 1.1k views
-
-
Surely there must be a way to change the appearance of a pop-up menu (or pop-up list for that matter) but I can't see a way to do this. I have searched through the help file & here with no luck. Any help appreciated.
-
- 8 replies
- 989 views
-
-
I've searched Filemaker Help and can't seem to find anywhere to set "hyphenation" on. I'm typing in an invoice description (for types of services rendered) field and when getting to the end of the text box, it's not hyphenating the words, forcing me to manually enter a "return" to type on the next line. Any help would be greatly appreciated. Thanks
-
- 14 replies
- 2.8k views
-
-
I have design a layout in which I need about 70 tabs in a few text items such as four fields and two text labels populated with field <<info>>. I have entered the tabs' settings every 25 pixels up to 500 pix and no more new tab... I need them but I do not know how to overcome that issue. Is there a workaround with other program -Which one?- and the pasted text manteins the format? Any idea? Does the versi
-
- 17 replies
- 1k views
-
-
Hi I am new to FM (just got it as trial). In one of the samples that come with FM there is a Purchase order table that I want to copy into my test database and modify it. How do I copy that table into my DB? Thanks
-
- 8 replies
- 752 views
-
-
I'm trying to modify some layouts ... but one is proving difficult because I cannot access the status area. In addition it has a body part. I have been unable to identify why it has a body part (I think it has to do with reports), but other layouts don't and I can't see how to remove it and how to get my status area back. The documentation is not at all helpful about what causes parts to exist in a form.
-
- 17 replies
- 983 views
-
-
Can anyone help me get my Newbie head around this... On a job sheet I need to detail individual product items - some jobs have many different products used so I don't want to limit myself with repeating fields - each product has a unit cost and some have a specific tax rate which I would like to have attached to that product, maybe I should give up for today and start again tomorrow but I just can't figure out how to go about it. any ideas would be great thanks
-
- 5 replies
- 857 views
-
-
I have a database with 2 tables..one is all infO of my clients and the other table is Case notes" The second table contains 4 fields..lastname, firstname, date and case note. What is the best way to call up a client record and also bring in their case notes? [email protected]
-
- 30 replies
- 2.3k views
-
-
I have two tables. Table 1 and Table 2. Table 1 has a text field in it where the color of the text is determined by a calculation. In most cases its black. In Table 2 there is a portal to Table 1 that shows this text field. In the portal in Table 2 I need to change the text color to white. How do I do this? I've selected the field, went to format and change text color. No change. Any help you can give is much appreciated.
-
- 5 replies
- 763 views
-
-
I am using Filemaker 7 and I need to create a conditional value list and honestly would like to scream because I can't get it to work. I have 2 tables Entry and Products. In the products table I have the fields part number and workcenter. I need to display in the Entry table a product value list based on the workcenter field. Example: Operator is in Entry table she chooses Workcenter(WC) 64 I need only the part numbers for WC 64 to display. I have created a self join relationship with the Products table with WC being the match field (products2). Where do I go from here??? I have chosen the part number field from the Products2 starting with Products and chose onl…
-
- 8 replies
- 1.6k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online