Yay! I got it! The problem was that I had started working on it in my personal Gmail account instead of my school account. Once I made a copy of the Daily Attendance in my work account, set up restrictions for only those within my organization, the problem of the extra column to collect emails was gone, and the original formula worked! Thanks again for this awesome video! Woohoo!
How do you know if they "popped in" while in the classroom? If the link is available online and they are remote, isn't it possible for them to "attend" without actually showing up?
Sure. That can happen. You don’t have to post online. Depending on the devices your students have, you could post a QR code for them to scan in the classroom or you can turn off/on the accepting responses dial.
I also tried this formula to compensate for the fact that my original data has the students' names in column "C". =QUERY(FormResponses,"select C, D, A where A > date '"&TEXT(TODAY(),"yyyy-mm-dd")&"'order by C ASC",1). I added back some of the spaces to this one as well. Still doesn't work. Please help!
I would add a question into the Google Form for students to select their class period. Then, add an extra parameter in my formula to include separating by class period column in the Google Sheet. I would also make tabbed sheets at the bottom for each class period and place the correct formula in each of those. It would all still operate off of one Form and one Response sheet.
I love this idea and have been working on it for several hours but, like Jamie, cannot seem to get the formula right. I'm using this one: =QUERY(FormResponses,"select B,C,A where A>date'"&TEXT(TODAY(),"yyyy-mm-dd")&"'order by B ASC",1). I also think I have my spacing wrong, but there is also another issue. My Google Form collects the students' email addresses, so my "B" column in my "FormResponses" is their emails, and the "C" is their names. Is that what could be causing the error that keeps coming out? I've tried switching out the "C" for the "B", but I keep getting the same message (Error: Array result was not expanded because it would overwrite data in B1.") Any help you can give me would be GREATLY appreciated. Thanks!
I can't get the query right, keeps giving me errors....=QUERY (Period1, "select B, C, A where A > '"&TEXT(TODAY(), "yyyy-mm-dd")&"'orderby B ASC", 1)? Im sure its about spacing
Things to try: 1) remove the space between QUERY and parenthesis 2) Is period1 the correct name of the data range or sheet you are pulling your data from? 3) looks like you might be missing an apostrophe in two places (a) before the "&TEXT (b) after the quotes dd")&" Let me know if this works or not.
Yay! I got it! The problem was that I had started working on it in my personal Gmail account instead of my school account. Once I made a copy of the Daily Attendance in my work account, set up restrictions for only those within my organization, the problem of the extra column to collect emails was gone, and the original formula worked! Thanks again for this awesome video! Woohoo!
can i use the same form for multiple periods? how does that work by linking the same form to the spreadsheet for multiple periods?
How do you know if they "popped in" while in the classroom? If the link is available online and they are remote, isn't it possible for them to "attend" without actually showing up?
Sure. That can happen. You don’t have to post online. Depending on the devices your students have, you could post a QR code for them to scan in the classroom or you can turn off/on the accepting responses dial.
I also tried this formula to compensate for the fact that my original data has the students' names in column "C". =QUERY(FormResponses,"select C, D, A where A > date '"&TEXT(TODAY(),"yyyy-mm-dd")&"'order by C ASC",1). I added back some of the spaces to this one as well. Still doesn't work. Please help!
How would I do this if I had multiple periods
I would add a question into the Google Form for students to select their class period. Then, add an extra parameter in my formula to include separating by class period column in the Google Sheet. I would also make tabbed sheets at the bottom for each class period and place the correct formula in each of those. It would all still operate off of one Form and one Response sheet.
I love this idea and have been working on it for several hours but, like Jamie, cannot seem to get the formula right. I'm using this one: =QUERY(FormResponses,"select B,C,A where A>date'"&TEXT(TODAY(),"yyyy-mm-dd")&"'order by B ASC",1). I also think I have my spacing wrong, but there is also another issue. My Google Form collects the students' email addresses, so my "B" column in my "FormResponses" is their emails, and the "C" is their names. Is that what could be causing the error that keeps coming out? I've tried switching out the "C" for the "B", but I keep getting the same message (Error: Array result was not expanded because it would overwrite data in B1.") Any help you can give me would be GREATLY appreciated. Thanks!
i think why setting up your form you can set it not to take their mail
I can't get the query right, keeps giving me errors....=QUERY (Period1, "select B, C, A where A > '"&TEXT(TODAY(), "yyyy-mm-dd")&"'orderby B ASC", 1)? Im sure its about spacing
Things to try:
1) remove the space between QUERY and parenthesis
2) Is period1 the correct name of the data range or sheet you are pulling your data from?
3) looks like you might be missing an apostrophe in two places
(a) before the "&TEXT
(b) after the quotes dd")&"
Let me know if this works or not.