How to get a list from the current table

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 ?

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.

1 Like

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

1 Like

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

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

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:
image

I want to like this. Like a realated table
image

1 Like

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.

2 Likes

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:
image

I need a list of references

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.

2 Likes

right. It’s VC

Correct this And get new error :slight_smile:

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

This is because of syntax error for

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

[Анасы][VID]

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

2 Likes

it’s working!

Thank you very much!

2 Likes