I am wondering if it's possible to automatically populate a field based on the previous field's data?  We are looking at creating a Library Check-in/out system for the students that come in and out of the library at our school.  So for example, we would scan the student's id card and the id numbers would go into the Student ID field.  Then we would like the student's name to then appear in the Student's Name field - the name would be based on what the id is.  I'm assuming we would have to import a list or create a list in Zoho Creator that has the ID's associate with the student's name.

If anyone know's if this is possible or how to accomplish this, any help would be greatly appreciated.

Thanks!