Forum Discussion
Yes, that all makes great sense. I have already done that. Just assuming I have done it incorrectly.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
In your relationship screenshot, click the "Add Lookup Fields" button in the bottom-right. Then, add the Department's "Name" field (assuming that's what you are tracking in the Department's table and how a Surveyed User would intuitively select a Department). Then, once the Department - Name field is available on the Survey's table, I'd update your Related Department proxy to use the Department - Name. Next, include the Department - Name on your form, so when User's are completing the Survey, their actually selecting the Related Department's ID by visually selecting the Name (the proxy) when completing the Survey. Then, once the Survey record is saved, trigger your email to the Department's Director.
Note, it looks like in one of your latest screenshots, you have a Department (Text - Multiple Choice) field in your Surveys schema. Is that necessary and is that what is creating the confusion? It's seems like that field should be removed?
------------------------------
Brian Seymour
------------------------------