Skip to main content
Question

Pipeline to Auto-Assign Trainings to Employees by "Profile"

  • May 27, 2026 5:20 PM UTC
  • 3 replies
  • 135 views

Forum|alt.badge.img+6

I have three tables in Quickbase:

  • Employees
  • Trainings
  • Profiles

I’m trying to build a Pipeline that automatically assigns trainings to employees based on their "profile".

Example:

  • The "profile" called “Basic”requires:
    • CPR Training
    • First Aid Training

If John Doe is assigned the “Basic” profile, the Pipeline should automatically add John Doe to the existing CPR and First Aid training records.

A few important requirements:

  • The Pipeline should only add trainings where the Employee Profile matches the Training Profile.
  • The Pipeline must check for duplicate trainings and NOT add the employee to a training if they are already associated with it.

If this can be done without a Pipeline I am all ears.

3 replies

MarkShnierYou
Forum|alt.badge.img+24

Can you tell me more about your relationships.

Is the table called Trainings really "Employee Trainings" which has a relationship to both the Employee and a Training Type Master table?

If I were setting this up I would have these tables

Employees

Master Training Topics

Employee Trainings

Master Profiles

Profile Trainings

 

Employee < Employee Trainings > Master Training Topics < Profile Trainings > Master Profiles. 

 

Is that your setup?   In my notation above it reads like One employee has many Employee Trainings.

 

 


RoyWanyoike
Forum|alt.badge.img+13
  • Qrew Colonel
  • May 28, 2026 8:32 AM UTC

You can automatically assign trainings to employees based on their Profile using a Quickbase Pipeline. The best approach uses a join table (called “Employee Trainings”) that connects the Employees and Trainings tables.

Create a Pipeline triggered when an Employee’s Profile is updated. It searches for all Trainings that match the employee’s Profile, then checks the join table to avoid duplicates. If the employee isn’t already assigned to a training, it creates the new assignment record.

This method ensures only the correct trainings are added and prevents duplicate entries.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 17, 2026 8:57 PM UTC

Mark's table layout is the one I'd use too: Employees, Training Topics, Profiles, a Profile Trainings table (which trainings each profile needs), and an Employee Trainings table (who is assigned to what).

 

For the no-duplicates rule, let a unique key do the work instead of searching first. Add a text field on Employee Trainings called Assignment Key and check Must be unique. The pipeline fills it with the employee's Record ID# and the training's ID, so the same pair can only exist once.

 

Pipeline steps:

 

1. Trigger: On New Event on Employees, for adds and updates, only when the Profile field changes.

2. Prepare Bulk Record Upsert on Employee Trainings, with Assignment Key as the merge field.

3. Search Records on Profile Trainings where the profile equals the employee's profile.

4. For each result, Add a Bulk Upsert Row with Related Employee, Related Training, and Assignment Key (employee Record ID#, a dash, then Related Training from the search result).

5. Commit Upsert, after the loop.

 

If the employee already has that training, the upsert matches the key and updates that row instead of adding another one. Anything new gets created.

 

Without a pipeline you'd be adding those rows by hand, so this is a good use for one.

 

https://help.quickbase.com/docs/bulk-record-sets

https://help.quickbase.com/docs/requiring-unique-entries-in-fields

https://help.quickbase.com/docs/use-the-quickbase-channel