Level: Intermediate, Version: FM 18 or later

A Value List Experiment

Demo file: a-value-list-experiment.zip Note 1: today’s demo is recycled from the one that accompanied Virtual Portal, part 2. All we care about this time around is how we assign the parent company; the remainder can be ignored. Note 2: if you’re unclear on value list basics, check out Thinking About Value Lists, part 1. “I… Continue reading A Value List Experiment

ExecuteSQL, Level: Intermediate, SQL, Version: FM 16 or later, Virtual List

2-Column Magic Value Lists, part 2

Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Introduction This is a quick follow-up to last month’s article on 2-Column Magic Value Lists, and, to avoid repetition, will assume the reader is familiar with that material. A colleague pointed out that… Continue reading 2-Column Magic Value Lists, part 2

ExecuteSQL, Level: Advanced, SQL, Version: FM 13 or later, Virtual List

2-Column Magic Value Lists

Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Acknowledgements: today’s article would not have been written without the inspiration provided by Bruce Robertson, John Ahn (FM 12 ExecuteSQL Unconference Session), Andries Heylen (Magic Value Lists), Marcelo PiƱeyro (How to Extend FileMaker… Continue reading 2-Column Magic Value Lists

ExecuteSQL, Level: Advanced, SQL, Version: FM 13 or later, Virtual List

Custom Field-Based Value Lists

Introduction Does this sound familiar? You’ve rolled out a solution that includes a single-record Settings table where authorized users can enter/update various system-wide settings, including one or more fields where the items will appear in popup menus… and then comes the inevitable question: Why don’t items in popup menus appear in the order I entered… Continue reading Custom Field-Based Value Lists

Level: Intermediate, Version: FM 13 or later, Virtual List

Modal Popovers + Magic Date Value Lists

Today we’re going to explore a couple ideas that were glossed over in last month’s article on the CustomList custom function… implementing a “modal” popover using a “magic” value list to display a properly sorted list of dates …and you can download a copy of today’s demo file, Date Filtration, if you are so inclined.… Continue reading Modal Popovers + Magic Date Value Lists

Level: Intermediate, Version: FM 12 or later

It’s Sorta a Value List Thing

Editor’s note: Today it’s my privilege to present an informative guest article written by Jonathan Fletcher on the elusive topic of sorted dynamic value lists. Jonathan is a well-regarded, thoughtful and thought-provoking fixture in the FileMaker community, known for his generous and frequent contributions to various online FileMaker forums. Have you ever had a need… Continue reading It’s Sorta a Value List Thing

Level: Advanced, Version: FM 10 or later

Thinking About Value Lists, part 3

Welcome to the third installment in this series. We’ve been exploring various issues and behaviors in connection with 2-column value lists (VL’s), and today we’re going to look at, and propose a work around for, an issue with filtered value lists in Find mode. All of today’s demo files feature a basic expense submission system,… Continue reading Thinking About Value Lists, part 3

Level: Intermediate, Version: FM 8 or later

Thinking About Value Lists, part 2

In part 1 we explored a particular type of value list: the field-based two-column variety, based on all values, and set to show values from the second column only… …and today’s article assumes familiarity with that material. This time around we’re going to look at some challenges and issues that can arise when using filtered… Continue reading Thinking About Value Lists, part 2

Level: Beginner, Version: FM 8 or later

Thinking About Value Lists, part 1

In July and August we explored several esoteric value list techniques. This time around, and over the next few postings, we’re going to step back from the cutting edge, identify some common value list challenges, and propose some solutions to those challenges. A few thoughts before we begin: Some of the material in this series… Continue reading Thinking About Value Lists, part 1