Database experts of Moodle, perhaps you can help?
I am trying to use Moodle to collect student applications and the Database activity seems to be most suitable for the purpose but there are a few functions that are not immediately obvious how to achieve. Can anyone advise if the following behaviors are possible, and if so how?
- Students will need to be able to review their entry and amend it any time up to the closing date.
- Some fields need to be populated from the user profile
- The student should only see the add entry tab within the activity
- Tutors will need to be able to add data to the students submission which will be included in the eventual export.
The application form will be running on a separate site so messing with the core code is a possibility if needed.
I have added a tutor comments section in the Add Template and hidden this using CSS, can this be revealed depending on a users role?
This site seems to suggest that I could pull values from one database into another but I'm not having much luck with that approach.
Any advice gratefully received.