Selecting Multiple Records

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
Here is what I'm trying to do. I have a table for Training Sessions and a table for employees. What I need is to be able to create a record for a training session and then list multiple employees on that record. 

Being that each training session has multiple employees and employees can attend multiple sessions, I was thinking of a join table. However, when I create a join table and create a new record I can only select one session and one employee. Which isn't a feasible way to process training sessions for 500+ employees. 

Am I going about this the wrong way? How do I get what I'm looking for?
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
I have a technique which I can demo for you which would allow you to set focus on a training course and then it would pop up a list of all your employees using a traditional quick base report which includes dynamic filters and the search box.

Then you would click click click on as many employees as you like and they would be quietly assigned to that course.

Then you would click a button to get back to your course and see a list of those employee training assignments.

Feel free to contact me via my website and and I will give you a demo. QuickBaseCoach.com

It typically takes about two hours of consulting time to set this up for a client and then they can use that technique on their own going forward. The technique does not involve any script, just URL formulas, so it is still in the genre of low code no code.