Using Text-Multiple Choice to Send Notifications to Non-users

Question

Hello,
Is it possible or does anyone know of a way to create a dropdown of email address, where when a non-users fills out the form, a notification will be sent to the email they selected from the dropdown?
This would be used as a type of automatic confirmation email for specific non-users when they fill out a form. I am worried about errors when typing out email addresses, so would like them to choose from a dropdown or list.
For the notification, I am putting the permission type as Open and then the Text-Multiple Choice field into Notify whom but I receive an error saying that: 'The Field' is neither a User field nor an Email address field. These are the only field types accepted for this type of Notification.Does anyone know a way to accomplish this?
------------------------------Cassandra Friend------------------------------

markshnier__you · Answer

np, just make a formula email field where the formula is simply
[insert your current drop down text field here]

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

cassandrafriend · Answer

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.&nbsp;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?------------------------------Cassandra Friend------------------------------

markshnier__you · Answer

&nbsp;OK, 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&nbsp;
[my drop down field]

That will convert&nbsp;
[my drop down field]&nbsp;
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.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

cassandrafriend · Answer

Thank you, that's the extra explanation I needed! It now works. Thank you very much for your help!------------------------------Cassandra Friend------------------------------

Forum Discussion

Using Text-Multiple Choice to Send Notifications to Non-users