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
Here is the form and a new entry I just submitted. The next screen shot is the All records table afterwards.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
In your screenshot with the question "Which Department or Division did you contact?" where you've selected "Airport" (in the top-right), what field is that on your form? I don't have much experience with the newer form builder (which you are using), but if you right-click on that field is that the Related Department field or the proxy you've set?
Then, in your report screenshot, can you temporarily add Related Department to make sure that value (ID) is set as expected?
Otherwise, are you sure that you've stored a Director's Email for the "Airport" Department?
------------------------------
Brian Seymour
------------------------------
Thanks everyone. I had several issues, as pointed out by a couple of you. It is now working as needed. Whew, what a learning curve. I appreciate the community here and the consistently good help you all provide.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------Nice Tony! Glad it's now sorted out and you've learned more about QB along the way :)
------------------------------
Brian Seymour
------------------------------