Formulas
Hello, Could anyone help me out to find the formula to display the Supervisor role employees alone in the Supervisor dropdown? I have an employee table with Role field, So I need to filter out only ...
Forum Discussion
If you have a relationship where 1 Employee has Many records, then this is easy.
Just make a report of employees called Used on Records Form for Supervisors drop down and filter the report where the Role equals Supervisor.
Then go to your form and for the drop down field set the form to use that report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Just make a report of employees called Used on Records Form for Supervisors drop down and filter the report where the Role equals Supervisor.
Then go to your form and for the drop down field set the form to use that report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Hello Mark,
I have a one to many relationships with task table
------Original Message------
If you have a relationship where 1 Employee has Many records, then this is easy.
Just make a report of employees called Used on Records Form for Supervisors drop down and filter the report where the Role equals Supervisor.
Then go to your form and for the drop down field set the form to use that report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Please describe your relevant tables and there relationships. I thought you had a drop down field on a record up choose a supervisor.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
