Record Picker Question

Question

Hello All:I am hoping there is way to only show "Labor" Category Items/Records in the record picker when using Labor Cost Form.Similarly, "Material" Category Items/Records in record picker when using Material Cost Form.I would like to keep all these cost codes for labor, materials and subcontractors in just one table (easier to update on new projects).Any ideas how I can do this?   Always grateful for insight and help.Dirk
------------------------------Dirk Ruana------------------------------

MarkShnierYou · Answer

When you have a relationship, the form will default to using the default record picker fields as specified in the Advanced Properties and the sort will default to the default sort for reports on that table.

But you can make a new report called Labour Cost Codes for drop down. I suggest making the report visible to no Roles as its only purpose is to serve the form. Set the filters and sort and fields you want to show, and then edit the form properties for that drop down field to use your report.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community