Forum Discussion
I don't actually want to ever show it to the user. I just want to be able to notify the director when they get a new survey. I assumed the easiest way to do this is to list the director, based on the other table, on the table so I can use that field to send an email notification.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
If you're making a relationship to 'Departments' then you just need the email to be a lookup field. You don't have to put it on the form or ever expose it to the user. When you set the department on the submission then the email would be populated and you can use it in an email notification. Fields don't have to be on the form or viewable by the user to have data - you can remove it through security if you're really concerned about it. The user would pick the department on the form via the 'Related Department' field and then then notification would just interpret the email that comes through via that relationship.
------------------------------
Chayce Duncan
------------------------------
- TonyGonzalez9 months agoQrew Trainee
Thanks, Chayce. That is exactly the way I was thinking it would work, I just can't get it to do so. I have it working to the point where I can go into a record and choose the appropriate email address, but that isn't feasible long-term. I was thinking it SHOULD populate based on the department name chosen, it just isn't doing it.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- ChayceDuncan9 months agoQrew Captain
Tony - I'm looking at other posts from below and your relationship shows that your 'Related Department' is an email field. Is the key field for your departments the email of the director in question? Is that how it's sourcing from your other application?
------------------------------
Chayce Duncan
------------------------------- TonyGonzalez9 months agoQrew Trainee
I made the proxy for "Related Department" the "Director Email" field. I can get it to show up, but only if I edit a record and choose it.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------