Column Reference Question

I am building an attendance app for different Clubs/Activities at my school. I would like the app to take in two data points from a form. 

  1. Student ID
  2. Teacher/Sponsor of Clubs email

I would like the for to only show a field to acquire ID#'s from students, and all other data is gathered from referenced tables. 

I can achieve most of this, but I am not sure how to make one tweak. I would like to make the Student ID field so students can type their ID numbers. Because the ID column is a Ref, AppSheet is making it a dropdown field in my form. 

How do I allow users/students the ability to type their ID#?

thanks!

 

Screen Shot 2022-08-18 at 8.11.28 AM.pngScreen Shot 2022-08-18 at 8.11.17 AM.pngScreen Shot 2022-08-18 at 8.11.39 AM.pngAttendance log data structure.png

1 3 121
3 REPLIES 3
Top Labels in this Space