Value Lists

I MADE 2 LAYOUTS MY IMAGES AND MY IMAGES SEARCH 1 - FORM VIEW TO ENTER DATA WITH CATEGORY AND INFO FIELD 2 - LIST VIEW TO SEARCH WHEN I CLICK CATEGORY EXAMPLE DE WINTER IT SHOWING ALL THE NAMES IN THE DROP DOWN I WANT DROP DOWN TO SHOW ONLY VALUES OF THAT CATEGORY PLEASE HELP ME ????????? AMI.fmp12

(I can't seem to find a definitive answer here after poking around, so I apologize if this has been covered before.) I have a related value list that I'd like to use in a pop-up menu. The problem is, I always have to include an adjacent "clear" button to clear the field and it looks amateurish to say the least...so I'd like to have a null/blank value at the top of the value list so users can "clear" the field of an unwanted value. I thought I'd be clever and try this: Let ( [ _relatedValues = List ( fieldname ); _blank = "" ]; _blank & ¶ & _relatedValues ) ...but that won't work because it be…

Howdy all: Here's the problem with the schema as-is (see attached): If a STAFF person's status changes from active to inactive, their STAFF record ID replaces their name in the EVENT portal since it violates the condition between T.O.s (for the value list); change their status back to active and their name returns. For historical record purposes, what I would like to do is have their name remain in the portal irrespective of their status in STAFF. What do I need to change in the schema to make that happen? Thanks in advance for your help! Rich Test.fmp12

Hello, I am wondering if there is a script step or or other mechanism which would cause the automatic activation of a drop-down list, or a pop-up menu, as if I had clicked on it.

Hi, There is a weird behavior occuring with a couple Checkbox Sets (not all of the sets present in the layout): 1. When the user selects Checkbox #5, the selected value is correct but the visual indicator of the checkbox goes to Checkbox #3. 2. When the user selects a Checkbox #6, the value is correct but the visual indicator of the checkbox goes to Checkbox #4 3. When the user selects a Checkbox #7, the value is correct but the visual indicator of the checkbox goes to Checkbox #4 4. When the user selects a Checkbox #8, the value is correct but the visual indicator of the checkbox goes to Checkbox #3 This happens using the "x" mark or the "Check" mark. D…

I couldn't find the answer here, but I'm sure it's been answered before so I apologize for my lack of search operator coding skills. (I looked at the FileMaker online help web page but it didn't offer an answer.) In the attached, you can see a related value list setup for a pop-up menu. When inactive, the field shows the primary key, not the school name (from the second field.) I have the Override data formatting with value list checkbox ticked in the the Inspector (Field section) but doesn't alter the menu's display, so what else do I need to do to display the school name instead of the primary key when the field is inactive?

I have a button for a script that takes the user to a layout (for use on iOS or macOS) that presents a value list as 100 radio buttons in a second layout. I want the numerical value of the radio button (1-100) in that second layout to be used as the value for a Find that will take the user to that record number in the original layout. It would accomplish the same thing as a Find where the user would type a value from 1-100 into the field but be mouse/touch based. I am not too with variables (concept but not syntax). Is the radio button value already stored, or does it need to be captured? FM 19 on Sonoma.

Hi all, I have given this the old "college-try" and worked until I have exhausted all variations to get it to work. I would not post this here unless I exhausted my search for a solution. I have attached a file that "should" open up to the "Paper Thickness" layout. I have reworked the file to try and explain with note labels what you are seeing and the troubles I am having. To me, it is bizarre. It kinda works and gives a weird unexpected result when creating a "first" record in the table. It is behaving as if there is no "internal" index of the "second field" display configuration on the Dwindling Value List I created - but only for the first record. In ad…

Hi all, I have created a "Dwindling Value List" that appears to be working. However, after I have "assigned" all of the available values from the "dwindling list" as I build out records, I am presented with a default message that says "<no values defiend>". I understand the massage, but prefer the message to say something more specific and understandable to a User (and myself). If I could customize the message to read: "All widgets have been assigned." or something that makes sense in the context of its use. For example: All available "People" have been assigned a "Task". All available "Cars" have been "Rented" . Is th…

Hi all, I have a two conditional value list issues / questions that I am hoping to get some assistance with. The two issues are: A Conditional Value List when CREATING records (BROWSE mode). See layout “WEIGHT” for notes on the layout itself. A Conditional Value List when SEARCHING records (FIND mode). See layout “UNIT OF MEASURE TYPE” for notes on the layout itself. File attached. NOTE: I have never been able to build conditional value lists for years - so I am trying my best! Any help appreciated. Thanks! David conditional_value_list_attempt.fmp12

Hello Loving FM, but very limited skills. I want my drop down value list just to show my OPEN orders. I've created value list, and can see all orders. I have a field in the Orders file with OPEN / Closed status. How do I limit the items in value list = OPEN orders. thanks ken

Hi - I am trying to setup a valure. It seems pretty simple, but having trouble making it work. I am trying to base the value list items on the values in a field in a related table. The related table had a bunch of fields, but 4 that matter for this description I think: LastName (Text) FirstName (Text) LastFirstManual (Text) Last.First (Calculated = LastName&", "&FirstName) The calculation works, works, meaning that looking at the field in the records of that table shows a last name, first name for each record. The LastFirstManual is there temporarily I hope for testing. I did a "replace field values" with the same calculation as the c…

I'm not even sure if I'm going about this the best way or not - hence my coming here to get a sanity check and suggestions. I have the following tables: t_Events t_BookedItems and t_Items The t_Events and t_BookedItems are related. t_Items is a table full of items that can be booked for events. I have a Value List: L_Items based on this table. (This is so that at any time, items can be added and the system will still work) I have currently set up an t_Events Layout, which has a portal to t_BookedItems in it that lists all the related records. I know I could just format the fields in the portal to have drop down lists etc a…

I'm wanting to create a value list that offers years in the range 5 years prior through to 5 years after the current year, self updating from year to year via calculation. I have found the range I need through a custom function with parameters of starting year and ending year which returns a single field with the list of years within the one field. I can't however figure out how to use this single field of multiple values as a value list. It may be obvious but I haven't been able to find a way of achieving what I want - it may not be the best way so any help is appreciated.

I have a "Client" table with a standard serial number primary key, and a text field that contains the client name. I have a value list that has the primary key as the first value, client name as the second value and "Show only values from second field" selected. On a few different layouts I have popup menus using this value list. I am encountering a really strange problem, whereby if the client name includes a number, the popup menu will show the client name value of the record whose primary key is that number. For example, if I have a record of a client called "Company 7", and another record of a company called "XYZ" whose primary key is 7, and on one layo…

Hi all I'm exploring the option of adding this feature if it's feasible or if another solution is warranted. Currently I'm working on a property management database to manage rental properties I have. In the Invoice table/portal I use to track charges and rent payments for each lease I have a Tenant field that allows me to tag a particular tenant within the lease to that charge or payment (useful if the lease has more than one tenant and they all pay separately, also to track how much each tenant pays individually). This is done using a pop-up menu and using the value from a second field that shows their name rather than their ID number from the first field. Cur…

Good day gurus, I have a true \ False value list, where i require the user to select only one option, but an option is required. I currently set it up as follow and it works. Auto-enter->GetValue( RightValues( Self ; 1 ) ; 1 ) Do not replace existing value of field: unchecked What i can not figure out is how to do is enforce a selection, something like using radius, where one of the two option MUST be selected. Thanks JMart

Hello! I'm creating a new database and I'm having problems with a conditional list. The table has 3 fields (Code, Prefix, Locality), and when we enter a number in the code field, it automatically shows the available results in the prefix field. I wanted to do the same thing for the location field, but I can't get it to display all the data without me asking to show it. Example: (Code, Prefix, Location) 98989, 001, SPAIN 98989, 002, PORTUGAL 30303, 001, PARIS 30303, 005, POLAND The results that appear in the locale field is for example if I type 98989 in the code and 001 in the prefix it will show me Spain and Portugal …

Perhaps I'm having a brain fart, but I'm stumped... I want to isolate "n" number of characters at the beginning of each line in a value list field and put the extracted values into another list field via calculation. The number of values is dynamic based on the user adding items to the list. An example: Value List................ Desired result 0001|Chocolate...... 0001 0002|Christmas...... 0002 , etc. Of course, if I use Left, Middle, etc. I only get the first line of the list. P.S. - I'm forced to go no higher than FileMaker 17, so the While function is off the table.

field = "Music Format" Value List (checkbox) Album Cassette CD EP Single iMusic Same field done in text format (temp). However, when the checkbox VL is empty, content still exists in text field version. My aim is getting my calculation to work. Field = "zFormat" used in my header. Case ( MUSIC FORMAT = "ALBUM"; "ALBUM"; MUSIC FORMAT = "CASSETTE"; "CASSETTE"; MUSIC FORMAT = "CD"; "CD"; MUSIC FORMAT = "EP"; "EP"; MUSIC FORMAT = "SINGLE"; "SINGLE"; MUSIC FORMAT = "iMUSIC"; "iMUSIC"; MUSIC FORMAT = "iMUSIC" and MUSIC FORMAT = "CD"; "CD + iMUSIC" MUSIC FORMAT = "ALBUM" and MUSIC FORMAT = "iMUSIC"; "ALBUM + iMUSIC" )

This question may be more of an incorrect relationship setup than a value list, so I am hoping to get help with either/and. The tables in question are Budgets - which have a unique name and number; and are comprised of the table Accounts ; Transactions for expenses within a single budget; and TransactionsLI, that allow for multiple line items inside of the transaction via a portal and allow for a different account numbers for each line (e.g., line 1= salary, line 2= benefits - each has a different account number). In short, I need to create a new transaction in the transaction table, select the budget associated with the transaction, then within the Transaction …

The table, "Address" has a field "Location". The Location field is formatted as a popup menu using a value list "Locations_VL" "Checked with "Override data formatting with value list" The value list "Locations_VL" is pulling from a table called "All_Locations" with a "Primary Key" field and a Location Field. the table is populated with separate locations The Value list "Locations_VL" is using the "Primary Key" as the first first field and the "Location" field for the second with the "Show values only from second field". This works fine the issue is when I want to concatenate fields into a field "Main Address" I enter the Location field and I get th…

*sigh* It's a good thing I'm paid by the hour. After Comment's outstanding help with setting up a value list for grade levels, I've run into a snag: how to create a summarized list by individual grade level when each record's value list contains multiple-checked values? Example: If I want an ascending-order, summarized list of teachers who teach in 1st grade, then 2nd grade, then third grade, etc., how do I parse that from a value list field (GradeLevel) where ticked checkboxes have 1, 2, 3, 4, 5? My best guess is to create a looping script to parse 14* separate variables--using GetValue--to generate discrete values for use in a Find-by-grade level (also looped)…

I have been searchind here for an answer, but probably don't know what to search for. And/or I am missing a simple solution. Three tables: Customers Sites Tickets Each customer may have one or more sites. Each Site may have one or more ticket. Most of the "action" will be creating tickets. I would like to have a single pop up on the Ticket layout that allows the user to pick the Site primary key, but displays the "Customers::Name - Sites::Name." Ideally this would looks something like: Cust A-home Office CustA-satelite officeA CustB-Home Office I thought -- no problem, add a calculated field to Sites table "Sites::CustS…

Howdy, all: Well, I've spent the last twelve hours beating myself up trying to get the attached to do what I want it to do, but couldn't; I did manage to utter a unique, fantastical, banquet of curses throughout the day, though. What I'm trying to accomplish is in the School (and in turn, District) tabs in the Activity_Log layout: I want to have the the user choose a school (using the global field's pop-up menu) and have only the District_Staff names appear in the Name-labeled field's (::_kflt_District_StaffID) value list who not only belong to the chosen school but also have "Active" entered in their respective Status__lxt fields. (By the way, did I set up the …

I'm trying to make a value based on the content of JSON_cListKeys in this specific record only: The fields involved: I get the "This Value List Won't Work... based on a calculation" message. So I tried to see if looking up the content or calculating the content and using that instead.. um.. no, it's still a calculation. I Tried changing to a calculated text field ... I get no error from the value list creator, but I still don't get actual values in the list. In order to only get the values from the current record, I created a self join [Items <--> Items_Current_Record] and linked it to itself by the un…

Hi, I'm creating a dropdownlist where the user can choose between different units. The user should be able to choose between the general unit being "PCS" or the sub-unit (could be gr, kg, boxes etc..) which is mentioned in another field of the record. Main idea behind this is that the user has the freedom to be able to select the full quantity of a record or a smaller quantities in logical units. Lets say one PCS = 10 boxes (instead of for example 0,2 PCS the user can enter 2 boxes). So I want to create a dropdown value list based on a combination of two sources: - 1 fixed value, which is always the same (in my case it is value "PCS") - 1 value b…

I've been using FileMaker for many, many years... dabbled enough in building solutions to be dangerous. Over the years I often come across a problem that has no solution, but a notorious work-around. Filemaker's limitations provide endless frustrations for this simpleton. Just this evening, I was building a very-very simple database, and just needed a field to have a basic drop down list... but no matter how i work it, it is ugly, or over complicated, and borderline dysfunctional. Why is the very basics of a useful tool like a drop down list so gosh dang junky!?! There are many features FMP has, I'd almost trade them all for a simple/functional way to build a drop down li…

I have a 'Jobs To Do' file. In it I create a job and assign it to people who are listed in a portal. I have a dwindling VL on the portal which ensures the same person cannot be assigned to the same job twice. What I am trying to do is to ensure a person is only assigned to one job. ATM when I create a new job, the list displays all people including those who already have a job. Can anyone assist with this please?? I have attached the file. Thanks. DWINDLING TEXT FIELD FOR FORUM.fmp12

I have some data I need to store that closely resembles preferences. It's not going to change often and I'll want to refer to those values when calculating things in other tables. Like a tax rate container that I might refer to in a calculated field on item price. Were would I store those?

Hi everyone, My title may be a bit obscure, so I’ll explain. I am using FM 16. I have records that hold the results of ancestry research. Each record has one main person and several other persons. So sometimes person A is the main person in a record and ‘’another’’ person in a different record. I have a portal that displays all the records. I’m filtering this portal using a global field and a value list. The problem I have is this: if I pick, say, person A in the dropdown list, what I’m getting in the portal is all the records where A is either the main person or ‘’another’’ person. I’d like to be able to filter the portal further by choosing, say when I se…

I want to do something seemingly straightforward, but it seems very hard to accomplish. I have two global text fields that a user sets in a table TGlobal. At some point, I want the user to choose between the text values in the two fields, FieldOption1 and FieldOption2, which represent different options that a user can take at some point in the workflow. So ideally I'd like to create a value list, which can be used to present a user with the two clear choices in an elegant layout that contains a question and a radio button. So here's what I have tried to do. 1. I created a table, VList, with two fields (ValueOptionID and ValueOption) and two records. The first re…

This is a two part question: A Checkbox Field is the selected options from a Value List separated by a return (¶) So if I have a Value List where the options are Alpha, Bravo, Charlie, Delta ... and I've selected three of them, the field will be stored as: Bravo¶Delta¶Alpha Or visibly: Bravo Delta Charlie What I'd like to do is re-format the display of those values as "Bravo, Delta, Charlie" (obviously in the order selected, as the standard way value lists populate the fields) In the sample Filemaker file attached, the blue text are examples of how I'd like to see the choices displayed.. It's likely some kind of calculation with conc…

How do I set a field with a value list item from a script, from a set of tick box values? .. or remove a value list item, but leave whatever else is there alone? Looks like GetValue with the name of the value list and the position # of the value, but I'm sure that also means that if I change that value list, I need to change any scripts that reference them by position # too.. Something like detecting if a string is already there, and if not add it, surrounded by C/Rs, unless it's the first item entry? For the first time a field is set, I presume I could just Set Field (field ; "Value List Item"), and if there's only one entry/line in it, just clear it. But…

Gents, would you please inspect the attached file. The conditional value list I made is not working properly on layout - Prices. I'd appreciate if somebody can point me to some resource to help me understand how conditional values list work and is being consturcted. price collector.fmp12

Evening all I am creating a multiple choice test solution with three possible answers. I have an "Answers" table joined to my "Question" table via a QuestionID field. The answer selection to each question is presented in a portal. Currently I have set up a radio button for the user to select their answer ("selection"), however currently I'm stuck trying to figure out how to only permit one answer choice for each question. Right now I can select all three answers by clicking each radio button in each row. Is there a way to make FileMaker only permit one radio selection in a group of related records (the answers)?

Hi, I've been having this issue for a ling time and thought that maybe today is the day to troubleshoot it and fix it!. I love drop downs for filling out forms. But a while back my drops disappear quickly and I have to click escape to get them to come back. Then when stepping down a list, it will disappear again. Very slow and frustrating? I keep thinking that an update will fix it but it hasn't through 3-4 upgrades. Maybe a preference is corrupted? Where would I find the correct one to delete? Thaks for any/all suggestions Peter

FM stores value list options as they are whole. A web form supports showing the label and storing an associated value. Can the same behavior be easily duplicated in FM? This is in cases where you're working with data that uses simple stand ins rather than the entire string. stored value -- Means: a (All Options) b (Beta Release) c (Complete Image) tr (Translated) I could do a focused find/replace with that CSV data and change those values into their full descriptions, which means any data going back the other way needs to be exported with the values rather than descriptions first.

Hi I'm new to FM and looking for an existing FM questionnaire that I can use and custom if possible. Otherwise advice or how to go about creating one from scratch. Essentially I only wish to display the current question and then based on the answer I need to display the relevant next question based on the answer. I'd dynamic. Anyone have any advice please. Thanks in advance James

I have a field on a layout that I have configured to display the Last names of personnel in my "Personnel" table. I'd like to find a way to make the dropdown menu only display personnel in a certain department. The Personnel table has a Department field already. I'd like to have it actually filter it before it's displayed, rather than validate the entry and give an error if the personnel is in the wrong department. Tagouts Copy 1.fp7.zip

Is there any way to show the Drop Down list without the mouse, when "Include arrow to show and hide list" is active? Example: TheField has a Control Style set to Drop Down list with Include arrow to show and hide list. My cursor is currently in TheField. I want to activate the Drop Down menu without using the mouse. A possible solution would be to have a copy of TheField below the other one. This copy would be set to Drop Down list, but with Include arrow un-checked. Then, create a Script that goes to this copy, thus activating the Drop Down list. However, I am intending to use this field in a portal, and it would be awful lot of copies of the fi…

I have a portal where I navigate with arrows, with the help of Script Trigger > OnObjectKeystroke. I also have drop down lists in some of the fields in this portal. It turns out that OnObjectKeystroke don't activate in drop down menus. Is there a workaround for this?

Hi, all! I find this issue hard to google, so I bring it up here. I'm sure many people have had the same issue, but I could not find any thread on the matter. I have several value lists made from tables, where the primary key is stored but some other secondary field is displayed in popup-menus. Quite often, the choice is removed, and in it stead, a five digit number appears. The number is not the same as any primary key value in the table behind the value list. I then have to manually re store the choices. The relationship is also broken. Can anything be done to prevent this from happening? Thank you for your help

I have an address record with seven fields. To enter the data, my users like to tab through the fields in a set order. One of the fields is set to pop up list with a value list of world countries, the first of which is 'United Kingdom'. My problem is that if I click in the field with the mouse, the popup is triggered and the value list is displayed for selection with the mouse. However, if I tab through the list, when I tab into the field the popup is not triggered so the value list of countries is not displayed for selection. How can I set the layout so that tabbing into that field will show the popup list?

The problem is I have a value list that is based on 2 fields from another table, the first field is Order and the second is the Description, but it only populates with the first field which is a number and doesn't make sense. We need the description. I've had this problem before and worked around it, and I wish there was a simple way to solve this. So I made a calculation that concatenates the 2 fields for the value list, and the script trigger sets the field with the description without the number included (the script trigger does other things as well). But I realize not all of the value list is sorted correctly because it's a text field. Maybe a new calculation? So…

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 rec…

So I am fairly new to this and I am trying to get a inventory database set up. I am working on making the database a that is in 3nf. I am trying to pull information on a drop down menu from different tables. I have attached how they are related below. The input menu does not show me anything from the drop down menu, though there is data there. Do I need to create a desperate table for title data where I store information or am I missing a step to pulling the data from the other table?

Spoiler Spoiler I have an inventory database with several different types of inventory in it. I would love to have at the top of the header a count of each type of device I have. The Column name is "Device Type", and right now I only have four different types of devices, "Printer, CiscoPhone, DockStation, and Lablemaker". I would love to have a counter in the header for each device so I can simply see how many of each device I have. I can't seem to find a way to do this, and I am sure there must be. Could you please help me out?? Thanks!!!!!!!!!!! pic1.docx

I have a value list that displays a fixed set of years: 2018, 2019, 2020...2030. I use it for creating new records. I've already used the years 2018 and 2019 to create records. Is there a way to filter the list so it only displays the values after 2019? Or, is there another way to do what I'm trying to do?

Hi all, In my contacts table, I have a check box field where the user can categorize any contact into three categories that are used in several places throughout the solution. So a contact may be in the 'client' or 'personnel' category. Ideally I would end up with three value lists that can be applied anywhere a contact needs to be entered. For example, when creating an invoice the contacts menu would pop up a list of only those contacts that have the 'client' checkbox set. I keep running into problems with globals not being indexable or the popup list showing the contact ID along with the name which I don't want. So obviously I'm approaching this wrong. …

I’ve been working on a database for a rental company, on and off, for quite a few years. Some of the answers to my previous queries here have been really useful in moving things along. The volume of orders has increased to the point where we need to track things more carefully. The crucial bit is spotting shortages/overbooking, but it would also be useful to generate proper reports on hire volumes for each item, rather than relying on anecdotal evidence. However, the actual "line items” on each order are just text fields that users can freely enter. We try and impose some discipline with consistent names for popular items, but there’s always a fair bit of deviat…

Hi All, please could you give some background? I am working in layout FactoryAllocations. I have a drop down with records from my ATA Table my second drop down is from the FactoryPrice, but I only want to see part with the same ATA as selected in the first drop down. I have my relationship, Factory Price and ATA tbl with relationship between ATAChapter I have created a second bable instance for FactoryPrice and linked to ATA - ATAChapter In my second drop down, I Use value from the FactoryPrice_ATA Tbl and only include values starting from ATA. Still I get all record and not filtered. Is my understanding of this incorrect?

Hi everyone i was pleased to find out that auto complete had been introduced in FM Go 17, however, it’s still not working for me because I have a Sales form that has a Products drop down box. Now the first field for the value list is fkProductID, and I use the second field to draw a list of product names. But FileMaker advanced 17 will not allow autocomplete when two fields are used. I can’t get rid of the fkProductID from the drop down box because that breaks all the related fields on the form and the inventory stock control. Autocomplete is not a problem on FM Pro because even with it unchecked, you can type and it jumps to the correct product range. Problem …

Hello all, I just started using FM17. It has been a long time, since FM11 that I have used FM. I am setting up a solution starting with FM Starting point. I created some value lists to use and all of them are fine but something strange keeps happening with one of them. I select the field, the options come up, I pick one, and I get this. "This operation could not be completed because the target is not part of a related table.". Filemaker does make the change when I select a new value from the list. How can I get this warning from a value list? Doesn't this error have to do with a script? I am not running a script that I can see. Thanks. Dave

Hi All, Lets say I have a customer tbl , a product tbl and a transaction tbl If customer 1 owns product 1, 2 and 3 and customer 2 owns product 4, 5 and 6 When in transaction layout which was opened by related customer 1, I want to select the products only related to customer 1. How would I setup my drop down box to only show product 1, 2 and 3 related to customer 1 and then when in customer 2, to only show products 4, 5 and 6. I dont see any type of filtering I could do when setting up the drop down box value list. The products tbl does have a customer ID reference so I recon it should not be that difficult but I might overlook som…

Hello everyone! This site is awesome and I just joined it. I have a probably SIMPLE question. I just need a column in that keeps count of the records. Very simple, but I can't figure it out, or find the exact formula to use. Here is an example of the formula in the first column, "NO #". I just want to column to start at 1, and continue on at each record. I already have the records in the system, and just want to label them show when I print it out it looks nice like this. THANKS!

I am implementing a Value List using "Values from a field" -- let's say its a list of jobs. I want the Values to be ordered in a specific, non-alphabetical order, but can't figure out how to do that. I see that I can create a "Display Order" field and assign each job its appropriate order, but I don't want to use that # as the field data -- I want to enter the Job name itself. For example, how can I make these three jobs display in the following order? Inspector Archivist Registrar

hi i have a field on my layout that is display via a popover that the value list is based on a relationship narrowed down by another relationship. i would like to perform a find on this layout by only showing the related results, however i can't seem to perform a find in the popup field , is that something that cannot be done - i can't seem to find anywhere it talking about it?

Greets, all: I'm having a royal brain hernia trying to figure out how to create a conditional value list between two tables where there are multiple key fields. (Please refer to the attached.) In the JOB table there is a field, JOB::CAD_Type, which stores a handful of custom values for a value list: COMM, DIST, PROV, ST, and TERR. In the screen capture, I chose ST (for State) as a value for JOB::CAD_Type. To the right of it, under the pop-up value list, is JOB::CAD_Abbreviated--it gets its values from another table (VALUE_LIST) where you can see VALUE_LIST::Cad_Type (ST), VALUE_LIST::Country_Abbreviated (US). VALUE_LIST is a table dedicated to storing values tha…

dear all, i have a questions about making a dropdown menu, for example: i have a category Food the sub category : frozen food, fruits,snacks if i have some categories, food, beverage, tobacco, etc, and i choose food in a dropdown list, it will jump directly to the next field (sub Category) how can we make the script? thank you

Hello! I have come across a very unique situation. We are hosting a multi-user solution with about 50 concurrent users on FMS16 with all clients using FMP16; everything is updated and patched. I have one client that is having issues with drop-down fields on 2 different layouts, each different fields. The user can not click into one of the drop-down fields on either layout to make any changes to that field but can edit any other field or dropdown on the layout. Everything else on the layout works fine just the one drop-down field. The user had a Full Access account so security shouldn't be an issue. No other user of the system is having any issues with these f…

Hi everyone, I need some help creating a drop down menu. I’ve read several threads in this forum about it, but I’m not grasping the concept. I’m probably overlooking something simple, so I just need a nudge in the right direction. It’s a movie database, and I’m adding a drop down menu for directors. I created a table just for the directors, and then created a value list based on that table. I did that because I’m going to be entering several movies with the same director, such Woody Allen, Stanley Kubrick, etc., so I can just open the drop down menu and select their names. As of right now, it works as intended. But I also want to be able to add names to the li…

Once again, I suspect I'm probably making it far more difficult to perform a simple operation than it needs to be. Please refer to the attached. The setup: In the table, CHECKLIST_FORM, there are two fields of note: AccountName__lxt and Course_Parent__lxt. The list of test records is: Record #----AccountName__lxt----Course_Parent__lxt 1 999999 History 2 999999 Social Studies 3 999999 Science 4 111111 History Goal: To enable users to choose from a portal (self-join?) a value (Course_Parent__lxt) where if they click it, a script triggered script will take them to the record belonging to what's in …

I'm working on a database that included 5 tasks that will be checked and initialed by the worker that competes them. We want them to choose their initials from a drop down list. For each of the 5 tasks, there needs to be a drop down list with a list of initials to choose from. I want to keep the list of initials consistent without having to add/delete 5 times every time there is employee turnover. Is there a way to maintain one list of initials that is used independently by 5 value lists? Thanks!

I have two tables named "Products" and "Bundles" . I needed to have a user select from a drop down list either a product or a bundle by name. I also wanted a separator inside the drop down to show the user which items where products and which were bundles. Finally I wanted to sort each grouping (products or bundles in alphabetical order). Here is what I want the drop down to look like and below that is where I am currently at in the process. Drop Down Box -------------------- Products -------------------- Apple Banana Carrot Hamburger Lettuce Onion Tomato ---------------------- Bundles -------…

Hi can anyone advise how i can make a simple value list conditional? I have a single table on a job bag system and one field specifies the choosen print supplier i.e.: "London Print ""Wards Print" etc. I would like the detail fields such as "Foil Colour" to be conditional because different suppliers have different references to the colour swatches.. e.g. London Print may use "RED032" where Wards Print could use "BlazeRed" I only want to display the user the values specified by the choosen supplier.. i'm not sure where to start? I think i need to create tables and relationships but would appreciate any help thats out there on the forum... many thanks

Hello all, I have created this sample solution to demonstrate a technique that I'm trying to implement using custom value lists. I was able to fix my first issue, but the way it was fixed is bothering me a little. Because it seems like too much overhead to have a non-global/non-calculation field serving the same purpose as one. This version actually uses two extra fields whereas the first was using one field. Maybe I am over reacting and this will not cause any issues and is a fine alternative, but I wanted to reach out and see if anyone else had any thoughts, ideas or suggestions on this before I move forward? My original problem shown with versi…

Hi Folks, I hope you're all well. I'm trying to use a Find step in a script, to find multiple words from a Global field checkbox in a field in the same table. It works fine when just one word is selected, but fails when two or more are. I've tried different operators, but = and == don't work either. Is it possible to get this kind of thing to work, or is it only do-able in related tables? ------------------------- hmmm, having asked the question, I suppose I could separate the list into it's different words, give each a variable and Find for each variable. There are only three possible words so a max of three variables to set. Can't remember…

Hello, I want to split a custom value list into two lists while keeping my records intact. I used to add new vendors to a custom value list called _vendors_. I have now reached the 30000 character limit. I have managed to solve the 30000 character limit on custom value lists by splitting them into two list (_vendors_A-K and _vendorrs_L-Z) following these steps https://community.filemaker.com/thread/93937. Problem is that since I changed the value list _vendors_ into two new lists the records don't remember their old custom value meaning I would have to change over 4000 records by hand. Is there an easier way to solve this I might have overlooked? Excuse my lack of te…

I have 3 tables: Person, Session, and Contract where Contract is a join table. I am in the Session table layout, in a Contract portal. I have a field – Trainer Name in the Contract table – where I want to select the name of a person from a list of people in the Person table. The Trainer Name field is a dropdown list using values from the Trainer value list “Person::__k_p_Person and Person::Name_Full”. I have tried numerous configurations with table instances and I either cannot alter the Trainer Name field at all, or I get a “?”. After the Contract record is created, I want it to show up in a Contract portal on the person’s record in the Person table. …

Hi, so I'm struggling with a solution for work. It requires being able to filter a set of records through two different specifications (the first being department [HR, engineering, shipping, etc] and the second is status [active, inactive, or unknown]). I want it so that WITHIN each department only the records with Active and Unknown are displayed on a value list for populating a related table. I know how to do it for one level, but not two.

FM 16. I would like to have new field entries automatically be added to the value list for the same field. I tried searching but wasn't able to find any references to this. Apologies if it has been previously addressed and appreciate any advice. Thanks.

I have a value list in my Timesheet table that includes all related values in the last 60 days, so that a user can use this as a quick reference of their recent usage instead of looking up codes every time. What I'm trying to do now is sort the value list by a second field (Timesheet::Client_Project_dropdown), which is in itself a calculation of company name and project name fields from related tables. As far as I can tell from error messages, I can't sort the value list by this second field because it can't be indexed, because the calculation is based on related fields. I know I can make these fields text fields with auto-enter calculations, but the…

I have stumbled upon a strange bug in one of my Databases concerning a value list. We have a table containing part numbers, which is related to a table containing "revisions" for the part numbers, which is related to a table of inspections for the "revisions". On a layout of the Inspections table, I have a value list. This value list selects the UUID of the revision, but displays the Part Number for the user. This has worked perfectly for several months. However, this morning one of my users discovered that he was unable to located "0000194" from this list. At first I thought maybe the UUID's somewhere along the line had become disconnected from their respe…

I tried looking in the forum but couldn't find anything similar. I'm having a hard time with creating a value list from a many to many relationship, this is the diagram. The goal is to have 2 drop down lists, ddl 1) shows all of the companies ddl 2) shows the programs that are related to the company selected I'm not sure how to create the conditional value list, do I have to create a table occurrence? if so, of what table? This is what the ProgramCompany table looks like Thank you guys for your time, you're awesome

FM 15 Adv. When I click on a drop-down list it selects the whole value making it difficult to edit the value. I have to click 4 or 5 times before the selection disappears so I can edit the value. The drop-down reads values from a field and is not configured to select the entire contents on entry. Is there a way to stop this? I would prefer to just click and have the insertion point appear where I click.

Hi, A customer needed to "List" only if the item was "Different", if more than the same item, the customer only wanted to see it "Once". As I pushed the value list to his field, I noticed that it was not in the correct order. Is there any way to list within a value list "creation order", the value list organizes itself either alphabetically / numerically. I need creation order ( M43, C167, S26, G6789 etc ... ), suggestions ? Thank you. I tried ordering within the "Value's" relationship by my "Creation DateTime Stamp" but the value list still ordered incorrectly ... The value list needs to organized this way ... creation order; …

Well... I spent about two weeks of trial and error getting my DB to provide conditional value lists as I wished, since I couldn't post the DB online. After using the DB for a week (mostly flawlessly), my conditional value lists didn't end up working. Being frustrated after beating my head against the wall for so long, I researched (more) about this ability, and have come to the conclusion that either 1) I have issues translating simple two table examples to my more complex example, 2) I'm missing something fundamental, 3) my structure isn't conducive to my goals, or 4) I have issue with creating the value lists from the proper sources (which is easy to do, considering the…

Hi all I've created a value list that serves as an email autocomplete drop down (like the sort in an email client). This VL looks to a single text field in a single record table which currently has 3000 lines. The field is updated every 15 minutes by a scheduled server script. The 'auto complete using value list' option is applied on the field that refers to this VL. The old method was to not have a VL but to just tick the 'auto complete using existing values' option on the field. This was not ideal because existing values might be incorrectly spelled email addresses (and the user would not be able to remove them). Since switching to the new method it …

Greets, all: The attached file is representative of a much larger one I'm working on. The goal is to see in COURSE::TestField__lxt a value list of only Astronomy's related values (through COURSE::_k_Astronomy) in the VALUE_LIST::VALUE__lxt, i.e., Planets, Stars, Galaxies; in the Edit Value List window, I left it set at "all values" just to test the relationship--which seems to be working. However, I know there's something amiss because FileMaker Pro won't let me set the "Include only related values..." default to the appropriate setting. I'm curious why the relationship seems to be working, but isn't. Is the "real" solution to set up yet a third related table wi…

Hi all I've added a new table and field which needs to use a previously created value list called "clients for sorting". The VL will be used for data entry in the new table. To save clutter I would like to use (but edit) this VL instead of creating a near duplicate. I'm not sure where exactly this VL has been used up to this point but I am willing to trust my naming of it and say it is for sorting and not data input. It is currently configured to show both the first and second fields, and to sort values using the second field. I want to change it so that it only shows the values from the second field (for the new table/field). Two questions: 1. If I do…

In FileMaker 14, I have a checkbox set that allows the user to enter other values aside from the assigned value list. I'm trying to figure out how I could display the "other" text that is entered by the user, without also displaying other selected items, since those are visible in the checkbox set. Can I somehow filter each value list item out and only display what is left in a text field? Thanks for any suggestions.

Hi All I am fairly new to FIlemaker and am working on a project that I want to have a few conditional value drop down lists for product entry. I want to have the ability to enter in multiple line items and have copied the fields to make up 5 lines. The issue I am having is that the drop-down menu selections populate all of the line items when something is selected. For example, if I select something in the first field, it selects the same section on all 5 lines I feel like I am missing something simple but have been banging my head on this for a while and I am not getting anywhere. Any help would be appreciated.

I have a keys database: what keys have been assigned to a person or location. so i need a list of these people (scott, bob, smith) or locations (key box 1, key box 2, binder 1). How can I put the list so that locations are first and people are 2nd (in alphabetical order) like this: Binder 1 Keybox 1 Keybox 2 Bob Scott Smith Thanks in advance.

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?

Hey all, I have a table that has hundreds of records that describe archival footage based on "tape names" for a documentary I'm working on. I also have a second "in the cut" table that describes all of the clips contained in an edited episode that may have several iterations of the same tape, since we are using different sections of them. However, we want to DESCRIBE each iteration of the tape name contained in the "in the cut" table, differently. Instead of creating a field and manually typing out the description of each iteration in the "in the cut" table, is there a way to create an editable value list that connects to each tape name, allows the user to …

I have a field called "Employee Name" that presents the user with a drop down list showing a list of all employee names. I would like to force the user to select their name from the list only and not be able to manually type in their name. How can this be accomplished ?

I have a popover portal that displays a virtual list. My client would like to have two or more windows open at the same time. (ugh, i know). Currently, if the user has two windows each with a popover portal displayed, they are parsing the same $$vlist, and so one popover's portal is showing the wrong data. My options seem to be: find a way to make the $$vlist window specific find a way to close the first popover if the user makes a different window active (both popovers do not need to be visible at the same time) hide one popover by storing a key in the virtual list that compares the record to this key in the $$vlist, and if the key isn't ther…

I am just working on an appointment reminder system and I would like to create a set of records each day for the next day's appointments. In general, appointments are half hourly and mostly only one for each timeslot. I'd like each new record to auto-enter the appointment time 1 slot (30mins) later than the time slot in the previous record. At the moment the timeslots are in a value list from 8.00AM to 5.00PM in 30min intervals. Once I've created the record for the 10.30AM slot I'd like the next record to auto-enter as 11.00AM etc. My current method is to do it by calculation from the time data in the timeslot field from the previous record by using the value of…

Hi there, Please can you advise? I have a database with the fields "Category" and "Item". There are multiple categories. Each Item record is different, but some will have the same category next to them. I have a drop down list that lets me choose a category, but i would like to be able to choose in a second drop down an item that belongs in the category chosen in the first drop down. Does this make sense? Hope someone can help! Thanks, Mike

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?

Can a person select certain items in a Value List or does one have to select everything?

I am a new filemaker user and have already checked several dynamic/conditional value list threads in this forum. However, I couldn't find the solution for my problem. I want to show the value list according to unique date and not already entered products. I have created a video explaining what I want to accomplish. Please check here: https://www.dropbox.com/s/js1rwex9o6a2fv5/01%20Product%20selection%20according%20to%20date.mp4?dl=0 Any help is appreciated.

Let's say I have 1000 values in the drop down list. What's the easier way to select from such drop down list? I know I can move the selection by typing some beginning letters of the values but that's not that user friendly. I may not remember the beginning letters and might remember the middle letters. I am looking for functionality something like as shown in this video: https://www.dropbox.com/s/8s7ecv1d0chi3yj/02%20Dropdown%20with%20filter.mp4?dl=0 Any easy solution?

Hello I am trying to create solution for examination questions. Each question can be allocated to one of 38 key topics and only one of 38 topics I have decided to do this using a value list based on a table of Key topics Each Key Topic has a name and a code (an alphanumeric value) In the Question layout I want to have a drop down menu to chose the Key Topic and have the code auto-populate using a related field. I am struggling to understand the relationship because the Question seems to be the parent in the relationship, but it can only have one child - so seems to me to be a one to one relationship or an attribute!! When I design the r…

Hi all, How do you set up a checkbox so that only one value is set such that selecting another value will clear the current value.

Hello, I have looked over the forums and I can't find a solution that best fits what I am trying to do. I have a large DB filled with about 200k policy numbers Some are duplicates and some are unique. What I would like to do is using a self joining table list all the unique numbers (taking the first record from duplicates) and have them automatically be entered into a second related table called policy join. Here is what I have so far, I created a self joining relationship between the policy table. I have created a find duplicate script which looks for duplicates and in the policy table this script insert a new record into the policy join table. I am wondering if …

I need to update a solution designed for FM9 to FM15, the whole solution has 68 value lists (VL) all of them based on tables but only a few of these are conditional VLs. All of the tables have a primary key and a value field. The solution is designed according to the separation model. In the user file layout, each of VL data fields is duplicated so one field stores the value id (as dropdown list) and the other -just on top- shows the related value. This design requires a lot of table occurrences just to show related values which makes the graph and layout design more complex and tedious. As most of the lists are static (their component values will never be chang…

I would appreciate if anyone can suggest how I display valuelist items in a Show Custom Dialog script. I am interested in presenting a date range to a user so they can select an upper and lower boundary. Thank you.

Hi there, I am looking to create a value list from a unique set of values in a given field. E.g. 5 records with apple, cherry, orange, cherry, apple and want to have a dynamic value list containing just apple, cherry, orange - having pulled the unique entries from this list. Having searched through this and other forums, I have found various ways to either extract these distinct records, or create a list but not seen how to put them together so that the list is automatically updated. I'm assuming that the value list will be from a calculation field, that in turn (funnily enough...) calculates from the "fruit" field in this case, but I'm unable to apply it. Per…