I made a database and app to allow teachers to track behaviors of students at our school. I planned to have students use the app to set goals and track their behavior, but appsheet doesn’t allow the student accounts to access the app. I then decided to set an automation to send each student their own data.
Anytime I test with one student, it works fine, but when I run the bot for all 700, only 50-100 come through. I checked our Google Workspace Admin console, and it doesn’t show any rejected. appsheet.com is whitelisted on our spam filter. Appsheet audit log says everything was sent, Workspace says nothing was bounced, but the emails aren’t arriving.
Any ideas on how I could get these students able to access their behavior data from the database to be able to track their progress?
I could really use a hand here. I know I’m not wearing a suit in my picture, but using this platform in educational settings seems like a worthwhile application of the product, and a great opportunity for students using Google to get introduced to the power of appsheet and computer science in general. Any recommendations? Resources to point to? Anything? Please and thank you!
Argh. I can try chunking them. Sending out a batch every hour over night maybe. It seems like SOMETHING is flagging them as spam, but I’m just surprised I don’t see it rejected on our end in Workspace ELS.
Is there a way I could generate a pdf report only accessible by that individual student? I can use expressions to have the report generated in a unique path, but it would have to be generated in their drive so only they have access to their report. They are all internal drives in our organizational unit. I searched the forum for something like this, but no luck. Does anyone know a way to do this, or another workaround?
Key points:
Students can’t login with their to the app with their edu accounts because of Google’s rule.
All student accounts are in our organization.
Each student has data in the table they need to be able to review at least once a week.
What you want to do is not straight out of the box in appsheet. Nevertheless, it could be possible. Is there a way to look at the project in total together? Let look into the
Yeah, it looks like I can use Apps Scripts to to control more on the Drive side to make reports only the student can access.
Vision: Teachers can easily track behaviors and award points for positive behaviors, students and parents can check their performance and set goals. Admin can easily pull student behavior data for decisions.
Mission: Make a database app so teachers can award points for positive behavior and document behavioral issues. Create admin and student views.
Current: Appsheet database with multiple tables and relationships. Everything is working great except students seeing their data. Students can’t login to the app, so I setup a bot to get the necessary data emailed to them, but only 50-100 of the 700 are going through. Appsheet says they went, and our organizations email filter did not block them. It’s all internal to our Google Workspace.
Scope: My school, 700+ kids and 40+ Teachers/admin
Timeline: It’s already deployed and operational. Everything is great except the emailed reports.
I see. You have really gone far. Weldone.
Try this workaround.
Build a public app that has access to the table containing the data of interest (from appsheet) which I believe the student could download (or access). from this, I believe, they could access their data realtime instead of waiting for an email that may not deliver.
Just wanted to post the solution for anyone else in the same boat. Breaking out the emails to the students in chunks every couple hours over the weekend worked. They were able to get their data that way. Not as good as them being able to login. Maybe one day Google will make a version students can access? I’d love to use it to teach them how to make their own apps too!
