Skip to main content
Question

Fields - Multiple choice for emails

  • September 13, 2022
  • 0 replies
  • 38 views
Hello - 
I'm creating a form and two of the fields in the form is manager name and manager email.  From there, I'd like to create an automated email that sends to the manager's email when a new form is submitted.  From what I understand, the field format would have to be "email" in order to send an automated email.  Is there a way to create a multiple choice drop down for email addresses instead of text?  I'm trying to avoid mistakes by having people type in email addresses.  

I'm also trying to not link to a table since our company has thousands of managers and we don't want to have to maintain that data.  It would be best if we could have a handful of selected managers to choose from, with the ability for the person entering it to add a new manager as they need (like the multiple choice text field allows).

Thank you

------------------------------
Valerie Wong
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    I suggest making a table of Managers where the Key field is the email address and another field for their name.  Then make a relationship where One Manager has many "Form records".

    You can populate the Managers table with a few good choices and allow,  through permissions,  your users to add Managers or flag Managers as being inactive in the Managers table. The advantages of having a table versus a down and dirty multiple-choice field is that if mistakes get entered into a multiple choice field or a manager is no longer valid to be chosen there's no way for these regular empowered users to correct that error. Whereas if you have trusted users  they can keep that table tidy and relevant at all times. 

    Because you don't ever want to really delete manager records I suggest having a checkbox to indicate whether the manager record is active. Then on the form where the manager is being selected through the relationship you were used to report for this filter to include active managers only.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement