Filter data and selecting multiple pieces of data from a list

[James_Brennan]

I’m trying to create an attendance app for a large high school. I would like users to filter down data by department > teachers > periods that teacher teaches > students. I would like the user to select multiple students from a list and gather that information on another sheet.

Right now I have dependent dropdowns with Validif statements that give me the department>teacher>period>student. The student column I have set up to be an enum list so that I can select multiple students. However, the app sheet will only record one student at a time. If I select more than one student from the enum list nothing appears on my sheet. I will get the department>teacher>period information but nothing in the student field.

I have never created anything like this and I do not even know if I am on the right track. I would appreciate any help I can get!
Thank you!

[1minManager]

These might help

Filters in AppSheet applications - in Preview Program Announcements

The following feature has been added to the Preview Program. Feel free to test the feature and report issues or possible improvements in this thread. App users can now filter items from a collection of records based on column values. The feature is available both on mobile devices and desktop computers. Here is a very simple example. Your application has pastries that have a ‘price’ and a ‘type’ (Sweet vs Savory). In a view that shows all pastries, app users can now filter to see only the one…

You’re other choice is to create a dashboard with 2 views. The first is the existing table of data. The second is another table with just one row where you can choose options for department, teacher, period & student. The first table will read from a slice and the slice looks at this second table.

I’ve been an Appsheet Dev now for 5+ years. When I first started out I paid a few people to do various tricky things. So it might be worth just letting me of one of the other devs (https://www.appsheet.com/Partners) do this for you in about 20-30mins to get you started. Most bill by the minute and the cost is quite reasonable.

Simon@1minManager.com

[Steve]

James_Brennan:

gather that information on another sheet

What does that mean?

James_Brennan:

the app sheet will only record one student at a time

How are you accomplishing even that? Are you using an action?

We’ll need a lot more information to help effectively. Please post screenshots of the worksheets involved. Please be sure to obscure any student and faculty information. If the column headers are pretty intuitive, just screenshots of the column headers are probably enough.

[James_Brennan]

 

[Steve]

Start here:

https://help.appsheet.com/en/articles/961554-dependent-dropdown