Search the Community
Showing results for tags 'valuelists'.
I would like help designing a drop down value list which filters the list based on what is already type in the input field. See example - admin 1234 - When they click on the field the drop down menu appears and would be filtered by the first letter of what they typed in so the user can correctly match up with the exact name - the field data comes in from a web form and I do not want to change the web form - just the value list - thanks ValueLists.fmp12
I'm using FileMakerPro Adv 13 Considering There are records like these below 1 Orange 2 Apple 3 Strawberry 4 Apple 5 Lemon 6 Apple 7 Orange 8 Melon I have a value lists called "TypeOfFruits" then If I execute this function Substitute(Substitute ( ValueListItems ( Get ( FileName ); "TypeOfFruits"); "¶"; "n") ;" ";"") I get this output OrangenApplenStrawberrynLemonnMelon It is shown on a page just like this Orange Apple Strawberry Lemon Melon If I want to count all of them and want an output like this, how can I change my function above? (sorted b