IMPORTANT : Read the description carefully before start doing ഓൺലൈൻ ക്ലാസ്സിൽ അറ്റന്റൻസ് എടുക്കാൻ ബുദ്ധിമുട്ടുന്നുണ്ടോ ? ഇതാ ഈസി ആയി ഗൂഗിൾ ഫോംസ് ഉപയോഗിച്ച് ഓട്ടോമാറ്റിക് ആയി അറ്റന്റൻസ് ജനറേറ്റ് ചെയ്യാം Automatic attendance statement generator using google forms This video explains an easy method of taking an automated attendance sheet from google form at online class easy step by step process IMPORTANT UPDATE : 1. Do enable "collect email address" option from the google form setting after manually inserting an entry in google form then use the below equation Equation 1 : =QUERY('Form responses 1'!A:E,"select todate(A),B,C,D,E where todate(A)=B ") Equation 2 : =ArrayFormula(if(len(C1:C),len(C1:C)-len(SUBSTITUTE(C1:C,",",""))+1,)) Equation 3 : =sumifs(Sheet2!$F$2:F,Sheet2!$D$2:D,A2) Equation 4 : =(C2/B2)*100 Optional Equation 5 : =unique(QUERY(Sheet2!A:F,"select B,C,F order by C")) Equation 6 : =sum(C2:C) If the above equation doesn't work after including email ID then follow the below equations Equation 1 : =QUERY('Form responses 1'!A:F,"select todate(A),B,C,D,E where todate(A)=C ") Equation 2 : =ArrayFormula(if(len(C1:C),len(C1:C)-len(SUBSTITUTE(C1:C,",",""))+1,)) Equation 3 : =sumifs(Sheet2!$F$2:F,Sheet2!$E$2:E,A2) Equation 4 : =(C2/B2)*100 Optional Equation 5 : =unique(QUERY(Sheet2!A:F,"select C,D,F order by D")) Equation 6 : =sum(C2:C) ** Do use Date --) Remove duplicate option before taking final attendance Do comment if you face any issue, i will be happy to help.. Credit Music : Alan Walker - Force, Royalty Free - Bomber [Sting] #attendancegenerator #onlineattendance
