Custom Select that list filtered users by their roles

Hi, I have 2 collections:

User (default)
Contracts: title, description, customer, employee
The customer and employee are relation fields pointing to the User collection.
In the settings, I created 2 roles: customer and employee.

I aim to create a custom select field that takes an attribute (say called customer) and filters all users with the role of customer.

How would I do that? I tried other ways that work, but I believe they are bad practices. One of those “bad practices” would be just to add 2 collections (customer and employee) and relate them to the user collection, this will duplicate the data and would not give me the result I am looking for in the long term after expansion.

I believe my way is to code a custom component. If you guys see it solveable in a different way please let me know. I am new to strapi and would not prefer to mess with code.

This topic has been created from a Discord post (1291622133469941882) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

You could try this plugin