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
Hey Tony,
I don't totally understand your intent as it your initial question and latest response seem to have opposing goals of displaying the Director's email once submitted or not at all (both are possible).
Here are couple things to consider:
- Notification data is separate from displaying form data, so you'll have access to fields that are not necessarily shown on a given form.
- You may have cross-app relationships so it may be useful to relate Surveys to Departments
- But, I try to avoid these cross-app relationships when possible (consider a Pipelines search to locate the Director's email instead once the new Survey record is created?) But, it depends on your use case.
- Form fields may be set to display on add, edit or view. So you could have the director email shown on "view" (after the record is saved), but not on "add" (when submitting the form)
If you've created the Surveys table where users/visitors are able to create records, then it seems like you would be able to trigger a email notification when a new record Survey record is created and the Director's email field is not empty (based off the selected Department)?
Hopefully that helps!
------------------------------
Brian Seymour
------------------------------