Hello!
I am trying to include a Teacher email field in a table when I import and update records in a table. My Teacher users table has both teach names and email. I need to be able to import my file so one field has the teacher name (so that the teachers can only see the students they are assigned to) and another field pulls the email from the teacher table. How can I do this?
Hi @Dan3,
I’ve read and re-read your post to try and visualise what you are trying to achieve. It sounds like you already have the teachers’ email addresses and names in your accounts object, and you’re then importing records into another table that connects the teacher record to the accounts object, so they only see records related to their login.
If you need to display their email, you could add a text formula to look up the email from the related account, then use an email field and set a conditional value referencing the text formula to convert it to an email address that you can use in a Knack email field.
Obviously, I’m only guessing, so I may not have your requirements correct in my mind. If you could expand on your question or provide a short Loom video, it would help clarify things.
You are spot on Carl, THANK YOU!
Did exactly what you said and with my imports the functioning email address now populates my teacher email field! I am my lab facilitators thank you! 
Wow… 
- that was a lucky guess! I’m really pleased that I understood your query and was able to provide a suitable and timely response.