FileMaker Interface Features
-
Hello, I am new in this... I have 100 records and 2 popup i would like to create a new layout with the results of the combination of these two pop-up. How do I do that? I am very new in FM. Thanks
-
- 3 replies
- 781 views
-
-
I have a solution that contains information about our employees that I use all the time. Is there a way other than a list layout where I can have photos of employees in a grid layout (as opposed to a list) and be able to click on them to go to their related record? I already have a container field with the photos. Thanks, john
-
- 3 replies
- 998 views
-
-
I've been seaching the forums but I can't seem to find the answer to this. I have a value list which contains vendor numbers and vendor names sorted by the second field, vendor name. The user tabs to the vendor number field and gets the pop-up list. In version 6 if the user typed an 'M' the list would scroll to the vendor names that started with 'M' now in version 7 the list scrolls only scrolls if you type in a vendor number. I hope I explained that well enough. I don't know if this is a bug or if FM did this intentionally. I hope someone can help me out with this because it's a real problem for me. Thanks!
-
- 4 replies
- 837 views
-
-
newbie with a sliding problem. I have a form that imports through 15 various portals to make a summary report. Within all the portals, they slide up if no information is included. In preview, most of the portals slide up to eliminate blank space between portals as well, except for the first two portals. I have checked numerous times to confirm that all portals are formatted the same exact way, and yet I still get blank lines for the first two portals even when there is no data presented. Any ideas??? Any help would be greatly appreciated.
-
- 2 replies
- 809 views
-
-
Is it possible to put a merge field into a global text field? On my "estimate" layout I have a scope field that copies a global field on a different layout. I would like info from other fields in the estimate record to be included into the global field via merge fields. Is this possible?
-
- 2 replies
- 950 views
-
-
I have an invoice with a portal showing sales of CDs and single images. Some of the invoices go over 2 pages and I have just about mastered the sliding and printing to get rid of extra space. The problem is when an invoice goes over more than 4 pages, the lines of the portal start showing half on one page and half on another. is there a way to stop it? Thanks!
-
- 2 replies
- 933 views
-
-
Is it possible to build a layout that fits different screen resolutions, say 1024 x 768 pixels, 800 x 600 pixesls or 640 x 480 pixels? I am using FM 6.0.
-
- 4 replies
- 1.1k views
-
-
My portal rows each contain a small Delete button. Aesthetically I can't stand seeing a Delete button on that last, empty row that exists because of "Allow creation of related records". However, since I do need to create records in the portal, I'm trying to find a way around the "Allow creation of related records" option for the portal. My best effort so far has been to store the value for the related field into a global, and call a script in the related file to create a new record and fill in the related field. Back in the main script, I then GotoPortalRow[select,Last] and fill in the remaining fields. A new, blank record does appear in the portal, but GotoP…
-
- 4 replies
- 782 views
-
-
Hi, I have attached a file that has an interface that I've built over time, but now, to me, appears too cluttered. Could anyone share any ideas with me for how to lay it out more logically ? Or, just share any opinions or first thoughts you have ? It is the main record window for a job applicant database. Any advice would be most appreciated,.. I think I've been too wrapped up in this database for too long to look at it with fresh eyes. design.fp7.zip
-
- 6 replies
- 1.8k views
-
-
Hi, I was told by someone that I can take a snap shot of a layout and display it in a field. Basically what i want is to offer a small preview in a layout of the larger printable layout. Is there a way of doing this? I am making a field with a large amount of text that has been formatted through scripting. It is basically a menu comprised of different fields combined into one. I want to put a smaller version of the field in the editing window, but when i do, the text is the normal size and i want it to be a full page in a small field. Thanks in advance for any help you can give.
-
- 1 reply
- 956 views
-
-
Hi - I am using FM with a barcode creation plug-in to create inventory labels - labels with a product's name, SKU and barcode. Unlike address labels, where I would want one of each record, I have multiples of each label that need printing (and not necessarily the same number for each record.) The labels are printing on full sheets rather than spool-fed individuals, so if I simply specify a number of copies of a single record to print - let's say 15 - I'll be wasting a half of a sheet of labels each time. I would appreciate it if anyone has any ideas for how to deal with this - for instance a script that uses the number in my inventory field to specify how may of…
-
- 7 replies
- 1.9k views
-
-
Ok, I'm whipped. Many of the threads here seem to be about filtering, but I'm not getting it.... A Workshops record contains WorkshopName and ActiveFlag. ActiveFlag is a Number field containing 0 if the workshop is inactive, 1 if active. I want a value list that contains the WorkshopNames for active records. The ActiveWorkshops value list is defined to be "Use values from field...", "Only related values: WorkshopsByActiveFlag", using values from :Workshop_ID and ::WorkshopName. The WorkshopsByActiveFlag relationshop is from Workshops to Workshops, a self relationship matching ActiveFlag to ::c_Constant. c_Constant is a stored, indexed calculatio…
-
- 16 replies
- 1.4k views
-
-
I'm trying to have a portal show only the unique records, instead of every record, but not having much luck. Here's what I've got: Databases: Orders - main entry of order, has portal of Items which are related by Order Number. Items - each separate item in the order, includes the vendor and item ID. I want to create a portal that will show all the vendors used on an order as the same vendor can be entered on the order multiple times. I did manage to make a calculation which returns all the vendors from a relational value list. But I can't seem to relate this calculation in order to show the values in a portal. I got this tip from an earlier post, but m…
-
- 6 replies
- 905 views
-
-
Is there any way to have one layout set to Portrait and another to Landscape?
-
- 5 replies
- 5.1k views
-
-
I am building a simple database that has 2 main layouts, the first is a control panel where you would enter data and the second layout is the list view showing all the data entries. My problem is that i would like to make a portal on a section of the Main layout where data is entered and have a portal that shows the list view in a portal window, so i don't have to switch between my main entry page and list view so all can be displayed on one page, that's the goal!! Is it even possible to use a portal in this manner? Someone please help! I am using filemaker 6 running on os x panther
-
- 2 replies
- 685 views
-
-
Is there a way in FM7 that you can create a button to sort a portal. I know you can define a sort when you create a portal, but say the user what the change to a pre-define sort (ex. alpha based on lastname). Thanks for your help!
-
- 6 replies
- 927 views
-
-
Anyone know how to make a portal in FM7 reset on exit of the portal like it did with FM6? Meaning, if I create a new entry in a portal via the bottom row, it stays there until I exit the layout and then come back. Used to be (when I walked to school without shoes, through 3 feet of snow and through Indian territory) in FM6, when you exited the portal by clicking in the open, the portal would reset and your new entry would hop to the top (if it was sorted descending via created date and time in the relationship. Now, it just sits like a lump at the bottom. Is there is a script solution to reseting the port (other than hopping into another layout and back?
-
- 3 replies
- 745 views
-
-
Hello there Forum!!! A text field in Contacts. I need a popup menu which will display, depending upon the Staff viewing it. This popup will need to be user-specific and only contain THEIR possible choices. And they need to be able to add and change this popup freely but it would need to be restricted to 15 possibilities. A portal would not work in this scenario (no space). I'm considering many things and would appreciate knowing how you all would approach this situation. I have a Preference file, a Staff file and a Contacts file. I currently don't have a Value List file. Is this a good candidate? Or would you store this VL within the staff record itself? Ide…
-
- 3 replies
- 796 views
-
-
I have a layout that has two portals. Both portal relationships are self-joins to the table that the records reside in. None of the fields are editable on the layout, and when one person is already on that layout it is locked and no one else can even scroll through the portals. Any ideas other than placing the portals on a layout not in that table (i.e. no self-joins)? The only goal I have is to be able to have everyone be able to scroll the portal rows no matter if 1 person or 40 people are in that file.
-
- 9 replies
- 1.1k views
-
-
I am having some problems with getting a find to work within a portal and I am not sure what I am missing. I have two tables, workstations & unassigned licenses. There is a relationship between the two tables. I have a portal on a workstations layout that is showing the unassigned licenses data. When I enter find mode and put a value into one of the portal fields and hit find, it returns all of the data in the portal not just the data I searched for. I tried switching to the unassigned licenses layout and performing the find there, then switching back to the workstations layout but that did not work either. What am I doing wrong here? I should be able to do this…
-
- 1 reply
- 602 views
-
-
Here's what I'm doing. I have a properties database (real estate). The main output from this database is a sell sheet. I have fields like TITLE, SHORT DESCRIPTION, MAIN DESCRIPTION, PHOTO 1, PHOTO 1 CAPTION and so on. I also have 10 fields titled: BULLET 1, BULLET 2 and so on. But some of these bullets get long (and thus wrap) and I would like to have the second and third lines to indent: (this doesn't actually show it indented here, but you get the idea)
-
- 3 replies
- 989 views
-
-
I'm interested in comments regarding the use of multiple windows in FileMaker. As you probably know, FileMaker 7 has the ability for a single file to show multiple windows, which allows for some interesting and perhaps useful new additions to how solutions can work. For instance, I am currently working on a solution that has three tabs across the top: Home, Vendors, Traffic. Vendors and Traffic are main tables that contain the bulk of data entry, and have many portals into other tables of related information. Each has a list view and details view. With multiple windows, I can have one window for Home, one for Vendor List, one for Vendor Details, one for Traffic List …
-
- 2 replies
- 1.3k views
-
-
I have a script step which sorts by a custom order, involving three fields. The first of those three fields is set to sort using a custom order based on a value list, which is as follows: Red Yellow NI Green Note In the sorted results, items appear in this order (there are no entries for NI at this time): Green Note Red Yellow This is in the wrong order. I tried selecting "Sort Records..." from the Records menu, and removing the other two fields (to sort just on this field), but the results are the same. I suspect this is a bug, but the same, unchanged setup was working perfectly before. The only changes I have made were to …
-
- 11 replies
- 1.6k views
-
-
I've been looking but I can't find a portal filter example that works via a date? Can anyone help Thanks
-
- 0 replies
- 773 views
-
-
I'm building a database of real estate properties. I have fields such as: TITLE, SHORT DESCRIPTION, MAIN DESCRIPTION, DSCRPTN 2, DSCRPTN 3, PIC 1, PIC1 CAPTION, PIC2, PIC 2 CAPTION, PROPERTY TYPE, AGENT and so on. The main output for this database is sell sheets. HERE'S MY QUESTION: I would like the user to have the ability to--once in a layout--choose which fields populate which areas. I'm thinking of a dropdown menu (suppressed printing) by each "field area" (sometimes it's a picture box, sometimes it would be a text box) so that the user can choose which fields populate that layout of that record, at that time. Can this be done?
-
- 2 replies
- 896 views
-
-
-
I need help. I have a list of Jobs with corresponding Job Titles. I want to use this field as a value list, HOWEVER I only want displayed as part of pop-up list Titles for Jobs that are not 'completed'. Completed jobs are flagged as such. Removing these from value list will limit pop-up list to around 30 items, as opposed to several hundred if value list contains ALL jobs. Can I use the "Include only related values starting from" box to accomplish this. I'm new to FM so please be specific. Thanks.
-
- 6 replies
- 1.1k views
-
-
Hi Everyone, I have a file (Invoices) with many products for each invoice . Each product have a name, price, quantity ... and stored into another (and different) table (LineItems). These products (LineItems) are into the "Invoice form" (Invoice table) through a portal. Unfortunately, when I'm trying to search for products in the "Invoice form" through the portal (by Find Mode) I got many results that have no common words with the search criteria (same problem with numbers , Quantity, Price) . A search into their table layout (LineItems) will give the good results. Anyone have an idea Another thing : all the records have been imported to filemaker 7 (by T…
-
- 2 replies
- 747 views
-
-
I have a database containing "client" records and another containing "contact" records. These are relational and I wish to write a standard letter for the "Contacts" using a new layout. When I insert the merge fields to be used the <Name> comes from the "Contact" database but I want the other information such as <Company> , <Address> etc to come from the "Client" database. Whilst I can choose these merge fields from the "insert merge field" by choosing a related database (i.e "client") when I preview or print I don't get any information across ?? Pretty new to using Filemaker so if you can advise me I would be most grateful. Cheers guys.
-
- 0 replies
- 872 views
-
-
I want to be able to print labels on a partially used Avery label sheets. I want to select what my starting label will be.
-
- 3 replies
- 5k views
-
-
We are using File Maker Pro 6 on windows XP. One of our databases has a form that is too large to print on one page, even if we use legal paper set as landscape. The owner will not allow us to redo the layout to be more printer friendly. My question is, how do I make filemaker 6 for the PC shrink the layout down to fit on one sheet of paper without changing the layout? Is this possible? Thanks!
-
- 2 replies
- 1.9k views
-
-
Is it possible to remove the entire menu bar of a runtime solution without using a plugin?
-
- 4 replies
- 1.1k views
-
-
Enclosed is a sample of my database. When using the Admin User the POS window refreshes just fine...when using any limited account user (Even when you give the limited user full access to everything) the portal window fails to refresh properly. Thanks, Greg POS_sample.zip
-
- 0 replies
- 654 views
-
-
Hi all, this is my first post. I have done a lot of reading and ordered several books. I appreciate your help in helping me get started on redesigning my website www.robnokes.com, currently the site is run on W2K with a SQL db driving it. I have a pop-up value list of six items (about, contact, credits, news, references, movies) and I would like to select the one item from the pop up list and then have a script find the appropriate records (based on the selected value from the pop up list) and display them. To date I have not been able to create a button that has an underlying pop up list. Please advise. BTW I am writing this on FMP7 and also have Dev7 and…
-
- 1 reply
- 803 views
-
-
Oh I looked, I did. For the past three hours and can't find something like this. I have employee table (staff activities) which is connected to activities (activities found) on many things. This is so I can filter the portal. It's very pretty and works great, filtering by date range, types, status etc. I call it activities found because it searches for the employee in the employee (staff activites) so only their page displays. Staff activities is not yet attached to our customers. Problem: When I click portal row with Go To Related, it only lists one. When I try to script 'starting from' staff activities, it doesn't give me a customer layout to go to because…
-
- 6 replies
- 1.4k views
-
-
I have a field with 8 repeating text values called "Tour" (types of kayaking trips). I want to establish a script or calculation in the "Fee" field (city port fee) that queries the "Tour" field and returns a value in the "Fee" field based on whether the type of kayak trip listed/repeated in the "Tour" field uses a motor boat or not. If yes motor boat, then fee; if no motor boat, then no fee. What seems to be failing is the repeating nature of the "Tour" field - niether script nor calculation recognizes the repeated values as a field. Any advice to my friends ou there?
-
- 6 replies
- 869 views
-
-
I'm setting up a guest list for each day of a tour. I have one portal that contains guest names. There will be a different number of names for each day. How do I set up a print layout to print the portal across a page breaks?
-
- 3 replies
- 745 views
-
-
I am working on kiosk db. I have a "Search" layout that the user can use to find specific book records. After hitting the search button, the user is taken to the results Layout which is in List Mode. If they would like to see the information for a particular title, how can I take them to a Detail Layout for that one record? I would like something that functions like a web hyperlink- meaning they can click on the title and go directly to that record instead of having to type anything in to a new field to get there. Is that possible? Thanks for any advice, Catherine
-
- 4 replies
- 956 views
-
-
Hi there, Someone here know if Filemaker Pro 7 now have a better and easier way to be able to make the people directly add data on the TOP ROW in portal? I didn't see any change at this part, i'm surprise. I'm the only one? thx fred
-
- 6 replies
- 1.6k views
-
-
I've run across a few 3rd party plug-ins that say they can create basic charts with FMpro. Can anyone offer suggestions or recommendations of their own for creating charts? I'm looking to do simple line charts that would update automatically once new data comes into the db. So once the chart is set up there shouldn't be much more to do a far as maintaining it. Is there anything available like this? Cheers...
-
- 10 replies
- 1.6k views
-
-
Hi, If you are in a layout and you have a field or a number of fields, say a table of Music Groups information and you would like to put this information into another table, say called "Managers", then what is the best way to do this? I have found 2 ways so far. First way is using global variables. I set the field(s) I want to copy into a global field in the same table. I then switch to another layout, and then do a Set Field on the record in the other layout using the global variable. Set Field [bands::gBandName; bands::name] Go to Layout ["manager layout" (managers)] Set Field [managers::band_I_manage; bands::gBandName] The second way is to use Copy…
-
- 2 replies
- 864 views
-
-
I have a layout that has 5 portals on it. Each one is dependant on the previous portal as you work across the layout. As you click on a row in one portal a script is triggered to setting a key field that populates the next portal with related records for that particular item ... it also changes the background colour of the clicked row to signal it is the current selection. This all works fine. The problem I have is this. The number of records in Portal 1 stays pretty much constant. Portal 2 may fluctuate but never really exceeds 5 items. So the first two portals are working fine. However Portals 3, 4 & 5 often have more records than what my layout will a…
-
- 1 reply
- 807 views
-
-
This may seem elementary to most of you but I'm new to FM7. Is there a good tutorial or book that would explain how to add or create "tabs" on a layout. Something along the lines of the Personnel Records layout template that comes with FM7. If I wanted to add another tab to the 3 that already exist I don't even know where to start and exploring the layout it's not intuitive to figure it out. Any help would be greatly appreciated because this knowledge could be used on many other layouts in the future. Thanks... I do enjoy this forum by the way.
-
- 4 replies
- 1.2k views
-
-
Post deleted by vasilek
-
- 1 reply
- 806 views
-
-
Probably a dumb question but is there any way to adjust the portal row height or spacing?
-
- 1 reply
- 956 views
-
-
HI all. I am wondering if anyone knows how to get rid of the back border that surrounds a text field when it is active. Yes, I have already unchecked Layout Setup: show field frame when field is active. I want to get rid of the back boarder when the mouse clicks into the field. Thanks for any advice. Travis Ferreira
-
- 1 reply
- 977 views
-
-
Hi, I am making updates and upgrades to a database created by someone else and I think I have hit the outer limits of my abilities. I'm hoping I can explain this clearly enough so you all understand what I'm talking about! This database has about 15 files, and I think 4-5 of them are involved in this report: Client information - holds basic client info - name, address, employer Workshop information - holds basic event info - title, date, location Workshop registration information - line item that registers a client for a workshop Session information - holds information about breakout sessions WITHIN a workshop Session registration information - lin…
-
- 0 replies
- 997 views
-
-
Sigh, this is really frustrating. I create a SIMPLE portal with a relationship to a remote database (that is password protected...but it's not asking me for a password). It works WONDERFULLY until I close the file. When I reopen it, poof, the portal is empty. I know this is really vague, but any ideas?
-
- 4 replies
- 832 views
-
-
-
Hi. Is there a way to create a splash screen, set a timer to shut it off and then go to a layout? And can you make this splash screen without the tool bar on the left... and then when it opens the second layout.. have the tool bar re appear? It's probably easy, but I'm new. Vandy
-
- 5 replies
- 1.2k views
-
-
How do I make a layout in FM that changes color with the color scheme of Windows XP?
-
- 1 reply
- 809 views
-
-
All, Is there a way to align a layout to the centre of a window rather than to the left as standard? Besides appearances in FM this could also be used when publishing to the web ie Have a block of graphics similar to FM or Apple web site. Any thoughts? C
-
- 0 replies
- 802 views
-
-
I need to know if it is possible to set up two columns in the body of a report and then have a portal populate into both columns.
-
- 2 replies
- 699 views
-
-
Is it possible to build two portals which are inter-dependent? That means, when the record of one portal is changed and the other portal will display related record.
-
- 1 reply
- 670 views
-
-
I'm having a frustrating time here, something that my head tells me should be quite easy to sort out... In main layer (Members) I have a drop down list, that contains membership types (Beginner, Junior, Adult, Junior Honorary, Adult Honorary, Expired) I would like to be able to display in another layer "Junior" only records. I would also like a layer, that contained the details of a combination of types, as a "Junior" member can also be a "Honorary" member. Thank you for any help. (If I have posted in the wrong section, please shout, and I'll quietly move elsewhere)
-
- 0 replies
- 735 views
-
-
Hi everyone. I'm working on developing a volunteer tracking system for the local chapter of Habitat For Humanity. What I'm doing is building a database that will log volunteer hours, for the use in grants and recognition. i'm pretty good with filemaker, but have never used the portals. what i want to do is make the portal a time log of each visit, where they were, what they did, and for how long. i can get all that stuff working, but i can't get a new line to show up for the next entry! what am i doing wrong? do i have to set-up a script to do this, or is there a simple setting i'm missing? an example of what i'm talking about is in the "time billing" template…
-
- 1 reply
- 673 views
-
-
Our server and most of our clients are OS X. But we have a few rebels accessing the databases with Windows - mainly XP. But nearly every layout looks different in Windows and they cannot print forms that they need. The fields cut out some of the test and even objust are in different places. FMP is supposed to be cross platform, but I am getting frustrated. IS there a simple way to get the layouts to look the same in both platforms? Tanya
-
- 1 reply
- 791 views
-
-
I'm running FM 7 on XP and I'm having a strange problem with my layouts that i cant seem to figure out or find any info on. It seems to happen at random but it always happens in the following order: 1. First, there will be any of a number of odd selection problems, including an inability to select/deselect certain fields; selection boxes staying put when the field they surround is moved; locked fields disappearing. Once this begins on a layout, it doesnt seem to stop (or spread) even after the computer and Filemaker are restarted. 2. Eventually (and inevitably, it seems), only one or two objects or fields will be selectable at all and even those are un…
-
- 8 replies
- 1.5k views
-
-
Hi there - I am using FileMaker 6 on XP with FM Server 5.5 on Windows Server 2003. I have attached a copy (pdf format) of the report that is printing in an odd way. The section that is not printing correctly is under "Loose Items to be Built and Sent with Job" and under "Crown, Knifemold, Toekick, Shoemould, Decks and Bar Tops". For some reason, when this prints it is scrunching the fields in an odd manner. Any ideas on how to fix? Thanks! ShopTravelerExample.pdf
-
- 0 replies
- 815 views
-
-
Does anyone use ACD Deneba Canvas to create layout design? I'm struggling with transparent graphics
-
- 0 replies
- 816 views
-
-
Hi I am fairly new to FM. I have a multi-tabled project that I am working on. One table contains "families". A second table contains children. These 2 tables are linked by a family code. In the family table is the street address. All the children are seperate records in the children table. I am trying to create a mailing label that would say: To the parents of xxx,yyy,xxx where there might be 1 child in the family or 4 children. Thanks in advance cathy
-
- 3 replies
- 902 views
-
-
I am having a problem with a layout that I am using as a contract. The layout is "Stock" 3 pages long but when in preview mode slides up to anywhere from 1-1/2 to 3 pages in length. It does this because I have a series of large text fields that shrink to fit the text within them. I have inserted a page numbering script that displays the page numbers as "Page 1of3". The numbering system works great! Here is my problem. The layout automatically wants to print 3 pages even if the last one is blank because that is how long the body of the layout is. My specialized numbering system doesn't jive when the last page of the contract says "Page 2of3". Thi…
-
- 3 replies
- 1.2k views
-
-
Please explain how one gets and uses the portal row number. I have tried: field "Row Number" type number with auto enter calculated entry Get ( PortalRowNumber ) result returns numbers incrimented by one but the first row which should be one is some other number and field "Portal Row Global" type number with auto enter calculated entry Get ( PortalRowNumber ) result returns the number 2 for every row.
-
- 8 replies
- 1k views
-
-
Hi, Suppose you have say a list of purchases in a table called [purchases] I have a field in there for customerName and customerPhone and so on. I'd like to go to a contacts screen - which has a contacts table. Pick a contact from the table - say in find mode and then set that values from contacts in the [purchase] tables contact fields. If you use a value list with a drop down, then this is easy. the thing is my contacts list may be so big (say 100 or more) that the drop down would be cumbersome to manage. Also Im not relating the producs with contacts because I only want to copy the information - not have a link to it. Is there a way to do this with va…
-
- 6 replies
- 1.5k views
-
-
Hi, I have two drop down lists, which filter off of each other. drop down list 1 is Bands - has a list of bands in it. drop down list 2 is members - has a list of members in it. you pick the band you like, then you pick the members drop down list and select the person you want. so for example, I might pick Beatles and then pick Ringo Starr. I have this working - i believe. But how can you make the second drop down list automatically drop down.... let me elaborate more. the situation where it doesn't drop down is when I change the first one again. example: I picked the Beatles from band list, i picked Ringo Starr from the band members list. B…
-
- 0 replies
- 998 views
-
-
We have both Filemaker 5.5 and 7 in our network. I'm converting some of the files over to 7, but things are not going too smoothly. Today's problem is the page setup. In 5.5, the page orientation was remembered for each layout. In 7, all layouts default to portrait. If I set it for landscape, print and then close the db, the next time I open it, it will be back to portrait. Anyone else see this? BTW we have 7.0v2 on all the computers. It's a global problem with FM7. Tom
-
- 1 reply
- 1.1k views
-
-
Hi I am having problems with this: I want to have a warning message pop up if a particular item has been selected in a fields pull down menu. I can do this with a script but it then needs to be triggered by clicking something else. Does anyone know any other way I can acheive this.
-
- 4 replies
- 964 views
-
-
I have a whole database of information, some of the fields are selected either by checkboxes or popup menu, the question that i am asking is that when you edit the popup menus or checkboxes, the already created information selected from those boxes remain the same and does not change to what you have edited it to, therefore leaving two types of the same fields but with different name, is there a way to change the current fields to whatever I have modified them to? My current solution would be to create a .NET program to interact with the database and change them, but I want to know is there a way to do it in FileMaker. The version of FileMaker that I am using i…
-
- 3 replies
- 814 views
-
-
This is the problem..... I have a features table which user can modify the names of the check boxes, on the other page that it updates correctly it composes of a products page which you can select the features it has using checkboxes again. When I modify the names of the checkboxes in features, the names of the checkboxs on the products page changes, but if it is already checked, it will be unchecked, how could I get around this problem, by making the checked boxes update but without it being unckecked. Please help me Ken
-
- 3 replies
- 816 views
-
-
What is with the buggy graphics in layout mode??? Lines looking cutup and such? If I scroll off screen and then back sometimes it corrects it. It has been that way from filemaker 5 to 7 and it seems that 7 is worse. It happens on multiple computers with multiple licenses. Is there a fix for this? Is it a Windows thing?
-
- 8 replies
- 2.1k views
-
-
I need a popup menu with times. I want them displayed every half hour from 7am to 10pm. I could create custom VL of course, but I want the result to be a real time field (will be triggered to notify User via plugin). Is there a calculation I can use? Or, if I need to enter them all manually, how can I be sure it will be appropriate for a time field. I just have never worked with time fields before. LaRetta
-
- 9 replies
- 1.1k views
-
-
Hi everyone, I was told that FMP7 supported transparencies. I can do this with a container field, but is there a way of doing with a pasted background graphic? I have a picture that has a transparent background and I want to make it sit in the background of a layout with a colored background. Thanks in advance
-
- 4 replies
- 1.3k views
-
-
I have a Database set up as a quotation database. One field (called "status") is a member of a Value List that has values for "Current Sale", "Sale Lost" and "Sale Complete" and are displayed as radio buttons. The other field is called "Invoice Number". Now some users when clicking on the "Sale Complete" button are forgetting to enter an "Invoice Number". Is it possible to force a user to enter an number into the "Invoice Number" field but only when they click on the "Sale Complete " Radio Button and not on the "Current" or "Sale Lost" button. I know you can click on "not empty" for valadition for a field but can you do this or something similar for one radio button wi…
-
- 5 replies
- 829 views
-
-
When you sort ascending on a field, blanks go to the top of the list. You can get around this by sorting on a value list. Non-value list members, including blanks, sort to the bottom. In FM6, this also held true for sorting portals. But in FM7, whether you sort on a relationship, or sort the portal directly, blanks go to the top of the portal. Anyone else been bitten by this? It bites. My workaround is to use a calculated field Case( SortField, SortField, 999 ) /* I hate this */
-
- 4 replies
- 835 views
-
-
How does one limit the font choices in FM? I olny want to show the Windoze/MAC compatable fonts.
-
- 9 replies
- 1.3k views
-
-
Currently there is a drop down list with each month range in it. EX: 1/1...2/1 2/1...3/1 And so on. This is used for searching for patients whose baby due date is in that month. HOWEVER, the year stays as the current year when the search is done. What I'm looking at is taking the 1/1...2/1 and adding the appropriate year to it and putting that in the EDD field and doing the search on that. So if it is October and 1/1...2/1 is selected in the drop down list, the date in the EDD box is 1/1/2005...2/1/2005. Any suggestions will be appreciated. Basically I'm not sure how to get the data selected, I think after that I can dynamically creat…
-
- 6 replies
- 818 views
-
-
How does one limit the font choices in FM?
-
- 1 reply
- 801 views
-
-
Does anyone know of a way to hide or lock layouts (or make invisible) from users? I'd like to make it where they can still have access to the status bar but not be able to see the names of all the layouts.
-
- 1 reply
- 767 views
-
-
I am trying to create an iTunes-like interface to act as a front end to several databases (Magazines, Issues, Competitions). The idea being the user can click on a portal displaying Magazines which will then create a key for the next portal displaying the years that magazine has been published. This continues onto Issues published in that year and onto competitions run in that issue. I am trying to achieve a drill down like action where the user by clicking is filtering down the list of records. My problem is that when the user clicks on the Magazine Portal Row all the issue records for that magazine show in the year portal. Meaning there are duplicates displayed ins…
-
- 2 replies
- 784 views
-
-
Hi there, I (re)built the FM example of the webstore which comes with the Filemaker 5 package.
-
- 3 replies
- 708 views
-
-
Actually using WinNT. I have one page that I want to serve. When I hit the web link that shold take me to the page, I get the following error: Unable to process your request because the layout could not be accessed. Any idea's? tia, Brad
-
- 0 replies
- 926 views
-
-
I'm creating a db in Filemaker 7 for me to track musicians who will be performing in a worship service for church. I am working with 2 tables, (1) Music Schedule and (2) Music Schedule line item. I am trying to create a portal in the Music Schedule db to view the following in columns. Service Date Prelude Offertory 1/1/204 John Doe Mike Jones I really would like the prelude and offertory to be the same field from the Music Schedule line item table so when doing searches, I can do so in 1 field. How do I view the same field under 2 columns and yet tie it to 2 different categories without having it display in 2 portal rows with the same date? Thanks for you…
-
- 2 replies
- 636 views
-
-
I call a set of records in a portal by defining the rel Date::Date , having a global that allows me to enter any date I want. Here's my problem: Once I have all of the records defined, I would like to filter more specifically, and to perform some calculations off of the displayed records. For instance, I would like to display in my portal records that are from one day (Date::Date), but filter those to show only the records that are in a specific facility (Location::Location). Is there any way I can use multiple relationships to do that?
-
- 3 replies
- 937 views
-
-
We are using a popup list field that has more than 1600 part numbers in it. We are having a problem using this kind of field on Windows in a type ahead mode. That is we want to be able to type in the numbers rather than select them from the menu. On Macintosh this fields works just fine, in two ways. First is that after tabbing into the field, you can type and the list selection type ahead will begin selecting the correct item. Unfortunately, with such a long list and six digit numbers, one seldom finishes typing the entire number. The second way is by pressing the "Enter" key (not the "Return" key). This changes the field from a pop up list to regular type in…
-
- 1 reply
- 818 views
-
-
I posted this message in the FMPro 7 General Forum as well.... I am not using a script to create the new portal records so I cannot use the Exit Record command and I've tried using a calc field behind the portal and that does not work.... I am displaying a portal window, which when a line item (UPC) is entered, it (the UPC field in my Items DB) does a lookup of an inventory item (in my Inventory DB). When using the [Full Access] log-in, the portal window refreshes after each line item is entered accurately displaying the new line item. When using any other account access (i.e. Data Entry only), the portal window fails to refresh automatically after each line ite…
-
- 3 replies
- 855 views
-
-
Only the first row of my portal row (red text) is giving the right calc I tried a refresh - any ideas anyone? Thanks portal_prob.zip
-
- 9 replies
- 1.1k views
-
-
Hi, Just when I thought all my problems had been solved forever... Enclosed is a small attachment that best illustrates my problem (if you run it but see no problem, please tell me anyway). My main file (Main.fp7) has a startup routine that executes a script to go to a layout in another file (Help.fp7). It goes to the layout in the other file, but leaves a visible reminder of the opening layout in the main file. It appears that part of the non-client area of the original layout has NOT been removed from the screen. I can find nothing regarding this in the product errata. Has anybody seen anything like it ? {FM Developer 7 running on Windows 200…
-
- 4 replies
- 989 views
-
-
Hi, I have a clients table (and layout) in one file and a contacts table (and layout) in another. On both layouts, I want a button to ADD various details of the record to the other table, so that name/address details will be copied across (or updated). I tried relating the tables through ID and using a lookup for the fields to be copied, but get the error 414 (layout cannot display the result) if I try to "Go To Related Record" in the other file (wrong use of the command !). Intuitively, the tables should be related to make copying easy, but I can't see how best to achieve this between the 2 files. I suppose the problem can be summarised thus: Q.…
-
- 2 replies
- 964 views
-
-
I have a order entry database. The original programmer (a long long time ago, in a galexy far far away...) decided to use repeating fields (see another universe). One of the repeating fields is a part number. The objective is to write a report that will give the count of orders that use that part number. I have a field "Count of Orders" that is a summary count on "sales order numbers" I create a layout that shows the part number and order number. Then I have a Trailing grand summary that has the count. However that will only count the found records. So I tried to use the "subsummary when sorted by:" Part Number but that did not show ANY Counts. …
-
- 2 replies
- 874 views
-
-
I have a global variable set for the months of the year with values of JAN, FEB, etc. I'm displaying them as checkboxes and want to make a button that can select/deselect all months. Any ideas?
-
- 4 replies
- 864 views
-
-
OK I am having trouble setting up a value list as follows: It is for a list of computer components (A long varied list) I would like the user to be able to select the type (monitor, printer, scanner etc.) then the next box will show all matching manufactures of that product (HP, Panasonic etc.) then finally they get a final box that contains all the models that match both type and manufacturer. Thanks
-
- 8 replies
- 1.4k views
-
-
I have a button placed in a portal in layout mode, which duly appears alongside each record in browse mode. I want to attach a script to the button that opens the relevant record in a new window using another layout, but no matter which instance of the button I click my script just opens the record from the first portal row. Any idea how I can make the button relate to the record contained in the same row?
-
- 2 replies
- 1.3k views
-
-
I currently need my layouts and reports to start a new page when the text I write in text boxes in the body field overuns the size of the A4 layout. Nearly all of the reports I need to create in filemaker need alot of accompanying text to go with them. This means that being restricted to one page for my outputted documents like estimates isnt a desirable situation. Does anyone know how to achieve multiple page reports and layouts that relate to single records, I'm stuck................. Thanx Ash
-
- 1 reply
- 1k views
-
-
How can I make it possible to enter time in a field as such; 1.15 for an hour fifteen minutes without getting the box that says I have to enter time as 01:00:00? Help! I frustrated.
-
- 1 reply
- 930 views
-
-
<< STD DISCLAIMER FOR HAVING HAD A FRONTAL LABOTOMY >> I execute a script in file A, that executes a script in File B to go to a particular layout (in file :. It appears to work okay. If I then add a line in the script in File B (after the Go To Layout line), to execute a script in File A, it does not go to the layout in File B, but stays where it is (in whatever layout I was in, in File A). Could someone please explain the underlying design feature of FileMaker that is causing this. I would love to know, because my only alternative at present, is to duplicate numerous scripts in all the files I am using. Thanks in advance. Roger.
-
- 4 replies
- 1k views
-
-
I've been lurking around for while digesting things here in the forums. I finally have encountered a problem that has me totally stumped with FM7 and it deals with summaries and layouts. I have a table of records, call it Table A, which contains "call" records each stamped with call creation dates and account IDs. I am trying to create a summary layout which will show, for a given date range, a single line summary that looks like: Date Total Calls Account #1 Total Calls Account #2 Total Calls Account #3 In other words, no detail records, just summary. Almost like a pivot table view. I can easily generate a detailed report that lists the detail …
-
- 4 replies
- 1k views
-
-
Whats the best way to keep a current running total across records when entering information in a different table? Confusing description, I know. I have a data entry table and a data storage table and the storage table stores the actual line item records created in the entry table. So I'll only see one record in the entry table while I have 10 created (from new line items) in the storage table. It would be great if I could see the running total of the records in the storage table while I am adding new items (to the layout that appears in the entry table). I have tried a summary field for the other table but it only shows me the current total for the page i'm on, and not al…
-
- 7 replies
- 1.1k views
-
-
Why does FileMaker, even in version 7, continue to use the old style radio buttons, check-boxes and drop-down menus from the "Classic" Mac OS's. Under MacOS X the style of these things changed completely, and FileMaker's own GUI does use the new Acqua style. So why aren't these styles available to database designers? Or are they available, and it's a setting I have somehow missed? cheers, Richard
-
- 1 reply
- 827 views
-
-
I currently have a layout based on a 'Membership' table. I have a portal in the layout, which displays parts of a letter I have sent to that member. I have a button that, when clicked, takes me to the full record of a given letter. Fine so far... However, on my layout, I want to only show one particular letter at a time. To try and achieve this, I've set the portal to only display one row at a time and I've used a script as follows: Go to Portal Row (Select) This works fine - I type in the ID field of one of the letters and it highlights / displays that record in the portal. HOWEVER - if I click *out* of the portal, it defaults back to the first record…
-
- 1 reply
- 722 views
-
-
Hi ! Let me start by saying I'm totally new to FM and have only "watched" a couple of tutorials. I have no experience in db of any sort. Anything to get started, right? I have now made my first database and have gone to an extent where I have many tables with many fields and many, many inconsistencies... How would I make a value list display only certain records from a table. I mean, i.e. I have a table named AGENDA, where I stored CUSTOMERS, SUPPLIERS and EMPLOYEES, then I have the field EMPLOYEES in the table INVOICES where I would like to show only the employees and not the customers and suppliers, so I created a Value List from the field AGENDA ID so a pop-u…
-
- 1 reply
- 732 views
-
Recently Browsing 0
- No registered users viewing this page.