Qrew Legendnp, just make a formula email field where the formula is simply
[insert your current drop down text field here]
I think I must be missing a step. I try to input just [Field Name] and that is where I receive the error saying: 'The Field' is neither a User field nor an Email address field. These are the only field types accepted for this type of Notification.
Am I supposed to be inputting this into a different area other than the Notify whom section of the notification?
Qrew LegendOK, let me explain in more detail.
When you provide something in the Notify Who box the field has to be either of type email or a user field. It sounds like you are providing a text field type which although it may appear to contain an email address is just text as far as Quickbase is concerned.
What I am suggesting is to create a new field of type formula email and the formula will simply be
[my drop down field]
That will convert
[my drop down field]
to an email field type and your new formula email field should be offered to you in the notification as the choices of a field to send to.
Thank you, that's the extra explanation I needed! It now works. Thank you very much for your help!
