FileMaker Interface Features
-
I have a report which sub totals fees for events. The report is generated weekly. Certain clients are also billed a weekly consultancy fee on top of the event fees. The amount of the consultancy fee is added on the client's record as it is always the same - week after week. I have sub summaries (sorted by client) displaying the totals of a client's fees for the week. I can also display in the sub summary, the weekly consultancy fee (if the client happens to be flagged as such). What I can not work out is how to total in a Grand Summary part, the total of these consultancy fees. I have attached a screenshot. (I need the total to read £600.00 and £105.00 in the example.)…
-
- 0 replies
- 1.1k views
-
-
I'll try to keep this as simple as possible. I'm designing a comprehensive database in which one element logs uniform inventory and assignment. Generally, the uniforms are distributed as separates (i.e., jacket #13 and pants #24, not necessarily matching jacket #13 and pants #13), thus it is necessary to record all uniform components separately. In order to accommodate the various measurement methods used (i.e., chest/bust/waist for jackets, and waist/length for pants), I have a radio button field named Measurement Method, as well as individual fields for each measurement per method listed. The idea is that all measurement fields are grayed out and are invalidated unl…
-
- 2 replies
- 1.6k views
-
-
Database has a parent client records table and a child client billing table in a portal with a 1 to many relationship. Duplicating the client parent record is easy, but I would like to duplicate his portal billing records to create a second set of billing records for his second entry in the parent client file, in order to save a lot of typing. Any way to do this?
-
- 1 reply
- 1k views
-
-
Hi everyone, The boss just asked me to add a page total to one of my layouts and I said, "Sure Boss, no problem..." Then I dug into it and couldn't find an easy way to make it happen... : So, what I'm trying to do is total a column of numbers and display that total at the bottom of each page. I tried a sub-summary, but that places the total after a group of like records and not at the end of the page. I can't find any easy way of doing it... Please help! : Mac Hammer
-
- 24 replies
- 5.5k views
-
-
may be related to: http://fmforums.com/forum/showtopic.php?tid/197715/post/new/#NEW I have a db that will show user clock times, current week displayed: Mon-Fri, up to 4 clock-in/outs and then weekly totals per month... This is what it looks like I need to display current weeks daily times and then sum of hours per week/per month My table for hours looks like: nameUserName;timeIn;timeOut;date multiple instances of username exist in this table for each record is a clock-in/out interval so I could have: jsmith01;8/1/08 8:00:00 AM; 8/1/08 9:30:00 AM; 8/1/08 jsmith01;8/1/08 9:45:00 AM; 8/1/08 11:30:00 AM; 8/1/08 etc Finally, my question …
-
- 0 replies
- 1.3k views
-
-
Hi, I'm currently developing a system intended for a retail company. When generating the catalog, the system needs to have thumbnail pictures that are arranged from left to right (say, 5 pics per row) with 3 lines of texts below each thumbnail to properly indicate the item code, description and price. This is intended to be viewed and printed. If I have only one container field to hold the pic for each product, how can I generate a preview of the item catalog following the layout format stated above? Many Thanks!
-
- 0 replies
- 1k views
-
-
Hi, I'm guessing there is an easy answer to this but I can't find it. I have a delete button on a portal row. The button is to the right of each row and looks just fine. However, there appears to be an empty portal row generated at the bottom of my portal and the graphic is also appearing there, as in: Does anyone know how to get rid of this phantom graphic? Many thanks, Pat
-
- 2 replies
- 954 views
-
-
Is it possible to make a merge field work like a "basic" field to do look ups? I have a "production company" field that i set up with a drop down so I can see a list of 2 fields: "prod co id" and "prod co name" (this is great) When I select one the "prod co id" is displayed properly and the "prod co name" displays and based off of the "prod co id" the look up perfoms and all my look up data auto enters. ( also great!) the only problem is id like to have information from 2 fields displayed in the "production co" field. I tried the merge field and had it display what i was looking for but is this similar to all other fields? can I give a merge field a name and have…
-
- 6 replies
- 1.4k views
-
-
I need to omit records that have no records showing in a portal. So far I've been able to isolate records with specific data in the portal, but can seem to do a find for "=" to isolate empty portals. Is there a way to do this?
-
- 14 replies
- 1.8k views
-
-
I know this topic has been covered numerous times, but none of the solutions seem to apply or even work with my problem... I have a data base for employee information. Here are the tables (simplified for view) Emp_Table: emp name (*source for value list) status Timecard: emp name Value List: status ("active" "inactive") (custom values) emp name (* from emp name field of emp_table) In the Emp_table I specify info like, name and status (active or not) In the timecard table I have a field for the emp name which is a value list from the emp names in the emp_table. In the employee table I have a value list to select the st…
-
- 19 replies
- 2.7k views
-
-
Hi. I cannot see any native tools to do it, but was wondering if anybody was able to make FmPro do the following task: I have a need for a drop-down box that displays entries that not only start with-, but also ONLY have the typed characters in it. For example. A list with 100 names of various spelling. As you type the letter A, only entries in that field that contain A (not just start with A) appear, then T is pressed, and the list narrows to only items in the list where AT can be found somewhere in the field contents, thus narrowing the search smaller and smaller until it beeps when none are found - the beep is optional. lol Is there such a function - eve…
-
- 2 replies
- 1.3k views
-
-
Is there a way to log what layouts gets used/accessed during a time period?
-
- 2 replies
- 1.1k views
-
-
Hello, I have a ton of Access experience, but just picked up Filemaker Pro last week. I would appreciate any help you can share. I am developing a database for a law office, and what I want is to have one table that holds documents of various types that many different portals display depending on the document type. I have designed a layout with multiple tabs, each with a portal for a specific type of document. I figured out how to do it with different tables for each type of document, but one table and therefore one input interface would be nice. Is this something that FMP is capable of? Thanks again for any input, Rebecca
-
- 6 replies
- 1.2k views
-
-
Is it possible to create a subsummary report with fields from two different tables? I have two tables -- Customers and Lead Cost -- linked by year, lead source and month. I tried to create a subsummary report under the Lead Cost table that breaks down the cost per lead by month, like this: January 5 leads $100.00 $20.00 February 7 leads $200.00 $28.57 Etc. Total 12 leads $300.00 $25.00 I used a "Total Count of Leads" field from the Customers table for the subsummary Total, but it is not calculating the total. The Total Cost is a field "Total Cost Incurred" in the Lead Cost table. The only thing I can think of is that FM won't let you creat…
-
- 0 replies
- 996 views
-
-
Hello out there. I have been having trouble with parts breaking across pages. The "Allow part to break across page boundaries" option is NOT checked in both the Body part and the associated sub-summary. The text in any body and any one sub-summary easily fits on one page. However, when there are multiple groups, the bottom part will sometimes break onto the next page. If it cannot fit fully, I want it to start on a new page. I tried to make sure that no field was touching a part boundary. Any other suggestions to avoid parts breaking across a page? Thank you in advance,
-
- 1 reply
- 1k views
-
-
Hi all, I am new to this list and have a question. Is it possible to format the second third and subsequent entires in a list so that they are not seen. I have a list of entires in a portal that are listed in date order - fields are date, event name, start time. However, to make the list easier to read - see that there multiple events on the same day - I wish to supress displaying the date of the second and subsequent entries so that only the first date shows in the list. Year - 2008 Month - May ___________________________________ 4 May | Rehearsal Follies | 4:00pm 7 May | Myrid Dance School | 9:00am | Farmers Market | 2:00pm 9 May | Ec…
-
- 5 replies
- 1.9k views
-
-
Stumped at trying to provide a scrolling static text. The requirement is that it must show the scroll bar indicating there is text below the edge of the container regardless of what field the user happens to have in focus. (aka works like a normal web or application interface). This is instructional information and not a "field". I cannot be entered or edited per requirements. I am probably making this too hard but any clues are appreciated.
-
- 7 replies
- 1.7k views
-
-
Hello, If there is already an answer to this, please point me to the link, my searching came up empty. I am trying to build a Meal Planner where I can select Recipes and Products for each meal for every day of the week. Here are my tables: Products: - kp_product name - Product ID Recipes: - kp_recipe_name - Recipe ID Join Table: - kf_Product ID - kf_Recipe ID Meal Planner: - Meal ID In Meal Planner I want to be able to pick the recipes and products that go into each day's breakfast, lunch, and dinner. My thought was to create a portal for each day's meal and use a drop down menu to make the selections. This worked fi…
-
- 18 replies
- 3.9k views
-
-
I'm new to filemaker and need some help getting unstuck. I'm building a database for the school i work at and want to display the courses for a particular month (i.e.-for the month of October) in a portal. How can i do this? I've tried a few different ways but now I'm just lost. Thank you for your assistance
-
- 4 replies
- 1.2k views
-
-
I've got a database with parent and student information. On one layout I've created a "find" portal based on Matt Petrowsky Many Faces of Portal Filters. The user types the first few letters of the parents last name and the portal filters to show matching records. It's worked great for several weeks, but we've found one instance where a parent shows twice in the portal. I've checked and there isn't a duplicate record. The duplicate show with 3 matching letters, not one, two or four. What's up with this?
-
- 1 reply
- 1.1k views
-
-
Hello, I'm working on a database for our school that tracks student assessment scores. Each assessment has it's own layout and table. The table structure & layouts of the assessments are pretty much the same. I can't combine them, because my boss wants it setup this way. Here's my question. I create Table 1 and Layout 1. I wish to duplicate both to Table 2 and Layout 2. How can I do this, without having to change each field on Layout 2 to table 2. (When I duplicate Layout 1 to 2, the fields still connect to Table 1). Is there a way to select multiple fields and point them to a different table? Thanks.
-
- 1 reply
- 973 views
-
-
I have a layout which sends an e mail. Once an e mail has been sent it ticks a field in the record to mark it as sent. Is there a way to make this record (or if necessarily each individual field)read only if this box is ticked when this e mail is viewed for information, similarly to the way conditional formatting works. Many thanks John
-
- 3 replies
- 4.7k views
-
-
ok.. i did tried many times the layout/previews summaries... i just really would like a very simple report like follows.. a table: moo 3 0 moo 2 0 moo 1 0 moo 0 7 moo 0 2 foo 1 0 foo 0 7 foo 0 2 i want to get as a summary: moo 6 9 3 2 foo 1 9 1 2 where 6 and 9 are sums of all the values for moo in the second field of the table above (same for foo) and 3 and 2 is how man records are not zero... very, very simple... yet not with file maker... i tried that new layout/report menu many times back and f…
-
- 6 replies
- 1.5k views
-
-
I have an Access background and I'm trying some solutions in Filemaker V9. Table and List view in Filemaker seem very limited presentation wise compared with Access. Is there a way of presenting a recordset for either data entry or viewing in Table form in any part of the Window, say for example in a Tab Control? A Portal is fine for related records but I can't seem to display it for a single table and allow data entry. Any help or suggestions is appreciated.
-
- 1 reply
- 953 views
-
-
OK I am DESPERATE! I have attached my empty file in hopes someone will show me kindness I have created separate tables, booth sales, other sales, and cancellations. The data for each of these gets entered into a separate portal. All records are designated by year. No matter what I do , I cannot create a report that will combine all and breakdown by year and salesperson. I have twisted and turned and as you will see have created summary fields that are not working when shown in another table, and I can't figure out what its pulling. I also created a 4th table for show year that miraculously works but only for the total per year. PLEASE HELP! TEST_Clone.zip
-
- 5 replies
- 1.2k views
-
-
I have a portal that pulls records correctly from another table with a field in that portal that has a calculation for Get (PortalRowNumber. So its basically like this: FieldName = Get (PortalRowNumber. My FieldName is just a calculation with the get function in it is all. The issue is when i go into browse mode, all it shows in that field for every record that is listed in that portal is 0 for the portal row number even if i have 7 records in that portal. They still all show 0 for the portal row number. Can anyone tell me what could be the problem? The relationship is correct and everything else works but the portal row number.
-
- 6 replies
- 6k views
-
-
I have a food ordering database for a school. There is a student table and an orders table (one to many). I need to create food tickets showing the student name and the orders they have for a given day. I'd like them to look like tickets that the kids can bring to the servers. So far I can't figure out a way to make reports print in two columns. Nor can I figure out how to keep the body (part with the food orders) from splitting across pages. HELP! I have a cludgy work around where I use a relationship to aggregate all of the orders into one field in the student table. Then it doesn't have to be a report. Problem is, all students then print even those without orders (t…
-
- 1 reply
- 1k views
-
-
I know this may seem odd to some people, but im trying to get a date field to be quicker for data entry.. Ex instead of typing 01/01/01 as a date you can type 010101 and Auto-Enter an auto enter calculation will format it to a correct date format of 01/01/01. My Calculated auto entry is: Case ( Length ( datetest )=6 ; Date ( Left ( datetest ;2 ) ;Middle ( datetest ; 3 ;2 ) ; Right ( datetest; 2 ) )) Pretty Simple and straightforward... but the problem is I always get errors of wrong date format. Any ideas how to do this?
-
- 6 replies
- 1.4k views
-
-
I have a field named Groups that is populated from a checkbox with a value list. I need to change some of the group names in the value list, but I also need the records already in the database to change to the new names also. How should I do this?
-
- 17 replies
- 2.1k views
-
-
I'm using FM 6.0 v2. At my high school we have a Driver Education file stored on a server. A secretary accesses this file from her desk and I access it from home. Everything works good except it opens in the wrong layout. In Preferences/Document/When Opening I have the "Switch To Layout" box checked to the correct layout, but it opens with the wrong layout. I also wrote a script to get to the correct layout and in Preferences/Document/When Opening I checked the box "Perform Script". This doesn't work either. Any ideas?
-
- 4 replies
- 962 views
-
-
I'm attempting to parse data from a web viewer window into a new record. All good. The problem is that once a new record is created the web viewer refreshes and goes back the the original login screen not the client screen I was on. Tried a portal with no luck.
-
- 2 replies
- 1.2k views
-
-
Certain data in portal not writing to record: Go to portal row [select;first] Go to (primary key) field [Registrant::RegistrationNo] Set field [Registrant::RegistrationNo = $$Reg_Nbr] Go to (secondary key) [Registrant::RegistrationNo_Sub] Set Next Serial Value [Registrant::RegistrationNo_Sub] (Did in layout) Copy Record/Request Problem: primary key wrote, secondary key did not. This portion of file structure: Registration PK Registration::RegistrationNo Registrants (1 - 4) PK Registrant::RegistrationNo SK Registrant::RegistrationNo_Sub (1 - 4)(max can not exceed 4)
-
- 7 replies
- 1.4k views
-
-
I am changing a custom values list to be a table managed list. The custom values list looks like so: Alert Fun -- Sad Depressed -- Silent -- Scared Mean I need to be able to keep the grouped values together and use the separators. I have found that I can use a space in the separator records to get around the duplicate values issue. My problem is that I am left with an additional "sort" value in the value list when trying to keep my grouping of values correct. Any thoughts about how to elegantly recreate this custom values list in a table managed solution? TIA, Aaron
-
- 0 replies
- 1k views
-
-
This has had 35 views and nobody seems to know if it's possible... I guess I have an unsolvable (via FMP) problem). Thank you to everyone who contributes on this forum, you save me often! I am working on my site and I can't upgrade the SSL due to cash issues (another story). Obviously, I need to access the site, but when I go there via the Web Viewer I get the [color:red]expired server certificate error. Does anyone know a setting so I can get around this? I can bypass it in my browsers, why not FMP? - Mac, Firefox/Safari, FMP 8.5.
-
- 2 replies
- 1.4k views
-
-
Join us for the return of SmallCo's FileMaker Design Caucus Thursday, Aug 28 at 3 pm Eastern Time (UTC - 4). No Caucus membership is required. Join as a guest at: http://smallco.net/caucus See FileMaker solutions from FileMaker, Inc. and five of your developer colleagues, and vote for the best solutions in three categories: 1. Best Bang for the Buck: the smallest change that afforded the biggest improvement for the user. 2. More Than Skin Deep: the layout redesign that best expresses the user's world. 3. Why Didn't I Think Of That? the most creative re-thinking of an app's first screen. See you there! -- Albert Harum-Alvarez Sma…
-
- 0 replies
- 1.4k views
-
-
Hi guys, hoping that someone can sort out this highlighting problem I have. I'm using a database that when you click into a portal, the colours of everything within it are sort of inverted (the dark grey background becomes light grey, cyan boxes become orange, etc). It's lurid and horrible. Now this happens under XP but not OS X (OS X simply applies a grey tone to selected objects). I wouldn't be surprised if this is an operating system issue rather than anything to do with FileMaker but after a long hour of searching, I've found nothing. I've noticed that any object within the portal that is static (a non-enterable field, the portal background, etc) is simply r…
-
- 4 replies
- 1.6k views
-
-
Hello, I regularly use custom colors on my layouts. Each time I exit the program, I lose all of the custom colors I had previously set. Does anyone know if there is a way to save or store these custom colors between sessions? It is so frustrating to have to set them all up each time I open FileMaker. Thanks!
-
- 8 replies
- 6.3k views
-
-
Hi - I've been happily using various features form the Scriptology Theme Library since I bought it last year, just by trail and error and have found it very useful. One area I can't seem to grasp on my own though is how to achieve the nice gradual color changes on graphical layout objects like I see in many of the Layouts. I note that when I copy an object to my solution and re-size it vertically to fit my own design, I get the hard bands of color. Similarly, the menu of 'Gradients' appears to be a really useful tool for, I'm just guessing, overlaying a light/dark transparent object over a solid-colored object to achieve that nice "grading" of color. Yes? But how? …
-
- 2 replies
- 1.6k views
-
-
Hi, I have a hosted database. Some users can access it through the network and some through the web. I want that after users login go to the first layout. I have set up the order of the layouts but apparently it only takes effect on the layout pop-up menu. I want that the first layout users see is the first on that pop-up. It keeps showing me other layout.
-
- 0 replies
- 918 views
-
-
It seems to me there must be a way to alter the size of a button without having to drag it with a mouse. In the world of Pages, there would be an "Inspector" where I could define its length and width. How to do that with Filemaker 9 Pro? Thanks.
-
- 3 replies
- 3.3k views
-
-
I have a field that uses checkboxes with custom values. I want to sort by these custom values. (I have club members select 2 forms of community service -- I want to then list everyone who signed on for each of the 5 forms. The problem is, the standard sort by custom value will only allow the club member's name to appear in the first of the custom values checked off. Their name will not appear under second option they have checked. I want the names to appear twice in the sort, but the sort will not repeat. How do I generate a list of names by these checkbox custom values?
-
- 1 reply
- 869 views
-
-
Hi, In a script I have defined the value of a variable named $$VOLNAAM.... now I want to print the value in the lay-out.... I have no idea what format to use in the text field. The following formats don't work: <> <<$$VOLNAAM>> &&VOLNAAM Any idea??
-
- 3 replies
- 2.6k views
-
-
Hello - is it possible to place a button ( with script) in a table view? Thank you - Alon
-
- 6 replies
- 9.6k views
-
-
Is there an easy way to make filemaker omit a line in the body part of a report if the fields in that line are zero or empty, so as to avoid empty lines? In omnis, you can set the report field attributes to make the relevant report line non-printing if the value of the field in question is zero, but I can't see any equivalent method in filemaker.
-
- 1 reply
- 1.3k views
-
-
Trying to search Amazon MP3 Downloads via a webviewer, however a URL string that works in browser (returning results for mp3's only) returns a generic search of all amazon (not just mp3s)? Check example file. (same behaviour mac/pc) Any ideas why this happens, workarounds? Many Thanks Olly WebViewer.zip
-
- 2 replies
- 1.5k views
-
-
Could anyone help me solving this? How to create a script for the Flag that can control the "NO" and make all fonts inside "Description" becoming bold + underline, even when I print out? Example attached. Best James Portalrow.zip
-
- 5 replies
- 2k views
-
-
This topic is so basic I'm embarrassed not to have found the answer in old posts or elsewhere: Is there a way to have a header when in form view, that stays on the screen when you scroll down, the way it does in list view? I have a layout that I don't want to be viewed in list view, with a lot of buttons and some other stuff at the top, and which is too big for my monitor. I would like to be able to scroll down without losing sight of my buttons, etc. at the top. - - - - TIA.
-
- 3 replies
- 1.7k views
-
-
Hi everyone... My layouts contain several buttons with scripts. Most of the buttons open a URL or a file on a server, or start a specific search within the database. Everything works fine, and what I really like is that most of my scripts are not attached to a "real" button anymore, but to any kind of object, most of the times it is a simple field. For example, instead of having a little button that says "Go to full record" next to a name, the user simply clicks on the name and the new window with the person’s full record opens. My question is: Is it possible to attach a script to specific words in a text field (instead of attaching it to the whole field)? …
-
- 0 replies
- 977 views
-
-
Does anyone have a solution for resolving date and time conflicts? Here's what I mean. In a portal I'm displaying a series of collected timestamped events for an employee (Time tracking). This is the administrative view that allows an admin to edit, add or delete entries made by the employees. Being the feature it is, the admin could accidentally enter or edit an entry that overlaps the time value of another entry. Now I don't want to prevent that but I do want to display the result (conditional format) and draw attention to the conflict. Each record has a start and stop timestamp and the total time as the difference between the stop and start. I have to b…
-
- 2 replies
- 1.1k views
-
-
Hi, I'm pretty new to FM, so I hope this is the right forum. I have 3 tables in my database: Jobs, Companies, and PIC (Person in charge). Each Job is performed by one Company. Each Company has several PIC's. Therefore, I have related Jobs and Companies through the "Company Name". Companies and PICs are related through the "Company ID#". The user looking at the Jobs database can select a Company for the Job by pulling down a drop-down list with a value list based on the "Company Name" field. The appropriate information fields about the company then display as static fields in a portal. However, I want the user to also be able to select one of the the PICs from th…
-
- 1 reply
- 1k views
-
-
Good afternoon everyone, I'm working on an application that generates invoices using data from a Timesheet table and a separate Purchases table. I've created a separate Summary table which contains the Timesheet records in one portal and the Purchases in a second portal. Often the time associated with jobs is part billed, so I've used a check box in the Timesheet portal to filter which records should be added to the final invoice (which is in a separate table). So far, so good. I can build the invoice correctly by placing portals for the Purchases and Timesheet on the invoice layout. However, I need to be able to produce an invoice history for each job…
-
- 0 replies
- 1k views
-
-
So, the main menu for my solution is just that: a menu. The user clicks the button to go to the database he or she needs. The table for the Main menu naturally has 0 records, which is fine. The problem comes with the user clicks somewhere other than on a button. They get the windows "WHUM" and an error saying the action cannot be performed because the required table is missing. My thought as a solution is to make a script that runs when the main menu is opened. The entire script would be: Set Error Capture [on] Pause/Resume [indefinitly] Set Error Capture [off] The problem with this is that while the script is running, the user can't …
-
- 4 replies
- 1.4k views
-
-
Hello. Can somebody help me? I'm trying to make a recipe file that calculate the price of a recipe. I have a table with the ingrediënts and there prices, i want to use. Is there any example-file i can use?
-
- 4 replies
- 1.7k views
-
-
I want to copy text from a field on a layout and paste it into a field in a web site in Web Viewer on that same layout. Although I can type into the field in Web Viewer, I cannot paste from the clipboard. Is this a knowm limitation or am I doing something wrong. I'm using Filemaker Pro Advanced 9 on Mac Leopard.
-
- 4 replies
- 2.6k views
-
-
I have a peculiar issue I hope someone can shine some light on for me. On one of my layouts I have several portals showing related data. Whenever I make changes to the related data in the portal, the last modified timestamp and username I have displayed do not update. However updating non-portal data updates the user and modified timestamp properly. Any insight would be greatly appreciated.
-
- 0 replies
- 916 views
-
-
I had a value list based on a list of suppliers I entered directly/manually into a special field for the purpose. I changed this to base the value list on the actual suppliers I have created records for. So, add a new supplier, and then the value list will automatically change to include that. But something is awry - the value list is fine except that there are 3 suppliers who appear twice in it. I checked, and there is definitely only one record for each of these suppliers. I experimented with deleting one of the suppliers, and their name still appears twice! So how does this work - it has some kind of memory for what was listed? How do I change this? Its like…
-
- 14 replies
- 2.3k views
-
-
Well this started as a question, but now it’s a tip, with a question (VB Script related) at the end. The goal is to display a PDF document in the web viewer, but use FM to control what the users can do. I don’t want them to be able to print or save as etc. I want those actions to be controlled by script and logged. You cannot prevent a user from saving a copy of the document if you allow them to open it with Adobe Reader. I tried placing a button or a field over the web viewer, with access only to the scroll bar, but for some reason the Web Viewer always places itself on top of the button. So the user can still right click it and print, save etc. The Man…
-
- 0 replies
- 1.6k views
-
-
Hi, I have a table which is used to create recipes. In the creation of the recipe I need to select each ingredient from the Products table. Each ingredient then needs the amount put in. I can get the field to properly list the ingredients, but how do I set-up the table so I can add as many ingredients as possible? The number of fields for ingredients will be different with each recipe. Also, how do I link the amount field to the ingredient field when amount is an edit box and ingredients is a value list? I need to do it this way because I will also be creating a Meal Planner table which will select recipes for each meal on a specific date. I will als…
-
- 1 reply
- 1k views
-
-
Hello, I've searched this forum as well as the FileMaker Developer forums, and it would appear that I am the first and only person to ever inquire about "bullet points". My question is actually very simple. I've got a word processing document in a word processor. It contains text. Some portions of the text have bullet points. Where the bullet points are, the text is automatically indented. Very basic, standard, nothing fancy going on. I want to transfer this bullet-formatted text onto a Filemaker layout. In my word processor, I select-all, copy, mosey on over to FileMaker, Layout mode, Text tool, click in the layout, and Paste. The text comes on over. So does most …
-
- 8 replies
- 6.6k views
-
-
Hey, I’ve got a problem when it comes to pasting text that comes from MS Word into fields. What gets inserted comes with all the text formatting from the original document. But this is not what I want... Font size and font should stay the way I set it on the layout. Is there a way to insert text without the original format? Thanks! Mike
-
- 5 replies
- 1.2k views
-
-
Hello everyone. I would think that this would be a very common task, so hopefully someone will know how to do it! I have a Firstname and a LastName field (so that records can be sorted by last name) and I want my layout to display a condensed full name without a bunch of extra space between the names if the first name doesn't fill the entire fixed-width box. Easy enough; I can use a calculation field or a merge field, right? But, I also want the name to be editable. How can I do both of these things? Thank you!
-
- 1 reply
- 868 views
-
-
I'm trying to make a solution with clairvoyance like the on from John Mark Osborne, it just doesn't work, i have attached the file i made if someone could tell me what i'm doing wrong. test.fp7.zip
-
- 1 reply
- 1.4k views
-
-
Is there a way to make a layout the default layout when opening a database?
-
- 4 replies
- 9.3k views
-
-
Hello and thanks in advance for your help I did a layout and I need include the number of record, the number of found record and the total record. As in status area. Should appears so the form: 1 of 5 when we do a "find" thank you. jjf
-
- 7 replies
- 1.9k views
-
-
I have one file with two tables -- each with a listview layout of records including a header and body. Both have the same types and number of fields. Both sets of fields come from the current table. When navigating to the listview in table A, (200 records) the body displays/refreshes quickly (less than a second) and smoothly downward from row 1 to bottom of screen. When navigating to the listview in table B, (29 records) the body displays/refreshes slowly (about 3 seconds) and downward in a row-by-row cascading fashion from row 1 to bottom of screen. I’ve checked for overlaping parts and the front-to-back field layers in table B, but it still cascades…
-
- 5 replies
- 1.2k views
-
-
Hello I would be eternally thankful if someone is helping me out on this: As the title line says I need to print on partially covered label sheets. Any Avery sheet for that matter. This is to archive film raw material, which is managed in the database. I understand, that for this I'd need a script. Does anyone have a script for this or could help me out and give me a hint how to do it. Oh and it's for an Apple system. I think it should be possible in Filemaker anyway, as in most cases you don't have to print out exactly the number of labels available on the sheet. I need to print the labels on whereever I want, as the tapes don't come in in 20s or …
-
- 2 replies
- 1.9k views
-
-
Hi Everyone, I have to say once again, this is a cracking forum. I'm a newbie but with a fair bit of technology (MS) experience... so the whole FMP thing is new to me. I'm progressing nicely with my solution - the client is happy with the data entry side of things, and we are now looking at the reporting side of things. I have the reports design so now need to implement them... here's my problem: I need to put together a summary report which breaks down costs of a project according to type and category. The information comes from 2 tables - expenseslines and timesheetlines, with each timesheet line or expense line allocated to a specific cost category (di…
-
- 2 replies
- 1.3k views
-
-
I have a layout I use as the front page of the database and is opened with a script when a user logs on. It only has one record and is mainly used as a home page for the users. There is a calculated field on the page but this is unstored and just shows the logged on user. It also has a portal on the page related to that user. It works well (So far). The problem I have is that this database is on a network with a number of users. When more than one user is logged on they get an error message saying that someone else is accessing this record. This message only appears at log on not in the general use of the database. As no information is being stored in this record there is…
-
- 6 replies
- 1.6k views
-
-
Hello -- I'm trying to setup a layout where I have a portal showing all records of, say, "classes". In this portal I need to match the current record of the layout to the row's record. all_classes is a cartesian product of class: class::id x all_classes::id I defined a field in class called "__is_current" as If(id = all_classes::id; 1; 0) Problem is now that the rows only match the first class record, not the currently shown. Example: Viewing class id 1, the portals reads: all_classes::id | id | __is_current 1 | 1 | Yes 2 | 1 | No 3 | 1 | No Viewing class id 2, the portal reads: all_classes::id | id | __i…
-
- 4 replies
- 1.4k views
-
-
Hi, I am new at the FMFORUMS and I find it fantastic. I am trying to find a way to create submenus, meaning that i will have a pop-up menu and inside of it some kind of a submenu so if i will choose an option from the submenu automatically that will select the root of the submenu. I hope i am clear enough. I would appreciate any help . Paul
-
- 0 replies
- 1.3k views
-
-
I have not seen a post that answers this, but direct me if this has already been answered. I have a line item portal on my invoice layout. extPrice has the following case statement in the definition: Case ( ProductCode= "ServAgr" ; ( CopiesAllowed * CPC) ; ProductCode= "ServAgrColor" ; ( CopiesAllowed Color * CPC Color) ; ( Quantity * Price ) * ( 1 - ( Discount / 100 ) )) When the first line item is either one of the two conditional items (servAgr or ServAgrColor), the calculation works AND all other line items will pull the correct price. It does not work, however, if one of these two conditional items are entered in on any other line except the first…
-
- 4 replies
- 1.2k views
-
-
With our current software, users regularly enter customer numbers for invoices. If, however, they don't know the customer number, they can instead type in the first few letters of the customer's name and search through all the records that start that way, and then select the one they want. I'm wondering if this is at all possible in Filemaker with portals. Basically, the portal would link to the customer database, and a field above it would take in the name. Any customers who's name started with what the user types in shows up in the portal. For example: User types in: Ar Portal results: Ark Supplies Arol's Tool Depot Aroma Candles (these compan…
-
- 2 replies
- 1k views
-
-
I have a main, sort of 'overview' form with a number of portals to show the progress of jobs through a production cycle. I realise I need TO's of my Jobs table to filter the different portals but what is the best way to exclude records that have no date in a particular field? TIA
-
- 6 replies
- 1.4k views
-
-
I thought this was going to be an easy task but apparently not: How do I remove the Title Case attribute from a text field? While in Layout mode, I highlighted the field (named Title) via the Format->Style->Plain Text menu choice, but that didn't work. Next, I wrote a script (see attached) but I think I botched it in the highlighted instruction therein. I have about a thousand records to change so doing so manually would take too long. Any ideas how I'd improve on my script to make the change? TIA for your help! Rich
-
- 19 replies
- 4.1k views
-
-
Hi: I have created a simple file to demonstrate what I am trying to achieve. Basically I am trying to filter a value list to present the user with available position codes for a specific date. I have used Ray Cologon's ZapValues custom function to filter the available codes and then used the field "ListAvaiablePositionCodes" for the value list. The problem I am having is that when I create a record and select a date the drop-down menu sometimes displays "". If I click the "ListAvaiablePositionCodes" field the drop-down menu is updated. I realise that there may be an easier way to do this, if so can someone let me know. DynamicValueListFiltered.fp7.z…
-
- 0 replies
- 1.2k views
-
-
After following the threads and also receiving excellent help on this forum, I am one piece short and pulling my hair out - and I'm no spring chicken! I have 5 tables: Students, Assets, Transaction line items, transactions in, transactions out... The purpose is to allow students to checkout and return equipment and keep track of it. I may have done this wrong... but you can see the relationships. Everything seems to be working except (and this is where my thinking may be WAY OFF)... the checkin area. Is it wise to have two different tables - one for check outs and one for check ins? The checkout area works fine... I can enter a student ID and get the relate…
-
- 0 replies
- 992 views
-
-
So, I'm starting to get into tab controls for a potential solution that's needed, and I'm wondering just how dynamic they can be. The solution is a revisions database. When a 'noticeable' change is made to a product, it keeps its unique ID number, but a revision number is incremented. I'd like to have the tab control show information for the most recent revision (that is, the one currently being used), while tabs behind it show previous revisions of the item. Revisions are specified by the month they occurred in, and we're allowing up to 10 revisions per month, though this is more than we'll probably ever need. When the user chooses to view the revision…
-
- 1 reply
- 1.7k views
-
-
Hi, Is there a way I can accept the user entered input at the time of script execution ? In other words, is it possible for users to enter the data in the field(which is not a part of DB) and use that field value for calculation and manipulation ? I would appreciate your ideas on this. Thanks
-
- 2 replies
- 1.1k views
-
-
I'm trying to get some system of conditional formatting to display RECENT or OUTDATED depending on the date with regards to a "Date" field. I'm just a newb, so be nice =P I'm not sure if I can do it as a drop down list and set it up as values (0 = Recent, 1 = Outdated) or if I need to set it up as regular text (Displaying Outdated to match background when within desired time period... and vice versa). I've attached a quick .fp7 to give you a visual and the field names. Thanks for any help. Dated.zip
-
- 4 replies
- 1.5k views
-
-
Hello, I represent a company called Sutherland Design Agency and I am creating my first database with file maker. My CEO wants me to set up a drop-down menu on our time cards that lists all the open projects. I created another table that has project name and a radio button set with status: open, closed. I want to be able to filter the project name field in a value list so that if a project is closed it doesn't show up in the drop-down menu on our time cards. My boss says this is definitely possible, but i'm not sure how to do it. I'm a total beginner. Any help would be appreciated. Thank you, Logan
-
- 0 replies
- 971 views
-
-
I've just realised that things are not going as I expected. I'm trying to add a number of portals to a main form to give me an overview of all my orders, jobs accounts etc. regardless of what customer they relate to. I'm wondering what to base the main layout on as this does not actually hold any fields - it's all portals but it's relationship seems to be causing a problem.
-
- 1 reply
- 873 views
-
-
I think the answer to this is likely simple. In the real world I'm taking soil samples and counting the numbers of individuals of species in each sample. In FMP 9 I've got Samples, Sample-Species, and Species tables. On a Samples table layout I have a Sample-Species table portal on it in which for each record I have a dropdown menu for Genus and a dropdown menu for Species. When I select the Genus, I want the Species list to be filtered by Genus. Genus and Species are two fields in the same Species table. I've tried a variety of relationship graph arrangements but I can't seem to do this simple logical thing. Thanks for your help.
-
- 3 replies
- 1.1k views
-
-
I am trying to line up a heading with 3 title columns (the part is a Title Header). I have all the columns aligned the same at the bottom (I used the alignment button), but when I go to Preview Mode one of my titles is way higher than the others. The other 2 are lined up perfectly, however, in Layout Mode all 3 are lined up perfectly. Am I missing something? Thanks, Michelle
-
- 2 replies
- 978 views
-
-
two questions: 1) i have FIELD 1 wherein i input data separated by semicolon (. sometimes there can be 2 or more values. what i want is on FIELD 2, to put automatically the first value. so if field 1 contains: group1 ; group2 ; group3 then field2 should contain only group1. 2)somethins like q.1 above but this time the separator is not ; but a space between data. thank you for any help
-
- 6 replies
- 2.1k views
-
-
This will be a dumb question. When I print in filemaker my PC always says from "Page 1 to 1" instead of having the button "All" clicked. When I change it it stays changed, until I relogin to Filemaker. A Page Setup script step before printing has no effect on this. Where does one specify what "pages" of the Printout should be printed by default? Thanks spongebob. Filemaker 8.5v2
-
- 3 replies
- 1k views
-
-
Hi there! I'm trying to add a "written communications" module to my database, allowing me to produce personalized letters and faxes. However, I can't seem to work around the fact that some texts are short (1 page total) and others will be longer (2 or more pages). Is there a way to define a "flexible size" for the bodytext field in the letter layout, without having to let my users tamper in layout mode themselves? Or maybe a workaround, that first calculates the number of lines required to print the full text and then decides on what layout it needs? Or - if at all possible - get FMP to open an MS Word template and print the lot from there? I know…
-
- 1 reply
- 970 views
-
-
Hmmmmmmmmmmmmmm I have a Text Field called "hello". I type some text into it. On my printlayout I have a Textbox with <> in it to print the fieldcontents (Plain vanilla up to here...yes). That Box is fully justified so the left and right so the edges look nice incase theres lots of text. Problem: Sometimes, when I type some text like a phrase with the string R-01122 at the end into the Textfield, the R is cut off on the right hand side from the printout (as well as on the layout one can see it). This happens when the text R-01122 is on the far right hand side of the text and FM wants to make the break top the next line where the - is. ie when …
-
- 2 replies
- 1.2k views
-
-
hello.. i have a second table occurrence of a 'contacts' table showing related contacts working at the same company. This is fine, but it's very rigid. For instance, contacts at "Widget Corp" and "Widget Corp, Inc." aren't showing that they're related. short of forcing every company to be spelled EXACTLY the same, what can i do to make this relationship 'bend' a little? the only 2 ways i can think of at the moment would be either: 1. adding a new 'tag' field.. and typing the common word ("widget") there. Then basing the relationship on that.. OR 2. somehow exploding each word in the Company string and doing an "OR" type of comparison.. somethin…
-
- 9 replies
- 1.3k views
-
-
I'm going nuts here -- I've got a simple little database I use for my own purposes, and it's real minimal in terms of function -- just a few layouts and sometimes a second window open. Somehow I tinkered with the windows, maybe doign a little layout work, or navigating to a different layout with the second window . . . and now when I open the File, the main window is hidden behind the second one and I have to drag it out and resize it. I figured onece I dragged it back tpo where it belonged, if I shut it down and re-opened, it would be back where I want it, but no . . . I know I can write opening scripts to control what windows open, what size, position etc. -- …
-
- 4 replies
- 1.4k views
-
-
i've got a self join 'notes' table, containing a client's call history. Some of these note will have a follow up date attached to them. right now, when i (brian) log in, i see the last 5 notes left flagged with my name. I also have a global field to allow adjusting the date range ('show brian's notes scheduled over the next [5, 10, 30] days'). i'd LIKE to see only the notes that have a follow up date. Can't figure out what to add to the relationship. Thinking of creating a calc field that sets itself to "1" for notes with a follow up date and doing something with that, to filter out the non-important notes (the ones not requiring a follow up).. other sugge…
-
- 5 replies
- 1.3k views
-
-
I would like to know how can i change filemaker menu like in Busines productivity control.
-
- 1 reply
- 1k views
-
-
Are there any techniques to bold the text of only the selected items in a set of check boxes? I've done some searching but have come up empty.
-
- 5 replies
- 2.6k views
-
-
I had made a reply to you, and then the Forum went down before it posted. Check out this file Link and there are also a couple of files at databasepros.com Link just search for High HTH Lee
-
- 2 replies
- 1.3k views
-
-
When I create layouts on my Mac using Custom Colors I seem to have complete control. When I enter the same values on Windows, I get totally different colors, and once hue, saturation, and brightness are set it seems to force the RGB values rather than accept my input. The color differences are greater than might be expected just due to different monitors. Anyone have a solution to matching colors across platforms? Is there a basic difference in how color is managed between the two operating systems? Thanks in advance.
-
- 2 replies
- 1.1k views
-
-
One of the interesting features of the Web Viewer is the ability to display almost anything you can throw at it. Attached is a simple demo file that shows how to do something similar with just one table and either a list or portal view to that table. It is a method for displaying data held in a Filemaker list (text field, global text field, or $$variable). The idea is that you make a set of records, in a table called Array. In it simplest form, there are only two fields. A number field "Index", going from 1 to N. And a calc field, Display, GetValue( $$array; Index). Now ANYTHING you put in global variable $$array will be displayed in the record list f…
-
- 24 replies
- 3.9k views
-
-
I have an accounts portal which shows 'invoices' and 'credits' with summary fields below showing total credits, debits and the balance. My customer will get commission on these entries, but I also need to be account for cash sales but exclude them from the portal and summary fields or my commission figure is thrown out. Any ideas?
-
- 0 replies
- 1.1k views
-
-
Hello, I have a portal that I am using for entering data on various contacts (which is stored in a CONTACTS table) that are associated with a particular piece of media (found in the MEDIA table). I have it setup so that the name of the contact auto-completes based on previous entries. However, it would save a lot of time if the other fields (address, phone number, etc.) would also auto-complete based on name selection. In other words, if I type in a name that already exists, the other fields that are associated with that contact will automatically populate. Is there way to do this with my current setup? Hopefully, I've provided enough information. If I have…
-
- 9 replies
- 2.8k views
-
-
Hi, I have a portal that sum up all the orders a customer as made in my client's layout. I'd like to print a summary of that portal so I can see all the orders made so far but can't figure it out. How should I do ? Thanks
-
- 1 reply
- 1.2k views
-
-
I have a PDF (of a WORD file) that is 13 pages long. It is the manual entry form for the database, for those people that do not have, or are uncomfortable with, or cannot afford enough entry stations to support the user data collection community. Print and complete, with data entry later. The DB uses multiple layouts and tabs within the layouts to get all the data collected. In paper form, this translates into different presentations (popup menus on paper are tough :-) so printing the on-screen input layouts is not practical. Filemaker 9, appears to constrain the layout to 10 pages (actually 8000 pixels - a key differentiator) in portrait mode. The paper repo…
-
- 0 replies
- 1.2k views
-
-
I manage a school database accessible to non-technical users. The database opens to an 'entry screen' with buttons for various activities. I would like the entry screen to display some basic information, such as current enrollment by classroom, etc. If I script a report to summarize the data using summary fields, I realize I need to display in Preview--but then the buttons don't function, and I don't get to use the full screen width, just page width. If I use GetSummary(), I can't figure out how to see subtotals for all of the classrooms--just the total for the classroom of the currently selected record. Is there a way to do this? Thanks!
-
- 2 replies
- 974 views
-
Recently Browsing 0
- No registered users viewing this page.