I am wondering if a field can populate data automatically based on what was entered in a previous field?  We are looking at creating a Library Check-In/Out system at our school for the students that come in and out of the library.  For example, we want to scan the student's ID card which their ID number would get put into the Student ID field and then I am wanting the Student's Name field to then automatically get populated with their name.  So when I scan in their ID and jump to another field or immediately after scanning, I am looking for their Name to show up in the Student's Name field.

I'm assuming the Student ID and their Name has to be imported into Zoho Creator somehow.

I greatly appreciate any help into how this can be accomplished.

Thanks!