User Field DB

This plugin allows Moodle administrators to create user profile fields filled with data from a database table. By using this plugin, administrators can create data tables that students can select from and automatically generate reports in Kopere BI.
This plugin allows Moodle administrators to create user profile fields filled with data from a database table. By using this plugin, administrators can create data tables that students can select from and automatically generate reports in Kopere BI.
Features
Create user profile fields linked to database tables.
Define categories of data stored in the database.
Allow users to select predefined data when editing their profile.
Facilitate data consistency and minimize entry errors by using database-based options.
Setup
Go to  Site Administration > Users > User profile fields .
Create a new profile field of type “User Field DB”.
Configure the field by specifying:
Database table from which data will be extracted.
Key and value columns to display options.
Additional conditions to filter the data (optional).
Save the field and check if it appears in the user profile form.
Usage
Users will see a dropdown list when editing their profile and will see the data previously set by the administrator.
Administrators can update the data in the database table to dynamically modify the available options.
Requirements
Moodle 4.1 or higher.