How to get Airtable Data By Filtering

[ansi_nadubail (Mohammad Anas)]

THIS IS MY AIRTABLE LINK

Airtable: Organize anything you can imagine

I wants to filter student by class and show student name on list view.

this is my aia file
MHSS_ARTS.aia (9.5 KB)

[ImranTariq]

I will check after a little and check what is issue

[ImranTariq]

Your Column Name is in Capital NAME and you are asking to get name in small , also Table Name was wrong, table name is STUDENT_WITH_ITEM nd you set STUDENT only
now you list is getting data of Name

[ImranTariq]

You Need a lot of fixes in your screen, like dont send any empty data to airtable other wise it will not recall data, and use a checker before adding data use if not is empty text box, then call airtable to store data, if text box will be empty airtable store empty data and you cant call back that data

[ansi_nadubail (Mohammad Anas)]

no i am calling data from student

[ImranTariq]

Also getting data from STUDENT
From app

[ansi_nadubail (Mohammad Anas)]

data is getting perfectly but i whats to filter student name by class and division.

[ImranTariq]

for that why dont you make extra table for a class, like class 1 has there own table when you try to add student use a list picker to select class and then that selection can be set as table name of spreadsheet and create new row in that class table,

[ImranTariq]

or you can use filter search of listview and call student name with class and search by class, like search class2 and all class 2 students will appears

[ImranTariq]

Like this check out

[ansi_nadubail (Mohammad Anas)]

This is fine please send solved aia.

[ImranTariq]

here is aia file, if needs any help contact me in pm
MHSS_ARTS.aia (10.4 KB)

[Choofa]

Before I download this aia to see how you solved this, may this solution also work with my project?

I have solved it, but with LOTS of blocks and many Airtable components and not the way I want it.

Airtables - Get row based on value in cells of a column

Hi again everyone! I could not find this in forum after some reading, so I hope to find a solution here in my topic. If I use Get Column, is it then possible to separate the values based on the text and then Get Rows based on the value? I have a shoppingcart with different stores, when the data is uploaded the user choose what store it’s supposed to be bought in. Thereafter I want the data to be placed within the List View for that store. I hope you understand what I try to do H…

[ansi_nadubail (Mohammad Anas)]

Thank you for your support

[ImranTariq]

Welcome…,

[ImranTariq]

i suggest you to make single table for a single type item, for example, if a category is clothes, and other is shoes, then make a table with name of clothes, and other with shoes and at main screen set you buttons to open a screen with value, when cloth button click, open screen (shop) with value Clothes, and when shop screen initialize set table name of each spreadsheet to start value(cloth or shoes) and get column , then your list only contains that items, and for seconds or other buttons call there table

[catel (Cahaya Telematika)]

I tried to use your aia, but I was not successful

[ImranTariq]

why what is your issue?

[catel (Cahaya Telematika)]

I want to display data from the airtable using parameters that are input via the text box