I have a script that inserts data from an email into a table (it's a help desk ticketing system). Since the email would come from an existing person in our organization, the User is already in the app. There is a "Created By" field that is a lookup field on the User table. If I try to insert the user's name (the "From" field has been parsed down to produce the user's First/Last name) into the "Created By" field via the API, nothing happens. I don't know if that's because (a) it's a dropdown field, or (b) if the value I'm trying to insert doesn't exactly match a user.
In any event, it would be handy to be able to insert this data. If I had to insert it into a different field, and then do a lookup on the value, and change the "Created By" field to match that value, how would I go about doing that?