# \[Help Needed\] Skill Matrix with Application Builder: Linking Skill Level to Employee-Skill Table (Self-Hosted, Advanced Plan)
**URL:** https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212
**Category:** Application Builder
**Tags:** self-hosting, advanced
**Created:** [May 14, 2025, 6:49pm UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212 "2025-05-14T18:49:28Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@rreichl90](https://community.baserow.io/u/rreichl90)
#### Post date: [May 14, 2025, 6:49pm UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/1 "2025-05-14T18:49:28Z")
Hello everyone,
I’m currently working on a **skill matrix solution** using Baserow (self-hosted, Advanced Plan, Docker).
My goal:
To display all skills (from the “Skills” table) for each employee and allow maintaining a **skill level** for each skill. These skill levels should be stored in a linking table (“Employee-Skills”) that connects employees and skills.
**My current setup:**
- I have three tables:
- **Skills** (list of all skills)
- **Employees**
- **Employee-Skills** (linking table with fields: Skill, Employee, Skill Level)
- In the **Application Builder** , I created a repeating element (“Repeat”) that shows all skills.
- For each skill, there is an input field (dropdown) to select the skill level.
**My challenge:**
I want to achieve that:
- The skill level field in the repeat is linked to the linking table.
- When changing or entering a skill level for a skill (and a selected employee),
**either a new entry is created** or
**an existing entry is updated** in the linking table.
- The repeat should also display whether a skill level already exists for the current skill/employee combination.
**What I have done so far:**
- The Application Builder is enabled and usable.
- The Advanced license is applied and the container has been restarted.
- I can create pages, repeats, and input fields.
- However, **events/actions for dropdown change are greyed out and not selectable** in the Application Builder.
**My questions:**
1. How can I link the skill level field in the repeat so that on change, an entry in the linking table is created or updated?
2. How can I display in the repeat whether a value already exists for the current skill/employee combination?
I appreciate any tips, example workflows, or hints - thank you!
Best regards,
Robert
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [May 15, 2025, 11:15am UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/2 "2025-05-15T11:15:10Z")
@frederikdc we would need your help here 🙏
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [May 15, 2025, 2:28pm UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/3 "2025-05-15T14:28:09Z")
Hi, looks like a nice project.
There are no events to update / insert records on a field change. So, you will need to make it two separate actions
1. An action that inserts or removes a skill for an employee. Assume that you show all the employees in a repeat element, you can have a form inside with a record selector that allows to select one or more skills. But you will need to use a button to confirm.
2.Maybe you can have a repeat inside the employees repeat to show all the skills. The inner repeat element will also need to have a form with an input element to set the skill level.
---
### Author:  [@rreichl90](https://community.baserow.io/u/rreichl90)
#### Post date: [May 16, 2025, 7:44am UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/4 "2025-05-16T07:44:48Z")
hello, at the moment I have a form which shows with repeat all skills.
I have a labels the information from the skill table. The page is only logged in available (the employees should be maintain this for himself)
I have also a select for skills (not connected to anything yet.
I think I need in each repeat form a button. And then I need anyhow to catch the attributed of the related skill + employ id + select skill rate and create a new entrance right?
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [May 19, 2025, 7:44am UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/5 "2025-05-19T07:44:22Z")
I created a small prototype:
Table `Skills` with just a name
Table `Employees` with just a name
Table `Employee_Skills` that links both and creates Link to table fields in both `Skills` and `Employees`
I’ve added a lookup field `Assigned employees` in the `Skills` table to get more information about the Employee (required in the app builder)
I created a page with 2 data source
`* Skill for employee`: Get all records from the Employee\_Skills table where the Employe is the current user.
- `Skills not assigned`: I get all the skills from the Skills table that are not assigned to the employee (that’s why I needed that username in the lookup field)
On the page I have a Repeat element for the `Skill for employee` data source. This element contains a button with a delete action on the Employee\_Skills table and refreshes both data sources.
There is also a form that updates the level of the skill
Below the repeat element, I use a table element for the `Skills not assigned` data source. The table has a button element to assign the skill with a default value of 1.
---
### Author:  [@rreichl90](https://community.baserow.io/u/rreichl90)
#### Post date: [June 24, 2025, 5:55am UTC](https://community.baserow.io/t/help-needed-skill-matrix-with-application-builder-linking-skill-level-to-employee-skill-table-self-hosted-advanced-plan/10212/6 "2025-06-24T05:55:18Z")
thanks you a lot. I was in vacation for three weeks. I will look into it this days. If I have question I will reach out you 🙂