How to keep shift details in tables and run accordingly on weekly basis?

Hi @Troy Tessalone 
Two tables  - zap for numbers and zap for shift
zap for numbers is where I’ll be storing numbers for the persons(as initials) in shift schedule.
zap for shift is where I have 5 week schedule, each person is denoted by their initials.
The way it should work is when I call zap for shift after code by zapier (which runs to fetch the week and week day), it should be returning the value as initials and its assigned number from zap for numbers by filtering the week and week day from code by zapier.
How will be the workflow in this case?
Hope the context is clear.

@Troy Tessalone 

Here are some screenshots for reference.

This is the setup(above) we are using to assign values based on week (filter using code by zapier). This zap is running each day based on week number. Calling get multiple values from this particular storage by zapier, we could fetch the assigned values of that particular shift.

Like mentioned, zap for numbers stored for each initials (sample data)

zap for shift has reference for these initials for each shift.

Now I need to replace my existing setup to directly fetch shift member from zap for shift ( gets the initials) and auto-fill their values from zap for numbers,avoiding the use of storage by zapier. Also keep in mind I usually update the zap for shift depending upon availability of people( this has to reflect in real-time).

Inputs for this are the initials in zap for shift and the expected output is getting the values for each initials by the particular shift times.

How do I do this?

@Troy Tessalone 

Of course, I tried them(Find records). But it seems the values from one table won't be available even if I refer the key (initials)to the next table.

@Troy Tessalone 
Based on shared context,  How can i configure this setup?