Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Get User from a text field

I am trying to make a form a little more user friendly and eliminate unnecessary data entry.  The field I am trying to automate now is an email address that will be used for notifications.  Is there a way to dynamically populate an email address from a text field that has the users first and last names.  The source data is not generated in Quick Base. 

The current form structure has a User field that allows the user to select a user from the app's users.  Another field uses the UserToEmail function to get the email address for the notification.  I would like to eliminate this step if possible.  The desired source field is not a Quick Base user at any point.  I'm not sure if this is important; but, the field is a lookup field from a parent table. I haven't found a function that would match a user with a text field.  

Is this possible?



------------------------------
Paul Peterson
------------------------------
  • You can create a table of names where the key field is the name.  The use a formula field equal to the name in your detail record to make a relationship back to the the names table to pull in an email address.

    I'm assuming in this case that the names are entered free form or imported from another system.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      I may look into a table after launch.  There are two fields in this form that would benefit from a separate table at the moment.  Think I'll put this on the back burner for now.  We're getting pressure to launch quickly and this is more of a nice to have than necessity.

      ------------------------------
      Paul Peterson
      ------------------------------