I need 4 checkboxes on one row for a Google Sheet. They represent (3) school exams refused. The last box is when all of them are refused.
2 months ago, I knew nothing about VBA and since then I have made a series of macros with 6 year old like coding. They are not pretty but they work. Now I am beginning at square one with Apps Script or whatever coding you suggest/recommend I use. I'm sure the coding between the two (VBA and Apps Script) look similar to you but they look totally different to me.
I do not have any code or experience for this. I searched around and found something (on this site) that is really close to what I am looking for.
Here is the example that I found:
all checkboxes need to be checked and unchecked with the main checkbox
This is for a Google Sheet. I have 3 exams that my students have to take - English, Math and Science but have a tendency to refuse to take them. They may refuse all of them, some or none. I need 4 checkboxes - one for each individual exam they refuse and one if they refuse all of them. If you check all of the individual boxes (done over a period of time), the "Entire Exam" box is checked and the individual boxes become unchecked. If you directly check the "Entire Exam" box first, any checks that may be on the individual boxes become unchecked.
The checkboxes will be on the same row but individual cells. English will be F2, Math will be G2, Science will be H2 and Entire Exam will be I2.
The reason I can't have all the individual exams boxes and the Entire Exam box checked at one time is because I need to distinguish between partial exams and entire exams not taken. I will need to count the number of individual exams that were refused as "Partial exams" as well as entire exams.
Another thing I want to do is reduce the number of clicks so a suggestion that may come up to just have 3 boxes for the individual exams and if they are all checked, that would mean the entire exam had been refused, that's 2 extra clicks of the mouse. This sheet will most likely be used during a sudden flood of refusals just an hour before the exams begin so just checking the "Entire Exam" box if the case may be, would be simpler/faster than checking all 3 individual boxes.
How does this work? Do you assign the code to the checkbox itself?
I would appreciate any feedback and help. And if you have any sites that you can refer me to start my learning in this, please share. Thank you. Jim
Aucun commentaire:
Enregistrer un commentaire