How to get a list from the current table

[sayan1]

Hello, my friends!

I have a table called Animals, where I have record cattle information. When cow calved, I have added a new row with information new bord calve.

Every cow row has a column called mother. So, when I record newborn calve I have just added mother ID to the mother column.

Now, I want to see all the calves of cow in a detailed view.

How can I select calves from the Animals table in virtual column ?

[OptimiX_XcrY]

You can build a one row second table, just for the purpose of selecting from a dropdown.

Then a slice from the animals, based on that selection.

Another basic way, build a second view of animals table, grouped by mother.

[Lynn]

Hi @sayan
Depending on what you want to do with the list you may be able to get a list of all the calves by doing just a search for the cows ID

[sayan1]

In a detail of cow, I want to show the list of the calves.

Calves are animals, so they are stored in animals sheet.
I want to make like this select in the slice for Animals table
Select(Animals,[_THISROW][VID = Animals[Mother]])

As result, I want to see a list of the calves

[Steve]

sayan:

Select(Animals,[_THISROW][VID = Animals[Mother]])

FILTER("Animals", ([Mother] = [_THISROW].[VID]))

[sayan1]

its greate and help me!

But this data shows me like a text, I want to see this is a table, and I want to press an open his detail.

How can I do that ?)
This Is result:

I want to like this. Like a realated table

[Koichi_Tsuji]

It seems you set the base type of the column to text instead of REF.
Make sure to set to REF and reference table is also set to Animals.

[sayan1]

It’s a good idea!

But, a cow has many calves. So the type of my filter expression is the list.

So I have this error:

I need a list of references

[Koichi_Tsuji]

It is virtual column, right?

Then the field type should be set to LIST, and then you edit the column details further to make the base type to ref / reference table is set to animinals.

It seems you set the column type itself to ref, which is not right.

[sayan1]

right. It’s VC

[sayan1]

Correct this And get new error

Column Name ‘Бұзаулары’ in Schema ‘Animals_Schema’ of Column Type ‘List’ has an invalid app formula ‘=FILTER(“Animals”, ([Анасы][VID] = [_THISROW].[VID]))’. Column ‘Анасы’ is used in a SELECT or list dereference expression and should be a List/EnumList of Refs

[Koichi_Tsuji · Accepted solution]

This is because of syntax error for

FILTER(“Animals”, ([Анасы][VID] = [_THISROW].[VID]))

[Анасы][VID]

Should return the list type , which making this syntar errorly.

[sayan1]

it’s working!

Thank you very much!