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 ...
Relationships
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
    5 years ago
    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
    ------------------------------