We are using AppSheet to help students register for our classes. Students are required to take a short assessment using Google Forms before class starts. My goal is to have students’ responses to this assessment automatically appear as related records in our STUDENTS1 table.
I thought I had made this work. In the ESL Locator 2.1 table, I have a Ref column titled Virtual Email with this formula: ANY(SELECT(STUDENTS1[@lfccadulted.com email], ([Personal Email] = [_THISROW].[Personal Email])))
The students @lfccadulted.com email is the key for the STUDENTS1 table. And when I enter this formula, a new column for Related ESL Locator 2.1’s is created in the STUDENTS1 table with this formula: REF_ROWS(“ESL Locator2.1”, “Virtual Email”)
For about half of our students, this seems to work fine. The related records are appearing as they should. However, for half of the students, it shows they have no related records, even though I can open the ESL Locator 2.1 spreadsheet and see their entries. I thought maybe the personal emails didn’t match in both tables, but I’ve checked them, and they do match.
I’ve also tried to test by creating 2 fake students just now. For one of them, everything is working fine. For the other, there are no related records. I can’t identify any difference between students for whom the related records are appearing, and those for whom the related records aren’t. I’m pretty stumped, and would very much appreciate any assistance or advice you could provide.