Value Lists
Value lists, pop up lists, conditional menus...
425 topics in this forum
-
How to add one extra item in Value Lists
by nextgen- 3 replies
- 3.2k views
I have created a value list based on Products table. However, while selecting products, sometime I need to select all products. While showing product name in popup menu, I want to show one more value called "All" for denoting that it applies to all products. How can I do that?
-
User Input
by torch_55- 1 reply
- 1.1k views
Hello All, I think this is fairly simple, but I have not had to approach this before... I want to ask a user if he wants to crate a record for a new project or one for an existing project. Would a custom dialog be a good way to do this? I am a little off base with this as it only allows the user to push buttons as a response. So how do I get the value for the new project phase from the user? Or is there a better way to approach getting this input? Thanks in advance.
-
Storing data for every month
by nextgen- 1 reply
- 996 views
I need to add one record for every month. For example, the user will choose from drop down list like: Nov 2016 Dec 2016 Jan 2017 Feb 2017 (sorted according to month) How can I achieve this? and what's the best field type to store it?
-
- 4 replies
- 1.6k views
Hi there, I am new to filemaker and struggling to find a solution to my problem. I have one table with Subject (parent) and another table with Test (child). Each Test is repeated by each Subject at 5 different Timepoints. I would like to set up the Timepoint value list (in the Tests table) in such a way that it automatically omits items (timepoints) that have previously been selected for the same record (Subject), showing only items (timepoints) that remain available. Any easy solution? Many thanks, Murph
-
Multiple Conditional Value Lists
by dave.goodnature- 12 replies
- 15.9k views
I've been scanning the forums, and can't really find anything that I can comprehend that can answer my question. To make a very long story short, I have a products table, consisting of Series, Type, Size, Parts, all related to other tables. See super-simplified version, below: I'm trying to have a series of pop-ups that reduce the items available in the subsequent pop-up, 4 layers deep, that simplify product selection for the individuals using the layout. I'm trying to continually reduce whats available in the final PRODUCTID pop up. See super-simplified version, below: I've tried filtering valuelists, using globals in the pop ups, but I can…
-
Dynamic value list ( Please help :) )
by Mushabab- 2 replies
- 1.8k views
Hi everyone I would appreciate the help! I want to build a solution for a medical warehouse and the database will contain thousands of records of different materials (consumables) : I start building the solution but I faced a problem with nested value lists: I will have 5-6 tables in a file to describe these materials: 1. Category (many items) 2. Class (to be nested to Categories) e.g. many classes belong to one category. 3. Type 4. Size 5.... Every table of the above belongs to the table above I want to have a table where once I choose a category only the related classes pop up in the class field and the same with once I choose …
-
Value list based on calculation field
by steveald- 13 replies
- 5.5k views
I found several similar posts, but nothing that seems to fully address what I need. To start with, I have a calculation field that determines a maximum value for each record. I need to create another field that provides a list of numbers with a specific starting point, specific increment, and that maximum value field as the last number. Then, I need to create a value list that uses the values from that list field. The net result should be a pop-up menu that contains a list of numbers up to a maximum value associated with that record. i.e. record 1 will show the following list in the pop-up menu: 50, 60, 70, 80, 90; while record 2 will show: 50, 60, 70; while recor…
-
Value lists to be used as records for a report.
by Jamie999- 3 replies
- 1.8k views
Hi, New Filemaker User and novice scripter - lurked a bit but never posted. I really hope this question makes sense to thew experts! I have been requested to produce a report consisting of Employee Names, each with the single task assigned to them. I have a large DB table ALL_TASKS where each record is a unique TASK_NUMBER, and each record has an employee assigned to it (EMPLOYEE_NM) from a value list (unique values from the field EMPLOYEE_NM). There's also a lot of other summary data assigned to tasks, like time to complete, etc. (Tasks are added sequentially all the time throughout our work day). So far I: Created a new empty table for my report, RE…
-
- 2 replies
- 1.4k views
Hi, I have a layout with a pop-up menu which shows which staff are currently on duty. It is used to select which staff member is performing an intervention. Rarely, an intervention might be performed by someone outside the organisation, and so I would like to include an "Other" option on the value list? Does anyone have any suggestions on how to do this? I have the value list working to include only on duty staff, but I just need help adding the additional "Other" value? Many thanks, Mike
-
Popup menu does not update after selection is made
by DeepThought- 1 reply
- 1.5k views
I'm having trouble getting a popup menu to update after the user makes a selection. The popup is meant to show a list of choices. Once the user selects a choice, the choice should no longer appear in the popup. I can't get it to work. The popup does not update after a selection is made. Here's how I have it set up: A main table (transactions) and a second table (tags) are related by an id in the usual way. A second relationship is set up to show all rows in the tag table are NOT yet associated with the record from the transactions table. The popup is based on a value list from this second relationship. When the user selects a choice, the tags table record is asso…
-
- 3 replies
- 5k views
Script sitting on a foundset of 1. Got a valuelist, happens to be named "LPStratValues" (real name). The value list itself is defined as related values only, starting from the table native to the layout I happen to be on at this point in the script, of Meters via VLB FM::LPStrat (actual TableOccurrence name, actual field name). In midscript, in browse mode, attempting to set a $variable to ValueLIstItems (Get (FileName); "LPStratValues") and it returns blank, no values, script debugger slides to next script step. Kill script in script debugger, put a randomly chosen global text field on the layout and attach the value list LPStratValues to it. Click in it. …
-
Limits to Value Lists and Indices/Indexes?
by Feirefiz- 0 replies
- 1.6k views
How many values can be in a value list in FM 12? Other posts indicate that in 2008 the limit could have been around 550. Also, is there a difference between the index used for auto-complete and a user-created value list in terms of size? Are there other significant differences? Is the possible number of index items the same as the number of records (64 quadrillion total records over life time of file)?
-
Exporting Value Lists
by Zach P- 1 follower
- 5 replies
- 9.3k views
Hi, I'm looking to export some value lists from a DB to its updated version*, but I've found that I can't do a simple copy-paste. Is there a relatively painless alternative to copying the lists over, or am I going to have to brute force it? Just to note, I'm not looking to simply reference the value lists in the new database - I want to actually move them over. Also, I'm using FileMaker Pro 11 Advanced. Thanks! *The repository system that's being used is pretty arcane (e.g. non-existent), so I'm having to do merges manually (and carefully :worked_till_5am: )
-
Dropdown readout?
by pctechtv- 0 replies
- 1.6k views
Does anyone have or know about techniques for making a dropdown display the current record you are on or things like a parent record. I have a way I am doing it but I wonder if it is the best way. The way I am accomplishing it is; I just take a field with the deduced result that I want it to display a put it on top of the field that I have set to a self-join. This self-join than has a relationship set up limiting it to the members I want to show up based on the context. What I ultimately want is a set of dropdowns across the top of my solution that show the trail or breadcrumb, and when each one is clicked I can go to that record. The top dropdowns will update accordingly…
-
Mandatory Values
by pctechtv- 2 replies
- 1.9k views
What are the concepts to begin understanding to not ever let a field be empty or not one of you possible values you want? For instance: • Cat or Dog for the purpose of what you are doing are all you need to receive as data • You also never want it to be “”, NULL, FALSE, 0, or Empty (so something like 1 could do) I have started understanding about Auto Enter but this is more of a Validation Issue correct? Does it need to be a Value List or can a calculation do the trick? I guess scripting could be this type of sentinel as well?
-
Fickle Checkbox Set?
by pctechtv- 1 reply
- 2.2k views
If you have a check box set, let’s say Man, Buck, Woman, and Doe. Is it possible to only be able to choose Man and Woman and let Buck and Doe have to be set with auto enter from some other factor?
-
Left on all list items?
by pctechtv- 2 replies
- 1.4k views
I see that when you use Left(return separated list; 10) it gives you 10 of a count of every character in the list. So if you had 10 list items all 20 characters long in the list you just get back 10 characters of the 1st one only. How can you use Left with a list and make it shorten every Item in the list?
-
Wrap lines of list
by pctechtv- 3 replies
- 2k views
If you have a return separated list how could you wrap each line like this? Cat Elephant Woodpecker Dog Mongoose To this Cat Elephant Woodpecker Dog Mongoose
-
- 5 replies
- 5k views
Hello, So I'm new to Filemaker (I usually use MySQL and PHP) and I'm having an issue that I can't seem to find a solution after reading through the forums. Table 1: uniqueID firstName lastName mentor (this is either true or false) Table 2: personalID (related to uniqueID) mentorID (related to uniqueID startDate endDate What I'm trying to do is create a drop down list people can select in the mentorID field in Table 2 generated from a conditional query from table one. So in MySQL I would go SELECT * FROM Table 1 WHERE mentor = true and then output that into an HTML option list via a loop. Is this possible in Filemaker or do I need to create a …
-
Filtered Value List
by ivanlim- 5 replies
- 2.2k views
Hi everyone, I am very new to FM and I have a problem that has been bugging for a very long time. It would be great if someone can help me out. I have 2 Tables - Production Sheet - Field::Material - Inventory - Field::PK, Field::Category, Field::Item, Field::Description & Field::Discontinue I would like a Value list which will populate Field::Material with Field::PK. By displaying a pop-up value list showing Field::Description. But only show me Field::Category with Paper, Plastic, Wood & Metal in it, and also don't show me Field::Discontinue with discontinue in it. I hope my problem description do not confuse you guys too much. BTW Table I…
-
capturing FMP 12 table metadata in table
by thatkinson- 2 replies
- 2.3k views
In its basic configuration metadata on FMP fields and tables is only available through the "Manage database" mode. Is there some way to loop through tables and fields and capture that same information into a new table for reporting purposes? Thanx
-
Jump to another record in found set
by jfranck- 2 replies
- 2.1k views
Hi First of all, this is my first posting to this brilliant forum! I certainly profited a lot from good experience of you all. Thanks for that. Now, I'm desperately trying to crack the nut of jumping (not filtering) to another record in the found set, identified by my key field "Record ID" To that end, I've been investigating various solutions with Go to Related Record etc., self-join between the field containing the Record ID and the one containing the Cross Reference I want to jump to, but so far, luck hasn't been smiling at me... Are there any good ideas out there? Sorry if this is piece of cake - I just haven't found the cake-recipe yet.
-
Multiple Conditional Value Lists, Last One Within a Portal
by Glenn Butler- 0 replies
- 3.2k views
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-- CLIENTS----SERVICES. What relationships and/or table occurrences do I need to create to place multiple conditional value lists inside of an ESTIMATES layout? I want to select a client from a value list (all values), then select a property related to the particular client, then select a tree inside a portal row (based on SERVICELINES) related to a particular property. Thanks for any help.
-
Dynamic Value List - hadi
by Big Show- 1 follower
- 1 reply
- 2.3k views
hi, i wont some one to help me, i have two table, 1- department 2- employee i wont to selct dynamic value list from first table ( department ) from employee, that show only related value from department . when iam in employee i wont to chose department so i chose car, after that i will chose nissan in group filed, and only see in categorey armad and maxima can for nissan group, and after i chose armad by example i will see only in service filed 2011 and 2012, like this. [TABLE=width: 500] [TR] [TD]department[/TD] [TD]group[/TD] [TD]categorey[/TD] [TD]service[/TD] [/TR] [TR] [TD]car[/TD] [TD]nissan[/TD] [TD]armada[/TD] [TD]2012[/TD] [/TR] [TR] [TD…
-
- 2 replies
- 2.1k views
Is it possible to allow a user to change the value of a field once he has selected it from a value list? If the control style is drop-down list or menu, then it's impossible to change the field contents once the value has been selected from a value list. One approach would be to attach a script to a button that executes a script that changes the layout so an edit box replaces either the drop-down list or menu control style, but I was wondering if there was an alternative. I know that conceptually this seems at cross-puposes with what a value list is intended to provide: a controlled vocabulary. But there are occasions in my application where I want to allow the u…
-
Value List from Calculation Field
by mattym01- 1 reply
- 1.9k views
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.
-
Conditional Value Lists
by mattym01- 1 reply
- 1.7k views
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?
-
Create a Value List from Two Fields?
by sothos- 0 replies
- 1.3k views
I'm creating an Accounts Receivable Application. I have a field for defining a Return Slip (a document that records a sales return) that is the number of the related charge invoice or delivery receipt. I need to validate whether the number input is a member of the CI# or DR# field. I know I can create a value list for this, but as the numbers come from two fields, I'm at a loss. Any thoughts? Thanks in advance.
-
Dropdown Box Population
by chockey- 5 replies
- 2.6k views
Hello, I'm a novice user of Filemaker 10 and am having an issue with a drop down box population. Here's what I'm trying to do: I have two databases: Database 1 contains a listing of new students and their information - this database contains fields for information related to their "mentor" Database 2 contains all of the information related to the 27 mentors. I am trying to set it up so when I click on the "Mentor Last Name" field in Database 1 - a dropdown box will appear with all of the mentor last names from Database 2 In addition...I would like the remaining fields related to the the mentor (ie. first name, major, etc) to automatically populate based …
-
First field in Value List will not select
by GreenBase- 0 replies
- 1.3k views
Table 1: RecordID (a unique numeric serial ID) Usage ("Accepted" or "Not Accepted) IsBasionym (Yes, No) Scientific Name (name field) AcceptedBasionym (calculation IsBasionym&Usage) BasionymID (For those records that aren't basionyms, it is populated by the RecordID of the relevant basionym) BasionymLookUp - a calculation field containing CASE (AcceptedBasionym = "YesAccepted"; RecordID) For those records that aren't basionyms, a second instance of Table 1 (called Basionyms), related via Table1::BasionymID = Basionyms::RecordID is used to pull data from both tables in a series of layouts. I use the BasionymLookUp field to populate a Value List. This gi…
-
Upcoming Events
No upcoming events found