FileMaker Interface Features
-
Hi All, This is my first post on this forum. Is it possible to get a list to pop-up based on another list. What I have is as follows: Manufacturer eg Sony which in turn has many models So, if Sony is choosen from a pop-up list (Manufacturers)then another pop up appears (models) with just all the models for that particular manufacturer. Any help would be greatly appreciated. Thanks Paul
-
- 1 reply
- 817 views
-
-
I posted this a few weeks ago but really had a chance to look into the problem so lets see if I can be a little more descriptive. The problem: Blank records are being created in a database(this should not be happening). Background: I have sorted through some things and found that the relationship between this database1 and database2 is an(=) and has the checkbox "allow creation of records into this table via the relationship" under database2. However when I uncheck the box I am no longer able to use the dropdown box (as in it becomes unclickable)on the database1 to see the files of Database2. Question: Is there a way to set this relationship up to still …
-
- 2 replies
- 918 views
-
-
Can the web viewer be used to track packages from United Express? http://unitedexusa.com/ Thanks in avanced!
-
- 3 replies
- 1.6k views
-
-
I have created a report that has a portal within. I set the portal to 1 to 30 records. Most of my records have less than 30 records for the portal section. Is there a way to have the report print only showing the populated records within a portal?
-
- 1 reply
- 890 views
-
-
Question says it. I'd like a button to open a new window of a different layout than the one the user is currently on, but of the same database. Is there a way to do this? nm. Found it. All My Best, Jeffrey
-
- 1 reply
- 769 views
-
-
Hi, I'm pretty new at filemaker and I am having troubles with scripting. On my 'Main Menu' layout I have 3 'menu buttons'. Each button is a general category of the 3 areas of the database. Each category has different layouts depending on what you want to do. What I want to do is when you click a 'Menu button' a set of 'layout buttons' will appear. The 'layout buttons' will re-direct you to a layout you select to add records. Example: 'menu buttons' = production, quality control, and inventory. 'layout buttons' for inventory: view inventory, edit inventory, add inventory ... 'layout buttons' for production: orders placed, stock on hand ... …
-
- 1 reply
- 918 views
-
-
Hi, FMP Fans! I have a Table that contains a date Field, among others. Whenever a new record is created, the date automatically fills this date Field. I would like to create another layout that shows how many records were created today and for each day of the past week or two. Preferably, this would look like a bar chart. How can I create this layout?
-
- 1 reply
- 942 views
-
-
Hi, I have a htm file (File.htm) published by another application on a networked server, called "server". I want to view these htm files in the webviewer in Fmpro, however, I do not manage to get the correct URL in order to get these files into my webviewer. URL if file on own HD: "file:///D:/HTLM/File.htm" URL if file on networked server: ?? Can anybody help me in this? Patrick
-
- 0 replies
- 1.1k views
-
-
Also, it is a app for a print house. In the table A i must make calculations for the print cost. In the table B i have papers. 15-20 paper manufacturer. Every manufacturer has a couple kind of papers, and the papers have various weights. Its should bee possible, in table A field 1, to choose all of the manufacturer. Then in field 2 (table A) should be possible only to choose papers that are provided by chosen manufacturer in field 1 that display values from records in table B. In field 3 (table A) should be listed only the paper weights for chosen paper manufacturers and chosen papers from records in table B. When all fields are matched, then are tables A and B related, s…
-
- 1 reply
- 859 views
-
-
Hi, Hopefully this will make sense and be easy to answer. I am creating a schedule in FM for our employees. Due to the nature of our business, there can be any number of employees on for a given shift (from 1-20 people), as well as multiple shifts per day. I would like to set everything up like a spreadsheet, each person in it's own field. I would like to have, by default, 4 spaces for personnel with the ability to add more as necessary for that particular day. I was thinking along the lines of a button to add another row and a button to move to the next day. Another option is to automatically have one blank field following the full ones, and when that is f…
-
- 1 reply
- 764 views
-
-
Hello oh mighty ones. I have a layout with a portal. The portal shows 2 occurences with 2 fields each. How can I make sure that ALL occurrences of the portal are printed? IE if theres 5 I want all 5 on the printout... Can it be done oh powerful ones? Spongebob
-
- 10 replies
- 1.4k views
-
-
I know I should know how to do this, especially since I've done it in FM 5.5. I have a portal displaying on a page. I want to be able to hit a button and add a record to the portal. Previously in 5.5, I had relationship set up which was a field with a "1" in it relating to a field which I would do a set field to through the relationship to that field. This is odd, but would create a new record and enter the data I specified in the set field every time I hit the button. I can't get this to work in 8.5. Is there a new/better/different way to do this? Thanks, Mike
-
- 5 replies
- 1.4k views
-
-
I'm trying to use the web viewer to show directions from one customer record to the next customer record. I have the string that will map two sets of information and show the driving directions in the web viewer(by google maps). But I'm struggling with getting the info from two seperate records into the string. I want to use a calculation that will pull the info(address) from the previous record and put it in the current record, so I can use the info to fill the string properly. The person using the directions will always go from the previous record to the next record when driving (it is a found set that is sorted and printed) I'm hoping that there i…
-
- 6 replies
- 1.9k views
-
-
Hello! My colleague cut and pasted some data into my database. This means that I have some data in my default font, and some in a weird font from the internet. Is there a way to unify the font across all the records in my database?
-
- 2 replies
- 984 views
-
-
Hello, I'm having a problem with a custom portal sort. The sort is based on a value list that is made up of related records from another table. I have created a table of Shakepearean productions. On the main layout is a portal that contains a list of actors and the characters that they play. For example in a production of Shakespeare's 'A Midsummer Night's Dream' I have a list of actors playing various roles including Hippolta, Oberon, Theseus, Titania etc. I want to show the actors that play the most important roles first so I have another table where each record contains a role name and a play id that is used to link it with records in the table of production…
-
- 5 replies
- 1.1k views
-
-
I'm working on my first FM DB and am trying to setup a DB that will pre-populate a field based upon what is entered into another field. For example, I want the DB to fill out the name and address fields based upon what is entered into the 'type' field. So, if I enter "Water" in this field I'd like all of the address information automatically entered, but remain editable should I wish to make changes manually. My tiny FM app only has one DB. I hope that makes sense. Any suggestions would be appreciated. ~Steve
-
- 2 replies
- 930 views
-
-
Hey everyone, I am creating a quote output for my customers. Is there a way to make a "boundry" line vertically across the body to seperate different fields. It seems like it would be pretty easy but I can't get it to work in preview mode. I eaither can't get it to cover the whole space or it will not show up because some of it is not in the body. I know about the Set/Sliding Printing, but it seems to only be able to slide upwards. Slide down?
-
- 1 reply
- 850 views
-
-
can users of a developed filemaker file make his custom reports that have grouped and summarized any way he wants, is there any sample likes this? database has 10 tables, each table has 40 fields, and fields can be combined and make many reports with grouped data from any other fields. 400 reports must made, if developer wants make reports himself.
-
- 1 reply
- 776 views
-
-
When I changed the data of related fields (Date, Code Number or Firm) The records of portal disappeared How can I solve the problem? Thankz Study_Portal.zip
-
- 5 replies
- 1.2k views
-
-
Can anyone tell me whether it is possible (and how to do it, of course -)) to insert links into a FMP database that then bring up a particular point in the document. At the moment it's a word doc - about 25 pages long with explanations of the rather technical clinical terms that crop up in the database and it would be very helpful to provide a 'help' button next to these terms to minimise frustrations on the user side. I've looked at inserting a container field but can't see how to get to a particular sentence in the document. Any help/ suggstions would be gratefully received. (I'm using FMP-8.0, by the way) Many thanks George
-
- 1 reply
- 975 views
-
-
Using FM Adv. 8.5 I have two files: UI_file.fp7 doclib.fp7 I want to provide users a way to assign publishers and authors to a document from a list of each. The list should dwindle based on already assigned authors or publishers. In the UI file I have a pop-up with portal showing the list of not-related publishers (for example). This is working and is based on a List() function calc in the doclib file. As this number of rows in the portal grows I'd like to be able to filter this list using a VL (A-Z). The attached screen shots show the TOG, the pop-up picker window and the relationships. There is a separate pop-up for authors and publishers. …
-
- 2 replies
- 931 views
-
-
In FM 8.5, I can't figure out how to show the number of portal records found. I just want a count of the related records!
-
- 6 replies
- 1.6k views
-
-
Hi you guys no clue yet about IWP access has no access to files referenced in container fields ? please a help would be nice! tanx palomendes
-
- 0 replies
- 818 views
-
-
Hello does someone knows how to avoid the presentation of those records not acessible to user, after a privileges verification. I need that the user only gets the found set of the records he/she can access after the privileges verification. tanx
-
- 11 replies
- 5.9k views
-
-
HI, I am trying to put together an inventory solution that handles unique and non-unique items. The items are computers with unique serial numbers but have non-unique attributes such as family, model, memory size , hd size, processor speed, condition grade, and operational status. The unique computer records will also have child records of the parts INSIDE that computer which might need to be repaired, or exchanged with a similar part. The child part records are also unique. I need to show the origin and the end-disposition for each unique part: for whole machines that would be origin=Purchase Order number, and for end-disposition=Invoice number. …
-
- 3 replies
- 990 views
-
-
Hi, I currently have a portal filtered by 3 different criterias that go from global fields on the parent side to the child side. The interface and the data is also seperated out into seperate files. The globals reside on in the interface file. So the filtered portal is working but the user also wants the ability to perform finds. Since the filtered portal can not be used to perform finds because of the multiple key relationship, I am assuming that i have to have them do a find on another layout that has direct access to the other data correct? Has anyone ever created a filtered portal with the capability to do finds as well? Any recommendations or tips?
-
- 2 replies
- 1.1k views
-
-
Hello im having a valuelist + calculation field issue. When I change information in my valuelist field (in a portal) my calculation fields not updating unless I click on a blank spot on the record. As you can see in figure 1 (image below), I have a field that shows how many related contacts are per location (in blue and underlined). The formula im using for that is: TextColor ( TextStyleAdd ( "Related Contacts (" & Count ( CustomerEmployeesBYVendorIDLocationID::RecordID ) & ")"; Underline) ; RGB ( 0 ; 0 ; 255 ) ) and I have a portal where I can view All contacts (related of not) and I can chose what location by a pulldown menu that contac…
-
- 2 replies
- 1.2k views
-
-
I have viewed the tutorial files on Related Fields Pt 1 and Pt2. The problem I am having is that I only get the first name to show in the list of customers full names. How do I get the other names to show? I have viewed the videos about a dozen times and must be missing something, but I sure don't know what it is.
-
- 7 replies
- 1.2k views
-
-
First, hello to the forum. I have a problem and not sure this is the right place for the post but I'll ask anyway :. I have a database wich stores traveling info needed for expense tracking, it has: no., date, name of the person who travels, costs of the trip, dates of arrival and returning, etc. There can be many such forms throughout the year. In my country we have to submit a summary of all these forms in several sheets of paper at the end of the year. So what I'm trying to accomplish is getting all those records to print like so: page1: header, 25-30 records, footer page2: header, next 25-30 records, footer and so on... What seems to bother me is…
-
- 2 replies
- 791 views
-
-
improvments over the network a shared network directory in a separate server, permits file references to files in that folder, and the Filemaker clients can access the files. But in the browser using IWP still no access. Can you help on that Gurus. tanx palomendes
-
- 0 replies
- 805 views
-
-
PLEASE HELP is there a way for users to see and get the files linked by reference incontainer fields. Till now from remote client access over the network or by IWP i find no way for users to get the reference files, normaly pictures in my case. tanx to all palomendes
-
- 1 reply
- 742 views
-
-
Hi All. I am new to the filemaker world and would appreciate any help received. I have a layout as follows: Entity -State/Prov --Vendor1 Total_Payment --Vendor2 Total_Payment --- TOTAL_PAYMENT_PER_STATE -State/Prov 2 --Vendor Total_Payment . . Enitity 2 -State/Prov --Vendor1 Total_Payment --Vendor2 Total_Payment --- TOTAL_PAYMENT_PER_STATE -State/Prov 2 --Vendor Total_Payment ...and so on The form layout is using the vendors table which enables me to get the vendor, state/prov, and entity which is then sorted by entity, state/prov. T…
-
- 1 reply
- 724 views
-
-
Hey there, sorry but I have no idea where to post this. I recently discovered this website Qunu.com. If you need help, or better even, if you like to help people, check it out. Its a way give (and recieve from) live help to people. It would be great if a few Filemaker experts could join. Thanks
-
- 1 reply
- 1.1k views
-
-
I have a web view set to a custom web address - which is HTML that is contained within a field. The web viewer setup looks like this: "data:text/html," & Stats::html_final (where Stats::html_final is the html code) This works on my Mac, but not on my Windows machine. What do I need to do in order to display HTML from a field in Windows? (I have Win 2000) Thanks, Tony
-
- 1 reply
- 1.2k views
-
-
Is there a way to display portals rows horizontal instead of vertical?
-
- 3 replies
- 961 views
-
-
I've attached a sample file to show in general what I'm up against. So let's say you have two tables, the parent table is books and the child table contains all the proposed titles. So you have a layout showing records from the parent/books table with a portal showing all the related records in the child/titles table. Now, what I need to do is have the ability to select which title is current so we can retain the list of all proposed titles but track which one we are currently going with. So that boils down to a primary key of sorts in order to make sure only one title is selected as current. So that's what I have in the sample file. The only…
-
- 2 replies
- 798 views
-
-
Hi, I'm new to FileMaker. Is it possible to reference an image from the web? In the table, there's a PhotoLink field and a PhotoContainer field which is a calculated value from the link. I haven't found a function doing so and I don't know how to use Insert_Picture to place the picture in the container. I'm using FMP8 advanced. Thank you for your help. Nick
-
- 0 replies
- 731 views
-
-
Helvetica has always been the default font for Filemaker. Is there a way to change this default?
-
- 2 replies
- 1.2k views
-
-
In filemaker 8 is it possible to set up a tab control, then flip it on its side? I can't figure out how to do it, and it would seem silly if filemaker didn't allow this.
-
- 3 replies
- 1.6k views
-
-
Hi dumbo question (its the simple things in life that are challenging): I have a layout with a header that has my "Navigation Buttons" that you need to navigate my app. The Body has the fields. The navigation buttons are set not to print thru the sliding/printing dialog. When I print a record, a large gap is now left on the paper at the top where the header is. Nothing is in it as i told the nav buttons not to print. Question: Can I avoid that gap, ie not print the header at all? Thats what I want if poss without creating a special "print layout" without the header because I actually have 40 layouts like that. Any ideas? Can it be done oh master…
-
- 12 replies
- 1.4k views
-
-
I have a scheduling_table::Instructors, scheduling_table::time and scheduling_table::date_calc (dayoftheweek) scheduling_table::time is 26 time slots from 8:00 am to 8:30 pm in 30 minute increments for each day of the week. Not all instructors are available for each time slot for any given day of the week. I would like to create a limited value list for scheduling_table::Instructors defined by a particular time value in scheduling_table::time and scheduling::date_calc (dayoftheweek), so that at say 8:30 on Tuesday, Bill is available, but not at 9:00 on Tuesday because Bill indicated this in instructors_table:: .... I know I can use calc fields to…
-
- 6 replies
- 1.1k views
-
-
-
I have two lines of text on a layout, both containing merge fields. When I add a tab stop to the text, it affects the text alignment of other objects on the layout. Has anyone else heard of this problem? I've tried creating a new layout, with same result. Also tried doing a recover. Using 8.0v3 Advanced on two different computers.
-
- 5 replies
- 1.2k views
-
-
Sorry I do not know where best to post this. Also I have done a search but not found an answer to this one. How do I stop my users from using ctr-tab to flip between available windows. TIA Phil
-
- 8 replies
- 1.3k views
-
-
Hi, FMP Fans! I've got one for ya: Setup - Two Databases (Employee and Bug) - Records in the Bug db have an Employee field - This field uses a Value List that looks at the Employee field in the Employee db via the "Use value list from another file" Value List option - The Employee db has a field called Status that is marked either "Current" or "Former". In several layouts and Value Lists, the Employee db shows only "Current" employees by scrips that run a find for "Current". Question Can I have the Value List in the Bug db show only "Current" employees so I don't have to maintain two Employee Tables in both databases?
-
- 4 replies
- 1.8k views
-
-
I tried searching for this but came up empty so I appologize if this topic has been discussed already. Is there a way to disable a users mouse wheel to "scroll" through the records in layout mode? I can see that it would be very easy to accidentally change the record during data entry. Any help on this would be appreciated.
-
- 4 replies
- 1.2k views
-
-
We have several Databases, (Orders, Contracts, Engineering Tickets, Contacts, Quotes) We have buttons on the main screens for every database layed out. The problem is, There are too many buttons, valuable space is wasted on these buttons Currently, I have removed some buttons for performing finds. And created a field, that the user selects a drop down of what they want to find, and press "Find" Issue is, thats an extra step i do not want for these main database buttons. I want to know if I can create a popup field. that when the user selects the name of the database, a script running in the background will perform the selection. Without the user p…
-
- 1 reply
- 727 views
-
-
Just winding down a FM project. The idea is to spin it offf as a stand alone application PC & Mac. So, after doing all the development on my Mac, I tested it on the PC. Looks terrible. Seems the PC doesn't come out of the box with Helvetica. The entire interface is helvetica.. Arrgh! Is there a best choice for a font that works cross platform? Can I bundle some helvetica font with an installer? I'm sure I'm not the first to run across this pothole. Any hints? Please? Many thanks in advance! -jim lee
-
- 5 replies
- 1.6k views
-
-
I'm using a database wich intends to serve as correspondance (mails letters etc) aplication. It was incoming documentation and outgoing documentation. I've created a field in "incoming table" to validate the department where the original is going to, and created a [color:red]checkbox set with several entrances to sign all those departments who have cc of the incoming item, and should only view the record not edit it. in privileges area i can give access easily to selected users to see the record where the their department is in the field wich has he original, but i cannot give access (view only or any other) to all the departments wich belong to the checkbox can …
-
- 8 replies
- 1.6k views
-
-
hi all, i'm inputting data from a survey of visitors to a store. one of the questions asks which items they preferred over others--visitors can select none, one or more or all. this requires a CHECKBOX value list. i want to create a summary of how many check marks every item received. how do i do this? essentially, i want to create a count/summary of occurences of each item in a value list. how do i do this? thanks so much!!
-
- 1 reply
- 911 views
-
-
I'm trying to set up a check box and timestamp feature to the database so we know when things moved from graphics into production or in production to shipping, like that. What I'm trying to do is when one of the checkboxes is clicked it updates a timestamp for that specific job (Going from graphis to production). I've tried a few things and I can't seem to get it, all my timestamps update together. I know I'm missing a step in here to seperate them but keep them on one page. Help?
-
- 8 replies
- 2k views
-
-
Is it possible to move a field to another table after its been created and assigned to a certain table? The reason I'm asking is because when I made the current database I'm using, I just put every field in one table, and now I'm wondering if it would have been more prudent to divide my fields into several tables. (Right now I have like 85 fields in one main table).
-
- 2 replies
- 780 views
-
-
I have a script that populates a field with HTML and then web viewer will display the page. However, there is a slight delay in the web viewer displaying the HTML as it should - so it displays the HTML as text in the web viewer window. While it only displays it for a half-second, it will be annoying to my clients (as it has been annoying for me). I have tried to freeze the window until the very end of the script, and then I do a refresh, but it still shows up. It also happens as I scroll between records (as the HTML field is a global field) - so is this just a web viewer glitch? Any information is appreciated. Thanks, Tony
-
- 2 replies
- 1.6k views
-
-
Ok here a sample file of what I am trying to do. In the Routing table it is a list of parts and in the Routing Data Table contains steps these are master files that are for initial building of the traveler tables. These are like MASTER RECORD for each part number. The Traveler table get its the information first by typing in the work order pulling the Item number then based on that number it pulls routing header information from the routing table. Information is changed in the traveler table it is not reflected into the Routing Table. Like wise, once a traveler gets the information once from the Routing Table, changes to the Routing Tables do not modi…
-
- 3 replies
- 1.1k views
-
-
I'm creating a 'standard' set of buttons to go on all layouts (navigation, return to menu etc). In the past I have simply added the graphic elements or images to each layout. However, on this particular project some users will be viewing the database (as a Filemaker client) over a VPN link, hence speed is a major factor. If I use global fields to store the graphics and use these fields as my buttons, will this increase the speed for the users? I guess what is mean is, does Filemaker 'cache' images in much the same way as a web browser? Anyone else experimented with this and have any test results to share? Thanks
-
- 2 replies
- 1.1k views
-
-
I would be grateful for any help/suggestions from all the afficionados out there. I've just started using filemaker and am making my first layout. I'm trying to make a button within filemaker that will link to a powerpoint presentation that's also on my hard drive. Is this possible? How can it be done? Thanks so much for any help.
-
- 4 replies
- 929 views
-
-
I have a Contacts Database that I have several different Layouts for data Entry. How can I make a specific Layout be assigned to default for a certain record? For Example if I use Layout #2 when I create a record, when I open that record in browse mode, I want it to open in Layout #2. HawkLA
-
- 1 reply
- 1k views
-
-
Hello, I wasn't search which forum section to post this! Here's my question: Most Dell mouses nowdays come with a small middle "scroll" section, that allows users to easily scroll through documents. However, in Filemaker this can cause BIG problems. For example, if you are inputting data into one record, and accidently hit the middle scroll on the mouse, you could be entering data into the wrong record, and not realize it, because you had accidentally scrolled through several records records without realizing what had happened. Does anyone know how to disable the "Scroll" function in Filemaker, so that if you hit your mouse the wrong way, you won't acc…
-
- 2 replies
- 835 views
-
-
TO start I am a complete Filemaker database noobie. So please bare with me. Background: We have a database set up for intakes at my business. That database draws contact information in a drop down box from another database. Problem: The people that use the intake database are altering and adding information in the contract database, when they shouldnt be. Questions:Is there a way to make the data from the contracts database editable in its own database so that it can show up correctly in the intake database. And make it so the changes made to it from the intake database do not change the information in the contract database. Or is there a way to make a f…
-
- 5 replies
- 1.2k views
-
-
I have been out FMP development for a little while so I am a little rusty. I am putting together a project tracking database. I have a main database, ProjectRequest, that has several fields that are integers that are codes to other tables. These codes are foreign keys in my ProjectRequest table. The actual description or name for these codes reside in the code table itself. Example: ProjectRequest has the following fields: PriorityCode StatusCode PriorityCode table has: PriorityCode PriorityName My problem is how to best display these fields on a layout. The code needs to be entered into the projectrequest:PriorityCode field but the user doesn…
-
- 5 replies
- 1k views
-
-
Hi there, I'm using a portal in my database which I wish to automatically populate with some data (roughly the same data is looked at for each record for which the portal exists). This data may be wanted to be deleted or changed by whoever is entering it however. I do have a value list containing everything I need to be in this portal. Would the proper way to go about doing this be make a script which, on creation of each record, populates the fields which the portal is drawing from with the auto-enter data? If so, how would this script work? Thanks a lot! Michael ps If you need to see my file to understand this better, let me know.
-
- 4 replies
- 1.1k views
-
-
This is a FileMaker 8.5 file that demonstrates some of the new features in FileMaker 8.5 in a real world scenario: Web Viewer and Google Maps API. You can find a lot of distances all round The World. This file is free and open source. Working Under: 8.5v1 Solution Status: Finished Pre-requisites: Author(s): INO Date: 03-10-06 Credits: Instructions / Other Info: Need Shell PlugIn (included) P.S. Try to put in [color:blue]Sample Files & Open Source Solutions Forum, bat that doesn't work for moment or : Happy WebViewering ino Worldwide_Distance_v1.zip
-
- 2 replies
- 3.1k views
-
-
Hi, I have a field - gender. I need to count number of males and number of females in the portal!! when i do count function it only read the first one in the portal. I want to be able to say Select Gender = "Male" and Count. what do i doo??? please help!?!
-
- 9 replies
- 1.2k views
-
-
Is there a way to take the contents of a container image from several records and display them as a grid? [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] In the example above each square is a container from a seperate record based on the results of a search query. If the results were more than would fit on one screen then ideally you could scroll down until the last record was displayed. Then you couldd click on any individual square to navigate to the "related "record." I have attached an image from an application that does this. The grid is dynamically generated based on the results of a search query of a total record population. …
-
- 2 replies
- 1.2k views
-
-
Hallo people, I have a set of records, where each record needs to be conected to a different set of records.(a subfolder of records in a record). How would you do this? I'm stuck!! Thank you in advance!! (this forum is saving me as I'm new with FM!thanks)
-
- 5 replies
- 942 views
-
-
our contacts database always opens up full screen (which on a 20" imac is a lot of white space) whereas our invoicing databases open up to approximately a4 size. can i restrict the contacts file to open much smaller? the empty file is here if somebody wants to have a look at it: http://www.redfacilities.com/fm/ContactsEmpty.fp7.zip many thanks max
-
- 3 replies
- 1.2k views
-
-
Hello All! I have a portal loacted on one of my files. This file is called "Addressbook" The Portal is supposed to be gettings it's information from the table in the file "ToDo" I have created a link going through the "Task" field joining up the two tables. Everything works fine when i click on the portal to add a new reccord. BUT, i don't want to do this. I wan't to go into the file "ToDo" and create a new reccord. But, when i do this, it does not appear on the Portal. How can i get it so that it will display all of the reccords found on that table? Thanks.
-
- 6 replies
- 1.1k views
-
-
Hi I think I being a bit thick but I am experimenting with relationships. I have a products table and a quotes table which I want to be able to add products to my quotes layout I beleive the best way to do this would be to use a portal and add products into this? Thanks
-
- 1 reply
- 757 views
-
-
When I run a script the tab view changes....I might be on the fourth tab when I start but when the script completes it will refresh to the first tab.....can't find any script commands to counteract this... thanks, Paul
-
- 4 replies
- 1.7k views
-
-
Ok so this is a two pronged question... prong 1 - When looking at the layout ruler...be it pix, inch, whatever, How do you change where that ruler starts for the layout... I ask this because I am an new employee and working with some existing files... some of the layouts start @ 0 some dont... how can i change this? prong 2 - in the same file i am trying to change the print margins for a layout... they are all set at .25...Now this is where i get concerened..I get the limitation warning for this configuration and i cant close the box... ie it pops up..i close it it pops up again immediately!! i get stuck in this loop and have to force quit out... Any taker…
-
- 1 reply
- 983 views
-
-
I was completely taken by the Google maps web viewer and how simple it was to add a viewer to a layout, match the Google address fields to my database address fields and have a map for every person's address in my membership database (being able to switch the view to satellite was a bonus - it showed that address USPS said was undeliverable was now a vacant lot :-). It did get me thinking about another useful addressing tool, - looking up zip+4 zip codes from the USPS website. The task is virtually the same - USPS wants three fields of information street, city and state, just like google maps. Unfortunately FM doesn't automatically give you the USPS field names to match …
-
- 2 replies
- 1.8k views
-
-
Still rusty on portals. I think these questions are pretty elementary, but they're beyond me and my Missing Manual. The db I'm developing is for a gallery, so includes contact information for artists and detailed entries for their works. 1. On the artist's rolodex entry, a portal shows a list of all works by that artist. A container field to the right of the portal wants to display the graphic included with the related record I'm clicking at the moment. Layout necessitates that the cotainer can't be inside the portal [to register, the repro needs to be 150 px tall]. It displays fine the graphic associated with the first record in my portal ... can I convinc…
-
- 4 replies
- 1.1k views
-
-
Hi All, I'm using FMP 8 Adv to create a new database that uses portals and have found a bug I had not experienced before. When entering data in a portal field, with a transparent background, all editable portal fields turn gray. The user ends up entering and editing black text on a gray background. I have been unable to fix this, except by adding a background color to the field. I don't want background color, since it I have alternating color bars in the portal. Is there any way to fix this bug? I am running 8.0v3 on OS X 10.4.7. I have not tried it on the PC yet. I welcome all suggestions. Thanks, - Miles
-
- 3 replies
- 1.3k views
-
-
I have a portal (lower half) and I would like to have the data shown in the portal always sorted by what exists in the "Title" field (upper left). What I would like to have is a search function the moment I commit to an entry in the Title field, so that it shows me in the portal below, other items with the same or similar names. I can then select the item row in the portal and have the upper half of the screen populated with that record. OR select nothing in the portal and start a new record using that title I entered, and hit the "New Entry" button to save it. What I'm doing is a database of Apple II peripherals and related items, by catagory, condition, …
-
- 2 replies
- 915 views
-
-
I am having problems getting JPG's to show up when I use HTML from a field in the web viewer. I tried using "data:text/html,....[field name]" as my source in web viewer, and it will load the HTML, but it won't recognize any jpeg's that I have in my FMP home directory. When I load the same html code from a file on my hard drive into WV, the jpegs work. I can get a successful result if I load the images onto my web server and put the full path name in the tag, but I don't want to have to be connected to the Internet for this to work. I have tried searching for the answer, but I can't seem to find anything... Any assistance is appreciated. Thanks, …
-
- 0 replies
- 1.1k views
-
-
Thought this may be of intrest to this forum. This example outputs html/flash files to your FileMaker application directory to display the charts using the webviewer.. There is no password on this file (is open source) Mortgage Amortization: http://www.swconsulting.com/whatwedo/filemaker/index.asp
-
- 0 replies
- 1.7k views
-
-
Disclaimer: I'm an Access person, but my boss set up a FileMakerPro 5 document/database to collect survey data, and now it's my job to figure out how to extract and slice & dice the data. We have over 50 questions that asked people to choose A, B, or C. A,B & C were entered in FMP as a value list, and each question was given a field with the person doing the data entry choosing the appropriate answer from the value list. Now I need to know how many people answered A, how many B, etc. for every single one of these questions. I'm trying to learn how FMP works, but the more I read the manual, the more I'm afraid it might not do what I need to do. I tho…
-
- 2 replies
- 1k views
-
-
I think I've really designed a bad database structure! I've been asked to create a database to store confidential information on students. The district already had a student management database which is structured so the data is stored in an admindata file and the user interface is accessed through a separate file. Following this structure, and not wanting to be responsible for making modifications another developers databases, I created a new file called Student_Info. This file contains one table and all of the fields are globals. There is only one record in the file. On the opening layout, the user sees a portal related to the admindata file which displays al…
-
- 3 replies
- 1.1k views
-
-
Anyone know how to obtain the URL of the page the user currently is viewing in the Web Browser, even if it can't be done automatically? Thanks, Steve
-
- 1 reply
- 1.3k views
-
-
Is there a way to duplicate a table and all the fields within it within the same file. start with: Table1 ... Table1::name1, address1 And create from this table and its fields: Table2 ... Table2::name1, address1 I am sure there could be piles of instances this feature would be extremely helpful..... Thanks
-
-
- 8 replies
- 2.6k views
-
-
I have been developing a db that generates a "purchase order". Everything has been great,with help from this forum, until the users asked for another item. We need to be able to list all the products that make up ABC product below the ABC Product Description. Currently I am using a portal that the users pick the products, this in turn populates a table that I draw from for various reports including a purchase order. I have been looking at sub-forms but unless I categorize every product (10,000+) I don't think it will work. I was thinking about multiple portals. Add another field to the details table and pull from that. Can multiple portals be u…
-
- 4 replies
- 1k views
-
-
Hi everyone, this is my first post. Here at work they forced us to change from Mac to PC (using FPro 7). We had a bunch of databases developed on the Mac. They work on the PC except for horrible printing problems. Most of the time what looks OK on screen prints out scaled way differently, with lots of stuff chopped off. My experience is that the first time I preview a report it looks OK. Then I print it, it comes out all screwed up and afterwards the preview on screen is all jagged and screwed up. Our PC-newbie systems admins set up a postscript printer for us to use so we could play with the scaling, but it still doesn't work consistently. It appears that FPro just can't…
-
- 2 replies
- 641 views
-
-
Lets say I have 4 tables. Names, Items, a Join table, and a global table for an interface. The basic relationships are Names to Join, Join to Items, and then an interface table with global fields in it to Names. There is a value list created that shows all the related records from Names to Join. In the interface table I have a global field that I want to use a match key to find all records in Name that have a certain item number. In the Names Table, I have a calc field that returns the value list items of the Join Item IDs. So for lets say Bob, I will get a result of: 5 7 9 10 So When I type 5 in the global field I should get Bob in the portal I have on…
-
- 4 replies
- 1.3k views
-
-
I have FileMaker Server 7 running on a Windows box at a remote office. In one of the databases I created a portal with a sort order that is controlled by a value list. The value list contains the following: Annual Dec Sep Jun Mar I can login to the FileMaker server, open the local FileMaker client and view the portal with the correct sort order. I can also access the database through a VPN using my Mac FileMaker client and see the portal in the correct order. What baffles me is that Windows clients on the remote office computers sees the same portal sorted alphabetically as: Annual Dec Jun Mar Sep
-
- 2 replies
- 775 views
-
-
Hi all, I've set the window size of my database using a script that runs on startup, but I'm now trying to figure out how to enforce that window size. Unlike the "Show/Hide Status Area" and "Show/Hide Text Ruler" steps, there doesn't seem to be a lock option. Anyone know how to do this? Thanks in advance for any help!
-
- 4 replies
- 6k views
-
-
Is there a way to specify as opposed to averaging (layout/arrange/distrib) the spacing between selected objects? I'm working on recreating a layout that displays small grouped tables in various areas of the page. I've kinda figured out that if I do the math and then position and lock the top and bottom objects in the group I can get pretty close to getting the space I want between my objects vertically. But that's time consuming, not exact, and that doesn't work horizontally since all the text objects are various widths. I've been using the T-square and object info tools, but that's also time consuming. And then if I have to make changes to the layout, I have to sta…
-
- 2 replies
- 1.2k views
-
-
I need to put the portal row number into a field so that I can export it. I cannot use @@ as whilst it gives each row a number, you cannot export it. The sort order will always be exactly the same. TIA
-
- 2 replies
- 889 views
-
-
Ok I have a portal that works great, it shows the user the information he needs to see. However the information is tied to timestamps dates which are required for a report. So i do not want the user to change the information in the portal just view it, so I locked the fields. I have a button that sets var. from the contact table and set fields in the call table with freeze window all that, and it works. My question is I'm trying to create another portal with one row so the user can click the new button and enter information into the 1 row and have the other portal just to see information it sort of works but the user can still change the info in the 1 row portal. …
-
- 2 replies
- 1.1k views
-
-
I want to copy a field in layout A and paste it into layout B and in the process, I want FileMaker to remember which field it is rather than pasting an unknown field. I am sure this was possible in v4/5/6 but it no longer seems to work in v8.5. Am I going mad or do I have a problem with my system (Mac OS 10.4.7)?
-
- 5 replies
- 1.2k views
-
-
I am creating a new window with specific size settings that closes when the user is done editing info. For some reason, it changes the size of the original window if it was maximized when the button to run this script is pressed. Any ideas?
-
- 2 replies
- 870 views
-
-
Hey Guys.... running Filmaker 8.5 Advanced. I'm trying to extract text from a web page using the GetLayoutObjectAttribute function, but I have having a lot of trouble getting it to work. This is the calculation field I am using" [color:red]outputtext = GetLayoutObjectAttribute ( "webbox" ; "content" ) as a TEXT result. As a text field I get no resulting HTML. As a container I get the resulting HTML source, but it is un-parsable. Should the result be a Container or Text ? What I am doing wrong ?
-
- 2 replies
- 2.3k views
-
-
I have a portal where I display the delivery addresses that have been used in the past for the current customer/dept. combination. Is there any way of filtering this portal so that any address only appears once no matter how often it appears in the relationship? TIA Phil
-
- 4 replies
- 870 views
-
-
Hi everyone -- in using Brian Dunning's excellent Chartmaker Pro 7 in my recently upgraded FM Advanced 8.5, I have noticed a lot of weirdness in trying to set field and rep widths. For instance, when Chartmaker calls for a rep width of 1 pixel, I cannot get FMA8.5 to cooperate. I have tried to mouse-drag the primary/left-most rep to 1 px, but the object size viewer only allows to 2 px... If I try to manually enter a 60-px width for a 60-rep field, it defaults to 61 px..? I thought zooming in, a la Illustrator and other graphics apps, would afford more precise setting, but not so... Any advice, or at least a witness!?
-
- 2 replies
- 772 views
-
-
Hello, I'm hoping that somebody can help me out. I have spent the last 2 days trawling through this resource and others looking for the answer with no result. I have produced a fm system for my my graphic design business. Its fantastic (the software that is, not necessarily my system) and has eased up the workload considerbly. However there is one area that needs attention, namely sales invoice statements. Basically I want to produce sales invoice statements for my clients that display the total of: 'Invoices that are Over 30 days due, Over 60 days due, Over 120 days due. The invoices at the moment capture the 'Total' and 'Issue Date'. I think that I shou…
-
- 0 replies
- 803 views
-
-
I recently started using the business productivity kit that you can download from the filemaker site my only prob is that the invoice only has 8 product fields, how do I add rows as needed. HELP. thx
-
- 12 replies
- 1.8k views
-
-
Is there a way of Selecting ALL in a TAB view to cut or paste WITHOUT selecting the tab...it seem like once I get all the fields in that the only way to get them all out if a "goof" occurs is to shift click them one by one....dragging multiple moves the tab view..and I can't unselect the tab view with a shift click. Thanks, Paul
-
- 1 reply
- 1.1k views
-
-
I've written a runtime solution that has two fields, TailNumber and SerialNumber. As it is, I have a Case calculation in the SerialNumber field so that if a user selects a particular tail number from TailNumber's pop-up list, its serial number autofills the SerialNumber field, e.g., selecting N908FX will autofill the SerialNumber field with MSN-114. The problem is, since it's a Case calculation it's "hard-coded" into the database so users can't enter new tail numbers where the serial number will autofill. So, is there a way I can get around this problem in the master file so it'll work in the runtime solution? As always, thanks in advance for your help!
-
- 1 reply
- 849 views
-
-
Hi, I'm having a real problem that makes my head hurt! I'm trying to set up a value list that uses values from a field - e.g. field1 = make of car, field2 = model, so that the value list for field2 depends on the entry (from a static valuelist) for field1. I've set up a series of global fields with all the possible values for field2 and defined a holding field as a calculation based on the value for field1. This seems to work in that the holding field correctly returns the values from the appropriate global field but it doesn't work as a valuelist in that it returns spurious values from more than one of the global fields. Can anyone suggest where I am going wron…
-
- 3 replies
- 853 views
-
-
Hi all friends I have a problem with the List( ) function of FM 8.5. The help on line says: List function Format List(field{;field...}) Parameter field - any related field, repeating field, or [color:red]set of non-repeating fields; [color:red]or an expression that returns a field, repeating field, or [color:red]set of non-repeating fields. So, if I have a field (FieldContents) with a calc like this: Let([ fieldNames = Substitute ( ¶ & FieldNames ( Get(FileName) ; Get(LayoutName) ) & ¶ ;["FieldContents¶";""]; [¶ ; " ; "] ); adjustedFieldNames = Middle ( fieldNames ; 4 ; Length ( fieldNames ) - 6 ) ]; list ( adju…
-
- 7 replies
- 1.1k views
-
-
These commands do not work!!! Select multiple objects - (If you press ⌘ while dragging, the selection box does not have to completely surround the objects.) Duplicate an object by dragging it - Option and drag the object These were directly from filemaker help. Neither works!!! Its been a year. Its driving me craZZZZy. I have deleted the prefs and reinstalled. Mac OS 10.4.7, Filemaker Pro Adavanced 8.5
-
- 4 replies
- 896 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online