Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
This is possible if you set up a Relationship where 1 vendor has many Projects. They will be typically connected by the field [Related Vendor] and the lookup field and "Proxy" will be Vendor name.
Then on the FORM properties on the Project record for the vendor field, you can specify the report to be used for the drop down list of vendors, and it can be a report filtered to just show Electricians.
Then on the FORM properties on the Project record for the vendor field, you can specify the report to be used for the drop down list of vendors, and it can be a report filtered to just show Electricians.
- JoshCollins9 years agoQrew Assistant CaptainThanks for the info. I've got the 1st paragraph of your reply set up properly. However, I can't seem to get the 2nd paragraph to work.
What field type should I be using? I am currently using a Text - Multiple Choice field and I do not have an option to specify the report to be used for the dropdown list when I am on the Form Elements page and looking at the field. If I view the field properties, I can select a reference field for the dropdown list (ie- Vendors-Vendor Name), but I can't specify a report. - QuickBaseCoachD9 years agoQrew CaptainRight, so you cannot filter a drop down report when you have a simply mutiliple choice field.
You will need to set up a Relationships where 1 Vendor has many Projects. Set the proxy field for the field Related Vendor to be the Vendor Name. You set that on the field properties for the field Related Vendor.
This assumes that you have a table of Vendors and the Key field is still the Record ID# field.
Then put the field for vendor on the form. The form will let you select a report to use for the drop down, so use a report with the Electrician filter.. - JoshCollins9 years agoQrew Assistant CaptainOk...got it. I have it working.
HOWEVER- I need to have numerous fields that have the same functionality, but use different "filters" or "reports."
For instance, I have one field to select a related electrician, another to select a related plumber, and another to select a related HVAC contractor.
Is this possible? - QuickBaseCoachD9 years agoQrew CaptainYes, each one will be a new relationship, and then and then each will have its own drop down and it own drop down report filers. Tip: if you copy the field Related Vendor it will also duplicate the relationship for you. Saves a click or three.
- JoshCollins9 years agoQrew Assistant CaptainGot it, works great! Thank you for the help!
- WilliamMaughan5 years agoQrew MemberThanks, I had the same requirement for my form and this worked great. I display the dropdown based on a report that has some additional filtering criteria.
I am unable to figure out how to do the same filtering in a REPORT. I am able to show the dropdown values based on a selection from another field, but I would like to filter further, similar to what I am doing in the Form (e.g, filter out where amt = 0). Can this be done in a report as well? I can not find the option to display values based on a report.
thanks
- Bill
------------------------------
William Maughan
------------------------------- MarkShnier__You5 years ago
Qrew Legend
On the form properties, the default is to use the record picker for the drop-down list. This will respect a conditional drop-down but if you want to introduce additional filtering onto the drop-down choices then you need to change it from using the standard record picker to a report of your choosing. So you would create a report which is filtered with the additional criteria and then set the form property to use that report for the drop-down list.So if I understand your question above the effect of that is that the conditional drop down would do part of the filtering and then the report filter itself would do more filtering.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------