FileMaker Interface Features
-
Create a table with two text fields, "Color" and "Sample". Allow the user to enter a hex color (e.g., FF0000 for red, 00FF00 for green, etc) in the "Color" field, and have the fill color of the "Sample" field change to that color. Possible?
-
- 3 replies
- 1.7k views
-
-
Hi All, I'm creating a recipe database (don't groan!). In the Ingredients table I have fields for Ingredients, Measure type, Quantity etc. In the Recipe table I have RecipeName, Method etc. I bring these together on a Recipe layout, where for each recipe there is a portal for ingredients with their corresponding quantities and other fields. Some ingredients are used (and so entered) more than once in a recipe, but I don't think this is a problem. I've used a value list based on the Ingredients field to enter the ingredients into the portal, and it all LOOKS good. If I do a find on the portal the find works OK, finding only recipes that include the ingredient reques…
-
- 2 replies
- 1.5k views
-
-
I am trying to create a survey using a visual analog scale, where the person doing the survey, answers a question by selecting a point anywhere along a 100mm line. If the start of the line is selected it should return the value 0, and at the end 100. Any point along the line any value b/w 0 and 100. Multiple radiobuttons is limited by the number that can be squeezed in, and is not a true visual analog scale. A slider like a volume bar or scroll bar may work?? Anyone know a way to solve this problem?
-
- 44 replies
- 15.5k views
-
-
Thanks to the help from the forum, I was able to write a script that can automatically check values for multiple records in a checkbox set. See: http://www.fmforums.com/forum/showtopic.php?tid/199116 Now I'd like to know if it's possible to do the same for unchecking values. Anyone?
-
- 6 replies
- 1.4k views
-
-
I have a database with two tables. These tables are related. One of the table layouts has a portal that displays values from a field in the other table. Right now it displays ALL of the values. I would like it to only display the values from FOUND records. How would I go about doing this?
-
- 4 replies
- 1.5k views
-
-
I am using the Purchase Order Tracker solution program that came with FMP8. I have modified it a bit and I have a quick question. (it will be quick for you) I have to determine popularity of a given item. A lookup, not a calculation, because I need historical reference as well. We place items on a purchase order to be ordered. Each line can contain one item. I have a Purchase Order table and an ItemsOrdered table. When we order an item, we specify the item and the quantity ordered. I need one more field (the lookup) that will tell me how many of that item I have ordered over the last 6 months (I can change the time frame later)
-
- 1 reply
- 1.1k views
-
-
I have a portion of a database that keeps track of wait time. I have a report that is supposed to group my data by start time, and average the number of minutes waited for each hour. I have a summary field for number of minutes waited. I get the report all laid out and it's working great. Then, suddenly, it stops grouping the data on the preview view. I can still see the grand total, but not the sub-summaries. I have no idea what could be causing the sudden change. The only way I've found to fix it is to recreate the report from scratch.
-
- 2 replies
- 1.2k views
-
-
I know this questions has been asked about 1000 times on this forum, but after reading all of them I think I might be more confused. Outline: Policy_Page [has basic info on a policy ie policy number, face amount etc...] Policy_Note Page [has basic info on what is typed in on the portal ie: date, subject and check boxes to indicate which categorize the note should be filtered in] Relationship: Policy_Notes::Rel_PolicyID = Policies::PolicyID Policy_Notes::Chk_1 = Policies::Chk_1 Question: Is there a way to use the check boxes on the portal (On Policy_Page) to filter the portal. Ie: I click the check box "1" -- want it to show only items r…
-
- 9 replies
- 1.9k views
-
-
Hi Everyone, I have just started working with FileMaker Pro for an internship that I am doing and I don't know what I am doing. I need help in changing the field names to a database. I did the process that the tutorial tells me but it is still not going through in the actual database. Can someone help me?? thanks
-
- 1 reply
- 872 views
-
-
I'd really appreciate any help with the following problem. I have a field that contains a value list, shown as a checkbox set. Different records have different checkboxes checked. In a certain layout, I'd like to check one of the boxes for a certain found set of records. I now have this script: Go to Record [First] Loop Insert Calculated Result [select; fieldname ; value] Go to Record [Next; Exit after last] End Loop This works, but it replaces the current checked boxes, because I use "[select;...]". But if I don't use that, I doesn't work. I get an error message telling me that my field doesn't except the new value. What am I doing wrong? …
-
- 5 replies
- 1.3k views
-
-
This seems like it should be really easy, but can't find any mention of this on the forum. I would like to have one button that when clicked, goes to the next record of a found set and on more clicks, continues to loop through all the records even after reaching the end. So instead of having 2 separate buttons for previous and next, they just keep cycling through the records with the one button. Thanks for the help!
-
- 6 replies
- 4.9k views
-
-
I have quite a few calculation fields displayed on a layout. I want to leave field behaviour set to not allow the field to be entered in Browse mode so as not to confuse the user into thinking the field can be edited. However, I would also like access to the Ctrl-Click functions like Find Matching Records. I can script each separate button as If( Get(ActiveModifierKeys)=4; Go to Field.... then specify each field for each button, but one single script entering the field 'Self' would be way smarter. Is this possible? Phil Sorry, probablt should have posted this in scriptmaker?
-
- 0 replies
- 1.6k views
-
-
Is it possible to filter a portal in Filemaker v5.5. I have a portal based on a date (job date), which shows all of the jobs for that date. Now I want to filter out the jobs which we do in house. These jobs are designated with a check box. If possible what is the best way to do this. Keep in mind I am using FM v5.5. Thanks in advance...
-
- 1 reply
- 1.3k views
-
-
I'm revisiting a topic I pondered over a year ago: How to display iconic representations of information without having to store the corresponding icons in the individual records? Up to now, I've used a container field or two in a very limited number of tables, with each field using a lookup-style calculation. This has always seemed cumbersome for these reasons: In records with just a handful of text and numeric fields, adding corresponding container fields for icons greatly expands the table size*. Displaying corresponding icons should be a runtime activity -- equivalent to the Format as Boolean capability for numeric values. Deciding (at runtime)…
-
- 7 replies
- 1.3k views
-
-
Runtime solution that contains a multiple page layout in Preview Mode. Without making the status area available to the user, Windows will advance to the next page of the report by pressing CTRL+down arrow. I cannot find an equivalent command on the Mac. I've tried Apple-down arrow, CTRL-down arrow, and Option-down arrow to no success. Any insight from you Mac FileMaker geniuses? Thanks. Jerry
-
- 2 replies
- 1.3k views
-
-
I need to put in a 15 page contract in filemaker, but the layout will only go up to 110 inches. So is there a way i can a) Extend the length of the layout or : Make a 2nd column to print. Eg: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x normal page x 2nd column page x normal page x 2nd column page x normal page x 2nd column page x normal page x 2nd column page x normal page x 2nd column page
-
- 3 replies
- 1.4k views
-
-
I have a font that I use all over and I tried to set a filed to that font in Layout with no success. When I'm in View mode and switch to that font in the filed, it types correctly. Any ideas? Mike
-
- 5 replies
- 2k views
-
-
I am having a wonderful time right now with a relational value list that works, kind of... I have a company table, a location table and an order table. Both the Order table and the location table are related to the Company table by the "ContacID" field. When I create a new order, the ship location field will display a drop down value list of all related values from the location table, based on ContactID. Well, it works beautifully for all companies that were imported into the database when we went live. What I just found it, however, is that for all companies that are being created in the database now, the value list will only show the FIRST related locatio…
-
- 10 replies
- 1.4k views
-
-
I have a table with a calculated field whose value depends on various conditions. I use that field for a value list elsewhere. I would like to 'snapshot'or 'save' that value list to fix the contents so that it can be applied later, even though the values in the original table, and hence the original value list, may have changed. Hope that makes sense. Any way to do that?
-
- 4 replies
- 1.3k views
-
-
I have a field that is a drop-down list displaying a value list. The value list is "Use values from field: " and I'm selecting a field from another table. It all works fine, except one thing. If you enter the field and begin to type, the list will scroll to the whatever you're typing... as long as you type fast enough. If you pause in your typing, it starts over. If I type "Cust" quickly it will go to "Customer". But, if I type slowly, it will go to "Customer", then "User", then "Supervisor", then "Trainee" I have other databases where you can type as fast or slow as you like and it works the same. I can't tell the difference in the field setup or in …
-
- 13 replies
- 4k views
-
-
Hi all, I am currently facing two situation with a portal which I believe to be related to relationship. This portal reside on a Job form where each row relates to a record in the [color:brown]Job_Lines table. Each job gets assigned to a [color:red]customer. Problem 1: The first column of the portal contain the [color:red]Product Name field (value list of all the product). Once selected, the rest of the line get populated as well. In column two however, two different values can be inserted: [color:red]Product Code or [color:red]SKU. [color:red]Product Code is taken from the [color:brown]Products table and [color:red]SKU comes from a [color:brown…
-
- 4 replies
- 1.2k views
-
-
I have a text box like: texttext <> text and field name are normally different colors On a certain condition, I want both to be invisible on a white background, so I set the condition for the text color to be white. Under that condition, only the 'texttext' part of the box becomes white. Anything I can do?? TIA
-
- 3 replies
- 1.4k views
-
-
Hi All, I have a table of students. To group those from the same family I use a self-join relationship based on surname & home phone and display them in a portal. Both the relationship and the portal are sorted by student contact hours, descending. I need to calculate a family discount rate so that if the student falls into the top row of the portal, they calc as 1, otherwise as 0.9 Since there seems to be no First() function, I changed the relationship & portal sorts to descending and used If( Last(MyFamilyMembers::NameFull) = NameFull; 1;.9 ) My flawed logic: "If I am at the person at the bottom of the list, give me a 1, otherwise giv…
-
- 10 replies
- 2k views
-
-
Hi. in advanced thanks for looking into this post. i am an IT Consultant and have been working on a database where i have a list of all of my clients, technicians, issue tracker, work orders, etc. The database is nearly perfect and about 90% complete. The last 10% i am struggling. here is the issue: I have a Clients table: Client Code (Related) Client Name Address, Etc. I have an Appointments table: Client Code (Related) Visit Type Technician, Date, Etc. I have an Issue Tracking Table Client Code (Related) Priority Date, Etc. Currently there are 3 Accounts in the database. Admin and 2 technicians who enter work orders. What…
-
- 4 replies
- 1.3k views
-
-
I frequently use a value list for data entry. That is, I insert data from one table into another via a value list. I set the first field of the value list to be the record ID and set the second field to be the client name. I then set choose the “include all values” radio button and place a check in “Show values only from the second field”. However, the value list only displays the second field if the field is displayed as a pop-up menu. If it is set as a drop-down list, the first field displays. Is this a bug? Or must I always use a pop-up menu to display the second field?
-
- 2 replies
- 1.2k views
-
-
I would like to limit the number of character that a user can enter. I understand setting up the field with the Maximum set to the desired number, but the user can enter as many characters as he wants. The user doesn't know he's gone over the, let's say, 80 character limit until he tries to go to the next field. At which time, the error message shows up. Is there a way to have filemaker stop allowing any characters to be typed in to the field when past the limited number of characters?
-
- 21 replies
- 4.3k views
-
-
I have an Employee table occurrence (TO) which has a related Manager TO through a field called ManagerID. I have created field called StatusID in the Manager table. This StatusID field is related to a table called Status. On the Employee layout (with the Employee table as its source), I have created a dropdown for the ManagerID field which works fine and refreshes the ManagerName edit box which is located right beside it. I have also created a dropdown for the StatusID field and I want to display the StatusDescription edit box right beside it. The StatusID field works fine but the StatusDescription field does not refresh when a StatusID is chosen from the dropdown.…
-
- 1 reply
- 966 views
-
-
I've inherited a file that displays the header when in Table View. I've tried to copy the exact same technique into my own file, even going so far as to copy the same header, same depth. Yet it doesn't work for me. Header is ignored on display. Both files running under FMP9 Advanced. Any clues on how to display the header when in Table View? Kind regards,
-
- 2 replies
- 1.1k views
-
-
Hello, I have been using FileMaker Pro since version 6, and now using version 9.03. My question concerns using multiple portals on one layout and from the same table. I am using a relational database Payitems--workorderlog----entryform Heres my setup: I have place a portal with 1-20 rows on the top half of the entry form and a portal with 1-6 rows on the bottom have of the form. The data is being pulled from the same table; in this case, "work order log" The pay items contains the labor cost and material cost which automatically populates the line items of the workorder log and entry form Within the workorder log I have material line- item f…
-
- 9 replies
- 2.4k views
-
-
Hi all, I would like to import images as folder following the order sorted by name. I have images with name 0.jpg to 2547.jpg. however when i imported, it starts from 939.jpg. anyone can give me some hints on that? archlight Regards
-
- 2 replies
- 1.4k views
-
-
I'm a little new to FMPro. I hope this is the correct forum. What's the best way to protect (make it read only) an individual sales order once it has been invoiced? I have a field in the sales order table that is either empty (not invoiced) or contains a timestamp (date/time of invoicing) that can be used to test if the order has been invoiced. I have a feeling that this could be done with read-only permissions on single records, but don't know how to do this.
-
- 4 replies
- 1.2k views
-
-
I'm migrating a 54-table database (ie 54 files) from FM5 to 9. Navigation from one table to another has been using an "Open file" script step on a button. That script step is not IWP compatible. How can you script navigation that works on FM client (our power users) but also on IWP (for our regular users)? I could use an open URL script step, but that would presumably foul the FM client "open file" step.
-
- 8 replies
- 1.5k views
-
-
Had been using this URL for a nice simple small online clock for display in layouts: http://www.clarify.net/peter/digitalclock.html Anyone know if there is a new location for this one or perhaps another URL for a small digital clock display? Thanks
-
- 2 replies
- 1.2k views
-
-
I am having difficulty figuring out how to use the GetSummary function and was wondering if someone could help me out. I am creating a table that displays therapists and their treatment time(in minutes) of patients. The output looks like this using a 'summary field' for total time-min when sorted by therapist. Therapist 1 Total minutes 160 patient1 40 patient2 40 patient3 40 patient4 40 Therapist 2 Total minutes 240 patient1 60 patient2 60 patient3 60 patient4 60 I would like to add a field that converts the field total time-min to hours and have tried the creating a calculation using the GetSummary()function (using tot…
-
- 9 replies
- 1.6k views
-
-
I am trying to highlight multiple entries in a portal by using conditional formatting. So far, I can only get it to highlight one row at a time. Does anyone have any suggestions on how to make this work? Thanks!
-
- 10 replies
- 2.5k views
-
-
I am a new user of Mac and am checking out compatible database systems for our small business. Our needs are basic, but I do not have a lot of experience or time to create something that will fits our needs. Maybe my question is simple enough to get an answer on this forum (that's my hope anyway). I can use any one of the templates available and edit it, but I am not sure how to get the results I am looking for. For example, 1. I need a field that will "timestamp" before entering notes in the notes field. The notes field will need to hold 6-8 entries. 2. When I send an email from FM I need a copy sent to the notes field. Any suggestions/help would be great…
-
- 1 reply
- 1.1k views
-
-
First, I apologize if this is the wrong area for this post, but my suspicion is that layouts will ultimately hold the key. I have recently become responsible for maintaining the database for a school. Currently, they have a somewhat convoluted (albeit functional) set of FM databases. They have one separate database for students, one for instructors, another for classes, and another for the current semester. Each semester, they copy the last semester's database and erase all of the data. I want to bring all of these pieces together into one database. I've started doing it, but one issue that I can see looming on the horizon is maintaining the separation betwe…
-
- 2 replies
- 1k views
-
-
I dunno if anyone has done this as a sample yet, but here is one just in case there isnt one out there already. Highlighting portal rows in FM9 using conditional formatting. It will work with seperation of data as well, so no more added relationships and calcs needed in the data file strictly for highlighting purposes. Enjoy. Highlight_portal_FM9.zip
-
- 6 replies
- 4.1k views
-
-
Hi, I'm an infrequent FMP programmer. Here's my dilemma: Consider a table of People with field Lastname (to simplify). I want to create a portal that filters based on matches to a last name search criteria that I enter in a global field. So, if I enter "J" in that field, I want to see all the names starting with "J". If I instead enter "Jon", I want to see those starting with "Jon", such as "Jones", "Jonsa" etc. After digging into other posts, I understand that my previous attempts failed due to a relationship based on an unstored calculation. However, I fail to see how to solve this, even using "Ugo's Method". This seems like a very basic need. Is …
-
- 2 replies
- 1.1k views
-
-
Hi all, I have come across some unindented tab behaviour: In a layout with several tabs I am entering information into a field on tab 5, suddenly the layout switches to tab 1, but still displays the fields from tab 5. This only happens sometimes, not always. I have made sure that all fields are within tab boundaries and that the tabs are embedded in the body only. I do not have an explanation at this stage - can somebody help? Is this a bug? Cheers, Berny
-
- 3 replies
- 2.3k views
-
-
Hi all - as part of my portal, I am using a calculated field to return either a value or a "blank". What I want to achieve is to then assign a button(script) to that field in the portal, but for this to only be there when there is a value present i.e. if there is a value the hand cursor should appear and the button can be pressed, whereas "blank" doesn't result in the hand cursor nor the ability to press the button. At the moment no matter if there is a value or not, the hand cursor is appearing and the button can be triggered. Clearly this is happening because the field is still there, its only the condition of the field that says whether something is shown or …
-
- 3 replies
- 2.5k views
-
-
I am working on a database to help secondary school students choose majors in high school.Different High Schools have different major selections. I would like to create a drop down box field with the selections being the high schools in the district, and then, based on that selection, have another drop down box to allow the student to choose one of the majors offered by that high school. Can a selection by one drop down box control the selections offered in another drop down box?
-
- 1 reply
- 1.1k views
-
-
I have a "to do list" in a portal. Works great. When the to do item is completed a date is inserted. The not yet completed items don't have this date. How do I get a count of the not yet completed items? Something along the lines of: If (IsEmpty ( To Do::Date Completed ) ; Count ( To Do::To Do ID) ) This obviously doesn't work because once a completed date is entered into any of the items, it quits counting. I think I'm on the right track, just not there yet.
-
- 2 replies
- 959 views
-
-
is it possible to have an input field within a custom dialog box to include a drop down value list ? thanks ben
-
- 1 reply
- 1.9k views
-
-
Ok, I have a number of databases linked. After I navigate to one from another, the screen flickers/flashes. Is there a way to do the navigating smoother so it looks better?
-
- 6 replies
- 3.1k views
-
-
Since I can't install Filemaker at work, I develop my tools at home and convert to a runtime to use at work. I develop on my MacBook (OSX.5 and FMP8 Adv) and use on my XP Professional Dell at work. I ventured into using a pop-up window. Point being I am entering invoices and need to tweak the vendor record. I click on a button and go to that vendor record. When I went to close it, there X was grayed out. I opened the file on the MacBook. There I could close the Vendor pop-up window. Back on the XP I couldn't. I didn't see options to control it. Is it a matter of the OS used or runtime vs full application?
-
- 2 replies
- 1.2k views
-
-
Hi, I'm trying to get information from a portal into a printout. Table 1 (T1) - File Information Table 2 (T2) - Notes (Date & Note field) T1 has a portal where users can enter data into T2. T1 will NOT always have records in T2. (Hence I cannot print the data from the T2 table) I need to print out a report from table T1 showing concatenated data from related T2 using a value list of related records then a field ValueListItems ( Get(FileName) ; "Notes" ) This works fine with the exception that the records in the field do not sort by date order. I tried using a portal on screen and locking it to the bottom of the screen so it will …
-
- 4 replies
- 1.2k views
-
-
I an order system where I have a relation calculated value list based upon that a researcher has a head of department and depending what projects (cost centre) that head of the department carry the researcher can choose (only from that head of departments and no other heads projects) a project (cost centre) to debit the purchase. The value list doesn't work unless it's "been triggered" by adding a new project... After a new project has been added the new project AND the already existing projects spring to live... I realize there is some relation error and mostly wonder if anyone has experienced anything similar? Cheers!
-
- 2 replies
- 972 views
-
-
Is there a way to create a list of layout names with associated tables, as shown in the Set Layout Order dialog box?
-
- 9 replies
- 1.7k views
-
-
Managing Complexity, Mangling Complexity, Round 2 FileMaker Design Caucus 10.08 Thursday Oct. 30th, 3 pm Eastern Time, Noon Pacific (1900 UTC) --- Help decide the topic & lead the discussion at the next Design Caucus, and [NEW!] post document images in advance at: http://gallery.me.com/smallco#100132 This is the second round for this topic, with more documents to share and more caucus members on mic. If you'd like to be heard at this caucus, please arrive one half hour early, with a working headset. Microphones alone are not good enough due to the potential for audio feedback! How have you dealt with very complex application architecture? Do …
-
- 0 replies
- 1.2k views
-
-
Can anyone help me or show me the way to do this with filemaker please. Having looked for all the templates and examples I cannot find anything even remotely close to what i want to achieve with filemaker. Before i explain further,i will just summarise the extent of my knowledge and ability. I previously used Excel to collect data in conjuction with macro enabled word documents,I am quite advanced in vb scripting which has helped when in comes to filemaker scripts,but i still consider myself to be a learner in that particular department. The reason I switched to filemaker I think is quite obvious because of the data handling capability and speed of excel. So i…
-
- 13 replies
- 1.6k views
-
-
Hi all, using FMPro6, I would like to change a defined value list field to a plain text field. I figured out how to delete the defined value list, but an empty dropdown menu is still there. Sorry, I am pretty new to FM still. Thanks all, Heeter
-
- 2 replies
- 998 views
-
-
I can't seem to figure out how to calculate if a value in one field is one of the values in a checkbox list. When I use Case (field1 = List ( field2 );"something happens"), "something happens" only when just one checkbox is checked. But I want this to be true when the same value is checked, no matter if there are others checked as well. Does this make sense? I hope someone can help me out... VAB
-
- 13 replies
- 1.5k views
-
-
Is there any easy way to do this that I'm just not aware of? I have a value list ("All Departments") populated by values in the field "Department" stored within the table "Users". In the "Hardware" table (which has a relationship to "Users") there's a text field "DeptFilter" that's global, set to display as a checkbox set using "All Departments". When the user clicks a "Find" button they're presented with a simple layout showing the "DeptFilter" field as an assortment of checkboxes. In theory, they select one or more checkboxes and click OK which then triggers the script to show only those hardware records tied to the selected department. Selecting a S…
-
- 7 replies
- 2.4k views
-
-
I have only been using FM for a very short time, and I am sure this is an operational error, but I can't work it out. I have a couple of layouts where I have selected the alternate row color in the body, but it just won't show. Strangely I have a couple of other layouts in the same file where it is working. It is driving me mad. Any suggestions would be most appreciated.
-
- 1 reply
- 4.6k views
-
-
Hi - I am new to Custom Menus and am trying to make mine context sensitive but having trouble with getting the required calculations for the menu item names to be up to date. I have a simple global field (g_context) which defines the context I want shown in the menu. I have defined a menu item which uses that global field for the override title. It works on first use - but does not seem to keep up to date as the field g_context changes. I have tried to ensure records are correctly committed and that the window is refreshed and joins updated - but nothing seems to reliably change the menu item correctly. Can anyone shed light on what I am missing. …
-
- 2 replies
- 1.5k views
-
-
Hi, I was wondering if it was possible to create a chart without a plugin? I went on the chartmaker site, downloaded the demo and the weren't any plugins. How can we generate such charts? Thank
-
- 2 replies
- 2k views
-
-
After messing around with the table view, I just discovered that you can't copy and paste multiple fields like you can in Excel. This functionality is very important to one of my clients and I was wondering if anyone has come up with an elegant way of addressing this problem. Specifically, the client would like to copy most of a given row (but not all of it so duplicate won't work) and tab down the list pasting it (but not in every row) with keyboard shortcuts. I thought about just having copy and paste buttons for each row in Form View, but this still isn't as easy as being able to use arrow keys or tabs. Any ideas? Thanks, Brien
-
- 6 replies
- 10.6k views
-
-
I am having problems with a checkbox set. I have a list of procedures identified by item numbers and descriptors. These are two fields of a table. There are also corresponding unit values for each procedures. Multiple procedures can be used for one patient - they are selected by a checkbox value list. I am trying to write an invoice using this data. By using a "merge field" I can get a list of the item numbers, but only the first of the corresponding "descriptions" and "unit values" appear. Am I going about this completely the wrong way, or can you suggest any solutions. Ultimately I need to multiply the unit value for each selected item by a …
-
- 2 replies
- 1.1k views
-
-
Hi. (I apologise if this topic is in the wrong area - it seemed like the best spot, but feel free to move it if need be.) I am looking to write a POS system for a client of mine. I've written them before but not in FmPro. I am looking to see if anybody knows of- or has written a popup keyboard function - used mainly for the touch screen environment. Cheers, Greg
-
- 2 replies
- 1.1k views
-
-
Having a problem here. Working on a database for a law firm. Main table is Cases and the related table is Clients. A case can have many clients. Clients can be active or closed. Attorneys are assigned on the client level. An existing report shows attorney client assignments for active cases using the sub-summary report feature and a summary field. We search for active clients and sort by assigned attorney and the display is like: Atty Assignments Brenda 17 Bob 20 Sarah 15 This worked great until they realized they need to see not only a count of the client assignments but also a count of the number of unique cases comprising the attorney assignment…
-
- 8 replies
- 1.3k views
-
-
Hello, I have a popup menu value list that displays only the second field (oil_supply). The first one is just a serial number (000203). I also have a different field that calculates ( Filter ( Proper (oil_supply) ; "ABCDEFGHIJKLMNOPQRSTUVXYWZ" )) and only displays the first 3 letters from that field. The problem is it will calculate the first value field (Serial Numbers) instead of the second (oil_supply). Is there a calculation that uses the second value field instead of the default first one? Thanks
-
- 8 replies
- 2.4k views
-
-
As I am new to Filemaker I stumbled over a problem that I can't find any topics or help in FM. How do I in a correct way setup a layout so it matches I.E. an MS Word A4 document. I mean what is important to think about with the header, body and footer? And even more I need to have three A4 size pages on one layout as I will send them as PDF files to the costumer. Can some body please direct me to a topic or any instructions for this. Thanks, Mats
-
- 7 replies
- 2.4k views
-
-
Hi, I have one client computer (iBook G4) that has a weird issue with Arial 12 font. Whenever the person types a small "c" it either comes up on the screen as a small "g" or capital "T". I also noticed that some other fields that are from a relational database have replaced the C's with other letters. I tried changing the font type and size and it will display correctly. It's only happening to this one machine. Any thoughts? Thanks! Raschelle P.S. Attached is a screen shot. Notice in the grayed fields that Project looks like ProjeTt. (FM 9v3/FMS 9v3 & 10.5.5)
-
- 3 replies
- 1.2k views
-
-
We have a 1:many relationship set up within a database. Is there anyway to associate multiple child records to one parent without using a portal? We want to be able to take advantage of the sliding functionality for the child records as they are of varying lengths but understand that sliding does not work within a portal. Suggestions?
-
- 3 replies
- 1.6k views
-
-
Is there a way to make it so that if the radio box = "Lingerie" then it will automatically change the layout to "Layout2". If the radio box = "Toys" it will change the layout to "layout1".
-
- 2 replies
- 1.2k views
-
-
Hi all friends the attached HTML file shows a grafh of 12 columns on Win... ... but they are nine, because the last 3 are zero height. Mac shows exactly, but Win NO. Can someone expert of HTML say me why ? P.S.: change the extension from .txt to .html and open with a browser. test.txt
-
- 15 replies
- 2.6k views
-
-
When using the type ahead feature I'd like the drop down menu to not display at all or if it must display to be blank until the user begins typing in the data entry field. My users find the scroll list of many hundreds of records confusing when nothing has been entered. Is this possible? Kind regards,
-
- 3 replies
- 1.7k views
-
-
Does anyone have any experience with using non-body parts to display data in Form View? Right now, for some of my data entry tables I have two layouts, a list view and a form (detail) view. In the name of simplicity and the principle of "Return your user to where they left," I'd like to use one layout for both views. What I've come up with is to have on layout with a small body in which I've put the contact's name. Then I've put all the detail info in a trailing grand-summary part. In List view the summary doesn't show, just the name. In Form view, both parts show, with the name in a decent enough location on the screen. Do you see any downsides to t…
-
- 2 replies
- 1.2k views
-
-
I’m planning to use TEXTRACTOR in a document management system to extract text from PDF documents, and make the contents searchable. I want the users to be able to view the extracted text, but not to interact with it (ie copy to clipboard, export field contents etc.). To prevent them doing that I have to turn off access to the field in Browse mode - but then they don’t get the scrollbar… I tried using a plain text field on a layout, and I have tried with the web viewer. Using this as the Web Viewer URL : "data:text/plain," & Fieldname I can view the text on the Web Viewer, but if I disallow interaction with the viewer, I cannot navigate through the pages.…
-
- 11 replies
- 2.3k views
-
-
I am wanting to create a list of letters of the alphabet, which when clicked upon will execute a script (that will return records beginning with that specific letter) and then highlight that letter in the list. I can envisage 26 buttons each calling the same script passing in the chosen letter. Where I am struggling is with how to highlight the letter somewhere in this process. I have spent hours barking up lots of wrong trees!! Can anyone help me please. Many thanks Tim
-
- 2 replies
- 1.1k views
-
-
I created an invoice layout. Everything is working, except that I can only get one product from the Sales Orders TO to display. Here's my setup: Sales Orders: SalesProj portal (used to choose project from Project TO) ProjProd portal (displays all products for specified project in Project TO) Sales Invoice: Show records from ProjProd In the body I have the Product Name field from ProjProd Everything works fine except I only get the first product to display. I believe I must be missing something simple or have some setting incorrect. Thanks for any help and push in the right direction.
-
- 2 replies
- 1.2k views
-
-
I suppose the title says it all. I have a table layout mode. It includes some information about a student and I want to print out several tables according to one specific field, each table having it's own page with the matching fields. Can this be done? I find that the Part Section is fairly confusing if you haven't used it before and I think I need a fairly clean explanation on how to do this, I keep thinking it might be a script I have to create but again, I am not even sure. Thanks! -Keith
-
- 9 replies
- 1.1k views
-
-
hi everyone, i suppose the answer to my question is very easy: how can i highlight the search results in a portal row field thank you
-
- 3 replies
- 2.3k views
-
-
Hello All, In creating a new layer I have a number field for account numbers, However when the number exceeds 7 characters and if you click out of the field it will open spaces in the field no longer showing all numbers until you reclick in the field and all numbers look normal. This would not be such a big deal but I need to print these numbers and not spaces in the field. Why would clicking out of the field make it show spaces in the number and not the entire number until reclicked into ? Any help please. Thx much Erick
-
- 4 replies
- 1.1k views
-
-
Hi all, Apologies if this is not the right place to post this question. I have a FM file where I have imported a JPG image into a container. I would like to double click the image and have the source image open externally in "Preview" (The mac default image viewing software) Could anyone suggest how this would be done? Thanks! =)
-
- 0 replies
- 1.3k views
-
-
I don't need a full blown calendar, just a way to display events/appointments whose date ranges overlap. Just need this in a simple field. For example, I have an event that took place over the course of a year. Let's call this event Age 13 (since I was 13 for a whole year). I am inputting some other events (journal entries) that also fall within this time frame. So, after I finish putting in the start and end date of the journal entry, it would show me in a text box or portal any other events that overlap. In this example, the event: Age 13 would overlap. I don't know how to do this. It seems like it should be simple. Help Please! Jeffrey
-
- 11 replies
- 2.3k views
-
-
Frequently I see icons or small graphics in various computer programs (for example Win Vista) that I would like to use in FileMaker. Is there a way to copy them as a graphic and create buttons for use in FM?
-
- 3 replies
- 1.5k views
-
-
This has probably been answered before, however... I have a database that I am developing. In one table (called Books) I have a handful of fields which includes 'Book Title' (text) and 'Level' (numerical value). In another table, I have a value list that uses values from Book Title (First Field) and Level (Second Field). What I need to happen is: When a user selects a Book Title from the value list, it then displays the Book Title, plus it also displays the Level in a separate field. How do I make this happen? Regards, Michael.
-
- 2 replies
- 1.2k views
-
-
I have a product catalog that is automatically created from the line item records in an inventory table. The script that creates the catalog sorts the products by category and via the use of a sub-summary the catalog comes out nicely with headers at the top of each new category as you flip through the book. However, I would like to be able to have a table of contents automatically created with the page numbers of each category. How might this be accomplished? Basically I would need Filemaker to be able to calculate on which page each new category would begin when sorted by category. I hope that makes sense.
-
- 4 replies
- 2.7k views
-
-
I'm 99% done with this database (hooray!), having figured out just about all of my woes and worries. Now, after sitting in front of my screen for nearly eight hours getting everything ready, I've run into a snag that my sleep deprived mind can't connect. Here's the relevant part of my relationship graph: On the PAYMENTS table, when a new payment is received the user first selects the exhibitor from which the payment was received. This is established through the relationship between the PAYMENTS and EXHIBITORS 2 tables. I have a value list that's created from all of the exhibitor names in the EXHIBITORS 2 table and it works nicely. I run into my proble…
-
- 11 replies
- 3.5k views
-
-
hi, i am fairly new to filemaker and am wondering if there is a way to select an item on a value drop down list and have that automatically go to a different layout? example: I have a drop down value list in a contact list database made up of: Client, Freelancer, Employee... and so on. i want to be able to select client in that drop down list and then have that automatically navigate to the client layout in the contact database or if i select freelancer to have it go to the freelancer layout in the contact database. Is there anyway to do this without selecting additional buttons?
-
- 6 replies
- 2k views
-
-
Dear filemaker oricles, I am not an expert by all means, i am just doing a simple data base for my training center. I have setup two fields, 'course type' and 'course fee'. The course type field is a dropdown list of all our courses. I want the 'course fee' field to auto-fill itself depending on the course thatis selected from the drop-down list. The problem i am having is, i can't figure out how to assign prices to each entry in the value list. Any help would be fantastic
-
- 2 replies
- 2k views
-
-
Hello, Is it feasible to use a pdf in a field for layout/printing purposes? I need to print records to a specific (state issued) form. What I've been trying to do is insert that form as a pdf into a field which is behind all the other pertinent fields in the print layout. I believe I can only do the insertion on a Mac, which is fine. I've actually accomplished this and it works beautifully on the Mac. My problem is when I host the db on FMP server and view/print from a windows xp machine. The quality is pitiful and not usable. Am I going about this the right way? The form has fonts not currently installed on the systems which is why I tried the pdf route. I …
-
- 2 replies
- 1k views
-
-
I have three tables: A: Casino Names B:Slot Machines Inventory C.Game Types Relationship A to B: a casino can have many games Relationship B to C: a game type can be on many games Keys Table A: Casino Name (1) Table B: Game's Location (1) & Game Type (2) Table C: Game Type(2) I would like to make a portal on the CASINO NAMES Table. I can get the portal to show all the games at the casino (i.e) [Portal] Row 1. Cash Gold Asset# 54 Row 2. Cash Gold Asset# 56 Row 3. Money Magic Asset # 58 Row 4. Green Cash Asset # 89 Row 5. Cash Gold Asset # 90 Row 6. Green Cash Asset # 88 But I would like the portal to show for a s…
-
- 1 reply
- 1.2k views
-
-
Anyone know if it is possible to page down a portal window? thanks
-
- 6 replies
- 1.5k views
-
-
I have what seems to be a simple relationship problem but am completely stumped by what to do. I have a database which include the tables 'jobs' and 'teams' Relevant fields: Jobs Team 1 Team 2 Team 3 Team 4 All teams (calculated join of all fields above) Hours Teams Team name Total hours (summary of Jobs:Hours) The relationship is All Teams = Team name This was all good before I needed to include the hours (this is the expected hours that the team will work on the job in the next week). This returns a total in the summary as it should. The only issue is when I need to have teams work on jobs for different amounts each week. I …
-
- 1 reply
- 1.1k views
-
-
I want to be able to highlight a portion of the text in a field and then run a script to change the text's color. Is there a way to do that? Thanks
-
- 6 replies
- 2.1k views
-
-
I have a portal that shows records from table2 in table1. The related fields are datefield (dateformat in table2) and timestampfield (timestamp format in table1). When the user picks a date in datefield the portal will display all records the user has done on that day. It works if i change the timestampfield to dateformat, but don't if i use timestamp. Is there a way of making the relation/portal to do right?
-
- 2 replies
- 2.2k views
-
-
Hi, I have recently upgraded to 8 then 8.5 from 7 (windows platform) and the fonts are being displayed in a n anti-aliased style (not smooth) when in 100% mode. If I move to 150% or 75% they are smoothed but obviously I can't do this as all my layouts are full of many sized fonts and it would be a mammoth task to reshape every layout. Besides if I am viewing in 150% then the print size will be too small. Anyone encountered this before? Any suggestions? I have tried EditPreferences.. and all the options there. Interesting note: oproblem is worse (fonts are sketchier) in 8.5 than in 8! It's like the further it gets away from the native 7 format the les…
-
- 4 replies
- 1.8k views
-
-
Hi there, I would appreciate some help on this, how can I change the style of a field by clicking in a check box? for example: check box | text field [x] | [color:red]text here changes style (color, or strikeout)
-
- 2 replies
- 1.1k views
-
-
I think I have finally poked enough keys I found my answer after I posted below. Will this do what I need?..it seems to work If[Get(RecordNumber)=Get(TotalRecordCount) Show Custom Dialog etc. ect. Hi, On my layout I have an arrow to move to the "Next" recod. How would I script the button so that when the user has advanced to the last record a message would show "You have reached the lat record" I know how to do the message part...I just cant seem to figure out how to script the button to know when it has reached the last record in the db. Thanks, Jim
-
- 3 replies
- 1.3k views
-
-
Hello all: I'm setting up my application to run in kiosk/runtime mode and I'm getting the error "Your access privleges do not allow you to perform this action". What is the minimum privleges needed for an account to run in kiosk mode. I've created an account named kiosk (for lack of a better name) and set the privlege set to the documentation below: a. In the Edit Privilege Set dialog box, give the privilege set a name and description. b. For Layouts, Value Lists, and Scripts, select either All view only or All no access. c. Clear the Manage extended privileges checkbox. What am I missing? Thanks.
-
- 2 replies
- 1.8k views
-
-
I started a project and got it almost done however I am simply missing the understanding of report layouts (preview mode) vs the same in list view and possibly relationships between tables or so I believe. For the description of project you can see this thread: http://fmforums.com/forum/showtopic.php?tid/198469/ Basically I have two main tables. Orders and OrderItems. It is a one to many relationship. What I need is to get a set of reports. I got some of the reports working but not all. I added a third table named Items. I related that to OrderItems via SKU number so that will give me a report of total quantities for each SKU number. What I need t…
-
- 10 replies
- 1.4k views
-
-
using a drop-down menu list is a simple way to provide a limited set of possible field entries BUT, just use copy & paste to enter any field contend you want (or better: dont want) in the drop-down menu field Any ideas how to block copy & paste for drop down menu fields? thanks norbert
-
- 2 replies
- 974 views
-
-
Hello guys, I have a table with a date field (called expiration) and I need to create a new layout (columnar list) that shows only the expired records (expiration < today). I have looked around for a bit but I couldn't find anything about that. Can someone please point me on the right direction? Thanks and have a nice day!
-
- 7 replies
- 1.3k views
-
-
Hey everyone, I am working on a database for a metal recycling company. I have 2 Tables. A customer table and a service order table. They both act as different modules (customer module and invoice module). I have relationships set between the two so that when I start a new service order from a customer it automatically sets name, phone number, and address to its appropriate value. On the customer module, I set up a metal pricing list so that the owner can set the price per pound paid for each metal type (ie Customer ABC TOWING has thier prices set to: brass is 10 cents per pound, copper is 13 cents per pound, steel is 18 cents per pound, etc). On the invoi…
-
- 7 replies
- 7.6k views
-
-
Hello, I'm not sure this is the right place for my question but I couldn't find a better place. I need to remove a container field from a FM9 DB but when I try to do that I get a message that sounds like "the field x can't be delated because is used by the privilege y" I checked out the privilege but I couldn't find anything about that. How can I delete the field? Thanks and have a great day ! Sig
-
- 2 replies
- 946 views
-
-
Hi, Before I ask my question, I ask that you please bear with me. I'm a novice at best when it comes to Filemaker, but it was thrown into my lap when an employee left. "Hey, you're a Linux guy. Linux guys are smart, you do the Filemaker stuff." We have a system here where customer service can print out a packing slip for an order. In this layout, every item ordered is on it's own line (line item). Among other things, the line item row contains the product name. This has been fine for the most part, but now we've added products which need more space to print out the product name (due to chosen options). In the product name field, if I have a name that is t…
-
- 3 replies
- 3k views
-
-
hello, The "Scenario" I have a table for my CRM System which keeps ALL adresses regardless of the type (supplier, customer, subcontractor,....) called "Address" There is a field "isSupplier" in that table which either says "Yes" or "No" whether the entrie is a supplier or not. Now there's a Table for my Products called "Products"... For each product I want to be able to choose my main supplier from the "Address" table described above and have it associated. to accomplish this the Products table has a "SupplierAddress_ID" numeric field which can contain the AddressId of a supplier. I want to create a ValueList which should show all Entries fr…
-
- 1 reply
- 1.1k views
-
Recently Browsing 0
- No registered users viewing this page.