This is a little app I am working on to collect some research from my students.
I wanted to have an app where I could get the students to fill in some information, but NOT have to log in to do it.
*** This is really only for students you can keep a secret. Each student will have an access code they will need to memorize and keep track of. ***
Each student is assigned a STATE of the USA.
Each student will have to collect TEN facts about their assigned state and enter it into the APP.
Each state is given an Access Code. The student researching that state will be given the ACCESS Code for that state.
On the APP, there is a place to put in their access code. This goes into a USER SPECIFIC column. So it will be different for each device, as the code is entered.
The sheet will then do some ‘calculations’
There is a column that will copy this number DOWN using a Single Value Column
There is a MATH column that will subtract the entered value from the Access Code.
There is a If/Then column that returns the word EDIT if the MATH column is ZERO
Once the correct Access Code is entered, their specific state will “Rise to the Top” and will be editable.
Then ONLY THAT state on THAT device with THAT Access Code can be EDITED.
Go ahead and give it a try!
Some of the Temporary Account codes can be seen in the screenshot above. (and are pretty easy to guess!)
Disclaimer: I am sure that there may be a different/easier way to get the if/then to work, but this worked for me! I am open to “Why didn’t you try this!” and “There is another way!” comments.