FileMaker Interface Features
-
I'm trying to produce a Filemaker version of a home budget program with similar functions of Quicken. I started out with Filemaker's "Check Tracker" template, and added additional features. I'm having some trouble implementing the "Split Transaction" feature. This feature allows a record to have sub records. As an example, if the record was a credit card bill, the split transaction allows typing in all the individual purchases made by that credit card for that particular bill. I could create a relational database file for each split, but that seems like alot of files to keep track of as the database grows. Is there another way to do this? Thanks, Ron K
-
- 7 replies
- 3.1k views
-
-
hi, I would like to count the number of items contained in a value list that is defined by a calculation. I have a field that displays the value list like this: CIO CW NWW I'd like to to be able to count this list so I can provide conditional formatting to a field if the list has more than one item. Any suggestions? Thanks.
-
- 4 replies
- 8k views
-
-
I have a multi-page report with page numbers. Is it possible to start the page numbering at 2 instead of 1? A cover page created elsewhere is always used & is officially page 1. Thanks!
-
- 2 replies
- 1.3k views
-
-
Using v11, in a new layout I create a rectangle that's 300 px wide and a line of the same length. Zooming in reveals that the line is one 'pixel' longer than the rectangle. In Browse Mode "adjusting to fit" the window results in the line extending past the rectangle leaving the background color showing next to the rectangle. Shorten the line to 299 and they look almost the same, but "adjusting to fit" still shows the background color to the right of the rectangle.The line must be shortened to 298 px for correct rendering. I noticed similar behavior in v10 when converting my pre-7 files, so I made all the lines one pixel short as a fix. Now, to eliminate the love…
-
- 30 replies
- 3.7k views
-
-
how we use username and password protected to filamaker database and give specific role to each user.
-
- 1 reply
- 1.1k views
-
-
Hi, in my solution I have a layout with a portal on it. There is a delete button for each record in the portal (the last column). Now I would like to show this button dynamically because some of the records can't be deleted. So it useless to show the delete button. I thought to use a global field and fill it with the button if delete is possible and leave it empty if not. But I'm not sure how to aacomplish that. Could someone help me? Thx by ChiSao
-
- 3 replies
- 1.3k views
-
-
Hi, I'm new. A few years ago I created a layout that tracks jobs coming into our business. I did not create a customers table (did I mention I'm new at this?) Each job is created as a new record. The problem is, we have many repeat customers. Now I have thousands of records, many are from the same customers. When I export my data to Excel, I see I have many duplicate customer fields. Is there a way to get a list of distinct customer names and other related fields such as address, phone, email, etc.?
-
- 1 reply
- 2k views
-
-
Hi all A very newbie question here. I'm trying to create an invoice using a demo file as a template which can be found at this link: http://fmforums.com/forum/showpost.php?post/309136/ I have setup tables similar to those in the demo file apart from naming convention. I have created a value list for contacts which shows both contact and contact id by using the second field option. When I add fields to my layout in layout mode I get little magnifying glass icons next to the added fields. Some are green, some are yellow. I'm assuming the fields that are green are for fields from the table that the layout is based on and yellow are from other tables…
-
- 2 replies
- 2k views
-
-
Dear Forum - Our users are running FileMaker 9 on Windows XP and have their PCs set for various countries. FileMaker is great about displaying dates in the correct format according to the PC settings, but not currencies. Is there some way to display a number field in US currency format (1,000.00) to some users and EU currency format (1.000,00) to others in an elegant manner? Here are things I have already tried / contemplated: - I know that if I leave a number field in "General Format", then the PC country settings will be considered for a decimal point, if entered, but then the number does not always show the decimal nor a thousands separator and doe…
-
- 2 replies
- 3.1k views
-
-
Greetings all, I have been through all of the threads of this topic and have seen this subject has been discussed half a dozen of times but I guess my question is a bit different. I am trying to make a two steps procedure to help the user choose the address he/she is looking for among the whole group of address. I have designed two value lists ; one with the Groups list, the other with the Subsidiaries list. When the user selects the Group he/she is looking for, the second value list should be set up, live, with this selected Group's Subsidiaries list. My problem is that my second value list is not immediately initiated. In fact, the selected value of …
-
- 2 replies
- 1.6k views
-
-
Newb diving into conditional formatting needs help. I have two fields – “Date Received” & “Due By” “Due by” is a calculation field -> Date Received + 21 I would like to use conditional formatting to change the color of the “Due By” field Black for 21-15 days remaining Blue for 14-8 days remaining Orange for 7-1 days remaining Red for 0 days remaining I’ve been trying to come up with the correct calculation for Black only (baby steps) but I can’t figure it out. Am I remotely close to being on the right path with this formula? GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≥ 15 and GetAsDate(Self - GetAsDate(Revie…
-
- 4 replies
- 2.1k views
-
-
Is it possible to test for the existence of a value in a drop down value list? I am trying to build a script (triggered on field entry) to auto enter a value, if that value is in a drop down value list.
-
- 7 replies
- 2.3k views
-
-
I have a calculated field with the following definition: ValueListNames ( Get(FileName )) The file has many lists, the field returns an empty string! Any help will be very much appreciated! Amram Chayim Eirinberg
-
- 7 replies
- 2.1k views
-
-
-
Hello, im making a purchase order database, everything was ok until i tried to make the reports. when i try to make the purchase order report i put the portal rows on the body part and it shows me only the first record not all the items of the order. ' do i am making something wrong ? some advises? thank you very much for your help Maurice
-
- 2 replies
- 1.4k views
-
-
Greetings all, I'm taking the first step in admitting I have a problem. I created a file navigation box and want to place it on each layout so those who like to "see and click" can navigate easily. I place this grouped box just off the page margin on the right side of the layout. I've tried locking it in place, but it slides to the right when I exit edit mode. Any tips/tricks/suggestions are appreciated. Jamie Avatar Energy
-
- 2 replies
- 1.4k views
-
-
Is there a basic way to count the number of records in a portal? But, I don't want the value in the portal. I want it on the layout that the portal is on. I have a portal relating account records to clients. Using information on this forum I figured out how to get the conditional formatting I want -- if there are more than 5 records in the portal of the same account type the back ground color is changed. What I'd like to do is have the number of records in the portal on the layout. Why? I want to perform finds based on that value. Thanks in advance. Christopher
-
- 5 replies
- 2.5k views
-
-
I've looked at all similar posts, but answers my variation of this problem. I have a simple contact database with 2 tables: Contacts and phone_numbers. These are joined by contact ID. The phone numbers appear in the contact layout within a portal that contains two fields: type & number (e.g. "Work Phone" & "555-1234"). I've set the field behavior to allow data entry in find mode, but when I try a find of "Work Phone" in the type field in the portal, it says "No records match this find criteria". I'm not trying to filter the portal rows in the current record, I'm trying to find all contact records with "Work Phone" in the portal. The data type is text and th…
-
- 18 replies
- 6.2k views
-
-
I'm working on a database that was created in Filemaker 10 and am using Filemaker 11. I can duplicate this oddity with both Filemaker 11 and now Filemaker 10. I add a tab panel to a layout and add 2 tabs with default settings. I then create fields on each tab. The tab functions perfectly, keeping each of their respective fields on the tabs that they are supposed to be on. I then change the tab justification to full and change the tab type to square, and now the tab panel displays all fields across all of the tabs in the first tab. No amount of switching or playing around with the layout fixes this until I delete the tab and try again. Can anybody reproduce …
-
- 3 replies
- 2.9k views
-
-
I understand the theory behind displaying a number field in a value list. FMI sees only the number in the field. Then it takes the first entry (of that number) and displays that in the value list (including any garbage with it). By garbage I mean non-numbers. So in attached: -1234 is seen first as -12aazzzz34 so it displays. ---aa12 a ---34 isnâ��t seen as separate number (but as -1234). 1234 is first seen as a1234a so that displays as well. But why is Monday showing in the pop-up? Well, the first time (and only the first time) that any straight text appears in a record, it displays in the value list. Notice that the dash and slash wonâ��t display. …
-
- 0 replies
- 1.4k views
-
-
I am trying to sort out what setting would not allow a user account to use the "Go To Record" options? If I log in with Full Access The Go To Record options are available under the Records Menu and Contral + Arrow Key options, but with any other privilege set they are grayed out even though it is the same Custom Menu Set. I even tried the standard menu set and all other privilege sets have no access to the Go To Record or key commands. I have checked that their Available Menu Commands is set to ALL in their Privilege Set so have just about run out of ideas. This is happening in FileMaker 11 on both Mac and Windows.
-
- 1 reply
- 2.9k views
-
-
In trying to format a field to create check boxes based on a value list, the dropdown menu under: Field Control/Setup/Control Style/Display As is blank and frozen. This problem is not limited to creating check boxes for a value list, as I have also observed this behavior when trying to select the format for exporting records. Sometimes restarting the OS fixes the problem, other times the issue is persistent. It is currently holding up my work, so any insight is greatly appreciated. thanks, bones [color:red]UPDATE: It appears as if this behavior is due to a conflict with some other software. Logging on as a different user (essentially a fr…
-
- 5 replies
- 3.9k views
-
-
Whenever I enter find mode, the content of portals disappear, or there is a box from which you could perform a find. I'd like a portal to show record content while in find mode so I can script it and perform scripted finds by clicking the portal content. Is this possible? I know I could do this by creating a value list and creating a checkbox set instead, but unfortunately I need to be able to control the sorting better than the value list allows.
-
- 7 replies
- 2.2k views
-
-
Is there a way to do a find for all records that contain an empty filtered portal? The portal is being filtered using Filemaker 11's new portal filter feature. Or am I going to have to create a filtered relationship in the relationships graph and then do an isempty search? It's a complex filter so I would really prefer not having to do it in relationship graph. Thanks!
-
- 4 replies
- 1.5k views
-
-
In FMP 11, I want to make a field which affects the behaviour of another. Specifically, I have a table for income tax which includes a calculation field which automatically calculates the amount of GST (sales tax). So total in field B is 10% of field A. However, some income does not attract sales tax. I have made a field C with a drop down menu that will allow a choice of type of income - taxable or not. How can I set the database up so that choosing Taxable results in the normal calculation; and choosing Not Taxed results in a null value? I have tried Case and Validate but not getting anywhere. Thanks for your help - it's much appreciated.
-
- 2 replies
- 1.3k views
-
-
What's wrong, what I am doing wrong? Thanks in advance for your support and help, Zagino ps. Imac os x11.4 fmp 10 adv GoogleMap.zip
-
- 0 replies
- 1.5k views
-
-
how to add item from table which is in portal and display total item in other layout which is in portal
-
- 1 reply
- 1.3k views
-
-
I need the value list to change based upon the contents of another field. If Field A = US then value list for Field B needs to offer Yes or No. If Field B = Canada the value list for Field B needs to be No only. thanks, Jim
-
- 2 replies
- 2k views
-
-
Hi. Just found this site! Here we go with my first post. We've recently upgraded from fmp 6 to 10. In our reports we have a 'matrix' made up of four fields with 25 repetitions. Some reports have a few entries in these fields, some have the full 25, some may have none. This is where the problems start!! These fields have borders and are set to slide up when they are blank. In the past (on fmp 6) this worked fine. Now though, if these fields are all blank, we still get the borders showing for the first row (repetition 1). Is there any way we can prevent this happening? I've (hopefully) attached a screenshot of how it is displaying these bo…
-
- 0 replies
- 1.2k views
-
-
I am working on a report that has three subsummary parts. When I run the report it comes out fine except that I would like it to not brek up a section at the end of a page. If it doesn't fit I would like that section to go to the next page. Every part has allow part to break across boundries unchecked. It doesn't seem to change when I do check any of them. Any help greatly appreciated.
-
- 0 replies
- 1.3k views
-
-
I copied a script to remove a portal row but it removes ALL of the entries for the match and deletes them from the parent file. I have checked and there are no permissions to either create or delete records between the tables upon which the relationships are based (either way). Any ideas?
-
- 1 reply
- 1.2k views
-
-
I know but.... I have read the manual (RTFM), Ive used FM for over 15 years, I searched the web and the forums. And still - How do I change the LAYOUT ORDER in FM 11?: Anyone?? It doesnt seem to be in my menu... :
-
- 1 reply
- 1.2k views
-
-
Is it possible to have a web viewer auto login to a website? I've got a web viewer set up for our Google Calendar and I'd like it to automatically be logged in to our account when a person pulls it up (I've got some people here that won't take the time to log in, and then they never see what's going on, nor do they add items to the calendar.) Is there a way to do this? I'm not sure what the coding would be to include the username and password.
-
- 1 reply
- 4.1k views
-
-
I'm currently encountering a weird problem that I've never noticed before. I'm opening a database from our FMSA 8 server with 9 Advanced client and adding layout graphics to it. They work fine on my machine, but when viewed on another client, I get a square box with the text "The file cannot", instead of the image. The rest is cut off, but I'm presuming the rest says "be found". It's clear that the graphic is being referenced to its location on my computer, instead of being saved in the layout, but this has always worked before, so I'm at a loss to explain it, or more importantly, fix it. Any ideas? Kev
-
- 1 reply
- 1.1k views
-
-
Hello, this might be something simple but I haven't been able to figure it for the past 3 hours. I have one dbase.fp7 with over 1500 records. I perform a search and find for certain records and let's say the search gave me 7 records (field name = CUSTOMER_NAME). I now want to import these 7 records into accounting.fp7. accounting.fp7 contains a portal with 7 rows that is supposed to show only the 7 imported records. When I import the 7 records and look at the portal, I see the same database record (CUSTOMER NAME) in each row of the portal and not the 7 different names of my customers. When I set the portal fields to reflect the contents of the fie…
-
- 1 reply
- 1.4k views
-
-
Hi All, I'm using a Webviewr to display a google map based on address fields, I would like to modify the web content so that it displays only the map without all the side panes and top toolbars, is that possible? Bear in mind that I still want the map to be based on my address fields. Any help will be very much appreciated! Amram Chayim Eirinberg
-
- 1 reply
- 1.7k views
-
-
I have recently started using stricter control of Firefox and Safari on my mac. Unfortunately, the Filemaker webviewer no longer works on certain websites. I cannot figure out which setting changes caused this. Does Filemaker inherit security features from Firefox, Safari, or some other place. Firefox is my default browser. Thank you, Fed
-
- 0 replies
- 1.2k views
-
-
Hello hopefully somebody will be able to help me with this problem. What I need is as follows, I have created a holiday database for staff to login online and put down the holidays they want. Now when their manager logs in online they get a seperate menu screen. How do I get this screen to show the manager how many holidays they have to authorise. I know its something to do with found count but I cant seem to get it to work Please Please Please can someone help as this is the only part that I cant get to work and is driving me insane Thanks in advance
-
- 0 replies
- 1.1k views
-
-
Hi there, I'm producing a solution for a service based business. When they quote/invoice, there are often several discrete items as part of the same service. To aid clarity, they would like to add descriptive text to each group of items (this is standard, but changes for each service they provide). For example: Descriptive text for service 1 Item 1 service 1 12m £5 Item 2 service 1 5m £4 Descriptive text for service 2 Item 3 service 2 4m £8 Is there a way to achieve this using sub summaries? Since the descriptive text is static and I don't require intermediate totals, ideally I would like to a…
-
- 1 reply
- 981 views
-
-
Hi All, Is it possible to format a webviewr control so that only the web contents should be visible and not the borders and engrave effects? Any help will be very much appreciated! Amram Chayim Eirinberg
-
- 0 replies
- 1.4k views
-
-
Is there a way to find the number of values contained in a value list? The value list is calculated from the entered value of a particular field. Thanks for your help. Gary P
-
- 2 replies
- 1.4k views
-
-
I have a flash player in a web viewer. I'd like to have a script that controls it. Is there any way for a script to control the mouse so that it clicks on the correct flash player control (e.g. Play button, or Next song)?
-
- 0 replies
- 1.3k views
-
-
I want to use a Web Viewer to Populate a shipping page on UPS. I've done a tracking page, but this seems a little more complicated.
-
- 2 replies
- 1.7k views
-
-
I have a database that is for a yearly convention. I have a table for the name and the amount of the of each session offered. I made a layout with a portal in order to open and choose which session will be attended. There can be up to 7 choices for the conference. My main table is demographics, then I have registration data for each year, related using the RSVPID #. For each registration table, I have the conference table related by the conference description. In the registration table i have fields for method of payment. When I register someone, after choosing their choices for the conference, I have a layout 'method of payment' I choose their method; i.e. PO; Ch…
-
- 0 replies
- 1.1k views
-
-
Hi. in FM 11 I have a simple portal with a portal filter. Example: Clients and Orders. Depending on the value in 3 global fields, only subsets of all available Orders are shown in the portal for a client. Imagine a client has 12 Orders listed. I apply my portal filter to only show the ones from this year for example. And now only three Orders are shown in the portal. Question: Now I want to switch to the layout/table of orders and only show those three and not the 12. In other words I want to do a show related records with THE PORTAL FILTER considered. Possible? Or can anyone suggest a reliable technique for this? Switching layouts and refinding all …
-
- 3 replies
- 1.4k views
-
-
Hi, I am trying to build a program to calculate the results of a competition. I have 1 table with: competitor type of obstacle 1 (Value list) marks obs 1 (Value list) co-efficient obs 1 (look up) result obs 1 (Marks X co-ef.) type of obstacle 2 marks obs 2 co-efficient obs 2 result obs 2 etc. up to 16 and a second with: type of obstacle (time, pace, success) marks obs ("time", "walk/trot/sprint", "yes/no") co-efficient from which the value lists and look ups are sourced. I have managed to make it work but for each obstacle I find myself having to create a new value list, a new instance of table1 and three new i…
-
- 2 replies
- 1.5k views
-
-
I'm trying to change the sort order for a report. The report shows people working different shifts of the day and is based on a join table called 'shift_positions'. This table has a field named shift_type which would be one of day, night, or detail. I have a sub-summary based on this field and the report works fine. However, it sorts alphabetically - day, detail, night - and I'd like it to be day, night, detail. How would I go about this? TIA
-
- 2 replies
- 1.3k views
-
-
Experienced Access Convert due to current employer purchasing FM, needing help with what is a 30sec task in Access, but has so far consumed three hours of my life in FM. The DB I am creating is for Inventory Control. One of the aspects I am having trouble with is Storage Areas and Locations. I have in my item table ´inventory_items´ a field called ´Storage Area´ which is populated with a drop down, that pulls values from another table called ´SA´, values XYZ. I have another field ´Storage Location´, which is also a drop down, but needs to populate with values ABC if X is chosen in the previous drop down - and DEF if Y etc. My question is how the heck do I do it?
-
- 2 replies
- 3k views
-
-
Hi, is there a nice way to check if a portal is empty? Thanks by ChiSao
-
- 2 replies
- 5.8k views
-
-
-
I've been a dormant FM developer, and am just having occasion to examine the Layout Script Triggers in FM10, and I am a little confused (this is a normal state for me). First off, I do not understand why there is a trigger for Layout Load, but not one for Layout Close? Next, I am not sure when the OnRecordCommit trigger actually runs. Here is the situation: a client wants to process credit card transactions, and a fellow developer has a technique that allows all sensitive information to be pushed up to the card processor (so my app doesn't have to have the security headache!). However, I will still need to offer a layout in which the user enters the card information …
-
- 3 replies
- 1.6k views
-
-
Using the "Modified By" selection thinking.. Is there anyway to set it to a specific field? Meaning that you can modify everything but once you modify a specific field it inputs the user name as the modifier? I assume if possible it would go in hand with time stamp as well. Or is there a way to log this info every time the user modifies the record/time/specific field?
-
- 4 replies
- 2k views
-
-
I have a value list that is populated based on two fields, one is the customer code and the other is the customer name. The problem is some customer codes are 4 numbers, some are 4 then a hyphen then 2 numbers. This creates a messy looking list: For example: 1234-10 St Mary's Hospital 5555 St Thomas 8765-22 St Victory Hospital 2233 Walter Reed My value list is based on two fields from the customer table. I would like to see the columns even so whether the customer code is 4 digits or seven it takes up the same amount of room.What the quickest and easiest way to achieve this result. Do I have to create a calculation field that masks the client code, then cho…
-
- 1 reply
- 1.1k views
-
-
I rearranged View>View as Table by shrinking and moving columns by dragging them all over with my mouse. I would now like to restore the View to Table to its original form without going through trying to re-drag and resize to original positions. Is there any easy way to do this?
-
- 2 replies
- 1.3k views
-
-
Is it possible using something like the function 'ValueListItems' to alter the state of a Radio Button pair dependant on the contents of another field. I have a club membership application in FMP Adv 11 which has a Radio Button pair of Active/Inactive dependant on whether they have renewed their annual subscription. At the moment the Radio Button pair is a manual setting, but I would like to automate this based on the subscription date. Any help/advice would be appreciated
-
- 4 replies
- 1.3k views
-
-
I think I am in the correct section? What I am trying to do is to create a db for my students to select color combinations, like the color wheel. I would like to be able to select a color from a Value List in field one (First Color) and a second color from a Value List in field two (Second Color)and have the results displayed in field three. First Color: Blue Second Color: Yellow Result: Green Do I need a join table for this? My book is not very clear. M. Logan
-
- 1 reply
- 1.6k views
-
-
I have searched for this here and on the internet, and still don't find the solution. I had this working in Microsoft Access for years, now i need it in Filemaker instead. I want a picture to show [perhaps in a Container field?] based on a field in the record [combination of 2 fields: /dir_field/images/filename_field.jpg] and i want this done at the record's "onLoad" trigger, when the record gets shown. (I don't want to store the picture, nor do i want to import it, there are 8,000 pictures to do that for, instead i want the picture association to be automatic.) In MsAccess I had a "picture field" which was a blank field initially, but upon loading the record …
-
- 6 replies
- 4.4k views
-
-
Hello all -- Is there an easy way to close all Windows except the current window without closing the whole file? Thanks
-
- 1 reply
- 3.8k views
-
-
For some time now I've been using a tip from Ray Cologon to highlight rows in list view using a web viewer. Now I find that when using the trial version of FMP11 this no longer works. I've attached Ray C's original file here and find that it's OK in FMP10, but not in FMP11. Any thoughts anyone? RowHighlightv8.5.zip
-
- 6 replies
- 2.1k views
-
-
I am having issues creating a filtered portal on a users home screen. I am trying to filter a portal based upon a global number field on the home screen and a calculated number field in the portal record. I am filtering based upon two fields. The first is my primary field, which displays all records with a status of "Pending" and "In Progress". I have this field set to a check box and can actively filter between the two different statuses. When add the second portal filter and try to filter by specific number, the portal returns no results no matter I set the number to. If instead I set the second filter field to a text field manually type in the value of a rec…
-
- 0 replies
- 1k views
-
-
Is there a way to limit the input of data into a text field per the width of the field itself? I can't use a "hard" character count in the field set-up because the text font is proportional; I don't want excess text to scroll to the next line. Any ideas? TIA for your help! Rich
-
- 2 replies
- 2.9k views
-
-
I'm trying to get this UPS tracking web viewer to work. It works, excetpt it puts the field name "Jobs::Tracking Number" into the field that the actual content of the field "1ZYY64820398867660" should go into. What am I doing wrong? "http://wwwapps.ups.com/WebTracking/processInputRequest?tracknum="&"= Jobs::Tracking Number" "Jobs::Tracking Number is my field name.
-
- 4 replies
- 1.6k views
-
-
This may be more of a script question than a value list question, but here goes (see attachment) What I want to happen is for a user to click on the drop-down list, a warning message appears (a custom dialog box fired using a script trigger), then the drop-down list drops down, revealing its values. I got the first part to work but I just can't figure out what script command to use so the list reveals itself automatically after the warning message is dismissed; currently, what I have to do is click the drop-down menu manually (again) to reveal the list. What command should go in the script? TIA for your help! Rich Career_Launcher_040210.pdf
-
- 5 replies
- 2.4k views
-
-
Hello! Is there a possibility to show/hide portal rows? I have a table in my database for offers, which operate with data from another table through the portal. And I have the invoices file, where the same portal is placed. No problems so far. But, in invoices file I must hide some lines in portal. The deletion is not allowed, because the offer should stay untouched. Is there a way to do this?
-
- 8 replies
- 2.8k views
-
-
I'm working on a database for field organizers to use in the Initiative-1068 Marijuana Legalization campaign in Washington State, USA. Petitions are individually (uniquely) numbered. The petitions are then checked out by the field organizers to volunteers. Volunteers collect signatures and then return the petitions to the field organizers who check them in before sending them in to campaign central. The database has two three tables: Volunteers, Petitions, and Contacts. In Volunteers, there are 2 fields for entering the range of petitions (field1= low#, field2= high#). Relating the range of petitions to individual volunteers is accomplished by: i. a self-relation …
-
- 0 replies
- 1.6k views
-
-
I'm pretty new at this stuff but have a layout for Companys (Companys table) with a portal for contact names (People table) related thru a CompanyName field in each table. Problem is, in a company with multiple contact names, only the first name (first when viewing People in Table View) shows up in the portal. When I first set it up all the names were showing but since then (several days) something has changed. I have double checked the name spellings in both tables and the relationships. I need help. lorenb
-
- 7 replies
- 1.8k views
-
-
I guess there is no answer to this, but it could be a good suggestion for filemaker team... Is there a way to make horizontal portals? I have to display a grid showing pre-scheduled sessions displaying time values. Three lines, one for today, one for the day before and one for the next day. Clicking on a timefield should bring up an appointments dialog. I actually made it working. there are three series of twelve horizontally aligned different portals. For each portal, I had to select a different starting row to display. But then I also had to duplicate the time fields for every portal, and manually program every field to be a button. The formatting was als…
-
- 4 replies
- 3.9k views
-
-
I'm working on a file to be used with FMTouch on an iTouch. Since this app doesn't effectively let you choose a year when entering a date field that's set up as a calendar, I need to set it up as a regular text edit field. This is all fine so far, but I also need to format the date as DD/MM/YYYY. I can do this manually under Format-->Date, but the program still only allows me to enter the date as MM/DD/YY. If I try to put in 23/12/2003, for example, I get an error message. If I enter 12/23/2003, it accepts and displays it as 23/12/2003. This would still be OK, but I want to avoid confusion about entering values like 4/3/2003. If someone mistakenly enters…
-
- 11 replies
- 3.5k views
-
-
I've created a database but after trying so many different ways to do the same with relational databases have ended up with 1000 fields!!! I know!! So .. what is the maximum amount of fields I can use? and if I do have loads will it consideralbly effect the speed etc of the database? thanks all.
-
- 30 replies
- 4.6k views
-
-
Hi all, I am doing a conditional format in which I need to get the current year. Obviously I can get the current date but I only need the year. Is there a way to get current year? Thanks Ron
-
- 2 replies
- 8.5k views
-
-
Hello, I think im having a brain freeze on this problem. I am building a solution which will be used as CRM/Quotation/SalesOrder/Invoice etc... (well there the only bits involved for this problem) but obviously once one bit is working the others is just variations. I have got the Layouts & Scripts/Tables sorted & working how i want.. however there is a need to print a Quotation (and sales order and ultimately invoice) out with the bill to address & the Site Address & then the details of the Quote & any parts to be used. Just to give you the information you may need to understand the problem im having. Tables "CID" (cid is …
-
- 0 replies
- 1.5k views
-
-
Ive been on advanced 10.3 for quite some time and have a database that does nothing more than have a list of files in a table and a webviewer for viewing those files (pdf's). Ive not made any recent changes to the system and, seemingly out of the blue, the files now open full screen in an external pdf viewer window and not inside the webviwer window.. any ideas on how i can get back to the old behavior so that the pdf's show constrained inside the webviewer??
-
- 2 replies
- 1.5k views
-
-
Hello, I have a FM database on a MacOS 10.4.11 served with Fm Server 8.0v4. The clients are also on MacOS 10.4.11 but use FM Pro 8.5. The problem is if I set the Page Setup for a layout (Paper Size, Orientation) it isn't saved with the layout. Each time I reconnect to the database and print the layout, I must change the Page Setup. Is there a solution to this problem? How do you save this information in a client/server environment? Thanks for the help. Andrew
-
- 5 replies
- 2.9k views
-
-
The new features of table view are a nice idea, but some of it seems a bit quirky. I have a layout with many fields and when I flip to table view not all of them show up either on screen or in the modify list. In case anybody else has stumbled on this I found a work around, which is to add a new field (or several) in table view and then trash them in the modify window. When they're deleted the original locked fields that were missing suddenly appear to take their place.
-
- 1 reply
- 1.3k views
-
-
I am making a database for work and trying to exclude records from a report. I used the starter database “Inventory”. I have a field named “In_Out” and when a card is put into inventory, this field is set with the number “1”. And when it is taking out of inventory this field is set with the number “3”. I use this field to filter the portals Cards In and Cards Out. This works just fine. My problem is when running the report “ View Inventory Report” I have not been able to exclude the cards that have been taken out of inventory. Any suggestions that would point in the right direction would be greatly appreciated. I have have attached the file. Inventory.zip
-
- 2 replies
- 1.7k views
-
-
Hi, On Snow Leopard Macs I am noticing a big change behavior between Web Viewer in 10.0v3 and 10.0v1 Within the Web Viewer I am using the following calc to define whether to load a local or a server-based php file into a Web Viewer: If( Local < 1; "http://server.myco.com/stores/store.php?clear=y"; "http://localhost/stores/store.php?clear=y" ) The server-based file displays in good order on both 10.0v1 and 10.0v3. But although the local file displays OK in 10.0v1 it shows as raw PHP in 10.0v3. Why does it show as raw PHP? The file itself displays fine in Safari. This has happened on a few Macs after upgrading from 10…
-
- 2 replies
- 1.4k views
-
-
Hello all, Greetings from Seoul, Korea. I'm trying to figure out how I can add an image file of my signature to the signature box in a letter layout with merged fields. What I've done: 1. Insert the text with merged fields throughout 2. Added the image of my signature as a .jpg in the signature box. I did this by going into the Insert menu and selecting 'picture.' *Since the length of the letter varies according to the information in the merged fields, it often ends up under or over the text. Is there a way to format the image so that its placement easily adjusts according to each letter without losing uniformity in line breaks and such. …
-
- 2 replies
- 2.1k views
-
-
I'm new at this so would appreciate your help. I have a field "gender" with either "male" or "female" in it, and want to generate a salutation including "Mr." or "Ms.". I tried to set up the salutation field in a calculation as follows: If(Exact(GetField ( "gender" );"male");GetValue( "Mr.¶Ms." ; 1 );GetValue( "Mr.¶Ms." ; 2 )) but this returns nothing visible into the salutation text field What am I missing?
-
- 7 replies
- 3.2k views
-
-
Here's the problem... I have a 'jobbing database' and I have created a separate new 'time database' - the link relationship is the Job_No field. I have a view in the Jobbing DB where the user can add new entries by selecting their name from a pull down menu, then enter time and date in fields (within a portal view)... so via the portal the Time DB is building a list of users and their times and dates against a job number... this is all working well - a user adds new time to the main jobbing database and it creates a new record entry in the time database... Now management is concerned users may delete or edit other users time amounts against the job number (fo…
-
- 0 replies
- 1.1k views
-
-
Hi, I have a related table called Po lines. What happens, is that customers place orders for goods not released yet ( we are selling CD's; DVD's-etc). We put all these orders in this table, then when we have enough orders for a particular supplier, we create a purchase order. However, in the PO lines table, you can have 6 different customers ordering the same product, for differing quantities. At present I create a Po and assign the Po number to all the records chosen in the PO lines table. Then in a portal layout i can view by po number, the order and its related lines and produce a summary report by catalogue number and total quantity for each item being ordered. H…
-
- 1 reply
- 1.8k views
-
-
I've seen that Filemaker 10 has a sorting functionality for developers when defining tables and fields; it's a column with a double head arrow which can be used to do arbitrary sorting by drag n' dropping. Is this functionality available for developers to be used in own apps? I have a layout based on table view and i need to make arbitrary sorting of records available to users. The option i'm using now is a numeric field for sorting, users put numbers to sort records as they want and Filemaker sorts according to this, but it's a bit difficult if table has more than 35-40 records.
-
- 3 replies
- 1.4k views
-
-
Hi all, I sure this will be a simple solution but I just can't figure-out what how to do it. I have two tables; Table A Client ID Client Name Complain Solution Table B Client ID Invoice No Invoice Amount Invoice Amount Total (Summary Field) I also have a layout that shows field from from Table A and Table B. I need to show the "Invoice Amount Total" for a given Found Set without sorting on a Header or Sub-summary part but in Browse Mode. Any help is GREATLY appreciated Thanks RudyM
-
- 3 replies
- 1.5k views
-
-
Hello, I'm a beginner user having a problem with calculating data in a portal based on a date field. The items I am working with are: Invoice (the portal table name) Payment Date (Date field) Payment Amount (Number field) I'm a guitar teacher and I would like to create a report that displays income sorted by year and then month. I am sure this is very rudimentary, but the other answers out there seem to involve more complex operations. Any help or direction would be really appreciated. Kind regards, Joel
-
- 4 replies
- 1.7k views
-
-
Is it really worth upgrading to FMP11? The answer is YES - not for the new features that come with FMP11 but for this totally awesome undocumented improvement. I haven't read through all of the FMP11 documentation but I think that what I will discuss below has not been documented - or maybe it has? Please let me know if it's the case and where I can find information about this... The greatest thing about FMP11 is what I call "layout and field immobility". With previous versions of FMP (including FMP 10), fields that don't have a matching background or overlapping fields flash when navigating from record to record resulting in a very poor experience for the end u…
-
- 16 replies
- 2.8k views
-
-
In FM 11, can a portal be set up to filter for: Table::TextField contains the word abc somewhere in the field ... or is it limited to exact matches? (Table::TextField = "abc") Thanks in advance for any help.
-
- 3 replies
- 3.1k views
-
-
We have a task system we have developed over a number of years and which we are very happy with. Each task is either "in Studio" or "Delivered". Each Task has an "Task ID" and a "Task Description". It also has a time sheet component. Currently each graphic designer must type in the "Task ID" which allows them to allocate time to the appropriate task. Instead of that I would like them to select from a drop-down list of "Task Descriptions", which is simple enough. However I want it to display only the "In Studio" tasks allocated to a specific designer.
-
- 2 replies
- 1.4k views
-
-
I would think this would be easy to achieve, but I can't figure it out and have searched all over to no avail. I want a sub-summary to print at the top of every page with a maximum of 6 body records printed. Here are some examples of how this should look for various numbers of records within the sub-summary grouping. In this example, there are 18 records in the found set, the sort field breaks them up into 3 groups (3 records, 6 records, 9 records). I want that displayed as follows: Page 1: Sub-summary group 1 record 1 record 2 record 3 Page 2: Sub-summary group 2 record 1 record 2 record 3 record 4…
-
- 3 replies
- 3.7k views
-
-
I have a layout which on layout load performs a few finds so that only certain records are showing. This layout pulls fields from other tables. It is sorted by month and contains a sub-summary leading part sorted by Header::cMonth, a sub-summary leading part sorted by Client_Header::ClientID, and a sub-summary trailing part sorted by Header::cMonth. The layout shows a few clients (that are similar) for every month with their projected, remaining, and spent budgets. I need to somehow get a total of these numbers. I tried putting some summary fields in the last sub-summary trailing part that is sorted by Header::cMonth. The problem is, on one certain month (the busie…
-
- 0 replies
- 1.2k views
-
-
This seems so simple that I hesitated to post it until I had thrashed around with it for a couple of days unsuccessfully. Any help would be much appreciated. I am making a task list viewer that by default lists all tasks for a group of users. I would like to show all the users and the number of tasks they have in a subsummary report at the top of the page, followed by a list of all of the tasks sorted by user: User 1 - 2 tasks User 2 - 1 task User 3 - 9 tasks --Task A User 1 --Task B User 1 --Task C User 2 --Task D User 3 I am getting stuck, however. If I use the subsummary report and place the task list in the bo…
-
- 6 replies
- 3.7k views
-
-
I have an idea that I try to make in my database but cannot get it to work. I am still a beginner in Filemaker 9 and did study video tutorials to understand things better. Here is what I try to make: I need a drop down menu that contains 10 choices to choose from. Next to this I have 10 times 12 text boxes in which I already have my text ready to be used. So every drop down menu choice is connected to 12 text boxes with predefined text description. Lastly, I need to have 12 empty text boxes in which those 12 text descriptions need to appear after making a choice from the drop down menu. Now what I want is whenever I choose one of the 10 choices from my drop down menu…
-
- 1 reply
- 893 views
-
-
As many of you know, FM11 solves the flicker problems that have plagued Windows users -- with ONE GLARING EXCEPTION. Portals flash like crazy whenever there is any background color or graphic involved. It is a devastating effect for the user. To clearly test and demonstrate the effects in a variety of portal/layout combinations, I built the attached example file. Of all 16 variations it includes, only white on white lessens the effect. Portal flashing makes FM 11 unusable for my primary application, which involves 72 layouts with portals. It is not practical to redesign them to remove Body Fill Color. The resolution must come from FileMaker in the form of…
-
- 0 replies
- 2.1k views
-
-
I've two tables related by a room number. one called "room" and the other "equipment in room". I want a report to list all the rooms with all equipment listed under a "room number" sub-summary. Not all rooms have equipment. If I make the layout show records from "room layout" I only get one piece of equipment listed and if I make the layout "equipment" I dont see the rooms with no equipment. Any thoughts? thanks
-
- 6 replies
- 1.2k views
-
-
"PK_Customer_ID" is defined to contain unique values only. Allow duplicate value? I click on NEW CONTACT in my custom solution and it creates a unique customer ID. Then when I click over to another tab such as Purchase Order or Work Order, and arrow down to that Contact I get the message above. Please help. Amy S
-
- 1 reply
- 1.8k views
-
-
I have a summary feild that totals for each county in a state. I would like to display this data on a state map with each county total displayed in the county on the map. Is there a way to do this? I have looked around but have not seen anything. Thanks.
-
- 4 replies
- 3k views
-
-
Hi All, I am using ESS and hooked up to ms sql db. I have a column in the db of type BIT. with possible values of zero or one. This is the typical way of storing boolean/true false values.. What is the best way to handle this in FM? I notice with radio buttons the labels and values are not seperate.. And also i can't make a single checkbox.. checked meaning true and unchecked meaning false. Am i missing something? how can i handle this? thanks!
-
- 1 reply
- 3.7k views
-
-
Hi, This is my first post, I can't find a related discussion on what I want to find out. I am creating a layout for a Purchase Order. I have created a portal on this layout that relates to another table, called Purchase Order List Items. I want to use the portal to list the items we want to order. I have created a relationship between them that allows the creation of a new record in the Purchase Order List Items table when an item is added to the portal on the Purchase Order table. I have set the portal up so that it has only 2 rows, however sometimes we will want to add more than 2 items. Whenever I have added more than 2 items and gone to print the Purcha…
-
- 2 replies
- 1.7k views
-
-
I apologize if this has been dealt with before but I didn't find it on the site. While I've been using a template for my Art Studio since v6 (now on v8 and testing v11), I want to be able to start personalizing it. I'd like to be able to select the phone type (home, work, cell, fax, other) of my collectors in a pull down button which would trigger in the next field the corresponding field (home phone, work phone...etc.) for data entry and collection. All I have now is three separate entry fields to accommodate the information. Since most collectors provide a contact preference (either home or work numbers) it would be nice to use a pull down menu so that I can put the pre…
-
- 2 replies
- 2.1k views
-
-
Is there a way to make a checkbox field scroll? I think a checkbox solution is easier for my users than any other value list type; but I have quite a few values so a regular field would take a lot of space on my layout. If not, how can I apply the same type of functionality in a portal solution? I specifically would like the find to work like a checkbox field.
-
- 4 replies
- 3.5k views
-
-
I'm working on creating an interface simply to list all records in my database. For my layout I've created a one line body with a header and a footer that looks great in layout mode. When I display in browse mode the header looks great and the footer looks great. The body starts out right under the header and looks wonderful at first but then, after displaying all the records in the database, there's a huge space between the displayed records and the footer. It's as if there's a set display size (as if this is meant to be a report rather than a screen) that is expected and I don't have enough lines to fill it so the display just shows empty background. I've checked all my…
-
- 3 replies
- 1.6k views
-
-
Is there a way of conditional formatting all the fields of a specific record based only on the conditions of one single field of that record? Example: Suppose I generate a report with a list of employees with fields like name, address, date of birth, etc... 1) John Doe - Poker Street - Chicago - 10/11/1952 2) Mary Lou - Chess Street - Washington - 9/15/1963 3) Mark Jones - Domino Avenue - Chicago - 7/22/1971 Suppose I want to highlight all the employees born in Chicago in my report by making the font bold for these employees. I can easily make the text "Chicago" bold by conditional formating it. But is there a way to format the whole line (includin…
-
- 3 replies
- 1.9k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online