I know how to create a database input with lookups using excel VBA and with google scripting but I have no idea how to do it using MYSQL database or the database module in moodle.
Here is an example of what I want to accomplish and I want to do it INSIDE moodle and not by a URL link to something outside moodle as I want the user to experience this happening inside moodle without leaving the site.\
A user types in a number say they get a 25 in red at the beg of year that would be 97 on the lookup. Then they get a 30 in blue in the middle of the year which would be a an 88 and they end the year with 33 in green which is an 83. Then maybe it looks up a different table depending on the year in school.
Does anyone know how I can do this in Moodle. I can easily do it in excel but that's not the platform I want.
Thanks,
Jamie