Need help with reading selected columns from google sheet based on SSO

I am really unsure of how to show the data based on the logged-in user. The problem that I am trying to solve pertains to the following logic'

  1. There is a repository(Datasource) of the teachers (manager in my case ) These teachers then report to a Head of Department that in turn report to the principal.
  2. The teacher should be able to rate the students based on random questions(there is a separate list for that), and this teacher should be able to see only the students assigned to her not the other students of different classes.
  3. Similarly, an HoD should be able to teachers from her/his department, not the other teachers and rate them.
  4. Google SSO implementation.

Any help is appreciated well in advance I have started coding a few months back, need to develop this project form my confidence.

How do intend for this part to work for you ?

I wish to collect the address and use it as a primary key to further show the options that I speak of . it all hangs on the SSO

OK, assuming that we are talking about Google accounts (?) do the users need to authenticate with their google accounts for any other reason than providing their email address for you to use as an identifier and primary key in your data?

Yes, so the company has their workspace account and anyone else outside the application should not sign up for the same

I believe that using App Inventor to work within the closed environment of Google Workspace, in the way you intend, is not possible. You could possibly create a web app that can handle the authentication and authorisation...

To use AppInventor, you can use access permissions on Google to control who can access the spreadsheet (you could set this up in advance, with all the google accounts of all the teachers), you will also need admin rights to be able to make the spreadsheet available "outside" of your google workspace, in order for App Inventor to access the data, knowing that only those with access can access it. You can then have some internal controls in your App Inventor app (perhaps using the same list of accounts) to control who can actually use the app.

I have done this before when I had google workspace (or google suite...) in my last organisation. We were also a school, handling private and sensitive personal data, and it passed all our stringent security, privacy and GDPR tests in the UK.

How do I go about the Conditional select options , I have developed a login and registration method to by google in a way but that is devoid of captcha,

The data of client is in CSV , I have to read and append the rating in a different sheet any way to take up the conditional values based on login ?
via app inventor

I do not understand what you mean by this. Perhaps show some sample data / blocks ?


Check this sheet out ,
the Question would be random if no random in the said format and we pick up the relations of the employee and manager from sheet one present them, managers, to rate the employees associated with them only and then rate them in Sheet 3

You need to learn to use conditional statements; here is some help Programming Your App to Make Decisions. You can probably provide the logic using Blocks You can figure this out with a pencil and paper probably.

If employee then .... else if manager then rate employee and use Sheet3

Can have the Book or the Source from where this chapter is taken ?


Here are some resources to help you learn to use the AI2 tools. A very good way to learn App Inventor is to read the free Inventor's Manual here in the AI2 free online eBook ... the links are at the bottom of the Web page. The book 'teaches' users how to program with AI2 blocks.

There is a free programming course here and the aia files for the projects in the book are here:

How to do a lot of basic things with App Inventor are described here: .

Also look here and here for more tutorials.

Learn about components
and visit the Library Help>Library on the MENU