FileMaker Interface Features
-
Is if possible to have 2 value lists available to one field? If Field 1 = Cats Then field 2 = Cat Value List If Field 1 = Dogs Then field 2 = Dog Value List
-
- 8 replies
- 1.9k views
-
-
Just working with modifying some layouts using tab control instead of buttons/layouts and I have something weird happening. In layout mode I have created 4 tabs with fields and objects clearly placed on each tab area. When I switch to browse mode, I see all fields and objects for each tab AT THE SAME TIME, stacked on top of each other. This case is true no matter what tab I click on. Strangely, it didn't do it at first but now it is so I have no idea what I did to change things. I know its probably something simple but any ideas? thanks
-
- 5 replies
- 2k views
-
-
FM 6 Database running over Macs of all ages -eMacs, iMacs (anglepoise, standard screen and widescreen models), G4 towers with 17, 19 and 24 inch screens. Current design of database layout seems based on 12" screen in use when dbase was written. I am not a programmer, but maintaining the database/ work record has fallen to me. Is there an elegant (and easy) way of maximising the layout area that will optimise/maximise the layout for these various screensizes? Currently the onscreen size is only a portion of the screen real estate available. Dragging the bottom right corner of layout when in BROWSE reveals part of next record. Can this be avoided b…
-
- 5 replies
- 1.1k views
-
-
I was not able to find hot to do this so any pointers are appreciated. I have about 800 records. Among the fields I have Item_Name, Picture and Cost. I would like to make a catalog layout where the records would show up horizontally one next to each other rather then vertically. I can get them to show like: Item_Name, Cost Picture Item_Name, Cost Picture Item_Name, Cost Picture Basically a regular list layout. I would like to show them as: Picture Item_Name Picture Item_Name Cost Cost constrained to page width for printing purposes. Thank you.,
-
- 10 replies
- 1.5k views
-
-
I have a problem with the format of text that is copied from the internet and pasted into a field. In the table, I have the field set to a particular font and font size. When I manually type in the data the format is fine. However, I get a lot of the information I need from the internet. When I copy and paste the text from the internet into the field the formatting from the internet overrides the settings on the field. Is there a way to force the field to change the formatting to specific settings after pasting the data in? Thanks for any help you can provide.
-
- 4 replies
- 899 views
-
-
Hello, I need to create a product sheet / entry form that lists every product from a products table as well as fields that display and allow the user to enter order values for a particular customer. I have a standard 3-table relationship schema of: Customer (IDCust_pk) Customer_Orders (IDCust_fk, IDProd_fk) Product (IDProd_pk) On the customer layout, I can get a portal to display just the products that the customer currently has orders for. What I want to show is a layout where EVERY product is listed, customer information, and data fields for what the current orders are by product. Any help would be very much appreciated. -Brian
-
- 2 replies
- 811 views
-
-
Aside from doing a screen dump, how can one print a layout--with the header, footer, and all design features--from within FileMaker? Ordinary printing leaves out the header, footer, and design features (like tabs). Ordinarily I wouldn't need these to print with a record, but I do for design documentation.
-
- 2 replies
- 969 views
-
-
Hello, I have a portal that displays some employees tasks, the task can be relatively simple, and take 1 line to explain, but some tasks are more complex, and the information that exceeds the row height are hidden, i need to click over them do display the rest I'd like to know if there is a way to auto adjust the row height to display all the information of that field. Sorry for bad english Thanks
-
- 6 replies
- 5.4k views
-
-
Thanks in Advance for all the help from everyone on this site. Included is an inventory solution. Right now you select item number and a value list of item # and item show up. which works great. What I want to do is select the manufacturer first, and then have only the items for that particular manufacturer show up in value list for item. Thanks!
-
- 17 replies
- 2.6k views
-
-
When selecting a element(fk -from a value list) in a portal- the wrong/next element [in this case a new foreign key] is created then stored instead of the value list element I clicked on. [color:red]See attached file for demo There seems to be an increment error: I have 4 tables: shootme_a shootme_b shootme_c [the problem child table] shootme_ab [this is a join table between A and B] Viewing from shootme_a, i can select elements of shootme_b (using a valuelist in a portal located in Layout "Shootme_a"- seen via drop down. "[color:green]fk_b"- see attached file for demo) and add records in shootme_ab(the join table).. this works. But when i try …
-
- 1 reply
- 847 views
-
-
Next Transaction Record problem..... As a point of reference , I posted yesterday in regards to a portal/script interaction..... http://www.fmforums.com/forum/showtopic.php?tid/188361/post/258169/hl//fromsearch/1/#258169 ....and the response yielded a fix to my problem. YES! But now a new issue. Even though there are no records in the table the portal refers to, there is a "default entry" that shows up in the portal, which I do not want there. I have attached 2 images to illustrate what is happening. Any insight would be greatly appreciated.
-
- 1 reply
- 1k views
-
-
Hope I am in the right for this question... I am using a portal for navigation. I have looked at all the examples I can find on how to highlight the portal row. The portal is not a selfjoin as most of the cases i have seen. The portal is populated from a table called catagory. i have the field acting as buttons that run a find script in the layout that the portal is on. all works well. Now i would like the row to stay highlighted after the script is run. all of the examples i have found relate to portals from a selfjoin. Any Ideas? I have been trying to solve this for a few days now. Thanks
-
- 3 replies
- 3.8k views
-
-
I have produced a portal containing many container fields which, thanks to other peoples help, works well. I would like to expand this by being able to click on a container object, such as a picture, and have information about the picture displayed in another text box. I tried to create a field in my table called "info" but this just puts up the text for the first picture and does not change when selecting another.
-
- 8 replies
- 1.9k views
-
-
Hi. I'm relatively new to Filemaker and have been trying to figure out how to get rid of the main window scoll bar when not in use. At the moment the scroll bar is always greyed out when not needed. This interferes with the look of the window if I place a grey fill graphic at the top to extend the title bar down to form the background of a menu bar. The right hand side can't cover the scroll bar so the window doesn't look like a "real" application. Because of this I've been looking at using Runrev Revolution as a front end to a database. It allows objects to be automatically resizable (now available in FM9 according to the website) and complete control of the windows. …
-
- 2 replies
- 794 views
-
-
Background: I have a survey database for our company. It surveys employees about their training needs. We ask employees to rank how often they use a particular software and how important training would be. I have created summary fields that give me the Averages of importance. Now I want to display the data in a report. I have a sub-summary section when sorted by Training Program name that displays the Avg of Importance for each training program. The problem: I need a field that is calculated based on the Importance average Summary Field. If the average is between 4 and 6 display "Important." If the Average is between 6 and 10 display "Very important." …
-
- 2 replies
- 972 views
-
-
Hi there, I am very new to FileMaker, but I am quite adept at other databases (Access and a variety of legal dbs). We are using FileMaker cross-platform - XP and Mac. When I view the Mac terminal I cannot see the contents of any field until I click into that field. I don't know if this is a setting on the users part or a Mac issue (I am a PC user myself.). Any advice would be great! Much thanks, Ky
-
- 1 reply
- 799 views
-
-
Hi, This is my first official post. I was redirected here from Fm tech support. Here is my situation: I am using FMV6.0, Epson LQ-590 Impact Printer, WinXPPro. Here at the office we are required to print these government certificates on an impact printer. These certificates are numbered, preprinted and a bizarre size. Now I am able to print the first page no problem. The problem starts with the line of the second page, it starts too low. All these certificates are on one continuous roll, and we are suppossed to print them out multiples at a time and tear off once done. In print setup, I change the page from "Letter" to "C5" and it does line up a l…
-
- 2 replies
- 1.7k views
-
-
I'm starting to use FMP again after a long absence, so I'm a not a newbie, but I am rusty, and new to FMP 8.5. Anyway, I have a problem with a script I'm writing to automatically enter a value into a field in a portal. It's a bit bizarre because the script works as long as I click outside the portal after each use. But if I continue to click (and create) new related records in the portal one after another, the script fails (and some strange FMP behavioir occurs). It's as if the calculations I'm using are only appearing to update, but aren't. The weirdest thing is that one of the fields I'm using as a counter is in the main layout, and it displays the correct value nt…
-
- 9 replies
- 1.8k views
-
-
I'm creating a database consisting of a listing of researchers, their contact information, what institution they are affiliated with and their research skills/interests. I'm confused about a few basic things: 1. Do I need separate tables for these 3 items? (contact, institution, research skills/interests? 2. This is a public db web published. I want people to have a main page publicly accessible where a member can do a search for another researcher based on location, skills or interests. How do I do this correctly? Portals/reports/or..? What I have done so far is set up a "main" layout with fields and a search button which runs a script going into find mode,…
-
- 1 reply
- 831 views
-
-
"Hello FileMaker World" Looks like you have a great forum here! I am a noob evaluating Filemaker 8.5 as a possible vehicle to parse and scrape content from web pages - saving said content to an FM database for massaging and printing. I have looked around the forum and see that it's possible to access the web page source and parse it with scripts. I do have the following questions: 1. What is the native character encoding of text entered into FM scripts ? 2. Is content scraped from a web page source in the original web page encoding or is it converted automatically to FM native encoding ? 3. Does FM use 'regular expressions' ? 4. Can scripts …
-
- 1 reply
- 1.9k views
-
-
I have a very simple script to duplicate a record, and add ".1" to a certain field. Duplicate Record/Request Set Field [Main table2::Transaction $; Main table2::Transaction #+".1" It basically works, (and if I duplicate a duplicated script, it changes the .1 to .2 which is useful, but odd it does that without me telling it to) but the field it modifies usually has a hypen, which is deleted in the duplicate record field. The original record will show "2003-25", while the duplicate record will show "200325.1". Why is it deleting the hypens, and how do I prevent this?
-
- 2 replies
- 892 views
-
-
Hi, hope somebody can help. Here's a simple example of my problem/question. I have two portals on one layout. The main layout is Employee Name. Portal 1 is a TO DO list and Portal 2 is a DONE list. I have a "Done" button in each portal row of the TO DO list and when you click it, it should send the TO DO item to the DONE portal and delete it from the TO DO list. Likewise, there is a "Back" button in the DONE list which sends that data back to the TO DO list and removes it from the DONE list. I can't figure out how to set up the relationships to make it work. Actually, what I'm trying to do is more complicated than this, but if somebody can make a simple exa…
-
- 2 replies
- 948 views
-
-
I am trying to integrate the Interlink (Courier) website in to a tab on my database. It all works OK, but when I click on the button on there web page which prints out the labels nothing happens. When I click on there button from safari, it does not display the lablels, it just brings up the print dialog to select which printer, and the label gets printed. Any ideas why the print dialog is not displayed when I click on it from the filemaker web viewer? Any suggestions appreciated Matthew
-
- 2 replies
- 1.3k views
-
-
Hi all, I come from an MS access background and now am using FM 8 in my current employment and can't pull something together like I have done previously. I need to track licenses for products and the users who have the license. So I need in the top part of a screen product information with serial numbers, purchase order info, number of seats on the license etc etc (in a table view). In the lower section of the form I want to have another table view but to contain all the user information relating to the locations of the licenses. So if I click on a particular Photoshop line in the top, then all the users who have that license allocated to them (for volume licenses…
-
- 8 replies
- 1.3k views
-
-
I have a multi-language application. Every button, field label, and tooltip appears in the logged-in user's language -- English, Spanish, or Portuguese. It is all dictionary driven. The only remaining issue I have is tab labels. Is there a way to change the label of tab panels?
-
- 2 replies
- 2k views
-
-
(I searched a number of different threads but couldn't find the answer to my question.) This ought to be relatively simple...I hope! I have a radio-buttoned text field and a date field. When asked if a user had filed a report, he or she would choose either Yes - No - N/A from the value list; if Yes is chosen, I'd like the computer to beep with a message to appear that says, "Enter Date" and the user would enter the date. However, if he or she changes is or her mind later and selects the No or N/A radio button, the contents of the date field would be deleted; I'd like a validation-type calculation where FM won't allow a date entered with either the No or N/A but…
-
- 2 replies
- 1.2k views
-
-
I have a javascript that brings answers to a calculation into the web viewer. Is there any scriptural way to copy that info and put it into a database from the web viewer?
-
- 0 replies
- 1.5k views
-
-
I can't figure out why the "Set Web Viewer" (reload) step isn't working for me. If I go to another layout, the web viewer reloads fine. I've tried defining the Layout Object with a bunch of names, and I've double-checked that the names match in the script step. I've even tried Get(ActiveLayoutObjectName) in the script step. Anybody know what's going on?
-
- 0 replies
- 1.1k views
-
-
This is kind of like a philosophical question more than technical. When I was less experienced I created a layout attached to one of the tables in my database for the purpose of excuting scripts that produce reports from other tables in the database. Over the years it has become massive with a lot of buttons for various reports and different output formats. Since those days I've learned to create function scripts so that the user can specify the output type upfront. That has reduced the number of button but the number of reports required continues to grow. The question is: Is it still a practical navigational Interface technique for producing all these reports o…
-
- 1 reply
- 782 views
-
-
I have a customer table, and a Film table. for every customer i have 1 portal with up to 15 rows. Inside the portal i have a field called "need films" and when i click on the email icon it send an email to our art dep, and it puts an "R" in need films. R stands for request. Now not all rows need films, but what i want is to be able to get the total number of "R" per customer and send that number to my home page that displays all my customers. But i can't do it. Hope my description helps. thanks in advance :o
-
- 1 reply
- 1.5k views
-
-
I am using the filtered selection portal technique discussed in the book: Special Edition Using FileMaker Pro 8. (I wish I had the page numbers for you but the book is at work.)For the most part it works with minor but annoying problem. Three tables: Personnel, Positions and Assignments; the are hundreds of personnel and hundreds of positions. I bring them together on the Assignments table. Because the user is likely to be in/on the Assignments TO for a length of time I've put the filter field and the portal of the Position TO directly on the Assignments TO. The filter works perfectly in grouping all the positions of any 1 out of 11 programs in the portal. …
-
- 2 replies
- 1.1k views
-
-
I have the following Fields that I am trying to get a running total from, when I do it gives me a number but it is wrong. DH_TRANS_DATE -> DATE DH_CODE -> Transaction Type (NUMBER) SumOfDH_TOTAL -> Transaction Total (NUMBER) CODES_DH_TOTAL -> CALCULATION (10)(No of Rep) Case(Get(CalculationRepetitionNumber)=(Extend(FM_CODE)); Extend(SumOfDH_TOTAL)) CODES_TOTALS -> SUMMARY (10)(No of Rep) =Total of CODES_DH_TOTAL CODES_TOTALS_BY_DATE -> CALCULATION (10)(No of Rep) GetSummary(CODES_TOTALS; DH_TRANS_DATE) CASH_BOOK -> CALCULATION -(GetRepetition(CODES_TOTALS_BY_DATE;3)-GetRepetition(CODES_TOTALS_BY_DATE;…
-
- 0 replies
- 730 views
-
-
Hi is there any way to use the auto complete function in value lists, with filemaker 7? thanks
-
- 2 replies
- 1.1k views
-
-
I am designing a "Call Intake" form to gather information for our Sales department. They want to track, among many other things, what types of calls are being fielded. A call can be a "Catalog" call AND/OR a "Contact Info." call AND/OR a "General Info" call AND/OR an "Order" call. I put a portal on the Call Intake form that allows the user to set one or more "Call Types" for each call by choosing from a drop down list of possible choices. Each time they choose, it adds a record to the related CallTypes table. I do NOT want them to choose the same type of call twice. I have set up validation that recognizes this situation. [color:blue]THE PROBLEM is that the…
-
- 1 reply
- 861 views
-
-
I am trying to do a calcuation that would be equivilent to an if; then statement If number field A is less than or equal to 0, than the calculation field remains as a fixed number (Field but if number field A is greater than 0 than the calculation should take place which is (Field B + Field C) I have only been able to get filemaker to do one or the other calculations but not both. how do i do this? thanks! deborah I am very new to building databases!
-
- 2 replies
- 826 views
-
-
I want to find out if there is anything out there that I can use in my Contact Db which would provide the list of states & provinces for all countries (particularly US, Mexico, Canada & South Africa). I want to have value lists but I don't want to input the info. Help me out, y'all!
-
- 2 replies
- 1.1k views
-
-
Hi I have built a database with records. This allows me to print envelopes to a client. If I select one record and print the envelope it is blank (not on the screen but in printing and preview). If I select all and hit print/preview (it will now print all records) non are blank. If I than ask it to print/preview the one record that I wanted to print in the first place by entering print from X to X, it prints fine. Any suggestions? Thanks
-
- 1 reply
- 716 views
-
-
In my solution I have "Help" buttons which open new windows and, hopefully, enlighten the user. My problem is that I need to locate and close any "help" windows which may still be open prior to Quitting FMP from my base window.
-
- 7 replies
- 1.3k views
-
-
Hi, all: I'm feeling unusually dense today so hopefully you can get my head wrapped around a custom menu problem. Background: In the aviation world there's a list we call an ATA list that references different components on an aircraft, like so: 12 Servicing 1210 Fuel Servicing 1220 Oil Servicing 1230 Hydraulic Fluid Servicing 1240 Coolant Servicing 18 Helicopter Vibration 1800 Helicopter Vibration/Noise Analysis 1810 Helicopter Vibration Analysis 1820 Helicopter Noise Analysis In my solution, rather than send someone off to a layout and have him or her search through all of codes for the one they want (we're talking hundre…
-
- 2 replies
- 1.5k views
-
-
Hello I now have filemaker 8.5 and when I make a script to populate the web browser with another web site, it keeps crashing. Any suggestions Thanks Dave My version is 8.5 v1 and I am on a Mac 10.4.9
-
- 6 replies
- 1.8k views
-
-
Is there a way to script within the viewer to add multiple points on a google map. Say 200 or so from my database. I would like to do this in the web viewer. Has anyone sucessfully done this? Thanks
-
- 0 replies
- 1.3k views
-
-
Is anyone out there currently designing in AutoNavigator by David Kachel? I would like to share notes.
-
- 0 replies
- 808 views
-
-
We have a form at work that we use as a cover page for our documents. Frequently we use a rubber stamp to denote that a vehicle is associated with the record. I would like to add a check box that when checked, makes a box with some text appear on the top of the page when printed. The box would not need to have any data entered/retained, it would just need to print when checked, and not print when unchecked. Thanks in advance, I'm a FileMaker newbie.
-
- 6 replies
- 1k views
-
-
I need to add a time stamp to a running note field, something the user clicks a button to add a current note. My attempts are replacing all the note field contents. Help!!
-
- 1 reply
- 905 views
-
-
Okay... I have a question, and I don't even know how to ask it. A client of mine runs a non-profit organization and sends his donors receipt letters. He would like those letters to include a year-to-date total, so they can see how much they've given for the current year. I developed a couple summary fields that seemed to do the trick. But...those fields summarize ALL the donor's giving, not just the current year's. So, for now, it would work, but come January, the total wouldn't go back down to $0. Any ideas? I'm really lost on this one. I'm afraid that I may have gone through the back door to get things done one to many times, and I'll have to redo a bunch …
-
- 7 replies
- 1.5k views
-
-
Hi To All, Hope someone has some ideas on this one. Webviewer is proving to be great to get information from a website and bring into filemaker. But if the website has to do a little more complex query that might run over 60 seconds I get timouts. This is a real problem. Any solutions greatfully accepted. Thanks, Lance
-
- 0 replies
- 732 views
-
-
Hi, As I click to scroll down in the Portal, the records at the bottom apprear to duplicate again and again as I scroll down until the scroll bar reaches the bottom, but they are not really there in the Table. If I go back to the top and just pull the scroll bar to the bottom they appear fine. Why is the Portal scrolling this way. It dosesn't matter if it is locally on the PC, or from Server Advanced Thanks, Mark
-
- 2 replies
- 1.1k views
-
-
I'm not sure if this is considered a conditional value list or not, but I need to develop a cascading popup structure that goes from Countries to First Level Administrative districts (states/provinces/etc.) to Cities. Any suggestions with supporting examples (if possible) would be great.
-
- 6 replies
- 1.1k views
-
-
Hi, We have just started using Filemaker to keep up with our soccer team information. I have played around with the webviewer and have finally made it work to show the location of some of our games. Will Filemaker work with Google Earth also? Thank you, Brenda E.
-
- 0 replies
- 1.2k views
-
-
Hi. Im doing something wrong Im sure, but cannot work it out. I have an database that is maximised for the most of it's operation, and occasionally need to open a small window in the foreground to (for example) select an item from a list but when I create then size (or new window with dimensions) the original window/app also changes size. Could somebody please explain with a simple demo of steps the process of doing this as I have various sized screens all over the place. Thanks, Greg
-
- 2 replies
- 1k views
-
-
Hello I would like to create a button and script that will create new records within a portal. However, I do not want the script to actually go to the portal table's layout to create the record, then go back to the initial layout. Is there any way to create the new record in the portal and stay on the same layout? PS: I tried 'go to portal record' , then 'insert record'. This just adds the record to the overall layout's table, not the portal.
-
- 5 replies
- 1.3k views
-
-
HI, I am trying to display the number of current record in total related records. For example, I have table Client and table Contact. In the layout Client I have portal Contact. Because the Contact table has too many fields, so on the portal I display only one record at a time. I need to show the total number of contact for the client, and also the current record is the 1, or 2 or 3 ... of the total contacts. So, I guess I need to have 2 fields in the Client table , one is current and the other is total. I tried to use function Count, but it does not work at all,maybe because I have not learnt enough. Could someone please help me out. Thank you
-
- 1 reply
- 947 views
-
-
Hi Anyone know if it's possible to format text based on what's in a field? For example: In my layout I have a field called "status." At the top of the layout I'm using <> to display "Complete," "Pending" or "Working," depending on which is in the "status" field. I want the text in <> to be red when the field for that record is populated with "Working," yellow when populated with "Pending," etc. By the way, does anyone know what that function of displaying text from a field using << >> is called?
-
- 1 reply
- 958 views
-
-
Hi there, I have a checkbox set of several provinces. I have created a calculation field that takes the selected provinces puts them into a list separated by commas. NOW - I am wondering if there is a way to also sort the provinces in alphabetical order. Currently the order they appear in is the order that they were selected. Is there anyway to set up a calculation that will sort the values of my province field? Alternatively, if I could script it that would be fine too. I just need my final result to be the selected values (provinces) in alphabetical order separated by commas for each record. Thanks in advance!
-
- 5 replies
- 1.2k views
-
-
Hey, I am currently using a value lists for a project and quite new to FM. The value list is getting data from another table first field is our internal product id and also displaying from the same table the name of the product. A product can have the same name but a different id when coming from a different supplier. My problem is when I either sort by the second field or tick the "show valuses only from second field" some of the products vanish from the value list. The ones with the exact same product name but also ones with same product name beginning. Any advice? Thanks
-
- 1 reply
- 884 views
-
-
Hello I have 3 tables that I want to display on a form. The tables are related parent -> child -> child where the parent table is behind the form and the child tables are two portals. If I select a certain record in a pop-up menu field from the child table (in portal), how can I get the corresponding value to display in the child portal field next to it?
-
- 2 replies
- 1.1k views
-
-
hi in my database i have a portal where items can be sold out, nothing special. However i want to be able to print an invoice of the current sale from the point of sale screen. Ive tried duplicating the POS layout and viewing it in preview mode but the portal doesnt change on the invoice page obviously. Is there any way to be able to display the portal items from the POS screen in another layout that i can print? thanks
-
- 2 replies
- 979 views
-
-
Hi All, Is it possible to have a Title Footer display on the last page of a multi-page print job as opposed to the first page? On a multi page documents where the totals/summaries are presented on the footer I would like it to appear on the last page as opposed to the first or (to me worse) all pages. It would be great if FMP would provided this as an option. i.e. "Display Title Footer on First or last page of Multi Page Documents." Is there a technique that I can use to work around this? Steve
-
- 2 replies
- 891 views
-
-
Is there a way to have a button take you to a specified layout but then also to a certain tab on that layout? Thanks
-
- 2 replies
- 862 views
-
-
I'm not exactly sure where I should go with this but I'll give you my dilemma. I have created a database for a cemetery. The database tracks which section, lot, and grave someone is buried in. My client is looking for a map of the cemetery so thay can click on a particular grave and it would bring up the related record of who is buried. The cemetery is broken up into different sections and they are odd shaped. Any suggestions or examples would be greatly appreciated.
-
- 5 replies
- 1.1k views
-
-
Is it better practice to traverse a portal of related records to change data within, or just to go to the related layout, find records, and traverse and change those records from beginning to end?
-
- 1 reply
- 956 views
-
-
Hello, I would like to have a tab view that displays only a selected few checkboxes from a single value list. Here's the scenario: I have a database that tracks the number and nature of contacts my school has had with students. When we input contacts, we need to select the reason for the contact (Test Taking, Counseling, etc.). There are many options to choose, and the options can be categorized. I would like tabs to display each category so we don't need to hunt through all of the types. But I would also like the information to end up in one field for reporting purposes. By that, I mean that I would like to have just one field in a list view that displays th…
-
- 2 replies
- 1.4k views
-
-
I've run into an interesting quirk. On Windows XP with 8.5 advanced, I have a list layout with a footer. In the footer I have multiple portals. When I drag and drop text into the portals I get different results. Sometimes the drop does not work, sometimes it drops data into the portal below (a different table and different field), sometimes it unexpectedly creates related records, every once in a while...it works as expected. I've tested the data file for corruption, I've reinstalled the app. The problem goes away if I change the view type to a form. Has anyone else seen this? Is it just me? Any ideas?
-
- 0 replies
- 801 views
-
-
All right, I ordered several FM training CD-Roms that were extremely helpful, but there is still a problem that I am facing that I have been unable to solve. We use FM to track user usage of our equipment, and then cost. Each user is listed under a different boss, and that boss then receives the bill. I have been able to create a report that shows single visit costs per user, total visit costs per user, and total visit costs per boss and then total visit costs for all bosses. This same report also shows me how often each user came in, how often users came in for each boss and how often users came in total. I cannot get the report to give me the total number of users …
-
- 0 replies
- 787 views
-
-
Hi all, im kind of beginner (one year in FM8) and now have a bad problem. Here is my real world Problem im trying to solve within filemaker 8: I have an Amplifier made of several PCBs (Printed Circuit Board) Thoses PCBs are build (as u can guess) with lots of single parts. Some Amplifies are build with the same PCBs. They difference between thoses Amplifiers is mostly the amount and type of PCBs. Maybe, you can say, those PCBs can be viewed as Modules. What i like to do is following: 1. When i get an Order i would like to print a list of all Parts i need to produce the Amplifier. So i can give it to an employee, who can get the parts from the dump…
-
- 0 replies
- 959 views
-
-
i searched the forums but couldn't find a hint. that's why i'm posting: can i add more avery label formats to the ones already in the filemaker format list? it seems that the ones in the format list are all in US letter format and not in A4 format as we use it in Europe. i need to print the labels in avery 3474 by the way. obviously i could define a customized format but i just can't believe that filemaker doesn't offer a better solution. Thanks, Hans
-
- 2 replies
- 5.3k views
-
-
Hello, My new problem. What I have is a layout form a table called “Main” this contains basic information about a person such as Name, Date Of Birth, Age etc. I have another layout called “Addresses” with a portal which contains address information. What I am attempting to do is create a layout to print containing all the information from the “Main” layout as well as a specific portal row from the “Address” layout. I have the layout to print in place, I just cant seem to figure out how to get the data from a specific portal row into the layout…right now it brings in the data from the first portal row and I need the data from the last portal row. …
-
- 1 reply
- 975 views
-
-
HELP!! FM Dev 7 Have a database with some 70 different customers and some 2900 records that include data such as Country, Type of operation, Process, Equipment, Model number and a few others. Items such as Equipment, Model number, Process may have multiple records for each piece of equipment. What I'm trying to acheive by having a 'Checkbox Set' of Customer Names and another 'Checkbox Set' with various pieces of equipment and having someone select either one or more customers from the list and have these records 'found' in a list format with all the relevant information. I need to do the same with the 'Equipment' list and find all the relevant information su…
-
- 3 replies
- 848 views
-
-
I have a portal with about 8 fields and I want to be able to sort the columns by clicking one of the 8 column headers. I have tried to make the header a button and use the sort record function to no avail. What am I doing Wrong?
-
- 19 replies
- 8k views
-
-
I have searched this question but can’t seem to find a solution. I have a field for a Social Security Number…I want to validate this to insure that a duplicate number is not entered. I have tried every setting I can to get the Revert Record button to go away and just have the message pop up with the yes or no button. Is it possible to remove the Revert Record button from the Validation / Unique Value settings? Thanks, James
-
- 11 replies
- 2k views
-
-
Hello all, I have recently implemented a new database solution for our lab, but there are some things that don't work quite the way I want them to. One of them is this. There are a number of tables that want to pull calculated reference names from other tables in a value list. If I set the fields to auto enter text calcs, it will allow me to pull them up in the value lists, however then they don't seem to update if any change is made to the originating related records. This is important as we are still in the process of standardizing naming conventions for things. If I then turn them into regular calcs, I am unable to index them, and thus unable to use them for…
-
- 5 replies
- 1k views
-
-
I have a field with 7 checkboxes. When I do a search for one of the check boxes, some records come up that don't have that checkbox checked. What's the deal???
-
- 17 replies
- 1.3k views
-
-
Hello: I have a form that displays in table view that lists job orders. If someone changes the quantity of a job, I want to change the font color of the quantity to red to indicate a change. Is this possible in table view? I change font using TextColor()on a field in Form view but cant get it in table view. Thanks! Rick
-
- 30 replies
- 3.4k views
-
-
Hi, I have a page with a number of fields that display summary of database data - eg calculated values. It displays the information as I want, but I have to do a Find from this page as well, and when I go into Find mode the values/text disappears. How can I make the values stay there whilst in Find mode? I have tried playing with the field behaviour and entering Browse Mode, Find Mode etc but it makes no difference. Any tips please. Ta. Greg
-
- 3 replies
- 791 views
-
-
Hi there, I am only new to Filemaker, but since I have a lot of experience with PHP and MYSQL Databases, I have been able to use this in building with Filemaker. My question is: Am I able to define a region where the sorted files or "Repeat Region" are in the Body section of the page. I want to display a large background image in the body and have the displayed fields (from search) over the top of this. So far I can only see that a repeat region occurs when you set a line of fields and move the body tag under the first line. This means I can't have a print out with the full background image. Can you display a list of results in the Body inside a c…
-
- 5 replies
- 1.1k views
-
-
Hello, I have a field which contains a value list of check boxes with 7 skills which a user can select. I would like to know how many times certain items were selected and by gender. Is FMP able to perform such a summary? Thanks in advance DH
-
- 4 replies
- 1.2k views
-
-
Hi, So does anyone know if there is a way to create a breadcrumb effect in a Filemaker layout? I would like to mimic the effect as seen in a web site like this very fmforums.com site (attached screenshot image with breadcrumb highlighted). What I am hoping to do is to create the breadcrumb trail based off of a 3 level (or more) tab control layout referencing the tabs as Objects. Example: Project->Customer->Invoice where there is a 1st (top) level tab control for Projects then a 2nd level tab control inside Projects for Customer & then a 3rd level tab control inside Customer for Invoice Make sense? Thanks, thegooglemoogle
-
- 2 replies
- 3.1k views
-
-
Hi. I have two tables. One is "Job List" which is a list of jobs for clients, and the second is "Timesheets" which is used for employees to enter times against various jobs in the first database. The layout Im using (in Timesheets) allows users to enter a single timesheet entry at a time against a single Job List job. I want to have it so I have a spreadsheet layout (assumably a portal) that allows me to enter multiple tasks for an employee on any of the jobs inthe first table. I can sort of get this working, but am having trouble with a feature the client requires. In the timesheet entry screen I can drop down a lookup list to the list of job numbers, but th…
-
- 3 replies
- 1.9k views
-
-
Hi everyone, Does anyone have the correct definition (syntax) for the UPS tracking web site? Thanks, Steve
-
- 12 replies
- 3k views
-
-
Hello all I have already created a detailed invoice layout associated to an invoices table with several relationships i.e. wholesale clients, invoice payments etc. A client required a packing list recently. All the information is on invoice. So i hightlighted fields not required and used Sliding Printing not to print those fields. Can i button be created and will automatically take data from invoice and create Packing List? I'm sure there is a way! Look forward to any replies. BFGK
-
- 2 replies
- 916 views
-
-
HURRAY!!! Safari 3.0 beta supports printing of SVG It works in the web viewer Amazing level of web viewer control now available for map making, charts... etc... Very exciting. www.apple.com/safari ------------- Safari 3.0 is available windows... Question for PC users... • Can you specify the web viewer to use Safari as default on Windows • Does Safari on Windows have the same URL length limitations? best Stuart
-
- 13 replies
- 1.8k views
-
-
I have a file with data entry page that frequently requires a look back at the reference information. I'd like to allow the user to open the reference files by using a button that opens a "pop up" window displaying the reference info. The reference info is tabular, text file, stored in a layout as a container file. Any thoughts on how to do this would be greatly appreciated.
-
- 0 replies
- 804 views
-
-
Very newbie to Web Viewer I have made my first attempt at using the Web Viewer. I have created a portal on my layout which has address, city, state and zip. What I am attempting to do is click on a button in the portal row which will open up a new window to show the address map in Google maps. So, I enter the address information in the first portal row and click the map button, the new window opens up and shows the map information and it is all correct. I then go to the next portal row and enter the address information and click the map button and the new window opens up However it still shows the address information that is listed in the first po…
-
- 4 replies
- 2k views
-
-
We have an employee that is reluctant or doesn't want to use the mouse drop down menu so her dates are always different making searches difficult (she manually enters rather than clicking with mouse). On those fields that are not drop down calendar style it is easy to right click->date format and set my preference (aka override hers) but when there is a drop down format it doesn't give the option when right clicking. I need two things: 1. To be able to autoformat the fields with drop down calendar when she manually enters the date as 6/22/07 instead of 06/22/07 as autoentered by dropdown. 2. To autoformat all the old entries that she has done in the p…
-
- 1 reply
- 999 views
-
-
[color:black]I have a value list of colors: RED orange yellow green blue violet White Black Pink Tan I would like the colors to appear in a menu like below from a value list [color:red]RED [color:orange]Orange [color:yellow]yellow [color:green]green [color:blue]blue [color:purple]violet [color:black]etc [color:black]How is this done. I am not sure if I can make different color words in a value list for a drop down menu Thanks Dave
-
- 5 replies
- 1.5k views
-
-
Hi, I have a button on my layout which will insert the date and time, however it all comes in as one long line... 6/22/20071:04:51 PM Is there a way to add a space between the date and time? Thanks, James
-
- 4 replies
- 1.5k views
-
-
I have been searching the forum for hours and have found many solutions to similar questions but none seem to fit my problem. I have a field on a layout. That field, Named Non-Active, is a check box with one value. I want to hide that field on the layout unless values in two other fields are met. Field A = x Or Field B = x Non-Active Field = Visible Otherwise Field = Invisible Very simple. All fields are in the same table and on the same layout. This is making me feel like a complete morron again.
-
- 2 replies
- 7k views
-
-
Hello, Its been a little while since I posted last…everything is going OK, until now. I really need some suggestions on how to go about this new problem. I currently have a form that I would like to develop in FM. The form is a monthly calendar which has numerical stats for about 25 questions. Currently the form is laid out in Excel and looks like this (of course with the grids) NOTE: I cant get the example below to align properly…so if you will imagine that each bit of data is in its own grid in the Excel sheet (the numbers would of course be under the listed dates). .............. July 1 July 2 July 3 July 4 Question 1: 44 …
-
- 2 replies
- 1k views
-
-
Can anyone point me to information about using a portal as the user interface? I am doing contract work for a consultant and he likes to have one table as the user interface. The only fields in the table are foreign keys and a primary key. All other data is displayed through a portal to a layout from that one table. I would like to know more about this method. Can anyone point me to articles or discussion threads? I've attached a file to illustrate my point. Thanks. dan
-
- 1 reply
- 1.1k views
-
-
Hi everyone, I'm kind of stuck here. I'm trying to create a dynamic value list with an autoincrement number field. E.g: Field number: 20 Value list: 1,2 ..... to 20 I can't manage to do that with a calculation field because I can't use a "loop" fonction because this is not a script. Is it possible to do that? Thanks a lot!
-
- 16 replies
- 2k views
-
-
FMP5 & FMP8 Adv, WinXP I have 3 files that represent a piece of a .fp5 database that I've replicated in another file in FMP8. What I really like about this (.fp5 file) is that, in the .fp5 file, when portal B has info in it and you select another subject from the pull down menu, portal B becomes cleared/blank and waits until you select another topic from portal A. In my FMP8 replication file, portal B retains info even after you select a new subject from the pull down menu and only updates with new info when you select the portal row button in Portal A. In my replication file, I want portal B to clear all its info when a new subject is selected. What makes po…
-
- 1 reply
- 938 views
-
-
I have two database files: Client.fp7 - Tracks time worked on client's case. Phone.fp7 - records phone call message As I get my voicemail messages, I record the information in Phone.fp7. Some messages are related to client that can be found in Client.fp7. I would like to be in Phone.fp7 and have a drop down (or some other tool) that allows me to link the phone message to a client in Client.fp7. There is no relationship between the two table I am using in Client.fp7 and Phone.fp7. All I have been able to do is create a drop down that has the 1st client in Client.fp7...it doesn't list all of them. Any ideas?
-
- 3 replies
- 1.4k views
-
-
When you "Duplicate" an existing record, is there anyway to have certain fields made blank automatically on duplication?
-
- 6 replies
- 1k views
-
-
I'm trying to work around filemaker's 12-page per record limit by having a separate report for overflows. I have a seperate input field with instructions to continue into the overflow input field if the input is past a certain length. This goes into a separate report layout that just has the standard header/footer, and this text field for the overflow. I'm setting up a script to print from the main report, then print the overflow report, by record so it prints out properly. Here's the problem: Even if the overflow field is blank (meaning the input data was less than the 12 page limit), I get a page for the overflow, which is blank + headers/footers. I don't want…
-
- 15 replies
- 1.7k views
-
-
Hello: For the life of me I cant figure this out. I have a popup box on a layout. I click on the box and I see all my choices. I let go and the popup box disappears. Then when I click someplace else on the form it comes back. Any ideas? Dom
-
- 8 replies
- 1.3k views
-
-
I recently came across the technique known as "Dwindling Value List" (it also goes by other names). If you search FMForums you will find a couple of examples that can be downloaded. I documented the procedure because it helps me to understand techniques (hopefully to where it becomes second nature). I am including my documentation here in a text format. Feel free to use it, correct it, amend it, etc. -dan Dwindling_Value_List.txt
-
- 1 reply
- 1.7k views
-
-
Hey all, I am adding several functions to an existing contacts database (this db is a perfect example of an 'angry fruit salad' database!) And my boss wants a scheduled call back layout that pops up at the push of a button. Now i built him a simple scheduled calls table and a nice little layout that pops up. Now the issue is that the layout in the background is resized when the layout window with the callbacks pops up. He wants me to make the button that opens the callback window make the window 'float' on top of the other table, so that no matter what, the main contacts db is maximized in the background. I do not know how this is possible. But he swea…
-
- 4 replies
- 1.5k views
-
-
Is there a way to remove or not show items selected from a value list? Example: If the value list is 1, 2, 3, 4 and in a previous record you selected 1 from the Pop Up Menu, can "1" be hidden or not shown for a series of records I'm tying to use this for a scheduling solution and once I select a persons name I don't want to have it available for a series of records
-
- 1 reply
- 802 views
-
-
I have a portal behaving very oddly. When I create a new entry in the last row of the portal, then it automatically does a find (which results in an error). When I modify a current entry it does nothing (which is what I expect). I cannot figure out what is triggering the "Find" command. I cannot find any scripts attached to this portal nor the fields in use that would do this. Thanks ahead for any help.
-
- 7 replies
- 1.5k views
-
-
I am a filemaker novice, and have finally come to the conclusion I probably won't figure this out by myself... I am creating a lighting audit database which records existing location information pertaining to light fixtures. These existing locations are then analyzed and new, more energy efficient light fixtures are specified. I have created an existing (EXI) fixture table, and new (ECM) fixture table to record all of the details. I have also created a location table, which will automatically populate a list of locations which can be matched back to a drawing or plan. It is here where the specifications are decided. My problem comes when I try to crea…
-
- 2 replies
- 830 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online