Thank you for watching! Glad you found it helpful.

Hi, okay, I will post here when it’s ready. Please give me 24 hrs. Thanks.

thank you @@SarahAshley_GH - I want to connect with you for the faculty development activities in my institution.

Hello everyone! I posted a new video showing how to build the private submissions database use case. kzbin.info/www/bejne/imLHf2OmeNOdqNUsi=hi2VebOLyFI-23SK More to follow soon, so keep your eye on my channel. 🙂

Hello, thanks for the positive feedback. There is usually a download link available. Icon looks like an arrow pointing downward?

At the top right there would be some icons to add it to your own drive or download the item.

Hello @Eve Alsdorf, Thanks for the feedback, glad it was helpful. I have not encountered a use case for subtotals as yet. Can you share a little more detail on your setup? Are your weeks represented as columns, in which case the subtotals would be at the bottom of each column? Or do you have a single field that specifies the week, in which case we need to do multiple tallies simultaneously to sum up values for each matching week? Final question - is there a set number of weeks that users pick from (5 weeks in a dropdown menu or radio buttons)? Your response will help me design the best associated approach for sub-totaling. Thanks!

Hello Suzanne Kohaya, Thanks for your question. Do you mean this post of mine? moodle.org/mod/forum/discuss.php?d=140433#p737826 I am sorry but I no longer work at that institution and do not have a copy of that database activity. But I did share my code that worked...can you follow along from my explanation there? moodle.org/mod/forum/discuss.php?d=140433#p737891 I will try to recreate that activity and will share when it is available, if that helps?

Hello! Glad you found this useful! 🙂 Not only in theory can you do this, but in actuality! Which template did you put your code in? The Search options show in the List View, so I put my code in the List Template, in the footer. Make sure to disable the editor. I entered the following after the closing table tag. <script type="text/javascript" src="ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script> $(document).ready(function(){ $('#options input.btn.btn-secondary').val("SEARCH"); }); </script> Does this work for you now?

Thanks so much @@SarahAshley_GH for taking the trouble to reply :). Sadly, I learn today that my institution has disabled JavaScript templates, claiming that allowing users to do this presents a serious security risk. I have to admit we're a large University so they cannot have oversight over a large userbase But I'm also surprised that client side scripts could be regarded as dangerous. Aren't browsers heavily sandboxed? Welcome your and Moodle views on this to take back to our IT Services.

@@phlerbert Okay, I will not try to fight any JavaScript Wars! 😂 But no worries! I believe that renaming that button to SEARCH is a reasonable change request, and this can be taken care of through the Language Strings. So it will change the name of that button across the whole site, for everybody! No JavaScript needed! Take a look at this annotated screenshot. You can send it to your site administrator for them to make the change for you. Hoping that will be permitted! drive.google.com/file/d/1AB4miR8J6dFGp_sDjPGRF7_GrDJ3OROq/view?usp=sharing Let me know if you have further questions. All the best. 🙂

@@SarahAshley_GH ha ha. I'll have a go.

Hello @metalheadmask, so sorry for missing your comment and question. Thank you. I first created the course development status tracker on a 3.9 Moodle site. I don't have access to a previous version of Moodle to try importing the preset but when I do that, I will upload to Moodle.net and let you know. If you want to give it a shot yourself, give it a shot and see if it works...and let us know how you fared! All the best.

Thank you so much! I'd love to hear how you are using the Database Activity. :-) Feel free to share!

Glad it was helpful!

Hi Paula, thanks for watching! Yes, the presets are in the description of the video. If you expand it you will see the links to presets and the slide deck. :-) Hope it helps! Let me know if you have further questions!

@@SarahAshley_GH thank you. I was actually referring to the presets from your previous video - in this one you didn't do the students community service (clinical) hours record example. I was wondering if you had a presets for that older example but for Moodle 3.9? We are looking at using Moodle to track our students clinical hours and I would appreciate help with the script that tallies the total hours as they go....

Ohh, goodness! Got it! :-) I have gone and updated that for Moodle 3.9. You can download it here: drive.google.com/file/d/1ptbBxKyV0cEeb67Y7QU2-vPAQqxExjgJ/view?usp=sharing and here are 3 sample entries you can import to get started right away with exploring it: drive.google.com/file/d/1gRYJeliGSZb40CrFW_Q8v0aySLM-PiFH/view?usp=sharing

@Paula Barnard-Ashton Happy New Year, Paula! I have uploaded a video walkthrough of the script for this community log. I hope it is helpful to you. Feel free to post any questions in the comments over there. Thank you! :-) kzbin.info/www/bejne/mIXIeWZmqpmeZ8U

Dr. Vijay Deshmukh Thank you, Dr. Deshmukh. Please confirm if you mean that you want to use the database activity to generate reports? If yes, then let me clarify that this is a tool for collecting/inputting data and displaying it in a specific, visual arrangement. You can export the data that has been input and download it as a .CSV file, which you can then import into Microsoft Excel or Google Sheets or whatever software you wish that can read a .CSV file. Just note that it is not a Reporting Tool that pulls information from your Moodle database. It can only give you what you have put in. I hope that makes sense! Feel free to follow up with more questions if you have any. Thank you. Be well.

+Benjamin Waller Thank you, Ben! Sure, happy to share! I will send you some screenshots.