How to prevent duplicate selections in a sub-table (NocoBase)?

English Forum
1

Good morning everyone,

I have a scenario that I’m not sure how to implement. It seems simple, but I couldn’t find a way to support it within NocoBase.

I’m building a recruitment and selection system where job vacancies are created.

On the vacancy page, we define the technical, behavioral, educational, and language requirements that candidates must meet.

In this form, I have a sub-table where the user can select from existing records (for example, the required language or technical skill).

My requirement is that once an option has already been added to the sub-table, it should no longer be available in the selection list, to avoid duplicates.

For example, if I’ve already selected English – Advanced, then English should no longer be available in the dropdown to prevent it from being selected again.

Is there any way to implement this scenario?

Thank you, and have a great week!

2

Hi, you can achieve this by using a one-to-one relationship together with the data picker component. This way, once a record is already linked, it won’t appear again in the selection list, which avoids duplicates.

3

Sorry, I don’t get you.

How can I do that ? And remember that I need to have several languages add