Is it possible to generat a list of names based on a date in BASE and have that list appear in a CALC sheet?

[paladin1]

I have a spreadsheet with class dates and student names. I have been trying to use vlookup, lookup or hlookup to create a list of students for only a single date. The lookup would select the date and have all the names in a drop down list to select from.
I have come to the conclusion that this will not work (am I wrong?) so I want to do the student list in BASIC and then feed that list of names into the appropriate CALC sheet, again based on the day.

Ultimately I want all of this in BASE but I am not that good at SQL (last db I worked with was db3 and MS access).

Is this possible and if so how. Any specific design/programming would be helpful.

[Ratslinger]

Hello,
It is not clear as to what you are doing. See no association of Date and Student. How is it that a student (or is it students) are selected by a date?
.
Part of your question seems to suggest using this list of names to place in classes by dates. Again not clear.
.
Please be more specific. Not sure Calc is actually needed. Maybe just Base.

[Wanderer]

@paladin1

The lookup would select the date and have all the names in a drop down list to select from.
I have come to the conclusion that this will not work (am I wrong?)

You are right concerning LOOKUP, but this can be done with data validation in Calc. It is possible to have a formula to select a group of valid entries from a list - this are then availabe as dropdown, when you enter data.
.
For Base I guess you would search for cascading listboxes.

[paladin1]

Let me try and clear this up for you and other helpers. All sheets are in the same CALC file
I teach several classes which are named by class date as in 220815 (8/15/22) and there is a sheet for this class to record attendance, grades, payments, and other items. Call this list A

There is a master list of all students for the year. It includes the usual personal information and a cell with the date of the class they have / will take. Call this list B.

I want to use the title (date) of the class in list A to select all students for this class and populate individual cells with their names.

I know I can create a dropdown list with all names, but with 125 or so names spread by date across the sheet this is time consuming cumbersome and slow.

If I use lookup or hLookup I get just the first name and no series. I use several formulas and such and even wrote macros in 123, and early excel, but I am not a programmer.