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?&nbsp;&nbsp; Always grateful for insight and help.Dirk
------------------------------Dirk Ruana------------------------------

markshnier__you · 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
------------------------------

markshnier__you · Answer

Custom Data rules are something completely different and are used to validate data or block the save if the data is invalid.I was not suggesting that you delete the relationship.&nbsp; Your question seemed to me to be saying that when selecting a labor cost code, you only want to see cost codes which are labor.So make a report of the cost codes that are just for Labor and then set the form to use that report for the drop down list for that cost code table.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

dirkruana · Answer

Mark:Worked like a charm.&nbsp; Quickbase does so much, its like trying to drink from a fire hose at times.Thank you for clear and insightful direction.Sincerely,Dirk------------------------------Dirk Ruana------------------------------

dirkruana · Answer

Hey Mark:Not sure I am following your suggestion.&nbsp; I can't eliminate the relationship.A little confused.Sorry,Dirk------------------------------Dirk Ruana------------------------------

dirkruana · Answer

Hi MarkI was hoping this could be accomplished with "Custom Data Rules." But not having any luck.Dirk------------------------------Dirk Ruana------------------------------

Forum Discussion

Record Picker Question

Related Content

Form Rule Question

Jinja Question: Adding business days to today

Chart Question

Record Picker in Grid Edit

Filtering Record Picker