Forum Discussion
I saw that as an option but I would like some way to have it show you this list before you hit "save". Is there potentially some formula I could use for a multi-line text field that would populate each entry in a drop down list? I can get the correct names from the department tracker table to populate this drop down list, but I would like it to be in the form of a text if possible.
OK, well assuming that you have a table of departments then on the department record show an embedded table of the employees. Then put a button on the department record to create the department day record. That way you're sitting on the department, you see in a better report of all the employees, and when you push the button to create the Department record that will trigger the pipeline.