Value Lists

I cannot get my head around a particular problem but I am sure there is an easy solution. Can someone help or knock up a small database I can download and look at? Here is an example of what I am trying to achieve. 3 fields, 1 spanish, 1 french, 1 english They each have value lists assigned to them containing the numbers written in each language, so the English field would have 'one', 'two' and 'three' as its values, if I select 'one' as the value for the English field I want uno & un to appear in the Spanish and French fields, alternatively if I select an entry in another language I want the corresponding entry in the other language fields to be d…

Not sure if this is possible, I'd like to have two checkboxes for each value. I've attached an example in PDF. The values are just used for display and print purposes. I know I could work around the issue by creating two value lists that are checkboxes, put them next to each other and on the one checkbox item only display the actual checkbox not the text. I hope this makes sense! Thanks in advance. Caroline DatabaseColorblockex.pdf

This one's giving me a brain hernia so maybe a seasoned FMP vet has an answer for this one... I have a field (with about 30 items in it) set up as a checkbox and I want to give the user full authority to edit the list without using "Allow entry of other items" since the new item--entered using "Other..."--doesn't appear in the list when added. Fine there. The problem at that I want to be able to record the checked list of items somewhere so in case the list is changed they still have their stored, original choice selection(s) that can be used in a report. Example: List items: [ ] apple [x] orange [x] pear [ ] banana If the user decides to r…

I could swear I've read how to do this, somewhere, before, but now I can't find it. My problem is this: I have a Value List called PeopleNames which uses values from first field "Person::id" and second field "Person::name". "Include all values" and "Show values only from second field" are both selected. Now, in my layout, where I use this value list to select a particular person (which I use for filtering a list of things), I want to also include at the very top of my menu of PeopleNames an "empty" value, or one that says "*ALL*" or something like that. * I don't want to have to create a blank dummy entry in the Person table (with Person::name = "" or Person:…

I would like to add a drop down list in the header that lists the various fields I want to be able to sort by. Prefer that when the drop down is clicked, it auto sorts... however a dropdown with a SORT button is also ok. I cannot figure out how to accomplish this. I know I need a value list of all the field names I want to sort by... but I am lost from that point on... Does anyone have any examples they can post to me so I can see something like this in action and dissect it?

Hi, I would like to create a value list based on a calculation so that the list only shows the classes available to an employee based on which classes they are allowed to take. There are fields in the employee info db for each training with Yes or No marked as to whether they need to take the class. My thought was to create a calculation field to display only the classes marked as yes and then make a value list based on that field. I used this calculation for the field: If ( RTK = "Yes" ; "1" ; "" ) &¶ & If ( Waste Handlers = "Yes" ; "2" ; "" ) &¶ & If ( Back = "Yes" ; "3" ; "" ) &¶ & If ( Eye = "Yes" ; "4" ; "" ) However, th…

I wonder if this can be done to avoid the use of validation calculations? I want to find a VL filter that will prevent double bookings of room_names in the same time_slot; ie. once a room_name is chosen for with a time_slot in one record, that room_name no longer appears in the roomVL in other records. Table1:rooms comprises 8 "room_names" Table2:Schedule date room time_slot time_slotsVL use "custom values", 8:00, 9:00, etc. roomVL based on relationship, Table1::Table2, "use values from field" Table1:"room_names". So, for example: the user chooses the time_slot first (from time_slotVL) and then room_name from roomVL .... re…

Hi guys I need some advice on performing what I assume is a basic function. I have a dataset of patients with their postcodes(zipcodes). I need to determine how many live at any given postcode and ideally display the count of each given postcode on a graph. I can think of ways using relationship with a given post code as a match field but that would involve creating thousands of relationship. Is there an easy way of doing this? Joseph

Hi all, I have this wierd problem with one record.I have a student table and team and degree table related to it.So in the student layout i created a portal that displays the degree and team of each student record.On the layout screen , i have a student number ,unique to each student.Beside this field i created a button that search a student record based on first name or last name or student number. What i did... I Could see a record for one student eg. student number :123456,in the student number field.Now , i tried experimenting by typing a different student number in this field(in other words overriding the value in this field and then clicking on …

I have a table that has the following fields: Phrase/ Phrase Export/ Phrase Export French The idea is that I can create a list of warnings, and the long form of the warning will be available for export. - This works fine. The Phrase Export French is the translated version of the warning. My problem is that I can not get the french field to display properly on the layout. It comes up blank. I have set it to the specific field it self,but I get an . I tried creating created another drop down that's supposed to display the Phrase Export French - but it also comes up as . Since these fields only exist in this one table, I'm not sure what to…

I have a value list where the 1st field is text and the second a sequencing number to order the text when the list is displayed in a drop down list. I would like to suppress display of the 2nd field in the drop-down list. I tried reversing the fields and using the 'display only values from the 2nd field' option, but it won't let me sort on the 1st field. Is there any way to suppress display of a 2nd field in a drop-down list when that field is used only to sequence the entries in the list? TIA

Hello, I have a student database, in which i have already entered all records.I created a semester field later.Now, i want this field to carry a default value of "spring".What i did is that in the options section for fields i entered the default value in auto-enter tab.But, this works only if i create a new record(that is , it enters the default value for all new records) and not the already created ones.Is there a way that for these already existing records also the default value gets entered.I am asking because no.of already existing records is 700!! and i dont want to enter manually. Any help will be appreciated Thanks, sunshine3

Hi I am new to fmp. I am designing a database for a sauna to check people in and to charge drinks ect to their key number. I have 2 tables: [Lockers] LockersID LockerNo CheckedIn (Yes/No) [CheakIn] CheckInID DateIn TimeIn Locker I have a pop up menu to select the locker however i want to filter this pop up so that it filters to only show lockers whos checked in value = no. Now if I was using access i would do it via a query but can't see how to do it in fmp. ultimately I will have scripts set up to automatically toggle the CheckedIn when the client checks in/out. I hope this makes sense ad many thanks in advan…

I have a checkbox that is populated by a value list. The information will change from time to time so this seemed to be the best way to set it up. The checkbox items are displayed in alphabetical order but I would also like the resulting text field to be sorted alphabetically. Example – Checkbox 1 – Apple Checkbox 2 – Pear Checkbox 3 – Turnip If a user selects the Turnip check box before the Apple checkbox – the resulting text field will be “Turnip Apple” I would like the output to be sorted alphabetically – “Apple Turnip” Is this possible? The reason for this is that a report I created is treating the same output as multiple outputs…

Very simply, I have FMP Server 9 running on dedicated machine. I use our FMP database to store info and images about the products that we sell on our website. I need to be able to import images and pdf files into the database (and be able to view both filetypes) and have those files stored on the server machine in a folder which I will synchronize with our FTP site for use by our website. Is there a simple way to do this? Currently I import images INTO the database (instead of just references) and then export those images to a specific folder when I am ready to upload them to the FTP site.

I am using FM9 and was wondering if there was any way of changing the order of values displayed in a drop down list. The values shown are part of a value list showing values from another field. Any help would be great have hunted the forums and can't find somebody with a similar situation.

Hello all I am fairly new to FMP and am at a beginners, conceptually alot of it isn't too difficult as I am familiar with Obj-C, C, some java, etc so I get some of the underlying concepts. Essentially what I have done so far is created a database for the window and door company I work for. What it presently does is store the prospects name, address, phone numbers, email, the product demoed, high price, low price, demo outcome, where the lead came from, a number of image containers to upload purchase agreements and various other docs into. It generates and emails reports and various other things. It works great for this but I would like to add an additional layout that…

Hi all, I have a general question, I have some very long lists defined to get their values from a field, these list can end up having over 20,000 items, whenever the user clicks in the list, it can take long time for the list to respond, sometimes by merely selecting the list the whole program goes in No Responding mode, Is there anything I can do to make the lists faster - less resource consuming? Any help will be very much appreciated! Amram Chayim Eirinberg

Hi, I have the following problem: I have a database of companies, some of which are checked as holdings. I need to define a value list, which will display only those companies, that have been marked as "holding" with a checkbox (i.e. the checkbox field is set to "1"). I have found a couple of ways to do that, but when I assign a company to a holding and after change the name of the holding company, the value in the assigned record stays the same. So I need to have the value list update the records when I change the name of the company I have assigned as "holding". I have managed to get it working with the company ID, but I can't make it show the company name, an…

What about sub-menu functionality of a pop-up menu? Do you think this could be a feature request? In terms of graphic interface it is a very convenient and intuitive way to select gradually a value, sorting out the unwanted ones, not to mention it is a widesread method as well.

How can someone insert separators in a value list based on a field, similar to the "-" sign entered in a custom value list?

I am using a value list and a relationship to retrieve and de-dup some data. How can I custom sort the result? The field in question outputs: LRG MED XXL I need the output sorted MED LRG XLG

Please help. [color:red]1. Sort within a function LIST (Field) 2. Isolating the first 8 (the largest or smallest value) Is able to sort the data received from the Aggregate function LIST (field)? How to sort or is there possibility to sort the data obtained with the function LIST (field) from smaller to larger, or vice versa? The data in the function list are unstable. Custom functions or? The result of LIST function is: 234 223 246 219 237 244 245 258 238 211 233 220 252 227 229 243 257 263 239 230 255 242 268 217 265 I need: 268 265 263 258 255 257 252 246 245 244 243 242 239…

Could not being indexed effect the performance of a conditional value list with IWP? thanks, Jim

Hi all I have read the following topics: http://fmforums.com/forum/showtopic.php?tid/214365/post/new/#NEW http://fmforums.com/forum/showtopic.php?tid/214264/post/354251 My problem is similar, but not quite the same. I am trying to create a layout that only allows data to be entered into a field if a condition is met. e.g Do you have a favourite colour? If the answer is 'yes' then I can select from a value list what colour is my favourite. If my answer is 'no', I wouldn't be able to access a drop down list of colours and the field would not be editable. How do I go about this? Thanks in advance Lee

Can a VL that uses field data be made to retain formatting? The ValueListItems function returns the text only as entered. My VL in question is used in a function to compare to two VLs which does not work due to differences in capitalization of original data. Formatting the field using auto enter calcs does effect the data in the VLs.

I have two tables Discipline & Disposition. I created a value list using the records from the Disposition Table. I want to use a drop down list to populate up to six Dispositions on the Discipline Layout. When I use it on the first occurrence, both fields from the value list appear. When I try it on the second occurrence, only the first field populates. Seems like a common use of value lists, but cannot figure it out. Thank you in advance.

Hello to all. This will be my first post on the forum, so I apologize if this isn't in the right place. Over the past few months I have been slowly building a database which will eventually track pieces of equipment as they go out into the field. The main purpose of the database is to keep us from "double booking" equipment for different projects which happen at the same time. Comment has helped me through to this point with some older explanations/examples. I am not sure that they are exactly what I need, but have seemed like steps in the right direction. - To prevent items from being used on two different jobs at the same time, I set up a self join relat…

Sorry, if this has already been ask on the forum. What I would like to do is: I have a field named Vendor on a PO layout I have a table of products and a products layout I would like to see in a value list of only related products of that vendor on the PO This for all of my vendors and their products Thanks

hi, I would like to count the number of items contained in a value list that is defined by a calculation. I have a field that displays the value list like this: CIO CW NWW I'd like to to be able to count this list so I can provide conditional formatting to a field if the list has more than one item. Any suggestions? Thanks.

Greetings all, I have been through all of the threads of this topic and have seen this subject has been discussed half a dozen of times but I guess my question is a bit different. I am trying to make a two steps procedure to help the user choose the address he/she is looking for among the whole group of address. I have designed two value lists ; one with the Groups list, the other with the Subsidiaries list. When the user selects the Group he/she is looking for, the second value list should be set up, live, with this selected Group's Subsidiaries list. My problem is that my second value list is not immediately initiated. In fact, the selected value of …

Is it possible to test for the existence of a value in a drop down value list? I am trying to build a script (triggered on field entry) to auto enter a value, if that value is in a drop down value list.

I have a calculated field with the following definition: ValueListNames ( Get(FileName )) The file has many lists, the field returns an empty string! Any help will be very much appreciated! Amram Chayim Eirinberg

I understand the theory behind displaying a number field in a value list. FMI sees only the number in the field. Then it takes the first entry (of that number) and displays that in the value list (including any garbage with it). By garbage I mean non-numbers. So in attached: -1234 is seen first as -12aazzzz34 so it displays. ---aa12 a ---34 isnâ��t seen as separate number (but as -1234). 1234 is first seen as a1234a so that displays as well. But why is Monday showing in the pop-up? Well, the first time (and only the first time) that any straight text appears in a record, it displays in the value list. Notice that the dash and slash wonâ��t display. …

In trying to format a field to create check boxes based on a value list, the dropdown menu under: Field Control/Setup/Control Style/Display As is blank and frozen. This problem is not limited to creating check boxes for a value list, as I have also observed this behavior when trying to select the format for exporting records. Sometimes restarting the OS fixes the problem, other times the issue is persistent. It is currently holding up my work, so any insight is greatly appreciated. thanks, bones [color:red]UPDATE: It appears as if this behavior is due to a conflict with some other software. Logging on as a different user (essentially a fr…

I need the value list to change based upon the contents of another field. If Field A = US then value list for Field B needs to offer Yes or No. If Field B = Canada the value list for Field B needs to be No only. thanks, Jim

Is there a way to find the number of values contained in a value list? The value list is calculated from the entered value of a particular field. Thanks for your help. Gary P

Hi, I am trying to build a program to calculate the results of a competition. I have 1 table with: competitor type of obstacle 1 (Value list) marks obs 1 (Value list) co-efficient obs 1 (look up) result obs 1 (Marks X co-ef.) type of obstacle 2 marks obs 2 co-efficient obs 2 result obs 2 etc. up to 16 and a second with: type of obstacle (time, pace, success) marks obs ("time", "walk/trot/sprint", "yes/no") co-efficient from which the value lists and look ups are sourced. I have managed to make it work but for each obstacle I find myself having to create a new value list, a new instance of table1 and three new i…

Is it possible using something like the function 'ValueListItems' to alter the state of a Radio Button pair dependant on the contents of another field. I have a club membership application in FMP Adv 11 which has a Radio Button pair of Active/Inactive dependant on whether they have renewed their annual subscription. At the moment the Radio Button pair is a manual setting, but I would like to automate this based on the subscription date. Any help/advice would be appreciated

I think I am in the correct section? What I am trying to do is to create a db for my students to select color combinations, like the color wheel. I would like to be able to select a color from a Value List in field one (First Color) and a second color from a Value List in field two (Second Color)and have the results displayed in field three. First Color: Blue Second Color: Yellow Result: Green Do I need a join table for this? My book is not very clear. M. Logan

This may be more of a script question than a value list question, but here goes (see attachment) What I want to happen is for a user to click on the drop-down list, a warning message appears (a custom dialog box fired using a script trigger), then the drop-down list drops down, revealing its values. I got the first part to work but I just can't figure out what script command to use so the list reveals itself automatically after the warning message is dismissed; currently, what I have to do is click the drop-down menu manually (again) to reveal the list. What command should go in the script? TIA for your help! Rich Career_Launcher_040210.pdf

I'm new at this so would appreciate your help. I have a field "gender" with either "male" or "female" in it, and want to generate a salutation including "Mr." or "Ms.". I tried to set up the salutation field in a calculation as follows: If(Exact(GetField ( "gender" );"male");GetValue( "Mr.¶Ms." ; 1 );GetValue( "Mr.¶Ms." ; 2 )) but this returns nothing visible into the salutation text field What am I missing?

We have a task system we have developed over a number of years and which we are very happy with. Each task is either "in Studio" or "Delivered". Each Task has an "Task ID" and a "Task Description". It also has a time sheet component. Currently each graphic designer must type in the "Task ID" which allows them to allocate time to the appropriate task. Instead of that I would like them to select from a drop-down list of "Task Descriptions", which is simple enough. However I want it to display only the "In Studio" tasks allocated to a specific designer.

I apologize if this has been dealt with before but I didn't find it on the site. While I've been using a template for my Art Studio since v6 (now on v8 and testing v11), I want to be able to start personalizing it. I'd like to be able to select the phone type (home, work, cell, fax, other) of my collectors in a pull down button which would trigger in the next field the corresponding field (home phone, work phone...etc.) for data entry and collection. All I have now is three separate entry fields to accommodate the information. Since most collectors provide a contact preference (either home or work numbers) it would be nice to use a pull down menu so that I can put the pre…

Is there a way to make a checkbox field scroll? I think a checkbox solution is easier for my users than any other value list type; but I have quite a few values so a regular field would take a lot of space on my layout. If not, how can I apply the same type of functionality in a portal solution? I specifically would like the find to work like a checkbox field.

Hi - part of my database is dealing with input of clinical measurements of vision, specifically lens powers (I'm an optometrist). The units of lens strength are by convention in 0.25 steps, so lens power goes +0.25, +0.50, +0.75, etc (or the same in minus values). General practise in clinical work is to shorthand these when entering, as (for example) +050, +100, -250, etc. Actual powers are very rarely above +/-20.00, so we would know to read them as +0.50, +1.00, -2.50, etc (rather than +50.00, +100.00, -250.00, etc). My problem - I need to set up the data entry so that users entering any shorthand versions (such as "050", "+050", "0.50", "0.5", +0.5", "+.5",…

I am using FM9. I am trying to create a dynamic value list from all the content of a specific field, across all the records. I have created a table where one can input, e.g., titles. I would like all that content from that specific field across ALL the records in that table, available to me, eventually as a value list for another field. Is there an easy (or any way) to do that. I can't find a function that will aggregate text from a field from ALL the records in that table. This list will become a dynamic list, available as a pulldown in another field in another table. I know that there are probably a few steps involved. Can anyone help, please? :

Is there anyway to make fields transparent or clear, or must they always contain a color? Thanks

I have a popup course id in student register. In this list it shows all the course id and otherthings that belong with that course id. What i am trying to do not show the course id that are in the past in student register. Or only show the classes that the roster submited yes box is unchecked In Course schedule there is a check box that says (Roster Submitted Yes or No) I would like to use this to not show class once the check box has been check yes. Here is what i have set up in relationship graph: Students::Student ID = Student Register::StudentID //enable "Allow creation of records..." for Student Register here// Course Schedule::Cou…

Is there a setting where upon entering into a field the data is highlighted? In the use of "Proper (name)" in the calculated value of for a name field, names that use "O'" or "Mc" require a space before creating the capitolization of the second part of the name, ie, require "Mccabe" or Mc Cabe" but not "McCabe" -- is there way to refine this?

I am looking to find a way to show more then 2 values in a pop up. In student register when i click on the popup I would like to see course id, Offering Title, Location, Class Start Date, Course Start Time This way i can actually see the all the course info in on box before i select that course and enroll a student in the course. The reason for this type of popup is that we offer the same course at many location and times. Here is a jpeg of what I am trying to do. (popup jpeg) On the left side of the photo is the popup, and the right side were it says [color:blue]click here is what pops up in the photo on the left. This is all in one window i put the…

I have three table one is student, the second is Student register, and the third is course schedule The field that I am trying to count is in students copy called (PAID) located towards the bottom it is a radio button. The radio button say yes paid or not paid. The field that I need the count to be in is in the course schedule (TO) where it say registered paid this is a number field I am trying to count how many student paid for that class so i know the count with out manually looking at each individual student. I would like the count to be in the course schedule SO WHEN I look at the class that are coming up i know how many student paid. You …

I want to create long descriptions next to my radio buttons. The text would be long enough to wrap down a line or two if it was in a normal field. Radio button text seems to not be able to wrap and wants to show up as a really long line which will truncate on a layout. Is there any way to get around this limitation (I know I can program a separate radio button selection box and put it next to fields laid out on the screen and program that, but I wanted to do it directly from the results of value list). Embedding CR/LF doesn't seem to work either. Any ideas on this? Thanks. --Peter Brooks

Hi, i wonder if there is a way to format numbers or text in show custom dialog box functions. Like how to define number as percentage or currency?

Hi all! How can I change the fields format by choosing a value from a list? I want to use it to change between dollar ($) and euro (€) and this value should valid all number format in the record. I can't find any describe in help and forum maybe I have to creat a new layout but change the format is more simplier.

I have a question that is difficult to explain. Essentially I want a field(A) to display one of two numbers. Each number is the value from two fields(B & C) entered on another layout. That would be easy enough but I want the decision of which number will be displayed to depend on another field(D). That field is a Pop-up Menu with 10 options, displayed as a value list. So, dependent on which option is selected in (D) one of two values will automatically be entered in (A). I think I need to define my database. But I can’t figure out how to write out the option for field(A). Should it be a calculation? It seems like I should be able to write a script that would automatic…

First time post.. I don't have a lot of experience with FileMaker but do have many years experience with other databases. Trying to figure out the best way to accomplish the following scenario. I'm building a basic invoice system. I have a relationship between my Invoices table and my Contacts table. I have enabled the ability to create new Contact records via the relationship. This works great but I would like to prevent people from creating duplicate contact records. What would be considered the best way of letting users search for a Contact record before creating one. Open a window and letting them search contacts is trivial but how would I let them 'sel…

I have a field with a value list based on a related child. Each time I add a record in the mother table and enter one of those values I would like the value list to no longer display that name. Is this possible? thanks

Is there a way to concatenate 2 value lists? For example, I want to have one value list derived from a field (call it "account name") Then I want to be able to append a value list with hard-coded values, such as "Add new account…" The only place I want this for is on a popup menu on a layout. The only way I can think of is to create a dummy record with the hardcoded value, but then it'll have to be hidden everywhere else, which seems like rather a lot of work.

Is it possible to filter a value list in FileMaker? I don't want to reduce the value list. Rather, I would like to show only certain values and I would like to show them every time. For instance, in the Demo file attached, the parent table has three records: "Guitar", "Amp", "Microphone." On the child record I would like to use a drop-down with a value list in order to set the foreign key. However, I do not want to "Amp". So, every time I set the foreign key in the child record, I would like to see a value list of "Guitar¶Microphone". Demo_FilteredVL.fp7.zip

how can i prevent duplicate record in portal? if a data is exist in the portal row then in other row the same data should not be entered again. how can i do it?

Hello, I have 2 tables "Customers" + "Appointments". The Customers table collects all the basic info: Name, Address, Phone number, etc. In Appointments I've created a drop-down list (a value-list based on customer names in the Customer's table). That works fine. However how would I get it to pull the related "Address" + "Phone number" into the Appointments view once I select their name from the drop-down? I've created duplicate field names in both tables, and linked those fields via a relationship. I'm just at a loss as to what would be the type of Auto-entry options to get this working. Any guidance would be appreciated, thanks. Marco

Hello, I am working on a database for my company, I am working on our project table, which has projects listed by year with a related table of Contacts which can be related to a number of project years. I have a relation setup Projects_by_Year:Year = Contacts:Years I then setup a checkbox set showing project years (Use Values from Field:Projects_By_Year:Year), therefore if the year is checked that contact is related to that years project. What I am trying to do is uncheck a year via a script, where someone may want to remove that contact for a particular year but not delete the record all together, for example say we have 2007, 2008, 2009, 2010; 2007 and…

Is there a way to format a value list which has 2 Columns of fields in it. My 2nd column of data practically runs into the end of column 1 making it not very legible. There is a need to format the value lists with a width value, or maybe it can be tabbed a certain number of tabs Thanks

Hi all, I have a database system where I can assign categories to a product. There are three levels: category, sub-cat, and sub-sub-cat. I have managed, with a little help, to create conditional value lists for the categories. The sub-category you can select depends on the category you have selected etc. Now I want to be able to compile orders, so I have created two extra tables: orders and order_line_items. From the order layout, I would like to have a portal for the creation of this order. I then want to be able to select the category and sub categories and then finally, based on the sub-sub-category, the product. The first problem is that my conditional …

I would like to create a value list that lists all the records for one table (values from a field) AND also includes "Add New" and a seperator at the top of the list (custom value). If someone chooses "Add New" I'll have a script that runs. Can this be done??? Thanks in advance!

I am using a List of Numbers in a field on layout 1 from Table2. The values are populated from another field table in Table1. The Table1 values are Sorted in Descending order such as: 7003 7002 7001 7000 etc... But when i click on the field in Table2 to view the value list items from Table1, they are sorted as: 7000 7001 7002 7003 etc.. Is it possible to re-sort them in Descending order instead in the Value List? If so, how? Corey....

Hello again great community! Is it possible to have a radio button be triggered base upon a field belonging to a specific value list? I've seen a lot about using value lists for ease of data entry, but not a whole lot for verification purposes. I know I can do this as part of a script or as a replace field command, but is there something that will update automatically so I don't have to run the same thing all the time or have to list every item separately? Scenario. I have a field called "product", and 2 value lists called "fruit" and "vegetable". I also have two radio buttons with the same labels. If I enter apple and apple is in the fruit value list, can I …

I have to set a max number for each category in a found set. I set up a script to handle adding in the max value of a found set but I would like for it to handle adding the max value for each found category. I have the category set as a value list. Is it possible to loop a find with the set max script to go through each of the values found in the value list? There are approximately 30 different categories, and I know that I could manually have it go through each of them, but I figured there must be an cleaner and more concise way. An example would be there there are records in CategoryA that have a number field value of 2, 3, and 4. There is a field called maxNum. I…

Hi All I'm curious to know whether it's possible to construct a key (global) that emulates the * wildcard from find mode but operates on a relationship. eg Two fields in a table and a separate file with globals. Field one is a product code and field 2 a product name. Say for example we have the 1000 series, 2000 series etc in the product codes and they end with 08, 09 etc for a year. Is it feasible to construct a pair of keys for the relationship that accepts such things as 1*09 or 2*09 or the more complex variations like 1*0809 and returns the appropriate Descriptions to a value list ? And if so is it efficient where the tables begin to run …

I am trying to restrict a value list as follows: two fields - one named "Subject" the second named "Category". There are multiple subjects for each category. I have the database setup so that when I enter the Subject field in Find mode, it drops down to show all the subjects. Then based on the subject chosen it shows a restricted list of categories to choose from. When the Find proceeds it goes to the full record that has that Subject and Category. --My problems is that I don't want to show all the Subjects in the dropdown - I want to restrict the dropdown list in Subject to only those Subjects in the current Found Set. So far nothing I do to the way the Value List i…

I have a field in a portal column.. selecting from a valuelist of fields Once i set its field from blank with text.. How can i disable any further editing of that field clicking on same field field again Field is plain text, theres no calculation set on field..

I don't know if this is possible but i have a databse file that contains 3 fields ie PART_NO DESCRIPTION ACTIVE_PART this is a stock database. I can create a value list by selecting use values from field and selecting PART_NO as the first field and then DESCRIPTION as the second field showing only values from the second field. This allows me to show the values of DESCRIPTION in the list but place the PART_NO in the correct field of another tables field?. What i would like to do though is get this value list only to show values for records that have the ACTIVE_PART field set to true as i do not want to delete records when a part becomes obsolete but would like to set …

Not explaining myself well a previous post Attach test.fp7.. with FILE1 with 3 records Listfile with 7 records I created a simple valuelist on FILE layout How would when clicking on my pulldown I only get listed or those only approaiate records in valuelist? When you click on my get button I am getting all seven records test_ValueList.ZIP

Is it possible to have a Value List, to list data from several Tables of records? I have several related Tables, but i wanted to place a value List on a field, that will contain data from several other tables, not just 1 or 2.

Hi All, I apologise in advance if this is posted in the wrong forum, but I'm a total FM newb! Anywho, What I'm trying to do is make a database for my pharmacy that records all the formulas we prepare. Without going into details (don't wanna bore you) these formulas are made up of different APIs and each API has multiple batches associated with it (APIs are delivered in batches and we need to record which one was used. Each Batch may only belong to one API.) I have an AddBatch table with two fields; API ID and Batch ID. Each time a batch comes in we record the Batch ID and the API that it is. Now in the Formula table I want to be able to choose an API from a …

With Instant Web Publishing, accessing a valued list, via radio boxes, pop up lists etc. dont work that well. Is there a solution that makes these work better. It seems to me that the file doesnt update quick enough for them to work.

Hello - I have a table called DocType with the following fieds dtID (num) and TypeName(text). I have created a Value List called vlDocTypes from this table. I have another table called Vendor it has all the normal fields you would expect and then it has the following 3 fields: dtID_purchase (num), dtID_creditmemo (num), and dtID_payment (num). As you would guess each of these are supposed to have values from vlDocTypes. Now, I can of course could have 3 different TOs (of the DocType Table) for each of dtID_xxx fields... However is there a way to do this with a single TO relationship between Vendor and DocType? Thanks Rich

Hi to all i need help about modifing and reordering a filemaker database.. what i don't understand is how to group some radio button values ... i mean - i have 20 radio buttons , they are unchecked as default - i need to add another button which reports if , for a selected record, any of these button are pressed, simply reporting "yes" or " none"... Any idea to do this? thank you very much

I am trying to list a found set of records down the side of a form view. I have a script to find the found set of categories but i would then like to go to any record of the found set by clicking on it in a portal down the side. I have tried to make a self join of the found set but a portal using this doesn't seem to work. Am I headed in the right direction, or is there something else I should be doing?

Hi, I'm learning Filemaker for a new project. I've been an expert Access user for the past 10+ years, so the subtle differences leave me scratching my head. Here's the issue... I have a table called Domain and a table called Category. Each have an * ID field, with the respective name, sequentially numbered, etc. The Category table has the Domain ID in it as a foreign key -- all is well and good. Each Category falls into a Domain. In Access, I would store the foreign key (Domain ID) in the field, but display the text value of interest (Domain Name) via the lookup to the other table. The interface would know there were 2 columns and that the field was bound to the…

Hi. Long time listener, first time caller... I'm working on an art inventory database requiring nested categories. I have a categories table set up like this, using a self-join to assign parent categories: id parent_id title etc... This allows me to set up nested categories to any level, and I've set up a calculation field to show me the entire hierarchy for any given category, like this: cat1::cat2::cat3... I've also set up a join table to add multiple categories to inventory records, and a portal to select from a value list of all category values. So far so good... But I only want my users to be able to select categories with no childr…

I do not have much experience in FMP and am trying to create a database that tracks department assets on a movie. I have one main table with many fields, one of which is called "Set ID." A 2nd table contains "Set ID" as well as "Set Color" (I am using conditional formatting based on the corresponding color, otherwise I would simply list the Set ID as custom values list within the database) The 2nd table contains the list of 18 set IDs and corresponding color codes. In the layout for the 1st table I have attempted a drop-down list that includes the values from "Set ID" in the 2nd table. My problem is this: The ONLY way I can get the drop-down list to appear …

I am trying to reduce the potential size of a Value List, that i use on a layout. I posted a previous thread about sorting, but think if possible, i would be better off removing no longer required values from the list. Currently the value list is a Simple: ALL Records from another field in another table. How can i use a calculated field to make up the Value List instead? When i tried it, i get a Cannot be Indexed alert, and i thus get not values populated in the Value List. I am trying to use a Cal field that states: Case(Job Card Processed ≠ "Job Costed";Job Number;"") This way if the Job has been costed, the Job No will not be listed in…

I'm working on a timeclock database, and need to verify if the data antered in a global employee ID field is in the value list of current employees. It seems simple, but I can't find how to do it in Version 6.

I'm wondering if it's possible to filter a value list that has two fields specified. Example: ID & Info Is it possible to filter this value list, based on the ID, but display Info, for example in a calculation. I am using the following to filter the list: FilterValues(ID; ValueListItems(Get(FileName);"Valuelist 1")) This filters it correctly, but displays the ID, when I would like it to show the Info instead. Also, is it possible to remove the carriage return at the end of the filtered result? Thanks heaps.

I have set up my system so that it records when a field has been changed. The problem is that when I am in a field, and then move to another record, the field that was active in the old record now becomes active in the new record, triggering my system to mark it as being changed. Is there a way to have the active field become "nothing" automatically when moving between records? Thank for your help, Fed

Disclaimer: My company built their database on "first name" & "last name" relationships as well as non-unique project numbers. I am trying to fix it and keep it as close to what they are used to as possible. That said... I need to recreate their Transmittals so they can ship stuff out. I have a simple one to many relationship. One Project can have many Transmittals. I have a foreign key <_kf_ProjectID> on the layout. This field is tied to a value list that displays all of the projects. This all works. How can I get it to filter further to show only the Acitve projects? After that I'd like to know if it can be pared down further to fi…

Thanks in advance for the help. I am fairly new at FM. I am making a database that will do Insurance premium quotes. Here are the basics: It starts with a base premium and then we add the state tax and then add the stamping fee, then admin fees etc to arrive at the total premium. I can do all of that ok with calculations etc. Here is where I need help, each state charges a different tax amount and a different stamping fee. I would like to be able to select (or type) the state (2 digit abbreviation) and have it automatically populate the tax and the stamping fee fields. I have an excel spreadsheet with all of the states and tax rates. I don't …

I have a layout that's shows a list of tasks: Tasks are related to projects via the projectID in the Task Table, and the job is related to the customer via the customerID in Job Table. I've created table instances of the customer, job and tasks, and the customer table has a global, gCustomerID. So I can add a new task, set the gCustomerID in a value list, tab and select the project from a value list, and enter the task description. Works like a champ. The issue is that the user sees the globalID on every record (not the "Customer Name" field, and they see the projectID, not the "Project Name". Is there a tricky way to get this to work like it does …

Anyone know of some great techniques for "categorizing" a value list generated from field? I have a ValuesTable (Three tables make this, ValuesSet, Values List & ValuesLine) I use to store all my Assignment Types. The list has grown larger then expected and is hard for users to read through. I would like to categorized them in some manor to help this. For example: SERVICES - Design - Writing - Motion Graphics PRODUCTS - Printing - Ad Specialties - Signage If you can help or point me to some good material to read/view I would really appreciate it. THANKS!

I need to have a script to select a checkbox in a set based on the value of another field. I am doing passes in school for students. The value list is Bathroom Pass Dress Code Pass Guidance Pass Hall Pass Library Pass Nurse Pass Office Pass Water Pass The checkbox set is Another Teacher, Bathroom, Checking Out, Guidance Office, ISS, Library, Locker, Office, Water. When Bathroom Pass is selected from the dropdown then I need to have Bathroom checked.

ValueListIDs ( fileName ) ValueListItems ( fileName ; valueList ) ValueListNames ( fileName ) what are this functions used for ?

I have a value list which is populated from a repeating [4] field. Lets say that the values in this field are: [C, Z, A, F] And another repeating [4] list like: [1, 2, 3, 4] I am currently developing a Filemaker "Email Center" and I would like to include the option for pre-made emails. This way, a salesperson could go in, put in the address of a new customer, and select the "Welcome New Customer" premade email, which would then populate the body of the email with the correct text. In this way, I would like to have it so that when I select "C" from the dropdown list of premade emails, it fills the body text with "1". When I select "A", it fills …

I made 2 fields in a layout 1.food 2.drink. The field food has a value list in it (1.solid food and 2.liquid food), the field drink has value list (1.pepsi and 2.coke) now question is if i select solid food in the field FOOD the field drink should auto enter into coke hope u understood many are explaining not able understand please can any genius can tell me script please please i am just a beginer

I am a newbie and think that this is what I need to solve the task. I believe that it is a conditional value list, but am not sure. Here is the problem. I am grading assignments. Each assignment has various components with different values. For example -- Project Specifications 10 point max. I have two fields Value and Points. I set value to 10. I then need a drop down value list for Points 10,9,8,7,6,5,4,3,2,1,0. Each component could have a max value that is different. I am currently using a set value list from 50 to 0, but it is time consuming when you have a max for this item of 10. It is also does not make it user friendly to share with another tea…

Basically the title says it all. I'm wondering if it's possible to create a value list whose values are the result of a calculation. For example, an event that begins on 1/1/2010 and ends on 1/5/2010... Is it possible to create a calculated field that would return a list of the dates (1/1, 1/2, 1/3, 1/4, 1/5) and could that list then be used as a value list for a drop down field? TIA

hi again we create value list and items are in text in valuelists is it possible that we can use pictures apart from text m trying but not getting head is about to blast :(

as we enter new records by function show all records we can see all records in list view but i want all records with field name be enlisted automatically in a value list according to alphabetic order so that i can drop down them to view in a layout in a form view hope u understand i am just beginner complex suggestions wont enter into my mind coz m science student pls help me :(

I'm creating an orders database to replace the software we currently use and we are trying to keep everything as close to the same as possible for the users as well as ease of importing data. In the old software, we had the option for value lists, but were able to populate multiple fields based on one list For example, we have a field for: line item Qty Price We have a value list on the line item field that is setup as: product;qty;price the ; would be interpreted as a tab and put that data in the next field. For example: valuelist would have widget;1;9.99 that would populate the line item field with widget, the qty field with 1 and the …