Record Picker 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 whe...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen 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
------------------------------
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
------------------------------
Hey Mark:
Not sure I am following your suggestion. I can't eliminate the relationship.
A little confused.
Sorry,
Dirk
------------------------------
Dirk Ruana
------------------------------
Not sure I am following your suggestion. I can't eliminate the relationship.
A little confused.
Sorry,
Dirk
------------------------------
Dirk Ruana
------------------------------
- Hi Mark
I was hoping this could be accomplished with "Custom Data Rules."
But not having any luck.
Dirk
------------------------------
Dirk Ruana
------------------------------- MarkShnier__YouCustom 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. 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- I guess I know how to make a report that just shows Labor Phase codes, but I can't figure out how to incorporate into record picker?
Do you create a Relationship between the report and the Labor Cost form? I thought you could only do that with tables?
Sorry for the confusion.
Dirk
------------------------------
Dirk Ruana
------------------------------