User profile fields: Dropdown dynamic menu

Maintained by Picture of Antonello MoroAntonello Moro
Dynamic menu user profile field for moodle Now users can create user menu fields whose values are retrieved from the moodle DB.
54 sites
12 fans
Current versions available: 2
Dynamic menu user profile field for moodle. Now users can create user menu fields whose values are retrieved from the moodle DB. Basically, the user can set a sql query as value definition of the field. Please note that the query *must* return two fields: id and data. Please note that this is an advanced plugin, mainly intended for developers and very advanced moodle users. You must know moodle DB and sql language to use this plugin properly.


Screenshot #0
Screenshot #1


Picture of Antonello Moro
Antonello Moro (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Antonello Moro
    Fri, Apr 29, 2016, 6:29 PM
    Hi Dan,
    Thanks for your help! I'll do my best to fix everything as soon as possible!
  • Picture of Dan Marsden
    Tue, May 3, 2016, 5:56 AM
    Thanks for tidying up those issues Antonello, I still think it would be nice if you could expand your description here a little bit more to explain the different use-cases (to help encourage more people to try out your plugin) but I think the plugin code is ready for approval - we'll just wait for the Moodle HQ team to make the final decision on approval.
  • Picture of Antonello Moro
    Wed, May 4, 2016, 6:11 PM
    ok thanks Dan. In the meantime I'll think about some use-cases to expand the description
  • Picture of David Mudrák
    Mon, May 9, 2016, 5:01 PM

    Thanks Antonello for sharing the plugin with the Moodle community, and thanks Dan for the detailed peer-review. I am happy to approve the plugin now. You are cleared to land, welcome to the Plugins directory!

  • Picture of Antonello Moro
    Mon, May 9, 2016, 5:24 PM
    Thanks guys!
  • Picture of eli chan
    Fri, Oct 7, 2016, 10:28 AM
    Very useful plugin after installation and work prefectly, but new course cannot add activity due to "Error reading from database".
  • Picture of Ibrahim Fadl
    Wed, Dec 7, 2016, 7:14 PM
    I am new to moodle, how to select all moodle users email addresses to this dynamic menu
  • Picture of Saaid Agherdien
    Sat, Dec 31, 2016, 6:15 PM
    Hi eli chan, I had the same issue with the dynamic multi select profile field. That is, it worked fine until I deleted a user that used the multi select to update his profile. After this I could not add activities to courses as I would get "error reading from database". I think that when I deleted the user, it did not clean up the database. To solve the problem I deleted the multi select field I created. I can now add activities to any course.
  • Picture of Antonello Moro
    Sun, Feb 12, 2017, 11:25 PM
    Hi folks, those issue should be fixed in the new version 1.1.0
  • Picture of Valentino Santucci
    Fri, Jul 28, 2017, 5:45 AM
    Hi, it does not work in the signup page (no option), while it is ok in the user profile page. Am I doing something wrong?
  • Picture of John Anderson
    Thu, Sep 14, 2017, 12:18 AM
    Hi, I have a question /idea about use case. I am facing a requirement to report on what sorts of learners, by license, credential, or age that completed course X. I don't have these fields in my moodle and was struggling to devise a plan to do this. I was thinking about using a feedback activity to collect this at the start of the course. Then use configurable reports to query out the data. But wondering if this might be used to store my feedback activity data into some profile fields?

    Any ideas welcome - interesting module !
  • Picture of Muneera AlNufaisi
    Sat, Jul 21, 2018, 4:08 AM
    is better if I can write full query that get form database rather than currnt way
  • Picture of David Collins
    Thu, Aug 23, 2018, 10:36 PM
    I am having the same issue as Valentino. Looking over your code, in the constructor for the field, you have a parameter for userID, which is null/empty from the sign-up page, so it never hits the code path to populate the dropdown.
  • foto_frank
    Wed, Jan 2, 2019, 3:37 AM
    Hi, thanks for sharing. How do I uninstall it?
  • Picture of Federico Bini
    Mon, Mar 9, 2020, 6:59 PM
    Hi Antonello! Your plugin is very useful and would do exactly what I need .. unfortunately it only does for "user" custom fields, it would be possible to have a version also for the custom fields that are used under the course or better yet to be used in multiple contexts (in so that they can also be used for the individual activities of a course)?
1 2
Please login to post comments