I would like to use our students’ school Gmail as the key in a Students table. By using this email as the key, we can send students Google Forms that automatically grab that email, and use it to link the Form data to the student’s record, which is great!
The problem is that when a student first expresses interest in our classes, they don’t have a school email. Ideally, I would want students to fill out a brief Form that asks for basic personal information, and creates a record with a blank key that I, or another user, can enter later.
Is there a way to do this? Or some work around that might let us accomplish the same thing?
So far, the best idea I have is to have the interest Form populate a Google Sheet, and then manually type the school Gmail into the Key column in the Google Sheet. In my prototype app, this seems to work. When I type in the Gmail/Key, the student then appears in Appsheet. However, I worry if this might have unintended consequences down the line. Also, in a perfect world, I want other users to be able to add the Gmail to a student’s record without having the ability to mess with the Sheet.