data from a lookup field displaying incorrectly in email notification
I have a form (let's call it Form A) in which, among other things, a user selects a site name from a drop-down list. This list is generated using a look-up field to pull in the site names from another form (Form B). I also have an email that is sent when a user updates another field on Form A, and among other things, I want to pass the site name in the email. However, instead of showing the actual text of the site name, what gets passed is a string of numbers. I'm guessing this is some sort of key used in the background for the look-up or something, but it's completely useless to send this in an email. Is there any way to fix this so that the actual text of the site name gets passed in the email?