FileMaker Interface Features
-
Ok, I'm stuck with a portal related problem. I have a portal thats displaying textual IDs from another table. There are up to ten related records being returned for each record in my database. I need to get all information out of each related record summed together into a single field in the database. For example, in a record in the database I have IDs from four related records in seperate portal rows 0027s1, 0027s2, 0027s3, and 0027s4. I would like this to become one single field that [0027s1 0027s2 0027s3 0027s4]. I have no problem summing togther numeric and date information, but am having no luck figuring out how to do this with text. Is this possible…
-
- 2 replies
- 830 views
-
-
I have a master password, a teacher password and a pupil password (blank). Each has it's own group. Two seperate portals appear but the data is not visible under both the teacher and pupil groups. Why do these two portals only display data under the master password?
-
- 7 replies
- 797 views
-
-
OK, heres what I want to do. I have a pop-up list with 5 options to select from (wich come from a value list). I need to run based on the pop-up list. For example: If option 1 is selected, script 1 runs. If option 2 is selected, script 2 runs. And so on and so on. I have no idea how to go about doing this. Any help you can give is much appreciated.
-
- 15 replies
- 1.8k views
-
-
Hello all, The portals in my database to not scroll properly. The portal is only three rows tall. When a fourth or fifth item is listed in the portal and I try to use the scroll bar to view them, I only see garbled information for the rows that are scrolling into the portal. If I click on the scroll button some more, the entire portal fills with the same garbled data. Do any of you know how I might fix this? The attached image shows the forth item in the portal repeating after I clicked on the scroll bar again. Thank you! John
-
- 2 replies
- 830 views
-
-
You've all seen this before, so I'll make it quick. I'm trying to create a drop down menu that will display only related values from another table. The simplest explanation is to say that I have three tables, two main record tables and a join table between them. On the layout for one of the main tables, I have menu set to display a value list which is defined to show only values from the other table starting from the join table. I put a portal on the layout in question to show the same related data, and it is populated with the correct values. The drop down box, however, only shows the first related record. I'm wondering if there is something obvious that …
-
- 3 replies
- 815 views
-
-
In the OrderEntry table I have portals to two other tables. When I enter a product number it fills in the product information from these two tables. I would like to be able to "lock" the product number once I have clicked or tabbed out of the field so that the only way to change the entry is to delete the portal row (and thus the related records in a line items type table). This is due to using this field in a look-up in another table which, of course, won't change due to being looked up so I need it to be deleted if the product info changes. The looked up value there is required for a calculation and needs to stay dynamic. I hope this is clear. I tried unchecking the all…
-
- 8 replies
- 999 views
-
-
i'm a complete noob in filemaker. basically my boss just asked me to make some modifications to an existing database the other day and i really can't figure out how to make the following change. there is a value list that is customly defined. my boss wants me to change the order of some of the values and the names of the values, but retain the information that has been entered already. basically the form now looks like Deposit Check Deposit Guaranteed Form 1 - Acceptance Form 2 - Agreement Form 3 - Physician Form 4 - Important Host Family she wants me to change it to Deposit Check Deposit Guaranteed Form 1 - Acceptance Form 2 - Phys…
-
- 1 reply
- 690 views
-
-
Hey guys, I've just started using filemaker, I'm coming from a web database programming background. I understand relationships and all that stuff, but I am still coming to terms with how FM deals with them. I have a simple setup so far. Im keeping track of a set of lawsuits. I have a suits table and a parties table. I have a join table linking them, with a field for the suit id and the party id. I also have a field in the join table telling whether the party is a plaintiff or a defendant. On the layout for the suits table I added a portal to pull a list of the parties involved. I added the field in the join table for partytype, but in all of the rows it on…
-
- 2 replies
- 671 views
-
-
I have a database of patients. The table patients is linked in a one to many relationship to medications (each patient may be on many medications). I created a portal in my patient layout to enter/view/edit medications. (ie keep an accurate medication list). Next to each medication is a checkbox field for active so old and inactive medications can be sorted to the bottom. All I want to do is to print a patients active medication list. Each time I generate a report it prints all my patients unless I manually limit my set to the current patient. I want to have one button that will print the active medications of the patient I am working on. Also, If I run a repor…
-
- 5 replies
- 1.1k views
-
-
Forgive me if this is too basic a question but this is my first multi-window multi-table-per-file FM7 DB and there's something I just can't seem to get to work (something that was an easy 1-step action in a one-table-per-file environment). Let's say I have two windows, A and B. Window A contains a portal. When I click a button in a portal row, it should bring up the respective record in B. My problem is that there is no "GTRR in EXISTING window X" command (AFAIK) and if I use SELECT WINDOW first, GTRR won't work anymore. The only way that I see at the moment would be to use a script that selects window B, saves it's size and position in globals, closes window B, rese…
-
- 8 replies
- 897 views
-
-
I have several dynamic value lists that are all dependant on each other. When I change one value in a value list I would like the value lists that are dependent that list to be refreshed or automaticlally show a blank. This will force the user to select data from those fields. The problem is that when I change one field the remaining fields still shows data from a prior selection which might not necesarily be a member the value list. This is temporariliy throwing off some calculations. I have tried an auto enter but have not had any success. Thanks for the help Thanks
-
- 4 replies
- 1k views
-
-
I'm a FileMaker Pro n00b and am trying to create a database to keep track of my coin collection. What I am trying to do is this: I have a field, "Denomination" which consists of a value list with different coin denominations: half-cent, large cent, small-cent, two-cent piece, three-cent piece, etc. I have another field, "Type" which should be the specific type of a particular denomination. So for the small-cent denomination, the available types should be "flying eagle", "Indian head", and "Lincoln." For the three-cent denomination, the available types should be "nickel" and "silver." I would like to get it so that the options available in Type are dependent on the …
-
- 2 replies
- 686 views
-
-
My portal has several fields on it. Several of these are filled in by choosing from a value list. The value list makes it own data from the field itself by way of allowing other as data is entered. The value lists come from fields in tables other than the one the portal is viewing. All of these work except one. As I use the value list, it will accept the data. But then when I try to add another item to the list, it wants to change the value that is already there. I can't get more entries, and it will change the entry to be the latest one entered, in all the records. At first I thought it might have to do with the position in the portal, so I moved anoth…
-
- 2 replies
- 896 views
-
-
I am developing a project management database in FMP7 that has several hundred projects being tracked. After a good deal of interface design sessions we settled on a primary layout whereby a portal on one side of the layout lists all of the projects and the remainder of the layout contains the detailed fields for the project selected from the list. This is accomplished with a Table Occurrence of the main Project Table related back to the main Project Table where an auto-entered serial field with a constant value of "1" is the key relationship field so that all projects are listed at all times in the portal. A related record script button overlaying each listed name…
-
- 3 replies
- 885 views
-
-
hi, As people suggested repeats used to store data is not a good idea, now my setup has changed from having repeats to a 1 to many table relationship between customers and orders. Basically a customer can place 5 "active" orders, now once they are cancelled they need to be still kept in the database. So i need a way to only show the active orders and filter out the canceled orders. MnR
-
- 1 reply
- 691 views
-
-
Hi everyone!! It is my first post haha had to throw that in. To the problem: We have employers going to a specific site where they log in with their email and password and after they log in, I am trying to create a drop down menu that is automatically populated with the first and last name of their employees. The employer's email address is Also, how would I direct the employer to the next page based on his/her selection of the student in the drop down menu that corrisponds to the students record in the database? I found some code on here that uses javascript, but for some reason i cannot get it to auto populate the drop down menu based on the employ…
-
- 2 replies
- 767 views
-
-
I'm sure this sort of question has been asked before, but I'm unsure what search terms to use, so please forgive me if this is old stuff: Let's say I have a table INVOICES and a table LINES which are related via the key field ID. INVOICES has a field LANGUAGE and LINES has a field UNIT. Now I would like to define a value list which will show all values of UNIT for records in LINES which are related to records in INVOICES with the same language, so when I tab into UNIT, I will get a pop-up list of all units that I have previously used in lines of invoices of the same language. Is this feasible dynamically (i.e. without using a lookup LANGUAGE field in LINES)? Che…
-
- 2 replies
- 725 views
-
-
I know this is a simple thing to do ,but I cant figure it out. I have a flat database (1 table) i'm using a pop-up list to pull names from. I would like to be able to choose a name from this list & also have an auto enter phone number in the phone field for that person. Can you tell me how to do this? Thank you for all the help this forum has given me...... Maby it's not so easy..
-
- 1 reply
- 699 views
-
-
Is there any way to change the way pop-up menus act so that when you click on a field with a pop-up menu and make your selection that you don't have click outside of the field to make the change take hold? I basically want a user to click on a field, click on the selection in the pop-up menu, and then filemaker automatically leaves the field. Thanks.
-
- 5 replies
- 882 views
-
-
Hi all! Wondering if you can help this poor girl out before the day is through... I have two tables, InvoiceSummary and InvoiceDetails. The data entry portion works great - have a portal set up that allows users to enter line items in the InvoiceDetails page for the related record in the InvoiceSummary table. However, I do not know how to print out all records in a portal. For instance, one invoice has 26 line items. How do i print a invoice that has all the headers from the Summary table (Name, Address, Phone, etc.) and then be able to print all related records from the Details table (Qty, Amt, Etc.) When I used a portal, all I can see is the first 5 o…
-
- 11 replies
- 1.4k views
-
-
I don't know if this is possible - but how can I make it so that the contents of a portal are visible _all the time_, even when the user is moving the portal view by dragging the scrollbox in the scrollbar? The contents are visible when scrolling, but only if you use the up/down arrows in the portal's scrollbar. If you drag the box, the display locks until you stop moving. This makes finding items in a long list somewhat slow.
-
- 1 reply
- 762 views
-
-
Is there a way to change the value list that shows up in a popup list based on whats shown in another list? An example would be: You have a layout with 2 popup list. The first one gives a list of office products(pens, pencils, paper, etc.) The second popup list will give a list of accessories that go with the product selected in the first popup list. The catch is, that the contents of the accessories list in the second popup list changes everytime the product in popup list 1 changes. So if you selected pens in popup list 1, pocket protector would show up as an accessory in popup list 2, however, it would not show up if pencils or paper was selected. I hope this doe…
-
- 1 reply
- 717 views
-
-
I don't know if it's possible to accomplish the following or not: Say you have a data table - each record in the table has three fields: Brand (Apple, Dell, DEC, Samsung, etc.) Type (Computer, Monitor, Mouse, Keyboard, etc.) Color (Beige, Black, Grey, etc.) You want to view these records via a portal - but you wish to be able to filter the portal contents on the fly. You define 3 global fields: g.Brand, g.Type, and g.Color. You set up the global fields with value lists, each matching possible entries in your data records. Now - if you enter 'Apple' in the g.Brand field, the portal should show only those records that are Apple brand. If you t…
-
- 8 replies
- 1.2k views
-
-
Is there any way to create something similar to a sub summary that is viewable in browse mode?
-
- 5 replies
- 1.1k views
-
-
Hello everyone, I am so so glad I stumbled onto this forum. I have just bought the program, and want to use it for my little business of selling t-shirts & accessories at local fairs here in California. I see that I could definitely make use of the templates that come with it, such as (inventory, purchase order, contatcts). I will be trying to tweak a few things here and there, such as making the purchase order into an invoice form. My question is this: I would want to tab between all the forms, but just don't know how to do it... I've spent the whole day/night on this. I'm having a feeling its something pretty simple. Firstly, do I need to p…
-
- 7 replies
- 1.2k views
-
-
I want to cut down on the amount of layouts I have for various faxes, memos etc. I'm thinking of creating some type of dynamic layout that I can use for all of them (presently we have around 50 layouts). User's would enter information into fields, click a button that would then run a script that would put all of these fields into a calculated field that displays the document. I would like to include portals in this calculation field. Is this possible? Thanks.
-
- 3 replies
- 1.2k views
-
-
There must be a simple solution - but I can't find it. When a user enters a ctiy name I would like to add the postcode and state at the press of a button. The postcodes come from a value list based on all cities and postcodes already entered. I would like to do this by using the vlaue lists and there seems to be all the functions except one. The value list for postcode and town can be put into two global fields with 'ValueListItems ( Get ( FileName ) ; "Postcodes")' and ValueListItems ( Get ( FileName ) ; "City"). I would like to be able to find the value number of the city so that the script could pull the postcode from the coresponding value postion in Postcodes with …
-
- 3 replies
- 854 views
-
-
I am working on a DB for employee tracking and I have a field called "Employee Status". I have a drop down of 5 items. 2 of wich are the words "Vacant" and "Contract". If I select either of those two words, a second window pops up and asks for two date values that must be entered. If I write a calculation for the "Employee Status" field and define as such. How should I modify my script to where it will bring up a second window that allows me to enter the Request Date and Expiration Date? They can be both assigned the same because they both represent the same result if either is selected. Let("Vacant" and "Contract" = 1), If "Employee Status" = 1,…
-
- 6 replies
- 966 views
-
-
I'm new to the filemaker d/b and am not sure how i do this - I need to create a report which would display all the records created between a particular date and also of a particular company (this is optional.. sometimes i will have to display all the records satisfying the date criteria) Also I have to subsummarize according to the state the company belongs to.. like.. State Company Name ID Sales Profit Creation Date I am not sure as to how i should go about designing the report? Can anyone help me with this? Thank You.
-
- 20 replies
- 2.5k views
-
-
I have a database consisting of many records and layouts. One of my layouts that I use for printing has a subsummary part. Each Record in the database has a number ie; 1m1, 1m3, 2m1, 2m2. When I go to this layout for printing which has the subsummary part it puts a heading over the records in that series. ie; Group 1: followed by records 1m1, 1m2; Group 2: followed by records 2m1,2m2. The group number is derived from the first number of the record. What I'd like to do is add another piece of data to that sub summary. For each group there is a version number that the user manually enters on a different layout. I'd like to have a calc that reads which group numb…
-
- 14 replies
- 1.3k views
-
-
I'm not sure exactly where this needs to get posted. I am trying to create an invoice that allows you to keep adding items to it. There will be a button taking you to a screen where you choose what is to be added to the next line of the invoice. The invoice will be automaticaly updated with the new item. This will be for creating printing invoices. Here is an example. I create a new invoice and select add quote. I am then taken to a screen where I enter 1000 prints on 80# cover stock etc.... I am then returned to the invoice and it is automaticaly updated. Then I click the add item button again and am taken through the same process. Does this make sense? I …
-
- 6 replies
- 867 views
-
-
In table 1 I have all the values. In table 2 I want 2 fields to contain related checkboxes in that when an item in field 2.1 is checkboxed, it is automatically checkboxed in field 2.2 Ideally this would be both ways so that when an item in field 2.2 is checkboxed it is automatically checkboxed in field 2.1 an example DB is attached. I think I need some relationships, but can't figure out which ones to get this going. Anyone got an example on or know how I could do this? Thanks.
-
- 2 replies
- 753 views
-
-
According to FM, they fixed the issue with portals not refreshing data when pulling data from distant tables. My problem is it is still doing it, despite following all of FMs instructions with the 7.3 update. I have data that is dependent on a key that is set in one file (with the portal) and then pulls data from another. The cost displayed in the portal only refreses if I enter a quantity (thus forcing the calc) or if I go to define database and go back, then every cost is refreshsed. Is anyone else encountering this and any ideas for a fix? Thanks.
-
- 12 replies
- 3.2k views
-
-
I have the following value list: A B C A&B A&C B&C A&B&C If I use a Pop-up List the values display correctly, but if I use a Pop-up Menu the last value shows as A&B&&C even though if it's selected the field is set to A&B&C. Normally this wouldn't be a problem and I'd just use a Pop-up List but the rest of the program is almost done now and I'm using Pop-up Menus and find they seem quicker and better for the program I'm building. It just seems unprofessional/strange to have one field selection being different than the rest I'm probably just missing something and it may not be a bug at all, any input is appre…
-
- 3 replies
- 1.1k views
-
-
I have a DB with a varying number of records per client. (I.e. client A have 5 records, client B have 1 record, client C have 12 records, client D have 0 records and client E have 3 record) One part of the DB shold in a portal reflect what clients (at that time) have records, and how many. Something like this: Portal ------- A 5 B 1 C 12 E 3 ------- This portal will serve as an index, for a CD backup of client material. Is this possible? I have a feeling I have seen something similar before, but can not remember how/where?? Regards!
-
- 2 replies
- 764 views
-
-
Hi I am trying to add a small graphic to a Container field. I set the graphic format to "Reduce or Enlarge" or "Enlarge" And the "Maintain origianl...." is not checked. But the graphic do not expand to the total field it leaves a white edge to the right and at the buttom (it looks like it make some kind of blur to the color). I have have used a color made inside FM and a graphic made in PhotoShop - the result is the same. Can anyone help me so the graphic fill the field total with not white edge. Jens Peter
-
- 5 replies
- 916 views
-
-
I believe I saw how to do this once but I can't find it again. I have a contacts field that I want to add a pop up menu to. It currently has contacts in the field. I would like to create a value list that contains those contacts and will be populated with any new contacts that are entered. I thought it had something to do with a self join but I couldn't get it to work. Contact Field: Either select a value from the list or enter in a new contact. That new contact would be populated into the value list because it is based on the contact field. Let me know if I didn't do a good job of explaining it. Did I remember right that this is possible or am I thinkin…
-
- 2 replies
- 701 views
-
-
I am creating a new application to print the obstetrician's delivery note, the labor and delivery nurse's delivery note, and a new report for the delivery log at the time each note is printed. I want the delivery log to be in landscape mode on legal paper, with each patient's record stretching across two facing pages, with the holes punched in the right margin of the left facing page and in the left margin of the right facing page. This is the format of the traditional hand-written delivery log. Each day in the delivery log will have its own two facing pages. I can print the left facing page, but not the right facing page. My layout has the page break correctly posit…
-
- 4 replies
- 3.2k views
-
-
In our FM-system, we have a separate file for suppliers (printers, papermills, prepress ...). I have tried to make a dynamic valuelist for each type of supplier, which works fine as long I'm in the same file. For example the field PRINTER_LIST (calc = "printer") is related to the field TYPE. Then I want to use this value list in another file in the system, I create a value list in the second file using "Use value list from another file". But that doesn't work... Any ideas? Or isn't possible? /Henke
-
- 1 reply
- 783 views
-
-
-
Hello, I have a few popup lists. I would like to check if the data the user entered is in a value-list. I'm using something like this to do this in script and it works almost perfect. if [ PatternCount ( ValueListItems ( Get (Filename) ; "StatusTypeValueList" ; Tasks::Status ) = 0 ] set field [ Tasks::gMatched ; 0 ] else set field [ Tasks::gMatched ; 1 ] end if Code elsewhere does something with the gMatched to display a message and/or so on. So, suppose I have in my StatusTypeValueList the following values : Open, Closed, Pending If I click in the drop down list of the status field in a task layout, I can pick any of these - but …
-
- 1 reply
- 856 views
-
-
Hi, I've searched the various post on dynamic value lists and the answer to what I'm looking for isn't quite there...close, not quite. I am trying to populate a value list with data from a table. And I need this to display on a invoice type page. So, the page shows records from Invoice Table, and I need to display two dynamic value lists from Products Table. The first dropdown list is called Company...upon choosing a certain company from the list I need the second dropdown to display items associated with that specific company...upon choosing the specific item the price of that item is now displayed. I have tried various self-joins, but i must be missing so…
-
- 4 replies
- 1k views
-
-
Hey, I'm just wondering why when I use a go to related record button, in a portal, it returns a the related record but within all available records. Is there a way to isolate the related record to be itself in the found set? I want the user to only be able to see the record that is selected from the portal, not to be able to flip through all records. Thanks...
-
- 1 reply
- 633 views
-
-
I have created a dynamic value list via a relationship. I would like to have another dynamic value list that is a subcategory of the first value list. The problem is that the second list would be based on multiple criteria. I need to create several fields with pop up lists that will eventually be narrowed down to one record. Make sense? I am using FM6 I appreciate any help.
-
- 2 replies
- 736 views
-
-
Hello, Everyone Is there a way to copy a table -- Duplicate it... This way I only have to change a few fields and not redo everything in the table. I know about table clones... Not what I need... Seperate Table is what I was looking for... Is there a way to duplicate a table? Joseph
-
- 4 replies
- 1.1k views
-
-
I have a fairly small database. Basically there is a Project table and a related Shots table. There is never more than a single project record and, during testing, I had no more than ten or so shot records. But when the number of shot records gets higher (at this point it is still just 64 records) the graphic refresh of some of my layouts slows right down. This does not happen when the file is shared via FileMaker Server, only when opened directly. I am using a pretty fast PC as my workstation (2.8 GHz, 16 MB AGP video) and I get the same speed issues when I run it directly from my desktop, so network issues aren't the problem. The real irony is that the PC bein…
-
- 16 replies
- 2.3k views
-
-
I have been so far very successful in creating my database but I am having trouble in displaying a summary of my data in a report and would appreciate help. I have a database of patients each of whom have many visits by a physician. Patient A is seen on 1/1/05 by Dr Y, 1/2/05 by Dr Z, 1/3/05 by Dr X. The same is true of Patient B although the dates and doctors will vary. At the end of the month I want to make a spreadsheet report that has the patients in rows and day of the month in columns. If patient A was seen on 1/1 it will display Dr. Y in that cell. under 1/2 it will display Dr. Z in the cell. Again each patient is linked to many visits which record th…
-
- 7 replies
- 1.2k views
-
-
Hey Im completely new to filemaker, so I am learning as I go. I figured out how they put the contact name in big grey letters on the contacts example. <<tablename::fieldname>> Easy enough. Now, I want to be able to display text based on a relationship. For example, I am designing a system to keep track of lawsuit records. I have a suits table, a parties involved table, and a join table which links what parties are involved in what suits. On the suit layout, I want to display text saying the name of plaintiff vs defendant. That information is in a related table, and I don't know how to access that using the table::field notation. I tried doi…
-
- 2 replies
- 904 views
-
-
Is it possible to apply conditional formatting to a layout in FM similar to excel, whereby alternating lines could be given different background colors for easier readability? (i.e., line 1 is gray, line 2 is white, line 3 is gray, line 4 is white)
-
- 14 replies
- 1.4k views
-
-
How do you make a layout with tabs across the top or section? I have seen this in many same files but I don't know how to do this. Is this a plug-in you can get?
-
- 2 replies
- 961 views
-
-
I'm developing an application that requires someone enter lab test results into it. There are often 30 or so numbers to enter from any given lab report. Unfortunately, different labs have different formats, including the order of the various results. The specifications for my application call for the user to be able to set-up the order of the fields for data entry. I assume that a user would just do this one time only - or very rarely - as users would change labs rarely. One thing that is NOT an option, would be to hard-code it in a few different formats. No one is quite sure of all the differnt lab formats that exist. I'm looking for your experiences and sugg…
-
- 4 replies
- 922 views
-
-
Hi all, Is there a way to give the user "controlled" design access to a label layout? I want the user to be able to adjust the field positions on the label layout, so i want to create a button that would "switch to layout view" for that specific label layout, pause the running script, let the user adjust field position (not allow any adding or removing) then return to the main menu. Am I dreaming or is this do-able??!! Thanks Dan
-
- 11 replies
- 1.1k views
-
-
Hi all, Is there a way to display the first 10 portal rows, and then by clicking an up or down button change the group of portal rows displayed. For example, you have the first ten dispalyed, then cick a down button to show the next ten. I am trying to eliminate the visual clutter arising out of the need for multiple scroll bars on a layout with multiple portals. Thank you, Don
-
- 2 replies
- 856 views
-
-
Hello, We manufacture windows and are trying to make order entry system. We have a Glass Order that you put in the Quantity and the sizes and then we have would like to make a assembly list that shows all the components you need to make each size. We would like to be able for it to copy the sizes and Qty. into the assembly lists at a push of the button. Do you have any Ideas on how you would do this I would greatly appreciate it. Thanks Alot Jonathan
-
- 3 replies
- 926 views
-
-
Hi, Does anyone know the best way to copy fields from records in one table to fields in records in another table. I've tried using a portal but I need to copy fields from more than 1000 records (the limit for a portal). Any ideas? Thanks.
-
- 7 replies
- 1k views
-
-
Anyone else have troubles with how drawn objects appear in FMP? below are pics of the same fields in Layout Mode then in Browse Mode. Anyone else get the shrinking Rectangle problems? If you look closely you will also see the Top field has a nice clean line where the top and right engraved edges meet. The field on the bottom has a jagged edge. I have noticed some other strange things with the drawing feautures of FMP, anyone else have similar experiences? Layout: Browse:
-
- 0 replies
- 710 views
-
-
Hello Everyone, I have a portal that indexes off of a value list. This works well... Is there a way to add and entry to the value list that will index the portal for all entries on the value list. Joseph
-
- 14 replies
- 1.4k views
-
-
Hi to all, i have a DB with a layout with several different Buttons (all buttons performs differents scripts), and i wish to put all them together in something like a toolbar. That it's possible? If yes, tell me how can i do it! Thanks in advance for your help!
-
- 3 replies
- 1.1k views
-
-
How to add page numbers on a layout. Not using the ## text code, this result only in a pagenumber I need to use pagenumber and total number of pages. page 1 of 2 page 2 of 2 Rgds Mark
-
- 1 reply
- 711 views
-
-
I am trying to get a total figure for each of 4 choices of a value list. I can't sem to get it to work. For example my value list is called types of concerns with the four choices of 1) academic 2) behavior 3)attention 4) emotional. I have 355 record with each record having one of those four choices in the record. I want to see have many I have of each type. I know it can't be as hard as I am making it.
-
- 3 replies
- 743 views
-
-
Why are number fields sometimes left justified when placed on layouts? I would think they would automatically be right justified but they aren't, and you can't change the justification by selecting Text Format. I placed a few fields on a layout and the number field was left justified. I selected all the fields changed the font size to a larger size. Everything became right justified then. Can't figure out what causes this erratic behavior. The Mad Jammer
-
- 2 replies
- 1k views
-
-
Happy 2005 everyone! I'm looking for a way to have FileMaker print two different layouts to a single PDF file. I currently have to click "Save as PDF" for the first layout in OS X's Print dialog box, save it to my hard drive, then execute a second script to get the second part of my PDF created (with another click on "Save as PDF") and finally merge the two parts using Acrobat Pro 6.0.2. Is there a way to get FM to save directly to a PDF file? Can I also get FM to append pages to an existing PDF file instead of doing a manual merge in Acrobat?
-
- 3 replies
- 1.3k views
-
-
Hi, I have a relationship set up (with appropriate "add records" ticked) where the user can type in a new record. Problem is - it won't let them. I can delete a record, I can edit a record, it just won't let me add a new record (ERROR MSG: this action cannot be performed because the field is not modifiable). The field is a straight text field. I have checked the following: Relationship - ticked to allow creation of records Field - edit, allows modification, text (not calc) table - on the actual layout with the table I can add a record. Portal displays current records correctly so obviously the relationship works. I've created these th…
-
- 5 replies
- 839 views
-
-
I'm uncertain whether this belongs in Portals or Relationships, since it pertains to both. Perhaps I don't understand how Portals really work, but this seems counterintuitive to me. Say I have two tables, A and B, with a join table (call it J) between them. This accomplishes a many-to-many relationship by including the ID fields from both A and B. Additionally, I have a flag field in J whose purpose is to filter the join. To do my filtering, I can place a *global* flag field in A or B, and then in my relationship I can specify that not only do the IDs have to match, but also the flags. Now imagine that I have set up a layout based on A. In it I put a portal view…
-
- 3 replies
- 695 views
-
-
Hi All, I was chasing a weird problem with value lists and managed to extract it from our application to the test.fp7 file attached Briefly: 1. I create a value list with "Use Values from Field" Option - The value List contains 2 fields ( first ID and second Name ) - It is ordered by the second field 2. I'm using this value list in a pop-up list field in another table: "Test Tbl" The problem: ( it is not the end of the world but let me know if it is some known bug ) 1. When I type inside the pop-up list field, for some of the letters it jumps straight to the place needed BUT : 2. If you try typing "Q" or "R" it jumps to the last member …
-
- 11 replies
- 2.1k views
-
-
This is a quick question for those who have developed a vendor ordering system for a business. I have a line items file and with each item a purchase order field. The p.o. number appears in this field when the item has been ordered by the business. So many items can contain the same p.o. number. I'm trying to find a method to view the p.o. numbers in a summarized format where each p.o. number appears only once (one p.o. per line). I'll keep searching the message boards, but thought I'd ask. Thanks
-
- 3 replies
- 949 views
-
-
I am trying to use checkboxes, and they aren't showing anymore. I have about 30 layouts using them, and they are all fine. Now on new layouts I try to use them and the values come up, but now actual boxes. They appear if you left click on them, but cannot be selected and disappear when the cursor moves. How can this be, and how can I make it right again? Thanks for any help!
-
- 13 replies
- 1.3k views
-
-
Hello all, Setup: Table 1: Name: "Main" Fields for Table 1: "MainID", "FirstName", "LastName", "Address", "City", "Zip" & " Phone" Table 2: Name: "Policies" Fields for table 2: "RelMainID", "RecordID", "Seller"(Full Name)....etc.... Table 3: Name: "Seller" Fields for table 3: "RecordID", "FirstName", "LastName", "FullName"(Calc) & "Address" Info..... Relationships: Main::MainID --> Policies::RelMainID Seller::Seller_FullName --> Policies::Seller_FullName Info: There can be many polices per one Main page ie: Bob Smith has 3 polices all with different information The Problem: As you can see I have a seller fiel…
-
- 2 replies
- 772 views
-
-
I am really new at this; I bought Using FileMaker 7, but I can't find the answer. We have a database of clients, and I want to write letters within FileMaker, then save the merged letter to the client's layout in a container field. I can set up the form letter and the container field just fine, but how do I save the individual letter? I've Googled,and everything I've found relates to ancient FileMaker versions. Many thanks.
-
- 4 replies
- 1.9k views
-
-
Hi, I'm just learning filemaker and I would appreciate any help you can give me. I need to create a filter that will show all records in a certain status. Example: Let's say there a 5 users in my system. I want to view all records that are open by a particular user. Is this possible? Please help. I have another problem, but I'll keep working on that one and if I can't resolve it on my own that I'll ask for help. Thanks in advance.
-
- 4 replies
- 687 views
-
-
I would like to open a new window so that the user can insert data in a small window that opens in front of the main window. The user should insert data and click on a continue button and the window closes and the user will go back to the main window and continue what he was doing. This new window should be Modal. That is a window that opens and the user won
-
- 8 replies
- 1.6k views
-
-
Hi everyone, I like using the send mail feature and scripting for the entire pages contents to be copied into a field so that I can specify this field as being the BODY TEXT of the email. Nice But no formatting at all except for carridge returns. Isn't there a way of including right justified tabs and font size, etc so that I can create an emailable, nice looking invoice document or quotation? At the moment every email I send looks like Date: 20-11-2004 PO Number: GT-11099 To: Rob Larkins Ingram Micro UK Order Details ___________________________________________________ Qty: 1 PCode: 450689394 Descr: dfhhj dfjkhgk hkjddfdf U…
-
- 1 reply
- 742 views
-
-
Our company has a mixture of Macs and Windows XP machines. I have several layouts with headers set top print at the top of each printed page. If my layout is sized to be printed in two pages, the Mac prints exactly two pages. However, the Windows XP machines print an extra page at the end with the header on it. Why?
-
- 3 replies
- 1.2k views
-
-
Quite simple me thinks, in fact I've never had a problem with this before until now. I click on Client Name It opens a new window and I FIND a client from a Portal list. The field ::ClientName from the portal window is a button that triggers a script to: setfield ClientFound, FindClient::ClientName What this does is copy the client name from the correct relationship name (FindClient) into a field called ClientFound which is used for another relationship to show client information in another window. The problem is: The portal window may show Johnson Banks John Malchavitch etc etc If I click on John Malchavitch, it goes to the …
-
- 4 replies
- 1.3k views
-
-
I am wanting to specify different colours in a particular field where the colours may be different for different records. (This therefore means that I can't do this in layout mode or it becomes global.) At the moment we just use the words (ie red, yellow, etc) but would like to know if it's possible to actually have a pull down menu of the different colours.
-
- 6 replies
- 1.7k views
-
-
Hi, Using a self relation from client table to client table for searching by alphabetical sort; tow fields Filter(text) and Filter"Z"(caculation) and Name of clients. Filter----------<=Name Filter"Z"---------->=Name This is working well foe rearchin on names; only when a name has Z in it by example FAWZI. This is not working if i search for FAW; but working when searching for F, FA, FAWZ, FAWZI an displays well all names bigning with theese. Do you have an explication for this; and something to do to fix this search. thanks [color:"blue"]
-
- 2 replies
- 708 views
-
-
Hello, I have a portal, which already has some filtering in it - you click the column header and it will sort the portal by that column (only ascending at the moment). I also have a popup-list above the portal, which allows the user to pick their name, then click a button [Filter] to show only the records which were created by them. Well, now I need to sort the portal by the status - so, there is a status column, and I click on the title of the column and it's sorted based on (the tricky part) the order of a value-list. The list is status: (Open, Closed, Pending); so when they click the title of that column, they will see the order showing n Open records; m Closed …
-
- 11 replies
- 1.3k views
-
-
We are using portals to track our theatre ticketing history. We have it set up so that the most recent order appears at the top of the portal. However, when anyone tries to pull a report than involves any of the other portal rows, it finds the correct patron and puts it in the report but posts only the info from the top portal row. The info in the portals is kept in a separate FM document and each portal row has its own order id number. Any ideas on how to fix it? I have a feeling it's something really simple I'm overlooking.
-
- 3 replies
- 706 views
-
-
A global field is formatted as a drop down list. If the user clicks in the field anywhere other than on a list choice the list collapses (as it should). However, if the user then clicks on the header area to exit the field they can not re-enter the list or execute any of the buttons in the Header. The system works fine on layouts without the Header formatting, and it works fine when clicking on the formatted Body. What is causing this? Can it be corrected other than changing the list to a menu? Global field is: If ( IsEmpty ( Lookup ( D_sSelectedNav::z_NavListName_t ) );TextColor ( "Select" ; RGB ( 255 ; 0 ; 0 ) );//No listName, Red TextColor ( Lookup ( D_sSel…
-
- 4 replies
- 1.1k views
-
-
Is there a way to begin printing labels to an Avery sheet without starting at the first label? I may print 2 or 3 file folder labels a session. I currently track projects in FMP and print the file folder label in a MacSoft product, Labels and Cards Mac. It works but it has the feel of an OS 9 program. Would the series of roll style (Brother Turbo) be better for this task? I can't believe after all of these years that this is not a standard printing feature in FMP. A plug-in or something.
-
- 1 reply
- 1k views
-
-
Hi All, I want to print a layout which has only one field which extends to about 10 pages. When I print that layout, it prints only some pages from the middle. I checked the printer configuration and it appears to be fine. It shows properly in the Preview mode as well. Please let me know what could be the problem in printing the whole text properly. Thanks Yogesh.
-
- 0 replies
- 718 views
-
-
This is strange... I've set up a simple database with two tables... one holding a list of all possible entities (ValueTable), and another that uses those entities (MainDB). I have a value list that pulls data from the ValueTable table. Now, I have a need to restrict that list to some smaller amount... let's say that it's based on the value of a field that can be either "1" (include it) or "0" (don't include it). To do this, I set up a relationship that connects the MainDB to the ValueTable based on matching that boolean field with a calculated "1" in the MainDB. I know set up a value list based on that relationship. No go. I get all the values. I created a portal to show …
-
- 2 replies
- 800 views
-
-
Hi everyone, i know i already posted something similar but still cant get it to work properly.. it improved and i understand it a lot better, but still need help: here is the problem, i have fields and a portal that depend on two fields: "part#" and "test" these 2 fields are value lists with "test" depending on "part#" so far when i change the value in "part#", the data refreshes immediately, but when i change the "test", nothing happen... if anyone could have a look at my database, and give me some advice that would be very nice Thanks, and again GREAT forum !!! Copy(2)ofTestVerificationDatabase.zip
-
- 11 replies
- 933 views
-
-
All, I encounter this behaviour on both Mac and Win, in FP7v3. I have 3 global fields, two of them numeric, one text. The text field points to a related table (this table is in a referenced file); this table returns a numeric key corresponding to the text. An unstored calculation in my local table returns a numeric value from this key and the two numeric globals. The calculation result points to exactly one record in another related table (again, that table is in a referenced file). Fields from this table (one of them a container, but I do not think this is relevant) are shown in the same layout as the globals. What happens is this: Whenever I change any of…
-
- 8 replies
- 1k views
-
-
Hello everyone, I thought I knew how to do this but I just can not figure that last step out. I have made a portal that indexes its self from a checkbox simply names Yes... That works well.. I would like to flip this around... meaning I want my portal to display everything that is not checked off. I can not get this to work I only want one checkbox -- If it is checked = Yes; If it is not checked = No How do you get a single check box to mean no If it is not checked... Joseph
-
- 10 replies
- 1.1k views
-
-
I am using a portal to view a list of invoices from the related invoic DB, filtered by the clients name. I placed a summary field outside the portal to show me the Total Ammount of a client. That works fine. but as soon as i change the clients name (pull down list) the summary field turns into a blank field. i have to klick into that field to see the new calculated result again. Is there a way to show the information on the layout without scripting? thanks Norbert
-
- 9 replies
- 935 views
-
-
Hi I tried to make dynamic Value lists to each dynamic field in a portal, meaning - if I change a the field in a column, then I get a different VL on that field. I played with it, and I can't index the field that stored the VL, thus I can't make it a VL... ( I don't want to use "getfield(field)" , because it wont change unless record is updated...) any suggestion? [Here is a link to a test file]
-
- 6 replies
- 836 views
-
-
Hi All, apologies for lack of input on these forums, but I've just started new job and things are a bit hectic. Anyway - I've been tasked with creating a new Asset Management Database (Users, Hardware, Software, Attached Devices etc etc) and immediately thought of FMP to develop it (as it's the only thing I use for DB creation!) First problem is hopefully something really silly - On the hardware page I want a portal row at the bottom where 'Attached Devices' can be entered (i.e - On Mac 1 I want to specify that a Scanner is attached, a USB HD etc etc). I's also like to be able to view these attached devices on a seperate layout that shows each device, and what '…
-
- 1 reply
- 1.4k views
-
-
I have a field that contains the full name of individuals. I would like to separate the full name which is separated by a comma into two fields, one with the first name and one with a last name. I want to print name tags with just the first name. I imported the original data base from Excel and was able to separate the field into 2 columns at a later time, but FileMaker did not recognize the file so I could not import the information. Thanks for the help. Pillroller
-
- 2 replies
- 889 views
-
-
Hello, Does anyone know how to index a portal from 2 fields (Seperate). I know how to index it from one field... But not two... Thank you, Joseph
-
- 5 replies
- 610 views
-
-
(we're still using FM5&6) In a portal, I have a field that may be one line of type, or may take up to several lines. Is there a way to make the field the size of the data entered into it when it prints? (i.e. if the size of the field in the layout allows for 5 lines of type, but sometimes when entered, only takes up one line, is there a way to omit all that extra space) I've been playing around with things, including the sliding/printing features, but can't seem to get this to work WITHIN A PORTAL. Thanks in advance for any input!!
-
- 5 replies
- 822 views
-
-
Hi, Any idea how to have the number of pages printed depend on the length of a portal, but in a way that a footer text always prints at the bottom of the page?
-
- 6 replies
- 3.3k views
-
-
Hi, I used to have a nice filemaker pro 4 file on my mac but the machine died and i bought an ibm with windows xp, where i installed a filemaker pro 5. Now the original layout doesn't fit to the papersize anymore (up to three times the size of the paper to print on). I can't find anything to reduce the whole layout, and I don't want to redraw the whole thng. Any ideas? thanks
-
- 1 reply
- 719 views
-
-
In FM6 I have a layout with several portals. When you print the page, portals only print the # of matching records and everything on the page slides up if it can. If there are no matching records, then the portal doesn't take up any space on the printed page. Is there a way of having FM7 do this too? I'm getting multiple pages where I used to get only 1. Thanks.
-
- 2 replies
- 668 views
-
-
Hi, I have a layout which contains a popup-list. How can I stop users from typing in there? I had validation being done by FM7, but went to my own vallidation scheme and now I either have to stop them from typing in there - or compare the selected item in teh list and then see if it's in the table which the value list uses to render itself. Oh and also these fields are just copied values - not related. sorry, one more thing, I would like to the ability to let the user click a button and add an item too. I guess I could just use a popup layout for that. thanks for your help in advance, sincerely, J__
-
- 5 replies
- 688 views
-
-
Hi all, I once started a collection management database with FM7 Pro and had to give out due to lack of time. Now, i'm re-starting everything from the beginning and am facing some problems i don't even remember i already had to ... So, my point is that i have a first layout where i enter new records ; one new record for one new disc. Then, i'd like to create another layout that would only sort the artists that i have discs from so i can pick one artist by selecting his name and beeing linked to a page with all his discs listed on (There shall be at least one more layers of that kind after the artist discs list). What i don't understand is how i can ask a P…
-
- 2 replies
- 857 views
-
-
I have buttons in my headers that are using grpahics for display puposes. In table mode, and only table mode, the graphic disappears when viewing the database in Instant Web Publishing. I get the dreaded "x" for missing graphic. Any fix?
-
- 0 replies
- 740 views
-
-
Does anyone know if it is possible to set the *paper* size to something smaller than 8 1/2 X 11 so I could print on labels that come on the small sheets? Thanks!
-
- 3 replies
- 807 views
-
-
Hi, I am a new member with only small experience about FM. I need to transfer a field content to my Foxpro program. Please imagine that I have a FM browser with an icon on that, when I click the icon, the FM should transfer a field content of a certain record to my Foxpro executable program. Help me please how to do it. Thank you very much.
-
- 3 replies
- 931 views
-
-
Hi, Is there an easy way to get filemaker to print a sheet of the same label from the same field instead of moving to a new record for each label? For example, I want it to print the product name "Candy Apple" 30 times on the same sheet, formatted properly for Avery 5660 labels. Thanks! Andrew
-
- 5 replies
- 1.2k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online