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
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
------------------------------