Bring field "forward" to related table
I have a Department table. Department and director email are two fields in this table.
In another app, Customer Satisfaction Survey, outsiders will use a form and pick a department. I want, on s...
Forum Discussion
Hello Tony,
if you don't want to expose the email on the form, and want to show it to user after submission.
Have you considered sending a notification email to user after the form is submitted, and on this notification include the selected department's email (you might have to ask user to provide their email address, assuming you are using an EOTI form).
------------------------------
Alberto Tablada
Lead Software Engineer
BlueWell Group
Florencia
+50688083124
------------------------------
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
------------------------------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
------------------------------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
------------------------------
