Wickerman Posted August 24, 2018 Share Posted August 24, 2018 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 Link to comment Share on other sites More sharing options...
Agnes Riley Posted August 24, 2018 Share Posted August 24, 2018 I think the only way is to sort your relationship in a way you want. Link to comment Share on other sites More sharing options...
Wickerman Posted August 24, 2018 Author Share Posted August 24, 2018 That sounds promising . . . but I'm playing around with that approach and not quite getting the result . . . So, I'd think the TO of the layout I'm putting the value list on needs to be related to a TO of the value list source with the SORT option in the relationship box set to the "order" field I created? That doesn't seem to work . . . could you give me a more specific nudge? Link to comment Share on other sites More sharing options...
Agnes Riley Posted August 24, 2018 Share Posted August 24, 2018 See if this helps you: https://www.filemakermagazine.com/videos/ultimate-value-list-control Otherwise I would build a portal for users to select from. Value Lists are sort of antiquated and frustrating in FileMaker. Link to comment Share on other sites More sharing options...
Lee Smith Posted August 24, 2018 Share Posted August 24, 2018 Hi Agnes, For some reason??? the link you entered would not go to the article. Anyway, Wickerman would need to be a member to see the video. Here is the same link (as far I can see) as what you typed, and I'll test it in a min. https://www.filemakermagazine.com/videos/ultimate-value-list-control It worked. Lee Link to comment Share on other sites More sharing options...
Agnes Riley Posted August 24, 2018 Share Posted August 24, 2018 Hey Lee, Works for me. And I'm not logged in and I can view it. Some of his videos are public. Cheers, Agnes Link to comment Share on other sites More sharing options...
Lee Smith Posted August 24, 2018 Share Posted August 24, 2018 Hi Agnes, It still fails for me, I get this "/videos%EF%BB%BF/ultimate%EF%BB%BF%EF%BB%BF%EF%BB%BF-value%EF%BB%BF-list-control%EF%BB%BF%EF%BB%BF" could not be found The video and file seem to be for members only, because it showing the teaser video of approx. 6 mins, without access to the file without login. Lee Link to comment Share on other sites More sharing options...
Wickerman Posted August 24, 2018 Author Share Posted August 24, 2018 I accessed the video all right -- there is a paywall to get to the actual how-to material, but that's okay -- I like that site and have been a member in the past, so it's a good occasion to re-subscribe. 1 Link to comment Share on other sites More sharing options...
Lee Smith Posted August 25, 2018 Share Posted August 25, 2018 ISO Magazine is a great resource, I've been a member since 2004. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2065 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now