Filtering Gender from Reference

[shane171]

I wanted to filter the gender of the employees from different reference table.

I have two tables Personal Details and COVID Vaccination Info. In the “COVID vaccination info” table, I want to filter the gender of those vaccinated employee whose gender column is located in the “Personal Details” table.

I’ll use the data for Chart view. Thank you.

[Marc_Dillon]

What exactly do you mean by “filter” in this instance?

help.appsheet.com

FILTER()

Select rows of table or slice

[shane171]

Hi Marc… I just wanted to get the number of Male and Female who got vaccinated.

“COVID vaccination info” table doesn’t contain gender, it is located in the other reference table.

[Marc_Dillon]

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[shane171]

Thank you, Marc. The links you shared helped the system works.