FileMaker Interface Features

Hi all, I've read through previous posts on conditional value lists but nothing so far seems to fit what I need to do. I'm wondering if someone could give me a nudge in the right direction to move on from this stumbling block I've been at for 3 days! I have 1 table called Sectors This has a key field - Sector The record then has 30 fields making up 10 headings. I should explain a little more perhaps These headings will appear on a document I have: Heading1_1 Heading1_2 Heading1_3 Heading2_1 Heading2_2 Heading2_3 And so on up to Heading10 The user enters what they want in each heading (each heading has 3 rows hence t…

• 4 replies
• 1.6k views

bcooney

January 30, 200818 yr

I am trying to create a pop-up value list to insert an employee ID into a field on an unrelated table (Mail Boxes), so the ID of the employee who opened the mail can be verified and stored. Problem is, employees are in the Contacts table, with all the other contacts. (I thought this would help reduce the number of layouts, fields, etc., especially when hiring an employee already in contacts.) When I make the value list use the fields from contacts, everything is fine, but I get a list of ALL contacts, not just employees. Everything I have done to try to reduce it down to just employees results in . Every contact has a field called Personnel, which contains …

• 3 replies
• 3.1k views

bcooney

January 29, 200818 yr

I have one table (Instructors), related to 3 separate tables (Days_Available, Certifications, and Addresses) by a primary key. In a fifth table (Events), I need to be able to select and schedule Instructors based on information in the 3 related tables (Days_Available, Certifications, and Addresses). Ideally, I would like to see a filtered value list of Instructors that meet the pre-defined criteria of the event. In other words, choose from a list of Instructors that have specified they are available the day of the event, but also meet the event certification requirements, and live in the home state of the event. Step Two of this would be to make the Instructor …

• 7 replies
• 1.8k views

bcooney

January 29, 200818 yr

Is it possible to set up a layout to change based on a logical calculation? For instance, if I had a field that displayed either a "Y" or an "N" and I wanted the layout to make the field's text green if it was a "Y" and red if it was an "N"? Does that make sense?

• 6 replies
• 1.3k views

_henry_

January 29, 200818 yr

Hi folks, New to Filemaker Pro but have successfully connected to our backend SQL2005 server and can read data directly etc. My problem is creating a find/script solution as far as i can make out from reading the forums. Within SQL, I have a database that contains multiple projects all with their own unique id so for example ProjectA = 1701 ProjectB = 1802 I normally file all projects under 2007 with the following projects i.e. Year 2007 ProjectA (Unique SQL ID = 1701) ProjectB (Unique SQL ID = 1702) ProjectC (Unique SQL ID = 1703) etc. Year 2008 ProjectA (Unique SQL ID = 1801) ProjectB (Unique SQL ID = 1802) ProjectC (Unique SQ…

• 1 reply
• 1.1k views

The Big Bear

January 29, 200818 yr

Hi, I have a question about calculating portal row count while also trying to adhere to the data separation model. My understanding of TSM is probably shakey, but when calculations are for interface purposes, one should try to keep them out of the data files and in the interface file. Is that correct? I have a situation where I have a contacts layout in an interface file that is based on a TO of the contacts table (in a separate data file). On this layout I have a portal which displays related "letters" that have been written to the contact. Above the portal I'd like to display the count of letters written to the contact. However, I'd like to avoid ha…

• 2 replies
• 2.9k views

comment

January 29, 200818 yr

I have a Project layout/table with a Project Notes portal to add notes to the project. I am trying to make a button/script that will: 1. Create a new related Note record in the portal 2. Populate a couple of fields in that related record 3. Open a new window (a detail view of the Note record) 4. Commit the record in the original file (so when I start typing in the Detail window it doesn't say "this record is already being modified..."). I think I've figured out everything but committing the record. I think it is committing the record in the popup window, not the original one. I've attached a capture of my script if anyone can help. Thanks much,

• 4 replies
• 1.7k views

bb84604

January 28, 200818 yr

I'm using a repeating field on a layout that contains graphics. I need the graphics to blend from one to next so they look continuous. The field is defined to show the 5 values of the repeating field horizontally, but there is a small gap between the fields. Is there a way to remove that gap? I made sure the borders are not set between values. Thanks.

• 2 replies
• 1k views

comment

January 28, 200818 yr

Hi. I'm new to FM and have attempted a database to keep track of conversations, issues and incidents within out staff. What I am looking for is to have a hidden field named 'Final Notice' that will show within the employee's profile if they were placed on Final Notice. I have unique tables for the overall employee stats, issues, incidents and conversations all linked by the Employee ID field. Within the issues and incidents tables there is a drop down list of disciplinary action, ie verbal, written or final notices. I'm looking to have the hidden 'Final Notice' field within the employees table show text (Is on Final Notice, YES or what have you)…

• 7 replies
• 1.7k views

Fitch

January 28, 200818 yr

Hi, i can't figure it out how to make a dropdown list depending from the selection of another drop down list. Here is the detail: Drop Downlist named (BRANDS) Shows: AUDI, BMW, ACURA, ETC If i select BMW in the other Drop Down List (SUBBRANDS) needs to show only the SubBrands from the selected: BMW (selection)Drop Down List (Brand) SHOWS Drop Down List (Sub Brand) Serie 1 Serie 2 Serie 3 X3 X5 Thanks Gian

• 3 replies
• 1.5k views

The Big Bear

January 28, 200818 yr

Morning, I'm trying to create a database that manages products for sale. The basic setup is very simple. Each product has a unique part number, a manufacturer, a little description, a price and a photo. I would like to be able to search the product database based on the manufacturer and / or the part number. Here's the thing, when I create my layout with a list view, it all works fine. I do not like the list-view look however (the horizontal lines that divide the different parts (header, body, footer) and I also don't like the scroll bar on the side of the window. So, I decided to try to use a portal instead, this way the scroll bar is well within my graphics (…

• 1 reply
• 1.2k views

SM76

January 28, 200818 yr

I have a checkbox set. On a report I would like to display the results of the field from the checkbox in a single row with each value separated by a comma (or anything, really). Filemaker automatically places the next value on a new line. Thanks in advance, Marc

• 17 replies
• 2.2k views

mkruter

January 28, 200818 yr

I'm having trouble entering a new related record in a portal in a new database I have created. I cannot tab to it, or even click on it. I just created a database to consolidate several others that I have used for years. One set is a typical Invoices/Addresses/Products/Lineitems four table database which is working fine. I have exported the Products and LineItems tables to try to create this integrating database. I am now creating a table which records the payments, called Checks. It references the LineItems with CheckNum, so if CheckNum 3401 paid for 2 widgets and 4 gadgets, they show up in a portal in Checks and I get six items for a total of $XX. I put a portal i…

• 2 replies
• 10.5k views

rcarbaugh

January 27, 200818 yr

Hello: Am working with two related files, and prefer to add new records to the second file via a portal in the first. Today, I changed the number of rows to display in the portal from 6 to 10. Afterward, I was not able to tab to the next portal row (to create a new record in the related file), as I was able to do before. Now when I press tab, it goes to the next field (outside the portal). Using the mouse, I can place the cursor on the next row, enter the data, and obtain the desired result (i.e., a new record in the second file). But I would prefer to have that tab-to-the-next-row-within-the-portal feature back. Have not been able to puzzle this one out throug…

• 7 replies
• 1.6k views

rcarbaugh

January 27, 200818 yr

I dont remember how I fixed this before. I have a list of products. I pick each color type for the products. SO, 1 shirt might only have 2 colors available. When entering a sales order I want to type in the product id and in the next field show a list of only the AVAILBLE colors. It seems like it would be simple but I cant seem to figure it out today...

• 9 replies
• 2.1k views

blissland

January 26, 200818 yr

Hi everybody, On a form I have a list of cities. Each record contains only one name in it's "city" field. On a second layout I have placed a map of whole territory. I am pondering over a script to bring me to the location on the map corresponding to the record on the form. Any suggestions are welcome. Thanks

• 2 replies
• 1.1k views

Raybaudi

January 26, 200818 yr

Hi there, I'm struggling with a problem with checkboxs. I have a table of 'groups' which lets the user add groups and then add contacts to each group. I would like to be able to speed up the process by using a checkbox on the 'people' layout allowing the user to add a person to several groups ( and also add groups through the 'other' check box) rather than have to go in and add the person to each group in the group layout which would be more timeconsuming. When I've tried to do this I run into problems, If I have groups 1, 2, and 3 when I add the checkbox it all looks fine but if contactX selects 1, 2 and 3 my groups layout would show that contactX is a member of g…

• 3 replies
• 1.2k views

bcooney

January 25, 200818 yr

Is it the way (possibility) to grab (get) result of [color:red]data URLs in Web Viewer ? GetLayoutObjectAttribute result is space/nathing.

• 15 replies
• 2.9k views

DMDewey

January 25, 200818 yr

Is there any way to disable the scroll wheel function which scrolls rapidly through records? I would prefer it scroll the page up or down rather than change records...

• 1 reply
• 2.3k views

aholtzapfel

January 25, 200818 yr

Hello, I am trying to create a cost estimator. I have created 3 tables that are as follows: Company, item Category and Item Sub Category. The "category" table is linked to "company" and the "Sub Category" table is linked to the "category" table. Now in my 4th Table "Cost Estimator" I created 3 conditional drop-down menus that depending on what the user choses from the first and second one shows different results. So lets say the user choses company A it shows Category A, B and C but if the user choses Company B the Category shows D, E and F. The relationships are as follows: table 1 "Cost Estimator" has a field called "company" as a unique value and is connect…

• 0 replies
• 1.2k views

anja

January 25, 200818 yr

It's been a while since I've used FMP...but I'm trying to get back into database design. I'm on v8.5 now and I can't seem to do the basic task of drag-copying layout elements with keyboard shortcuts...when I drag-copy I get the little + sign like it's copying, but the element just ends up moving. Am I doing something really basic wrong in this version???

• 3 replies
• 1.2k views

_henry_

January 25, 200818 yr

I want to download the page which is displaying in the web viewer in .html format.

• 6 replies
• 1.8k views

Rishali

January 25, 200818 yr

Just encountered a problem with calendar popup when using Leopard Spaces. I'm on Mac OS 10.5.1, FMPA 9.0v3 I have 6 Leopard Spaces setup. My FMP window is in Space-2. The layout has a date field with a calendar popup. Following the date field is a text field with a drop-down menu. When I click in the date field, Spaces shifts me to Space-1 and displays the popup calendar floating unattached. If I select a date, the calendar disappears and the drop-down value list for the next field appears, also floating in Space-1. I reported the bug to FileMaker. Has anyone else encountered the same problem? Does anyone know of a temporary fix? For now, I'm for…

• 0 replies
• 952 views

sprynmd

January 24, 200818 yr

I'm working on a membership database/directory for our church. I have created the main layout to be for a family. On a family's record it has Head of Household name, phone, work, etc. It also has the same for Spouse information. Then there are fields for the names of children. I created a report that nicely puts each family into a "directory" with two columns of families per page. So far so good. But now it gets more complicated. I want to have more detailed information for each person. For example, date of birth, date of joining the church, activities involved in, leadership experience, talents and gifts, whatever. How should I do that? Create a n…

• 6 replies
• 1.9k views

T-Square

January 23, 200818 yr

I have many advertisers. Each advertiser fits into a category, so there may be 100 advertisers and 25 categories. This will be done in FMpro8 How do I make a simple report that lists all the advertisers sorted by category, above each group of advertisers it displays the category and how many advertisers are in each category. I would also like to make a similar report without listing each of the advertisers. Thanks in advance, Marc

• 6 replies
• 1.3k views

UpNorth

January 23, 200818 yr

I have recently upgraded to Filemaker 9.0 from 6.0. In 6.0 I could go to "Access Privileges", then "Overview" and see what layouts my fields were located on. I can't seem to find that feature in 9.0. Can anyone help? Thank you so much.

• 6 replies
• 1.4k views

Lee Smith

January 23, 200818 yr

Is there a way to retunr information from the Web Viewer? I just read this article: http://www.briandunning.com/wv/12 It gives you the Latitude and Longitude for address. Is there a way to grab the info from Latitude and Longitude.

• 15 replies
• 4.3k views

aholtzapfel

January 22, 200818 yr

Is there a way to have a button that when clicked would open up a field in it to reduce space on the form? Like having the field, Investigation Notes be in a popup and fillout the info in the popup, and have it stored in said field without having the actual field taking up real estate?

• 1 reply
• 949 views

Leather Knight

January 22, 200818 yr

I have a database with 8 layouts Most all backgrounds behind type is lt blue In some layouts when you highlite type it turns the selection yellow on other layouts it turns the selection slightly darker than the light blue and you don't know if you have selected it Is there a way yo make the selection turn a specific color?

• 0 replies
• 832 views

linesider

January 22, 200818 yr

Is it possible to combine 2 portals into 1. For example. Say you have 4 tables. Tables 1 and 2 have records with identical keys. Is it possible to use table 3 to merge those portals so when you look at a portal(of table 3) in table 4, all the records in tables 1 and 2 are shown? I was just playing around and wondered if this was possible. If there is a better way, I would love to hear it.

• 0 replies
• 2.1k views

Heathbo

January 21, 200818 yr

Hi all I think this has been ask before but I cannot find it. When there are several records for the same spool number, I would like to display the spool number once until the next spool number and display this number only once until the next spool number appears. The example does not display well once submitted. Example spoolnumber weld number welder id sp1 1 K sp1 2 R sp1 3 A sp2 1 C sp2 2 K sp2 3 A would like the list view to resemble this: spool number weld numbe…

• 3 replies
• 1k views

The Big Bear

January 21, 200818 yr

I am building a little billing program for the people I work with. Some of them are paid on a daily rate and some on hourly. I was thinking of making a radio button to select one or the other. Then I would like to have one field for data input regardless of whether they selected hours or days. Based on the value selected, the data input page would have a label for "Hours Worked," or "Days Worked." Can my version of FMP recognize a field and adjust the text in a label automatically, or will I have to build two different data input layouts?

• 5 replies
• 2k views

Dchall_San_Antonio

January 20, 200818 yr

Hi everyone, I've received great help from here in the past, so I am back to ask more questions. I am trying to put together a FM solution for the company I work for. We write and process a huge number of SQL queries every day. I can't go into much detail because of an NDA, but what I need to put together is a combination tracking/formatting system. I am developing this using FMP 8.5 for Mac OS X. The way we do stuff is by client. And each client will have multiple queries associated with it. In general, my idea so far is to have two related tables, one for each client, and one for each query. But I'm not sure how to associate the query with the …

• 3 replies
• 1.1k views

macviolinist

January 19, 200818 yr

I am trying to create a database to keep track of answers to test questions for many students organized into classes. The tests have different numbers of questions, ranging from about 5 to 20, so I need to be able to add tests as I go along, or change the number of questions. I would like a layout on which I would see a list of students in a class and check boxes for each question on a particular test. The checkboxes are because I only need to keep track of whether a particular student got a particular question right or wrong, so they will be set to a value list with a choice of 1. This way I can analyze student scores and test questions based on different classes, gr…

• 0 replies
• 1.1k views

spoonman

January 19, 200818 yr

Question about Icon I was looking at some of the sample databases inside of FMP and I noticed that there are small icons next to add record, delete record, and find record. One appears as a rolodex card and the find is a magnifying glass. How do i use an icon like that in my DB and are there any other icons to choose from?? Thanks

• 6 replies
• 2.7k views

Leather Knight

January 19, 200818 yr

It looks like I have found a great resource here! I am fairly new to building FMP databases (although I have been a user for years). I have a basic issue I could use help on. I am trying to show that a record is selected in a list view layout with more that just the black line on the left side edge. I would like a graphic that I have in a global container to show in the selected record. I would greatly appreciate any help with this. Thanks

• 1 reply
• 1.1k views

bcooney

January 19, 200818 yr

I'm a teacher who has been setting up FM databases for about 10 years, but I've had zero formal training, so I may have just missed something basic. I work with 4 other teachers and we comprise a team. Each quarter, our students complete a project that counts as 1 grade but is made up of 5 parts, graded by the five subject teachers. I set up a simple database with the students' names, class and fields for the five scores and a field to sum them up. Since our students are divided into 5 classes, I set up an interface table with a global field with the choices for the classes (A, B, C, D, E) and related it to the table with the students. My colleagues click on a class …

• 6 replies
• 1.5k views

Lee Smith

January 18, 200818 yr

Hi All I have a layout linked to a table for "To do" items. Each record has a due date field (in date format) and a done field (a simple yes tickbox). I would like the layout to only show items which are not done (ie do not have a tick in the yes box) and in Due Date order. I am using the List View for the form. Is this possible? John

• 2 replies
• 1.2k views

Jed69

January 18, 200818 yr

Hi Everyone I've been setting up a User Interface made up of splash menus and Reports tied together by scripts to help new users not trained in FMP (some quite young) to navigate a FMP database to look at video-clips and a range of associated "reports". For any new user the "get me out of here" button - Go To Main Menu - is a critical support. However, some of my reports only give their best detail when they are sorted and viewed in Preview mode - which doesn't allow any buttons/scripts to operate. Now, obviously "I" know how to get out of Preview Mode and back to the Main Menu Layout, but a new user - still learning the menu interface - won't - and will therefore becom…

• 4 replies
• 1.2k views

gessie

January 18, 200818 yr

In my customer entry layout I have a portal with a filter so I can enter C and get all companies starting with a C. If I then go to the List layout all customers starting with a C are shown there as well. But if I perform a search in the list layout and return to the entry layout, the search performed in list view is not shown in the portal, the C customers are still shown. Is this just how it is and all searches should be done in the entry layout or is there something I can do so that no matter where the search is done, that search is shown in the portal as well. Thanks for your help, Milo

• 8 replies
• 3.2k views

bcooney

January 17, 200818 yr

Ok If I copy a record it should copy the contents of fields but this does not happen, originally I wanted an unused field to have a value N/A so if it isn't used it is obviously not needed. However the auto complete seems to then errase the data when copying the record for the copy at least, not the original..... So how do I keep a new record with the handy feature of displaying N/A but obviously copy data to a new record when you copy the record, this does not make much sense to me.... Thanks in advance....

• 0 replies
• 873 views

redballoon

January 17, 200818 yr

I have a project that has seperate "modules" (databases), 10 to be exact. When you open the program, you get a control panel with navigation buttons to the different modules; Investigation, Contacts, Research Notes, and so on. The CP is the main menu. I want to have the end user be able to pick from different looks. So I will have, say, 5 different CP's to choose from. By making buttons on them so they can pick the look, they can change to the one they like. Problem: How do I make it so if they like CP-3D, it will be the one that opens everytime first. But if they like CP-Classic, it will be the one that opens up everytime, yet still having the ability to change by c…

• 2 replies
• 1.8k views

FruitFul

January 17, 200818 yr

Hi there, I have a value list that has about 10,000 values. It takes forever to load the first time it's used, but after that, it is very quick. Is there someway I can preload the values into memory in a way that is not disturbing/slow to the user ?

• 7 replies
• 2.5k views

Søren Dyhr

January 17, 200818 yr

For some time I’ve been using repeating fields to hold short-hand keys to data from another table which is then displayed in full on the record via a portal. The repeating field has been the match field for the full data on the other table. But I want to hide the repeating field from my end users, who need to see only the full data displayed in the portal. To achieve this I’ve been using the trick I learnt in this forum of covering the field with another portal which doesn’t display to other users when there is no matching field . (http://fmforums.com/forum/showtopic.php?tid/177010/post/229456/#229456) Now, having also learnt that repeating fields are n…

• 12 replies
• 1.9k views

aliquis

January 17, 200818 yr

Is there a way to make the portal have a horizontal scroll instead of a vertical? Thanks

• 5 replies
• 9.6k views

Leather Knight

January 17, 200818 yr

I am struggling with a concept here. I have a database with a field that contains a URL of an image. For example, http://www.blahblah/images/image.jpg. I set webviewer to use that field as its URL. Great, now I can see the image in my layout. The problem being that I am looking for a way to resize or scale the image in the layout to create a sort of a "catalog". That said, these same images are available to me on a local network hard drive via drive mapping if that is an easier solution. I would appreciate any suggestions... Thanks

• 1 reply
• 1.8k views

Steve Shore

January 16, 200818 yr

Hi, Maybe i missed it, but is there a action equivalent to the "stop" button in a browser. thanks mfrapp

• 0 replies
• 1k views

mfrapp

January 16, 200818 yr

Hi, How can we get a specific value based on the data that user inputed? user enter U_SIZE(global) ____ " System will show the UNIT_PRIZE(based on the data) $_____ Price cart - If size: <25" = $25 <30" = $35 <45" = $45 This price cart is a database in filemaker. variables: SIZE, PRICE If user entered 19", the price will show up as $25 If user entered 26", the price will show up as $35 Thanks in advance, Zu

• 2 replies
• 1.3k views

zukutu

January 16, 200818 yr

I have four tables, company, contact, parking lot, and sweeping event. In my layout there are three portals I have a portal showing the contacts within the company(portal#1) I have a portal showing the parking lots that the contact manages(portal#2) I have a portal showing the sweeping events for each parking lot (portal#3) When i click on portal#1 I have a script that takes me to portal #2 and gives me a list of parking lots portal #1 and #2 work but, I cannot get the related records from portal#2 to show up in portal#3 Is this possible to have more than two portals related in succession? thanks in advance,

• 2 replies
• 1.1k views

ilexinc

January 16, 200818 yr

I've got a very simple fairly-standard Contact Database with two tables, Company & ContactName. The two tables are related through CompanyID and unlimited persons can be added to a company. I have a third file/table (let's call that "Invoices") that "pulls" information from the ContactDatabase via drop-downs and lookups. First, in the "Invoices" table I use a value list of all company names from the contact database. After the selection occurs, (1) I use a "lookup" field to copy over the CompanyID into the Invoice table and then create a relationship with this ID field and the CompanyID field in the ContactDatabase (just it case the company name changes in…

• 3 replies
• 1.7k views

bcooney

January 16, 200818 yr

Hi there, I'm completely new to Filemaker so please bear with me. I have a database (roughly based on the email campaign manager template) in fp9, with related tables. In contacts I add my contact details and in groups I can enter all the groups that individuals can be members of. In Groups I can then add members of each group which is great but I would like to be able to add the members to a group from the contact layout not the groups layout. I added a checkbox set on the contacts layout which takes the group names from a value list, all the names appear and I can select them but my problem is that this assigns new groups for each member rather than assi…

• 0 replies
• 1.2k views

jackkeenan

January 16, 200818 yr

if a print layout script has run? Reason is if I printout a work order for my assembly people to produce a customers order, then customer changes his mind (as they are prone to do occasionally) - Now I think I need to flag whether a work order was printed, then if changes are made since it was printed, to note in a field W/O Modified Date and Modified By, to be picked up and display only if the modifications took place after the print script was run on that record. I hope this made sense, thanks

• 1 reply
• 913 views

aldipalo

January 15, 200818 yr

I have a value list that is actually a checkbox set. As a new case is created, the number populates this field. It is great since they just click a box and it is referenced to the case. But here is my problem... What do I do when the list exceeds 100 cases? The checkbox does not allow for a scrollbar to accommodate the large and growing set of cases.

• 4 replies
• 1.9k views

Leather Knight

January 15, 200818 yr

I have a login dialog window with one field, into which the user types his initials. There are two buttons, Continue and Cancel. Continue is the default button, and as such I want the user to be able to hit RETURN (or the normal ENTER key on a PC) in lieu of clicking Continue. I'm having difficulty doing that. The login is driven by a script which creates the dialog window, positions the cursor in the name field, sets a global variable to "Continue", and then Pauses. In the dialog window, the name field's behavior is set to "move to next field" for RETURN, TAB, and ENTER (to not do that would allow return/tab/enter to be inserted in the name field). Both …

• 0 replies
• 1k views

Mandu

January 15, 200818 yr

I have an odd problem... Bot sure how it happened but I get popup text appearing on a button I created, however with Filemaker pro 9 I don't think there are any controls for popup text on buttons ? I have un grouped the button elements and that stops it, I I recreate the button and put a script on it the popup text reappears... It seems I have a ghost in the machine...

• 1 reply
• 920 views

bcooney

January 15, 200818 yr

Hy! I'm having some problems in my Filemaker, because i'm trying to introduce some changes in my database, i'm trying to put some filemaker files on tab of an existing table. but i don't want it to open in another window... the same window in a diferent tab.

• 0 replies
• 1.5k views

albano pereira

January 15, 200818 yr

Hi all i have a db with lots of fields. Some records need all the fields and some records only need a few fields. Is there any way i can select what fields can be seen in a record? many thanks

• 9 replies
• 2.1k views

transit

January 15, 200818 yr

Hi all, I have to compare the price by diffent vendor and check box the buy. Maybe you take some time to see my attachment you with understand. Thank for help! Comparison.zip

• 0 replies
• 1.1k views

Questions King

January 15, 200818 yr

Hi. I can't find out how to do this, but I have a value list that is used in a Drop Down menu. The value list is populated by a "Name" field. So, every Name from every record is in the Value List and Drop Down menu. What I want is to have the Drop Down Menu display only the Names from the current found set of records, instead of all records all the time. Is this possible, and if so how is it done? Thanks for any help.

• 3 replies
• 1.7k views

bcooney

January 14, 200818 yr

hi everyone, Just like to find out something.In the event that my customer place an order(add a new record)from the web,is there anyway for me to be notify of this new order? Thanks :)

• 2 replies
• 1.3k views

S_Yeung

January 14, 200818 yr

Can I make a "dynamic" value list? I'm building a solution that tracks a trader's transactions and which 'suggests' the size of the next trade based on various risk thresholds. Would it possible to translate that 'suggestion' (the result of a simple calculation) into a "capped" value list that actually leaves out any values that are greater than the suggestion? Real world example: Trade A: Risk represents 50% of risk threshold. Trade B: Remaining 50% of threshold translates to suggested trade size of '5x' Trade size value list available in record corresponding to Trade B runs in 0.1x increments up to (but no greater than) 5x, so trader cannot actually l…

• 1 reply
• 1.2k views

Fenton

January 13, 200818 yr

I have a global container that is set to Global, Auto-enter Last Visited,Can't modify, Always Validate. My Logo is a .jpg that sits on my desktop. My problem is I want to move my logo from the desktop to a folder inside Filemaker, but I don't know how to change the gLogoContainer to look in the new folder instead of the desktop? Can anyone help? Thanks

• 2 replies
• 3.4k views

Kicker3

January 12, 200818 yr

Hi - i would like to ask please i have a drop down list field with repetition, how can i get a summary which shows only the fields that are filled in. ex i have 5 repetitions of this field if a record has the 5 filled and another has only 3 filled how can i get a summary of the 8 filled fields rather than showing me the 10 of which 2 are empty? THanks for your help!

• 1 reply
• 1.1k views

Søren Dyhr

January 12, 200818 yr

I would like to filter a date range within a portal using two fields with a drop down calander. Any one like to make some suggestions?

• 1 reply
• 4.4k views

LaRetta

January 12, 200818 yr

Okay, here's the scenario...I have a series of 'number' formatted fields. In the 'number format...' option, they're formatted as "Format As Decimal" with two digits of precision. These fields are used to enter dollar/cents amounts. I'd like to be able to copy the contents of these number fields, and paste them into a single text formatted field, with carriage returns separating the dollar/cents entries. I suppose this would be considered a merge, since I'm copying data from multiple fields, and am pasting them into a single field. Not sure, though. Anyway, I have created a script that goes to these number-formatted fields, copies the content, shifts over to the target te…

• 1 reply
• 1.1k views

David Jondreau

January 11, 200818 yr

Hi, I have a value list of multiple publication titles. When a publication is sent out, I would like to select that publication's title from the value list and apply it to all records (recipients), rather than manually going to each record and selecting the value list's publication title in the field. Is there a way to "apply" a value list selection from one record to all records? Thanks. -Seattleflo

• 4 replies
• 1.5k views

seattleflo

January 11, 200818 yr

Is there a way to achieve this? I have a main table (Ticket) which contains many "pages" child records (related table) each of which can have any number of "services". So it's a parent-child-grandchild relationship. I'd ideally like to have the pages display in a one-row portal (which can be set to show a different page by changing the value of a related field) and show a second portal inside listing the related services. I'm thinking this may not be possible, since the grandchild "services" portal would be related to the parent "Ticket" and not its child "pages". However, there's usually a way to convincingly fake these things if you know enough. I know that I …

• 1 reply
• 1.2k views

no1tmorrow

January 11, 200818 yr

I don’t know if I'm just fried from trying to figure this out or if I just cant get it. I have a table called Case_Management (w/ __KP_Case_Management_ID) in this table I have a field called Case Number. What I cant seem to do is have a new window pop up which will contain a large text field for the officers to type in and keep the case nuber from the main table when a new record is created (I have tried putting it in a related table, as well as in the parent table etc.) I also have the Case Number field also on this layout. On the new window I have a button for a new record, when clicked I want it to create a new record with a blank text field(but still b…

• 9 replies
• 1.7k views

Totes

January 11, 200818 yr

Hi, I am wondering if there's a way to format or script a selected checkbox set to display horizontally instead of vertically? Thanks!

• 3 replies
• 3.7k views

Spirodoc

January 11, 200818 yr

Is there a way to print portals on a report horizontally through a script or calculation? I have tried to use Line Item reporting but it still lists the field data vertically. I am trying to get the data listed horizontally and comma separated to give a nicer presentation as well as conserve on space/paper. Any ideas appreciated!!

• 0 replies
• 912 views

Spirodoc

January 11, 200818 yr

I’m a newbie and I am having problems with portal / record navigation. I have a portal (list) which contains a list of employee’s names. I have a set of nav buttons (first, previous, next, and last) which I want to use to navigate the list portal. I use the selected portal row in the list portal to GTRR in another portal on the same layout which displays an employee record (employee). I first had the nav buttons moving between records, which was fine until the employee names were sorted and the record number no longer coincided with the name’s position on the portal. So I then scripted the nav movements using the portal row number / GTRR and all worke…

• 0 replies
• 1.2k views

jtomb

January 11, 200818 yr

Hi, I have a DB in development now that is a fairly modest creation — not more than 35 run-of-the-mill calculations; some summaries, a little conditional formatting. Not rocket science. Yet every time I enter a value in a field (like a quantity of product), the dependent calculations only update when I move the scroll bar or resize the window... they won't update of their own accord when I tab out of the field. Nor will they update when I force-commit the record. I'm running FM9 Pro on a Mac dual 2.5GHz machine with lots RAM and everything else performs perfectly. Any ideas, please?

• 5 replies
• 1.1k views

Søren Dyhr

January 11, 200818 yr

I have a portal that users want to see items in the added record order (sorted by ID field), newest item on top. No problem... But then later re-Sort it by a color field to bunch like colored items to together. I can't seem to figure out a way to dynamically allow users to toggle the portal's sort between the ID field and Color field Anyone have a clever trick? Is there a way I'm not seeing? Many thanks.... Dave

• 4 replies
• 3.2k views

comment

January 10, 200818 yr

Hi I am not sure if this would be the right area of teh forum to ask this question but honestly I didnt know what section to start in. My question is this: I have a simple database that i built to keep track of an inventory. For the last year I am the only person who has entered any stock into this database. Now I will be training someone else to enter stock into the database. What I would like to do is when this person enters a record into teh database, that a field will be auto filled showing which account last edited the field and/or entered the record. I have looked and I dont see where I would do this at. Any help would be greatly appreciated.

• 5 replies
• 1.3k views

Jared867

January 9, 200818 yr

Happy Holidays Everyone! We were working on this solution for our newsletter but decided to make it available to everyone. This is a very powerful Free solution that I think you will enjoy. I've included a couple of movies as well as the files for your enjoyment. * General Demonstration of 5 Step Wizard - Movie 1 http://www.fmwebschool.com/movies/googlecharts1/googlecharts1.html * Advanced Features - Movie 2 http://www.fmwebschool.com/movies/googlecharts2/googlecharts2.html The FMWebschool Google Charts tool allows you to design a custom Google Chart for your FileMaker application. The easy to use five step wizard gives you control o…

• 2 replies
• 3.1k views

FMWebschool

January 9, 200818 yr

Is it possible to manage users in a layout, view users etc ? I huess it must be but how do you get the user list ?

• 0 replies
• 974 views

redballoon

January 9, 200818 yr

I have built a replacement for and excel spreadsheet with filemaker and it is great however there is one BIG problem. Excel will give a preview of an illustrator file, Filemaker will not, so when a file is inserted in Filemaker there is no image, but in Excel it produces the image, this is not great surely there is a way around this so Filemaker can show the Illustrator file :)

• 1 reply
• 1.5k views

Reed

January 9, 200818 yr

I've been running into a problem with conditional formatting that I am hoping someone can help me with. I have various fields that I want to turn different colors based on formulas. What I've found is that if there are too many different colors and if the formulas are too complex, then the conditional formatting gets stuck somewhere and won't work as I want it to. Has anybody else run into this problem and if so what did you do about it? I'd really appreciate the help. I should probably add that I'm pulling information from a lot of different tables to create the formulas. Let me give an example. Let's say I have a date field that I want to turn: - r…

• 14 replies
• 2.8k views

LaRetta

January 9, 200818 yr

hi. happy new year to all. is a table i have name of customer and tape of customer. how can i make a drop down list that it will show me all the customer that are in tape "a"?

• 16 replies
• 2.4k views

LaRetta

January 8, 200818 yr

I'm using Filemaker for a database of contemporary artists. Sometimes I'd like to change the layout (insert an extra image, add a field)of an individual record without changing the layout of all the other records??? Also, how do I create space in a layout or record (i.e. I want to move the bottom fields so I can add a field in the middle of the layout)without having to move the fields individually?

• 0 replies
• 800 views

childstim

January 8, 200818 yr

What is a good way to display *all* of a field's contents automatically and be able to then select options and interact with another table's information? Two examples of the kind of thing I'm trying to figure out with FM8.5, but not grasping yet: 1) a school database with classes, hundreds of students, and the goal of keeping track of progress on academic goals for each student. 2) A sales database with sales regions, stores, hundreds of managers, a product line offering, and the goal of keeping information about where each manager is in the process of deciding what products they might carry. In each case there could be hundreds of students or hundreds of mana…

• 2 replies
• 821 views

Bri2008

January 8, 200818 yr

I have a field that makes a Client ID by taking data from the info inserted. It creates a unique id. However I would like to have the end user be able to change it if they have to use a specific id already in use. Maybe a button that pops up and asks what they want to use as an id for that client. any ideas?? Thanks

• 3 replies
• 924 views

Leather Knight

January 8, 200818 yr

I keep track of personnel hours in a lineItem table, all the dates and all the hours. The input of those dates and hours is in an 'Hours' table, in a portal, related to the lineItem table, allow creation of records. Every day a user has to make a new record, fill in the date and the hours. I show those records in the portal based on an ID value. The every day input seems to be too much work, so they want an 'automatic' record generator at the beginning of every month. No problem with that, it is working. They also want to see, in a portal, for every given employee, the records based on 14 days, starting September 1. With a total of hours for e…

• 0 replies
• 1.1k views

jrRaid

January 8, 200818 yr

Hey, Not sure where to put this topic. I have a text field that is a big box but the problem is when it comes to word wrapping, it cuts off words in a very odd way it might have "finishi" on the top and then "ng" on the next line. I don't see an option for widow/orphan type of thing. It is the same way on the preview format as well. It's not the biggest thing, but it looks unprofessional. Any help? The Lonesome Jubilee

• 2 replies
• 1.2k views

lonesomejubilee

January 7, 200818 yr

I'm hoping someone can tell me why in the world I can't seem to get this to work.. It seems a no brainer, but the loop won't continue beyond the first portal record. Many Thanks... Dave Filemaker 9 Go to Related Record[show only related records; From table: "Nim_OrderQ"; Using layout:" Order BOMS" (NIM_OrderQ)] Go to Portal Row [First] Loop Show Custom Dialog["Test"; SNInventory::ItemCode] Go to Portal Row [Next; Exit after last] End Loop

• 4 replies
• 4.6k views

Søren Dyhr

January 7, 200818 yr

I have recently reloaded my computer, and unfortunatley started FMP before installing all of my fonts. Is there a way to remap that new font to the original, and I have never really worked with custom fonts on a solution before, but do those fonts travel with it, or is it a waste of time to even try to use them?

• 3 replies
• 1k views

Lee Smith

January 7, 200818 yr

I have made several basic databases with containers, they all work great no problems, some are from flat files, some are for related tables etc…just no problems. Now today, I am working on a layout and I add a container (this is also a flat file db w/just a few fields and 1 container). I right click in the container to add a photo and !!!Nothing!!!. I think it’s a mouse problem so I install a new mouse…still nothing. I check all the setting to make sure the container can be accessed and it can be. I then click on the container again and boom..it works. I close out the db and reopen it, and now it will not work. I am lost, has anyone ever had this …

• 0 replies
• 732 views

Totes

January 7, 200818 yr

I have created two tables joined by a join table. My goal is to have a filtered portal on the layout of the first table which displays a filtered list in a portal. I'd like to be able to choose one or more of the records that show in the portal and save them to the record i'm working in. Concrete this means I have a patient who undergoes surgery to a specific region of the body. I'd like a filtered portal to show the types surgery dependent on the selected region. My problem is that the portalfield remains empty. I have read and tried almost all the example files on this forum and can't get it to work. Would somebody please be so kind and patient with to …

• 11 replies
• 3.3k views

Fenton

January 7, 200818 yr

I'd like to create a layout for a file so that when particular (restricted) accounts access the layout, some of the fields are hidden from view and the remaining are view only. I'm new at FileMaker. I assumed the way to do this is as follows... 1. Define a privilege set. 2. Assign the privilege set to the restricted accounts. 3. The privilege set is defined as follows.... -- Open the 'Edit Privilege Set' dialog. -- On the 'Data Access and Design' panel, select 'Custom privileges...' for the' Records:' field. -- On the 'Custom Record Privileges' dialog, set 'View' = yes, 'Edit' = no, 'Create' = no, 'Delete' = no, 'Field Access' = 'limited...' …

• 1 reply
• 944 views

Søren Dyhr

January 6, 200818 yr

Hi, Could some tell me if this is even possible or tell me of a better way of doing it. Our officers go out and take (lets say) 20 digital photographs, they return to the office and start entering their information into the database. Is there a way to either attach that folder of photos to a specific record? Or what I would really like to do is import all the photos at once(not a reference but the actual photo as space is not a problem, and the volume of photos will never really get to be too large) to a layout containing containers so they could add notes as well. If an import can be done, is there a way to make it a simple operation so they…

• 4 replies
• 1.2k views

Totes

January 6, 200818 yr

I've hit an interface wall. What I want is a tree table view , but I can't think of how to do this in FM elegantly. My goal is a portal of checkbox choices (the parents). Each choice has one or more checkbox choice children. A child can appear in one or more parents, but parents are unique (aren't they now : ). If the user deselects a parent, the children of that parent become disabled for selection. However, a user can select any or none of the children in a selected parent. How can I achieve this in FM? The quick way out is a portal of children, sorted by parent, I suppose. However, won't achieve the ability to disable all children of one parent with on…

• 3 replies
• 5.8k views

tgilders

January 4, 200818 yr

Hi all, I need to copy my portal by selection item to other portal layout. At my main file I create a new record with portal item, and now I need to copy the record and selection portal Item to my Main 2 layout. Can this done? Thank for help! Portal_copy.zip

• 1 reply
• 1.2k views

Simon K

January 4, 200818 yr

Hi, Does a Footer part ALWAYS "stick" to the bottom of the screen? Is there no way to make it stick to the bottom of a list of records instead? So, aligned TOP rather than BOTTOM. I have only perhaps five, shallow records in a file at any one time and I have a giant void of white space between the last of them and my footer. Many thanks in advance.

• 2 replies
• 1.3k views

fiveshorts

January 3, 200818 yr

I am trying to print a summary of my invoice. It contains products purchased by customers in a portal. The portal displays perfectly in layout mode but if I print the layout the portal area is completely blank on paper, it also does this if I export to pdf. Additionally if I go from layout mode to Preview mode the portal disappears. I can't figure what I've done wrong in my setup, any help will be appreciated! Thanks

• 1 reply
• 954 views

Søren Dyhr

January 3, 200818 yr

I have an ORDERSTATUS field that stores the numbers realted to the names: 1 - Open 2 - Pending 3 - Closed Is there a way to store the number and display the NAME of the status in the field instead of the value? I have overlayed a non-enterable field over it to show the related name but was hoping there is a better way.

• 3 replies
• 1.1k views

LaRetta

January 3, 200818 yr

Gaaah.... I got myself into a tizzy over what I now know as the "sticky text" issue in popups vs drop down lists. See: http://my.advisor.com/doc/18168 for a perfect explanation. The thing is, I really prefer the UI (keyboard wise) of the drop down. Is there any hope to getting sticky text with drop down behavior? Thanks! -Jeff

• 2 replies
• 1.4k views

Stuart Taylor

January 3, 200818 yr

basicaly i have a question in my layout and the user can answer yes or no, but if the answer is yes i would like to unhide another question(mergefield) and answer(field) in the same layout. any help? thanks for your time. mfrapp

• 2 replies
• 1.6k views

mfrapp

January 1, 200818 yr

Can one stop lines of text being shaved when printing portals across page boundaries? I am trying to print a directory of departments with department members appearing in a portal below each department field. All fields slide up to produce a continuous list and the 'Allow part to break across page boundaries' is checked. On some pages the top of a portal row prints at the foot of one page (the top of the characters), and the bottom appears on the next page. It appears FM does not know how to deal with widows and orphans. Preventing the part breaking is not an answer as this will mean some pages are only half full (where the following portal has man…

• • 
• 5 replies
• 3.2k views

Mike Owen

January 1, 200818 yr

Within my layout 'Job sheet' I have a value list of: -In Production -Dispatched -Invoiced They are displayed as radio buttons What Im after is that when a new job sheet is created or committed the radio button 'In production' is activated straight away. Is this possible?? Any help is much appreciated

• 3 replies
• 1.3k views

BananaUK

January 1, 200818 yr

I am struggling with something I think should be easy. I want to display in a portal related records who's parent record has a particular status. No records are displayed. See example.

• 8 replies
• 2.1k views

winklestork

January 1, 200818 yr