Jump to content

Ultimate Value List Control

This topic is 2805 days old. Please don't post here. Open a new topic instead.

Recommended Posts

No Access? Watch the preview video here. UltimateValueLists_Pre.mp4
Attachment Size
UltimateValueListControl.zip 279.84 KB
By Matt Petrowsky

People like to have things their own preferred way. Wasn't there some slogan for 40 years somewhere that said "Have it your way."? If people - developers in particular - can control the output, then life is good.

Within FileMaker, value lists are one of those areas where you may feel like you simply don't have the amount of control you should have. It's neither obvious nor inherently possible to control the order in which values are presented in anything other than an explicit value list. You know, the one where you type in the literal values.

The problem is, most value lists are not static. They're typically coming from the data within your solution. It's either all values from a given field or related values through a relationship.

FileMaker only provides you with one type of output, an ascending sorted value list according to the index of the field.

You can't programmatically add to it, nor can you subtract from it. You also can't control the sort order. At least not intuitively!

In this video, I show you a simple solution which provides all of the functionality missing above. You can combine both dynamic and static values and you can also control the order in which they are presented. Need more control over your value lists? This video and technique file will provide the answers!


External links

User-based Value Lists Interdependent Value Lists

View the full article

Link to comment
Share on other sites

This topic is 2805 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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.