The selection filter option, available in the link column options on TimeTonic, allows you to display filtered link values based on a dependent criterion.
The principle is the same as conditional selection, see the article and the comparison table to choose what best suits your needs.
Two filter selection options are available in the column options when your table relationships are pre-configured:
1️⃣ Filter by column value
In this example, I want to be able to filter the contacts of a client in my opportunities table.
Prerequisites for filter configuration:
You have in your workspace a:
- 🔵 Table 1 (e.g., clients) : This is the table containing the reference data that is related to 🟣 table 2 which complements the information (e.g., client contact)
- 🟣 Table 2 (e.g., contacts): which contains the information to be linked to 🔵 the main table.
- 🟠 Target table (e.g., Opportunities): This is the table where you will apply the filter in the link column options to restrict the choice list by 🔵 table 1 (e.g., I want for each opportunity the contact associated with my client, which gives: Contact.Client = Opportunities.Client)
Step by step after the prerequisite:
➡️ Open the Target Table
In the target table (the one in which you want to apply the filter),
- Insert a link column
Configure the available Selection Filter:
- 1️⃣ Select filter: filter by column value
- 2️⃣ Apply the Value Limit by selecting the condition defined by your reference columns offered to you. (e.g., Contact.Client = Opportunities.Client)
ℹ️ The filter ensures that only items linked to the reference value in the target table appear in the choice list.
👉 Illustrated example:
"I want to get only the contact assigned to the client in the opportunities table."
The steps of this example in video:
2️⃣ Filter by shared value
Example:
I work in the Student table. After choosing the link to the class of this student, I want the list of teachers to be filtered among the teachers of that class.
The filter by shared link involves 3 tables in addition to the current table.
If the Teacher and Class tables are not directly linked but through an Establishment table, the filter by shared link is suitable.
💡 Comparison with the conditional selection column to help you decide
| Feature | Conditional Selection | Selection Filter |
|---|---|---|
| Dependency | Strict hierarchy (level 1 > level 2). | Flexible relation, depending on crossed criteria. |
| Common example | Department > City > Neighborhood. | Client > Contacts > Opportunities. |
| Configuration | Requires Selection and Conditional Selection type columns. | Uses filter options in a link column. |
| Complexity | Simple and direct for a tree structure. | More advanced, suitable for cross relations. |