Forum Discussion
JoshCollins
Qrew Assistant Captain
Got it, works great! Thank you for the help!
WilliamMaughan
3 years agoQrew Member
Thanks, 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
------------------------------
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__You3 years agoQrew LegendOn 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
mark.shnier@gmail.com
------------------------------