Recently we introduced the “Related” column prefix that allows seamless access to columns from related tables and really simplifies the settings when creating a dependent dropdown for a single-reference column.

Example: Many Interests

Let’s explore a scenario where managing a list of interests and hobbies becomes seamless and intuitive for users. Imagine having a plethora of interests and hobbies, each interest branching into various specific hobbies. The challenge lies in allowing users to select multiple interests while effortlessly navigating through associated hobbies. Here’s how we can tackle this.

We begin with a robust database consisting of three essential tables: Interests, Hobbies, and Many Interests.

Firstly, within the “Hobbies” table, we establish a reference column named [Interest]. This enables us to designate one parent interest for each hobby created, ensuring clarity and organization.

Next, we introduce the “Many Interests” table, designed to empower users to select multiple interests and subsequently choose several hobbies linked to those interests. This table features two multi-reference columns: [Interest] and [Hobby].

Now comes the ingenious part – configuring the [Hobby] column to display only relevant hobbies based on the selected interests. We achieve this by implementing a filter formula in the record picker: Any([Interest Name], Related[Interests]). This filter dynamically showcases hobbies aligned with the selected interests, streamlining the user experience.

Consequently, users gain the flexibility to cherry-pick several interests and explore a myriad of associated hobbies effortlessly. With this approach, managing interests and hobbies becomes not only efficient but also enjoyable for users navigating the system.

In this example we saw how we can create a dependent selection between two multi-reference columns.

Example 2: Top 3 Interests

At times, the need arises to select values independently across separate columns, while still maintaining dependencies, particularly when selecting hobbies. Let’s delve into how to accomplish this seamlessly.

To start, alongside our existing setup, we introduce a new table named “Top 3 Interests.” This table features three single-reference columns: [Interest 1], [Interest 2], and [Interest 3], along with a multi-reference column: [Hobbies].

Within the [Hobbies] column, we apply a filter formula in the record picker to establish dependencies: [Interest]=Related[Interest1] or [Interest]=Related[Interest2] or [Interest]=Related[Interest3]. This formula ensures that only hobbies associated with the interests selected in the [Interest 1], [Interest 2], and [Interest 3] columns are displayed.

And there you have it! Users will encounter a streamlined interface when creating records within the “Top 3 Interests” table.

By following these steps, you’ve acquired the know-how to effortlessly implement dependent selections for multi-reference columns, enhancing the user experience and system functionality.