FileMaker Interface Features
-
To begin with let me explain my situation: I have a tabbed layout that is used for data entry. There are about 20 tabs wich are used for data entry, before i hear some nay sayer comment about how that is stupid and/or rediculous and there are better ways, this is the way we are doing things we have 4 different kinds of change orders and its a much easier navigation situation to have them ordered in tabs for data entry then to use seperate layouts. My issue is this the information populated in theses tabs, has to be printed in a specific manner, we've created a print layout but cannot figure out a way to return to the tabbed layout and the specific tab you were p…
-
- 9 replies
- 2.9k views
-
-
Anyone know of way to get the table name of a portal the user is working in without being in a field in that portal? For example, let's say I have a button in the portal and I want to be able to tell what the table name is for that portal when a user clicks on the button. Why do I want this?....I want it so that I can write some generic code for use in all portals without having to hard code the portal table name into the script parameter.
-
- 3 replies
- 1k views
-
-
I am trying to use webviewer for displaying content of a directory. The "custom web address" is defined as [color:brown]"file://" & Project::Documents_folder_path It works fine on PC. I can see directory, drag-and-drop, delete etc. However, when using Mac, all I get in the viewer is "file is directory". I am not familiar with Macs. Maybe anybody can give my advice on how to fix this. Thanks.
-
- 4 replies
- 1.5k views
-
-
Hi, I am pretty new to Filemaker although I am experienced in developing for Access and SQL Server etc. Anyway I'm trying to setup a simple database to track backups using Filemaker Pro 8. I have two tables - called Media and Tapes with a relationship between the two through the MediaID field which I have setup to allow new Tape records to be created through this relatinship etc. The Media table also has a field called Media Label. I want to setup a layout for Tapes which allows me to create a new tape record with an associated MediaID but by selecting a Media Label rather than a Media ID in the layout. I have setup a value list for Media Label using M…
-
- 1 reply
- 908 views
-
-
Alô, I'm trying to duplicate a record in a layout that has a portal. When I duplicate the record the rows in the portal aren´t duplicated. I can´t figure out how is it possible to copy all the rows in the portal.
-
- 17 replies
- 2.3k views
-
-
I have a dynamic value list that's used in a drop-down list with auto-complete. My problem is that the auto-complete only works for the first 318 or so items. Anything after than and no auto-complete, even though the item is in the drop-down list. Any ideas? Thanks
-
- 0 replies
- 901 views
-
-
I have no idea what I did but I have managed to loose all my value lists. Is there any way to recover them? Or import them. whilst keeping the orginal names and references I have a back up copy of all value lists in another saved database but I am unsure on how to import them? I can use from another file but they do not keep the same name. Can anyone help?? Ben
-
- 2 replies
- 813 views
-
-
Hi everybody ! I am getting nuts. I have a list of records and also 2 portals for this record in the list view. well everything works well in brows mode. In preview and print the fields from one portal are misaligned. playing with the field size, moving them, add them one by one makes it print ok. But I never manage to put all field and buttons before this effect shows Please what is the problem :?
-
- 11 replies
- 1.6k views
-
-
I want to set up a portal to display lab results. New results are available daily. I want the top, horizontal line of the portal to display date (1 week's worth) and the corresponding results to be listed below (vertically). Any idea how to sort a portal by date displaying along the horizontal sxis? Thanks. Rick
-
- 0 replies
- 926 views
-
-
I am developing an order entry/tracking system in FM8 for a silkscreen/embroidery shop. Each order may have multiple styles & colors of garments, as well as multiple sizes with varied quantities per size. I'm trying to figure out what would be the most effective way to create the records for the styles/colors/sizes/quantities. Currently, I've got a table for the entire order and within that table is a portal with a record for each item. (Each item could be a different style or color of garment.) I have a description field which can contain the color and style of each shirt. For the sizes and quantities, would my best option be to have a separate field for each si…
-
- 0 replies
- 870 views
-
-
I've got a Client table with a portal to a Client Address table; it is linked by ClientID and AddressType; I limit the AddressType to three radio button options on the layout: Home, Work, or Other. The portal displays only one row on the layout. This way, when I click on the radio button AddressType, the portal displays the correct address, and if one of the addresses doesn't yet exist, it allows me to create the new address for the selected AddressType. My problem: I believe I am having a "commit" problem, as it seems that a new portal record does not commit unless I click somewhere outside any of the fields on the layout. The effect of this problem is that i…
-
- 2 replies
- 1k views
-
-
Has anyone, see a web viewer solution for currency conversion?
-
- 0 replies
- 1k views
-
-
My users want to sort a portal by any column. Easy I thought..... Make the title into a button and use it to set the value of a global field (in the same table as the portal) and set the portal to be sorted by that field. The field gets set by the button script but the portal doesn't change. I then added a refresh window step and it still doesn't work. I also flushed the cached data - still no good. Anyone know why that doesn't work? Most irritating!
-
- 5 replies
- 2.4k views
-
-
I have a date field. I only want dates entered by selecting from a drop-down calendar. I've tried turning off entry to the field and attaching script with: Go To Field [ dropdownField ] ... with and without Select Field Contents Nothing I can think of works. Unchecking 'include icon' allows the pop when field entered - but doesn't prohibit entry to the field. Once the calendar is open, I don't want them to be able to click again and end up in the date field itself. I haven't played with 8.5 yet - maybe GoToObject? But still, we are on vs. 8 and I want it now. Is there any way to pop that calendar via script? It must be something simple I'm missing. …
-
- 25 replies
- 3.4k views
-
-
Hi I've had a little search around but can't find a definitive answer to this one. Is it OK to set up a value list and receive entries to that list on the same field? It seems to work fine but just wanted to check that it was good practice. So when you click on the field you can either choose from the drop down list, or you can type in a new entry. When you move onto the next record the entry you just typed appears as an option. Hope that makes sense, Many thanks, Rosie
-
- 4 replies
- 977 views
-
-
I would like to create a report that will show related data. For example, I have a database (DB) that tracks websites. The DB has 4 tables; Website, Owners, FQDNs and Notes. I want my report to look something like this; ******************** WebSite - MyWebSite Owners - John Doe, Jane Doe, Robert Doe FQDN - www.mywebsite.edu, mywebsite.edu Notes - 10/05/06 Created a new page. 10/06/06 Deleted page. 10/15/06 Added graphic to main page . 11/01/06 Attended conference to discuss future changes to the look and logic of website. ******************** What would be the standard way for extracting the data from my 4 tables to get this type of report?
-
- 1 reply
- 821 views
-
-
Anyone with experience working with text characters in the private Hex range (2000+) -- Unicode or other -- able to tell me how to get them to appear in a field or in the layout? Thanks. Dan
-
- 1 reply
- 1.2k views
-
-
I have an application that goes to a web site and retrieves the unicode of a name from engish to Korean. I want to paste the Korean Characters (Han Geul its called) into a field. I can copy and paste the text from the web page and it shows up correctly. I can also successfully retrieve the unicode string (Eg. "찰레스 델프스") by extracting it from the source HTML. My problem lies in how do I get this into the field and displaying correctly. Thanks for Your replies Charles
-
- 0 replies
- 1.1k views
-
-
Hi all, My problem is when I soft by date, how I calculation the cost field / amount field *100 = My percentage field result. Thank for your reply! Soft_Report_Problem.zip
-
- 4 replies
- 1.1k views
-
-
Can someone help me figure what I need to add to this script or help me rewrite it to do the following: If you can see the script I need it to send an email (this works) then I need it to fill in current date and check the completed box (this does not work) Please remember this script step is in a portal. How do I tell the script to only fill in the date and check box of the portal row I am on? Go to Related Record [show only related records; from table:Policy_Notes_LB Etc...] Send mail to [Person in contact list] Go to Layout ["Policies"(Policies)] Insert Current Date [select; Polices::LB_Date] Set Field [Policy_Notes_LB::Completed_Chk;1] Set Field …
-
- 3 replies
- 936 views
-
-
Something probably very simple here, but if I can't put my finger on the solution. If sex is Male, then I want a specific layout to be shown (A male figure). Eg. User chooses Male, and then clicks a button to view a diagram. I want that diagram to be of a male. Same for female. Would appreciate any advice! Thanks
-
- 2 replies
- 1.1k views
-
-
I am trying to create a layout that will display the last seven records of attendance along with customer demographic information. I know how to get the records through a find, but I am having trouble coming up with a solution to display them. Oh yes, and I need the horizontal versus the vertical layout of a portal. It would look something like this. Name - Phone - att. record 7 - att. record 6 - att. record 5 - etc. The record would display whether they were present or not. Sorry if this is not clear, please let me know and I will try to clarify. Thanks
-
- 0 replies
- 965 views
-
-
I want to have a script that takes me to a main record (a random one), then it should go to the portal in that record (the portal are related records, each record having a date), create a new child record in the portal and put todays date in it. There doesn't seem to be a script command that allows you to create a new child record in a portal. If you're in the portal at the last record created you can do the command, go to next portal record, but if you're in the main layout you'll only get to the first portal record, not a new one. Thanks Mike
-
- 6 replies
- 1.1k views
-
-
Greetings all, I first have to say i love this forum. I have learned a ton just perusing everyone elses topics but i have run into a problem of my own. Its 2 fold and probably unrelated. First i am creating a Cost analysis worksheet in Filemaker and I have 3 different products and each has its own specific values (for example: cost per sq. foot is different depending on the product) I don't want to leave a field where someone has to type the correct value in. What i was hoping to do was create a drop down menu (value list) that would determine what value goes in the different fields. So i made the Value list but i have no idea how to get the relevant fields to a…
-
- 6 replies
- 1.2k views
-
-
[color:green]Here's a stumper for you. We are using filemaker 8 in a small office of 4 computers. One of our layouts imports media names from another layout as a drop down list. On the host computer, the alpha list stops around the S media. On all the other ones, the list is able to be viewed through Z. This wasn't always the case and we're not sure what happened or how to resolve! Any ideas on problem/fix? Much thanks.
-
- 6 replies
- 1.1k views
-
-
I have a value list containing clients. There is an edit option to add new clients as they come in. However, when they appear on the pop up list for entry into a timesheet, they appear in the order they were entered. Is there any way to have them appear alphabetically? Thanks in advance.
-
- 1 reply
- 943 views
-
-
We've got some buttons we've created in FileMaker that have little pictures on them. The pictures look good on a Mac but on Windows they dont' show up. Get a little white box with black message...but it's so small I can't read it. Any info on how I can fix this would be greatly appreciated. Thanks!
-
- 1 reply
- 1.2k views
-
-
-
I have a layout I use for printing, that shows nine or ten records per page. In the footer, I want it to say "Records 1-10" on the first page, "Records 11-20" on the second page, etc. I can only figure out how to insert the number of the LAST record on the page (using symbol @@). Sorry if this is really obvious, and thanks for any help.
-
- 8 replies
- 1.2k views
-
-
I have a database that is based a lot on portal filtering and summaries of these filtered results. The filtering seems pretty easy when everything you want to filter is in the same table. However, I have a couple fields in my portal which are calculations based on other tables. e.g. The portal table is Events, the other table is highlights. A field in the highlight table is Category. If the highlights table has more than one category (like presentation or recruitment) at one specific event, then the event portal under category will show the word "Various" as opposed to the singular category name. However when I'm filtering, I would like the ability to filter different cat…
-
- 2 replies
- 1k views
-
-
I would like to use filemaker to complete forms using data from each of my clients. The forms are available as PDFs, and I would like to ovelay each client's data onto the form. I tried to save the file as a jpeg using Adobe Acrobat standard and import the file into filemaker but the quality of the printouts is horrible. Does anyone have any suggestions on how to doing this?
-
- 0 replies
- 744 views
-
-
I have three repeating fields that contain name, address, and city state zip. There are 31 repeats. I want to be able to create a label layout and move these fields onto the label layout. Not possible that I can figure out. Please help!!
-
- 3 replies
- 881 views
-
-
Didn't see a specific category for this so I'll try it here. I have implemented the chart example from Filemaker's website into my own. It works great. I am using the pie chart. But it does not transfer to shared users. How can I get them to see the chart too?
-
- 3 replies
- 936 views
-
-
Hello gurus, I am trying to create a form which takes the free text input of a field from my database and prints it on the resulting page. The issue is that the field (text box with scroll bars) could have anything from a few words to a many paragraphs of data within it. When creating the hardcopy form, I am using mail merge fields to output the data and the part in question needs to be printed in its entirety, to be followed by other static data, which is then followed by yet more dynamic data. How do I get a field to dynamically resize and adjust the space required automatically?
-
- 1 reply
- 1k views
-
-
Dear all, I have a database which I plan to separate it into two different files. One files for all layouts and the other files is for all the tables. After that I will do the kiosk mode for the layout files. Is there a simple way of doing it while i still get to keep my scripts working properly? Thanks
-
- 2 replies
- 919 views
-
-
I would like to go to a layer that has a date from and a date to then click a button and a list of all the invoices between those dates will come up, can somebody guide me? Thanks, JBarber
-
- 4 replies
- 1.6k views
-
-
I am having trouble with data not coming through a many to many relationship to a portal. If this possible to do? Here is the scenerio: Lets say there are 10 items for sale are on consignment to a dealer. Information on the consignment is in one table and is assigned a line item. 5 of those items are bought by the dealer and invoiced leaving 5 still on consignment. A few days later the dealer buys the remaining 5 and another invoice is created. In the end I have: 1 line item 2 Join records 2 Invoices. My setup: There is a table (the join table) which keeps track of how many items from the line item went to an invoice. There…
-
- 8 replies
- 1.4k views
-
-
Hi, I'm trying to do a trick that was suggested by Helpful Harry back in 2004. The idea is to add a new record to a portal but not on the last blank line. Helpful Harry had found a way of using two portals based on the same related file, where one portal would show all records and the other portal would show only new records. He said that here were no buttons or scripts. He said that he had posted an article some place but I can't find it. Any help appreciated. Bobbby (P.S. I posted this about an hour ago, but can't see it anywhere on the board yet. So this is the second post. Please excuse me if I'm repeating myself.)
-
- 6 replies
- 938 views
-
-
I am doing an invoice and I want to have the client list on a drop down menu and then just select it, I have done it. But when I change the name of the client it does not update in the invoice, how can I get this done? Thanks, Juba
-
- 23 replies
- 6.9k views
-
-
Hi FM Community, I moved all our files from FM7 to FM8 and after that successful move I ran into an issue with our value lists. When I enter the values in a value list and then view them in field it cuts off the words randomly in the value lists. So in the Define Value lists I enter "Directory 08" and it displays "Directo" Then a little down in that list I have entries like "Jan/Feb", "March", etc. When it displays these values I get "Jan/Fe" "March", etc. The values are cut offs randomly, it is not a specific number of characters, or specific character or a space that it cuts off. Any one else having this issue? Any ideas for a solution? It seem…
-
- 2 replies
- 1.4k views
-
-
Hi I have 2 webviewer windows which i want to be able to print to one pdf. Webviewer window A will contain pdfs of varying page lengths - sometimes 1 pages sometimes 2. Webviewer window B will be the same as A but displaying a different pdf. Can you set webviewer windows to slide up based on content that way I can make the window 2 page lengths but if the viewed pdf is only one page filemaker wont print/pdf the second blank page. Or is there another way of doing this?
-
- 0 replies
- 1.1k views
-
-
I'm having some trouble displaying borders on my print layout. I have a attached an image of what I have done so far and what I would like to achieve. I need to display borders (like a table) but as some of the fields can contain alot of text or almost none, I have to resize the fields in order to print it. The resizing works very well, but as it's a A3 print, I need to include borders to make it more readable.
-
- 4 replies
- 1.9k views
-
-
Any help on this would be great, I'm stuck. I have a project table that connects to a location table with a join table. Locations can belong to multi projects. I then have a media table that connects to the project table with a join table. A single media file can belong to many projects. I have portals viewing and creating all these records...works fine. Now I want to be able to assign the media to locations based on the list of locations that correspond to the projects assigned to the media. I can use a global field to give me a drop down showing only the active project locations. But if I assign two or three projects to a single media entry (via Portals), I would l…
-
- 4 replies
- 1.6k views
-
-
Can anyone help? I have tried every kind of format, color, I made sure I have more records than lines and still cant see it? Thanks Greg
-
- 1 reply
- 849 views
-
-
I'm working w/ a database that i didn't create, originally. However, the Tabs don't work w/ IWP. I know that there are some hangups w/ Tab Controls in IWP, but i thought that they were suppose to atleast work as far as navigation from one tab to the next and displaying information. thanks for any help!
-
- 3 replies
- 1.6k views
-
-
Anyone know if the webviewer show pdf files already on your computer? If so what is the format that needs to go into the web viewer fields? Many thanks
-
- 1 reply
- 1.2k views
-
-
Just a thought can one remove the [x]close window box on win/mac, quite often users will click this thinking the newly navigated layout was a popup or new window, they click it to get back and obviously it closes the database. Just a thought.
-
- 9 replies
- 1.8k views
-
-
I have a portal in a Purchase Order Input layout that relates to an Inventory table. The inventory records have various item numbers, and each item number has size variations. When an item has a negative "Available" value, I want it to show up in the portal. The problem is that all of the size variations that are negative availble show, and I want only one of each item. In other words, I need it to function like a value list. I can create a value list and use a drop down list, but I prefer to use the portal if possible.
-
- 15 replies
- 2.7k views
-
-
Here is a question that has puzzled me for many a year but i have never thought of posting as i just thought it is too annoying to tackle. I like most break my data down into the smallest possible parts.. this is great for most kinds of report ... but ... the CV is as everyone knows a complex animal. I want to create a database driven CV. So I have several databases... Education Employment Press Publications Events Referees Now i need these all on one sheet ... oh and they all have different layout formats ... and every time i print it it changes... So do i have to create a CV database with multiple overlated layouts and import the …
-
- 20 replies
- 2.5k views
-
-
Hi there I have an Client layout with an portal with number of personal to do with the Client. On the portal row I have placed an Button with scripted to receate pop-up window where I have log on that personal But what is happening all the other personal on the portal seem to link to the same log! How do I create an new unique log for each personal? attached is the database (have look at the client layout and the portal) Looking forward to you throughs as I bit lost on where to go from here Kind Regards Damian BD_job_tracking_v4Clone.fp7.zip
-
- 4 replies
- 1.2k views
-
-
Hi there. I have an avery label layout which is working well, except for one thing. I have a combined "field" in the layout which is: Salutation & " " & First Name & " " & Last Name & " " & Professional Designation However, when the Salutation is blank, it leaves a space before the First Name. How do I get rid of it? Thanks!
-
- 1 reply
- 955 views
-
-
Hello, I'm trying to do two things which on there own are simple enough to do, but they don't seem to work together. The first is to filter a portal (in my case, I'm using ExplodedKey and ExplodedString as well as a checkbox set) and the second is to highlight the current portal row selected in my viewer table (see Viewer Table Demo from Foundation Database Systems). The relationship between my pref table and the portal_list table doesn't seem to allow for the filters to work with the highlight. Any thoughts? People.fp7.zip
-
-
- 8 replies
- 3.9k views
-
-
Hi I have this problem with retro fitting Combo felds with value list and using pop up list Attached is a clone of the data base My problem is that my data base is growing I can not remember by Client ID with Client name or Project name with project ID and reference. So what I am trying to do it use and Combo field with pop up list to get around this issues. But for example as you can see with the attached data base. With "Job instruction layout" I try to add an Combo felds with pop up list but it say "This action is cannot be performed because this field is not modifiable" or for the "Job title, project ID and Job ref" Combo it wont even show the po…
-
- 2 replies
- 1.1k views
-
-
I have a portal in my sales database for event registration (date, event, qty, payment info, etc.) The events field is a value list, drop-down menu with many choices. This is related to my contacts database. (One contact may register for many different events). First, I want to be able to find everyone who's registered for a specific event (ie "farm tour"). Pretty stright forward through find... Next, I want to list all of these participants in a report by last name. Again, pretty easy... The catch is, I can generate all of this, but end up reporting the first entry from each portal (which is not always "farm tour"). How do I get all of the "farm tour…
-
- 1 reply
- 868 views
-
-
Hello I've just started using FileMaker 8.5. I have a field in a table which is a Checkbox set. When the user enters data - they can select single or multiple items from the set. For example: Receipt, Invoice, Waybill. (This checkbox set is populated by another table with up to 100 records) The trouble I have is when I change to a print layout, the field displays the checkbox set with the selected items as well as the non-selected items - is there any way to hide the items that are not selected?
-
- 6 replies
- 2k views
-
-
Hi, I'm using filemaker 8.5 and I'm trying to get a layout that displays one of two portals conditionally. I'm working on a database for the lab that I work in. To do an experiment you can use either of two different mixtures. The layout that I'm working on is an overview of what was done. What samples were used, conditions, and the components of the mix used. So I made two portals to the two tables that store the two different mixture compositions. I stacked the two portals on top of each other. Is there a way to conditionally tell the layout to display this portal in front of this portal? And how would you set up the script to decide which layout to dis…
-
- 5 replies
- 1.5k views
-
-
Hello, When I am printing list of people in my database, I have address field which I resized to show 5 lines of address. But some records are w/o address, so when i print, there is free space. Is it possible, that the "body part" and field will scale automatically, so my list should be like this?}:| Name addressline1ifNotEmpty addressline2ifNotEmpty addressline3ifNotEmpty addressline4ifNotEmpty addressline5ifNotEmpty
-
- 3 replies
- 1.1k views
-
-
Hello, I need help with a portal that will update automatically every time users open the file. I am using a global field in table [To Do List] and a text Field with an auto enter calculation in table [To Do List 2]. This works fine if you update the Due Date Field manually. The problem is I have over 2,000 records in the table and this number is expected to increase fast. The idea is to automatically display records with the following conditions [Do Dates] < [Current Date] and incomplete tasks in the portal. Please advice me what will be the best way to accomplish this task Thanks. To_Do_List_Copy.zip
-
- 1 reply
- 1k views
-
-
I have recently upgraded from FMP v5.5 to v8.0. Former separate files and their relationships are now separate tables and relationships in one file. A few layouts that contain table fields and related fields behave differently when changing records. For example, in layout mode I set my "advisment" layout to view records from my "main_info" table. For some records in browse mode, it shows "main_info" data fine but will not allow data entry in related fields on the same layout from my "advisor" table. Other records show both field types just fine. When I switch the layout to show records from my "advisor" table, I can enter data in the advisor fields and see previously ente…
-
- 3 replies
- 856 views
-
-
Hello, I am trying to figure out this: I have database with lots of people. When I am printing list of those people, in each person i have two field for telephone and two for mobile, like this: Tel1: 111 111 111 Tel2: 111 222 222 Mobile 1: 123 123 123 Mobile 2: 321 321 321 what I would like to do, is to hide field name (Tel1, Tel2, Mobile 1, Mobile2) if the field with that telephone number is empty. Because now, my printed list seems like this: Tel1: 111 111 111 Tel2: 111 222 222 Mobile 1: 123 123 123 Mobile 2: 321 321 321 -------- Tel1: 111 111 111 Tel2: Mobile 1: 123 123 123 Mobile 2: Thank you for …
-
- 1 reply
- 930 views
-
-
When viewing a database record with portal row with a number of portal rows the portal rows refresh slowly when you scroll up and down using FM 8.5 and XP. This does not occur using OS X 10.4.8. Anyone know of any work arounds? I have spoken to FileMaker tech support and they said this is expected. I view it as a bug.
-
- 0 replies
- 1.4k views
-
-
[color:red]Updated see below Hello, I have been doing my best to find some way of getting a jpeg into the web viewer from a field ...and I've done it HURRAY!!! ... imagine the smile on my face : : Here is an example of how to get an image from a text field. There are 5 examples 1. Webviewer only image (no fields or external URLs) 2. HTML including Image from a text field 3. HTML and Image Separated 4. How to convert images to text ... Externally 5. How to convert iamges to text ... Internally (Need help with this) Ok so its not how i expected it to be when i started but with this file and a little help from my friend here at FMFORUM im …
-
- 3 replies
- 2.4k views
-
-
I have a DB in which I have a drop down list displaying a primary key field from a related table. Although the primary key uniquely identifies the record, it is just a serial number and not very user friendly. So I created a calculation field that combines the vaules from a few different text fields to help describe the record better. I then attempted to "display values from second field" using the calculation field, but FileMaker gives me this message: "This value list will not work because this field cannot be indexed..." Does anybody know a work-around for this? I want to display the result of the calculation field in the value list.
-
- 7 replies
- 2.1k views
-
-
I have a field that is a "pop-up menu". It has a value list assigned to it. The field is also set up to "include 'other...' item to allow entry of other values" Are there any functions/scripts that can help manage the "Other"? This is what we would like to do: When a user selects Other, we want the field to show: "Other - " We know some users will be lazy and not put the "Other - ", or misspell it, or not follow format. Any way to do this? Thanks in advance.
-
- 1 reply
- 780 views
-
-
I just upgraded from Filemaker v5 to v8.5. on some of my layouts they are not printing. So I went into Layout setup, tab Printing, and i'm getting this error: "The selected value must be in the range 0.000 to -420.000, inclusively." after clicking "ok" the cursor is on a box, so I try to change it. the error pops up. I try to change it into the range, error pops up. I try to move to another box, and the error continually pops up, even when I click OK. Attached is a picture of the error. I have a feeling it has to do with the upgrade. Anyone got a fix for it? There is a complex fix. I can NOT duplicate the layout, the problem goes with it. I have to ma…
-
- 2 replies
- 1k views
-
-
Hi I have Company contact information page which as a portal that shows a list of personal in that company I want to recreate an pop up window which has Logs of phone discussion I have had with them. I can make the window pop up and show all the list but I can seem to developed the script to change the layout so it only shows the related records of that personal and also the ability to add a record also with the script The Pop up window is set up as an Columnar list/report The attached is a screen dump show the script I have set-up It would be great if any body has any throughs on this Cheers Damian screendump.pdf
-
- 3 replies
- 839 views
-
-
I am redesigning a gui from scratch and the client wants Arial 12pt but I am saying Arial 11pt as its displayed mainly on 15 and 17" displays (Windows). What do you guys/gals suggest or use?
-
- 7 replies
- 1.6k views
-
-
Hi everyone. I'm a newbie to both the forum and Filemaker Pro. Here's what I'm trying to accomplish. I'm setting up a database to track our repair shop customers and vehicles. I have a database called cars which lists the vehicle year, make, model and engine. On the customer database I have fields for year, make model and engine. What I would like to know, is there a way that when I click on MAKE that only the makes of cars that were produced for a certain year are displayed instead of all the makes. Then when I click on MODEL only the models for that make and year are displayed and finally when I click on ENGINE only the engines for the model and make of that year are di…
-
- 1 reply
- 1.2k views
-
-
...or something? I am new to Filemaker and these forums. I'm using FM Pro 8.0v3. I've got a layout issue I'm finding I need help with. It's a report which is sorted by a company division, then a person, then resources under a person's area of expertise, logically similar to the following: Division I ---->Person A --------->Resource 1 --------->Resource 2 --------->Resource 3 ---->Person B --------->Resource 1 --------->Resource 2 Division II ---->Person C --------->Resource 1 --------->Resource 2 ---->Person D --------->Resource 1 --------->Resource 2 --------->Resource 3 In any…
-
- 2 replies
- 1.7k views
-
-
Hi, I am attempting to use the table filtered two different ways through different portals. I have tried to link to a global field, set to the filtered value, from a separate table. I have also tried global field on the main table. Both give me a blank portal. Any help would be appreciated. I have attached a copy of the layout that I hope illustrates what I attempting to accomplish. Bill test.zip
-
- 11 replies
- 1.7k views
-
-
I've been away for a while from FM and when I came back it had grown tabs - all in favour. With the techniques from the scripted tab example, they are almost there! ( 24 Scripted Tab Example Link ) I have three tables: quotes, drinks and tab names. Records in the drinks table can have a type value of beer, wine, spirits, softs I have a tabbed interface with the same tabs, beer, wine, spirits, softs taken from tab names table. I am using the scripted tabbed interface example as my starting point and have this working well. What I have tired to do is have a portal on each tab that displays drinks from the drinks db based on the field 'type' related to th…
-
- 16 replies
- 3.4k views
-
-
I have problem deleting portal record with the X button that I created. Whenever I do an edit portal first and I press the delete button, the "Permanently delete this ENTIRE Record?" appears. BUT when I directly press my X button without editing the portal record first. the "Permanently delete this one related record?" appears. I check my relationship between my main table and portal table "Allow creating" and "Delete this related table" on portal table both checked. And for the main table both unchecked. What did I do wrong? Please help.
-
- 1 reply
- 934 views
-
-
Is it possible to change a background field by calculation. For example a menu list you choose a color and the background of a textfield changes colors? Thanks TMAS
-
- 3 replies
- 859 views
-
-
I have a bunch of fields that are Drop-Down Lists and works great. However I want the user only to be able to select values in the drop-down list. I know that If I use a Pop Up menu this will force the user to select a value in the list. However I do not like the design of the field Itself. I would prefer to have the same layout of a Drop-Down List (borders and arrow to the right). I tried to leave the Pop Up menu with no stroke and draw everything manually on top of it, but when I click the field, everything I drew is sent behind it and I can no longer see it. I've been playing around with this for a while and have not had any luck. Does anyone have any suggestions?…
-
- 4 replies
- 943 views
-
-
Thought I would query this astute forum with regard to whether “Custom Menus” can be associated with a specific user? In other words, when a user logs in can a specific “Custom Menu” related to their username be presented to them? Any help would be much appreciated…………….Ray
-
- 9 replies
- 2.6k views
-
-
One of my FM DBs won't let me enter data. I go into browse mode, try to click a radio button, and nothing happens. Help!
-
- 2 replies
- 808 views
-
-
Well, looks like this will be my last problem in this solution. So I have set all the fields on the layout as follows: Allow entry only in Find Mode, and allow the Tab Key to go next object. This is so the users will only be able to find results, not edit them. However, again, even though I've checked and rechecked them, three of the fields when the user *attempts* top enter the field, gives a dialog which says: "This action cannot be performed because the required table is missing." I have checked to make sure none of the fields has been set as a button, nor any graphics nearby. Two of the fields are simple edit fields, the third a checkbox field. Any…
-
- 1 reply
- 721 views
-
-
I am pretty new at this, but I have built a few small databases for various personal groups and projects. Currently I have a database that looks great in layout mode, but when I go to Preview (and when I print it) there is a large band of blank space between the body and the footer (both have patterned backgrounds) and the pagination does not print fully, as it is too low on the page. I cannot make a footer "slide up", and I have tried to adjust the size of both body and footer, to no avail. I have searched the Help, but found nothing that helps. Many thanks for any advice.
-
- 3 replies
- 805 views
-
-
Same application, same urls, but on this one workstation, the webviewer just sits at "Loading: http://xxx.com" leaving the screen area blank and the status line says "Done". The url can be accessed on this station with Firefox or IE. It does not work for any address I have tried. Is some setting blocking access? What other test should I try? Thank you for any idea to try. MF
-
- 3 replies
- 1.5k views
-
-
Hello, we have fm database with all our company emloyees. In each record, there is also field Category and SubCategory. I would like to be able to print list of all emploees sorted by Category and Subcategory. But we are changing these Category and SubCategory often, so is it somehow possible to soft it manually? Like if I can somehow sort Categories and SubCategories and print it?
-
- 5 replies
- 1k views
-
-
How can I display in a Value List only the records that correspond to a certain value (ex: active) instead of displaying all the records. Here's my scenario: A field named "coach_name" in table "Players" displays a drop-down list showing all coach names coming from table named "Coaches". This works fine for the moment. Now, I would like this Value List to display only the records for which field "Status" in table "Coach" would be equal to "active", so that it only lists active coaches, not all of them. I have a one-to-many relationship established between table Coaches and table Players using field Coachname. How can I accomplish this ? Thanks.
-
- 6 replies
- 1.4k views
-
-
I have a database of all the books I've ever read (dorky I know). I have a table that has all the covers (actual pictures) and the titles. What I would like is a...well I guess a form that displays all the pictures (say 5 rows across and how many ever down) and when you click on them it takes you to that record in the main book list DB. Can it be done? Thanks gang!
-
- 4 replies
- 974 views
-
-
Hi, I have a set of fields which vary greatly in terms of the amount of text in each filed. I have set each field for on a print only layout, and have resized them big enough to accommodate the largest amount of text any record has. Each field is placed one directly above the other, and each field has a field label to the left. I then set all fields and labels to the same setting in Sliding/Printing: Sliding Up based on All Above. This works perfectly for all the other fields and labels, but for some reason, one label "Credits" seems to not allow the next label to slide up -- or maybe that one isn't doing the sliding. Anyway, I have checked and re-che…
-
- 1 reply
- 764 views
-
-
I know this isn't possible "natively" in FMP, but I'm wondering what the best way to fake it might be. Within a portal, I need to vary what field/control type is displayed. This will be based on a categorical field in the related table. Basically, for each record in the portal I'll need to hide one control and show another. For some portal recs, I want to show a drop-down list. For others, I want to show a checkbox group. In no case will I need to show both for a single portal row, and I want if possible to show up in the same horizontal position. I could think of a number of ways to do this if I were working with a single-record layout instead of porta…
-
- 4 replies
- 1.1k views
-
-
I have a portal -- lets say a To Do List to give a visual. I have made everything I can including putting a button that runs a script that sends an email with what I need. The Problem is that I need the Script to only look at the subject box of the line I am on (Portal Row) that I hit the Button on. Every time I use the Script it looks for only the top most portal row -- the most recent one. I need it not to do that but to capture the portal row that I am on and use the subject line on that portal row. Can some one write this script? Thank you
-
- 2 replies
- 790 views
-
-
Is there a way to have value list items with a line break in them, without breaking them into separate items on a list?
-
- 3 replies
- 961 views
-
-
I have a portal that shows me data from a join table. I need to put a button that will run a script that will pull data from the id field in the portal row, and find the record in the master table on the other side of the join table. How do you pull data from a field in the portal row. I know this is basic, but I can't seem to make it fly. If I can get the data out of the field in the row, I'll be fine. Thanks for your help. Steve.
-
- 5 replies
- 1.1k views
-
-
Hi, I'm designing a layout that will be used to print records. I have a portal that shows a list of items that can be anywhere from 1 to 29 items in length. What I would really like to do is make a portal that has 2 columns and 15 rows. That way I can make the entire printout just one page. Is this possible? Thanks, js22
-
- 4 replies
- 1.1k views
-
-
ivve just read anothr post that says this isnt possible : but whats the answer? basically i have a portal of contacts who work for a company on the 'companies' layout. because a single contact may have many phone numbers and there can be lots of contacts i created another table for contact numbers. so basically i want to be able to see (on companies layout) all contacts and all thier phone numbers. lil help? p.s. if ur confused by all the fields in the 'contacts database dev' table its because im working with a 5year old DB, jus updated to 8.5 and im giving it a major functionality overhaul and the data is currently in that table.
-
- 2 replies
- 968 views
-
-
Hi i have decided to make our solutions area 900x600 as with the scroll bars, window title and status area it seems to fit on a 1024x768 window. When i tell FM to resize the window to 900x600 it doesn't allow for the actual window extras. what are the sizes of these bits so i can include them. Thanks.
-
- 2 replies
- 1.1k views
-
-
I am an artist and professional photographer who uses Filemaker to keep track of the editing and printing decisions behind my final prints. In the record for a given image, I have a sequence of 10 fields in which I log the major editing moves I make in Photoshop, and they contain entries such as: "Contrast layer, overlay blend, 20% opacity." Because the editing sequence is unique for each image, it doesn't make sense to organize these as Drop-down lists. At the moment, I have a text field in my entry layout in which I have the 20 most used editing moves available for selective cutting and pasting. Is there a way to make that text field available to all new records? Better…
-
- 4 replies
- 1.2k views
-
-
Hey, is there any relatively simple way to have a layout show a graphic and/or text only when in Find mode? It's easy to get something to display in Browse but not Find mode, but I'm looking to do the opposite. I never figured ou a great way to do this in FMP 5, but I'm hoping there's a way in 8. Thanks!
-
- 4 replies
- 1k views
-
-
I am an experienced developer, but new to FileMaker. I have two questions that I may need a bit of fairly explicit instructions to figure out how to do: 1. I want to set up my application so interface components are in one .fp7 file and tables are in another .fp7 file. My purpose in doing so is so I can more easily distibute interface updates, by simply replacing the client's interface .fp7 file, while keeping their current data .fp7 file. (On rare occasions, I may need to update the table structures and this would not work.) How do I do this? 2. If I have two .fpy files and one has a layout in it that I like and want to incorporate in second .fp7 file, how…
-
- 5 replies
- 1.4k views
-
-
Ok. I've only spent a day trying to figure this out, I have 2 tables: Customer Table Field 1 = Name Field 2 = Cust Key Transaction Table Field 1 = Date Stamp Field 2 = Transaction Type Field 3 = Amount Field 4 = Balance Field 5 = Cust Key Field 6 = Summary Amount (Total of Field 3) I am trying to print a report (previewed layout) that will print 1 line item per customer per day. 1. Cust Name (sort) 2. Beginning Balance 3. Total of Transactions 4. Ending Balance I can get 1, 2 and 3. I can't get #4. In my report, in order to only print 1 line per customer, I am using a trailing summary in place of the body. I do n…
-
- 4 replies
- 1.2k views
-
-
I don't want to put the descripton of the fields name e.g. "First Name" above, below or to the side of the field, is there a way to get it to appear before the user clicks on the field and then disappear with the users inputs the information. I think this is like a mask but i can't get it to work, I have been searching the forum without any luck. I have a limited amount of space for the look and feel that i'm going for. Thank you.......Tina Marie
-
- 9 replies
- 1.3k views
-
-
This has happened a couple of times: I have a report with body, sub-summary, and trailing grand summary. A calculation field has been defined. The calculation sums the values of another field in a related table. 'calculatedField=sum(relatedTable::otherField)' The calculation field is summarized in a 'total of' summary field. The calculation field displays properly in the body . The summary field is correct in the sub-summary, but the summary field in the grand summary is wrong. The grand summary is wrong in both browse and preview mode. In one case, after setting the parameters for the calculation, the grand summary total self-corrects i…
-
- 1 reply
- 892 views
-
-
I wish to recalculate a primary keyfield for a relation according to which of the tabs the user is on - it seems to be imposible to place invisible buttons on top of the tabs except the chosen, where it makes less sense. Is the solution to utilize http://www.onegasoft.com/tools/smarttabs/index.shtml ontop of an invisible (font's and outlines identical with background) tabbed system where the tabs is stuffed away in the upper rightmost corner, and put it entirely under script control ...or am I missing something?? --sd
-
- 1 reply
- 872 views
-
-
I have a text field which contains the availability of particular films on the internet. Some of these are also just brick and mortar locations. I'd like to be able to format the URL's to internet locations as "links" to be able to have users click on them and go to that page. Is there a way to do this? Thanks All My Best, Jeffrey
-
- 5 replies
- 1.1k views
-
-
I am designing a print layout that is orginized by Contact ID records. I have a seperate table that contains phone numbers. For each Contact ID record, I want to display the related records from the Phone Numbers table. I would prefer not to use a portal with sliding settings, because as far as I can tell, an emty entry line apppears below the bottom portal record. The portal takes up too much space, and I need the contact records to appear as compact as possible. For fields that are within the Contact ID table, merge fields have been the best for a simple and compact layout. Is there a way to insert a merge field the will display related records from anothe…
-
- 1 reply
- 909 views
-
-
Hi all, I've search around for something like this - and I can't find an example... AND I can't figure out how to do it. In a portal, I'd like to have alternating row highlights not by every other row, but every other occurrence of a field value. For example, say I have a portal with 15 items listed. I'd like a container field with a alternating white/off white shade to fill in based on groups of records. In my 15 items, I have a number field. The portal is sorted by this field. If in these 15 items I have 5 different numbers - ie. I have 5 sets of items (3 records each) that have the same number, I'd like to have the portal display with the 1st set of numb…
-
- 7 replies
- 1.2k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online