Solved: using "Label" instead of "Key" in slice - Page 2

Asheetbogo · 10-12-2022 12:30 PM

Hi everyone!

I have two tables: a) project and b) tasks

in table "Task" i can select multiple Projects with "EnumList" - works fine - even inserting new projects from EnumList to "project-table" woks perfect!

But if i want to setup a "Project-Filter" (e.g. "Project A") in a slice i have to filter with "key-value" of Project-field (e.g. "abee2625"), as in table "tasks" there are only key-values for all projects i have selected.

How can i achieve that "project-label-values" (e.g. "Project 1") are saved in "task-table" instead of "project-key-value" (e.g. "abee2625") for being able to filter with "project-label-value" (e.g. "Project 1") in my slice?

many thanks in advance for your help!

WillowMobileSys

@Asheetbogo wrote:
How can i achieve that "project-label-values" (e.g. "Project 1") are saved in "task-table" instead of "project-key-value" (e.g. "abee2625")

You can't IF you need to keep referential integrity. In other words, the whole idea of a Ref column is to act as a "pointer" to a specific ROW so that you can get access to any of the columns. For example, you could use your EnumList column to display an Inline Table view of the Projects.

If all you care about is having the list of "project-label-value" values in the Projects column, then change the EnumList base type to Text and provide a proper expression in the Valid_If for the dropdown to show the "project-label-value" values instead to choose from.

HOWEVER....

Let's say you want to KEEP the EnumList/Ref column as is but STILL want to filter by the "project-label-value" values from the EnumList. You can do this by including an IN() function in your filter criteria leveraging the EnumList column. It would look something like this:

...
IN([Project Name], [Project][project-label-value])
...

The [Project][project-label-value], will build a list of the label names.

View solution in original post