Value Lists

I would like very much to setup a Value List that is filtered. I have several popup menus throughout my DB that use the Employees table and it displays the "Full Name" field. However, I would like to limit it to just active employees (where Inactive = 0). How do I do this? http://prntscr.com/19y4ik Thank you, Ryan Smith

Hello. I am finding that I much prefer in many situations using a Value List based on values from a field. (the primary incentive is that it would help run some scripts; and provide the user with more control). This would require me to create a new table dedicated to the populating of the value list. Because one should try and limit the number of Tables/TOs in a file, does the addition of new tables for the Value Lists worth the benefit that this strategy provides? Thank you for any guidance you can offer.

Hi, I'm new around here, just downloaded latest FM Pro demo (Mac) with a view to converting a Bento database for a client. I hope this is in the right place, I could not find anywhere more appropriate. Looking at the level of expertise in these forums is truly humbling.. I feel rather stupid! Anyway I have been trying for some time to sort this out and just going round in circles so thought I would ask as I am sure someone will know immediately the source of my misunderstanding. Imported Bento data basically OK (single table) but the issue is this. Boolean field in Bento displayed as a checkbox. In FM it's a numeric field with a 1 or 0. I'm fine with the logic there…

Hello, I have a database to record data entry errors. In the "Log" table the user selects the transgressor from a value list "staff" that pulls from a field called "StaffID" in a table called "Staff". I would like the values displayed to be from a second field- "Staff::Username". Unfortunately, "Username" is a calculated field - Right(Users::LoginID;Length(Users::LoginID) - Position(Users::LoginID;"";Length(Users::LoginID);-1)) "Users" is a external SQL database. The values of LoginID read like DOMAINNAMEUsername so the calculation is to trim off the domain name and the slash. If I try to create the desired value list, when I specify the fields for it, I sele…

Hi all. I am relatively new to Filemaker programming, but I have come across what I thought was a bug, which I have been tearing my hair out trying to squash, only to find it is more a "feature" than a bug. I have a field set as the key for lookups in a ms sql database which I have created a relationship with. I have it set as a drop down, and it is showing 2 fields (last name and first name). Unfortunately, it only shows 1 person per last name in the sorted list (example, there are 5 people with the last name "Bennett" but only 1 shows). After driving myself nuts trying to find the error, I found the following in the filemaker troubleshooting section: : …

hello can someone help i need a drop down list what im looking for example if i type legal all the record with legal should be in drop down

Hi, I have been looking around how to solve this problem. I have one quotation system that have a related line Items. What I need is to have 3 conditional value lists, all of them depending on the first value selection. Example I will select the MEDIA, then the value list of SPACES and the value list of EDITIONS will depend on the MEDIA. I can send an example file by email to show what I have done so far. (The system didnt allow me to upload the file here) My problem is that in the PRICES, appear all the possible SPACES for the different MEDIA, and not only the prices related to the selected MEDIA. I will appreciate any help. Thanks in advance, …

I am building a "Magic the Gathering" program. The program has 23,106 records. I am trying to figure out how to use the check box to check more than one card at a time. For instance: Dragonmaze has 248 cards. I own all of them. As you can see on my interface there is a button on the card marked own. I was thinking that I could search for Dragonmaze cards and that would givce me all the cards for that set. Then click over to table and click on the own button at the top and it checks all 248 cards. But I cannot figure it out. Unless someone has a better idea that I need to go with. Thank you. Magic_FMForum.zip

Hi All, I'm new to FM Forums so I hope i'm following all the correct rules and procedures of the site. My Question: - I'm an experienced Microsoft Access User and on a form you can add a 'Combo Box' or 'List Box' that will list all the records for that single form and when one is selected will take you straight to that record. I suppose in a way it's acting like a filter without the need to scroll through all the records on the form individually. I've recently just purchased Filemaker 12 as required to develop a database for web use and trying to do a similar thing with a 'drop down list' on a layout. i.e My table is called 'Primary Schools Directory', a lay…

Hi Everybody, I am newbie with FM and I have a global variable that contains several values in different lines. I would like to insert automatically these text values in a field as a value list with checkboxes, could anyone help me to solve it? Thank you very much, Wardiam

I am currently using fm12 on a Mac. I have a field in my database called Selections which uses a value list with 5 options as checkboxes: Option1, Option2, Option3, Option4 and Option5. If I do a search and click the Options1 and Options2 checkboxes, I should find all records where the Selections field has both the Options1 and Options2 checkboxes checked. However, I am getting results where records with Options1 and Options3 checkboxes are checked - I am getting records which do not meet the search criteria. I am thinking: is this a fm12 bug? I started the database using fm8 and have just converted over to fm12. Searches with value lists created when I was u…

Please Help I need two fields payment and Method The Payment should be dropdown list cash, check and credit card. If i choose Cash in the method field should be Cash (number) f i choose Check in the method field should be Check (number) f i choose Credit Card in the method field should be CC (number)

hello everybody, my problem is the following: i have records with numbered index fields like: Record: 1 Index: 10 Record: 2 Index: 20 Record: 3 Index: 25 Record: 4 Index: 27 Record: 5 Index: 30 and i need them replaced with the value of a valuelist like: a,b,c,d,e respecting the sort order of the numberd index field. Basicaly my output should be Record: 1 Index: 10 CalculatedValue: a Record: 2 Index: 20 CalculatedValue: b Record: 3 Index: 25 CalculatedValue: c Record: 4 Index: 27 CalculatedValue: d Record: 5 Index: 30 CalculatedValue: e is there some function to help me? To make it harder i can add that the index field can repeat…

Hi everyone, I'm working on a FM database that was created by the predecessor of my position. We are due for an upgrade really soon (FM9 -> 12) and I want to make sure that I clean up the database as much as I can before migrating. The idea is to merge multiple tables into one file rather than having multiple files, and to also establish relations between these tables. Here's a challenge I'm coming up against - my current tables make much use of the "Custom Values" field in the Edit Value List menu. I want to convert it to "Use Values From Field" while using the old value to create links to the related table. For instance, one field has the Custom Value field fil…

Hey guys. I've got 3 individual portal rows that must be populated by three different Value Lists upon creation of a new record. These portal rows track pass/fail tasks that the user must perform on equipment. These pass/fail tasks fall under three different categories. When the user has created the new quality control record for the asset they are testing, I would like them to click a Populate button above each of the three portal rows. I have all the values for these categories placed in their own Value Lists, which upon population, creates related records in their respective portal rows. How can I script FileMaker to pull values from a Value List and create individ…

please help me about this i need two fields one is state one is county what im trying to do is if i enter state i need all the county list to another field Ex. if i select AL the county field should be autauga, baldwin etc

Here is my problem. I have two layouts that are linked together, Master Records and Products. I use a value list to display the status of the Master Record and Products (In work, Proofer, Final) I want the status of the master record to reflect the status of multiple products. So if product records 1,2,and 3 have a status of "in work", the master status is "in work". I want to make it so the status of the record in the Master Records on lt goes to "Final" if all the products statuses are "Final". If one of the products is "In Work" and the other two are "Final" the Master Record record should still show "In Work" Thanks Rob

Hello, I work from a few months to try to make a database for recording work. The result is in the attached file, but i don't know how to get values list, in layout "Detalhes de Trabalhos" in the tab "Consumos" which the portal is related to the table of the "Materiais". What I wanted to do was select material basis at work by selecting "Categoria", "Descrição" and "Tamanho" after writing the spend amount in "Mt. Liniares" to decrease in stock. I leave the attachment if someone can help greatly thanked. Sorry for the short text but do not know much English writing, hope that the file help to understand the question Thank you very much Cópia de Cópia de Miste…

I am having an issue regarding Field Values List using related value Table one maintains collectors pieces, each piece has 3 fields use the Contact Id supplied data. Seller Id, Appraiser Id and Buyer Id, [All are numeric fields that are indexed] Table two maintains the contacts information and has a sub-table named Contacts Type – The same source can be a seller, an appraiser and a buyer. This sub-table maintains the Contacts foreign key and the Contact Name field populated via a look-up. I have a defined a self-relationship in the Contacts Type sub-table with 3 constant fields that auto-filled value of seller, appraiser and buyer that respectively relate to…

Hi! I hope I'm posting this in the right place, and that it isn't TOO simple a question. I'm still a newbie, and am working on a pretty straightforward contact management database in FM Pro 11. Thanks in advance for your help! I need to attach files to quite a few contacts, so I've made a Files tab and added six container fields (and can add more as needed). My problem: I don't know how to add a tiny field next to the tab that shows how many files exist for that contact. I imagine that I'd need to create a function that checks to see which container fields have files, and adds them up. How do I do that? (Also, if there's a better way to attach files to a contact, …

Hi All, I'm brand new to Filemaker so I apoligize if this post is confusing in some way. In coming over from MS Access, I'm a little dismayed at how Filemaker handles it's down-down control. Specifically, that with a two field drop-down, the first field (usually an internal ID number) is displayed and not the second field that the user actually chooses from. I’ve seen a number of slick work-arounds like stacking fields on top of one another or suggestions to use the pop-up menu instead. It seems with the advent of the ExecuteSQL function in FM12 that another (perhaps better) work-around is an option. Unfortunately, my knowledge of FM scripting is not yet able to p…

Hi everyone, I believe mine is an old and easy problem and should have been covered in some of the earlier post. But I have search thru this for weeks and don't seems to find anything near the solution I am looking for. So I really hope to get some help here. I have a dropdown box which I want to populate with fields from the same table. Table : Items First Field ItemID : 1,2,3,4,5,10 Second Field : ItemName : BreadFast, Lunch, Dinner,Soccer, Bank Interest, Others Create New Value List - Under File/Manage/ValueList Now what I want is for the dropdown box to display the values in the order as I have type above - (ref : second field)…

Hi, maybe someone can help me with this question. I have three tables set up: Instructor table Instructor PK field Name field Programs Taught table (join table) <----- for many-to-many relationship Instructor FK field (Instructor PK) Program FK field (Program PK) <----- pop-up menu Hire Date field Program table Program PK field Name field Record State field ("Active" or "Inactive") Layout and portal: I have a portal showing the related records from the Programs Taught table on a parent layout based on the Instructor table. The portal has a pop-up menu with a conditional value list to select an existing program from the Program table and set …

I have country names in separate table, its ascending order when i show in value list.. but i would like to show this value list in descending order ? Is this possible, Please help me any one ? Many thanks in advance

Hi, I have a status screen that contains a list of items and would like to offer the end user a way to display it in different sort order. I have created buttons that run scripts that work fine, but want to offer a drop-down box to do this, however, a drop down list is essentially a field, as as it's a field, the information is stored in the table. The problem with this is that if several users want to access this screen each wanting their own sort order, then this method does not work. Is anybody aware of a method I could employ to achieve this? Cheers, Greg

My value list is created from entries I make in a field. I have used this list for several years and it is quite long. I pick the entry from a pop-up menu. It is working perfectly. However, I noticed some wrong entries and would like to remove them. How do I do this? There is no place where I see the values in the list. I am using FM Pro 12, Mac OS X 10.8.3

How do you use a drop down value to filter a portal?

Greetings, all. Â How would I pull this off (see attached)? It's a dynamic value list from another table and what I want a user to be able to do is click/enable the value choice and have the choice's text copied to the clipboard so it can be pasted into another app's data field. I got as far as figuring out that a script trigger would come into play but after that...? Â IIRC, whenever you enable, by way of a checkbox, a VL item its value is placed at the end of the field list, no? If so, how would I grab the the value from there? Â Ideally, I'd like to be able to code the list so a user can click-and-drag (or copy and paste) a value to the clipboard but I'm guess…

I want to trigger a script with the drop down list. I can not seem to get it to work. Any help would be appreciated. I just want to perform scripts using the value of the drop down.

   I have a MEMBERS table with the usual information: Name, address etc...  I have a layout based on MEMBERS called Member Summary Information . In the header of this lo I put the field Members::Name_Full and made it a POPUP.  I wrote an OnObjectModify script that runs the script above when the user selects a Member name from the popup.  <<ALL THE FIELDS ON THE LAYOUT ARE FROM MEMBERS. When I select the popup and change members, the address information stays the same. Why?  How do I get the address information to update to show the newly selected Member from the popup? >>  I tried including the PK_MemberID in the p…

Hi. Has anyone else observed this in FM12? I have a pop-up value list on a number field. The value list inserts a record number, but displays a second field, which is a text field. The text in the second field is interspersed with numbers. As long as the total number of digits in the second field is less than 9, everything works as expected. If there are nine or more digits, however, wherever they are located and even though intermixed with letters, the field only displays the numbers themselves, without the intervening letters. The pop-up list looks correct, but the selected text changes into a string of numbers in the actual field. Is there any explanation f…

Basically, I want to allow users to add items to a checkbox list on FM Go. The scenario is this; I have a text field called "visit notes". To the side of that is a checkbox list with existing items set up as custom values using 'Manage Value List' window on FM12 desktop. When checked, the text of the checked item is inserted into the text field. So far all works fine. I want to be able to allow users, on the iPad, to be able to add custom items to the list but NOT by using the 'other' checkbox that appears when you select 'allow entry of other values' in the Inspector (as this results in a drop down list of the additional items when the user selects 'oth…

I have a database that contains a value list that is made up of values from a field (Person's Name) in one table. In a layout for a related table, I have a drop-down list that uses the value list. Recently I noticed that some of the items (Names) that should be in the value list/drop down list do not appear. I have the value list to sort the names, so when selecting the drop-down list I see names in ABC order. The names that do not appear are towards the end of the alphabet (ex: Walter Smith.) However if I change the name of Walter Smith to AWalter Smith, it then shows up, but then one of the names that previously showed up at the bottom is not there anymore. The…

I couldn't find what I was looking for on the forum. I was wondering if it's possible to create a value list showing only unique values. Example: Camp sites value list showing: Site #1 Site #2 Site #3 Site #4 Record 1 of a reservation table selects Site # 2. Record 2 of the reservation table would now see the camp sites value list as following: Site #1 Site #3 Site #4 Record 2 selects Site #3. Record 3 would see the camp site value list as: Site #1 Site #4 Hopefully I explained what i'm trying to accomplish clear enough. Thanks for your help in advance.

Looking for a hero. I have searched for an answer to this online and if one already exists, please point me to it. Otherwise, I'm hoping there's a FMrock star out there capable of identifying what I'm doing wrong. Am trying to create three levels for conditional value lists to identify the location of assets. Consider this a library inventory sytsem that tracks: multiple locations where items are held, multiple aisles within each location, and multiple shelves on each aisle. The goal is to enable users to enter an asset record and select from a value list of LOCATIONS. That's a straightforward list from the LOCATIONS table. Works fine. Next the user should be able…

I hope this is in the correct area. We have a portal to where each record the User can select Contact Type(phone, fax, email, cell phone, etc) then they can enter the correct info in the field Contact Data. I need to know if Email is in their Contact Type and if so what value is it so I can locate it in the list of Contact Data. thanks, Jim

I have a working portal with 2 fields: Degree (holds 1 2 or 3) and Description. The description is part of a Dynamic Value List (based on degree) and it works great; sort of. The problem is a user sometimes forgets to first indicate the Degree but instead clicks the Description fields which then shows "<no values defined>". Question: "Is there a way to trap / eliminate the <no values defined> message and substitute a user friendly reminder like "You need to first supply the Degree". Thanks

I have 3 tables Client record Session note Intervention. I want a field in session note to use a checkbox value list to enter text based upon the a field in the intervention table. However, I would like to be able to add intervention descriptions as I go, is it possible to use the "Allow entry of other values" option to add to the Intervention table? If not, how can I solve this. The intervention table is not currently related as I can't work out a logical way to do that.

I am using FM 12 03 Advanced on OSX  I have a layout based MEETINGS and a portal on that layout based on MemberMeetingJoin. (FYI The LO is based on Meetings because to the right is another Join Table that holds VISITORS and there is a second Layout to the right that holds a portal based on Visitors.) Everything works OK   On the left Members portal, I have the the MemberMeetingJoin::KF_Member field.   The Value List definition for MemberMeetingJoin::KF_Member is:   And consists of the KF_Member field and NotDOP which is a calculated field that puts the name of the member in the NoDOP field if the member is not deceased. It works  =…

i am using a portal row where the user can enter history for particular items. the portal row has a button for each record to open a new window where additional information (four fields) can be entered for that particular related record. i want to incorporate a non-user editable check box in to the portal row that will be checked if these additional fields contain values, and not checked when they're empty. what is the best way to do this? i'm assuming a single value must be auto entered in to the check box field using the IsEmpty function. is this a script trigger or calculation? that's needed?

I have created a conference tracking database that has three tables: - Association: The association that puts on the conference. ie Medical Association, Real Estate Association, etc. - Event: The reoccuring conferences of the association. ie Spring, Fall, etc - Conference: The actual conference that includes date, location. ie Medical Association 2013 Spring Conference on 3/15/2013 in New York The problem I am having on my Conference layout is that I select the Association that is using a popup menu control with the list of assocations, then I want to use a popup menu control that provides a list of Events that are only related to the Association. After that I…

For some reason, filtered lists give me more trouble that just about anything. And they appear to be such a basic thing that I am frustrated that it eludes me. The technet manual hasn't done anything to clarify it so I turn for help to you guys/gals. Here is my problem. I have a product table, products have a category(either A or B in a field called productCategory. On my invoice entry layout (based on the Invoice table), I have a portal showing the invoice line items (based on the InvoiceLineItem table; relationship is Invoice :: InvoiceLineItems based on Invoice ID). I would like to have the productID field display only products based on a category, for example, on…

I am using FM 12 Adv in OSX and Windows I have a MEMBERS table that has: PKMemberID etc ActiveInactive (that holds the value 'Active' or 'Inactive' I need to base a value list on just the 'Active' Members. I suspect I make another TO of Members but I can't 'get' how to setup up the 'filter' for my popup that will show just the Active members... I am mentally stuck. Can someone give me a swift kick to get me started? Thanks Ron

Hello, I want to get list of all connected printers thru my custom plugin using 360works. or How can we get any printer using index(i.e. Printer(1)=printer no. 1 and Printer(2)=printer no. 2)? My main task is to design Printer setup by which user can set printer/Printers for printing. Please provide me java code for the same.... Thanks Anirudh

Hello....I am totally new to File maker coming over from ACCESS...I see that there are some things that are close to each other. Well im having trouble getting the value lists to show what I need...not sure where to go.. what i have is this. table LIfts: LIft_ID Lift Lift Classification 1 Bench Press Horizontal push 2 Incline Press Horizontal Push 3 Power clean Explosive 4 …

I have a conditional value list set up to show only values for active accounts. The value list is defined by the calculation field cActiveAccountID = If (CustomerStatus = "Active" ; CustomerID) The value list shows values both from the CustomerID field and from a second field: CustomerName The value list works perfectly if I sort by the first field. However, I would like both to sort by and display only the CustomerName. Meaning, I would like to sort by the second field and display only the second field. If I select either of these options the value list now returns all customer records, for both active and inactive accounts. Has anyone else run into thi…

I have a quick question.  We use a drop down menu to choose a certain color on a work order form. We them manually fill in a circle on the form with a marker to match the color on the order. Is there a way to either trigger a colored circle when a choice is made or to change the font color when the choice is made??  Any thoughts would be helpful...keep in mind that I am a bit of a newbie with Filemaker!  I have attached a screen shot for you to look at. The field with the term "dark grey" is the drop down box.  mhburris

Hi There, I have a quick question to ask, well I think it is a quick question. Is it possible to have a feild display 2 different value lists? What I mean is, in my solution I have a field that when a certain value is set it calculates a table to get values to populate a dynamic value list. Now I need to find out if there is a way to display a static value list in the same feild should the other option be selected. So in a nutshell: If Field A is selected with option 1, then run script to sort table and get values to populate in ValueList A that is used in Field B. If Field A is selected with option 2, then Field B uses static ValueList B I was thinking of duplica…

Seems basic, but I'm stuck with a simple issue here: To simplify the problem, suppose I have One table "Invoices" and related table "Items". The Items of an invoice can be shipped on more than one transport, so the latter has a textfield "transportNo" whose values are stored in a valuelist that uses values from the field, so that each time a "transportNo" is added in the job, it is available in the listbox for subsequent added items. Now, for some reasons, I'd rather not create a separate table for transports... but I need to know how many different transportNo have been inserted in the textfield, for every job. Unfortunately, Both count summary field or "ValueCou…

Hi, I run a small tree business and I'm trying to create estimates that have line items linked to each tree we perform work on. I have CLIENTS --< PROPERTIES --< TREES and ESTIMATES--< SERVICELINES >-- SERVICES. What relationships and/or table occurrences do I need to create to place multiple conditional value lists inside of an ESTIMATES layout via a portal based on SERVICELINES? On an ESTIMATES layout I have a drop down value list to display clients. I want conditional value lists that display 1) only properties relating to a particular client and 2) only trees related to a particular property. Thanks for any help.

Hi There. I have a table called: Users which contains the fields User ID, Level, Gender I have a table called Result Events. It contains Event ID, Level, Gender. I have a table called Results. It contains the fields User ID, Event ID, Result. What I would like to do is have a value list (a pop up menu) which only shows user IDs which are in the same level and gender as the event ID (eg if an event is Male, Junior, the value list in the table results will only show users which are Male Junior) Any advice would be greatly appreciated. I am stuck and can not get it to work - I have been looking on various sites and not be able to find a solution. Than…

I think what I'm looking to do shouldn't be that hard to figure out, but for some reason, I can't really find my answer. I've searched and searched but I might be searching using the wrong question! All I want to do is have a checkbox or radio box, (or even drop-down... I'm not picky!) that is a yes or no ("Do you have a member number?"), so if the user chooses "Yes", then either a text field appears, or a dialog box opens and the user can type in their member number and it gets stored in the proper "Member_Number" field. If no, (if possible) I'd like it to store a "None" in that "Member_Number" field. Also, if the user chooses "Yes", can I make it required that…

I'm using Filemaker Pro Advance 10 to make a simple invoice for line items of different products, each with varying colours. I, however, can not seem to get it to work. I created a table of products, whose layout has a portal to another table. This is where, using a drop down list, the varying colours of the product are input. The colours are listed in yet other table. Some products can have a limited number of colours while others have access to all colours. Ideally, on the invoice, by line item, The product is selected in one field and then one of the colours relevant to that product is selected from a drop down list. How do I make this happen? I have t…

I am working on making a report that shows which items a sales person had sold in a month. The way the database is set up is that there are 12 worksheets. These worksheets are used to provide a price for either different rooms or different plans depending on how the salesperson wants to price the cabinets they are selling. They can price up to 3 different cabinet styles. This calculates the cost of worksheets for each style. Everything is working on that aspect but now I want to add the ability that they can print off their commission report at the start of each month for the jobs they sold last month. Here is where I'm needing help. Sometimes a customer will bu…

Hello, I am trying to create a value list based upon a single field. This field is populated via AppleScript with the names of the calendars in iCal or Calendar. The list is in a single record, with a line given to each calendar's name. Without having to parse out the individual field into multiple records, how can I achieve a value list with each of these calendar names? Thanks for your thoughts! Regards, Stephen

I have a layouts with several global fields, each of which has a SQL driven, calculated value list attached. It works fine but I wanted to reduce the number of fields in the table for clarity sake and I was wondering if there was a way to have a single global field with multiple repetitions then use a Case function that SELECTS the appropriate value list. The effect would be that, instead of having 5 globals with 5 corresponding c_Valist fields, I could have single global with multiple reps and a single c_Valist field. I've been able to achieve something like this in a portal where I can easily set out conditions for which value list to trigger. But I can't seem to f…

I am working on designing a database where someone can custom build a computer. I have tables for each type of component. I have built some conditional value lists that only show compatible parts. Now what I am trying to accomplish is how to filter out these parts to only show items that are still available. I don't want it to show items that are compatible but discontinued. I have a field that I have a drop down list that I have selected if an item is "Active", "Unavailable", "Discontinued". I am not sure how to have my my value lists filter based on this condition. Any help would be greatly appreciated.

HI, I have been going around in circles with a DB I am building for my small buisness. It is a simple service request / report DB so we can keep track of what was done to where and when as well as printing a report for the client. It is a flat file as I have not defined any relationships. I can't quite get them to work and they do my head in but I know the answer is in them! We have CLIENTS that have multiple LOCATIONS which have multiple ROOMS/VENUES I have made the above fields, in the service request layout, a drop down list based on a value list of the field with the option to add "other". This works OK as it will standardise the entries. But, th…

Dear FileMakers, I'm trying to get a checkbox menu to work. Please see the example. There are 10 trains. When I select train 5, the find brings up train 5's data. Then, when I also select train 6, it finds train 56's data. There is no train 56 - I'm trying to bring up results for train 5 OR train 6. Seems it should be very simple, but it's had me going around in circles. If someone could the attached to work, and provide a explanation of how you did it I'd be so grateful! Ben CheckBox.zip

Dear FileMakers, I'm trying to create a single button with three different states, through which the user can toggle. I've completed the following tutorial: http://www.filemaker.com/11help/html/fmpa_tools.24.23.html ...and have the button with it's three different colours toggling nicely. Where I'm stuck is attaching a value to the different states. How do I get the button to output values (1, 2 and 3) into a field? Thanks in advance, Ben

Howdy, all:  I know I've seen a simple script somewhere that parses a checkbox'd value list and through a looping function, is able to create a summarized list based on the parent value list choice related children values, but I just can't find it here and online. (After two hours of searching my eyes feel like hamburger.)  Attached is a screenshot I threw together: the checkbox'd fieldname is "Class" and its (children) values (fieldname "Value") are in the portal to its right. So, in this example, a user has selected three values (shown also in the box in the middle of the layout for clarity's sake):  Duration Relationship Diplomat Type  ...with Diploma…

I have a field set as a checkbox list (5 rows high in the layout display). On another layout, I want to use only the chosen options from the checkbox list, but I want to display them in a single line separated by a comma and a space (I'm pushed for space in the new layout). The field will be displayed as an edit box in the new layout. So, assume the list below from original layout containing checkbox: A B C D E Options A, B and E are chosen. In the new layout, I require: A, B, E Any help much appreciated. John

I'm planning on using a number of drop lists, which when individual items are selected, a script would run (on Object modify) that would insert(append) specific text into a text window. Just after some help on scripting this one. TIA

Firstly Database includes the following tables: HorseOwner, Horse, TreatmentNotes Have set up a 'start' screen as a starting point for users. They have the choice to search by Owner Surname, Horse Name or Invoice To fields. I've set up value lists for each of these, which the user can choose from a drop down list. Firstly, Once they select the appropriate record from the pop-up, what's the best way to take them to the related record? Secondly, I considered an alternative for the Owner Surname value list so it included the Location value as well (in case there were more than one instance of a given surname (different individuals) thus identifiable b…

Hi, I guess that my tag line is not that clear...lol... that's what beginners are all about..lol I am looking for a way to influence the value list according to a certain value... i'll try to explain Lets say i am creating a company restaurant and that i have everyday 8 different type of offers I have created a library of recipes. When i go to my weekly planning i find a table that looks much like an excel table with on top the 5 days of the week and on the side i have OFFRE1 to OFFRE8. When i select OFFRE1 i would have a list poping up so i can select if OFFRE1 is SOUP, STARTER,SANDWICH...etc. According to my selection i would like that if i select SO…

I have a database with thousand of records. The users are held in a value list called userID. I user this script to assign records to users. Go to layout [ "Data" (Main data)] Enter find mode [ ] Set field [ Main Data::Assigned_to "=" ] Set error capture [ On ] Perform find [ ] If [ not Get ( FoundCount ) ] Go to layout [ original layout ] Show custom dialog [ "no unassigned leads found" ] Exit script End if #. Records found so loop them Set variable [ $list ; ValueListItems ( Get ( FileName ) ; "userID" ) ] Set variable [ $count ; ValueCount ( $list ) ] Loop Set variable [ $num ; Case ( not $num or $num >= $count ; 1 ; $num + 1 Set field [ Main Data::Assigned…

I have a table of over 10,000 health codes that I'd like the user to select from but I'd like to limit the list to the most relevant ones. I've added a field in the table called "relevant" and I'd like to display all values with this field set to "Yes" When the user selects one of the codes it should populate a portal row. I know how to do it easily in MSAccess but I've tried using a multi-predicate selection in FMP12 without any success. Have any ideas? Brian

I have two tables Company & Parts. I have a one to many relationship from company::companyID -----< parts:companyID I want the user to be able to select a company from a drop down when they use the Filemaker New Record button from the toolbar. I can only see the current value list I have created if I have the customerID filled in manually, otherwise the drop down doesn't display any of the companies so the user can make a selection. Any help would be great. TIA, Nate

I am running FM 12 v 1  There is a table: Patient There is a table: Doctor     PKDoctorID, DoctorLastName etc... There is a table: Procedures PKProcedureID, FKDoctorID, ProcedureName etc...  On the Patient layout there is the Procedures portal.   The procedures portal has FKDoctorID.  Here is my question: "When the FKDoctorID is defined as a popup, the DoctorLastName shows. When it is defined as a DropDown, I see the PKDoctorID ---- Why the difference?) Â

I want to create a value list from the records in a table. I also want to add the value 'All' to this value list as it will be used in a filter selection. How do I achieve this?

This is probably going to end up being embarassingly simple, but for now it escapes me! In reading the FTS 11 book, p. 4-29, it comments how with drop-down lists, using the show-second-field only option, that after the selection, the original value (usually a keyfield) is the one that shows. It suggests using an non-enterable opaque related field that contains the values displayed as the second field in the value list. Users clicking on this field would activate the hidden field formatted as a drop-down list, make selection, and after exiting, see the data in the second field rather than the stored key itself. My question is, how to do this? How does clicking in o…

I have a employee table that has a list of all employees which then have two different fields with radial options 1. active or non-active 2. sales rep or installer In another table i have a popup menu based on the employee records but the list is very large and i would like to filter it based on the field being entered. For example in the sales table i would like to assign employees to the sale, one being a salesrep and also an installer to each sale. In the salesrep field I would like a popup menu that filters from the employee table based upon the criteria (active, and sales rep), in the installer field i would like (active, installer) any help? I added…

There is a "Category" field in Browse mode, Table view that I can't find in Layout Mode. I didn't make the database so I don't know how to find the field. I need to give it a drop down list, so please help me find it!

Hello FMForums! I'm a recent convert from Access to Filemaker Pro so I'm still trying to grasp just how different the two platforms are. So please excuse me if I say things that sound weird. I'm working in a layout right now and I'm trying to create conditional formatting to make certain fields visible depending on another field. It's a little tricky though, the source field draws data from a Value List and is set to function as a Checkbox Set. Basically what I have is a day selector, I'm setting up whether this particular task is done on Monday, Tuesday, Wednesday, etc... So some tasks are one day a week, others are seven days a week. In my layout I'…

I have a table relationship between..... MeasurementChart and (TO) MeasurementChart_Defaults_List_Gender_Customer MC_STYLE_GENDER = MCDL_GENDER and MC_ID_CUSTOMER = MCDL_CUSTOMER_CODE and MC_WORD_RETIRED != MCDL_USAGE MC_WORD_RETIRED will always have "Retired" as a value, automatically entered when user creates a measurement chart. MCDL_USAGE can either have "Retired", "Current", or be blank. My drop down value list is located on 2 layouts which are based on MeasurementChart. The value list itself is based on the Defaults list and is set to "Include all Values" and "Show only values from second field". My question is does the "Include all …

I have a field where people need to enter either a project name, or if it's not related to a project, they need to select from a list of non-project related choices. The project list comes from two fields (project number, project name) in a separate database that houses all of the projects and other project-related information. The non-project related list will be a static value list. There is a checkbox that the user should check if the request is not related to a project. If the box is checked, the value list should be the static value list from within the same database, but if the box is unchecked, the value list should be the list of projects directly from the…

I am using FM 12 Advanced on OSX There is something fundamental that I am missing. Here is the situation: I have a 1 to many relationship between Patients and PatientStats My layout is based on Patients My portal is based on Patient Stats I have a popup that displays Patients::_PKMemberID (yes I should change the name to Patients::PK_PatientID) Problem: When I select a popup _PKMemberID, the associated Patient::NameFirst, Patient::NameMI etc does not change? Plus the portal seems to not display propertly. What causes this weird behavior?

Hello, I have a table called "objects" my objects are different from eachother, for example, lights, tables, chairs. I have alot of contacts but I just want to see some of the contacts when I choose lights for example, I know I should use a related value list somehow, any suggestions?

Hi I had hoped to make a simple dwindling list to insert a 'number' extracted from list of numbers (a calculation). Obviously it needs to be more complex than i had thought. I have attached a file for info if anyone would like to help. cheers test.zip

Hello I what to make a layout list of devices and the user can Select from the list one by a select box of the records. What am i missing here in the attach file Thank You Dani list select.fmp12.zip

I have a table called 'Processes' - which holds the steps for completing each 'Process' I have a table called 'ProcessSteps' which are attached to each process. Each process can have many steps attached to it. ProcessSteps has a field called Step #, which I want to have as a value list (values can range from 1-10), but I only want to display values that are 1 higher than the maximum step already assigned (this is stored in a value called HighestStep). I have this working with a new table called Steps, which has all the assigned combinations in fields Step-Value, eg: 1-1, 1-2, 2-1, 2-2, 2-3, etc. My relationship then goes from ProcessSteps to Steps with…

I have three small tables People, Households and Households2People. Households contains a numeric field, boolean format called, removeFromValueList. Those households where the removeFromValueList check box is checked should be excluded from the value list that appears on the Households2People portal (from the context of People). I don't where why this isn't working. I have a self join relationship from Households to a table occurance called FilteredTO_Households. The join ties the numeric field removeFromValueList with it's global equivilent through a "not equal to" relationship. The value list uses values on FilteredTO_Households and includes only related values start…

Hi there, Been searching high and low for an answer but can't find one. Running FMP11 and have set up a product database consisting of two tables related via a number field; the article number. The first table holds all of the information about the item, the second table only holds information about the name of the supplier, the price and stock. The value list is set up as a related value list showing only the values (names) from table 2 (the supplier table). I've created a drop-down list in the supplier field of table 1, and it lists all suppliers found in table 2 perfectly fine. However, clicking any of the values in the list results in nothing.…

Can I attach 2 value lists to one field? instead of creating a new field.

I am using Filemaker Pro 12 since its release and the program crashed on me. On restarting the drop menus fail to automatically populate. They only populate by moving my mouse through the invisible list. This occurs with all databases including the sample ones provided by Filemaker. Is there a quick fix or must I reinstall Filemaker?

Hi, I have a table called Customers, holding fields 'Customer ID', 'First Name', 'Last Name', 'Full Name'. Full Name = First Name & " " & Last Name. I want a value list that will allow me to view the full names, and select a value based on this. How is this doable? I've tried many solutions I found around the place, but nothing seems to work. Any help would be greatly appreciated.

hello! Not really sure where to post my question but it currently uses a value list so i figured let me start here. When writing orders we require that the salesperson choose either New or Repeat to let production know if the order is New or Repeat. It is a drop down with value of New or Repeat. One of those has to be chosen, but what is happening is when the sales person duplicates a similar order to speed up the process of generating a New order they are leaving the field as it was on the duplicated order which 9 times out of 10 says Repeat. So i constantly have orders sent through to production showing it as being repeat but actually is New. Just lazy sales staff. Is …

If a drop-down list has many items then one has to click, at the bottom of the list, on an ellipsis symbol "…" to force a display of all the items. This is new to FileMakerPro 12. Is there any way of reverting to the "old" interface which allowed one to see all the items without this extra step?

I have a table called Clients. This has all the clients information and a field called Active. This field is Yes or No. On a different table, Jobs, I have a drop down for a list of the Clients (the name field to be specific). I'd like to only show the ones that are Active. Is that possible? Thanks!

I am having trouble with a value list used in a portal. Tables I have are: Items: ItemID SupplierID Description, etc. etc. Suppliers: SupplierID SupplierName, etc. etc. Orders: OrderID SupplierID Date, etc. etc. OrderLineItems: OrderLineItemID ItemID Qty, etc. On the Orders layout, I have a portal that holds records from OrdersLineItems. I want to be able to select ItemID from ONLY the Items that share the same SupplierID as listed in the Order. If I have an ItemID field in the Orders table, it works perfectly using the relationship between Orders and Suppliers. However, once I use it in the portal, it does not work. I assu…

I realize this has probably been asked numerous times but I can't find another thread that I understand. I have an Inventory table with items listed by "shelf", "category" & "Stock ID". I also have a field that shows it's status as either "reserved or "Available". When entering a line item in my Invoice file, I have value lists for "Shelf", "Category" & "Stock ID". My Stock ID Value list now lists all related items but I only want my Stock ID value list to show me just the "available" ones. I don't know how I can do that. Any help would be sincerely appreciated.

Hi, I've got a field (CardWallCert) with a check box which is fed by a value list with entries "Wallet Card" and "Wall Certificate". It describes which are applicable for a given course (there are a number of possible variants ) and every option is potentially possible (Either one, or the other, or both, or neither) I'm trying to textually describe the contents of the check box (and hence the course variant) via a calculation: eg: Case ( IsEmpty ( CardWallCert ) ; "NO card/cert, " ; CardWallCert = "Wallet Card" and CardWallCert = "Wall Certificate" ; "" ; CardWallCert ≠ "Wallet Card" ; "NO card, " ; CardWallCert ≠ "Wall Certificate" ; "NO cert, " ; "…

I'm taking apart a working example of a conditional value list--recreating it myself to see if it will help me with understanding concept. The file I'm playing with is a two table example. Very simple. Designed to produced three layers of values (the second two value lists based on conditions). These values lists are on a single record context layout. The first two value lists work properly. The third is producing an undefined value. I've double-checked my relationships and fields and value list setup with that of the working copy and am not able to locate what I've done differently. Can anyone out there please take a look at this tiny file and point out to…

Help... I have a small three table database. The context is based on _Staff. I have a portal based on a tabled called _Services_Referrals_Sensitive and a conditional value list called _Services_Referrals_Sensitive_cvl. When the staff member adds a new portal row they are able to pick a category but then the correponding list is cut short--only showing one item in a much longer list. Can anyone see what I've done wrong on the attached file? I'm going round and round in circles on this and would really appreciate knowing what it is I'm doing wrong. Any help would be so greatly appreciated... mpConditionalVLProblem.zip

Howdy, all: I'm trying to print the contents of several value lists into a two-column-defined layout but can only get the list to print on the left-hand/column side; it won't continue/wrap to the second column. (See attached) I have a single calculation/global merge* field (<<_g__ValueListList__lxt>>) in the layout that contains the following: TextStyleAdd ( "Duration (JOBS)"; Bold ) & "¶" & VALUE_LIST::Duration_JOB__gxt & "¶¶" & TextStyleAdd ( "Referred By (JOBS)"; Bold ) & "¶" & VALUE_LIST::ReferredBy_JOB__gxt & "¶¶" & TextStyleAdd ( "Result By (JOBS)"; Bold ) & "¶" & VALUE_LIST…

I have a few files that have scripts that run dependent on the value entered into a field from a drop down value list. I always have a 'continue' button adjacent to the value list that runs the relevant script. I'm guessing there must be a way of running the script direct from the value list drop down without the need for a 'continue' button, but how?

I have a table that holds all inventory in stock - CurrentInventory This contains: ItemID ColourID SizeID Qty There may be the same ItemID, with different ColourID, and different SizeID. Eg: Item 1, Colour 1, Size 1, Qty 5 Item 1, Colour 1, Size 2, Qty 5 Item 1, Colour 2, Size 1, Qty 5 Item 2, Colour 2, Size 1, Qty 5 I want to create a value list to be accessed from my Purchases section, that only lists the available ItemID, and then once that is selected, shows only available colours in the ColourID field, and so on. How is this do-able? All the examples I have seen have 2-3 tables for the set up, but all the information of mine is s…

Hey guys I have a small database which utilizes a portal where I enter my hours for each day worked. Time In, Break Out, Break In, and Time out. I then have a field that calculates the total hours worked (everything is in 12 hour time), and then another field that calculates my pay for the day based on my hourly rate which is entered in a separate field under a separate table (total hours * rate). My tables are Week Info and Hours Worked. I'm trying to include two check boxes on each row that calculate one or both of the following: over time (time and a half for any hours exceeding 8), and time and a half (for days such as holidays where I earn time and a half f…

I have two tables: Items, and Suppliers. I have a value list to display Items, related to Suppliers. When I update the Items, and add new ones, the value list is not updated... I had to edit the value list, and confirm it was stil set up the same, and then when I selected OK it was updated... Why is this? Actually, it's not updating at all. When I go to select the item in the field where the value list is attached, it comes up as no values defined. I then change the value list to display all the items (not just those related) and I can select the item. Then once I change the value list back to being related, it only shows the single item I had previous…

This is driving me crazy: I snagged this solution from filemakermagazine.com and while trying to learn how it works, I added two fields, Popup List 3 and Popup List 4. For the life of me I can't figure out why they aren't populating with values on both the Main and Hidden layouts; I copied and pasted the original two existing fields, including their related scripts. Nada. You can see their data in the ValueLists layout so I know the data's there, just that the value lists don't appear. ...and what's _really_ going to tweak me is that it'll be something simple that I overlooked. *heavy sigh* TIA for your help! Rich Interface copy.fp7.zip